In cell B39, use the CUMPRINC function to calculate the end of period cumulative principal payment amounts for each period for loan option 4. Use cell references for all arguments and make sure the result is positive. Autofill the function down through B78.

In cell C39, use the CUMIPMT function to calculate the end of period cumulative interest payment amounts for each period for loan option 4. Use cell references for all arguments and make sure the result is positive. Autofill the function down through C78.

B D E $218,000.00 7.2% 10 4 $7,692.29 Principal Payments Interest Payments 28 29 Loan Analysis - Option 4 30 31 Loan Amount 32 Interest Rate 33 Term of Loan (years) 34 Payments per Year 35 Quarterly Payments 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29