Question

In: Finance

You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...

You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $2,356 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is ​7.500% (APR). How much do you owe on the mortgage​ today? ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) The amount you owe today is ​$___

Solutions

Expert Solution

Loan amount = PV of EMIs.

PV of Annuity:

Annuity is series of cash flows that are deposited at regular intervals for specific period of time. Here cash flows are happened at the end of the period. PV of annuity is current value of cash flows to be received at regular intervals discounted at specified int rate or discount rate to current date.

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
r - Int rate per period
n - No. of periods

Particulars Amount
Cash Flow $            2,356.00
Int Rate 0.6250%
Periods 360

PV of Annuity = Cash Flow * [ 1 - [(1+r)^-n]] /r
= $ 2356 * [ 1 - [(1+0.0063)^-360]] /0.0063
= $ 2356 * [ 1 - [(1.0063)^-360]] /0.0063
= $ 2356 * [ 1 - [0.1061]] /0.0063
= $ 2356 * [0.8939]] /0.0063
= $ 336949.53
Loan Outstanding after 56 Months ( ( 4 *12 )+ 8 ):

Particulars Amount
Loan Amount $ 336,949.53
Int rate per Month 0.6250%
No. of Months 360
Outstanding Bal after 56
EMI $      2,356.00
Payments Left 304

Outstanding Bal = Instalment * [ 1 - ( 1 + r )^ - n ] / r
= $ 2356 * [ 1 - ( 1 + 0.00625 ) ^ - 304 ] / 0.00625
= $ 2356 * [ 1 - ( 1.00625 ) ^ - 304 ] / 0.00625
= $ 2356 * [ 1 - 0.150456 ] / 0.00625
= $ 2356 * [ 0.849544 ] / 0.00625
= $ 320244.11

r = Int Rate per period
n = Balance No. of periods

Mortgage balance after 56 Months is $ 320244.11


Related Solutions

You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $2,356 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is ​6.750% (APR). How much do you owe on the mortgage​ today? ​(Note: Be careful not to...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $ 3 comma 093$3,093 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is 6.404 %6.404% ​(APR). How much do you owe on the mortgage​ today? The...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $1,850 and you have made every payment on time. The original term of the mortgage was 30 years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is 5.750% (APR). How much do you owe on the mortgage today? The amount you owe today...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $2,356 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is 6.375% ​(APR). How much do you owe on the mortgage​ today? ​(Note: Be careful not to...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $2,356 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is 6.375% ​(APR). How much do you owe on the mortgage​ today? ​(Note: Be careful not to...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is $1,850 and you have made every payment on time. The original term of the mortgage was 30​ years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is 7.500% ​(APR). How much do you owe on the mortgage​ today?
You have decided to refinance your mortgage. You plan to borrowwhatever is outstanding on your...
You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current monthly payment is$3,120and you have made every payment on time. The original term of the mortgage was 30 years, and the mortgage is exactly four years and eight months old. You have just made your monthly payment. The mortgage interest rate is6.750%(APR). How much do you owe on the mortgage today?
4)Given the recent drop in mortgage interest rates, you have decided to refinance your home. Exactly...
4)Given the recent drop in mortgage interest rates, you have decided to refinance your home. Exactly five years ago, you obtained a $550,000, 30-year mortgage loan (L1) with a fixed rate of 5.5%. Today, you can get a 30-year loan for the currently outstanding loan balance at 3.75% interest. This loan (L2), however, requires you to pay $3,000 in front-end fees and 2 points at the time of the refinancing (1 point equals 1% of the amount borrowed). Ignore tax...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) How much do you owe the bank after the 60th payment? (b) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? d) What is the present value of the interest portion of the...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is...
You plan to borrow $500,000 to buy a house. The amortization period of the mortgage is 20 years. You obtain a 5-year fixed rate mortgage from TD bank at 2%/year (using Canadian mortgage convention). (a) What is your monthly payment? (b) How much do you owe the bank after the 60th payment? (c) For the 24th monthly payment, how much of it is for interest, and how much of it is for principal repayment? (d) What is the present value...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT