In: Accounting
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.
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 SolutionsAn $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
Latest Questions
ADVERTISEMENT
|