Question

In: Finance

The Simpson’s are considering the purchase of a home. They currently have a combined annual gross...

The Simpson’s are considering the purchase of a home. They currently have a combined annual gross income of $68,000.

Current Monthly Expenses are as follows:

Car Payment $320

Credit Card$100

Student Loan $220

Their proposed mortgage payment (p&i) will be $820 per month, with an additional $70 per month for private mortgage insurance (PMI).Annual property taxes and homeowner’s insurance are $1,800 and $1,200 respectively.

Complete the below worksheet to calculate the front end and back end ratios.

Gross Monthly Income _____________

Mortgage (P&I)              ________________

Property Taxes                 _______________

Homeowner’s Ins.            _______________

Mortgage Ins. (PMI)             _____________

Total                                 ______________

Total                                     ______________

1-What is the Simpsons’ front end ratio?   _____________

2-What is the Simpsons’ back end ratio?   _____________

3-Based solely on your calculations would the Simpsons qualify for this mortgage?

Solutions

Expert Solution

Gross Monthly Income

Mortgage

68000/12=5666.67

820

Property Taxes

1800/12=150

Homeowners's Ins

1200/12=100

Mortgage Ins

70

  1. Front End Ratio=Monthly Housing Expenses/Monthly Income

                            =820+150+100+70/5666.67

                             =1140/5666.67=20.12%

2) Back End Ratio= Monthly Housing Expenses + Other Debt Payments/ Monthly Income

                          =1140+320+100+220/5666.67=

                         =1780/5666.67=31.4117%

3) Yes Simpsons would qualify. As per standard if front and back end ratio is less than 28% and 36% respectively borrower would qualify for loan.

                            -


Related Solutions

You are considering the purchase of a home for $700,000. You have available a deposit of...
You are considering the purchase of a home for $700,000. You have available a deposit of $100,000. The bank will lend you money at 7 per cent per annum compounded monthly over a period up to 20 years. If you borrow the required funds over 20 years, what are the monthly repayments? After two years, how much do you still ow the bank? What is the interest component of the 25th repayment?
Michael and Michelle currently earn a combined gross income of $200,000 per year and each earns...
Michael and Michelle currently earn a combined gross income of $200,000 per year and each earns $100,000 per year. The currently pay $2100 per month on their mortgage and plan to continue to live int he same house at retirement. The mortgage will be paid off just before their planned retirement at age 67. Michael is int he Navy Reserve and will soon qualify for retirement. This will result in him receiving a military retirement pay of $2250 per month...
You are considering the purchase of a really nice home in three years. You have $100,000...
You are considering the purchase of a really nice home in three years. You have $100,000 in your bank savings account today but would rather wait to buy the house. You plan to leave the money there for three years under 4% APR with monthly compounding. You understand that this money alone will not be enough to buy the house of your dreams, so when it’s time to buy the house you will have to take out a mortgage loan....
Suppose that an investor is considering the purchase of an multifamily housing. The potential gross income...
Suppose that an investor is considering the purchase of an multifamily housing. The potential gross income of the first year of operations has been estimated at $550,000. To value the property, the investor assume the following factors: Rents are estimated to increase by 2.5% per year. 5.5% vacancy loss rate and no other income. The vacancy loss rate will remain constant. Fixed and variable expenses were estimated at $97,000 and $155,000, respectively. These expenses will continue to represent the same...
4. Phil and his wife, Traci, both work and have a combined gross income of $165,000...
4. Phil and his wife, Traci, both work and have a combined gross income of $165,000 per year. Phil used the Total Expense Ratio to calculate an affordable monthly payment of $2100. Suppose the couple can get a 30 year loan with a rate of 4.5%, how much can they afford to borrow? a. Write the Excel formula used.____________________________________ b. How much can they afford to borrow? __________________________
You are considering the purchase of a new home offered at a price of $225,000. Create...
You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home. The bank will offer you a loan at an annual interest...
You are considering the purchase of a new home offered at a price of $225,000. Create...
You are considering the purchase of a new home offered at a price of $225,000. Create an amortization table in a new workbook that shows how much interest and principal you will pay each month for the duration of the loan. The following is a list of assumptions and requirements you need to consider for this assignment: You will be making a down payment of 20% on the home (refer to Table 2.5 for loan and lease terms). The bank...
You are considering the purchase of a home priced at $175,000, using 15% down.
You are considering the purchase of a home priced at $175,000, using 15% down. The rest will be financed at 4.29% over 360 months.   What is your monthly payment expected to be?A) $853B) $1,187C) $735.25D) $556.7914) For the loan in #13, what is the loan constant?A) 5.93%B) 4.29%C) 8.17%D) 6.77%15) If there were 2 points and $790 in fees to the lender to be paid to obtain the interest rate in problem #13, what would be the APR of the...
You are considering the purchase of a home that would require a mortgage of $250,000 (i.e....
You are considering the purchase of a home that would require a mortgage of $250,000 (i.e. you are borrowing $250,000 from a bank to buy the house. You intend to pay the bank back through equal monthly instalments). Suppose you are interested in the arithmetic sum of all the instalments you pay. How much more in total will you pay if you select a 30-year mortgage with an APR of 5.65% rather than a 15-year mortgage at an APR 4.9%?...
Suppose an individual has $62,500 in annual income and considering a home that they intend to...
Suppose an individual has $62,500 in annual income and considering a home that they intend to finance with a $175,000 mortgage at 5% APR 30-year fixed rate loan, the real estate taxes and insurance are $2,500 per year, auto payments are $300/month, and student loans payments are $350/month. What is the front-end ratio?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT