Amortization scheduleLoan amount to be repaid $($PV$)$$$33,000\mathrm{.}00$Interest rate $($r$)9\mathrm{.}00\%$Length of loan $($in years$)3$a$.$ Setting up amortization tableFormulaCalculation of loan payment#N$/$AYearBeginning BalancePaymentInterestRepayment of PrincipalRemaining Balance$123$b$.$ Calculating $\%$ of Payment Representing Interest and Principal for Each YearYearPayment $\%$ Representing InterestPayment $\%$ Representing PrincipalCheck: Total $=100\%123$FormulasYearBeginning BalancePaymentInterestRepayment of PrincipalRemaining Balance$1$#N$/$A#N$/$A#N$/$A#N$/$A#N$/$A$2$#N$/$A#N$/$A#N$/$A#N$/$A#N$/$A$3$#N$/$A#N$/$A#N$/$A#N$/$A#N$/$Ab$.$ Calculating $\%$ of Payment Representing Interest and Principal for Each YearYearPayment $\%$ Representing InterestPayment $\%$ Representing PrincipalCheck: Total $=100\%1$#N$/$A#N$/$A#N$/$A$2$#N$/$A#N$/$A#N$/$A$3$#N$/$A#N$/$A#N$/$A