The payment amount returned by the PMT function includes principal and interest but no

taxes, reserve payments, private mortgage insurance, or fees that may be associated with the

loan. No fees will be considered at this time. In cell C$10,$ calculate the end of period quarterly

payment amount using the PMT function. Be sure the result is displayed as a positive number.

The cumulative interest payment function can be used to calculate the amount of interest paid

over a specific number of periods, such as quarterly, annually, or for the whole term of the

loan. In cell C$11,$ calculate the total cumulative interest that will be paid on the loan for all $28$

end$-$of$-$the$-$period quarterly payments. Format as Currency. Be sure the result is displayed as

a positive number.