In: Finance
6) Refer to the capital budgeting narrative. What is the MIRR of the project?
Capital Budgeting Narrative:
(Use the following information for questions referring to the narrative): Aferine Electric is considering a new project. The initial investment required is $106,639.60 and the cost of capital is 8%. Expected cash flows over the next four years are given below:
| Years | Cash Flow ($) |
| 1 | 7,000 |
| 2 | 37,000 |
| 3 | 41,000 |
| 4 | 90,000 |
A) 17.1%
B) 13.8%
C) 14.1%
D) 15.0%
E) 8%
| Modified Internal rate of return assumes that positives cash flows are invested at the firm's cost of capital and | |||||||||
| initial outlays are financed at the firm's financing cost. | |||||||||
| In the give problem only one rate is given , hence we assume that cost of capital = cost of financing | |||||||||
| The formula to calculate MIRR is as under, | |||||||||
| MIRR = [FVCF / PVCF]^(1/n) - 1 | |||||||||
| FVCF = Future value of positive cash flows = $186254.78 | |||||||||
| PVCF = Present value of negative cash flows = $106639.60 | |||||||||
| n = no.of years = 4 | |||||||||
| Future value of positive cash flows at cost of capital of 10% is as under | |||||||||
| Year | Cash flow | Future value of factor @ 8% | Future Value | ||||||
| 1 | $7,000.00 | 1.259712 | $8,817.98 | ||||||
| 2 | $37,000.00 | 1.1664 | $43,156.80 | ||||||
| 3 | $41,000.00 | 1.08 | $44,280.00 | ||||||
| 4 | $90,000.00 | 1 | $90,000.00 | ||||||
| Future value of positive cash flow | $186,254.78 | ||||||||
| MIRR = [189187 / 106639.60]^(1/4) - 1 | |||||||||
| MIRR = 1.149601 - 1 | |||||||||
| MIRR = 0.150 | |||||||||
| MIRR = 15.0% | |||||||||
| The answer is Option D. | |||||||||