question 6

Given the following attributes of an investment project with a 5-year life and an after-tax discount rate of 11\%, calculate both the iRR and MIRR of the project: investment outlay, time 0,$2,500; after-tax cash inflows, year 1,$1,250; year 2,$1,250; year 3,$1,000; year 4 , $1,250; and year 5,$750. Use the appropriate built-in functions in Excel (IRR and MIRR) to estimate both the IRR and the MIRR of the proposed investment. (Round "IRR" and "MIRR" to 2 decimal places. (i.e. 0.1234=12.34%).)