Loan amortixation and capital recovery

Ian loaned his friend $$45,000$ to start a new business. He considers this loan to be an investment, and therefore requires his friend to pay him an interest rate of $5\%$ on the loan. He also expects his friend to pay back the loan over the next four years by making annual payments at the end of each year: lan texted and asked that you help him calculate the annual payments that he should expect to receive so that he can recover his initial investment and earn the agreed$-$upon $5\%$ on his investment?

Calculate the annual payment and complete the following capital recovery schedule:

$\backslash$table$[[$Year$,$Beginning Amount,Payment,Interest Paid,Principal Paid,Ending Balance$],[1,$$$45,000\mathrm{.}00,$grad,grad,,$],[2,$E$,,$grad,,$],[3,,,$grad,,$],[4,,,$grad,,$$0\mathrm{.}01$