a. in cell b16, enter a formula using the cumipmt function to calculate the cumulative interest paid on the loan for year 1 (payment 1 in cell b14 through payment 12 in cell b15). use 0 as the type argument in your formula because payments are made at the end of the period.