In: Finance
A- Project A requires an initial outlay at t = 0 of $4,000, and its cash flows are the same in Years 1 through 10. Its IRR is 16%, and its WACC is 12%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
B- Project L requires an initial outlay at t = 0 of $63,000, its expected cash inflows are $14,000 per year for 10 years, and its WACC is 12%. What is the project's payback? Round your answer to two decimal places.
C- Project L requires an initial outlay at t = 0 of $75,000, its expected cash inflows are $11,000 per year for 9 years, and its WACC is 14%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
A
| PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)] | 
| C = Cash flow per period | 
| i = interest rate | 
| n = number of payments | 
| 4000= Cash Flow*((1-(1+ 16/100)^-10)/(16/100)) | 
| Cash Flow = 827.6 | 
| Project A | |||||||||||
| Combination approach | |||||||||||
| All negative cash flows are discounted back to the present and all positive cash flows are compounded out to the end of the project’s life | |||||||||||
| Thus year 8 modified cash flow=(2295)+(2049.11)+(1829.56)+(1633.54)+(1458.51)+(1302.24)+(1162.72)+(1038.14)+(926.91)+(827.6) | |||||||||||
| =14523.33 | |||||||||||
| Thus year 0 modified cash flow=-4000 | |||||||||||
| =-4000 | |||||||||||
| Discount rate | 0.12 | ||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 
| Cash flow stream | -4000 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 827.6 | 
| Discount factor | 1 | 1.12 | 1.2544 | 1.404928 | 1.5735194 | 1.762342 | 1.973823 | 2.210681 | 2.475963 | 2.773079 | 3.105848 | 
| Compound factor | 1 | 2.773079 | 2.475963 | 2.210681 | 1.9738227 | 1.762342 | 1.573519 | 1.404928 | 1.2544 | 1.12 | 1 | 
| Discounted cash flows | -4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 
| Compounded cash flows | -0.00025 | 2295 | 2049.11 | 1829.56 | 1633.54 | 1458.51 | 1302.24 | 1162.72 | 1038.14 | 926.91 | 827.6 | 
| Modified cash flow | -4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14523.33 | 
| Discounting factor (using MIRR) | 1 | 1.137629 | 1.2942 | 1.472319 | 1.6749525 | 1.905474 | 2.167723 | 2.466064 | 2.805466 | 3.191579 | 3.630832 | 
| Discounted cash flows | -4000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4000 | 
| NPV = Sum of discounted cash flows | |||||||||||
| NPV= | 1.29919E-06 | ||||||||||
| MIRR is the rate at which NPV = 0 | |||||||||||
| MIRR= | 13.76% | ||||||||||
| Where | |||||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||||
| Compounding factor = | (1 + reinvestment rate)^(time of last CF-Corresponding period in years) | ||||||||||