A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2...

A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2 7,360 3 4,800 4 −1,640 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach?

Expert Solution

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 4 modified cash flow=(6259.97)+(8426.46)+(5136)
=19822.43
Thus year 0 modified cash flow=-11700-1251.15
=-12951.15


Discount rate	7.000%
Year	0	1	2	3	4
Cash flow stream	-11700.000	5110.000	7360.000	4800.000	-1640.000
Discount factor	1.000	1.070	1.145	1.225	1.311
Compound factor	1.000	1.225	1.145	1.070	1.000
Discounted cash flows	-11700.000	0	0	0	-1251.15
Compounded cash flows	0.000	6259.97	8426.46	5136	0
Modified cash flow	-12951.150	0	0	0	19822.430
Discounting factor (using MIRR)	1.000	1.112	1.237	1.376	1.531
Discounted cash flows	-12951.150	0.000	0.000	0.000	12951.150
NPV = Sum of discounted cash flows
NPV=	0.00
MIRR is the rate at which NPV = 0
MIRR=	11.23%
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

jeff jeffy answered 6 months ago

A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2...

A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2 7,630 3 5,040 4 −1,580 Assuming the appropriate interest rate is 10 percent, what is the MIRR for this project using the discounting approach? 19.21% 15.23% 13.96% 11.63% 17.77%

A project has the following cash flows: Year Cash Flows 0 −$127,800 1 47,000 2 63,800...

A project has the following cash flows: Year Cash Flows 0 −$127,800 1 47,000 2 63,800 3 51,600 4 28,100 The required return is 8.3 percent. What is the profitability index for this project?

1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2...

1) A project has the following cash flows: Year 0 -$22,500, Year 1 $12,650, Year 2 $10,900, and Year 3 $6,500. What is the IRR of the project? Please round your answer to two decimal places. 2) Following question 1, suppose the cost of capital is 15%. Would you accept or reject the project according to the IRR criterion? Accept or Reject 3) Following questions 1 and 2, which of the following statements about the IRR rule is false? -...

A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2...

A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2 8,100 3 6,600 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) NPV $ What is the NPV at a discount rate of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ What is the NPV...

A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2...

A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2 –27,600 What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return % What is the NPV of this project if the required return is 5 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round...

A project has the following cash flows: Year Cash Flow 0 $64,100 1 –30,100 2...

A project has the following cash flows: Year Cash Flow 0 $64,100 1 –30,100 2 –48,100 a. What is the IRR for this project? b. What is the NPV of this project, if the required return is 11.5 percent? c. NPV at 0 percent? d. NPV at 23 percent?

A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2...

A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2 7,600 3 6,100 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) NPV $ What is the NPV at a discount rate of 9 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ ...

A project has the following cash flows. What is the payback period? Year 0 1 2...

A project has the following cash flows. What is the payback period? Year 0 1 2 3 4 cash flow -$14500 $2200 $4800 $6500 $7500 A project has the following cash flows. What is the internal rate of return? Year 0 1 2 3 Cash flows -$89300 $32900 $64200 $5800 A project has the following cash flows. What is the payback period? Year 0 1 2 3 4 Cash flow -$28000 $11600 $11600 $6500 $6500 And how to solve this...

A project has the following cash flows: Year Cash Flow 0 $ 43,500 1 – ...

A project has the following cash flows: Year Cash Flow 0 $ 43,500 1 – 22,500 2 – 33,500 a. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What is the NPV of this project, if the required return is 12 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round...

Yellow Day has a project with the following cash flows: Year Cash Flows 0 −$27,000 1...

Yellow Day has a project with the following cash flows: Year Cash Flows 0 −$27,000 1 10,550 2 20,300 3 9,720 4 −3,600 What is the MIRR for this project using the reinvestment approach? The interest rate is 7 percent

Question