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

1 Expert Approved Answer
Step: 1 Unlock

These two measures of investment profitability make dif... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

249-B-M-L-P (557).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!