In: Finance
Tall Trees, Inc. is using the modified internal rate of return (MIRR) when evaluating projects. The company is able to reinvest cash flows received from the project at an annual rate of 12.04 percent. What is the MIRR of a project if the initial costs are $1,680,000 and the project life is estimated as 7 years? The project will produce the same after-tax cash inflows of 474,700 per year at the end of the year. Round the answer to two decimal places in percentage form.
Year | Cash flow |
0 | -$1,680,000 |
1 | 474,700 |
2 | 474,700 |
3 | 474,700 |
4 | 474,700 |
5 | 474,700 |
6 | 474,700 |
7 | 474,700 |
Annual rate | 12.04% |
MIRR | 16.16% |
Excel formulas: