case study solution (lot loan tab) h. schwarz-lopes & a. santos

8

Click here to load reader

Upload: ucf-continuing-education

Post on 27-May-2015

443 views

Category:

Education


1 download

TRANSCRIPT

Page 1: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

Borrower: lot loan 5 year amortization

Collateral: 5 year term/amo

Loan Amount: $200,000.00 Amortization Period (Months): 60.00

Interest Rate: 5.250% Amortization Method: Mortgage

Interest Based on 360 Days per Year

Period Beginning Bal Principal Interest Total Pmt Due Ending Balance1 $200,000.00 $2,916.75 $887.15 $3,803.91 $197,083.252 197,083.25 2,929.69 874.21 3,803.91 194,153.553 194,153.55 2,942.69 861.22 3,803.91 191,210.874 191,210.87 2,955.74 848.17 3,803.91 188,255.135 188,255.13 2,968.85 835.06 3,803.91 185,286.286 185,286.28 2,982.02 821.89 3,803.91 182,304.257 182,304.25 2,995.25 808.66 3,803.91 179,309.018 179,309.01 3,008.53 795.37 3,803.91 176,300.479 176,300.47 3,021.88 782.03 3,803.91 173,278.59

10 173,278.59 3,035.28 768.62 3,803.91 170,243.3111 170,243.31 3,048.75 755.16 3,803.91 167,194.5612 167,194.56 3,062.27 741.64 3,803.91 164,132.29

Period 1-12 35,867.71 $9,779.17 $45,646.8812 164,132.29 3,075.85 728.05 3,803.91 161,056.4413 161,056.44 3,089.50 714.41 3,803.91 157,966.9414 157,966.94 3,103.20 700.70 3,803.91 154,863.7415 154,863.74 3,116.97 686.94 3,803.91 151,746.7716 151,746.77 3,130.79 673.11 3,803.91 148,615.9717 148,615.97 3,144.68 659.23 3,803.91 145,471.2918 145,471.29 3,158.63 645.28 3,803.91 142,312.6619 142,312.66 3,172.64 631.27 3,803.91 139,140.0220 139,140.02 3,186.71 617.19 3,803.91 135,953.3121 135,953.31 3,200.85 603.06 3,803.91 132,752.4622 132,752.46 3,215.05 588.86 3,803.91 129,537.4123 129,537.41 3,229.31 574.60 3,803.91 126,308.10

Period 13-24 37,824.19 $7,822.69 $45,646.88Period 1-24 73,691.90 17,601.86 91,293.76

24 126,308.10 3,243.63 560.27 3,803.91 123,064.4725 123,064.47 3,258.02 545.88 3,803.91 119,806.4426 119,806.44 3,272.47 531.43 3,803.91 116,533.9727 116,533.97 3,286.99 516.92 3,803.91 113,246.9828 113,246.98 3,301.57 502.34 3,803.91 109,945.4129 109,945.41 3,316.21 487.69 3,803.91 106,629.2030 106,629.20 3,330.92 472.98 3,803.91 103,298.2731 103,298.27 3,345.70 458.21 3,803.91 99,952.5732 99,952.57 3,360.54 443.37 3,803.91 96,592.0333 96,592.03 3,375.45 428.46 3,803.91 93,216.5834 93,216.58 3,390.42 413.49 3,803.91 89,826.1635 89,826.16 3,405.46 398.45 3,803.91 86,420.70

Period 25-36 39,887.39 $5,759.49 $45,646.88Period 1-36 113,579.30 23,361.34 136,940.64

36 86,420.70 3,420.56 383.34 3,803.91 83,000.1437 83,000.14 3,435.74 368.17 3,803.91 79,564.4038 79,564.40 3,450.98 352.93 3,803.91 76,113.4239 76,113.42 3,466.29 337.62 3,803.91 72,647.1440 72,647.14 3,481.66 322.25 3,803.91 69,165.4841 69,165.48 3,497.10 306.80 3,803.91 65,668.3742 65,668.37 3,512.62 291.29 3,803.91 62,155.7643 62,155.76 3,528.20 275.71 3,803.91 58,627.5644 58,627.56 3,543.85 260.06 3,803.91 55,083.7145 55,083.71 3,559.57 244.34 3,803.91 51,524.1446 51,524.14 3,575.36 228.55 3,803.91 47,948.7847 47,948.78 3,591.22 212.69 3,803.91 44,357.56

