Spreadsheet: 865439d1712506761-look-up-loan-balance-by-date-sample
Sheet: MORTGAGE

 | Loan Amount | 328000 |  | PV | 328000 |  |  | Total Interest
 | Interest Rate | 0.07125 |  | RATE |  | Monthly |  | Total
 | Years | 30 |  | Nper |  | Monthly |  |  |  |  | 2027-10-01 00:00:00 | Paid off | 200000 | 100000
 |  |  |  |  |  |  |  |  |  | 1500 | 183763.08 | 2032-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2000 | 154816.83 | 2031-05-01 00:00:00 | 2026-09-01 00:00:00 | 2029-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2500 | 130412.88 | 2030-04-01 00:00:00 | 2026-03-01 00:00:00 | 2028-06-01 00:00:00
 |  |  |  | PMY |  | Monthly |  |  |  | 3000 | 111575.21 | 2029-08-01 00:00:00 | 2025-12-01 00:00:00 | 2027-11-01 00:00:00
 |  |  |  |  |  |  | 2023-09-02 00:00:00
Column1 | Periods | Payments | Int | Principal | Extra Payments | Loan Balance |  |  | 2033-09-01 00:00:00 | 1500 | 126 | 10.5
 | 0 |  |  |  |  | 328000 |  |  | 2031-12-01 00:00:00 | 2000
