Commercial Loan Amortization Schedule Calculator

A commercial loan amortization schedule shows each scheduled payment split between principal and interest, plus the remaining balance over the loan term. Enter the loan amount, annual interest rate, and term below to calculate an estimated monthly payment and total interest; the schedule itself follows the same payment-by-payment method.

Formula

For a fixed-rate loan with equal monthly payments, the payment is calculated as M = P × r ÷ [1 − (1 + r)⁻ⁿ]. Here, M is the monthly payment in dollars, P is the original principal in dollars, r is the monthly interest rate as a decimal, and n is the number of monthly payments. Convert an annual percentage rate to a monthly decimal with r = APR ÷ 1,200, and convert years to payments with n = years × 12.

For the schedule, each period’s interest is the balance at the start of that period multiplied by r. Subtract that interest from the payment to get the principal paid. The ending balance is the starting balance minus principal paid. Total interest in this calculator is I = M × n − P, using the unrounded formula payment in the expression; displayed outputs are rounded to cents. Actual loan schedules may instead apply a cent-rounded payment each month.

Worked Example

Using the calculator’s default inputs: principal P = $20,000, APR 8%, and term 5 years.

1. Monthly rate: r = 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Number of payments: n = 5 × 12 = 60.
3. Payment: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53.
4. Total interest: using the unrounded payment, I = M × 60 − $20,000 ≈ $4,331.93.

For a sample first schedule row, the first month’s interest is $20,000 × 0.0066667 ≈ $133.33. About $272.20 of the $405.53 payment reduces principal, leaving an estimated balance of $19,727.80. Because the calculator’s total-interest expression uses the unrounded payment while the displayed payment is rounded, multiplying the displayed payment by 60 can differ slightly from the displayed total.

Assumptions

• The interest rate remains fixed for the full modeled term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly using APR divided by 12; this is a standard simplified amortization convention.
• The estimate does not include fees, taxes, insurance, escrow, balloon amounts, or other charges. It also does not model interest-only periods, variable rates, or irregular payment dates.

How a Commercial Loan Schedule Works

Commercial real estate and business-purpose loans can use different repayment structures. A fully amortizing loan gradually pays down principal until the balance reaches zero at the end of the stated term, assuming payments are made as scheduled and the contract’s rate and timing match the model. Early payments generally contain a larger interest share because interest is calculated on a larger outstanding balance. As principal declines, the interest portion tends to shrink and more of each level payment goes toward principal.

A schedule usually has columns for payment number or date, payment amount, interest, principal, and remaining balance. To build one, begin with the original balance. For every month, calculate interest on the opening balance, subtract it from the scheduled payment to determine principal reduction, then subtract that reduction from the balance. Small differences can appear at the final payment because lenders may adjust the last amount to clear rounding residuals.

Reading Results and Choosing Inputs

The monthly payment is a modeled installment, not necessarily the full amount due under a commercial loan agreement. Confirm the principal, rate, repayment term, payment frequency, and whether the stated rate is fixed or variable using the lender’s written loan information. A quoted APR may not match the rate convention or fee treatment used in a simplified calculator.

• Loan amount: Use the amount being amortized, not a property value or business purchase price unless that is also the borrowed principal.
• APR: Enter a percentage such as 8 for 8%, not 0.08. Use the applicable loan rate supplied by the lender.
• Term: Enter the amortization period, which may differ from the time until a balloon payment or maturity date.

Commercial loans may have monthly, quarterly, or other payment schedules. This tool assumes monthly payments. To model a different frequency accurately, the period rate and number of payments must both be changed consistently; do not simply treat an annual rate as a monthly rate.

Amortization Versus Loan Term

A common source of confusion is the difference between the amortization period and the contractual loan term. Amortization describes how payments are calculated to repay principal over time. The loan term is the period the agreement remains in effect before maturity or another contractual event. If a loan amortizes over a longer period than its term, the scheduled installments may leave a substantial balance due at maturity. That remaining amount is often called a balloon balance.

For example, a schedule calculated over a long amortization period cannot be used to infer that the debt will be fully repaid by an earlier maturity date. You would need the actual payment structure and the balance at the relevant date. This calculator does not calculate a balloon amount or model a refinance, renewal, or payoff quote.

Common Limits and Mistakes

The standard formula is useful for estimating level payments, but it cannot represent every commercial loan. Interest-only payments, a variable rate, an upfront fee added to principal, a payment holiday, a large final installment, or a non-monthly schedule changes the cash flows. A lender may also use a different day-count convention or adjust payments for dates and rounding.

• Do not confuse APR entered as a percentage with a decimal: enter 8 for 8%, not 0.08.
• Do not assume the term is the amortization period; verify both separately.
• Do not interpret total interest as total borrowing cost when fees and other charges are excluded.
• Do not expect every displayed total to reconcile to the cent when payment and interest values are rounded at different stages.

For a contractual payment schedule, request the lender’s amortization table and compare its assumptions with the calculator. The result is an estimate and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What is a commercial loan amortization schedule?
An amortization schedule is a period-by-period table showing payments, interest, principal reduction, and the remaining loan balance.

How do you calculate a commercial loan payment?
For fixed-rate monthly payments, convert APR to a monthly decimal, find the number of payments, and apply the level-payment formula shown above.

Does a longer amortization period lower the monthly payment?
With the same principal and rate, spreading repayment across more payments generally lowers the calculated installment, while increasing the time over which interest accrues. This is a mathematical comparison, not a recommendation.

Why is the balance not zero at the end of the loan term?
The contractual term may be shorter than the amortization period, or the agreement may include a balloon payment, interest-only period, rate changes, or other features not represented by this calculator.

Does this estimate include commercial loan fees?
No. It estimates principal-and-interest payments from the entered amount, APR, and term. Check the lender’s documents for fees and other amounts due.

Related

• SSI Extra Payments: Who Qualifies and When
• VFS GFV and Extra Payments: How They Affect Your Loan
• Vehicle Payoff Calculator With Extra Payments

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