0% found this document useful (0 votes)
7 views11 pages

Loan Amortization Schedule Overview

The document is an amortization schedule for a $5,000 loan with a 4% annual interest rate taken out over 1 year and paid back in monthly installments. It shows the borrower will make 12 monthly payments of $425.75 each along with optional extra payments of $100 per month. By making the extra payments, the borrower will pay off the loan 9 months early having paid a total of $900 in principal above the scheduled amounts. In total, the borrower will pay $89.62 in interest on the loan over the course of the amortization period.

Uploaded by

Hải Vân
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)
7 views11 pages

Loan Amortization Schedule Overview

The document is an amortization schedule for a $5,000 loan with a 4% annual interest rate taken out over 1 year and paid back in monthly installments. It shows the borrower will make 12 monthly payments of $425.75 each along with optional extra payments of $100 per month. By making the extra payments, the borrower will pay off the loan 9 months early having paid a total of $900 in principal above the scheduled amounts. In total, the borrower will pay $89.62 in interest on the loan over the course of the amortization period.

Uploaded by

Hải Vân
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

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 2/20/2024 Total interest $89.62

Optional extra payments $100.00 LENDER NAME Woodgrove Bank

PMT BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE


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

Page 2 of 11
PMT BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT PAYMENT BALANCE INTEREST

Page 3 of 11
PMT BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT PAYMENT BALANCE INTEREST

Page 4 of 11
PMT BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT PAYMENT BALANCE INTEREST

Page 5 of 11
PMT BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
PAYMENT DATE PRINCIPAL INTEREST
NO BALANCE PAYMENT PAYMENT PAYMENT BALANCE INTEREST

Page 6 of 11
Product TOTAL PAYMENT PRICE INTEREST Discount
TV 525.75 509.08 16.67 432.72
Laptop 525.75 510.78 14.97 434.163
Desktop 525.75 512.48 13.27 435.61
Camera 525.75 514.19 11.56 437.062
Projector 525.75 515.90 9.84 438.519
Printer 525.75 517.62 8.13 439.981
Keyboard 525.75 519.35 6.40 441.447
Mouse 525.75 521.08 4.67 442.919
BEGINNING SCHEDULEEXTRA PAYMTOTAL PAYPRINCIPAL INTEREST
5000 425.74952 100 525.74952 509.082854 16.6666666666667
4490.917146 425.74952 100 525.74952 510.779797 14.9697238189629
3980.137349 425.74952 100 525.74952 512.482396 13.2671244951002
3467.654952 425.74952 100 525.74952 514.190671 11.5588498401579
2953.464281 425.74952 100 525.74952 515.90464 9.84488093636576
2437.559641 425.74952 100 525.74952 517.624322 8.12519880289435
1919.935319 425.74952 100 525.74952 519.349737 6.3997843956447
1400.585582 425.74952 100 525.74952 521.080902 4.66861860703755
879.5046797 425.74952 100 525.74952 522.817839 2.93168226580171
356.686841 425.74952 0 356.68684 355.497885 1.18895613676175

Company First Name Middle Name Last Name Suffix Company


Tinhocfighter Alistair Carrington Hiker's Way
Baradoch Brochanon Green Soles Adventure Club
Irma Tenderfoot Green Soles Adventure Club
ENDING BA CUMULATIVE INTEREST
4490.91715 16.6667
3980.13735 31.6364
3467.65495 44.9035
2953.46428 56.4624
2437.55964 66.3072
1919.93532 74.4324
1400.58558 80.8322
879.50468 85.5008
356.686841 88.4325
0 89.6215

Department Job Title Business Street Business City Business State Business Postal Code
Business Country Home Street Home City Home State Home Postal Code Home Country

You might also like