In cell E$7,$ calculate the new balance at the end of month $1.$ Fill cell E$7$ down the column to cell E$36.$

Note: The values in range E$8-$E$36$ will automatically change after completing the next steps.

In cell B$8,$ find the balance at the beginning of month $2.$ Fill cell B$8$ down the column to cell B$36.$

Fill cell C$7$ down the column to cell C$36.$ Fill cell D$7$ down the column to cell D$36.$ Apply to range C$8.$D$36$ the same formatting as for cell E$7$ Select cell E$7.$ On the Home Tab, click Format Painter and then select range C$8$:D$36.$

Note: The values in range D$7$:D$36$ should be equal to $$50.$

In cell F$38,$ find the amount owed at the end of one year.

In cell F$40,$ find the number of months to pay off the loan.

Save your file and submit for grading.

Total Points