A payment schedule book is a record of when payments are due and how much is owed; for a loan, an amortization schedule provides the fuller picture by showing how each payment is divided between principal and interest. Use this calculator to estimate a fixed-rate loan’s monthly payment and total interest from its amount, annual percentage rate (APR), and term.
Formula
The calculator estimates a level monthly payment using the standard fixed-rate amortizing-loan formula:
Payment = P × r ÷ [1 − (1 + r)−n]
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200.
- n is the number of monthly payments: years × 12.
- Payment is the estimated monthly amount, in dollars.
Total interest is calculated as monthly payment × number of payments − principal. The payment is rounded to cents before the total is calculated, so the displayed total reflects repeated payments at that rounded amount.
Worked Example
Using the calculator’s defaults: a $20,000 loan, 8% APR, and a five-year term.
- Convert APR to a monthly decimal rate: 8 ÷ 1200 = 0.0066667.
- Find the number of payments: 5 × 12 = 60.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The monthly payment is approximately $405.53 after rounding to cents.
- Total paid using that rounded payment is $405.53 × 60 = $24,331.80. Subtract the $20,000 principal: estimated total interest is $4,331.80.
Assumptions
- The interest rate stays fixed for the entire term.
- Payments are equal, monthly, and made at the end of each period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, escrow, and any separate charges are not included.
What a Payment Schedule Book Shows
In everyday use, “payment schedule book” can mean a notebook, ledger, planner, or digital record used to track bills and installments. A simple schedule may list the creditor or bill, due date, amount due, date paid, payment method, and confirmation or reference number. For borrowing, the term may also refer to an amortization table: a row-by-row projection of the loan balance over time.
In a standard amortizing loan, the payment amount is generally level when the rate and terms remain fixed, but the portions going to interest and principal change. Early in the schedule, the outstanding balance is larger, so interest for that period takes a larger share. As principal is paid down, the interest share usually declines and the principal share increases. The schedule’s final balance should reach zero after the planned payments, subject to rounding and actual payment handling.
How to Use the Estimate
Enter the principal you expect to borrow, the APR quoted for the loan, and the term in years. The result is a mathematical estimate, not a payment notice or lender offer. For example, a quoted APR should be entered as a percentage such as 8, not as 0.08. The calculator converts it internally to a monthly rate.
Compare the monthly estimate with the payment schedule or disclosure supplied for the specific loan, and check that both use the same amount financed, rate, term, payment frequency, and treatment of fees. A lender’s schedule may include an irregular first period, financed charges, a final payment adjusted for rounding, or terms that are not represented by this simplified formula. Use the lender’s figures when recording the amount actually due.
A payment schedule book can also help with routine organization. Record the due date and the actual payment date separately: paying on one date does not change the contractual due date. Keep receipts or confirmation numbers with the entry, and update the balance from a reliable statement rather than assuming that every payment is applied exactly as a basic amortization model predicts.
Common Mistakes and Limits
- Confusing APR formats: Enter 8 for 8%, not 0.08. The formula divides the annual percentage by 1200 to obtain a monthly decimal.
- Mixing terms and payment counts: A five-year term means 60 monthly payments in this calculation, not five payments.
- Treating total interest as total cost: The interest output excludes fees and other expenses. It also does not represent the total of every possible charge related to borrowing.
- Assuming every loan is fixed-rate: A changing rate can change future payments or the payoff timeline; this calculator keeps APR constant.
- Ignoring payment timing and rounding: Actual interest accrual conventions, payment dates, and cent-rounding practices can cause small differences from a projection.
The formula applies to equal monthly payments on a fully amortizing loan with a positive rate. It does not calculate a variable-rate payment, interest-only period, balloon payment, deferred-interest arrangement, or a schedule with extra payments. It is useful for understanding the basic arithmetic, but not a substitute for the contract’s payment terms.
Keeping a Useful Record
For a personal payment ledger, consistency matters more than elaborate formatting. A paper book or spreadsheet can include these fields:
- Bill or loan name and account reference, stored securely.
- Scheduled due date and expected amount.
- Payment date, amount actually sent, and confirmation number.
- Remaining balance, updated from a statement when available.
For security, avoid writing full account numbers, passwords, or other sensitive credentials in an easily accessible notebook. If you maintain a digital copy, protect access and keep a backup. A tracker helps organize information, but it does not replace official statements, payment confirmations, or notices about changes to an account.
Frequently Asked Questions
What is a payment schedule book?
It is a record of payments and due dates. For a loan, it may mean an amortization schedule listing each projected payment, its principal and interest portions, and the remaining balance.
Is a payment schedule the same as an amortization schedule?
Not always. A general payment schedule lists amounts and dates. An amortization schedule is a specific loan schedule that also shows how payments reduce principal and cover interest over time.
Why does the interest portion change when my monthly payment is fixed?
Interest is calculated on the outstanding balance. As principal falls, less interest accrues for a period, so more of a level payment can go toward principal.
Does this calculator include fees or insurance?
No. It estimates principal-and-interest payments from the amount, APR, and term. Enter any additional costs separately when reviewing the full payment information provided for a loan.
Why might my lender’s payment differ from the estimate?
The lender may use different financed amounts, payment dates, fee treatment, rate terms, or rounding. The estimate also assumes a fixed rate and regular end-of-month payments, so consult the loan’s actual disclosure for its figures.
This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.
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
- June Balance Date: What It Means for Loan Balances$405.53
- L&T Finance Gold Loan: How It Works and What to Check
- Journal Entry to Correct a Beginning Balance
- JS Bank Gold Loan: Eligibility, Process and Costs
- Journal Entry for a Bank Loan: Debit and Credit$20,000.00
- Journal Entry to Adjust Beginning Balance