Solve for both parts of the question (1 and 2) and show all work. I will rate your answer with a thumbs up!

Q2During the pandemic RK borrowed a principal of $1,000.00 at 10% annual rate. 1. Design RK's amortization schedule for each year in an Excel sheet. Your Ercel sheet imple- ment the following information: (10 pts.) Please make sure you indicate all your work. Otherwise, no credit will be given. Year Beginning Balance Interest on Balance Payment Forward Balance 0 1 2 3 : : : 10 Table 2: Table II 2. Determine how much interest in total RK has to pay? (5 pts.)