Switch to the Amortization worksheet. Calculate the cumulative interest for a loan for one food truck as follows:

a. In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan after the first year (payment 1 in cell C15 through payment 12 in cell C16) when the payments are made at the end of the period. Use 0 as the type argument in your formula.

b. Use absolute references for the rate, nper, and pv arguments.

c. Use relative references for the start and end arguments.

d. Copy the formula from cell C17 to the range D17:G17 to calculate the interest paid in Years 25.