Question

In: Finance

Begin by plotting how the NPV of this project changes with different discount rates. Note that...

Begin by plotting how the NPV of this project changes with different discount rates. Note that you'll have to find the NPV of the project first using a discount rate of your choosing. Use a data table to create this plot. Have your discount rates range from 0% to 60% in increments of 2%. Please label your x-axis "Discount Rate" and your y-axis "Net Present Value of Cash Flows". Title your graph "NPV Calculation". There should be no legend on the graph. How many IRRs does this project have? What are they? Perform your IRR calculations in the box on the left.

Year

Cash Flow

0

-1000

1

800

2

1000

3

1300

4

-2200

Solutions

Expert Solution

Given Cash flow in year 0 CF0=-1000

Cash flow in year 1 CF1=800

Cash flow in year 2 CF2=1000

Cash flow in year 3 CF3=1300

Cash flow in year 4 CF4=-2200

let r be discount rate

NPV= CF0+CF1/(1+r)+CF2/(1+r)^2+CF3/(1+r)^3+CF4/(1+r)^4

For

Discount Rate NPV
0% -100.00
2.00% -61.96
4.00% -31.09
6.00% -6.39
8.00% 13.00
10.00% 27.80
12.00% 38.65
14.00% 46.11
16.00% 50.63
18.00% 52.64
20.00% 52.47
22.00% 50.44
24.00% 46.82
26.00% 41.83
28.00% 35.68
30.00% 28.54
32.00% 20.56
34.00% 11.88
36.00% 2.61
38.00% -7.14
40.00% -17.28
42.00% -27.75
44.00% -38.47
46.00% -49.39
48.00% -60.45
50.00% -71.60
52.00% -82.82
54.00% -94.07
56.00% -105.31
58.00% -116.52
60.00% -127.69

From Above graph we find that it has TWO IRRs. two IRRs are 6.60% and 36.55%.

IRR occured when NPV=0

Let R be the IRR

-1000+800/(1+R)+1000/(1+R)^2+1300/(1+R)^3-2200/(1+R)^4=0

R=6.60% and 36.55%


Related Solutions

Note the payback period for each project. Calculate the NPV for each project assuming discount rates of 10%, 12% and 14% (round your answers to whole dollars).
Project Number       1   2   3   4   5   6   7   8                                    Initial Investment       ($2,000)   ($2,000)   ($2,000)   ($2,000)   ($2,000)   ($2,000)   ($2,000)   ($2,000) Year 1       $330    $1,666        $160    280    $2,200    $1,200    ($350) 2       330    334        200    280        900    (60) 3       330    165        350    280        300    60 4       330            395    280        90    350 5       330            432    280        70    700 6       330            440    280            1,200 7       330            442    280            2,250 8       1,000            444    280            9                   446    280            10                   448    280            11                   450    280            12                   451   ...
If the discount rate changes from 12% to 15%, what is the CHANGE in the NPV of the project approximately?
A project has the following cash flows: Year 0 Year 1 Year 2 Year 3 Cash flow -100.000 70.000 120.000 200.00 If the discount rate changes from 12% to 15%, what is the CHANGE in the NPV of the project approximately? Please no excel sheet, just detailed steps for someone new in finance ;)
What is the NPV of the following project if the discount rate is 10%? Round to...
What is the NPV of the following project if the discount rate is 10%? Round to the nearest cent. Investment today: $-150,000; Cash flow in year 1: $60,000; Cash flow in year 2: $75,000; Cash flow in year 3: $60,000
A project has an NPV of £12,632 when a discount rate of 12% is used and...
A project has an NPV of £12,632 when a discount rate of 12% is used and the same project has an NPV of (£6,935) when a discount rate of 24% is used. The approximate internal rate of return of the project is: Select one: a. 18.5% b. 15.16% c. 20.5% d. 19.75% An investment project costs $10,500 and will generate $4,000 in annual cash flows for five years. What is the exact internal rate of return (IRR)? Select one: a....
You are evaluating an investment project and learn the following: The project’s NPV at a discount...
You are evaluating an investment project and learn the following: The project’s NPV at a discount rate of 16% is +$35,879 The project’s NPV at a discount rate of 20% is +$12,356 The project’s NPV at a discount rate of 22% is -$1,923 Based on (i)-(iii) above you know the project’s IRR must be: a. Less than 16% b. Greater than 22% c. Between 16% and 20% d. Between 20% and 22% e. Exactly 20%
Calculate NPV for each project. Please workout problem.. Discount rate 10% Year Project A Project B...
Calculate NPV for each project. Please workout problem.. Discount rate 10% Year Project A Project B Project C 2018 ($3,000,000) ($3,000,000) ($3,200,000) 2019 $0 $975,000 $985,000.00 2020 $600,000 $975,000 $925,000.00 2021 $900,000 $975,000 $1,000,000.00 2022 $3,000,000 $1,000,000 $950,000.00
Explain how the use of different levels of discount rates make trade-offs between current and future...
Explain how the use of different levels of discount rates make trade-offs between current and future welfare. Give me one example of a situation in which a higher discount rate would be appropriate and one example of when a lower rate would be appropriate.
Explain the effect of different discount rates on the present value of receiving $1 in the...
Explain the effect of different discount rates on the present value of receiving $1 in the future.   The fourth rate is your choice: use the slider in the table to choose a discount rate you think is appropriate for the evaluation of the benefits and costs of climate change policy in the distant future. Justify your choice. Is it closer to the Nordhaus or Stern proposal? Or is it higher than or lower than both?  
What is IRR and how is different from NPV?
What is IRR and how is different from NPV?
What is IRR and how is different from NPV?
What is IRR and how is different from NPV?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT