LOAN AMORTIZATION SCHEDULE
ENTER VALUES LOAN SUMMARY
Loan amount $1,000,000.00 Enter info here to Scheduled payment $135,867.96 Table values are
Annual interest rate 6.00% show the loan Scheduled number of payments 10 calculated for you.
Loan period in years 10 payments in the Actual number of payments 10 Enter the informatio
Number of payments per year 1 table below. Total early payments to the left and watch
Start date of loan 1/1/2024 Total interest $248,196.12 your loan history
populate.
Optional extra payments LENDER NAME
PMT PAYMENT CHECK BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
NO DATE NUMBER CHECK DATE BALANCE PAYMENT PAYMENT PAYMENT PRINCIPAL INTEREST BALANCE INTEREST
1 1/1/2024 $1,000,000.00 $135,867.96 $0.00 $135,867.96 $75,867.96 $60,000.00 $924,132.04 $60,000.00
2 2/1/2024 $924,132.04 $135,867.96 $0.00 $135,867.96 $80,420.04 $55,447.92 $843,712.01 $115,447.92
3 3/1/2024 $843,712.01 $135,867.96 $0.00 $135,867.96 $85,245.24 $50,622.72 $758,466.77 $166,070.64
4 4/1/2024 $758,466.77 $135,867.96 $0.00 $135,867.96 $90,359.95 $45,508.01 $668,106.82 $211,578.65
5 5/1/2024 $668,106.82 $135,867.96 $0.00 $135,867.96 $95,781.55 $40,086.41 $572,325.27 $251,665.06
6 6/1/2024 $572,325.27 $135,867.96 $0.00 $135,867.96 $101,528.44 $34,339.52 $470,796.82 $286,004.57
7 7/1/2024 $470,796.82 $135,867.96 $0.00 $135,867.96 $107,620.15 $28,247.81 $363,176.68 $314,252.38
8 8/1/2024 $363,176.68 $135,867.96 $0.00 $135,867.96 $114,077.36 $21,790.60 $249,099.32 $336,042.98
9 9/1/2024 $249,099.32 $135,867.96 $0.00 $135,867.96 $120,922.00 $14,945.96 $128,177.32 $350,988.94
10 10/1/2024 $128,177.32 $135,867.96 $0.00 $128,177.32 $120,486.68 $7,690.64 $0.00 $358,679.58
PMT PAYMENT CHECK BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
NO DATE NUMBER CHECK DATE BALANCE PAYMENT PAYMENT PAYMENT PRINCIPAL INTEREST BALANCE INTEREST
Page 2 of 4
PMT PAYMENT CHECK BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
NO DATE NUMBER CHECK DATE BALANCE PAYMENT PAYMENT PAYMENT PRINCIPAL INTEREST BALANCE INTEREST
Page 3 of 4
PMT PAYMENT CHECK BEGINNING SCHEDULED EXTRA TOTAL ENDING CUMULATIVE
NO DATE NUMBER CHECK DATE BALANCE PAYMENT PAYMENT PAYMENT PRINCIPAL INTEREST BALANCE INTEREST
Page 4 of 4
