You are an analyst at a large firm. The Chief Financial Officer presents the fol
ID: 2757977 • Letter: Y
Question
You are an analyst at a large firm. The Chief Financial Officer presents the following free cash flow data for ABC Corp (in millions of $).
Year Cash Flow 2010 1600 2011 2600 2012 3200 2013 3400 2014 2300
She asks you to please calculate the:
- Geometric Total Return
- The Annualized Rate of Change
Then, the director asks you to make a 10 year cash flow forecast based upon the annualized rate of growth in cash flow.
Next, she asks you to calculate the NPV of the forecasted cash flows assuming an immediate investment cost of $19.8 billion.
To estimate the weighted average cost of capital, please use the following data points.
Market Value of Debt - $580,000,000 Market Value of Equity - $1,302,000,000
Current Yield to Maturity on Debt – 5.1875% Tax Rate – 35.2%
Expected Return on Market – 11.7% Current 10 year U.S. Treasury – 4.3% Beta – 2.41
Explanation / Answer
year cash flow 2010 1600 2011 2600 2012 3200 2013 3400 2014 2300 geometric return 2532.153402 Annualized rate of return (final value/ initial value)^1/no of years - 1 1.075280006 1 0.07528 7.528000641 Percent cash flows Year 1 2473.144 0.859549596 2125.789926 2 2659.32228 0.738825508 1964.775135 3 2859.516062 0.635057167 1815.956169 4 3074.780431 0.545863131 1678.409274 5 3306.249902 0.469196434 1551.280664 6 3555.144394 0.403297605 1433.781221 7 3822.775664 0.346654294 1325.181598 8 4110.554216 0.297966558 1224.807692 9 4419.996737 0.256117035 1132.036457 10 4752.734092 0.220145294 1046.292042 sum of present value of cash flow 15298.31018 cash outflow 19800 NPV -4501.689823 current yield to maturity After tax Yield to maturity weight cost of debt debt 580000000 5.1875 3.3615 0.308183 1.035956429 equity 1302000000 22.134 22.134 0.691817 15.31268225 total capital 1882000000 Weighted average cost of capital 16.34863868 cost of equity Ke = IRF +(RM-IRF)*beta 22.134
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.