Question

In: Finance

Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$30,000...

Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$30,000 1 12,200 2 14,900 3 16,800 4 13,900 5 –10,400

The company uses an interest rate of 8 percent on all of its projects.

Calculate the MIRR of the project using all three methods. a. MIRR using the discounting approach.

b. MIRR using the reinvestment approach.

c. MIRR using the combination approach.

Solutions

Expert Solution

a

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=-30000-7078.07
=-37078.07
Year 0 1 2 3 4 5
Cash flow stream -30000.000 12200.000 14900.000 16800.000 13900.000 -10400.000
Discounting factor (Using discount rate) 1.000 1.080 1.166 1.260 1.360 1.469
Discounted cash flows -30000.000 11296.296 12774.348 13336.382 10216.915 -7078.065
Modified cash flow -37078.065 12200.000 14900.000 16800.000 13900.000 0.000
Discounting factor (using MIRR) 1.000 1.198 1.435 1.720 2.060 2.469
Discounted cash flows -37078.065 10182.873 10380.238 9768.791 6746.163 0.000
NPV = Sum of discounted cash flows
NPV Reinvestment rate = 0.00
MIRR is the rate at which NPV = 0
MIRR= 19.81%
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
b
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=(16597.97)+(18769.71)+(19595.52)+(15012)+(-10400)
=59575.2
Discount rate 8.000%
Year 0 1 2 3 4 5
Cash flow stream -30000.000 12200.000 14900.000 16800.000 13900.000 -10400.000
Compound factor 1.000 1.360 1.260 1.166 1.080 1.000
Compounded cash flows -30000.000 16597.97 18769.71 19595.52 15012 -10400
Modified cash flow -30000.000 0 0 0 0 59575.200
Discounting factor (using MIRR) 1.000 1.147 1.316 1.509 1.731 1.986
Discounted cash flows -30000.000 0.000 0.000 0.000 0.000 30000.000
NPV = Sum of discounted cash flows
NPV Discount rate = 0.00
MIRR is the rate at which NPV = 0
MIRR= 14.71%
Where
Compounding factor = (1 + reinvestment rate)^(time of last CF-Corresponding period in years)
compounded Cashflow= Cash flow stream*compounding factor
c
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=(16597.97)+(18769.71)+(19595.52)+(15012)
=69975.2
Thus year 0 modified cash flow=-30000-7078.07
=-37078.07
Discount rate 8.000%
Year 0 1 2 3 4 5
Cash flow stream -30000.000 12200.000 14900.000 16800.000 13900.000 -10400.000
Discount factor 1.000 1.080 1.166 1.260 1.360 1.469
Compound factor 1.000 1.360 1.260 1.166 1.080 1.000
Discounted cash flows -30000.000 0 0 0 0 -7078.07
Compounded cash flows 0.000 16597.97 18769.71 19595.52 15012 0
Modified cash flow -37078.070 0 0 0 0 69975.200
Discounting factor (using MIRR) 1.000 1.135 1.289 1.464 1.662 1.887
Discounted cash flows -37078.070 0.000 0.000 0.000 0.000 37078.070
NPV = Sum of discounted cash flows
NPV= 0.00
MIRR is the rate at which NPV = 0
MIRR= 13.54%
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

Solo Corp. is evaluating a project with the following cash flows: Year 0 Cash Flow –$...
Solo Corp. is evaluating a project with the following cash flows: Year 0 Cash Flow –$ 29,100 Year 1 Cash Flow $11,300 Year 2 Cash Flow $14,000 Year 3 Cash Flow $15,900 Year 4 Cash Flow $13,000 Year 5 Cash Flow $– 9,500 The company uses an interest rate of 8 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach. b. Calculate the MIRR of the project using the reinvestment approach. c....
Solo Corp. is evaluating a project with the following cash flows: Year 0 Cash Flow –$...
Solo Corp. is evaluating a project with the following cash flows: Year 0 Cash Flow –$ 28,900 Year 1 Cash Flow $11,100 Year 2 Cash Flow $13,800 Year 3 Cash Flow $15,700 Year 4 Cash Flow $12,800 Year 5 Cash Flow $– 9,300 The company uses a discount rate of 13 percent and a reinvestment rate of 6 percent on all of its projects. a.)Calculate the MIRR of the project using the discounting approach. b.) Calculate the MIRR of the...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 29,200 1 11,400 2 14,100 3 16,000 4 13,100 5 – 9,600 The company uses an interest rate of 9 percent on all of its projects. 1. Calculate the MIRR of the project using the discounting approach. 2. Calculate the MIRR of the project using the reinvestment approach. 3. Calculate the MIRR of the project using the combination approach. Reinvestment rate not given.
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 29,500 1 11,700 2 14,400 3 16,300 4 13,400 5 – 9,900 The company uses a discount rate of 13 percent and a reinvestment rate of 6 percent on all of its projects. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Calculate the MIRR...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 28,900 1 11,100 2 13,800 3 15,700 4 12,800 5 – 9,300 The company uses an interest rate of 9 percent on all of its projects - Calculate the MIRR of the project using the reinvestment approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) How do i solve with BA II PLUS? Calculate...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 28,700 1 10,900 2 13,600 3 15,500 4 12,600 5 – 9,100 The company uses an interest rate of 8 percent on all of its projects. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Calculate the MIRR of the project using the reinvestment approach....
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 28,700 1 10,900 2 13,600 3 15,500 4 12,600 5 –   9,100 The company uses an interest rate of 8 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the MIRR of the project using...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 47,000 1 16,900 2 20,300 3 25,800 4 19,600 5 – 9,500 The company uses an interest rate of 10 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach method. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. Calculate the MIRR of the project...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$ 47,000 1 16,900 2 20,300 3 25,800 4 19,600 5 – 9,500 The company uses a discount rate of 11 percent and a reinvestment rate of 8 percent on all of its projects. a. Calculate the MIRR of the project using the discounting approach method. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$13,200...
Solo Corp. is evaluating a project with the following cash flows: Year Cash Flow 0 –$13,200 Year 1 Cash Flow $6,100 Year 2 Cash Flow $6,700 Year 3 Cash Flow $6,200 Year 4 Cash Flow $5,100 Year 5 Cash Flow $–4,500 The company uses a disount rate of 11 percent and a reinvestment rate of 9 percent on all of its projects. Calculate the MIRR of the project using all three methods using these interest rates. a. MIRR using the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT