Monthly Payment Sheet: Estimate a Fixed-Rate Loan

A monthly payment sheet summarizes a loan’s estimated payment and related figures, such as total interest, using the amount borrowed, annual percentage rate (APR), and repayment term. Enter those three values below to estimate a fixed monthly payment and the total interest paid across the scheduled payments.

Formula

The calculator uses the standard amortizing-loan payment formula. It assumes the same payment is made once each month, with interest accruing monthly at one-twelfth of the entered annual percentage rate.

Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]

Total interest: I = M × n − P

• P is the starting loan principal, in dollars.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8% per year.
• r is the monthly rate as a decimal: APR ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.
• M is the calculated monthly payment, rounded to the nearest cent.
• I is estimated total interest over the full schedule, using the displayed, cent-rounded payment.

The equivalent calculator expression for the payment is P × (APR ÷ 1,200) ÷ [1 − (1 + APR ÷ 1,200)^{−(years × 12)}]. The APR is converted to a monthly decimal rate: for example, 8% becomes 0.08 ÷ 12, or about 0.006667 per month. This is a mathematical estimate, not a lender’s payment quote.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—there are 5 × 12 = 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667.

Substitute those figures into the payment formula:

M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53.

The estimated total of the 60 rounded payments is $405.53 × 60 = $24,331.80. Subtract the original principal to estimate interest: $24,331.80 − $20,000 = $4,331.80. The calculator therefore displays a monthly payment of $405.53 and total interest of $4,331.80. Small differences can occur if a lender rounds each month’s interest or adjusts the final payment.

Assumptions

• The interest rate is fixed for the entire term.
• Payments are equal, made monthly, and begin one month after the loan starts.
• Interest is modelled with monthly compounding at APR ÷ 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and other charges because they are not inputs.
• The term represents the full scheduled repayment period, with no missed or extra payments.

What a Monthly Payment Sheet Shows

A monthly payment sheet is a convenient summary for understanding scheduled loan costs. It may be a calculator printout, a spreadsheet, a lender’s estimate, or a payment schedule. Depending on its source, it can show the principal-and-interest payment, the number of payments, the estimated total repaid, and an amortization breakdown that separates each payment into interest and principal.

The phrase does not have one universal document format. A sheet created for a car loan may show vehicle-related charges separately, while a mortgage estimate may display escrow or insurance alongside principal and interest. Read the labels carefully: a figure called “monthly payment” might include only loan repayment or may combine several costs. This calculator estimates principal and interest only.

How to Read the Estimate

The monthly payment is the scheduled amount under the formula’s assumptions. Early in a typical amortizing loan, a larger share of each payment goes toward interest because interest is calculated on a relatively high outstanding balance. As principal is repaid, the interest portion generally declines and more of each level payment reduces principal.

Total interest is not the same as total repayment. In the example, total repayment is $24,331.80, comprising the original $20,000 principal and $4,331.80 in estimated interest. This total assumes every payment is made on schedule and uses the rounded monthly payment. It does not include any charges omitted from the inputs.

A longer term generally spreads repayment over more months; for an otherwise identical principal and rate, that usually reduces the scheduled monthly amount while increasing the number of months over which interest accrues. A different rate also changes the result. These are mathematical relationships, not a prediction of any particular lender’s offer.

Using the Sheet and Checking Inputs

1. Enter the amount borrowed, not the total price of an item unless that entire amount is being financed.
2. Enter APR as a percentage number: type 8 for 8%, not 0.08 or 8% converted to a monthly rate.
3. Enter the term in years. The calculator converts it to months by multiplying by 12.
4. Compare the output with the loan’s disclosed payment schedule, checking whether that schedule includes charges not modelled here.

For example, a $25,000 loan at 6% APR for four years uses 48 payments and a monthly rate of 0.005. The formula estimates principal and interest only; the actual result depends on the contract’s rate, timing, rounding, and any included charges. Use figures supplied for the specific loan rather than treating the example defaults as a market rate or offer.

Common Questions About Monthly Payment Sheets

A common misconception is that the monthly figure alone tells you the full cost. It does not: the term and interest rate matter, and fees or other recurring expenses may not appear in a principal-and-interest estimate. Another frequent source of error is entering an APR as a decimal rather than as a percentage number.

The formula also assumes a fixed rate and regular monthly payments. A variable rate, irregular payment dates, payment holidays, extra principal payments, or a final adjusted installment can make a real schedule differ from this estimate. For an exact schedule, check the payment terms and disclosures for the specific loan.

Frequently Asked Questions

What does a monthly payment sheet include?
It commonly summarizes a scheduled payment and may show principal, interest, term, and total repayment. What it includes varies; confirm whether fees, taxes, insurance, or escrow are part of the displayed amount.

How do I calculate a monthly loan payment?
Convert APR to a monthly decimal rate by dividing by 1,200, convert the term to months, then apply the amortizing-payment formula shown above. This calculator performs those steps and rounds the payment to cents.

Is APR the same as the monthly interest rate?
No. APR is entered as a yearly percentage here. The formula converts it to a monthly rate by dividing by 1,200; an 8% APR corresponds to about 0.6667% per month in this model.

Why is my lender’s payment different?
The lender may include fees or other costs, use different rounding or payment dates, or apply terms not represented by this fixed-rate formula. Compare the same loan amount, APR, term, and payment components.

Does this estimate include insurance or taxes?
No. The calculator has no inputs for those costs, so its monthly payment is an estimate of principal and interest only.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• DFS Monthly Payments: Options and How They Work
• CPP Second Additional Payment: What It Means
• BMW X5 Monthly Payment Calculator and Cost Factors

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