Use the Loan worksheet to complete the loan amortization table.

In cell F$2,$ insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F$3$:F$25.($The results will update after you complete the other functions and formulas.$)$

$5$

$16$ In cell G$2,$ insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G$3$:G$25.5$

$17$ In cell H$2,$ insert a formula to calculate the ending principal balance. Copy the formula to the range H$3$:H$25.5$

$18$ Now you want to determine how much interest was paid during the first two years.

In cell B$10,$ insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive.

$5$

$19$ In cell B$11,$ insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. $5$

$20$ You want to perform a what$-$if analysis to determine the rate if the monthly payment is $$1,150$ instead of $$1,207\mathrm{.}87.$

In cell B$15,$ insert the RATE function to calculate the necessary monthly rate given the NPER, proposed monthly payment, and loan. Make sure the result is positive.

$5$

$21$ Finally, you want to convert the monthly rate to an APR.

In cell B$16,$ insert a formula to calculate the APR for the monthly rate in cell B$15.$

$5$

$22$ Insert a footer on all sheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. $2$

$23$ Save and close Exp$19\_$Excel$\_$Ch$07\_$CapAssessment$\_$Shipping.xlsx$.$ Exit Excel. Submit the file as directed.