Question

Consider two ways of getting a mortgage on a house worth $750,000. You plan to make...

Consider two ways of getting a mortgage on a house worth $750,000. You plan to make a down payment of $300,000 at closing. You need to borrow the rest of the $450,000. The first option is a 15 year fixed-rate mortgage at a 5.25% effective annual interest rate (assume monthly compounding with 12 payments per year to get a monthly interest rate). In the second option, you can “buy” a lower effective annual interest rate of 4.5% by paying the bank an additional $25,000 cash at closing (also assume 12 monthly payments over the year with monthly compounding). You are still borrowing $450,000, but now you are paying an additional $25,000 in cash up front at origination (this is commonly called paying “points” on a mortgage). All other costs are the same under both options.

a)Using the monthly interest rate over 180 payments, what would your monthly payment be under the first scenario?

b) Using the monthly interest rate over 180 payments, what would be your monthly payment under the second scenario?

c) Show which option is better.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a]

Monthly payment is calculated using PMT function in Excel :

rate = 5.25% / 12 (converting annual rate into monthly rate)

nper = 180

pv = 450000 (loan amount)

PMT is calculated to be $3617.45

b]

Monthly payment is calculated using PMT function in Excel :

rate = 4.5% / 12 (converting annual rate into monthly rate)

nper = 180

pv = 475000 (loan amount + additional upfront cash)

PMT is calculated to be $3633.72

c]

The first option is better as the monthly payment is lower

Add a comment
Know the answer?
Add Answer to:
Consider two ways of getting a mortgage on a house worth $750,000. You plan to make...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 9. You plan to purchase a house for $250,000 using a 30-year mortgage obtained from your...

    9. You plan to purchase a house for $250,000 using a 30-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price and monthly payments. You will not pay off the mortgage early. Your bank offers you the following two options for payment: i blaivini l Option1: Mortgage rate of 5.25 percent and I point. Option2: Mortgage rate of 5 percent and 2.5 points. bloy Trolovi po brol a. Calculate your...

  • Q1. You purchase a house for $750,000, you are able to make a down payment constituting...

    Q1. You purchase a house for $750,000, you are able to make a down payment constituting 1/3 of the cost of the house and take a mortgage to cover the rest. The mortgage you negotiate with the bank is a 30 year, 5% mortgage compounded semi-annually, and you make monthly mortgage payments. a) Under these terms, what is your monthly mortgage payment? b) Assuming that you can only afford monthly payments of $2500. Given the same rate above (5% mortgage...

  • rate of 5.25%, 1 Lender I offers you a fixed rate 15-year mortgage at an annual...

    rate of 5.25%, 1 Lender I offers you a fixed rate 15-year mortgage at an annual interes compounded monthly, with no points a. F ind your monthly payments under this option. b. Find the total amount of money paid to the lender. c. Find the total amount of interest you will pay over the life of the loan. 2. Lender II offers you a fixed rate 30-year mortgage at an annual interest rate of 5.75%, compounded monthly, with one point...

  • Suppose that you are purchasing a house (loan amount = $200,000) and inquire about the terms...

    Suppose that you are purchasing a house (loan amount = $200,000) and inquire about the terms for a 30-year fixed-rate mortgage. LOAN B: annual interest rate of 3.625% with monthly payments and compounding 1.25 discount points origination fee of 1% $18 in third-party closing costs What is the EBC for the loan if we prepay at the end of the third year?

  • Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months...

    Suppose your friend April is considering to refinance her mortgage. She bought her house 60 months ago. The amount of loan equals 154,00. She paid cash to cover the 5% down payment plus all required closing costs (closing costs include application fee, appraisal fee, loan origination fees and other costs, usually about 3%-5% of the loan amount). Since she had a decent credit history and relatively stable income, her mortgage rate was 5.25% for 30 years at the time of...

  • A house is for sale for $360,000. You have a choice of two 25-year mortgage loans...

    A house is for sale for $360,000. You have a choice of two 25-year mortgage loans with monthly payments: (1) if you make a down payment of 10%, you can obtain a loan with a 6% rate of interest or (2) if you make a down payment of 20%, you can obtain a loan with a 5% rate of interest. What is the effective annual rate of interest on the additional 10% of house value borrowed on the first loan?...

  • You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with...

    You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with monthly payments. A. Assume that you have good credit, and can borrow money at a 3.75% annual interest rate. What will your monthly payment be? B. Now, assume that you have lousy credit, and must pay a 6.5% annual interest rate to obtain a mortgage. What will your monthly payment be? C. Having lousy credit can be costly. How much additional interest will you...

  • need help thanks! Suppose that you have just borrowed $250,000 in the form of a 30...

    need help thanks! Suppose that you have just borrowed $250,000 in the form of a 30 year mortgage. The loan has an annual interest rate of 9% with monthly payments and monthly compounding. a. What will your monthly payment be for this loan? b. What will the balance on this loan be at the end of the 12th year? How much interest will you pay in the 7th year of this loan? d. How much of the 248th payment will...

  • Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan...

    Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...

  • Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for...

    Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for 30 years, monthly payments. The lender will charge you two discount points and the loan has a 3% prepayment penalty. A. (1 pt) What is the annual percentage rate (APR) of the loan? Answer: _______ B. (1 pt) How many points are required to yield an APR of 5.25%? Answer: _______ Suppose you take a fixed-rate mortgage for $200,000 at 5.00% for 30 years,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT