Free Monthly Amortization Schedule Template
Monthly Amortization Schedule
Prepared by: [Your Name]
Month 1: January
Week 1
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
1 |
01-Jan |
$10,000.00 |
$50.00 |
$811.60 |
$9,188.40 |
Week 2
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
2 |
08-Jan |
$9,188.40 |
$45.94 |
$815.66 |
$8,372.74 |
Week 3
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
3 |
15-Jan |
$8,372.74 |
$41.86 |
$819.74 |
$7,553.00 |
Week 4
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
4 |
22-Jan |
$7,553.00 |
$37.77 |
$823.83 |
$6,729.17 |
Month 2: February
Week 1
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
5 |
01-Feb |
$6,729.17 |
$33.65 |
$827.95 |
$5,901.22 |
Week 2
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
6 |
08-Feb |
$5,901.22 |
$29.51 |
$832.09 |
$5,069.14 |
Week 3
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
7 |
15-Feb |
$5,069.14 |
$25.35 |
$836.25 |
$4,232.89 |
Week 4
|
Payment # |
Payment Date |
Beginning Balance |
Interest |
Principal |
Ending Balance |
|---|---|---|---|---|---|
|
8 |
22-Feb |
$4,232.89 |
$21.16 |
$840.44 |
$3,392.45 |
