Question

In: Finance

required rate of return = 15% year year cash flow ($ in millions) 0 -500 1...

required rate of return = 15%

year

year cash flow ($ in millions)
0 -500
1 90
2 100
3 150
4 180
5 190
6 140
7 100
8 80
9 60
10 -50

using excel, draw npv profile and find "two" IRRs.

There should be two IRRs. If you get two IRRs, the NPV profile graph should look like a parabola curve.

I figured out the first IRR which is 19% (19.45...% to be exact) but I can't seem to get the second one.

Solutions

Expert Solution

here we have only one IRR not two IRR.

as per NPV graph you can see we have only one IRR.

find IRR by = irr(value,guess)

value = select cash flow and lock cell by F4

guess = select guess value that can be any value

now drag irr value up to guess value , if have two irr then you will two bur here we found only two.

create different NPV with diff discount rate (by guess)

NPV = = -500+npv(rate,value)

rate= discount rate

value =select all cash flow but ignore initial -500.

lock -500 by F4 and also lock value.

now drag down you will found all diff NPV.

now select all NPV and discount rate

go in to insert menu and select scatter.

Now we can see only 0 npv at 19% not at two diff rate that mean there is only one NPV


Related Solutions

required rate of return = 15% year year cash flow ($ in millions) 0 -500 1...
required rate of return = 15% year year cash flow ($ in millions) 0 -500 1 90 2 100 3 150 4 180 5 190 6 140 7 100 8 80 9 60 10 -50 1. make a spreadsheet using excel to calculate irr, mirr, npv, 2. using excel, draw npv profile and find "two" IRRs. 3. based on the analysis, should you take on this project?
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%
Given the following cash flow projections and a required rate of return of 14%, find the...
Given the following cash flow projections and a required rate of return of 14%, find the NPV, IRR. Should you accept this project? Does the project add value for the shareholders? Year Cash flow 0 -$3,000,000 1 $420,000 2 $600,000 3 $800,000 4 $1,000,000 5 $1,200,000 6 $800,000 7 $650,000 8 $500,000 9 -$450,000
Use the following cash flow with a 5% discount rate: Year Cash Flow 0 -$ 80,000...
Use the following cash flow with a 5% discount rate: Year Cash Flow 0 -$ 80,000 1 20,000 2 15,000 3 20,000 4 25,000 5 30,000 What is the NPV? $ 9,154 -$2,567 $14,003 $10,036
Project Cash Flow Today (millions) Cash Flow in One Year (millions) A -$10 $20 B $6...
Project Cash Flow Today (millions) Cash Flow in One Year (millions) A -$10 $20 B $6 $4 C $18 -$12 Suppose all cash flows are certain and the​ risk-free interest rate is 5%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose any two of these​ projects, which should it​ choose?
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What is the present (Year 0) value if the opportunity cost (discount) rate is 10 percent? Add an outflow (or cost) of $1,000 at Year 0. What is the present value (or net present value) of the stream?
Year Cash Flow (A) Cash Flow (B) 0 –$234,478        –$14,554          1 26,800        4,132...
Year Cash Flow (A) Cash Flow (B) 0 –$234,478        –$14,554          1 26,800        4,132          2 60,000        8,022          3 53,000        13,389          4 391,000        9,123             Whichever project you choose, if any, you require a 6 percent return on your investment. Required: (a) What is the payback period for Project A? (Click to select)3.34 years3.14 years3.4 years3.08 years3.24 years     (b) What is the payback period for Project B? (Click to select)2.11 years2.18...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -73 30 30 30 30 .15 Assume that projects A and B are mutually exclusive. The correct investment decision and the best rational for that decision is to: Group of answer choices a.invest in project A since NPVB < NPVA. b.invest in project B...
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash...
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash flow -$12,300 $4000 $4000 $3000 $3000 $3000 14.21% 12.75% 13.11% 13.85%
Annual cash flows: Year 0 $(104,000,000) Year 1 $250,000,000 Year 2 $(150,000,000) Required return 16% Output...
Annual cash flows: Year 0 $(104,000,000) Year 1 $250,000,000 Year 2 $(150,000,000) Required return 16% Output area: 2) NPV $42,806.18 Accept/Reject Accept 3) IRR 15.38% 25.00% 6) Required return @ Maximum NPV Maximum NPV What discount rate results in the maximum NPV for this project? What is that maximum NPV? Write a note to your client (or an old-school boss), who has little knowledge about the “Solver”, explaining what parameters you chose as inputs in the solver and what you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT