Question

A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...

  1. A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is invested monthly?

Homework Answers

Answer #1

Monthly payment without the points

N=360

I/Y=6/12=0.5

PV=-250,000

FV=0

CPT PMT=1,498.8763

Monthly payment with the points

N=360

I/Y =5.5/12=0.45833

PV=-250,000

FV=0

CPT PMT =1,419.47

Monthly payment savings = 1,498.87 - 1,419.47= 79.40

Present Value of Monthly Payment Savings

N=360

I/Y=5.5/12=0.4583

PMT=79.40

FV=0

CPT PV=

13,984.73

The Cost of Points: 0.0225*250,000=5,625

Now, I=5.5/12=0.4583

PMT=79.40

FV=0

PV= -5,625

CPT

N=85.8492 months

N = 85.8492 months / 12 = 7.15years

Know the answer?
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
Similar Questions
a homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
a homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is invested monthly?
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is invested monthly? please show work
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is not invested?
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is not invested? SHOW IN EXCEL PLEASE
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is not invested? show in excel please
show in excel plz A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate...
show in excel plz A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment saving is invested monthly?
A homeowner can obtain a $350,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $350,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.5 points. How long must the owner stay in the house to make it worthwhile to pay the points if the payment savings are invested monthly?
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with...
A homeowner can obtain a $250,000, 30-year fixed-rate mortgage at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. If you will keep the mortgage for 30 years, what is the net present value of paying the points (to the nearest dollar)? please show in excel
A homeowner can obtain on property valued at $250,000, a 30-year fixed-rate mortgage, LTV=90%, at a...
A homeowner can obtain on property valued at $250,000, a 30-year fixed-rate mortgage, LTV=90%, at a rate of 6.0 percent with zero points or at a rate of 5.5 percent with 2.25 points. If she will keep the mortgage for 30 years, what is the net present value of paying the points (to the nearest dollar)?
You are considering the following options on a $250,000 mortgage: 1) A 15-year 3% fixed-rate; 0...
You are considering the following options on a $250,000 mortgage: 1) A 15-year 3% fixed-rate; 0 points 2) A 15-year 2% fixed rate with 2 points How long must you stay in the house to make it worthwhile to pay the points if the payment savings is invested monthly? [Assume that the only savings from paying the points come from the difference in monthly payments between the two options; i.e. ignore the savings from differences in o/s balance at the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT