In: Finance
How do I calculate EPS for the following years with the current information I have.
| Price | 52.47 | Year | |||
| EPS | 2.51 | 2018 | ?? | ||
| Current P/E | 20.9 | 2019 | ?? | ||
| Current Year | 2017 | 2020 | ?? | ||
| Projected Growth | 10.00% | 2021 | ?? | ||
| Average P/E | 23 | 2022 | ?? | ||
| Dividend Payout | 29.00% | 2023 | ?? | ||
| Target Price | ?? | 2024 | ?? | ||
| E(Rate of Return) | ?? | 2025 | ?? | ||
| Price<20% Target | ?? | 2026 | ?? | ||
| 2027 | ?? | ||||
| Total | ?? |
Multiply 2.51*(1+growth rate) to find the EPS for 2018
2018 EPS=2.51*(1+10%)=2.761
2019 EPS=2018 EPS*(1+10%)=2.761*(1+10%)=3.037 and goes on like that
| Year | EPS |
| 2018 | 2.761 |
| 2019 | 3.037 |
| 2020 | 3.341 |
| 2021 | 3.675 |
| 2022 | 4.042 |
| 2023 | 4.447 |
| 2024 | 4.891 |
| 2025 | 5.380 |
| 2026 | 5.918 |
| 2027 | 6.510 |