Period 37-48 42,063.14 $3,583.74 $45,646.88Period 1-48 155,642.44 26,945.08 182,587.52

48 44,357.56 3,607.15 196.76 3,803.91 40,750.4249 40,750.42 3,623.15 180.76 3,803.91 37,127.2750 37,127.27 3,639.22 164.69 3,803.91 33,488.0551 33,488.05 3,655.36 148.55 3,803.91 29,832.6952 29,832.69 3,671.58 132.33 3,803.91 26,161.1153 26,161.11 3,687.86 116.04 3,803.91 22,473.25

Page 2: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

54 22,473.25 3,704.22 99.69 3,803.91 18,769.0355 18,769.03 3,720.65 83.25 3,803.91 15,048.3856 15,048.38 3,737.16 66.75 3,803.91 11,311.2257 11,311.22 3,753.73 50.17 3,803.91 7,557.4958 7,557.49 3,770.38 33.52 3,803.91 3,787.1159 3,787.11 3,787.11 16.80 3,803.91 0.00

Period 49-60 44,357.56 1,289.32 45,646.88Period 1-60 200,000.00 28,234.40 228,234.40

60 0.00 0.00 0.00 0.00 0.0061 0.00 0.00 0.00 0.00 0.0062 0.00 0.00 0.00 0.00 0.0063 0.00 0.00 0.00 0.00 0.0064 0.00 0.00 0.00 0.00 0.0065 0.00 0.00 0.00 0.00 0.0066 0.00 0.00 0.00 0.00 0.0067 0.00 0.00 0.00 0.00 0.0068 0.00 0.00 0.00 0.00 0.0069 0.00 0.00 0.00 0.00 0.0070 0.00 0.00 0.00 0.00 0.0071 0.00 0.00 0.00 0.00 0.00

Period 61-72 0.00 0.00 0.00Period 1-72 200,000.00 28,234.40 228,234.40

72 0.00 0.00 0.00 0.00 0.0073 0.00 0.00 0.00 0.00 0.0074 0.00 0.00 0.00 0.00 0.0075 0.00 0.00 0.00 0.00 0.0076 0.00 0.00 0.00 0.00 0.0077 0.00 0.00 0.00 0.00 0.0078 0.00 0.00 0.00 0.00 0.0079 0.00 0.00 0.00 0.00 0.0080 0.00 0.00 0.00 0.00 0.0081 0.00 0.00 0.00 0.00 0.0082 0.00 0.00 0.00 0.00 0.0083 0.00 0.00 0.00 0.00 0.00

Period 73-84 0.00 0.00 0.00Period 1-84 200,000.00 28,234.40 228,234.40

84 0.00 0.00 0.00 0.00 0.00

85 0.00 0.00 0.00 0.00 0.00

86 0.00 0.00 0.00 0.00 0.00

87 0.00 0.00 0.00 0.00 0.00

88 0.00 0.00 0.00 0.00 0.00

89 0.00 0.00 0.00 0.00 0.00

90 0.00 0.00 0.00 0.00 0.00

91 0.00 0.00 0.00 0.00 0.00

92 0.00 0.00 0.00 0.00 0.00

93 0.00 0.00 0.00 0.00 0.00

94 0.00 0.00 0.00 0.00 0.00

95 0.00 0.00 0.00 0.00 0.00

Period 85-96 0.00 0.00 0.00

Period 1-96 200,000.00 28,234.40 228,234.40

96 0.00 0.00 0.00 0.00 0.00

97 0.00 0.00 0.00 0.00 0.00

98 0.00 0.00 0.00 0.00 0.00

99 0.00 0.00 0.00 0.00 0.00

100 0.00 0.00 0.00 0.00 0.00

101 0.00 0.00 0.00 0.00 0.00

102 0.00 0.00 0.00 0.00 0.00

103 0.00 0.00 0.00 0.00 0.00

104 0.00 0.00 0.00 0.00 0.00

105 0.00 0.00 0.00 0.00 0.00

