D15 X V fx =ABS(PPMT($B$8, A15, $B$10, -$B$6)) A B C D E F Boyd Logistics Boyd N Loan Conditions Amounts 6 Loan amount (pv) $ 150,000 Annual interest rate 4.45% 8 Monthly interest rate (rate) 0.37% 9 Loan period in years 5 10 Loan period in months (nper) 60 11 Monthly payment $2,523.63 12 13 14 Period Payment Principal Interest Balance 15 2793. A 1 #NUM! 16 2 17 3 18 19 20 21 22 23 24 25 26 27 13 28 14 29 15 30 16on In cell C15, use the PMT function to determine the monthly payment. Enter the result as a positive value, use absolute cell references, and fill down. . In cell D15 use the PPMT function to determine the monthly principal payment. Enter as a positive value and fill down. In cell E15 create a formula that subtracts the principal amount from the payment to determine the amount of interest paid. Fill down. In cell F15 create a formula that calculates the balance for period 1. . In cell F16 create a formula that subtracts the principal amount from the previous period's (month's) balance. Fill down. . Ensure F74 lists zero balance due on the loan