![]() |
Advanced | Simple | FHA | USDA | VA | Commercial | Early Payoff | Refinance | Interest Only | Balloon | Widget |
Student Loan Calculator Excel with Amortization is used to calculate monthly payments for your student loan. Student loan calculator with interest paid calculates total payment, interest, payoff date and amortization schedule. Enter the loan amount, term and interest rate, and the student loan calculator will calculate monthly payment for your student finance. You can export the student loan amortization schedule to an excel sheet that your can review later.
https://mortgage-calculator.net | ||||||
Loan & Payment Summary |
||||||
Loan Amount: |
$20,000.00 | |||||
Monthly Payment: |
$358.04 | |||||
Total # Of Payments: |
60 | |||||
Start Date: |
Apr, 2021 | |||||
Payoff Date: |
Mar, 2026 | |||||
Total Interest Paid: |
$1,482.53 | |||||
Total Payment: |
$21,482.53 | |||||
Amortization Schedule |
||||||
Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
---|---|---|---|---|---|---|
Apr, 2021 | 1 | $47.50 | $310.54 | $358.04 | $19,689.46 | |
May, 2021 | 2 | $46.76 | $311.28 | $358.04 | $19,378.18 | |
Jun, 2021 | 3 | $46.02 | $312.02 | $358.04 | $19,066.16 | |
Jul, 2021 | 4 | $45.28 | $312.76 | $358.04 | $18,753.40 | |
Aug, 2021 | 5 | $44.54 | $313.50 | $358.04 | $18,439.90 | |
Sep, 2021 | 6 | $43.79 | $314.25 | $358.04 | $18,125.65 | |
Oct, 2021 | 7 | $43.05 | $314.99 | $358.04 | $17,810.65 | |
Nov, 2021 | 8 | $42.30 | $315.74 | $358.04 | $17,494.91 | |
Dec, 2021 | 9 | $41.55 | $316.49 | $358.04 | $17,178.42 | |
Jan, 2022 | 10 | $40.80 | $317.24 | $358.04 | $16,861.18 | |
Feb, 2022 | 11 | $40.05 | $318.00 | $358.04 | $16,543.18 | |
Mar, 2022 | 12 | $39.29 | $318.75 | $358.04 | $16,224.43 | |
Apr, 2022 | 13 | $38.53 | $319.51 | $358.04 | $15,904.92 | |
May, 2022 | 14 | $37.77 | $320.27 | $358.04 | $15,584.65 | |
Jun, 2022 | 15 | $37.01 | $321.03 | $358.04 | $15,263.62 | |
Jul, 2022 | 16 | $36.25 | $321.79 | $358.04 | $14,941.83 | |
Aug, 2022 | 17 | $35.49 | $322.56 | $358.04 | $14,619.28 | |
Sep, 2022 | 18 | $34.72 | $323.32 | $358.04 | $14,295.95 | |
Oct, 2022 | 19 | $33.95 | $324.09 | $358.04 | $13,971.87 | |
Nov, 2022 | 20 | $33.18 | $324.86 | $358.04 | $13,647.01 | |
Dec, 2022 | 21 | $32.41 | $325.63 | $358.04 | $13,321.38 | |
Jan, 2023 | 22 | $31.64 | $326.40 | $358.04 | $12,994.97 | |
Feb, 2023 | 23 | $30.86 | $327.18 | $358.04 | $12,667.79 | |
Mar, 2023 | 24 | $30.09 | $327.96 | $358.04 | $12,339.84 | |
Apr, 2023 | 25 | $29.31 | $328.74 | $358.04 | $12,011.10 | |
May, 2023 | 26 | $28.53 | $329.52 | $358.04 | $11,681.59 | |
Jun, 2023 | 27 | $27.74 | $330.30 | $358.04 | $11,351.29 | |
Jul, 2023 | 28 | $26.96 | $331.08 | $358.04 | $11,020.20 | |
Aug, 2023 | 29 | $26.17 | $331.87 | $358.04 | $10,688.33 | |
Sep, 2023 | 30 | $25.38 | $332.66 | $358.04 | $10,355.68 | |
Oct, 2023 | 31 | $24.59 | $333.45 | $358.04 | $10,022.23 | |
Nov, 2023 | 32 | $23.80 | $334.24 | $358.04 | $9,687.99 | |
Dec, 2023 | 33 | $23.01 | $335.03 | $358.04 | $9,352.96 | |
Jan, 2024 | 34 | $22.21 | $335.83 | $358.04 | $9,017.13 | |
Feb, 2024 | 35 | $21.42 | $336.63 | $358.04 | $8,680.50 | |
Mar, 2024 | 36 | $20.62 | $337.43 | $358.04 | $8,343.08 | |
Apr, 2024 | 37 | $19.81 | $338.23 | $358.04 | $8,004.85 | |
May, 2024 | 38 | $19.01 | $339.03 | $358.04 | $7,665.82 | |
Jun, 2024 | 39 | $18.21 | $339.84 | $358.04 | $7,325.98 | |
Jul, 2024 | 40 | $17.40 | $340.64 | $358.04 | $6,985.34 | |
Aug, 2024 | 41 | $16.59 | $341.45 | $358.04 | $6,643.89 | |
Sep, 2024 | 42 | $15.78 | $342.26 | $358.04 | $6,301.62 | |
Oct, 2024 | 43 | $14.97 | $343.08 | $358.04 | $5,958.55 | |
Nov, 2024 | 44 | $14.15 | $343.89 | $358.04 | $5,614.66 | |
Dec, 2024 | 45 | $13.33 | $344.71 | $358.04 | $5,269.95 | |
Jan, 2025 | 46 | $12.52 | $345.53 | $358.04 | $4,924.42 | |
Feb, 2025 | 47 | $11.70 | $346.35 | $358.04 | $4,578.08 | |
Mar, 2025 | 48 | $10.87 | $347.17 | $358.04 | $4,230.91 | |
Apr, 2025 | 49 | $10.05 | $347.99 | $358.04 | $3,882.91 | |
May, 2025 | 50 | $9.22 | $348.82 | $358.04 | $3,534.09 | |
Jun, 2025 | 51 | $8.39 | $349.65 | $358.04 | $3,184.45 | |
Jul, 2025 | 52 | $7.56 | $350.48 | $358.04 | $2,833.97 | |
Aug, 2025 | 53 | $6.73 | $351.31 | $358.04 | $2,482.65 | |
Sep, 2025 | 54 | $5.90 | $352.15 | $358.04 | $2,130.51 | |
Oct, 2025 | 55 | $5.06 | $352.98 | $358.04 | $1,777.53 | |
Nov, 2025 | 56 | $4.22 | $353.82 | $358.04 | $1,423.71 | |
Dec, 2025 | 57 | $3.38 | $354.66 | $358.04 | $1,069.04 | |
Jan, 2026 | 58 | $2.54 | $355.50 | $358.04 | $713.54 | |
Feb, 2026 | 59 | $1.69 | $356.35 | $358.04 | $357.19 | |
Mar, 2026 | 60 | $0.85 | $357.19 | $358.04 | $0.00 |
The student loan repayment calculator shows how much interest you will be paying at the end of your loan. If you want to payoff your student loan faster and save on interest payment, you can use the student loan prepayment calculator.
Mortgage Calculator | Terms | Privacy | Disclaimer | Contact
©2021 Mortgage Calculator With PMI and Taxes