i need help with step $29.$

Assignment Instructions

$28$

Enter a reference to the remaining balance of payment $1$ in cell B$13.$ Use the fill handle to copy the functions created in the prior steps down to complete the amortization table. Expand the width of columns D:H as needed.

PaymentAPRYearsPmts per Year$12131415161718192021222324252627$PaymentNumber$310111213141516$$$8,000\mathrm{.}00$S$\mathrm{.}75\%12$Beginning PaymentBalance Amount$$416,303\mathrm{.}09$ $$8,000\mathrm{.}00$LoanDPeriodic Rate#of Payments$$416,303\mathrm{.}090\mathrm{.}479\%60$GHPrincipal Remaining Cumulative CumulativeInterest Paid Repayment BalancePrincipalInterest$$1,994\mathrm{.}79$ $$6,005\mathrm{.}21$ $$410,297\mathrm{.}88$ $ $63,696\mathrm{.}91$ $ $416,303\mathrm{.}09$