Car Loan Schedule Loan Amount $$96,50012/10/2022$ Rate $2\mathrm{.}90\%$ Months $72$ Payment $($$$1,461\mathrm{.}88)$ Per month Month Beginning Balance Ending Balance Total Paid Interest $1$ $$96,500$ $$1,461\mathrm{.}88[14]$In cell C$7,$ enter the function $=$FV to determine the ending balance for year $1.$ Note that you need to do $=-$FV to make it positive. Also make, sure you have your absolute and relative reference correct. Also, note that since we are doing months the nper in the formula will be $1.$ I AM LOOKING FOR THE EQUATION FOR ENDING BALANCE THANK YOU