106 0.00 0.00 0.00 0.00 0.00

107 0.00 0.00 0.00 0.00 0.00

Period 97-108 0.00 0.00 0.00

Period 1-108 200,000.00 28,234.40 228,234.40

Page 3: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

108 0.00 0.00 0.00 0.00 0.00

109 0.00 0.00 0.00 0.00 0.00

110 0.00 0.00 0.00 0.00 0.00

111 0.00 0.00 0.00 0.00 0.00

112 0.00 0.00 0.00 0.00 0.00

113 0.00 0.00 0.00 0.00 0.00

114 0.00 0.00 0.00 0.00 0.00

115 0.00 0.00 0.00 0.00 0.00

116 0.00 0.00 0.00 0.00 0.00

117 0.00 0.00 0.00 0.00 0.00

118 0.00 0.00 0.00 0.00 0.00

119 0.00 0.00 0.00 0.00 0.00

Period 109-120 0.00 0.00 0.00

Period 1-120 200,000.00 28,234.40 228,234.40

120 0.00 0.00 0.00 0.00 0.00

121 0.00 0.00 0.00 0.00 0.00

122 0.00 0.00 0.00 0.00 0.00

123 0.00 0.00 0.00 0.00 0.00

124 0.00 0.00 0.00 0.00 0.00

125 0.00 0.00 0.00 0.00 0.00

126 0.00 0.00 0.00 0.00 0.00

127 0.00 0.00 0.00 0.00 0.00

128 0.00 0.00 0.00 0.00 0.00

129 0.00 0.00 0.00 0.00 0.00

130 0.00 0.00 0.00 0.00 0.00

131 0.00 0.00 0.00 0.00 0.00

Period 121-132 0.00 0.00 0.00

Period 1-132 200,000.00 28,234.40 228,234.40

132 0.00 0.00 0.00 0.00 0.00

133 0.00 0.00 0.00 0.00 0.00

134 0.00 0.00 0.00 0.00 0.00

135 0.00 0.00 0.00 0.00 0.00

136 0.00 0.00 0.00 0.00 0.00

137 0.00 0.00 0.00 0.00 0.00

138 0.00 0.00 0.00 0.00 0.00

139 0.00 0.00 0.00 0.00 0.00

140 0.00 0.00 0.00 0.00 0.00

141 0.00 0.00 0.00 0.00 0.00

142 0.00 0.00 0.00 0.00 0.00

143 0.00 0.00 0.00 0.00 0.00

Period 133-144 0.00 0.00 0.00

Period 1-144 200,000.00 28,234.40 228,234.40

144 0.00 0.00 0.00 0.00 0.00

145 0.00 0.00 0.00 0.00 0.00

146 0.00 0.00 0.00 0.00 0.00

147 0.00 0.00 0.00 0.00 0.00

148 0.00 0.00 0.00 0.00 0.00

149 0.00 0.00 0.00 0.00 0.00

150 0.00 0.00 0.00 0.00 0.00

151 0.00 0.00 0.00 0.00 0.00

152 0.00 0.00 0.00 0.00 0.00

153 0.00 0.00 0.00 0.00 0.00

154 0.00 0.00 0.00 0.00 0.00

155 0.00 0.00 0.00 0.00 0.00

Period 145-156 0.00 0.00 0.00

Page 4: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

Period 1-156 200,000.00 28,234.40 228,234.40

156 0.00 0.00 0.00 0.00 0.00

157 0.00 0.00 0.00 0.00 0.00

158 0.00 0.00 0.00 0.00 0.00

159 0.00 0.00 0.00 0.00 0.00

160 0.00 0.00 0.00 0.00 0.00

161 0.00 0.00 0.00 0.00 0.00

162 0.00 0.00 0.00 0.00 0.00

163 0.00 0.00 0.00 0.00 0.00

164 0.00 0.00 0.00 0.00 0.00

165 0.00 0.00 0.00 0.00 0.00

166 0.00 0.00 0.00 0.00 0.00

167 0.00 0.00 0.00 0.00 0.00

Period 157-168 0.00 0.00 0.00

Period 1-168 200,000.00 28,234.40 228,234.40

168 0.00 0.00 0.00 0.00 0.00

