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 | Monthly Debts | ||||||||||||
| Cash Available for Down Payment | I n t e r e s t R a t e | ||||||||||||
| % of Cash to Pay Debt | |||||||||||||
| House Price | |||||||||||||
| Interest Rate | |||||||||||||
| Term (Years) | |||||||||||||
| Monthly Debts (If Not Retired) | |||||||||||||
| Acceptable % of Income | |||||||||||||
| Income Calculation | |||||||||||||
| Monthly Income | |||||||||||||
| Acceptable Income Servicing Debt | |||||||||||||
| Monthly Debts (After Debt Retired) | |||||||||||||
| Max Payment | |||||||||||||
| Monthly Payment Calculation | From What if 1 (2 points) | ||||||||||||
| Loan Amount | 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 | Monthly Debts level | ||||||||||||
| Term (Years) | Enter Answer in F 37 | ||||||||||||
| Monthly Payment | |||||||||||||
| From What if 2 (4 points) | |||||||||||||
| Income Surplus | 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