2023-03-01 00:00:00 | 1 |  |  |  |  |  |  |  | 2030-09-01 00:00:00 | 2500
2023-04-01 00:00:00 | 2 |  |  |  |  |  |  | . | 2029-09-01 00:00:00 | 3000
2023-05-01 00:00:00 | 3 |  |  |  |  |  | 319519.27
2023-06-01 00:00:00 | 4 |  |  |  | 9170.54
2023-07-01 00:00:00 | 5
2023-08-01 00:00:00 | 6
2023-09-01 00:00:00 | 7 |  |  |  | 1000 | 296382.13 | 296382.13
2023-10-01 00:00:00 | 8
2023-11-01 00:00:00 | 9 |  |  |  | 2500
2023-12-01 00:00:00 | 10 |  |  |  | 2500
2024-01-01 00:00:00 | 11 |  |  |  | 2500
2024-02-01 00:00:00 | 12 |  |  |  | 2500
2024-03-01 00:00:00 | 13 |  |  |  | 2500
2024-04-01 00:00:00 | 14 |  |  |  | 2500
2024-05-01 00:00:00 | 15 |  |  |  | 2500
2024-06-01 00:00:00 | 16 |  |  |  | 2500
2024-07-01 00:00:00 | 17 |  |  |  | 2500
2024-08-01 00:00:00 | 18 |  |  |  | 2500
2024-09-01 00:00:00 | 19 |  |  |  | 2500
2024-10-01 00:00:00 | 20 |  |  |  | 2500
2024-11-01 00:00:00 | 21 |  |  |  | 2500
2024-12-01 00:00:00 | 22 |  |  |  | 2500
2025-01-01 00:00:00 | 23 |  |  |  | 2500
2025-02-01 00:00:00 | 24 |  |  |  | 2500
2025-03-01 00:00:00 | 25 |  |  |  | 2500
2025-04-01 00:00:00 | 26 |  |  |  | 2500
2025-05-01 00:00:00 | 27 |  |  |  | 2500
2025-06-01 00:00:00 | 28 |  |  |  | 2500
2025-07-01 00:00:00 | 29 |  |  |  | 2500
2025-08-01 00:00:00 | 30 |  |  |  | 2500
2025-09-01 00:00:00 | 31 |  |  |  | 2500
2025-10-01 00:00:00 | 32 |  |  |  | 2500
2025-11-01 00:00:00 | 33 |  |  |  | 2500
2025-12-01 00:00:00 | 34 |  |  |  | 2500
2026-01-01 00:00:00 | 35 |  |  |  | 2500
2026-02-01 00:00:00 | 36 |  |  |  | 2500
2026-03-01 00:00:00 | 37 |  |  |  | 2500
2026-04-01 00:00:00 | 38 |  |  |  | 2500
2026-05-01 00:00:00 | 39 |  |  |  | 2500
2026-06-01 00:00:00 | 40 |  |  |  | 2500
2026-07-01 00:00:00 | 41 |  |  |  | 2500
2026-08-01 00:00:00 | 42 |  |  |  | 2500
2026-09-01 00:00:00 | 43 |  |  |  | 2500
2026-10-01 00:00:00 | 44 |  |  |  | 2500
2026-11-01 00:00:00 | 45 |  |  |  | 2500
2026-12-01 00:00:00 | 46 |  |  |  | 2500
2027-01-01 00:00:00 | 47 |  |  |  | 2500
2027-02-01 00:00:00 | 48 |  |  |  | 2500
2027-03-01 00:00:00 | 49 |  |  |  | 2500
2027-04-01 00:00:00 | 50 |  |  |  | 2500
2027-05-01 00:00:00 | 51 |  |  |  | 2500
2027-06-01 00:00:00 | 52 |  |  |  | 2500
2027-07-01 00:00:00 | 53 |  |  |  | 2500
2027-08-01 00:00:00 | 54 |  |  |  | 2500
2027-09-01 00:00:00 | 55 |  |  |  | 2500
2027-10-01 00:00:00 | 56 |  |  |  | 2500
2027-11-01 00:00:00 | 57 |  |  |  | 2500
2027-12-01 00:00:00 | 58 |  |  |  | 2500
2028-01-01 00:00:00 | 59 |  |  |  | 2500
2028-02-01 00:00:00 | 60 |  |  |  | 2500
2028-03-01 00:00:00 | 61 |  |  |  | 2500
2028-04-01 00:00:00 | 62 |  |  |  | 2500
2028-05-01 00:00:00 | 63 |  |  |  | 2500
2028-06-01 00:00:00 | 64 |  |  |  | 2500
2028-07-01 00:00:00 | 65 |  |  |  | 2500
2028-08-01 00:00:00 | 66 |  |  |  | 2500
2028-09-01 00:00:00 | 67 |  |  |  | 2500
2028-10-01 00:00:00 | 68 |  |  |  | 2500
2028-11-01 00:00:00 | 69 |  |  |  | 2500
2028-12-01 00:00:00 | 70 |  |  |  | 2500
2029-01-01 00:00:00 | 71 |  |  |  | 2500
2029-02-01 00:00:00 | 72 |  |  |  | 2500 |  |  | 3500
2029-03-01 00:00:00 | 73 |  |  |  | 2500
2029-04-01 00:00:00 | 74 |  |  |  | 2500
2029-05-01 00:00:00 | 75 |  |  |  | 2500
2029-06-01 00:00:00 | 76 |  |  |  | 2500
2029-07-01 00:00:00 | 77 |  |  |  | 2500
2029-08-01 00:00:00 | 78 |  |  |  | 2500 |  |  | 3000
2029-09-01 00:00:00 | 79 |  |  |  | 2500
2029-10-01 00:00:00 | 80 |  |  |  | 2500
2029-11-01 00:00:00 | 81 |  |  |  | 2500
2029-12-01 00:00:00 | 82 |  |  |  | 2500
2030-01-01 00:00:00 | 83 |  |  |  | 2500
2030-02-01 00:00:00 | 84 |  |  |  | 2500
2030-03-01 00:00:00 | 85 |  |  |  | 2500
2030-04-01 00:00:00 | 86 |  |  |  | 2500
2030-05-01 00:00:00 | 87 |  |  |  | 2500
2030-06-01 00:00:00 | 88 |  |  |  | 2500
2030-07-01 00:00:00 | 89 |  |  |  | 2500 |  |  | 2500
2030-08-01 00:00:00 | 90 |  |  |  | 2500
2030-09-01 00:00:00 | 91 |  |  |  | 2500
2030-10-01 00:00:00 | 92 |  |  |  | 2500
2030-11-01 00:00:00 | 93 |  |  |  | 2500
2030-12-01 00:00:00 | 94 |  |  |  | 2000
2031-01-01 00:00:00 | 95 |  |  |  | 2000
2031-02-01 00:00:00 | 96 |  |  |  | 2000
2031-03-01 00:00:00 | 97 |  |  |  | 2000
2031-04-01 00:00:00 | 98 |  |  |  | 2000
2031-05-01 00:00:00 | 99 |  |  |  | 2000
2031-06-01 00:00:00 | 100 |  |  |  | 2000
2031-07-01 00:00:00 | 101 |  |  |  | 2000
2031-08-01 00:00:00 | 102 |  |  |  | 2000
2031-09-01 00:00:00 | 103 |  |  |  | 2000
2031-10-01 00:00:00 | 104 |  |  |  | 2000
2031-11-01 00:00:00 | 105 |  |  |  | 2000
2031-12-01 00:00:00 | 106 |  |  |  | 2000
2032-01-01 00:00:00 | 107 |  |  |  | 2000
2032-02-01 00:00:00 | 108 |  |  |  | 2000
2032-03-01 00:00:00 | 109 |  |  |  | 2000
2032-04-01 00:00:00 | 110 |  |  |  | 2000
2032-05-01 00:00:00 | 111 |  |  |  | 2000
2032-06-01 00:00:00 | 112 |  |  |  | 2000
2032-07-01 00:00:00 | 113 |  |  |  | 2000
2032-08-01 00:00:00 | 114 |  |  |  | 2000
2032-09-01 00:00:00 | 115 |  |  |  | 2000
2032-10-01 00:00:00 | 116 |  |  |  | 2000
2032-11-01 00:00:00 | 117 |  |  |  | 2000
2032-12-01 00:00:00 | 118 |  |  |  | 2000
2033-01-01 00:00:00 | 119 |  |  |  | 2000
2033-02-01 00:00:00 | 120 |  |  |  | 2000
2033-03-01 00:00:00 | 121 |  |  |  | 2000
2033-04-01 00:00:00 | 122 |  |  |  | 2000
2033-05-01 00:00:00 | 123 |  |  |  | 2000
2033-06-01 00:00:00 | 124 |  |  |  | 2000
2033-07-01 00:00:00 | 125 |  |  |  | 2000
2033-08-01 00:00:00 | 126 |  |  |  | 2000
2033-09-01 00:00:00 | 127 |  |  |  | 2000
 |  |  |  |  | 2000
 |  |  |  |  | 2000
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 |  |  |  |  | 1500
 | 128 |  |  |  | 1500
 | 129 |  |  |  | 1500
 | 130 |  |  |  | 1500
 | 131 |  |  |  | 1500
 | 132 |  |  |  | 1500
 | 133 |  |  |  | 1500
 | 134 |  |  |  | 1500
 | 135 |  |  |  | 1500
 | 136 |  |  |  | 1500
 | 137 |  |  |  | 1500
 | 138 |  |  |  | 1500
 | 139 |  |  |  | 1500
 | 140 |  |  |  | 1500
 | 141 |  |  |  | 1500
 | 142 |  |  |  | 1500
 | 143 |  |  |  | 1500
 | 144 |  |  |  | 1500
 | 145 |  |  |  | 1500
 | 146 |  |  |  | 1500
 | 147 |  |  |  | 1500
 | 148 |  |  |  | 1500
 | 149 |  |  |  | 1500
 | 150 |  |  |  | 1500
 | 151 |  |  |  | 1500
 | 152 |  |  |  | 1500
 | 153 |  |  |  | 1500
 | 154 |  |  |  | 1500
 | 155 |  |  |  | 1500
 | 156 |  |  |  | 1500
 | 157 |  |  |  | 1500
 | 158 |  |  |  | 1500
 | 159 |  |  |  | 1500
 | 160 |  |  |  | 1500
 | 161 |  |  |  | 1500
 | 162 |  |  |  | 1500
 | 163 |  |  |  | 1500
 | 164 |  |  |  | 1500
 | 165 |  |  |  | 1500
 | 166 |  |  |  | 1500
 | 167 |  |  |  | 1500
 | 168 |  |  |  | 1500
 | 169 |  |  |  | 1500
 | 170 |  |  |  | 1500
 | 171 |  |  |  | 1500
 | 172 |  |  |  | 1500
 | 173 |  |  |  | 1500
 | 174 |  |  |  | 1500
 | 175 |  |  |  | 1500
 | 176 |  |  |  | 1500
 | 177 |  |  |  | 1500
 | 178 |  |  |  | 1500
 | 179 |  |  |  | 1500
 | 180 |  |  |  | 1500
 | 181 |  |  |  | 1500
 | 182 |  |  |  | 1500
 | 183 |  |  |  | 1500
 | 184 |  |  |  | 1500
 | 185 |  |  |  | 1500
 | 186 |  |  |  | 1500
 | 187 |  |  |  | 1500
 | 188 |  |  |  | 1500
 | 189 |  |  |  | 1500
 | 190 |  |  |  | 1500
 | 191 |  |  |  | 1500
 | 192 |  |  |  | 1500
 | 193 |  |  |  | 1500
 | 194 |  |  |  | 1500
 | 195 |  |  |  | 1500
 | 196 |  |  |  | 1500
 | 197 |  |  |  | 1500
 | 198 |  |  |  | 1500
 | 199 |  |  |  | 1500
 | 200 |  |  |  | 1500
 | 201 |  |  |  | 1500
 | 202 |  |  |  | 1500
 | 203 |  |  |  | 1500
 | 204 |  |  |  | 1500
 | 205 |  |  |  | 1500
 | 206 |  |  |  | 1500
 | 207 |  |  |  | 1500
 | 208 |  |  |  | 1500
 | 209 |  |  |  | 1500
 | 210 |  |  |  | 1500
 | 211 |  |  |  | 1500
 | 212 |  |  |  | 1500
 | 213 |  |  |  | 1500
 | 214 |  |  |  | 1500
 | 215 |  |  |  | 1500
 | 216 |  |  |  | 1500
 | 217 |  |  |  | 1500
 | 218 |  |  |  | 1500
 | 219 |  |  |  | 1500
 | 220 |  |  |  | 1500
 | 221 |  |  |  | 1500
 | 222 |  |  |  | 1500
 | 223 |  |  |  | 1500
 | 224 |  |  |  | 1500
 | 225 |  |  |  | 1500
 | 226 |  |  |  | 1500
 | 227 |  |  |  | 1500
 | 228 |  |  |  | 1500
 | 229 |  |  |  | 1500
 | 230 |  |  |  | 1500
 | 231 |  |  |  | 1500
 | 232 |  |  |  | 1500
 | 233 |  |  |  | 1500
 | 234 |  |  |  | 1500
 | 235 |  |  |  | 1500
 | 236 |  |  |  | 1500
 | 237 |  |  |  | 1500
 | 238 |  |  |  | 1500
 | 239 |  |  |  | 1500
 | 240 |  |  |  | 1500
 | 241 |  |  |  | 1500
 | 242 |  |  |  | 1500
 | 243 |  |  |  | 1500
 | 244 |  |  |  | 1500
 | 245 |  |  |  | 1500
 | 246 |  |  |  | 1500
 | 247 |  |  |  | 1500
 | 248 |  |  |  | 1500
 | 249 |  |  |  | 1500
 | 250 |  |  |  | 1500
 | 251 |  |  |  | 1500
 | 252 |  |  |  | 1500
 | 253 |  |  |  | 1500
 | 254 |  |  |  | 1500
 | 255 |  |  |  | 1500
 | 256 |  |  |  | 1500
 | 257 |  |  |  | 1500
 | 258 |  |  |  | 1500
 | 259 |  |  |  | 1500
 | 260 |  |  |  | 1500
 | 261 |  |  |  | 1500
 | 262 |  |  |  | 1500
 | 263 |  |  |  | 1500
 | 264 |  |  |  | 1500
 | 265 |  |  |  | 1500
 | 266 |  |  |  | 1500
 | 267 |  |  |  | 1500
 | 268 |  |  |  | 1500
 | 269 |  |  |  | 1500
 | 270 |  |  |  | 1500
 | 271 |  |  |  | 1500
 | 272 |  |  |  | 1500
 | 273 |  |  |  | 1500
 | 274 |  |  |  | 1500
 | 275 |  |  |  | 1500
 | 276 |  |  |  | 1500
 | 277 |  |  |  | 1500
 | 278 |  |  |  | 1500
 | 279 |  |  |  | 1500
 | 280 |  |  |  | 1500
 | 281 |  |  |  | 1500
 | 282 |  |  |  | 1500
 | 283 |  |  |  | 1500
 | 284 |  |  |  | 1500
 | 285 |  |  |  | 1500
 | 286 |  |  |  | 1500
 | 287 |  |  |  | 1500
 | 288 |  |  |  | 1500
 | 289 |  |  |  | 1500
 | 290 |  |  |  | 1500
 | 291 |  |  |  | 1500
 | 292 |  |  |  | 1500
 | 293 |  |  |  | 1500
 | 294 |  |  |  | 1500
 | 295 |  |  |  | 1500
 | 296 |  |  |  | 1500
 | 297 |  |  |  | 1500
 | 298 |  |  |  | 1500
 | 299 |  |  |  | 1500
 | 300 |  |  |  | 1500
 | 301 |  |  |  | 1500
 | 302 |  |  |  | 1500
 | 303 |  |  |  | 1500
 | 304 |  |  |  | 1500
 | 305 |  |  |  | 1500
 | 306 |  |  |  | 1500
 | 307 |  |  |  | 1500
 | 308 |  |  |  | 1500
 | 309 |  |  |  | 1500
 | 310 |  |  |  | 1500
 | 311 |  |  |  | 1500
 | 312 |  |  |  | 1500
 | 313 |  |  |  | 1500
 | 314 |  |  |  | 1500
 | 315 |  |  |  | 1500
 | 316 |  |  |  | 1500
 | 317 |  |  |  | 1500
 | 318 |  |  |  | 1500
 | 319 |  |  |  | 1500
 | 320 |  |  |  | 1500
 | 321 |  |  |  | 1500
 | 322 |  |  |  | 1500
 | 323 |  |  |  | 1500
 | 324 |  |  |  | 1500
 | 325 |  |  |  | 1500
 | 326 |  |  |  | 1500
 | 327 |  |  |  | 1500
 | 328 |  |  |  | 1500
 | 329 |  |  |  | 1500
 | 330 |  |  |  | 1500
 | 331 |  |  |  | 1500
 | 332 |  |  |  | 1500
 | 333 |  |  |  | 1500
 | 334 |  |  |  | 1500
 | 335 |  |  |  | 1500
 | 336 |  |  |  | 1500
 | 337 |  |  |  | 1500
 | 338 |  |  |  | 1500
 | 339 |  |  |  | 1500
 | 340 |  |  |  | 1500
 | 341 |  |  |  | 1500
 | 342 |  |  |  | 1500
 | 343 |  |  |  | 1500
 | 344 |  |  |  | 1500
 | 345 |  |  |  | 1500
 | 346 |  |  |  | 1500
 | 347 |  |  |  | 1500
 | 348 |  |  |  | 1500
 | 349 |  |  |  | 1500
 | 350 |  |  |  | 1500
 | 351 |  |  |  | 1500
 | 352 |  |  |  | 1500
 | 353 |  |  |  | 1500
 | 354 |  |  |  | 1500
 | 355 |  |  |  | 1500
 | 356 |  |  |  | 1500
 | 357 |  |  |  | 1500
 | 358 |  |  |  | 1500
 | 359 |  |  |  | 1500
 | 360 |  |  |  | 1500