Question

In: Accounting

. A mortgage of $206,500 has an interest rate of 6% for 30 years. (If you...

. A mortgage of $206,500 has an interest rate of 6% for 30 years. (If you wish to use the formula instead of a mortgage table, note that this is 30 years of 12 monthly payments per year). Find the monthly principal and interest payment

Solutions

Expert Solution

Balance 206500
Interest Rate 0.005
Period 360
Monthly Payment ($1,238.07)
Month Installment Principal Interest Balance
1 1238.07 205.57 1032.50 206294.43
2 1238.07 206.60 1031.47 206087.83
3 1238.07 207.63 1030.44 205880.20
4 1238.07 208.67 1029.40 205671.53
5 1238.07 209.71 1028.36 205461.82
6 1238.07 210.76 1027.31 205251.06
7 1238.07 211.81 1026.26 205039.24
8 1238.07 212.87 1025.20 204826.37
9 1238.07 213.94 1024.13 204612.43
10 1238.07 215.01 1023.06 204397.42
11 1238.07 216.08 1021.99 204181.34
12 1238.07 217.16 1020.91 203964.18
13 1238.07 218.25 1019.82 203745.93
14 1238.07 219.34 1018.73 203526.59
15 1238.07 220.44 1017.63 203306.15
16 1238.07 221.54 1016.53 203084.61
17 1238.07 222.65 1015.42 202861.97
18 1238.07 223.76 1014.31 202638.21
19 1238.07 224.88 1013.19 202413.33
20 1238.07 226.00 1012.07 202187.32
21 1238.07 227.13 1010.94 201960.19
22 1238.07 228.27 1009.80 201731.92
23 1238.07 229.41 1008.66 201502.51
24 1238.07 230.56 1007.51 201271.95
25 1238.07 231.71 1006.36 201040.24
26 1238.07 232.87 1005.20 200807.37
27 1238.07 234.03 1004.04 200573.34
28 1238.07 235.20 1002.87 200338.14
29 1238.07 236.38 1001.69 200101.76
30 1238.07 237.56 1000.51 199864.20
31 1238.07 238.75 999.32 199625.45
32 1238.07 239.94 998.13 199385.51
33 1238.07 241.14 996.93 199144.36
34 1238.07 242.35 995.72 198902.01
35 1238.07 243.56 994.51 198658.45
36 1238.07 244.78 993.29 198413.68
37 1238.07 246.00 992.07 198167.68
38 1238.07 247.23 990.84 197920.44
39 1238.07 248.47 989.60 197671.98
40 1238.07 249.71 988.36 197422.27
41 1238.07 250.96 987.11 197171.31
42 1238.07 252.21 985.86 196919.09
43 1238.07 253.47 984.60 196665.62
44 1238.07 254.74 983.33 196410.88
45 1238.07 256.02 982.05 196154.86
46 1238.07 257.30 980.77 195897.57
47 1238.07 258.58 979.49 195638.98
48 1238.07 259.88 978.19 195379.11
49 1238.07 261.17 976.90 195117.93
50 1238.07 262.48 975.59 194855.45
51 1238.07 263.79 974.28 194591.66
52 1238.07 265.11 972.96 194326.55
53 1238.07 266.44 971.63 194060.11
54 1238.07 267.77 970.30 193792.34
55 1238.07 269.11 968.96 193523.23
56 1238.07 270.45 967.62 193252.78
57 1238.07 271.81 966.26 192980.97
58 1238.07 273.17 964.90 192707.81
59 1238.07 274.53 963.54 192433.28
60 1238.07 275.90 962.17 192157.37
61 1238.07 277.28 960.79 191880.09
62 1238.07 278.67 959.40 191601.42
63 1238.07 280.06 958.01 191321.36
64 1238.07 281.46 956.61 191039.90
65 1238.07 282.87 955.20 190757.03
66 1238.07 284.28 953.79 190472.74
67 1238.07 285.71 952.36 190187.03
68 1238.07 287.13 950.94 189899.90
69 1238.07 288.57 949.50 189611.33
70 1238.07 290.01 948.06 189321.32
71 1238.07 291.46 946.61 189029.85
72 1238.07 292.92 945.15 188736.93
73 1238.07 294.39 943.68 188442.55
74 1238.07 295.86 942.21 188146.69
75 1238.07 297.34 940.73 187849.35
76 1238.07 298.82 939.25 187550.53
77 1238.07 300.32 937.75 187250.21
78 1238.07 301.82 936.25 186948.39
79 1238.07 303.33 934.74 186645.06
80 1238.07 304.84 933.23 186340.22
81 1238.07 306.37 931.70 186033.85
82 1238.07 307.90 930.17 185725.95
83 1238.07 309.44 928.63 185416.51
84 1238.07 310.99 927.08 185105.52
85 1238.07 312.54 925.53 184792.98
86 1238.07 314.11 923.96 184478.88
87 1238.07 315.68 922.39 184163.20
88 1238.07 317.25 920.82 183845.95
89 1238.07 318.84 919.23 183527.11
90 1238.07 320.43 917.64 183206.67
91 1238.07 322.04 916.03 182884.63
92 1238.07 323.65 914.42 182560.99
93 1238.07 325.27 912.80 182235.72
94 1238.07 326.89 911.18 181908.83
95 1238.07 328.53 909.54 181580.31
96 1238.07 330.17 907.90 181250.14
97 1238.07 331.82 906.25 180918.32
98 1238.07 333.48 904.59 180584.84
99 1238.07 335.15 902.92 180249.69
100 1238.07 336.82 901.25 179912.87
101 1238.07 338.51 899.56 179574.37
102 1238.07 340.20 897.87 179234.17
103 1238.07 341.90 896.17 178892.27
104 1238.07 343.61 894.46 178548.66
105 1238.07 345.33 892.74 178203.33
106 1238.07 347.05 891.02 177856.28
107 1238.07 348.79 889.28 177507.49
108 1238.07 350.53 887.54 177156.96
109 1238.07 352.29 885.78 176804.67
110 1238.07 354.05 884.02 176450.63
111 1238.07 355.82 882.25 176094.81
112 1238.07 357.60 880.47 175737.21
113 1238.07 359.38 878.69 175377.83
114 1238.07 361.18 876.89 175016.65
115 1238.07 362.99 875.08 174653.66
116 1238.07 364.80 873.27 174288.86
117 1238.07 366.63 871.44 173922.24
118 1238.07 368.46 869.61 173553.78
119 1238.07 370.30 867.77 173183.48
120 1238.07 372.15 865.92 172811.32
121 1238.07 374.01 864.06 172437.31
122 1238.07 375.88 862.19 172061.43
123 1238.07 377.76 860.31 171683.66
124 1238.07 379.65 858.42 171304.01
125 1238.07 381.55 856.52 170922.46
126 1238.07 383.46 854.61 170539.00
127 1238.07 385.37 852.70 170153.63
128 1238.07 387.30 850.77 169766.33
129 1238.07 389.24 848.83 169377.09
130 1238.07 391.18 846.89 168985.90
131 1238.07 393.14 844.93 168592.76
132 1238.07 395.11 842.96 168197.66
133 1238.07 397.08 840.99 167800.58
134 1238.07 399.07 839.00 167401.51
135 1238.07 401.06 837.01 167000.45
136 1238.07 403.07 835.00 166597.38
137 1238.07 405.08 832.99 166192.30
138 1238.07 407.11 830.96 165785.19
139 1238.07 409.14 828.93 165376.04
140 1238.07 411.19 826.88 164964.85
141 1238.07 413.25 824.82 164551.61
142 1238.07 415.31 822.76 164136.29
143 1238.07 417.39 820.68 163718.91
144 1238.07 419.48 818.59 163299.43
145 1238.07 421.57 816.50 162877.86
146 1238.07 423.68 814.39 162454.18
147 1238.07 425.80 812.27 162028.38
148 1238.07 427.93 810.14 161600.45
149 1238.07 430.07 808.00 161170.38
150 1238.07 432.22 805.85 160738.16
151 1238.07 434.38 803.69 160303.79
152 1238.07 436.55 801.52 159867.23
153 1238.07 438.73 799.34 159428.50
154 1238.07 440.93 797.14 158987.57
155 1238.07 443.13 794.94 158544.44
156 1238.07 445.35 792.72 158099.09
157 1238.07 447.57 790.50 157651.52
158 1238.07 449.81 788.26 157201.71
159 1238.07 452.06 786.01 156749.64
160 1238.07 454.32 783.75 156295.32
161 1238.07 456.59 781.48 155838.73
162 1238.07 458.88 779.19 155379.85
163 1238.07 461.17 776.90 154918.68
164 1238.07 463.48 774.59 154455.21
165 1238.07 465.79 772.28 153989.41
166 1238.07 468.12 769.95 153521.29
167 1238.07 470.46 767.61 153050.83
168 1238.07 472.82 765.25 152578.01
169 1238.07 475.18 762.89 152102.83
170 1238.07 477.56 760.51 151625.27
171 1238.07 479.94 758.13 151145.33
172 1238.07 482.34 755.73 150662.99
173 1238.07 484.76 753.31 150178.23
174 1238.07 487.18 750.89 149691.05
175 1238.07 489.61 748.46 149201.44
176 1238.07 492.06 746.01 148709.37
177 1238.07 494.52 743.55 148214.85
178 1238.07 497.00 741.07 147717.86
179 1238.07 499.48 738.59 147218.38
180 1238.07 501.98 736.09 146716.40
181 1238.07 504.49 733.58 146211.91
182 1238.07 507.01 731.06 145704.90
183 1238.07 509.55 728.52 145195.35
184 1238.07 512.09 725.98 144683.26
185 1238.07 514.65 723.42 144168.61
186 1238.07 517.23 720.84 143651.38
187 1238.07 519.81 718.26 143131.57
188 1238.07 522.41 715.66 142609.15
189 1238.07 525.02 713.05 142084.13
190 1238.07 527.65 710.42 141556.48
191 1238.07 530.29 707.78 141026.19
192 1238.07 532.94 705.13 140493.25
193 1238.07 535.60 702.47 139957.65
194 1238.07 538.28 699.79 139419.37
195 1238.07 540.97 697.10 138878.40
196 1238.07 543.68 694.39 138334.72
197 1238.07 546.40 691.67 137788.32
198 1238.07 549.13 688.94 137239.19
199 1238.07 551.87 686.20 136687.32
200 1238.07 554.63 683.44 136132.69
201 1238.07 557.41 680.66 135575.28
202 1238.07 560.19 677.88 135015.08
203 1238.07 562.99 675.08 134452.09
204 1238.07 565.81 672.26 133886.28
205 1238.07 568.64 669.43 133317.64
206 1238.07 571.48 666.59 132746.16
207 1238.07 574.34 663.73 132171.82
208 1238.07 577.21 660.86 131594.61
209 1238.07 580.10 657.97 131014.51
210 1238.07 583.00 655.07 130431.52
211 1238.07 585.91 652.16 129845.60
212 1238.07 588.84 649.23 129256.76
213 1238.07 591.79 646.28 128664.98
214 1238.07 594.75 643.32 128070.23
215 1238.07 597.72 640.35 127472.51
216 1238.07 600.71 637.36 126871.80
217 1238.07 603.71 634.36 126268.09
218 1238.07 606.73 631.34 125661.36
219 1238.07 609.76 628.31 125051.60
220 1238.07 612.81 625.26 124438.79
221 1238.07 615.88 622.19 123822.91
222 1238.07 618.96 619.11 123203.96
223 1238.07 622.05 616.02 122581.91
224 1238.07 625.16 612.91 121956.75
225 1238.07 628.29 609.78 121328.46
226 1238.07 631.43 606.64 120697.03
227 1238.07 634.58 603.49 120062.45
228 1238.07 637.76 600.31 119424.69
229 1238.07 640.95 597.12 118783.74
230 1238.07 644.15 593.92 118139.59
231 1238.07 647.37 590.70 117492.22
232 1238.07 650.61 587.46 116841.61
233 1238.07 653.86 584.21 116187.75
234 1238.07 657.13 580.94 115530.62
235 1238.07 660.42 577.65 114870.20
236 1238.07 663.72 574.35 114206.48
237 1238.07 667.04 571.03 113539.44
238 1238.07 670.37 567.70 112869.07
239 1238.07 673.72 564.35 112195.35
240 1238.07 677.09 560.98 111518.25
241 1238.07 680.48 557.59 110837.77
242 1238.07 683.88 554.19 110153.89
243 1238.07 687.30 550.77 109466.59
244 1238.07 690.74 547.33 108775.86
245 1238.07 694.19 543.88 108081.67
246 1238.07 697.66 540.41 107384.00
247 1238.07 701.15 536.92 106682.85
248 1238.07 704.66 533.41 105978.20
249 1238.07 708.18 529.89 105270.02
250 1238.07 711.72 526.35 104558.30
251 1238.07 715.28 522.79 103843.02
252 1238.07 718.85 519.22 103124.17
253 1238.07 722.45 515.62 102401.72
254 1238.07 726.06 512.01 101675.65
255 1238.07 729.69 508.38 100945.96
256 1238.07 733.34 504.73 100212.62
257 1238.07 737.01 501.06 99475.62
258 1238.07 740.69 497.38 98734.92
259 1238.07 744.40 493.67 97990.53
260 1238.07 748.12 489.95 97242.41
261 1238.07 751.86 486.21 96490.55
262 1238.07 755.62 482.45 95734.94
263 1238.07 759.40 478.67 94975.54
264 1238.07 763.19 474.88 94212.35
265 1238.07 767.01 471.06 93445.34
266 1238.07 770.84 467.23 92674.50
267 1238.07 774.70 463.37 91899.80
268 1238.07 778.57 459.50 91121.23
269 1238.07 782.46 455.61 90338.76
270 1238.07 786.38 451.69 89552.39
271 1238.07 790.31 447.76 88762.08
272 1238.07 794.26 443.81 87967.82
273 1238.07 798.23 439.84 87169.59
274 1238.07 802.22 435.85 86367.37
275 1238.07 806.23 431.84 85561.13
276 1238.07 810.26 427.81 84750.87
277 1238.07 814.32 423.75 83936.55
278 1238.07 818.39 419.68 83118.17
279 1238.07 822.48 415.59 82295.69
280 1238.07 826.59 411.48 81469.10
281 1238.07 830.72 407.35 80638.37
282 1238.07 834.88 403.19 79803.49
283 1238.07 839.05 399.02 78964.44
284 1238.07 843.25 394.82 78121.19
285 1238.07 847.46 390.61 77273.73
286 1238.07 851.70 386.37 76422.03
287 1238.07 855.96 382.11 75566.07
288 1238.07 860.24 377.83 74705.83
289 1238.07 864.54 373.53 73841.29
290 1238.07 868.86 369.21 72972.42
291 1238.07 873.21 364.86 72099.22
292 1238.07 877.57 360.50 71221.64
293 1238.07 881.96 356.11 70339.68
294 1238.07 886.37 351.70 69453.31
295 1238.07 890.80 347.27 68562.51
296 1238.07 895.26 342.81 67667.25
297 1238.07 899.73 338.34 66767.51
298 1238.07 904.23 333.84 65863.28
299 1238.07 908.75 329.32 64954.53
300 1238.07 913.30 324.77 64041.23
301 1238.07 917.86 320.21 63123.37
302 1238.07 922.45 315.62 62200.91
303 1238.07 927.07 311.00 61273.85
304 1238.07 931.70 306.37 60342.15
305 1238.07 936.36 301.71 59405.79
306 1238.07 941.04 297.03 58464.75
307 1238.07 945.75 292.32 57519.00
308 1238.07 950.47 287.60 56568.53
309 1238.07 955.23 282.84 55613.30
310 1238.07 960.00 278.07 54653.30
311 1238.07 964.80 273.27 53688.49
312 1238.07 969.63 268.44 52718.86
313 1238.07 974.48 263.59 51744.39
314 1238.07 979.35 258.72 50765.04
315 1238.07 984.24 253.83 49780.80
316 1238.07 989.17 248.90 48791.63
317 1238.07 994.11 243.96 47797.52
318 1238.07 999.08 238.99 46798.44
319 1238.07 1004.08 233.99 45794.36
320 1238.07 1009.10 228.97 44785.26
321 1238.07 1014.14 223.93 43771.12
322 1238.07 1019.21 218.86 42751.90
323 1238.07 1024.31 213.76 41727.59
324 1238.07 1029.43 208.64 40698.16
325 1238.07 1034.58 203.49 39663.58
326 1238.07 1039.75 198.32 38623.83
327 1238.07 1044.95 193.12 37578.88
328 1238.07 1050.18 187.89 36528.70
329 1238.07 1055.43 182.64 35473.27
330 1238.07 1060.70 177.37 34412.57
331 1238.07 1066.01 172.06 33346.56
332 1238.07 1071.34 166.73 32275.23
333 1238.07 1076.69 161.38 31198.53
334 1238.07 1082.08 155.99 30116.46
335 1238.07 1087.49 150.58 29028.97
336 1238.07 1092.93 145.14 27936.04
337 1238.07 1098.39 139.68 26837.65
338 1238.07 1103.88 134.19 25733.77
339 1238.07 1109.40 128.67 24624.37
340 1238.07 1114.95 123.12 23509.42
341 1238.07 1120.52 117.55 22388.90
342 1238.07 1126.13 111.94 21262.77
343 1238.07 1131.76 106.31 20131.02
344 1238.07 1137.41 100.66 18993.60
345 1238.07 1143.10 94.97 17850.50
346 1238.07 1148.82 89.25 16701.68
347 1238.07 1154.56 83.51 15547.12
348 1238.07 1160.33 77.74 14386.79
349 1238.07 1166.14 71.93 13220.65
350 1238.07 1171.97 66.10 12048.68
351 1238.07 1177.83 60.24 10870.86
352 1238.07 1183.72 54.35 9687.14
353 1238.07 1189.63 48.44 8497.51
354 1238.07 1195.58 42.49 7301.93
355 1238.07 1201.56 36.51 6100.36
356 1238.07 1207.57 30.50 4892.80
357 1238.07 1213.61 24.46 3679.19
358 1238.07 1219.67 18.40 2459.52
359 1238.07 1225.77 12.30 1233.74
360 1238.07 1231.90 6.17 1.84

Related Solutions

A borrower has a 30-year mortgage loan for $200,000 with an interest rate of 6% and...
A borrower has a 30-year mortgage loan for $200,000 with an interest rate of 6% and monthly payments. If she wants to pay off the loan after 8 years, what would be the outstanding balance on the loan? (D) $84,886 $91,246 $146,667 $175,545 Not enough information Please explain me the step on financial calculator. The answer is D
You are looking to purchase a $300,000 home with a 80% LTV mortgage with a term of 30-years and an interest rate of 6%.
You are looking to purchase a $300,000 home with a 80% LTV mortgage with a term of 30-years and an interest rate of 6%. Your income is $120,000 per year, the annual property taxes are $3,600, and the hazard insurance premium is $1,200 per year. The borrowers other debt service consists of a $700/month car payment and $800/month credit card minimum payment. What is the front-end DTI ratio associated with this borrower/loan?Please input your answer as a percentage (74% would...
You currently have a 30-year fixed rate mortgage with an annual interest rate of 6%. You...
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) into a...
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)...
Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of...
Eight years ago you took out a $400,000, 30-year mortgage with an annual interest rate of 6 percent and monthly payments of $2,398.20. What is the outstanding balance on your current loan if you just make the 96th payment?
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....
A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a.      Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b.      Interest and principal payments during month 1. c.       Total Principal and total interest paid over 30 years. d.      The outstanding loan balance...
A borrower takes out a 30-year mortgage loan for $100,000 with an interest rate of 6%...
A borrower takes out a 30-year mortgage loan for $100,000 with an interest rate of 6% plus 4 points. Payments are to be made monthly. a. What is the effective cost of borrowing on the loan if the loan is carried for all 30 years? b. What is the effective cost of borrowing on the loan if the loan is repaid after 10 years?
A borrower takes out a 30-year mortgage loan for $250,000 with an interest rate of 6%...
A borrower takes out a 30-year mortgage loan for $250,000 with an interest rate of 6% and monthly payments. What portion of the first month's payment would be applied to interest? ($1250) Assume the question above was a negative amortization loan, what would be the balance after 3 years?
6. Your lender now offers you a 30-year-fixed rate home mortgage with 3.6% interest rate per...
6. Your lender now offers you a 30-year-fixed rate home mortgage with 3.6% interest rate per year. If you can afford a monthly payment of $1510, what is the maximum loan you can get? 7. What is the present value of $3190 paid at the end of each of the next 50 years if the interest rate is 7% per year?
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the...
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the payment, 5-year payoff, 5-year principal paid, and 5-year interest paid?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT