This file contains a worksheet with a loan parameters area (i.e., 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.

How do I fill out this table

D E 71 G H $34,472.55 12 OOONO F TRegular 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 Interest Principal Regular Payment 34472.55223 $ Extra Payment Ending Balance 0 $ 367,610.78 2,083.33 $ 32,389.22 A B 4 $ 400,000 Principal 5 6.25% Annual Interest Rate 6 2/1/2021 Date of First Payment 7 1 Term of Loan Years) 8 12 Number of Payments Per Year 9 Extra Payment Every Period 10 11 Payment Beginning Date 12 Number Balance 13 2/1/2021 $ 400,000 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 D E 71 G H $34,472.55 12 OOONO F TRegular 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 Interest Principal Regular Payment 34472.55223 $ Extra Payment Ending Balance 0 $ 367,610.78 2,083.33 $ 32,389.22 A B 4 $ 400,000 Principal 5 6.25% Annual Interest Rate 6 2/1/2021 Date of First Payment 7 1 Term of Loan Years) 8 12 Number of Payments Per Year 9 Extra Payment Every Period 10 11 Payment Beginning Date 12 Number Balance 13 2/1/2021 $ 400,000 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32