Find the Modified Internal Rate of Return (MIRR) for the following annual series of cash flows, given a discount rate of 10.50%: Year 0: -$75,000; Year 1: $15,000; Year 2: $16,000; Year 3: $17,000; Year 4: $17,500; and, Year 5: $18,000
A) About 6.35%
B) About 6.88%
C) About 7.35%
D) About 7.88%
Answer: A
Explanation: A) Step One. Find the future values of all the cash inflow by reinvesting the cash inflow at the appropriate cost of capital. FV = $15,000 × (1.1050)4 + $16,000 × (1.1050)3 + $17,000 × (1.1050)2 + $17,500 × (1.1050)1 + $18,000 × (1.1050)0 = $22,363.53 + $21,587.72 + $20,757.43 + $19,337.50 + $18,000.00. Summing these we get: FV = $102,046.18.
Step Two. Find the present value of the cash outflow by discounting at the appropriate cost of capital. This is the initial cash outflow of $75,000 because all investment is made at the start of the project. Expressing the cash outflow in absolute terms: PV= $75,000.
Step Three. Find the interest rate that equates the present value of the cash outflow with the future value of the cash inflow given as: MIRR = (FV / PV)n - 1 = ($102,046.18 / $75,000)1/5 - 1 = (1.360616)1/5 - 1 = 1.063524 - 1 = 0.063524 or about 6.35%.
You might also like to view...
Which type of financial statement shows how every category of expense was allocated?
A. activities B. cash flows C. financial position D. functional expenses
When a business constructs a new building, the cost of the building should include the insurance on the building during the period of construction
Indicate whether the statement is true or false
States will permit younger persons to be married if they have the consent of their parents or if they are emancipated from their parents
Indicate whether the statement is true or false
If an older client wishes to name her only adult son as the person who can make medical care decisions for her, that client should execute:
A) a will. B) a health care directive. C) a trust. D) a resulting trust.