A personal amortization schedule with payments is a table that shows each monthly payment on a personal loan, split into the portion that goes toward interest and the portion that reduces the principal balance. You enter the loan amount, the annual interest rate (APR), and the term in years, and the schedule lists every payment date, the payment amount, the interest and principal components, and the remaining balance after each payment. The calculator below works out your fixed monthly payment, the total interest you will pay, and the full schedule behind those numbers.
Formula
The fixed monthly payment for a personal loan is calculated with the standard amortization formula:
Payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
Where:
- P = loan principal (the amount borrowed, in dollars)
- r = monthly interest rate = APR ÷ 12 ÷ 100 (a decimal, e.g., 8% APR → 0.08 ÷ 12 = 0.006667)
- n = total number of monthly payments = term in years × 12
Each month, the interest charge is the current balance times r. The rest of the fixed payment reduces the principal. The balance after any payment k is:
Balance after k payments = P × (1 + r)^k − Payment × ((1 + r)^k − 1) / r
This is the same math used for mortgages and auto loans; a personal loan is just a smaller, shorter version.
Worked Example
Using the calculator defaults: a $20,000 loan at 8% APR for 5 years.
- Monthly rate: r = 8 ÷ 1200 = 0.0066667
- Number of payments: n = 5 × 12 = 60
- Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
- (1.0066667)^60 = 1.4898457
- Numerator = 20000 × 0.0066667 × 1.4898457 = 198.6461
- Denominator = 1.4898457 − 1 = 0.4898457
- Payment = 198.6461 ÷ 0.4898457 = 405.53
So the monthly payment is $405.53. Over 60 payments, you pay 60 × 405.53 = $24,331.80. Total interest = 24,331.80 − 20,000 = $4,331.80, matching the calculator output.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are made at the end of each month, starting one month after the loan is issued.
- Interest compounds monthly at APR ÷ 12.
- No origination fees, late fees, prepayment penalties, or other charges are included.
- The payment is rounded to the cent, and the final payment may differ by a few cents to clear the balance exactly.
How to Read Your Amortization Schedule
Early in the schedule, most of each payment goes to interest. For the $20,000 example, the first payment of $405.53 includes $133.33 of interest and only $272.20 of principal. By the 60th payment, the interest portion is about $2.69 and the principal portion is $402.84. This is not a penalty or a trick; it is simply how a level-payment loan works when the balance is largest at the start.
The schedule also shows the remaining balance after each payment. If you want to know your payoff amount after, say, 24 payments, find the balance at row 24. That is the amount you would need to pay in full, plus any interest that has accrued since the last payment date.
How to Choose a Loan Term
The term you pick changes both the payment and the total interest. A shorter term means a higher monthly payment but far less interest. A longer term lowers the payment but increases total interest. For example, the same $20,000 at 8%:
- 3-year term: payment $626.73, total interest $2,562.28
- 5-year term: payment $405.53, total interest $4,331.80
- 7-year term: payment $311.24, total interest $6,144.16
There is no universally correct choice. The right term depends on your monthly cash flow and how much total interest you are willing to pay. The calculator lets you compare terms side by side before you commit.
Common Mistakes and Misconceptions
Mistake 1: Using the APR as a monthly rate. The APR is annual. You must divide by 12 before using it in the formula. Using 8 instead of 0.006667 would produce a wildly wrong payment.
Mistake 2: Ignoring rounding. The formula gives a payment with many decimals. Lenders round to the cent, and the final payment is adjusted to clear the balance. If you build your own schedule, round each month’s interest to the cent before subtracting from the payment, or your final balance will not reach zero.
Misconception: Paying extra “doesn’t matter” because interest is front-loaded. Extra principal payments reduce the balance immediately, which lowers the interest charged in every later month. Even one extra payment early in the term can shorten the loan by several months. The schedule shows exactly how much.
Misconception: The total interest shown is what you will pay if you miss a payment. The schedule assumes you pay exactly on time every month. Late fees and missed payments are not in this model.
When to Use a Personal Amortization Schedule
Use this schedule before you sign anything to see the true cost of borrowing. It is also useful for:
- Comparing loan offers with different rates and terms
- Planning a payoff date if you intend to make extra payments
- Understanding how much of your payment is interest for tax or budgeting purposes
- Checking the lender’s numbers for errors
The schedule does not include fees, so if a lender quotes an origination fee, add it to the principal to see the real cost. If the lender quotes a different APR than the interest rate, use the APR in the calculator because it reflects the total cost of credit.
Limits of the Calculation
This calculator assumes a fixed rate and a fixed payment. Some personal loans have variable rates, which change the payment over time. Others allow interest-only periods or balloon payments. Those structures require a different calculation. Also, the schedule does not model prepayment penalties, which some lenders charge if you pay off the loan early. Check your loan contract for those terms.
The formula also assumes the interest rate does not change and that you make every payment on the scheduled date. If you pay late, interest accrues daily in many cases, and the actual amortization will differ from the table.
Frequently Asked Questions
How do I calculate my own amortization schedule? Use the formula above or the calculator on this page. For each month, multiply the current balance by the monthly rate to get interest, then subtract that from the fixed payment to get principal. Subtract principal from the balance and repeat. A spreadsheet can do this in minutes.
What happens if I pay extra on my personal loan? The extra amount goes directly to principal, reducing the balance faster. Your scheduled payment stays the same, but the loan ends early and total interest decreases. Some lenders apply extra payments to the next month’s payment instead, so tell the lender to apply it to principal.
Is the APR the same as the interest rate? Not always. The APR includes certain fees and costs, so it can be higher than the stated interest rate. Use the APR in the calculator for a more accurate total cost, but check the loan disclosure for exactly which fees are included.
Why is my first payment mostly interest? Because the balance is highest at the start. Interest is calculated on the full remaining balance, so early payments carry the largest interest charge. As the balance shrinks, the interest portion shrinks with it.
Can I pay off a personal loan early without penalty? Some lenders allow it, others charge a prepayment penalty. The amortization schedule assumes no penalty. Read your loan agreement or ask the lender directly before making extra payments.
This result is an estimate for educational purposes; the lender’s official disclosure will show the exact payment, interest, and fees for your specific loan.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Personal Loans Interest Free? The Real Answer$405.53
- Personal Loan 0% Interest: Is It Real?$405.53
- Personal Loan Zero Interest: Is It Real?$405.53
- Only Loans LLC: What It Is and How It Works$405.53
- Personal Loan and Interest Only Option?$133.33
- No Interest Personal Loan? What It Really Means$405.53