$12.$ In the third scenario, Liam could pay back the loan for eight years with a monthly payment of $$8,000$ and then renegotiate better terms. He wants to know the amount remaining on the loan after eight years or the future value of the loan.

In cell I$11,$ insert a formula using the FV function and the rate $($cell I$6),$ the number of periods $($cell I$8),$ the monthly payment $($cell I$10),$ and the loan amount $($cell I$4)$ to calculate the future value of the loan for the eight$-$year scenario.