Question

In: Finance

What is the internal rate of return (IRR) on an investment with the following cash flows?...

  1. What is the internal rate of return (IRR) on an investment with the following cash flows? Holding period 5 years. Round your answer to nearest 0.25%. Please show work (NO EXCEL)
Year Net Income
Purchase Price $4,000,000
1 $250,000
2 $300,000
3 $350,000
4 $400,000
5 $450,000
Resale $4,750,000 (net of costs)

Solutions

Expert Solution

Calculation of IRR 11% 12%
Year Cash-flow PV factor, 1/(1+r)^t PV factor, 1/(1+r)^t PV@11% PV@12%
0 $       (4,000,000)           1.0000     1.0000 $(4,000,000.00) $ (4,000,000.00)
1 $            250,000           0.9009     0.8929 $     225,225.23 $      223,214.29
2 $            300,000           0.8116     0.7972 $     243,486.73 $      239,158.16
3 $            350,000           0.7312     0.7118 $     255,916.98 $      249,123.09
4 $            400,000           0.6587     0.6355 $     263,492.39 $      254,207.23
5 $            450,000           0.5935     0.5674 $     267,053.10 $      255,342.09
5 $         4,750,000           0.5935     0.5674 $ 2,818,893.81 $   2,695,277.56
NPV $       74,068.23 $       (83,677.58)
IRR =Lower rate + Difference in rates*(NPV at lower rate)/(Lower rate NPV-Higher rate NPV)
IRR '=11%+ (12%-11%)*(74068.23/(74068.23+83677.58)
IRR =11.47%
IRR =11.50%

Related Solutions

What is the internal rate of return (IRR) of this project given the following cash flows?...
What is the internal rate of return (IRR) of this project given the following cash flows? Year                 CF 0                -$9,800 1                   $1,000 2                   $4,500 3                   $1,000 4                   $1,500 5                   $1,700 6                   $2,700 Convert your answer to percentage and round off to two decimal points. Do not enter % in the answer box.
a)Compute the Internal Rate of Return (IRR) of the prospective project: Estimated cash flows are $18,200...
a)Compute the Internal Rate of Return (IRR) of the prospective project: Estimated cash flows are $18,200 at the end of every year for 6 years. Cost today is $67,000. b) Should the company accept the project if the company's cost of capital is 7%, and why or why not? Please show all work using the TI BAII Plus Calculator like the example below: Make sure that 2nd I/Y which is P/Y is set to 1.0. Make sure that 2nd PMT...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Blue Pencil Publishing: Consider the following case: Blue Pencil Publishing is evaluating a proposed capital budgeting project (project Sigma) that will requ ire an initial investment of $800,000. Blue Pencil Publishing has been basing capital budgeting decisions on a project's NPV; however, its...
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: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $550,000. The project’s expected...
4. Internal rate of return (IRR) Aa Aa The internal rate of return (IRR) refers to...
4. Internal rate of return (IRR) The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider this case: Consider the following case: Fuzzy Badger Transport Company is evaluating a proposed capital budgeting project (project Delta) that will require an initial investment of $1,500,000 Fuzzy Badger Transport Company has been basing capital budgeting decisions on a project's NPV; however, its new CFO wants to start using the...
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: Blue Llama Mining Company is analyzing a project that requires an initial investment of $3,000,000. The...
16) A project has the following cash flows. What is the internal rate of return? Year/Cash...
16) A project has the following cash flows. What is the internal rate of return? Year/Cash Flow 0/ -$89,300.00 1/ $82,900.00 2/ $4,200.00 3/ $5,800.00 A) 1.02 percent B) 6.77 percent C) 5.97 percent D) 1.11 percent E) 3.45 percent 17) A company wants to purchase a new machine costing $1.46 million. Management is estimating the machine will generate cash inflows of $223,000 the first year and $600,000 for the following four years. If management requires a minimum 12 percent...
What is the internal rate of return (IRR) of the previous project? Year Cash flow 0...
What is the internal rate of return (IRR) of the previous project? Year Cash flow 0 -$100,000 (it is minus!) 1    $20,000 2    $50,000 3    $30,000 4    $40,000 A. 13.98% B. 15.98% C. 12.98% D. 11.98% E. 14.98%
\\ Compute the internal rate of return for the cash flows of the following two projects....
\\ Compute the internal rate of return for the cash flows of the following two projects. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)      Year Project A Project B   0 –$ 6,300 –$ 3,900     1 2,400 1,400     2 3,200 2,500     3 2,000 1,600       
Discuss the concept of Internal Rate of Return (IRR). What is it and how is it...
Discuss the concept of Internal Rate of Return (IRR). What is it and how is it used by companies. What is the modified internal rate of return (MIRR)? Give an example of each.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT