Question

In: Finance

Big Bank will make Duane Miller a mortgage loan if it meets the 28/36 rule. His...

Big Bank will make Duane Miller a mortgage loan if it meets the 28/36 rule. His annual gross income is $45,000. He has a $675 monthly auto payment and the property taxes & homeowners insurance for a new home will cost $3,000 annually. Big Bank will give him a 30-year mortgage with a 7.5 percent fixed rate. Duane will make a 20% down payment.

  1. What maximum purchase price for a home can Duane afford (how much house can he buy)? Round your answer to the nearest $1,000 and show your work.

  1. Assume Duane pays off his auto loan thereby eliminating the $675 monthly payment. What maximum purchase price for a home can Duane now afford? Round your answer to the nearest $1,000 and show your work.

Solutions

Expert Solution

As per 28/36 rule, an individual can spend a mximum of 28% of his gross income on his housing debt including housing expenses. And a maximum of 36% of his gross income on total debt which includes housing, car and other debt services.

Annual Gross income = $45,000

Annual Auto payment =$675 per month*12

= $8100

Property taxes & homeowners insurance = $3000 annually

Down-payment = 20%

a). Calculating the maximum purchase price for a home can Duane afford:-

Since, Duane is paying auto debt payments he will be covered in 36% rule.

Maximum debt service amount = Annual Gross income*36%

=$45,000*36%

= $16200

Debt payment available for housing loan = $16200 - $8100 - $3000

= $5100

Monthly home loan payment = $ 5100/12

= $425

Using, the monthly payment to calculate the Home loan amount:-

where, P = loan amount

r = Periodic Interest rate =7.5%/12 = 0.625%

n= no of periods =30yrs*12 = 360

EMI = monthly payment = $425

P = $ 60782.49

Loan amount = $ 60782.49

Down-payment = 20%

Maximum purchase price of home = Loan amount/(1-Down-payment)

= $60782.49/(1-0.20)

= $ 75,978.11

So, maximum purchase price for a home can Duane afford is $ 75,978.11

b). Calculating the maximum purchase price for a home can Duane afford:-

Since, Duane pays off his auto loan thereby eliminating the $675 monthly payments and therafter he has only housing debt payment and its related expenses to pay, thus he will be covered in 28% rule.

Maximum debt service amount = Annual Gross income*28%

=$45,000*28%

= $12,600

Debt payment available for housing loan = $12600 - $3000

= $9600

Monthly home loan payment = $9600/12

= $800

Using, the monthly payment to calculate the Home loan amount:-

where, P = loan amount

r = Periodic Interest rate =7.5%/12 = 0.625%

n= no of periods =30yrs*12 = 360

EMI = monthly payment = $800

P = $ 114414.10

Loan amount = $ 114414.10

Down-payment = 20%

Maximum purchase price of home = Loan amount/(1-Down-payment)

= $114414.10/(1-0.20)

= $ 143,017.62

So, maximum purchase price for a home can Duane afford is $ 143,017.62

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating


Related Solutions

John plans to borrow $400,000 15-years mortgage loan from his bank, which agrees that      John...
John plans to borrow $400,000 15-years mortgage loan from his bank, which agrees that      John should repay the loan in 180 equal end-of-month payments. The annual interest      rate is 4%, compounded monthly.         (1) What is the amount of each monthly payment? Show your calculation. (2) How much total interest dollar amount will John pay over the 180 months life of the        loan?   Show your calculation (3) Complete the following loan amortization schedule for the first 6...
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 5 years. How much will Sarah still owe on her house? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $____
Sarah secured a bank loan of $175,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $175,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time?
Sarah secured a bank loan of $165,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $165,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $
A family takes out a mortgage for $277,400.00 from the local bank. The loan is for...
A family takes out a mortgage for $277,400.00 from the local bank. The loan is for 30 years of monthly payments at a 4.32% APR (monthly compounding). What will the family’s balance be on the mortgage after 6.00 years?
A borrower takes out a 28-year adjustable rate mortgage loan for $451,185 with monthly payments. The...
A borrower takes out a 28-year adjustable rate mortgage loan for $451,185 with monthly payments. The first two years of the loan have a "teaser" rate of 4%; after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be?
AWL also received a $10,000,000 mortgage at 4% was received from the bank on February 28,...
AWL also received a $10,000,000 mortgage at 4% was received from the bank on February 28, 20X1 to pay for the warehouse. The mortgage required monthly payments of $101,246 on the last day of each month commencing March 31, 20X1. We calculated at the end of the period AWL had a mortgage payable of xx Payment Interest Principal Balance Feb28 100,000 Mar31 101,246 33,333 67,913 9,932,087 Apr30 101,246 33,107 68,139 9,863,948 May31 101,246 32,880 68,366 9,795,582 June30 101,246 .. .....
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge...
You have borrowed $56000 as a mortgage loan to buy a house. The bank will charge interest at the rate of 9% annually and requires a minimum monthly payment of $500. At the end of five years, you must pay off the entire mortgage by a “balloon payment”. You plan to pay only the minimum amount each month and then pay off the loan with the final payment. Find this balloon payment. (Answer: $49966.07) please answer in excel format
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT