please fill in excel blanks with an excel sheet.

please fill in all blanks and give excel formulas for answers.

= = teps for creating an Amortization Schedule. (Instructions can also be found in the textbook PG 210. Table 8-2) Remember: Enter the formulas in each cell to calculate the payments and bolonce. Hint: For Month 2 (Row 19) Beginning Balance, click in cell C19, type =, click in cell G18, click enter. Then once you get all of the formulas entered in row 19 , you can drag them all down to row 101. Step 4: Compute the end balance: =Monthly beginning balance - payment principal Note: The end balance does not include the interest, because it represents the principal remaining on the loan. The principol already repaid is "killed off" Problem 2: Loan Amortization type questions that will appear on the final exam. You just borrowed $45,800 and agreed to make yearly payments for 10 years on an amortized loan schedule. You agreed to pay 4.2% interest on the loan. 1. What would be the balance of the loan at the beginning of the second year? 2. How many dollars in interest will you pay during the second year of the loan? 3. From you first yearly payment, how many dollars will be allocated to the principal? Problem 1: = = teps for creating an Amortization Schedule. (Instructions can also be found in the textbook PG 210. Table 8-2) Remember: Enter the formulas in each cell to calculate the payments and bolonce. Hint: For Month 2 (Row 19) Beginning Balance, click in cell C19, type =, click in cell G18, click enter. Then once you get all of the formulas entered in row 19 , you can drag them all down to row 101. Step 4: Compute the end balance: =Monthly beginning balance - payment principal Note: The end balance does not include the interest, because it represents the principal remaining on the loan. The principol already repaid is "killed off" Problem 2: Loan Amortization type questions that will appear on the final exam. You just borrowed $45,800 and agreed to make yearly payments for 10 years on an amortized loan schedule. You agreed to pay 4.2% interest on the loan. 1. What would be the balance of the loan at the beginning of the second year? 2. How many dollars in interest will you pay during the second year of the loan? 3. From you first yearly payment, how many dollars will be allocated to the principal? Problem 1