Question

You have a 30 year $150,000 loan at 7% interest, monthly payments. Fifteen years later, you...

You have a 30 year $150,000 loan at 7% interest, monthly payments. Fifteen years later, you have the chance to refinance with a 15 year mortgage at 6%. However, the fees charged to make this happen are $2500. What is the return on the $2500 "investment" if you expect to remain in the home for the next 15 years? The answer is 28.89% but im not sure how they got that.

Homework Answers

Answer #1

Using calculator:
Step 1: Original Monthly Payment
N=12*30
PV=-150000
I/Y=7%/12
FV=0
CPT PMT=997.953742768775

Step 2: Loan Outstanding
PMT=997.953742768775
PV=-150000
FV=0
I/Y=7%/12
N=12*15
CPT FV=111028.299301527

Step 3: New Monthly Payment
PV=-111028.299301527
I/Y=6%/12
N=12*15
FV=0
CPT PMT=936.919884722007

Step 4: Return on Investment
FV=0
N=12*15
PV=-2500
PMT=997.953742768775-936.919884722007=61.03385805
CPT I/Y=2.407%
Hence, return=2.407%*12=28.89%

ALTERNATIVELY Use the below formula in excel:
=RATE(15*12,PMT(7%/12,12*30,-150000)-PMT(6%/12,12*15,FV(7%/12,12*15,-PMT(7%/12,12*30,-150000),150000)),-2500,0)*12
=28.89%

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 borrower has secured a 30 year, $150,000 loan at 7% with monthly payments. Fifteen years...
A borrower has secured a 30 year, $150,000 loan at 7% with monthly payments. Fifteen years later, the borrower has the opportunity to refinance with a fifteen year mortgage at 6%. However, the up front fees, which will be paid in cash, are $2,500. What is the return on investment if the borrower expects to remain in the home for the next fifteen years? (A) 6.00% (B) 7.00% (C) 13.00% (D) 22.62% (E) 28.89%
A borrower has secured a 30 year, $170,000 loan at 7% with monthly payments. Fifteen years...
A borrower has secured a 30 year, $170,000 loan at 7% with monthly payments. Fifteen years later, the borrower has the opportunity to refinance with a fifteen year mortgage at 5.75%. However, the up front fees, which will be paid in cash, are $3,500. What is the return on investment if the borrower expects to remain in the home for the next fifteen years? 20.50% 7.00% 29.12% 22.62% 28.89%
1. A borrower has secured a 30 year, $100,000 loan at 8%.  Fifteen years later, the borrower...
1. A borrower has secured a 30 year, $100,000 loan at 8%.  Fifteen years later, the borrower has the opportunity to refinance with a fifteen year mortgage at 7%.  However, the up-front fees, which will be paid in cash, are $2,000.   What is the monthly payment on the initial loan?   What is the loan balance at the time of refinancing?   What is the return on investment if the borrower expects to remain in the home for the next fifteen years after refinancing?  ...
A borrower obtains a $150,000 reverse annuity mortgage with monthly payments over 10 years.  If the interest...
A borrower obtains a $150,000 reverse annuity mortgage with monthly payments over 10 years.  If the interest rate of the mortgage loan is 8%, what is the monthly payment received by the borrower? (A) $820 $863 $1,250 $1,820 Answer is A. PLease help me explain how they got it using financial calculator step
A borrower obtains a $150,000 reverse annuity mortgage with monthly payments over 10 years. If the...
A borrower obtains a $150,000 reverse annuity mortgage with monthly payments over 10 years. If the interest rate of the mortgage loan is 8%, what is the monthly payment received by the borrower? $820 $863 $1,250 $1,820 Correct answer is A monthly rate: 8/12=.66667% number of month = 10*12=120 monthly payment =future value/FVA .66667%,120                   = 150000/182.95             = $ 819.90 Per month (approx 820) **you can find future value annuity factor using financial calculator This explanation is so confusing...
On a $150,000 home loan, Jared can either finance at 6.13% for 15 years or 30...
On a $150,000 home loan, Jared can either finance at 6.13% for 15 years or 30 years. they would make monthly payments. find their payments for the 15 year loan and for the 30 year loan. how much interest would be saved with the 15 year loan over the 30 year loan?
You are planning to buy a $200,000 house using a 30-year mortgage that requires equal monthly...
You are planning to buy a $200,000 house using a 30-year mortgage that requires equal monthly payments starting one month from today. Annual interest rate is 6.6%, compounded monthly. Calculate your monthly payments. How much have you paid off the mortgage after 10 years? Suppose you are planning to refinance this mortgage after 10 years at an annual interest of 4.8%, compounded monthly, for the remainder of the term. However, you are going to be charged a 10% prepayment fee....
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with...
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with an interest rate of 7%, compounded monthly. You borrow a total of $250,000. Given this, by the time you pay off the loan, how much in total (interest + principal) would the house cost you? (20 pts) 3.   How, reconsider the previous problem. Suppose you pay the mortgage according to those specifications (7% APR, monthly) for the first 10 years, but then you refinance...
You have a mortgage loan of $310,000 with monthly payments. The monthly interest rate is 0.1%....
You have a mortgage loan of $310,000 with monthly payments. The monthly interest rate is 0.1%. (a) Model the mortgage with a dynamical system, where your payment is ? dollars per month. (b) If the payment is $1,800 per month, how much is still due after 120 payments? (c) What monthly payment ? will have the loan paid out in exactly 25 years?
(a) After making payments of $911.10 for 6 years on your 30-year loan at 8.1%, you...
(a) After making payments of $911.10 for 6 years on your 30-year loan at 8.1%, you decide to sell your home. What is the loan payoff? (Round your answer to two decimal places.) (b) A homeowner has a mortgage payment of $995.10, an annual property tax bill of $592, and an annual fire insurance premium of $280. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.) (c) Suppose you...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT