Question

In: Finance

A 25 years $500000 mortgage at 4.30% compounded semi annually is repaid with monthly payment what...

A 25 years $500000 mortgage at 4.30% compounded semi annually is repaid with monthly payment what is size of monthly payment and balance of mortgage at end of 6 years and how much did the amortization period shorten by if the monthly payment are increased by $125 at end of year six?

Solutions

Expert Solution

At the end of year 6 the Principle balance is $423,325.97, the monthly installments are $2,711.49 from Month 1 to 72.

Payment Number Payment Principal Interest Balance
1 $             -2,711.49 $                      -936.49 $                  -1,775.00 $ 499,063.51
2 $             -2,711.49 $                      -939.82 $                  -1,771.68 $ 498,123.69
3 $             -2,711.49 $                      -943.15 $                  -1,768.34 $ 497,180.54
4 $             -2,711.49 $                      -946.50 $                  -1,764.99 $ 496,234.04
5 $             -2,711.49 $                      -949.86 $                  -1,761.63 $ 495,284.18
6 $             -2,711.49 $                      -953.23 $                  -1,758.26 $ 494,330.95
7 $             -2,711.49 $                      -956.62 $                  -1,754.87 $ 493,374.33
8 $             -2,711.49 $                      -960.01 $                  -1,751.48 $ 492,414.32
9 $             -2,711.49 $                      -963.42 $                  -1,748.07 $ 491,450.90
10 $             -2,711.49 $                      -966.84 $                  -1,744.65 $ 490,484.06
11 $             -2,711.49 $                      -970.27 $                  -1,741.22 $ 489,513.79
12 $             -2,711.49 $                      -973.72 $                  -1,737.77 $ 488,540.07
13 $             -2,711.49 $                      -977.17 $                  -1,734.32 $ 487,562.90
14 $             -2,711.49 $                      -980.64 $                  -1,730.85 $ 486,582.26
15 $             -2,711.49 $                      -984.12 $                  -1,727.37 $ 485,598.13
16 $             -2,711.49 $                      -987.62 $                  -1,723.87 $ 484,610.51
17 $             -2,711.49 $                      -991.12 $                  -1,720.37 $ 483,619.39
18 $             -2,711.49 $                      -994.64 $                  -1,716.85 $ 482,624.75
19 $             -2,711.49 $                      -998.17 $                  -1,713.32 $ 481,626.58
20 $             -2,711.49 $                   -1,001.72 $                  -1,709.77 $ 480,624.86
21 $             -2,711.49 $                   -1,005.27 $                  -1,706.22 $ 479,619.59
22 $             -2,711.49 $                   -1,008.84 $                  -1,702.65 $ 478,610.74
23 $             -2,711.49 $                   -1,012.42 $                  -1,699.07 $ 477,598.32
24 $             -2,711.49 $                   -1,016.02 $                  -1,695.47 $ 476,582.30
25 $             -2,711.49 $                   -1,019.62 $                  -1,691.87 $ 475,562.68
26 $             -2,711.49 $                   -1,023.24 $                  -1,688.25 $ 474,539.44
27 $             -2,711.49 $                   -1,026.88 $                  -1,684.62 $ 473,512.56
28 $             -2,711.49 $                   -1,030.52 $                  -1,680.97 $ 472,482.04
29 $             -2,711.49 $                   -1,034.18 $                  -1,677.31 $ 471,447.86
30 $             -2,711.49 $                   -1,037.85 $                  -1,673.64 $ 470,410.01
31 $             -2,711.49 $                   -1,041.54 $                  -1,669.96 $ 469,368.47
32 $             -2,711.49 $                   -1,045.23 $                  -1,666.26 $ 468,323.24
33 $             -2,711.49 $                   -1,048.94 $                  -1,662.55 $ 467,274.30
34 $             -2,711.49 $                   -1,052.67 $                  -1,658.82 $ 466,221.63
35 $             -2,711.49 $                   -1,056.40 $                  -1,655.09 $ 465,165.23
36 $             -2,711.49 $                   -1,060.15 $                  -1,651.34 $ 464,105.07
37 $             -2,711.49 $                   -1,063.92 $                  -1,647.57 $ 463,041.15
38 $             -2,711.49 $                   -1,067.69 $                  -1,643.80 $ 461,973.46
39 $             -2,711.49 $                   -1,071.49 $                  -1,640.01 $ 460,901.97
40 $             -2,711.49 $                   -1,075.29 $                  -1,636.20 $ 459,826.69
41 $             -2,711.49 $                   -1,079.11 $                  -1,632.38 $ 458,747.58
42 $             -2,711.49 $                   -1,082.94 $                  -1,628.55 $ 457,664.64
43 $             -2,711.49 $                   -1,086.78 $                  -1,624.71 $ 456,577.86
44 $             -2,711.49 $                   -1,090.64 $                  -1,620.85 $ 455,487.22
45 $             -2,711.49 $                   -1,094.51 $                  -1,616.98 $ 454,392.71
46 $             -2,711.49 $                   -1,098.40 $                  -1,613.09 $ 453,294.31
47 $             -2,711.49 $                   -1,102.30 $                  -1,609.19 $ 452,192.02
48 $             -2,711.49 $                   -1,106.21 $                  -1,605.28 $ 451,085.81
49 $             -2,711.49 $                   -1,110.14 $                  -1,601.35 $ 449,975.67
50 $             -2,711.49 $                   -1,114.08 $                  -1,597.41 $ 448,861.59
51 $             -2,711.49 $                   -1,118.03 $                  -1,593.46 $ 447,743.56
52 $             -2,711.49 $                   -1,122.00 $                  -1,589.49 $ 446,621.56
53 $             -2,711.49 $                   -1,125.98 $                  -1,585.51 $ 445,495.58
54 $             -2,711.49 $                   -1,129.98 $                  -1,581.51 $ 444,365.59
55 $             -2,711.49 $                   -1,133.99 $                  -1,577.50 $ 443,231.60
56 $             -2,711.49 $                   -1,138.02 $                  -1,573.47 $ 442,093.58
57 $             -2,711.49 $                   -1,142.06 $                  -1,569.43 $ 440,951.52
58 $             -2,711.49 $                   -1,146.11 $                  -1,565.38 $ 439,805.41
59 $             -2,711.49 $                   -1,150.18 $                  -1,561.31 $ 438,655.23
60 $             -2,711.49 $                   -1,154.26 $                  -1,557.23 $ 437,500.96
61 $             -2,711.49 $                   -1,158.36 $                  -1,553.13 $ 436,342.60
62 $             -2,711.49 $                   -1,162.47 $                  -1,549.02 $ 435,180.13
63 $             -2,711.49 $                   -1,166.60 $                  -1,544.89 $ 434,013.53
64 $             -2,711.49 $                   -1,170.74 $                  -1,540.75 $ 432,842.78
65 $             -2,711.49 $                   -1,174.90 $                  -1,536.59 $ 431,667.88
66 $             -2,711.49 $                   -1,179.07 $                  -1,532.42 $ 430,488.81
67 $             -2,711.49 $                   -1,183.26 $                  -1,528.24 $ 429,305.56
68 $             -2,711.49 $                   -1,187.46 $                  -1,524.03 $ 428,118.10
69 $             -2,711.49 $                   -1,191.67 $                  -1,519.82 $ 426,926.43
70 $             -2,711.49 $                   -1,195.90 $                  -1,515.59 $ 425,730.53
71 $             -2,711.49 $                   -1,200.15 $                  -1,511.34 $ 424,530.38
72 $             -2,711.49 $                   -1,204.41 $                  -1,507.08 $ 423,325.97

