Question: Do not touch this section Mortgage Approval What if 1 (6 points) What if 2 (8 points) Customer Information Down Payment Annual Income $62,000 Monthly

Do not touch this section
Mortgage Approval
What if 1 (6 points) What if 2 (8 points)
Customer Information Down Payment
Annual Income $62,000 Monthly Debts $5,000 $10,000 $15,000 $20,000 $25,000
Cash Available for Down Payment $10,000 1,000
I n t e r e s t R a t e
4.00%
% of Cash to Pay Debt 25% 900 4.25%
House Price $260,000 800 4.50%
Interest Rate 6.00% 700 4.75%
Term (Years) 30 600 5.00%
Monthly Debts (If Not Retired) $1,000 500 5.25%
Acceptable % of Income 40% 400 5.50%
300 5.75%
Income Calculation 200 6.00%
Monthly Income $5,167 100 6.25%
Acceptable Income Servicing Debt $2,067 0 6.50%
Monthly Debts (After Debt Retired) $875
Max Payment $1,192
Monthly Payment Calculation From What if 1 (2 points)
Loan Amount $252,500 Q1: With the current levels of all other model inputs remaining same, to what level should I bring down my monthly debts be approved (i.e. largest debt level that will give me have a positive income surplus)
Interest Rate 6.00% Monthly Debts level
Term (Years) 30 Enter Answer in F 37
Monthly Payment $1,514
From What if 2 (4 points)
Income Surplus -$322 Q2: With all else being equal, what level of down payment and interest rate just qualifies me for the loan (i.e., I have the smallest positive surplus possible and just sneak through)
Interest rate Down Payment
Approval No Enter Answer in F 42, G 42

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!