Question

In: Finance

Sarah’s gross salary is $200,000 per year. She is interested in purchasing a $600,000 house. She...

Sarah’s gross salary is $200,000 per year. She is interested in purchasing a $600,000 house. She will make a down payment of 20% and take out a 15 year, 4.5% fixed rate mortgage. The taxes plus insurance is $8000. In addition, she has student debt and makes annual payments of $6000 per year. What is the Gross Debt Service and Total Debt Service ratio? If the bank requires that these ratios must be less than 30 and 35% respectively, can she obtain her mortgage?

Expert Solution

Sarah's Gross debt service ratio = (Annual mortgage payment + Annual taxes plus insurance on the property)/ annual gross income

We know that the cost of house is $600,000 and down payment is 20%

Therefore Amount of mortgage after 20% of down payment

= $ 600,000 * (1-20%)

= $ 600,000 * 0.8 = $480,000

A 15-year mortgage at fixed-rate of 4.5%

The formula for monthly payment

M = P * (1+r) ^n * r / [(1+r) ^n - 1]

Where M = monthly payment

P = mortgage amount or principal = $480,000

And r = monthly interest rate = annual interest rate/12 = 4.5%/12 = 0.375%

And n = number of months = 15 years *12 = 180 month

Therefore

M = $480,000 * (1+0.375%) ^180 *0.375 / [(1+0.375) ^180 – 1] = $3,671.97

Annual mortgage payment = monthly payments *12

=$3,671.97 *12

= $44,063.61

Annual taxes on the property = $8000

Annual gross income = $200,000

Therefore

The Sarah's Gross debt service ratio = ($44,063.61 + $8000) /$200,000

= 0.2603 or 26.03%

Sarah's Total debt service ratio = (Annual mortgage payment + Annual taxes plus insurance on the property + other loan payments)/ annual gross income

As she has student debt and makes annual payments of $6000 per year therefore other loan payments are $6000 per year

Therefore,

Sarah's Total debt service ratio = ($44,063.61 + $8000 + $6000) /$200,000

=$58,063.61/$200,000

= 0.2903 or 29.03%

If the bank requires that these ratios must be less than 30 and 35% respectively, then also she can obtain her mortgage as her gross debt service ratio is 26.03% (less than 30%) and Total debt service ratio is 29.03% (less than 35%)

jeff jeffy answered 1 year ago

You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash...

You are thinking of purchasing a house. The house costs $200,000. You have $29,000 in cash that you can use as a down payment on the house, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires annual payments and has an interest rate of 7% per year. What will be your annual payment if you sign this mortgage?

Suppose that you are interested in purchasing a house in a particular area of a city...

Suppose that you are interested in purchasing a house in a particular area of a city and are inter- ested in the average size of the homes in that area. In a random sample of 200 homes, you find a sample mean of 2127.94 square feet and a standard deviation of 387.276 square feet. Further- more, you calculated a 99% confidence interval for the true mean size to be (2056.72, 2199.16). Why is it unnecessary to check for normality in...

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...

. Calculate Adjusted gross income for Sarah Smith based on the following information: salary $200,000 child...

. Calculate Adjusted gross income for Sarah Smith based on the following information: salary $200,000 child support received $20,000 capital loss $5,000 Interest on State of California bonds $20,000 Interest on Federal treasury bonds $10,000 Sole proprietorship net income $40,000 Qualified unreimbursed employee moving expense $ 10,000 Partnership loss $2,000 Unemployment compensation $20,000 Sarah received a gift of $10,000 from her father. Contribution to Individual Retirement Account $1,000 Sarah's brother Samuel paid back a $10,000 loan from 2015 Contribution to...

1. Assume you are interested in purchasing a $350,000 house with the following characteristics: - 80%...

1. Assume you are interested in purchasing a $350,000 house with the following characteristics: - 80% Loan to Value Loan @ 4% interest (30yr, fully amortized) - Property taxes = 1.2% of purchase price per year - Homeowners Insurance = $1,000/yr Homeowners Association Dues = $200/mo Payment to Income Ratio = 28% Total Obligations to Income Ratio = 35% Questions: A. How much do you have to earn to afford this house (assuming zero consumer debt) B. Will you still...

1. A statistician is interested in the gross earnings of several of her favorite bands. She...

1. A statistician is interested in the gross earnings of several of her favorite bands. She took a random sample of 30 of the Rolling Stones’ North American concerts, and found that the gross earnings averaged $2.27 million with a standard deviation of $0.5 million. One source suggests that the average gross earnings per concert for every stadium performance in North America is $2.11 million. Do the Rolling Stones earn more on average? Test at a 5% level of significance...

Amy works in a shop. Her annual gross salary is $25,000. From this, she must pay...

Amy works in a shop. Her annual gross salary is $25,000. From this, she must pay social security (calculated as 12% of her gross pay) plus 8% income tax. In addition to taxes, she must repay a loan to her employers at a rate of $125 per month, which comes out of her post tax income (i.e. income after tax has been calculated). What is Amy's take home pay per annum? Give your answer in dollars to the nearest dollar.

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...

Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....

Queenie just bought a house that cost $1,600,000. She has saved up $200,000 for the closing...

Queenie just bought a house that cost $1,600,000. She has saved up $200,000 for the closing costs--such as legal fees—and the down payment. When she approaches the local bank, she was quoted the rate for a two-year mortgage at 4% (APR, semi-annual compounding), 25 years amortization. But there is one problem; she was told that her income satisfied the bank’s GDS and TDS requirements, but the bank can lend only up to 75% of the purchase price of the house...

A European company is importing (purchasing) $600,000 of goods in one year. The current spot price...

A European company is importing (purchasing) $600,000 of goods in one year. The current spot price is $1.23/€. Risk free rates in the US and Eurozone are 4% and 3%, respectively. The forward rate is $1.20/€. Your CEO wants to implement a money market hedge. This involves borrowing in one currency to purchase the other currency (which you will then invest for one year). What is the amount you are borrowing? Once the money market hedge is finalized a year...