Not very good at excel. Please show me how to fill out this table with the proper formulas.. step by step. There is a screenshot of the file below.

You have recently taken a position in a bank. Your first client would like assistance planning for a loan. You want to set up a detailed loan amortization table. Open the attached Excel file LoanAmortization.xlsx. This file contains a worksheet with a loan parameters area (i.e., input area), a summary area, and amortization table column labels. You must use this template to complete a detailed loan amortization table and the summary area. Any other format of your amortization schedule will not be acceptable. You want to hide zeros from displaying if your client takes out a shorter-term loan or pay it off early. However, you must keep formulas in place for a traditional 30-year loan. In addition, you will notice overpayments on the last payment if you pay extra toward the principal each month. Add a header in the worksheet and place your name in the header. Alignment . abc . Clear Arial BT U & 10 A ACE V E 3 Wrap Text M erge - General 3 % ) J32 C D E Amortization Schedule $2.923.71 Loan Parameters $ 400,000 Principal 6.25% TAnnual interest Rate 3/1/15 Date of First Payment 20 Term of Loan (Years) 12 Number of Payments Per Year Extra Payment Every Period Loan Summary Information Monthly Payment (P&I Only Scheduled Number of Payments Normal Payoff Date Actual Number of Payments Actual Payoff Date Total of Extra Payments Total of An Interest Payments 10 Payment Number Date Beginning Regular Balance Payment 400.000222371281 Extra Payment Interest 2 .08333 Principal 840 38 Ending Balance 399.159.62 13 3/1/15 $ $ 15 16 1/ 18