Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started