PLEASE SHOW CALCULATIONS
Posted: Wed May 18, 2022 10:50 pm
- Please Show Calculations 1 (23.82 KiB) Viewed 52 times
с D E F G H 10% 15% 500 100 LO 0 -500.00 1 100.00 2 110.00 3 121.00 4 133.10 146.41 A 2 Growth rate 3 Discount rate 4 Cost 5 Year 1 cash flow 6 7 Year 8 Cash flow 9 10 NPV 11 IRR 12 13 14 15 16 17 Discount rate 18 19 20 21 22 23 24 2% 4% 6% 8% 10% 12% Growth $0.00 0% 0% 3% 6% 9% 12% 15% 18% 21% 24%
QUESTION 4 (5 points) The following table 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 for discount rates 0, 3, 6, ... 21 percent and growth rates 0, 2, 4, ..., 12 percent. NPV, DISCOUNT AND GROWTH RATES Growth rate 10% Discount rate 15% 500 Year 1 cash flow Cost 100 Year Cash flow 0 -500.00 1 100.00 2 110.00 3 121.00 4 133.10 5 146.41