In cell C16, enter a formula using the CMMIPMT. function to calculate the cumulative interest paid on the loan after the first year (payment 1 in cell C14 through payment 12 in cell C15) when the payments are made at the end of the period. Use O as the type argument in your formula. b. Use absolute references for the rate, per and py arguments. C. Use relative references for the start and end arguments. d. Copy the formula from cell C16 to the range D16:G16 to calculate the interest paid in Years 2-5.