New Monthly payment amount = $2,836.49. The remaining amortization period is 212.95 months or 17.75 years approx. The amortization period has been shortened by 1.25 years.

Formula used =NPER(EffRate/12,Payment, -Principal)


Related Solutions

A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is...
A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $275 at the end of year six?
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is...
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $100 at the end of year six?
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a....
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a. What is the size of the monthly payments ? Round to the nearest cent. b. Find the balance of the mortgage at the end of 5 years 00 Round to the nearest cent c. By how much did the amortization period shorten by if the monthly payments are increased by $ 200 at the end of year five
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the...
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the end of every 6 months. The loan was settled in 4 years. a. Calculate the size of the periodic payment. $3,406.15 $4,200.70 $3,786.54 $4,276.00 b. Calculate the total interest paid. $3,142.32 $30,292.32 -$644.22 $6,928.86
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over...
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over 10 years. a) What will be the principal component of the sixth payment? b) What will be the interest component of the sixteenth payment? c) How much will Payments 6 to 15 inclusive reduce the principal? d) How much interest will be paid in the third year? e) What will be the final payment?
A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid...
A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid by payments of $ 937.00 made at the end of every three months. ​(a) How many payments will be required to amortize the​ loan? ​(b) If the loan is repaid in full in 2 years​, what is the payout​ figure? ​(c) If paid​ out, what is the total cost of the​ loan? ​(a) The number of payments required to amortize the loan is nothing....
If a loan was repaid by semi-annual payments of $4710.00 in 6.5 years at 8.34% compounded...
If a loan was repaid by semi-annual payments of $4710.00 in 6.5 years at 8.34% compounded quarterly, how much interest was paid?
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (1) Calculate the principal. (2) How much of the principal is paid the first, 5th, 20th and last year? (3) How much interest is paid the first, 5th, 20th and last year year? (4) What is the total amount of money paid during the 30 years? (5) What is the total amount of interest paid during the 30 years? (6) What is...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (5) What is the total amount of interest paid during the 30 years? (6) What is the unpaid balance after 25 years? (7) How much has to be deposited into a savings account with an interest rate of 4% compounded quarterly in order to pay the unpaid balance of the mortgage after 25 years? (8) How much has to be deposited each...
Which of the following options regarding a $200,000 mortgage, compounded semi-annually results in the lowest total...
Which of the following options regarding a $200,000 mortgage, compounded semi-annually results in the lowest total interest payment? A 3.5% interest rate, paid bi-weekly and amortized over 20 years A 3.5% interest rate, paid monthly and amortized over 20 years A 3.25% interest rate, paid monthly and amortized over 22 years A 4% interest rate, paid monthly and amortized over 15 years
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT