In: Accounting
(In millions), my 1st year OCF = .5107, 2nd year = .6740, 3rd year = .811, 4th year = .795, and 5th year = .632. In the 4th year I will donate $400,000 (.4) to charity and in the 5th year I will donate $200,000 (.2). My initial investment was $500,000 (.5). I will issue 1 personal bond with coupon rate of 5.74% and five years until maturity. Bond price on issue date is $978.50. The personal bond has a maturity value of $100,000. I also will issue 1 share with a dividend in one year of $5.29. Expected growth is 4.9% per year. They are willing to pay $68.36 per share of equity. Using the financial calculator, calculate NPV. Compute and Draw the NPV-IRR profile.
1 | 2 | 3 | 4 | 5 | |||
Initial Investment | (0.5000) | ||||||
Operating Cash Flow | 0.5107 | 0.6740 | 0.8110 | 0.7950 | 0.6320 | ||
Expected Outflow | (0.4000) | (0.2000) | |||||
Total Cash Inflow/ (Outflow) | (0.5000) | 0.5107 | 0.6740 | 0.8110 | 0.3950 | 0.4320 | |
Present Value factor 9.4% | 1 | 0.914 | 0.836 | 0.764 | 0.698 | 0.638 | |
Present value | (0.5000) | 0.4668 | 0.5632 | 0.6194 | 0.2758 | 0.2757 | 1.7008 |
IRR | 113% | ||||||
Costs of Debt | 6.25% | 0.5 | 0.03125 | ||||
Costs of Equity | 12.64% | 0.5 | 0.063192 | ||||
9% | |||||||
Costs of Debt | |||||||
PV | 97800 | ||||||
FV | 100000 | ||||||
I/Y ( Calcuated) | 6.25% | ||||||
N | 5 | ||||||
PMT | 5740 | ||||||
Costs of Equity r= D1/P0+g | 5.29/$68.36+4.9 = | 12.64% | |||||