Ivada wants to compare monthly payments, total interest, and total cost for interest rates that vary from $7\mathrm{.}725\%$ to $8\mathrm{.}075\%.$ She has already entered formulas to insert the

helly Cashman Excel $2019|$ Module $4$: End of Module Project $1$

monthly payment in cell D$11,$ the total interest in cell E$11,$ and the total cost in cell F$11.$ Based on the range C$11$:F$26,$ create a one$-$variable data table that uses the rate in cell D$6$ as the column input cell to provide the compari$\}$on that Nadia requests.

Cell D$6$ includes the rate a bank quoted Nadia for the business loan. In the list of interest rates $($range $C12$:$C26),$ create a Conditional Formatting Highlight Cells Rule to highlight the matching rate in Green Fill with Dark Green Text.

Nadia has set up the structure for an amortization schedule in the range H$4$:L$15.$ Finish the amortization schedule by completing the formula in cell J$5,$ which already contains an IF function that checks whether the year in column $H$ is less than or equal to the term in cell D$7.$