Question

In: Finance

You are considering two payment options on a $500,000 20-year mortgage having an interest rate of...

You are considering two payment options on a $500,000 20-year mortgage having an interest rate of 2.8% compounded monthly. The first option is to make monthly payments at the start of each month, while the second option is to make payments at the end of each month. How much interest will be saved by choosing the first option ?

Solutions

Expert Solution

Step 1 : Monthly payment under first option
Present Value Of An Annuity Due
=C + C*[1-(1+i)^-(n-1)]/i]
Where,
C= Cash Flow per period
i = interest rate per period
n=number of period
500000= C+C[ 1-(1+0.002333333)^-(240-1) /0.002333333]
500000= C+C[ 1-(1.002333333)^-239 /0.002333333]
500000= C+C[ (0.4271) ] /0.002333333
C = 2716.86
Monthly payment = $2716.86
Step 2: Monthly payment under Second option
Present Value Of An Annuity
= C*[1-(1+i)^-n]/i]
Where,
C= Cash Flow per period
i = interest rate per period
n=number of period
500000= C[ 1-(1+0.00233333)^-240 /0.00233333]
500000= C[ 1-(1.00233333)^-240 /0.00233333]
500000= C[ (0.4284) ] /0.00233333
C = 2723.19
Monthly payment = 2723.19
Step 3 : Interest saved
= Total Payment under option 2 - total payment under option 1
= ($2723.19*240)-($2716.86*240)
=1519.20
= Or 1521.23 ( if no intermediate rounding off)

Related Solutions

You have two options for a 30 year fixed rate mortgage: $500,000 mortgage, 5% rate $500,000...
You have two options for a 30 year fixed rate mortgage: $500,000 mortgage, 5% rate $500,000 mortgage, 4.50% rate, 2 discount points For how long must the mortgage remain in effect for you to choose the lower rate and pay the discount points
A borrower takes out a 20-year mortgage for $500,000 with an interest rate of 6%. The...
A borrower takes out a 20-year mortgage for $500,000 with an interest rate of 6%. The loan requires monthly payments and has a 3% fee if the loan is repaid within 10 years. What is the effective interest rate on the loan if the borrower repays the loan after 72 payments?
A borrower takes out a 20-year mortgage for $500,000 with an interest rate of 6%. The...
A borrower takes out a 20-year mortgage for $500,000 with an interest rate of 6%. The loan requires monthly payments and has a 3% fee if the loan is repaid within 10 years. What is the effective interest rate on the loan if the borrower repays the loan after 72 payments?
Consider a 15 year mortgage with a 3% APR interest rate and a 20% down payment...
Consider a 15 year mortgage with a 3% APR interest rate and a 20% down payment if you can afford a $1500 monthly payment, how expensive a house can you buy? a. $254,250 b. $217,208 c. $271,510 d. $298,402
Mortgage Payment You currently have a 30-year fixed rate mortgage with an annual interest rate of...
Mortgage Payment You currently have a 30-year fixed rate mortgage with an annual interest rate of 6%. You have had the mortgage 4 years, and on September 1, 2015 you made your 48th payment. The original principal amount was $280,000 and you monthly payment, without taxes and insurance, are $1,678.74 per month, computed using the Excel function =PMT(0.5%,360,280000,0,0). Starting with your original mortgage your banker calls and says that you could refinance your existing mortgage (6% rate, 30-year original term)...
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately...
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately after your 12th payment, you make an additional principal repayment of $50,000, and then refinance the outstanding balance with a new 15-yeatr mortgage at a 4% effective annual interest rate. Both mortgages require annual year-end level amortization payments. Find the amount of interest in the 5th payment of the new mortgage. PLEASE NO EXCEL!!!! :)
You are considering investment in one of the following two options. Assume an interest rate of...
You are considering investment in one of the following two options. Assume an interest rate of 12% per year, compounded monthly. Option A & Option B Initial Cost, respectively -$100,000 -$800,000 Quarterly Maintenance Cost, respectively -$26,000 -$15,000 Salvage Value, respectively $16,000 $200,000 Lifespan (years) 2 & 4, respectively a. What is the effective monthly interest rate? b. What is the effective quarterly interest rate (to 2 decimal places)? c. Draw cash flow diagrams for the two projects. d. Calculate the...
Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly...
Calculating the Payment for a Constant Payment Mortgage (CPM) $100000 Mortgage 5% Interest 20 Years Monthly Payments If he wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? Present Value Method
For a 20 year mortgage of $150,000 at 7.5% interest, one additional payment $5000is pai in...
For a 20 year mortgage of $150,000 at 7.5% interest, one additional payment $5000is pai in mortgage after 2 years of making regular payments. How many monthly payments will be eliminated from the amortization becasue of this additional payments?
Suppose you obtain a 20-year mortgage loan of $197,000 at an annual interest rate of 8.2%....
Suppose you obtain a 20-year mortgage loan of $197,000 at an annual interest rate of 8.2%. The annual property tax bill is $978 and the annual fire insurance premium is $491. Find the total monthly payment for the mortgage, property tax, and fire insurance. (Round your answer to the nearest cent.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT