Term 30 years Base Interest Rate 4.01\% One-year constant maturity as of 10/7/2022 Debt Table ... for paying off a loan, place an " x " in the Payoff Column. This will zero out the monthly payment and add the payoff amount to the loan Complete this WS with the original information. ou can format and add rows on this worksheet. The Total Loan and PI variables have to be in the ighlighted cells. The table to calculate average balance follows the "Total Savings Remaining" cell. A. Complete the "Loan WS" worksheet with the given information. Use the provided "Loan WS" for this first part. 1. Base Downpayment - start with 15% Base Loan Amount Payment on Base Loan Amount UFPMI - Up-front Private Mortgage Insurance PI - Principal and Interest 2. Monthly PMI - Private Mortgage Insurance Property Taxes Insurance PITI - Principal, Interest, Taxes, and Insurance 3. Ratios Front-end (Housing Expense) Back-end (Debt-to-Income) 4. Closing Closing Costs Total Savings Needed Total Savings Remaining B. Analyze the results 1. Analyze the results from LOAN WS Term 30 years Base Interest Rate 4.01\% One-year constant maturity as of 10/7/2022 Debt Table ... for paying off a loan, place an " x " in the Payoff Column. This will zero out the monthly payment and add the payoff amount to the loan Complete this WS with the original information. ou can format and add rows on this worksheet. The Total Loan and PI variables have to be in the ighlighted cells. The table to calculate average balance follows the "Total Savings Remaining" cell. A. Complete the "Loan WS" worksheet with the given information. Use the provided "Loan WS" for this first part. 1. Base Downpayment - start with 15% Base Loan Amount Payment on Base Loan Amount UFPMI - Up-front Private Mortgage Insurance PI - Principal and Interest 2. Monthly PMI - Private Mortgage Insurance Property Taxes Insurance PITI - Principal, Interest, Taxes, and Insurance 3. Ratios Front-end (Housing Expense) Back-end (Debt-to-Income) 4. Closing Closing Costs Total Savings Needed Total Savings Remaining B. Analyze the results 1. Analyze the results from LOAN WS