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

Free

80.2K

Verified Solution

Question

Finance

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 appropriateinterest rate is 7 percent, what is the MIRR for this project usingthe discounting approach?

Answer & Explanation Solved by verified expert
4.4 Ratings (647 Votes)

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

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students