Saved HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri -11 % M > > BIU Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles board Font X A B D E F G H 1 J K 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? Year 0 Year 1 Year 2 Year 3 A A A A $ $ $ (13,900) 6,400 8,700 5,900 0% 10% Discount rate Discount rate Discount rate Discount rate 20% 30% 5 7 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. 8 9 NPV at O percent 0 :1 NPV at 10 percent Sheet1 Prav 2 of 3 # Next > Year 3 5,900 Discount rate Discount rate Discount rate Discount rate 0% 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 question. NPV at O percent NPV at 10 percent NPV at 20 percent NPV at 30 percent Sheet1 HE EADY attempt(s)