In: Accounting
1. At the beginning of its fiscal year 2020, an analyst made the following forecast for Greenfield, Inc. (in millions of dollars):
2020 |
2021 |
2022 |
2023 |
|
Cash flow from operation |
$1,234 |
$2,568 |
$3,755 |
$2,100 |
Cash investment |
428 |
489 |
502 |
756 |
Greenfield has a net debt of $1,950 at the end of 2019. Assume that free cash flow will grow at 4 percent per year in 2024 and 2025, after that this will grow at 5 percent per year. Greenfield had 425 million shares outstanding at the end of 2019, trading at $72.5 per share. Using a required return of 9 percent, calculate the following for Greenfield at the beginning of 2020 (You have to fill in the table below, and also show your working process):
[5 marks]
[2 mark]
[1 mark]
[1 mark]
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
||
Cash flow from operation |
|||||||
Cash investment |
|||||||
Free cash flow |
|||||||
Discount rate |
|||||||
PV of FCF |
|||||||
Total PV till 2023 |
|||||||
Continuing value (CV) |
|||||||
PV of CV |
($ in millions) | |||||||||||
Particulars | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 Onwards | Total | |||
Cashflow from operation | 1,234 | 2,568 | 3,755 | 2,100 | 9,657 | ||||||
Cash investment | -428 | -489 | -502 | -756 | -2,175 | ||||||
Free Cash Flow | 806 | 2,079 | 3,253 | 1,344 | 1,398 | 1,454 | 1,526 | 11,860 | |||
PV of FCF @ 9% | 0.92 | 0.84 | 0.77 | 0.71 | 0.65 | 0.60 | 25.00 | PV for 2026 onward =1/(0.09-0.05) | |||
Total PV till 2023 (PV * FCF) | 739 | 1,750 | 2,512 | 952 | 5,953 | ||||||
Continuing Value (CV) | 1,398 | 1,454 | 1,526 | 4,378 | |||||||
PV of CV (CV*PV) | 908 | 867 | 38,159 | 39,934 | |||||||
Total PV as on 2020 (beg.) | 739 | 1,750 | 2,512 | 952 | 908 | 867 | 38,159 | 45,887 | |||
* Free cash flow growth @ 4% for during 2024, 2025 and @ 5% during 2026. | |||||||||||
$ | |||||||||||
So, Enterprises Value | 45,887 | ||||||||||
Equity Value (Enterprises values less debt value) | 43,937 | ||||||||||
Equity Value per share (Equity Value/No. of shares) | 103.38 | ||||||||||
Yes, investor should buy at $ 72.5 as value is higher | |||||||||||
as per above calculation | |||||||||||