Question 20 (1 point) F G 0 B D E 1 Discount rate 10% (NPV Calculation) 2 3 Year 1 2 4 Cash flow -100 46 30 5 6 NPV 7 8 The appropriate formula to get "NPV in cell B6 is: 3 34 4 25 5 21 al =NPV(B1,B4:G4)+B4 =NPV(B1,C4:G4)+B4 No correct answer option is given =NPV(B1,C4:G4) =NPV(B1,B4:G4) F G + Question 21 (1 point) C D E 1 For your company, you have borrowed $550,000 2 You plan to make loan repayment for your firm on a yearly basis. 3 4 You use the following criteria: 5 Initial loan 550000 6 Loan payment in year 1 75000 7 Each year loan repayment will increase by 10% 8 Maximum loan repayment in a year 100000 9 10 Below, calculation is shown for six years: 11 Year 1 Year 2 Year 3 Year 4 12 Beginning Loan 550000 475000 392500 301750 13 Loan payment 75000 90750 99825 14 Ending loan 475000 392500 301750 201925 15 16 The appropriate formula for loan repayment in cell C13 is: Year 5 201925 100000 101925 Year 6 101925 100000 1925 =IF(B13*(1+$E$7)