The spreadsheet fragment below shows a net present value and internal rate of return calculation for a project:

Use Data Table to do a sensitivity analysis on the NPV of the project, varying the discount rates from 0%, 3%, 6%, ?, 21% and varying the growth rates from 0%, 3%, ?, 12%.

Transcribed Image Text:

D E NPV, DISCOUNT AND GROWTH RATES A В F G H 1 2 Growth rate 3 Discount rate 4 Cost 5 Year 1 cash flow 10% 15% 500 100 6 7 Year 8 Cash flow 1 2 3 4 -500.00 100.00 110.00 121.00 133.10 146.41 10 NPV 11 IRR (101.42) <-- =NPV(B3,C8:G8)+B8 6.60%|<-- =IRR(B8:G8) Cell B15 contains the data table 12 function =B10 13 Growth 14 15 16 ($101.42) 0% 3% 6% 9% 12% 0% 0.00 30.91 63.71 98.47 135.28 17 Discount rate 3% -42.03 -14.56 14.55 45.38 78.01 18 6% -78.76 -54.26 -28.30 -0.84 28.21 19 9% -111.03 -89.08 -65.85 -41.28 -15.33 20 12% -139.52 -119.78 -98.91 -76.86 -53.57 21 15% -164.78 -146.97 -128.15 -108.28 -87.32 22 18% -187.28 -171.15 -154.13 -136.16 -117.23 23 21% -207.40 -192.75 -177.30 -161.01 -143.84 24 24% -225.46 -212.11 -198.04 -183.22 -167.62