169 0.00 0.00 0.00 0.00 0.00

170 0.00 0.00 0.00 0.00 0.00

171 0.00 0.00 0.00 0.00 0.00

172 0.00 0.00 0.00 0.00 0.00

173 0.00 0.00 0.00 0.00 0.00

174 0.00 0.00 0.00 0.00 0.00

175 0.00 0.00 0.00 0.00 0.00

176 0.00 0.00 0.00 0.00 0.00

177 0.00 0.00 0.00 0.00 0.00

178 0.00 0.00 0.00 0.00 0.00

179 0.00 0.00 0.00 0.00 0.00

Period 169-180 0.00 0.00 0.00

Period 1-180 200,000.00 28,234.40 228,234.40

180 0.00 0.00 0.00 0.00 0.00

181 0.00 0.00 0.00 0.00 0.00

182 0.00 0.00 0.00 0.00 0.00

183 0.00 0.00 0.00 0.00 0.00

184 0.00 0.00 0.00 0.00 0.00

185 0.00 0.00 0.00 0.00 0.00

186 0.00 0.00 0.00 0.00 0.00

187 0.00 0.00 0.00 0.00 0.00

188 0.00 0.00 0.00 0.00 0.00

189 0.00 0.00 0.00 0.00 0.00

190 0.00 0.00 0.00 0.00 0.00

191 0.00 0.00 0.00 0.00 0.00

Period 181-192 0.00 0.00 0.00

Period 1-192 200,000.00 28,234.40 228,234.40

192 0.00 0.00 0.00 0.00 0.00

193 0.00 0.00 0.00 0.00 0.00

194 0.00 0.00 0.00 0.00 0.00

195 0.00 0.00 0.00 0.00 0.00

196 0.00 0.00 0.00 0.00 0.00

197 0.00 0.00 0.00 0.00 0.00

198 0.00 0.00 0.00 0.00 0.00

199 0.00 0.00 0.00 0.00 0.00

200 0.00 0.00 0.00 0.00 0.00

201 0.00 0.00 0.00 0.00 0.00

202 0.00 0.00 0.00 0.00 0.00

203 0.00 0.00 0.00 0.00 0.00

Page 5: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

Period 193-204 0.00 0.00 0.00

Period 1-204 200,000.00 28,234.40 228,234.40

204 0.00 0.00 0.00 0.00 0.00

205 0.00 0.00 0.00 0.00 0.00

206 0.00 0.00 0.00 0.00 0.00

207 0.00 0.00 0.00 0.00 0.00

208 0.00 0.00 0.00 0.00 0.00

209 0.00 0.00 0.00 0.00 0.00

210 0.00 0.00 0.00 0.00 0.00

211 0.00 0.00 0.00 0.00 0.00

212 0.00 0.00 0.00 0.00 0.00

213 0.00 0.00 0.00 0.00 0.00

214 0.00 0.00 0.00 0.00 0.00

215 0.00 0.00 0.00 0.00 0.00

Period 205-216 0.00 0.00 0.00

Period 1-216 200,000.00 28,234.40 228,234.40

216 0.00 0.00 0.00 0.00 0.00

217 0.00 0.00 0.00 0.00 0.00

218 0.00 0.00 0.00 0.00 0.00

219 0.00 0.00 0.00 0.00 0.00

220 0.00 0.00 0.00 0.00 0.00

221 0.00 0.00 0.00 0.00 0.00

222 0.00 0.00 0.00 0.00 0.00

223 0.00 0.00 0.00 0.00 0.00

224 0.00 0.00 0.00 0.00 0.00

225 0.00 0.00 0.00 0.00 0.00

226 0.00 0.00 0.00 0.00 0.00

227 0.00 0.00 0.00 0.00 0.00

Period 217-228 0.00 0.00 0.00

Period 1-228 200,000.00 28,234.40 228,234.40

228 0.00 0.00 0.00 0.00 0.00

229 0.00 0.00 0.00 0.00 0.00

230 0.00 0.00 0.00 0.00 0.00

231 0.00 0.00 0.00 0.00 0.00

232 0.00 0.00 0.00 0.00 0.00

233 0.00 0.00 0.00 0.00 0.00

