3 FILE ? 3 X Calculating NPV - Excel FORMULAS DATA HOME INSERT PAGE LAYOUT REVIEW VIEW Sign in X Calibri -11 M Paste BIU - A A % A Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Nh l Font A1 v B C D E F G 1 2 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? 5 6 7 Year 0 Year 1 Year 2 Year 3 S $ (13,900) 6,400 8,700 5,900 $ 10 11 12 Discount rate Discount rate Discount rate Discount rate 15 0% 10% 20% 30% 16 16 17 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 Opercent 19 20 21 NPV at 10 percent Sheet READY Attempt 100% All answers must be entered as a formula. Click OK to begin. OK