Can anyone help use this excel sheet to answer the questions? Show work please, I'm lost and want to try to use it as a walkthrough.

Amortization schedule Loan amount to be repaid (PV nterest rate (r) Length of loan (in years) $48,000.00 8.00% Formula a. Setting up amortization table Calculation of loan payment Repayment of Principal Year Beginning Balance Payment Interest Remaining Balance b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Representing Interest Payment % Representing Principal Year Check: Total: 100% Formulas Repayment of Principal #N/A #N/A Year Beginning Balance Payment #A/A #A/A Interest #A/A #A/A #N/A Remaining Balance #A/A #N/A b. Calculating % of Payment Representing Interest and Principal for Each Year Payment % Representing Principal #A/A #A/A Payment % Representing Interest Check: Total 100% #A/A #A/A #N/A Year