Question: Use the data in exercise 12-33 and the appropriate function in Excel to estimate both the IRR and the MIRR of the proposed investment. What
Use the data in exercise 12-33 and the appropriate function in Excel to estimate both the IRR and the MIRR of the proposed investment. What accounts for the difference in these two measures?
In exercise 12-33, Given the following attributes of an investment project with a five-year life, and an after-tax discount rate of 12 percent, calculate the net present value (NPV) and the payback period of the project: investment outlay, year 0, $5,000; after-tax cash inflows, year 1, $800; year 2, $900; year 3, $1,500; year 4, $1,800; and year 5, $3,200. (Use the built-in function of Excel to estimate the NPV of this project.)
Step by Step Solution
3.33 Rating (168 Votes )
There are 3 Steps involved in it
These two measures of investment profitability make dif... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
249-B-M-L-P (557).docx
120 KBs Word File
