Question

In: Finance

Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 –...

Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 – 3,580 Required: The company uses an interest rate of 12 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) MIRR Discounting approach % Reinvestment approach % Combination approach %

Solutions

Expert Solution

Discounting Approach
All negative cash flows are discounted back to the present at the required return and added to the initial cost
Thus year 0 modified cash flow=-15900-2031.39
=-17931.39
Year 0 1 2 3 4 5
Cash flow stream -15900.000 7930.000 9490.000 8970.000 7210.000 -3580.000
Discounting factor (Using discount rate) 1.000 1.120 1.254 1.405 1.574 1.762
Discounted cash flows -15900.000 7080.357 7565.370 6384.669 4582.085 -2031.388
Modified cash flow -17931.388 7930.000 9490.000 8970.000 7210.000 0.000
Discounting factor (using MIRR) 1.000 1.313 1.724 2.264 2.973 3.903
Discounted cash flows -17931.388 6039.348 5504.272 3962.260 2425.508 0.000
NPV = Sum of discounted cash flows
NPV Reinvestment rate = 0.00
MIRR is the rate at which NPV = 0
MIRR= 31.31%
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
Reinvestment Approach
All cash flows except the first are compounded to the last time period and IRR is calculated
Thus year 5 modified cash flow=(12478.01)+(13332.77)+(11251.97)+(8075.2)+(-3580)
=41557.95
Discount rate 12.000%
Year 0 1 2 3 4 5
Cash flow stream -15900.000 7930.000 9490.000 8970.000 7210.000 -3580.000
Compound factor 1.000 1.574 1.405 1.254 1.120 1.000
Compounded cash flows -15900.000 12478.01 13332.77 11251.97 8075.2 -3580
Modified cash flow -15900.000 0 0 0 0 41557.950
Discounting factor (using MIRR) 1.000 1.212 1.469 1.780 2.157 2.614
Discounted cash flows -15900.000 0.000 0.000 0.000 0.000 15900.001
NPV = Sum of discounted cash flows
NPV Discount rate = 0.00
MIRR is the rate at which NPV = 0
MIRR= 21.19%
Where
Compounding factor = (1 + reinvestment rate)^(time of last CF-Corresponding period in years)
compounded Cashflow= Cash flow stream*compounding factor
Combination approach
All negative cash flows are discounted back to the present and all positive cash flows are compounded out to the end of the project’s life
Thus year 5 modified cash flow=(12478.01)+(13332.77)+(11251.97)+(8075.2)
=45137.95
Thus year 0 modified cash flow=-15900-2031.39
=-17931.39
Discount rate 12.000%
Year 0 1 2 3 4 5
Cash flow stream -15900.000 7930.000 9490.000 8970.000 7210.000 -3580.000
Discount factor 1.000 1.120 1.254 1.405 1.574 1.762
Compound factor 1.000 1.574 1.405 1.254 1.120 1.000
Discounted cash flows -15900.000 0 0 0 0 -2031.39
Compounded cash flows 0.000 12478.01 13332.77 11251.97 8075.2 0
Modified cash flow -17931.390 0 0 0 0 45137.950
Discounting factor (using MIRR) 1.000 1.203 1.447 1.740 2.093 2.517
Discounted cash flows -17931.390 0.000 0.000 0.000 0.000 17931.390
NPV = Sum of discounted cash flows
NPV= 0.00
MIRR is the rate at which NPV = 0
MIRR= 20.28%
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
Compounding factor = (1 + reinvestment rate)^(time of last CF-Corresponding period in years)
Compounded Cashflow= Cash flow stream*compounding factor

Related Solutions

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5
  Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10 percent? Add an outflow (or cost) of $1,000 at Year 0. What is the present value (or net present value) of the stream?
Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5...
Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 Revenues Cash Costs Set up $280,000.00 $420,000.00 $280,000.00 $140,000.00 $140,000.00 Other operating $240,000.00 $240,000.00 $360,000.00 $360,000.00 $240,000.00 Depreciation $280,000.00 $280,000.00 $280,000.00 EBIT -$200,000.00 $140,000.00 $130,000.00 $250,000.00 $190,000.00 Taxes -$70,000.00 $49,000.00 $45,500.00 $87,500.00 $66,500.00 Net Operating Income After Taxes -$130,000.00 $91,000.00 $84,500.00 $162,500.00 $123,500.00 Add Depreciation $280,000.00 $280,000.00 $280,000.00 Net Operating Cash Flows $150,000.00 $371,000.00 $364,500.00 $162,500.00 $123,500.00 Recovery of...
Investment A: Year: 0 1 2 3 4 5 Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000...
Investment A: Year: 0 1 2 3 4 5 Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000 $6,000 Investment B: Year: 0 1 2 3 4 5 Cash flow: -$15,000 $7,000 $7,000 $7,000 $7,000 $7,000 Investment C: Year: 0 1 2 3 4 5 Cash flow: -$18,000 $12,000 $4,000 $4,000 $4,000 $4,000 The cash flows for three projects are shown above. The cost of capital is 7.5%. If an investor decided to take projects with a payback period two years or...
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ?...
Year Cash flow (€) 0 - Investment -? 1 150,000 2 150,000 3 4 150,000 ? Some years ago X AG paid €15’000 for a vacant lot with planning permission. The plot could easily be sold today for 10 times that amount. X AG has however a project in mind that would occupy the plot and require investment of €200,000 but generate positive cash flows of €150,000 for the next 4 years. X AG will be able to sell the...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash...
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash flow -$12,300 $4000 $4000 $3000 $3000 $3000 14.21% 12.75% 13.11% 13.85%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT