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.$)$

$18$

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.$

$19$

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

$20$

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.

$21$

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.

$22$

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.

$23$

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.$ solve step $22$ and $23$ in detail give me step by step solution of the rate function in this assignment and also for the APR