| Home | Mortgage | Car | Loan | Biweekly | Extra Payment | Refinance | HELOC | Excel |
Amortization Calculator Excel is used to calculate monthly loan payments. The amortization calculator generates an amortization schedule that has all the details about your payment, such as principle, interest, and balance.
Loan Summary |
|||||
Loan Amount: |
$85,000.00 | ||||
Monthly Payment: |
$2,002.08 | ||||
Total # Of Payments: |
48 | ||||
Start Date: |
Oct, 2023 | ||||
Payoff Date: |
Sep, 2027 | ||||
Total Interest Paid: |
$11,099.76 | ||||
Total Payment: |
$96,099.76 | ||||
Amortization Schedule |
|||||
| Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance |
|---|---|---|---|---|---|
| Oct, 2023 | 1 | $435.63 | $1,566.45 | $2,002.08 | $83,433.55 |
| Nov, 2023 | 2 | $427.60 | $1,574.48 | $2,002.08 | $81,859.07 |
| Dec, 2023 | 3 | $419.53 | $1,582.55 | $2,002.08 | $80,276.51 |
| Jan, 2024 | 4 | $411.42 | $1,590.66 | $2,002.08 | $78,685.85 |
| Feb, 2024 | 5 | $403.26 | $1,598.81 | $2,002.08 | $77,087.04 |
| Mar, 2024 | 6 | $395.07 | $1,607.01 | $2,002.08 | $75,480.03 |
| Apr, 2024 | 7 | $386.84 | $1,615.24 | $2,002.08 | $73,864.79 |
| May, 2024 | 8 | $378.56 | $1,623.52 | $2,002.08 | $72,241.27 |
| Jun, 2024 | 9 | $370.24 | $1,631.84 | $2,002.08 | $70,609.43 |
| Jul, 2024 | 10 | $361.87 | $1,640.20 | $2,002.08 | $68,969.22 |
| Aug, 2024 | 11 | $353.47 | $1,648.61 | $2,002.08 | $67,320.61 |
| Sep, 2024 | 12 | $345.02 | $1,657.06 | $2,002.08 | $65,663.55 |
| Oct, 2024 | 13 | $336.53 | $1,665.55 | $2,002.08 | $63,998.00 |
| Nov, 2024 | 14 | $327.99 | $1,674.09 | $2,002.08 | $62,323.91 |
| Dec, 2024 | 15 | $319.41 | $1,682.67 | $2,002.08 | $60,641.24 |
| Jan, 2025 | 16 | $310.79 | $1,691.29 | $2,002.08 | $58,949.95 |
| Feb, 2025 | 17 | $302.12 | $1,699.96 | $2,002.08 | $57,249.99 |
| Mar, 2025 | 18 | $293.41 | $1,708.67 | $2,002.08 | $55,541.32 |
| Apr, 2025 | 19 | $284.65 | $1,717.43 | $2,002.08 | $53,823.89 |
| May, 2025 | 20 | $275.85 | $1,726.23 | $2,002.08 | $52,097.66 |
| Jun, 2025 | 21 | $267.00 | $1,735.08 | $2,002.08 | $50,362.58 |
| Jul, 2025 | 22 | $258.11 | $1,743.97 | $2,002.08 | $48,618.61 |
| Aug, 2025 | 23 | $249.17 | $1,752.91 | $2,002.08 | $46,865.70 |
| Sep, 2025 | 24 | $240.19 | $1,761.89 | $2,002.08 | $45,103.81 |
| Oct, 2025 | 25 | $231.16 | $1,770.92 | $2,002.08 | $43,332.89 |
| Nov, 2025 | 26 | $222.08 | $1,780.00 | $2,002.08 | $41,552.89 |
| Dec, 2025 | 27 | $212.96 | $1,789.12 | $2,002.08 | $39,763.77 |
| Jan, 2026 | 28 | $203.79 | $1,798.29 | $2,002.08 | $37,965.48 |
| Feb, 2026 | 29 | $194.57 | $1,807.51 | $2,002.08 | $36,157.98 |
| Mar, 2026 | 30 | $185.31 | $1,816.77 | $2,002.08 | $34,341.21 |
| Apr, 2026 | 31 | $176.00 | $1,826.08 | $2,002.08 | $32,515.13 |
| May, 2026 | 32 | $166.64 | $1,835.44 | $2,002.08 | $30,679.69 |
| Jun, 2026 | 33 | $157.23 | $1,844.84 | $2,002.08 | $28,834.85 |
| Jul, 2026 | 34 | $147.78 | $1,854.30 | $2,002.08 | $26,980.55 |
| Aug, 2026 | 35 | $138.28 | $1,863.80 | $2,002.08 | $25,116.74 |
| Sep, 2026 | 36 | $128.72 | $1,873.35 | $2,002.08 | $23,243.39 |
| Oct, 2026 | 37 | $119.12 | $1,882.96 | $2,002.08 | $21,360.43 |
| Nov, 2026 | 38 | $109.47 | $1,892.61 | $2,002.08 | $19,467.83 |
| Dec, 2026 | 39 | $99.77 | $1,902.31 | $2,002.08 | $17,565.52 |
| Jan, 2027 | 40 | $90.02 | $1,912.06 | $2,002.08 | $15,653.47 |
| Feb, 2027 | 41 | $80.22 | $1,921.85 | $2,002.08 | $13,731.61 |
| Mar, 2027 | 42 | $70.37 | $1,931.70 | $2,002.08 | $11,799.91 |
| Apr, 2027 | 43 | $60.47 | $1,941.60 | $2,002.08 | $9,858.30 |
| May, 2027 | 44 | $50.52 | $1,951.55 | $2,002.08 | $7,906.75 |
| Jun, 2027 | 45 | $40.52 | $1,961.56 | $2,002.08 | $5,945.19 |
| Jul, 2027 | 46 | $30.47 | $1,971.61 | $2,002.08 | $3,973.58 |
| Aug, 2027 | 47 | $20.36 | $1,981.71 | $2,002.08 | $1,991.87 |
| Sep, 2027 | 48 | $10.21 | $1,991.87 | $2,002.08 | $0.00 |
Amortization Calculator | Terms | Privacy | Disclaimer | Contact
©2023 Amortization Calculator