2006A | 2007F | 2008F | 2009F | 2010F | 2011F | 2012F | |||
Sales | 20,48,947 | 24,79,226 | 29,25,487 | 33,64,310 | 38,68,957 | 44,49,300 | |||
NOPAT (A) | 3,89,300 | 4,71,053 | 5,55,843 | 6,39,219 | 7,35,102 | 8,45,367 | |||
Book Value of Common Equity | 19,91,985 | 23,00,882 | 26,57,686 | 30,67,298 | 35,30,964 | 40,64,465 | 46,78,300 | ||
Beginning BV of Common Equity | 19,91,985 | 23,00,882 | 26,57,686 | 30,67,298 | 35,30,964 | 40,64,465 | |||
(Beginning BV of Equity) X (Cost of Equity) (B) | 2,19,118 | 2,53,097 | 2,92,345 | 3,37,403 | 3,88,406 | 4,47,091 | |||
Residual Income (A-B) | 1,70,182 | 2,17,956 | 2,63,498 | 3,01,816 | 3,46,696 | 3,98,276 | |||
Cost of capital and discount factor (C) | 1.107 | 1.226 | 1.358 | 1.503 | 1.664 | 1.843 | |||
Present Value of Residual Income (A-B) / C | 1,53,732 | 1,77,778 | 1,94,034 | 2,00,809 | 2,08,351 | 2,16,102 | |||
Return on Common Equity: | |||||||||
Cost of Equity: | 11% | ||||||||
Present Value of Equity Calculations: | |||||||||
Current Value of Common Equity: | 19,91,985 | ||||||||
Sum of PV of Residual Income: | 11,50,806 | ||||||||
Terminal Growth Rate: | 2.05% | ||||||||
Estimated Year 6 NOPAT | 8,45,367 | ||||||||
Residual Income Terminal Value: | 40,10,185 | =(8,45,367*1.0205) - (46,78,300 * 11.0%) / (10.73%-2.05%) | |||||||
PV of Res. Inc. Terminal Value: | 21,75,900 | =40,10,185/1.843 | |||||||
Present Value of Equity: | 53,18,692 | =19,91,985 + 11,50,805 + 21,75,900 | |||||||
Shares Outstanding: | 7,71,781 | ||||||||
Share Price: | 6.89 | =53,18,692 / 7,71,781 |
Question 3. 5 Marks Use the residual income valuation model and the forecasts and the other...
Estimating Share Value Using the DCF Model Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018 Reported Horizon Period $ millions 2018 2019 2020 2021 2022 Terminal Period Sales $14,768 $15,654 $16,593 $17,589 $18,664 $19,017 NOPAT 2.711 2,880 3,053 3,236 3,430 3,499 NOA 9,462 10.028 10,630 11,268 11,944 12.183 Answer the following requirements assuming a discount rate (WACC) of 7.35%, a terminal period growth...
Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 30, 2016 Reported Horizon Period Terminal $ millions 2016 Period 2017 2018 2019 2020 Sales $73,785 $75,261 $76,766 $78,301 $79,867 $80,666 3,630 NOPAT 3,312 3,387 3,454 3,524 3,594 23,443 NOA 21,445 21,872 22,309 22,755 23,210 Answer the following requirements assuming a terminal period growth rate of 1%, a discount rate (WACC) of...