234 0.00 0.00 0.00 0.00 0.00

235 0.00 0.00 0.00 0.00 0.00

236 0.00 0.00 0.00 0.00 0.00

237 0.00 0.00 0.00 0.00 0.00

238 0.00 0.00 0.00 0.00 0.00

239 0.00 0.00 0.00 0.00 0.00

Period 229-240 0.00 0.00 0.00

Period 1-240 200,000.00 28,234.40 228,234.40

240 0.00 0.00 0.00 0.00 0.00

241 0.00 0.00 0.00 0.00 0.00

242 0.00 0.00 0.00 0.00 0.00

243 0.00 0.00 0.00 0.00 0.00

244 0.00 0.00 0.00 0.00 0.00

245 0.00 0.00 0.00 0.00 0.00

246 0.00 0.00 0.00 0.00 0.00

247 0.00 0.00 0.00 0.00 0.00

248 0.00 0.00 0.00 0.00 0.00

249 0.00 0.00 0.00 0.00 0.00

250 0.00 0.00 0.00 0.00 0.00

Page 6: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

251 0.00 0.00 0.00 0.00 0.00

Period 241-252 0.00 0.00 0.00

Period 1-252 200,000.00 28,234.40 228,234.40

252 0.00 0.00 0.00 0.00 0.00

253 0.00 0.00 0.00 0.00 0.00

254 0.00 0.00 0.00 0.00 0.00

255 0.00 0.00 0.00 0.00 0.00

256 0.00 0.00 0.00 0.00 0.00

257 0.00 0.00 0.00 0.00 0.00

258 0.00 0.00 0.00 0.00 0.00

259 0.00 0.00 0.00 0.00 0.00

260 0.00 0.00 0.00 0.00 0.00

261 0.00 0.00 0.00 0.00 0.00

262 0.00 0.00 0.00 0.00 0.00

263 0.00 0.00 0.00 0.00 0.00

Period 253-264 0.00 0.00 0.00

Period 1-264 200,000.00 28,234.40 228,234.40

264 0.00 0.00 0.00 0.00 0.00

265 0.00 0.00 0.00 0.00 0.00

266 0.00 0.00 0.00 0.00 0.00

267 0.00 0.00 0.00 0.00 0.00

268 0.00 0.00 0.00 0.00 0.00

269 0.00 0.00 0.00 0.00 0.00

270 0.00 0.00 0.00 0.00 0.00

271 0.00 0.00 0.00 0.00 0.00

272 0.00 0.00 0.00 0.00 0.00

273 0.00 0.00 0.00 0.00 0.00

274 0.00 0.00 0.00 0.00 0.00

275 0.00 0.00 0.00 0.00 0.00

Period 265-276 0.00 0.00 0.00

Period 1-276 200,000.00 28,234.40 228,234.40

276 0.00 0.00 0.00 0.00 0.00

277 0.00 0.00 0.00 0.00 0.00

278 0.00 0.00 0.00 0.00 0.00

279 0.00 0.00 0.00 0.00 0.00

280 0.00 0.00 0.00 0.00 0.00

281 0.00 0.00 0.00 0.00 0.00

282 0.00 0.00 0.00 0.00 0.00

283 0.00 0.00 0.00 0.00 0.00

284 0.00 0.00 0.00 0.00 0.00

285 0.00 0.00 0.00 0.00 0.00

286 0.00 0.00 0.00 0.00 0.00

287 0.00 0.00 0.00 0.00 0.00

Period 277-288 0.00 0.00 0.00

Period 1-288 200,000.00 28,234.40 228,234.40

288 0.00 0.00 0.00 0.00 0.00

289 0.00 0.00 0.00 0.00 0.00

290 0.00 0.00 0.00 0.00 0.00

291 0.00 0.00 0.00 0.00 0.00

292 0.00 0.00 0.00 0.00 0.00

293 0.00 0.00 0.00 0.00 0.00

294 0.00 0.00 0.00 0.00 0.00

295 0.00 0.00 0.00 0.00 0.00

296 0.00 0.00 0.00 0.00 0.00

297 0.00 0.00 0.00 0.00 0.00

Page 7: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

