hello i need a numbered step by step guide explaining how to fill each column including what formulas i need in order to do so and where to i put them. thank you!

Formula Bar B D G H Amortization Schedule (Spring 2021) $34,472.55 12 Loan Parameters $ 400,000 Principal 6.25% Annual Interest Rate 3 2/1/2021 Date of First Payment 1 Term of Loan (Years) 3 12 Number of Payments Per Year Extra Payment Every Period 0 1 Payment Beginning Number Date Balance 3 2/1/2021 $ 400,000 4 Loan Summary Information Regular Payment (P&I Only) Scheduled Number of Payments Normal Payoff Date Actual Number of Payments Actual Payoff Date Total of Extra Payments Total of All Interest Payments Regular Payment 34472.55223 $ Interest Principal 2,083.33 $ 32,389,22 Ending Extra Payment Balance 0 $ 367,610.78 C - 16 17 8 19 20 21 22 23 24 25 26 27 28 Payments 7.(15 points) This exercise let you practice your accounting and Excel knowledge/skill 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 Excelle LoonAmortization Spring2021.xlsx. This file contains a worksheet with a loan parameters areale, Input section, a summary section, and an amortization table with column labels. You must use this template to complete a detailed loan amortization table and the summary section. Any other format of your amortization schedule will not be acceptable. You amortization table should be able to display the data for a loan up to 30 years. The data in the Summary section should be automatically changed when a user changes any value in the input section. You should hide zeros from displaying if your client takes out a shorter-term loan or pay it off early, The Ending Balance cannot be negative values. 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