Question

1. What's the internal rate of return of the following cash flows with a 8% WACC?...

1. What's the internal rate of return of the following cash flows with a 8% WACC?

2. What's the modified internal rate of return of the following cash flows with a 8% WACC?

Year 0 = 100,000

Year 1 = 10,000

Year 2 = 50,000

Year 3 = 45,000

Year 4 = 25,000

3. How long should a company keep the following project?

WACC = 8%

CF year 0 = 1,500,000

Salvage = 1,500,000

CF year 1 = 750,000

Salvage = 1,250,000

CF year 2 = 600,000

Salvage - 425,000

CF year 3 = 800,000

Salvage = 0.00

Homework Answers

Answer #1

Formulas used:-

IRR =IRR(C4:C8)
MIRR =MIRR(C4:C8,B2,B2)
Value of the project if Disposed off in Year 1 =PV(8%,1,-750000,-1250000)-1500000
Value of the project if Disposed off in Year 2 =1025000/(1.08)^2+750000/1.08-1500000
Value of the project if Disposed off in Year 3 =800000/1.08^3+600000/1.08^2+750000/1.08-1500000
We should Disposed it Off in Year 1
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
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
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....
Find the modified internal rate of return for the following annual series of cash flows: given...
Find the modified internal rate of return for the following annual series of cash flows: given a discounted rate of 10.50%: year 0 - 60,000$: year 1: 15,000$, Year 2: 16,000$, Year 3:17,000$ and year 4: 17,00$
Fernando Designs is considering a project that has the following cash flows and WACC data. What...
Fernando Designs is considering a project that has the following cash flows and WACC data. What is the project's discounted payback period? (10 points) What is the project’s modified internal rate of return? WACC: 10.00% Year                                 0                1                2                3     Cash flows                    -$900         $500          $500          $500
Given the following end of year cash flows (CF) estimate the internal rate of return (IRR)...
Given the following end of year cash flows (CF) estimate the internal rate of return (IRR) of this project. If the project’s cost of capital is 10%, would you undertake this project? Timeline 0 1 2 3 4 CF 0 700 700 700 -3,000 Group of answer choices No; IRR = 18.93% Yes; IRR = 18.93% No; IRR = 7.50% Yes, IRR is greater than the cost of capital
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....
A project has the following cash flows. What is the internal rate of return?                Year             ...
A project has the following cash flows. What is the internal rate of return?                Year                 0                      1                        2                     3                Cash flow     -$782,100        $219,500             $348,600           $348,600
Find the modified internal rate of return (MIRR) for the following series of future cash flows...
Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 13.72 percent.The initial outlay is $470,600. Year 1: $185,900 Year 2: $185,100 Year 3: $125,700 Year 4: $183,400 Year 5: $184,100 Round the answer to two decimal places in percentage form. How do I do this in excel?
Find the modified internal rate of return (MIRR) for the following series of future cash flows...
Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 12.92 percent. the initial outlay is $439,500. Year 1: $130,600 year 2: 178,600 year3: 147,800 Year 4: 133,600 Year 5: 155,700 Round answer to two decimal places.
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • A car makes a trip along a straight line without changing direction. The average speed of...
    asked 3 minutes ago
  • What were the major differences during the reconstruction era between the northern and southern parts of...
    asked 8 minutes ago
  • A group of researchers want to determine whether the order in which items are presented influences...
    asked 10 minutes ago
  • A scientist wishes to perform the Stern-Gerlach experiment to separate silver atoms at least 1cm (greater...
    asked 13 minutes ago
  • You are conducting a study to see if the mean doctor's salary (in thousands of dollars)...
    asked 20 minutes ago
  • 70% of the students applying to a university are accepted. Assume the requirements for a binomial...
    asked 31 minutes ago
  • Problem 9-24 Comprehensive Variance Analysis [LO9-4, LO9-5, LO9-6] Marvel Parts, Inc., manufactures auto accessories. One of...
    asked 35 minutes ago
  • please answer the following question: Debate the two approaches from business and technology perspective. A “keep...
    asked 38 minutes ago
  • I need a solution of this structural dynamics problem? A mass with mass 1 is attached...
    asked 38 minutes ago
  • According to a recent study1, it takes between 5.6 and 10.2 million joules of energy to...
    asked 44 minutes ago
  • A regression analysis has been conducted between the annual income (in 1000 euros) and the work...
    asked 52 minutes ago
  • Statistics EXERCISE 4. Dave’s Automatic Door installs automatic garage door openers. The following list indicates the...
    asked 1 hour ago