Question

If your required rate of return is 7%, calculate the MIRR of a project with the...

  1. If your required rate of return is 7%, calculate the MIRR of a project with the following expected cashflows (in thousands):- (8)

Time

0

1

2

3

4

5

Cashflow

-130

60

70

-60

50

50

Homework Answers

Answer #1

Future value = Present value (1 + rate)^time

Future value of year 1 cash flow = 60 (1 + 0.07)^4 = 78.64776

Future value of year 2 cash flow = 70 (1 + 0.07)^3 = 85.75301

Future value of year 4 cash flow = 50 (1 + 0.07)^1 = 53.5

Future value of year 5 cash flow = 50 (1 + 0.07)^0 = 50

Future value of cash inflow = 78.64776 + 85.75301 + 53.5 + 50 = $267.90077

Present value of cash outflow = Future value / (1 + rate)^time

Present value of cash outflow = 60 / (1 + 0.07)^3

Present value of cash outflow = 60 / 1.22504

Present value of cash outflow = $48.97787

Total cash outflow = 130 + 48.97787 = 178.97787

MIRR = (Future value / initial investment)^1/n - 1

MIRR = (267.90077 / 178.97787)^1/5 - 1

MIRR = (1.49684)^1/5 - 1

MIRR = 1.0840 - 1

MIRR = 0.0840 or 8.40%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Your company is considering a project which has the expected cash flows as follows. year 0...
Your company is considering a project which has the expected cash flows as follows. year 0 1 2 3 4 5 6 7 8 9 10 cash flow -500 90 100 150 180 190 140 100 80 60 -50 The required return for the project is 15% per annum. (1) What is the NPV? (2) What are 2 IRRs? (3) Draw the NPV profile (4) What are the MIRR? (5) Should your company take this project?
28. What is the modified internal rate of return (MIRR) for the following project? The cost...
28. What is the modified internal rate of return (MIRR) for the following project? The cost of capital is 10%. Time 0 1 2 3 Project A -$350 $300 -$100 $200 a. 10.35% b. 9.18% c. 10.25% d. 8.50% 31. Simkins Renovations Inc. is considering a project that has the following cash flow data. What is the project's IRR? Year 0 1 2 3 4 Cash flows -$825 $296 $285 $300 $320 a. 16.65% b. 14.61% c. 17.24% d. 13.59%
Calculate NPV, payback period and IRR for the following project given a required return of 10%:...
Calculate NPV, payback period and IRR for the following project given a required return of 10%: Project z Time 0 1 2 3 4 5 Cash Flow -11,000 6,230 4,120 1,530 3,500 990
A project has the following forecasted cash flows: Cash Flows Thousands of dollars C0 C1 C2...
A project has the following forecasted cash flows: Cash Flows Thousands of dollars C0 C1 C2 C3 -100 40 60 50 The investor expected rate of return is 10%. The cost of capital is 12%. Required: 1.What will you choose to be the discount rate? Why? 2.Please calculate the payback period (PP) and return on investment (ROI). 3.Please calculate NPV,PVI and IRR.. 4.Make decision based on the above calculation and explain the reasons. 5.David said that the profit is the...
What is the Modified Internal Rate of Return (MIRR) for the following cash flows? Assume that...
What is the Modified Internal Rate of Return (MIRR) for the following cash flows? Assume that the required rate of return is 4% Year CFs 0 -1,000 1 100 2 200 3 350 4 800
Cashflow patterns and the modified rate of return calculation Sharp Manufacturing Inc. is analyzing a project...
Cashflow patterns and the modified rate of return calculation Sharp Manufacturing Inc. is analyzing a project with the following projected cash flows: Year Cash Flow 0 - $1,324,800 1 300,000 2 450,000 3 546,000 4 360,000 This project exhibits   cash flows. Sharp’s desired rate of return is 7.00%. Given the cash flows expected from the company's new project, compute the project’s anticipated modified internal rate of return (MIRR). (Hint: Round all dollar amounts to the nearest whole dollar, and your...
Problem 9-20 MIRR [LO6] RAK Corp. is evaluating a project with the following cash flows:   ...
Problem 9-20 MIRR [LO6] RAK 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 a discount rate of 12 percent and a reinvestment rate of 7 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...
8. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...
8. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR. Consider the following situation : Cute Camel Woodcraft Company is analyzing a project that requires an initial investment of $3,225,000....
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the...
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Fuzzy Button Clothing Company is analyzing a project that requires an initial investment of $500,000. The project’s...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Green Caterpillar Garden Supplies Inc. is analyzing a project that requires an initial investment of $2,500,000....