Solving Annuities using a spreadsheet and TVM solver

How to solve tA loan of $$22,000$ is borrowed at $4\mathrm{.}9\%$ interest. The loan will be paid off in three years with monthly payments and interest is compounded monthly.

Use a spreadsheet program of your choice to determine the monthly payments.

Include a screenshot of the spreadsheet formula with all values visible and explained or

Record a video of you entering the values into the spreadsheet with a verbal explanation of the values entered.$$How much can you borrow so that you can make semi$-$annual payments of $$1,800$ for $5$ years? Assume the account earns $3\%$ interest compounded semi$-$annually.$$

Determine the amount you can borrow using a TVM solver of your choice. Include a screenshot of the TVM solver with all values inputted and clearly visible.$$