Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. suppose that a 15-year mortgage loan for $200,000

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate,...

Free

50.1K

Verified Solution

Question

Finance

Suppose that a 15-year mortgage loan for $200,000 is obtained.The mortgage is a level-payment, fixed-rate, fully amortizedmortgage and the mortgage rate is 7.0% (APR, monthly).

a. Find the monthly mortgage payment.

b. Compute an amortization schedule for the first sixmonths.

c. What will the mortgage balance be at the end of the 15thyear?

d. If an investor purchased this mortgage, what will the timingof the cash flow be assuming that the borrower does notdefault?

Answer & Explanation Solved by verified expert
3.7 Ratings (456 Votes)

Loan Amount $                            200,000.00
Interest Rate 7.000%
Monthly interest 0.00583
PMT=(Monthly Rate,Number of payments,Loan Amount)
Monthly Payment ($1,797.21)
Mortgage Balance at the end of 15 th year is Zero
Loan Amortization Schedule
Payment Interest Principal Balance
0 200000.00
1 1797.21 1166.67 630.54 199369.46
2 1797.21 1162.99 634.22 198735.24
3 1797.21 1159.29 637.92 198097.31
4 1797.21 1155.57 641.64 197455.67
5 1797.21 1151.82 645.39 196810.29
6 1797.21 1148.06 649.15 196161.14
7 1797.21 1144.27 652.94 195508.20
8 1797.21 1140.46 656.75 194851.45
9 1797.21 1136.63 660.58 194190.88
10 1797.21 1132.78 664.43 193526.45
11 1797.21 1128.90 668.31 192858.14
12 1797.21 1125.01 672.20 192185.94
13 1797.21 1121.08 676.13 191509.81
14 1797.21 1117.14 680.07 190829.74
15 1797.21 1113.17 684.04 190145.71
16 1797.21 1109.18 688.03 189457.68
17 1797.21 1105.17 692.04 188765.64
18 1797.21 1101.13 696.08 188069.56
19 1797.21 1097.07 700.14 187369.43
20 1797.21 1092.99 704.22 186665.20
21 1797.21 1088.88 708.33 185956.87
22 1797.21 1084.75 712.46 185244.41
23 1797.21 1080.59 716.62 184527.79
24 1797.21 1076.41 720.80 183807.00
25 1797.21 1072.21 725.00 183081.99
26 1797.21 1067.98 729.23 182352.76
27 1797.21 1063.72 733.49 181619.28
28 1797.21 1059.45 737.76 180881.51
29 1797.21 1055.14 742.07 180139.44
30 1797.21 1050.81 746.40 179393.05
31 1797.21 1046.46 750.75 178642.30
32 1797.21 1042.08 755.13 177887.17
33 1797.21 1037.68 759.53 177127.63
34 1797.21 1033.24 763.97 176363.67
35 1797.21 1028.79 768.42 175595.25
36 1797.21 1024.31 772.90 174822.34
37 1797.21 1019.80 777.41 174044.93
38 1797.21 1015.26 781.95 173262.98
39 1797.21 1010.70 786.51 172476.47
40 1797.21 1006.11 791.10 171685.37
41 1797.21 1001.50 795.71 170889.66
42 1797.21 996.86 800.35 170089.31
43 1797.21 992.19 805.02 169284.29
44 1797.21 987.49 809.72 168474.57
45 1797.21 982.77 814.44 167660.13
46 1797.21 978.02 819.19 166840.93
47 1797.21 973.24 823.97 166016.96
48 1797.21 968.43 828.78 165188.18
49 1797.21 963.60 833.61 164354.57
50 1797.21 958.74 838.47 163516.10
51 1797.21 953.84 843.37 162672.73
52 1797.21 948.92 848.29 161824.45
53 1797.21 943.98 853.23 160971.21
54 1797.21 939.00 858.21 160113.00
55 1797.21 933.99 863.22 159249.78
56 1797.21 928.96 868.25 158381.53
57 1797.21 923.89 873.32 157508.21
58 1797.21 918.80 878.41 156629.80
59 1797.21 913.67 883.54 155746.26
60 1797.21 908.52 888.69 154857.57
61 1797.21 903.34 893.87 153963.70
62 1797.21 898.12 899.09 153064.61
63 1797.21 892.88 904.33 152160.28
64 1797.21 887.60 909.61 151250.67
65 1797.21 882.30 914.91 150335.75
66 1797.21 876.96 920.25 149415.50
67 1797.21 871.59 925.62 148489.88
68 1797.21 866.19 931.02 147558.86
69 1797.21 860.76 936.45 146622.41
70 1797.21 855.30 941.91 145680.50
71 1797.21 849.80 947.41 144733.10
72 1797.21 844.28 952.93 143780.16
73 1797.21 838.72 958.49 142821.67
74 1797.21 833.13 964.08 141857.59
75 1797.21 827.50 969.71 140887.88
76 1797.21 821.85 975.36 139912.51
77 1797.21 816.16 981.05 138931.46
78 1797.21 810.43 986.78 137944.68
79 1797.21 804.68 992.53 136952.15
80 1797.21 798.89 998.32 135953.83
81 1797.21 793.06 1004.15 134949.68
82 1797.21 787.21 1010.00 133939.68
83 1797.21 781.31 1015.90 132923.78
84 1797.21 775.39 1021.82 131901.96
85 1797.21 769.43 1027.78 130874.18
86 1797.21 763.43 1033.78 129840.40
87 1797.21 757.40 1039.81 128800.60
88 1797.21 751.34 1045.87 127754.72
89 1797.21 745.24 1051.97 126702.75
90 1797.21 739.10 1058.11 125644.64
91 1797.21 732.93 1064.28 124580.36
92 1797.21 726.72 1070.49 123509.86
93 1797.21 720.47 1076.74 122433.13
94 1797.21 714.19 1083.02 121350.11
95 1797.21 707.88 1089.33 120260.78
96 1797.21 701.52 1095.69 119165.09
97 1797.21 695.13 1102.08 118063.01
98 1797.21 688.70 1108.51 116954.50
99 1797.21 682.23 1114.98 115839.52
100 1797.21 675.73 1121.48 114718.04
101 1797.21 669.19 1128.02 113590.02
102 1797.21 662.61 1134.60 112455.42
103 1797.21 655.99 1141.22 111314.20
104 1797.21 649.33 1147.88 110166.32
105 1797.21 642.64 1154.57 109011.75
106 1797.21 635.90 1161.31 107850.44
107 1797.21 629.13 1168.08 106682.36
108 1797.21 622.31 1174.90 105507.46
109 1797.21 615.46 1181.75 104325.71
110 1797.21 608.57 1188.64 103137.07
111 1797.21 601.63 1195.58 101941.49
112 1797.21 594.66 1202.55 100738.94
113 1797.21 587.64 1209.57 99529.38
114 1797.21 580.59 1216.62 98312.75
115 1797.21 573.49 1223.72 97089.04
116 1797.21 566.35 1230.86 95858.18
117 1797.21 559.17 1238.04 94620.14
118 1797.21 551.95 1245.26 93374.88
119 1797.21 544.69 1252.52 92122.36
120 1797.21 537.38 1259.83 90862.53
121 1797.21 530.03 1267.18 89595.35
122 1797.21 522.64 1274.57 88320.78
123 1797.21 515.20 1282.01 87038.77
124 1797.21 507.73 1289.48 85749.29
125 1797.21 500.20 1297.01 84452.28
126 1797.21 492.64 1304.57 83147.71
127 1797.21 485.03 1312.18 81835.53
128 1797.21 477.37 1319.84 80515.70
129 1797.21 469.67 1327.54 79188.16
130 1797.21 461.93 1335.28 77852.88
131 1797.21 454.14 1343.07 76509.81
132 1797.21 446.31 1350.90 75158.91
133 1797.21 438.43 1358.78 73800.13
134 1797.21 430.50 1366.71 72433.42
135 1797.21 422.53 1374.68 71058.74
136 1797.21 414.51 1382.70 69676.04
137 1797.21 406.44 1390.77 68285.27
138 1797.21 398.33 1398.88 66886.39
139 1797.21 390.17 1407.04 65479.35
140 1797.21 381.96 1415.25 64064.10
141 1797.21 373.71 1423.50 62640.60
142 1797.21 365.40 1431.81 61208.79
143 1797.21 357.05 1440.16 59768.63
144 1797.21 348.65 1448.56 58320.08
145 1797.21 340.20 1457.01 56863.07
146 1797.21 331.70 1465.51 55397.56
147 1797.21 323.15 1474.06 53923.50
148 1797.21 314.55 1482.66 52440.84
149 1797.21 305.90 1491.31 50949.54
150 1797.21 297.21 1500.00 49449.53
151 1797.21 288.46 1508.75 47940.78
152 1797.21 279.65 1517.56 46423.22
153 1797.21 270.80 1526.41 44896.82
154 1797.21 261.90 1535.31 43361.50
155 1797.21 252.94 1544.27 41817.24
156 1797.21 243.93 1553.28 40263.96
157 1797.21 234.87 1562.34 38701.62
158 1797.21 225.76 1571.45 37130.17
159 1797.21 216.59 1580.62 35549.56
160 1797.21 207.37 1589.84 33959.72
161 1797.21 198.10 1599.11 32360.61
162 1797.21 188.77 1608.44 30752.17
163 1797.21 179.39 1617.82 29134.34
164 1797.21 169.95 1627.26 27507.08
165 1797.21 160.46 1636.75 25870.33
166 1797.21 150.91 1646.30 24224.03
167 1797.21 141.31 1655.90 22568.13
168 1797.21 131.65 1665.56 20902.57
169 1797.21 121.93 1675.28 19227.29
170 1797.21 112.16 1685.05 17542.24
171 1797.21 102.33 1694.88 15847.36
172 1797.21 92.44 1704.77 14142.59
173 1797.21 82.50 1714.71 12427.88
174 1797.21 72.50 1724.71 10703.16
175 1797.21 62.44 1734.77 8968.39
176 1797.21 52.32 1744.89 7223.50
177 1797.21 42.14 1755.07 5468.42
178 1797.21 31.90 1765.31 3703.11
179 1797.21 21.60 1775.61 1927.50
180 1797.21 130.29 1927.50 0.00
Total 323497.8 123758.38 200000.00

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Suppose that a 15-year mortgage loan for $200,000 is obtained.The mortgage is a level-payment, fixed-rate, fully amortizedmortgage and the mortgage rate is 7.0% (APR, monthly).a. Find the monthly mortgage payment.b. Compute an amortization schedule for the first sixmonths.c. What will the mortgage balance be at the end of the 15thyear?d. If an investor purchased this mortgage, what will the timingof the cash flow be assuming that the borrower does notdefault?

Other questions asked by students

Q

Which process is most directly driven by light energy?creation of a pH gradientby pumping protons...

Biology
Q

The term that is used to describe the position of something that is relatively close...

Biology
Q

A call option written against stock owned by the writer is said to be in...

Basic Math
Q

For each research objective presented, identify the population and sample in the study: ) The...

Basic Math
Q

Question 6 of 14 1 point Question Attempt 1 of 3 where do you liver...

Statistics
Q

Lakatos Corporation manufactures one product. It does not maintain any beginning or ending Work in...

Accounting
Q

if a company had non interest bearing notes (no coupon payments needed) outstanding in 2016,...

Accounting
Q

Logistics Solutions provides order fulfillment services for dot.com merchants. The company maintains warehouses that stock...

Accounting
Q

LO 1.3 Rahul and Ruby are married taxpayers. They are both under age...

Accounting
Q

Why would an organization switch from the FIFO to LIFO method? Wouldn't the time it...

Accounting
Q

2. Closing Statement Using the following information, prepare a settlement statement for the transaction using...

Accounting
Q

Which of the following statements is true about the annual renewable term policy? It is...

Finance