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.) $____
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
Mortgage loan commercials and bank banners can be a little confusing due to the fact they...
Mortgage loan commercials and bank banners can be a little confusing due to the fact they report two rates: 1) the stated nominal annual rate that we usually think of as APR which is compounded monthly and is the rate that is used on the actual loan amount to determine the monthly payment, and 2) the "APR" which is somewhat higher and in some ads significantly higher than the first rate. This second "APR" is a stated nominal annual rate...
There are three loan officers at farmers National Bank. All decisions on mortgage loans are made...
There are three loan officers at farmers National Bank. All decisions on mortgage loans are made by one of these officers. The president of the bank would like to be sure that the rejection rate is about the same for the three officers. A sample of 200 recent applications yielded the following results. Is the rejection rate related to the officer that processes the loan? Use the 0.05 significance level. Loan Officer Felix    Otis Foxburrow Approved 50 70 55...
The loan department of a bank offers 3 different types of loans: signature, mortgage, and commercial....
The loan department of a bank offers 3 different types of loans: signature, mortgage, and commercial. The following cost and activity estimates are available for the upcoming year: Activity Activity Cost Activity Driver Answering customer questions $ 35,000 customer inquiries Filling out loan application     60,000 pages Loan application processing     30,000 data entry hours Loan analysis & evaluation   100,000 loan dollars Preparation of loan checks     28,000 checks prepared Posting of loan payments     42,000 checks received Total $295,000 The following activity driver...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT