This workbook has the following worksheets. Go through and look at all of them before you start working. ou are a mortgage broker with a client that has found a property to purchase. You must: 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 in LOAN WS from the original scenario. Make notes since the worksheet will change as you complete this assignment. 2. Write up your results in the Answer box below. Question: Does your customer qualify for a loan for this property? If not, what can you do to help them qualify? Total Savings Needed Total Savings Remaining B. Analyze the results 1. Analyze the results in LOAN WS from the original scenario. Make notes since the worksheet will change as you complete this assignment. 2. Write up your results in the Answer box below. Question: Does your customer qualify for a loan for this property? If not, what can you do to help them qualify? Term Base Interest Rate 30 years 4,01% One-year constant maturity as of 10/7/2022 Cost of Private Mortgage Insurance Up-Front Private Mortgage Insurance (UFPMI) Annual Monthly Insurance Premium (MIP) 1,75% 0,85% File Home Insert Page Layout Formulas Data Review View Help 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 calculations. Complete this WS with the original information. You can format and add rows on this worksheet. The Total Loan and PI variables have to be in the highlighted cells. The table to calculate average balance follows the "Total Savings Remaining" cell. Total Loan C4 & \\ \hline 19 & Ratio Analysis \\ \hline 20 & \end{tabular} Closing Payoffs: xfx Closing Costs Total to bring to closing: Total Savings Remaining End of Assignment \begin{tabular}{|r|r|} \hline \multicolumn{2}{|c|}{ Table to calculate } \\ \multicolumn{2}{|c|}{ Average Balance } \\ \hline Month & Balance \\ \hline 0 & $0,00 \\ 1 & $0,00 \\ 2 & $0,00 \\ 3 & $0,00 \\ 4 & $0,00 \\ 5 & $0,00 \\ 6 & $0,00 \\ 7 & $0,00 \\ 8 & $0,00 \\ 9 & $0,00 \\ 10 & $0,00 \\ 11 & $0,00 \\ 12 & $0,00 \\ \hline Average & $0,00 \\ \hline \end{tabular} This workbook has the following worksheets. Go through and look at all of them before you start working. ou are a mortgage broker with a client that has found a property to purchase. You must: 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 in LOAN WS from the original scenario. Make notes since the worksheet will change as you complete this assignment. 2. Write up your results in the Answer box below. Question: Does your customer qualify for a loan for this property? If not, what can you do to help them qualify? Total Savings Needed Total Savings Remaining B. Analyze the results 1. Analyze the results in LOAN WS from the original scenario. Make notes since the worksheet will change as you complete this assignment. 2. Write up your results in the Answer box below. Question: Does your customer qualify for a loan for this property? If not, what can you do to help them qualify? Term Base Interest Rate 30 years 4,01% One-year constant maturity as of 10/7/2022 Cost of Private Mortgage Insurance Up-Front Private Mortgage Insurance (UFPMI) Annual Monthly Insurance Premium (MIP) 1,75% 0,85% File Home Insert Page Layout Formulas Data Review View Help 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 calculations. Complete this WS with the original information. You can format and add rows on this worksheet. The Total Loan and PI variables have to be in the highlighted cells. The table to calculate average balance follows the "Total Savings Remaining" cell. Total Loan C4 & \\ \hline 19 & Ratio Analysis \\ \hline 20 & \end{tabular} Closing Payoffs: xfx Closing Costs Total to bring to closing: Total Savings Remaining End of Assignment \begin{tabular}{|r|r|} \hline \multicolumn{2}{|c|}{ Table to calculate } \\ \multicolumn{2}{|c|}{ Average Balance } \\ \hline Month & Balance \\ \hline 0 & $0,00 \\ 1 & $0,00 \\ 2 & $0,00 \\ 3 & $0,00 \\ 4 & $0,00 \\ 5 & $0,00 \\ 6 & $0,00 \\ 7 & $0,00 \\ 8 & $0,00 \\ 9 & $0,00 \\ 10 & $0,00 \\ 11 & $0,00 \\ 12 & $0,00 \\ \hline Average & $0,00 \\ \hline \end{tabular}