What is the NPV at 0%?

What is the NPV at 10%?

What is the NPV at 20%?

What is the NPV at 30%?

16 ? X XL 5D FILE HOME INSERT Calculating NPV - Excel FORMULAS DATA REVIEW - Sign In PAGE LAYOUT VIEW Paste 10 B I U- - A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - points Clipboard Font Skipped A1 c E F G H I J K - eBook Print What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is 10 percent? If it is 20 percent? If it is 30 percent? References Year 0 Year 1 Year 2 Year 3 (13,900) 6,400 8,700 5,900 A 0% Discount rate Discount rate Discount rate Discount rate 10% 20% 30% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this