Question

In: Accounting

A $425,000 mortgage with a 3-year term is amortized over 25 years at an interest rate...

A $425,000 mortgage with a 3-year term is amortized over 25 years at an interest rate of 8.2% compounded semi-annually. If payments are made at the end of each month, determine the mortgage balance at the end of the 3-year term.

Solutions

Expert Solution

First of all we need to understand mortgage term and Amortization term.

Mortgage term is the period during which person need to pay to the agreeing term .

but amortisation term is the period at the end of which balance dur amount will be zero.

EMI = (principal* intt rate*(1+r)^n)/(1+r)^n-1
Principal 425000
N 50 semi annually
r 4.1% semi annually
power of 1.041 value
2 1.083681 EMI (425000*0.041*7.46)/(7.46-1)
3 1.128112 20122.37
4 1.174365
5 1.222513 Half Year EMI Interest Principal O/S balance
6 1.272637 0 425000
7 1.324815 1 20122.37 17425 2697.37 422302.63
8 1.379132 2 20122.37 17314.41 2807.96 419494.67
9 1.435676 3 20122.37 17199.28 2923.09 416571.58
10 1.494539 4 20122.37 17079.43 3042.94 413528.64
11 1.555815 5 20122.37 16954.67 3167.70 410360.95
12 1.619604 6 20122.37 16824.8 3297.57 407063.38
13 1.686007
14 1.755134 Balance after 3 year would be = 407063.38$
15 1.827094
16 1.902005
17 1.979987
18 2.061167
19 2.145675
20 2.233647
21 2.325227
22 2.420561
23 2.519804
24 2.623116
25 2.730664
26 2.842621
27 2.959169
28 3.080494
29 3.206795
30 3.338273
31 3.475142
32 3.617623
33 3.765946
34 3.92035
35 4.081084
36 4.248408
37 4.422593
38 4.60392
39 4.79268
40 4.98918
41 5.193736
42 5.40668
43 5.628354
44 5.859116
45 6.09934
46 6.349413
47 6.609739
48 6.880738
49 7.162848

Related Solutions

An $600,000 Mortgage is amortized by monthly payments over 25 years. The interest rate charged is...
An $600,000 Mortgage is amortized by monthly payments over 25 years. The interest rate charged is 4% compounded semi-annually. 1.What is the size of the monthly payment to the nearest dollars? 2.How much interest paid in the first payment? 3.What is the outstanding balance after the first payment?
You have just negotiated a 3-year mortgage on 500,000 amortized over 25 years at rate fo...
You have just negotiated a 3-year mortgage on 500,000 amortized over 25 years at rate fo 6%. Assuming after three years the mortgage rate changes to 5%, what will your new monthly payments? (Hint: Canadian banks quote mortgage rates as a rate per year compounded semi-annually.)
A mortgage is set up for $115000 and is amortized over 25 years at 7.95% interest....
A mortgage is set up for $115000 and is amortized over 25 years at 7.95% interest. Approximate the following payments:) a) monthly b) semi-monthly c) weekly d) biweekly e) accelerated weekly
You have just negotiated a 5-year mortgage on $400,000 amortized over 25 years at a rate...
You have just negotiated a 5-year mortgage on $400,000 amortized over 25 years at a rate of 3.5%. After 5 years assume that the mortgage rate remains the same, but you increase the payments by 500 dollars per month, in how many periods (months) will you be able to pay the whole amount. please show all steps for answer.
You have just negotiated a 5-year mortgage on $400,000 amortized over 25 years at a rate...
You have just negotiated a 5-year mortgage on $400,000 amortized over 25 years at a rate of 3.5%. After 5 years assume that the mortgage rate remains the same, but you increase the payments by 500 dollars per month, in how many periods (months) will you be able to pay the whole amount. (Hint: Canadian banks quote mortgage rates as a rate per year compounded semi-annually)
The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest...
The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest for the first five years was 4.3% compounded semi-annually. a. Determine the Grewals’ monthly payments. b. Determine the balance owing after the 5-year term. c. Before renewing for another term of 5 years at 4.5% compounded semiannually, the Grewals make an additional payment of $21,000. If they keep the same monthly payments, by how much will the amortization period be shortened? note; sir i...
A $ 120 000.00 mortgage is amortized over 20 years. If interest on the mortgage is...
A $ 120 000.00 mortgage is amortized over 20 years. If interest on the mortgage is 6.5% compounded semi-annually, calculate the size of monthly payments made at the end of each month.
You have just negotiated a 5 year mortgage on $100,000 amortized over 25 years at a...
You have just negotiated a 5 year mortgage on $100,000 amortized over 25 years at a rate of 5%. After 5 years of payments, assume that the mortgage rate remains the same, but you change your monthly payment to $1500. If you change your payment, how many more periods will it take you to pay off the remaining loan balance?
A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...
A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 5.1% compounded semi-annually for a six-year term. ​(a) Compute the size of the monthly payment. ​(b) Determine the balance at the end of the six-year term. ​(c) If the mortgage is renewed for a six-year term at 6​% compounded semi-annually, what is the size of the monthly payment for the renewal​ term? ​(a) The size of the monthly payment is ​$__. ​(Round the final...
A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...
A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 8.6% compounded semi-annually for a six​-year term. ​(a)Compute the size of the monthly payment. ​(b) Determine the balance at the end of the six-year term. ​(c)If the mortgage is renewed for a six-year term at 6​% compounded semi-annually, what is the size of the monthly payment for the renewal​ term? ​(a) The size of the monthly payment is $__.(Round the final answer to the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT