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

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%

jeff jeffy answered 9 months ago

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%

(a) NPV at the end of the project (discount rate 15%) (b) IRR at the end...

(a) NPV at the end of the project (discount rate 15%) (b) IRR at the end of the project. Year (n) 0 1 2 3 4 Capex -$600,000 - - - - Income - $200,000 $200,000 $200,000 $200,000 Undiscounted cash flow P/F (15%) Discounted cash flow IRR - - - -

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?

Question