0% found this document useful (0 votes)
40 views9 pages

Loan Amortization Schedule

The document outlines a 1-year $5,000 loan amortization schedule with monthly payments of $425.75 and optional extra payments of $100 per month. It shows that with the extra payments, the borrower will pay off the loan in 10 months, paying a total of $900 in principal above the scheduled amount and $89.62 in total interest.

Uploaded by

aman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
40 views9 pages

Loan Amortization Schedule

The document outlines a 1-year $5,000 loan amortization schedule with monthly payments of $425.75 and optional extra payments of $100 per month. It shows that with the extra payments, the borrower will pay off the loan in 10 months, paying a total of $900 in principal above the scheduled amount and $89.62 in total interest.

Uploaded by

aman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

LOAN AMORTIZATION SCHEDULE

ENTER VALUES LOAN SUMMARY


Loan amount $5,000.00 Scheduled payment $425.75
Annual interest rate 4.00% Scheduled number of payments 12
Loan period in years 1 Actual number of payments
Number of payments per year 12 Total early payments $900.00
Start date of loan 12/1/2020 Total interest $89.62

Optional extra payments $100.00 LENDER NAME Woodgrove Bank

SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT
1 12/1/2020 $5,000.00 $425.75 $100.00 $525.75 $509.08 $16.67 $4,490.92 $16.67
2 1/1/2021 $4,490.92 $425.75 $100.00 $525.75 $510.78 $14.97 $3,980.14 $31.64
3 2/1/2021 $3,980.14 $425.75 $100.00 $525.75 $512.48 $13.27 $3,467.65 $44.90
4 3/1/2021 $3,467.65 $425.75 $100.00 $525.75 $514.19 $11.56 $2,953.46 $56.46
5 4/1/2021 $2,953.46 $425.75 $100.00 $525.75 $515.90 $9.84 $2,437.56 $66.31
6 5/1/2021 $2,437.56 $425.75 $100.00 $525.75 $517.62 $8.13 $1,919.94 $74.43
7 6/1/2021 $1,919.94 $425.75 $100.00 $525.75 $519.35 $6.40 $1,400.59 $80.83
8 7/1/2021 $1,400.59 $425.75 $100.00 $525.75 $521.08 $4.67 $879.50 $85.50
9 8/1/2021 $879.50 $425.75 $100.00 $525.75 $522.82 $2.93 $356.69 $88.43
10 9/1/2021 $356.69 $425.75 $0.00 $356.69 $355.50 $1.19 $0.00 $89.62
11 10/1/2021 $0.00 $425.75 $0.00 $0.00 $0.00 $0.00 $0.00 $89.62
12 11/1/2021 $0.00 $425.75 $0.00 $0.00 $0.00 $0.00 $0.00 $89.62

Page 1 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 2 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 3 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 4 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 5 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 6 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 7 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 8 of 9
SCHEDULE
PMT BEGINNING EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE D PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT BALANCE INTEREST
PAYMENT

Page 9 of 9

You might also like