298 0.00 0.00 0.00 0.00 0.00

299 0.00 0.00 0.00 0.00 0.00

Period 289-300 0.00 0.00 0.00

Period 1-300 200,000.00 28,234.40 228,234.40

300 0.00 0.00 0.00 0.00 0.00

301 0.00 0.00 0.00 0.00 0.00

302 0.00 0.00 0.00 0.00 0.00

303 0.00 0.00 0.00 0.00 0.00

304 0.00 0.00 0.00 0.00 0.00

305 0.00 0.00 0.00 0.00 0.00

306 0.00 0.00 0.00 0.00 0.00

307 0.00 0.00 0.00 0.00 0.00

308 0.00 0.00 0.00 0.00 0.00

309 0.00 0.00 0.00 0.00 0.00

310 0.00 0.00 0.00 0.00 0.00

311 0.00 0.00 0.00 0.00 0.00

Period 301-312 0.00 0.00 0.00

Period 1-312 200,000.00 28,234.40 228,234.40

312 0.00 0.00 0.00 0.00 0.00

313 0.00 0.00 0.00 0.00 0.00

314 0.00 0.00 0.00 0.00 0.00

315 0.00 0.00 0.00 0.00 0.00

316 0.00 0.00 0.00 0.00 0.00

317 0.00 0.00 0.00 0.00 0.00

318 0.00 0.00 0.00 0.00 0.00

319 0.00 0.00 0.00 0.00 0.00

320 0.00 0.00 0.00 0.00 0.00

321 0.00 0.00 0.00 0.00 0.00

322 0.00 0.00 0.00 0.00 0.00

323 0.00 0.00 0.00 0.00 0.00

Period 313-324 0.00 0.00 0.00

Period 1-324 200,000.00 28,234.40 228,234.40

324 0.00 0.00 0.00 0.00 0.00

325 0.00 0.00 0.00 0.00 0.00

326 0.00 0.00 0.00 0.00 0.00

327 0.00 0.00 0.00 0.00 0.00

328 0.00 0.00 0.00 0.00 0.00

329 0.00 0.00 0.00 0.00 0.00

330 0.00 0.00 0.00 0.00 0.00

331 0.00 0.00 0.00 0.00 0.00

332 0.00 0.00 0.00 0.00 0.00

333 0.00 0.00 0.00 0.00 0.00

334 0.00 0.00 0.00 0.00 0.00

335 0.00 0.00 0.00 0.00 0.00

Period 325-336 0.00 0.00 0.00

Period 1-336 200,000.00 28,234.40 228,234.40

336 0.00 0.00 0.00 0.00 0.00

337 0.00 0.00 0.00 0.00 0.00

338 0.00 0.00 0.00 0.00 0.00

339 0.00 0.00 0.00 0.00 0.00

340 0.00 0.00 0.00 0.00 0.00

341 0.00 0.00 0.00 0.00 0.00

342 0.00 0.00 0.00 0.00 0.00

343 0.00 0.00 0.00 0.00 0.00

344 0.00 0.00 0.00 0.00 0.00

Page 8: Case study solution (Lot Loan tab) H. Schwarz-Lopes & A. Santos

345 0.00 0.00 0.00 0.00 0.00

346 0.00 0.00 0.00 0.00 0.00

347 0.00 0.00 0.00 0.00 0.00

Period 337-348 0.00 0.00 0.00

Period 1-348 200,000.00 28,234.40 228,234.40

348 0.00 0.00 0.00 0.00 0.00

349 0.00 0.00 0.00 0.00 0.00

350 0.00 0.00 0.00 0.00 0.00

351 0.00 0.00 0.00 0.00 0.00

352 0.00 0.00 0.00 0.00 0.00

353 0.00 0.00 0.00 0.00 0.00

354 0.00 0.00 0.00 0.00 0.00

355 0.00 0.00 0.00 0.00 0.00

356 0.00 0.00 0.00 0.00 0.00

357 0.00 0.00 0.00 0.00 0.00

358 0.00 0.00 0.00 0.00 0.00

359 0.00 0.00 0.00 0.00 0.00

Period 349-360 0.00 0.00 0.00

Period 1-360 $200,000.00 $28,234.40 $228,234.40