In: Finance
DYI Construction Co. is considering a new inventory system that will cost $750,000. The system is expected to generate positive cash flows over the next four years in the amounts of $350,000 in year one, $325,000 in year two, $150,000 in year three, and $180,000 in year four. DYI's required rate of return is 10%. What is the modified internal rate of return of this project?
| Computation of MIRR | |||||||
| Year | Cash flow | ||||||
| 0 | (750,000.0) | ||||||
| 1 | 350,000.0 | ||||||
| 2 | 325,000.0 | ||||||
| 3 | 150,000.0 | ||||||
| 4 | 180,000.0 | ||||||
| we have to first compute the future value of the cash flow from year 1 to 4 for project | |||||||
| Year | project L | Future value | |||||
| 1 | 350,000.0 | 465850 | 350000*(1+10%)^3 | ||||
| 2 | 325,000.0 | 393250 | 325000*(1+10%)^2 | ||||
| 3 | 150,000.0 | 165000 | 150000*(1+10%) | ||||
| 4 | 180,000.0 | 180000 | 180000 | ||||
| future value | 1204100 | ||||||
| now we have to use financial calculator to compute the MIRR | |||||||
| Put in calcluator | |||||||
| PV | (750,000.0) | ||||||
| PMT | 0 | ||||||
| FV | 1204100 | ||||||
| N | 4 | ||||||
| Compute I | 12.56% | ||||||
| MIRR = | 12.56% |