Amortization Calculator Excel - Free Download | Page 6
4.5, 3575 votes
Please vote for this template if it helps you.
Amortization Calculator Excel Page 6
Amortization Calculator Excel
Page 5 of 7
Loan Amortization Table
© www.excel-skills.com
1,000,000.00
9.25%
240.00
9,158.67
8/15/14
End
Month
Repayment
Number
Opening
Balance
Loan
Repayment
Interest
Charged
Capital Repaid
Closing
Balance
% Capital
Outstanding
Interest Rate
Loan Start Date
Repayment Type
Loan Principle Amount
Annual Interest Rate
Loan Period (in months)
Original Repayment Amount
Aug-2037 277 - - - - - 0.0% 9.25%
Sep-2037 278 - - - - - 0.0% 9.25%
Oct-2037 279 - - - - - 0.0% 9.25%
Nov-2037 280 - - - - - 0.0% 9.25%
Dec-2037 281 - - - - - 0.0% 9.25%
Jan-2038 282 - - - - - 0.0% 9.25%
Feb-2038 283 - - - - - 0.0% 9.25%
Mar-2038 284 - - - - - 0.0% 9.25%
Apr-2038 285 - - - - - 0.0% 9.25%
May-2038 286 - - - - - 0.0% 9.25%
Jun-2038 287 - - - - - 0.0% 9.25%
Jul-2038 288 - - - - - 0.0% 9.25%
Aug-2038 289 - - - - - 0.0% 9.25%
Sep-2038 290 - - - - - 0.0% 9.25%
Oct-2038 291 - - - - - 0.0% 9.25%
Nov-2038 292 - - - - - 0.0% 9.25%
Dec-2038 293 - - - - - 0.0% 9.25%
Jan-2039 294 - - - - - 0.0% 9.25%
Feb-2039 295 - - - - - 0.0% 9.25%
Mar-2039 296 - - - - - 0.0% 9.25%
Apr-2039 297 - - - - - 0.0% 9.25%
May-2039 298 - - - - - 0.0% 9.25%
Jun-2039 299 - - - - - 0.0% 9.25%
Jul-2039 300 - - - - - 0.0% 9.25%
Aug-2039 301 - - - - - 0.0% 9.25%
Sep-2039 302 - - - - - 0.0% 9.25%
Oct-2039 303 - - - - - 0.0% 9.25%
Nov-2039 304 - - - - - 0.0% 9.25%
Dec-2039 305 - - - - - 0.0% 9.25%
Jan-2040 306 - - - - - 0.0% 9.25%
Feb-2040 307 - - - - - 0.0% 9.25%
Mar-2040 308 - - - - - 0.0% 9.25%
Apr-2040 309 - - - - - 0.0% 9.25%
May-2040 310 - - - - - 0.0% 9.25%
Jun-2040 311 - - - - - 0.0% 9.25%
Jul-2040 312 - - - - - 0.0% 9.25%
Aug-2040 313 - - - - - 0.0% 9.25%
Sep-2040 314 - - - - - 0.0% 9.25%
Oct-2040 315 - - - - - 0.0% 9.25%
Nov-2040 316 - - - - - 0.0% 9.25%
Dec-2040 317 - - - - - 0.0% 9.25%
Jan-2041 318 - - - - - 0.0% 9.25%
Feb-2041 319 - - - - - 0.0% 9.25%
Mar-2041 320 - - - - - 0.0% 9.25%
Apr-2041 321 - - - - - 0.0% 9.25%
May-2041 322 - - - - - 0.0% 9.25%
Jun-2041 323 - - - - - 0.0% 9.25%
Jul-2041 324 - - - - - 0.0% 9.25%
Aug-2041 325 - - - - - 0.0% 9.25%
Sep-2041 326 - - - - - 0.0% 9.25%
Oct-2041 327 - - - - - 0.0% 9.25%
Nov-2041 328 - - - - - 0.0% 9.25%
Dec-2041 329 - - - - - 0.0% 9.25%
Jan-2042 330 - - - - - 0.0% 9.25%
Feb-2042 331 - - - - - 0.0% 9.25%
Mar-2042 332 - - - - - 0.0% 9.25%
Apr-2042 333 - - - - - 0.0% 9.25%
May-2042 334 - - - - - 0.0% 9.25%
Jun-2042 335 - - - - - 0.0% 9.25%
Jul-2042 336 - - - - - 0.0% 9.25%
Aug-2042 337 - - - - - 0.0% 9.25%
Sep-2042 338 - - - - - 0.0% 9.25%
Oct-2042 339 - - - - - 0.0% 9.25%
Nov-2042 340 - - - - - 0.0% 9.25%
Dec-2042 341 - - - - - 0.0% 9.25%
Jan-2043 342 - - - - - 0.0% 9.25%
Feb-2043 343 - - - - - 0.0% 9.25%
Mar-2043 344 - - - - - 0.0% 9.25%
Apr-2043 345 - - - - - 0.0% 9.25%
Amortization Calculator Excel Previous Page Amortization Calculator Excel Next Page
Amortization Calculator Excel