Amortization Calculator Excel - Free Download | Page 7
4.5, 3575 votes
Please vote for this template if it helps you.
Amortization Calculator Excel Page 7
Amortization Calculator Excel
Page 6 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
May-2043 346 - - - - - 0.0% 9.25%
Jun-2043 347 - - - - - 0.0% 9.25%
Jul-2043 348 - - - - - 0.0% 9.25%
Aug-2043 349 - - - - - 0.0% 9.25%
Sep-2043 350 - - - - - 0.0% 9.25%
Oct-2043 351 - - - - - 0.0% 9.25%
Nov-2043 352 - - - - - 0.0% 9.25%
Dec-2043 353 - - - - - 0.0% 9.25%
Jan-2044 354 - - - - - 0.0% 9.25%
Feb-2044 355 - - - - - 0.0% 9.25%
Mar-2044 356 - - - - - 0.0% 9.25%
Apr-2044 357 - - - - - 0.0% 9.25%
May-2044 358 - - - - - 0.0% 9.25%
Jun-2044 359 - - - - - 0.0% 9.25%
Jul-2044 360 - - - - - 0.0% 9.25%
2,198,080.40 1,198,080.40 1,000,000.00
Amortization Calculator Excel Previous Page Amortization Calculator Excel Next Page
Amortization Calculator Excel