How to Calculate Commercial Loan Payments, Interest & Amortization

What Is a Commercial Loan Calculator?

A commercial loan calculation is a method that helps you estimate the monthly principal and interest payment on a commercial mortgage or term loan. It applies the standard amortization formula to a set of inputs: loan amount, annual interest rate, and the number of payments (usually based on the amortization period).

This page explains the math behind that tool. You will learn the variables that drive your payment, how the formula works, and how to interpret results. You can then apply the same steps with any spreadsheet or calculator.

Sources: Bureau of the Fiscal Service, Mortgage Calculator

Key Variables in Commercial Loan Calculations

Three primary factors determine the monthly payment on a fully amortizing commercial loan: the loan amount, the interest rate, and the amortization period. The amortization period is the length of time over which the principal would be fully repaid if you made level payments. For commercial mortgages, the amortization period is often 25 or 30 years, even when the loan term is shorter.

The loan term is the actual length of the loan contract, often 5, 10, or 15 years for commercial mortgages. When the term is shorter than the amortization period, a balloon payment is due at maturity—the remaining principal balance becomes payable in one lump sum.

Other costs, such as property taxes, insurance, and lender fees, are not part of the basic principal-and-interest calculation, but they can affect your total monthly outlay.

• Loan amount (principal)
• Annual interest rate
• Amortization period (years)
• Loan term (years, often shorter than amortization)
• Possible balloon payment at the end of the term

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau, Mortgage Calculator

The Loan Payment Formula Explained

For a fully amortizing loan, the monthly payment (M) is calculated with this formula:

M = L × [r(1 + r)^n] / [(1 + r)^n - 1]

Where: L is the loan amount, r is the monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments (amortization years × 12).

The formula assumes equal payments over the amortization period and that interest is compounded monthly. It is the standard method used for commercial mortgages and most term loans.

Sources: Bureau of the Fiscal Service, Mortgage Calculator

How to Calculate Total Interest and Amortization

Total interest over the life of a fully amortizing loan is the sum of all monthly payments minus the original loan amount. To calculate it, first find the monthly payment using the formula, then multiply by n and subtract L.

An amortization schedule shows how each payment splits between interest and principal. Early payments are interest-heavy; later payments reduce principal more quickly, assuming a fixed rate and level payment. Over time, the principal balance declines until it reaches zero at the end of the amortization period.

If the loan term is shorter than the amortization period, the amortization schedule still reflects the payment based on the longer period, but the balance at the end of the term becomes a balloon payment.

• Monthly payment = formula output
• Total paid = monthly payment × n
• Total interest = total paid − loan amount
• Balloon payment = remaining principal at end of loan term (if term < amortization)

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Worked Examples: Monthly Payment and Total Cost

The following examples illustrate how to apply the formula. They use realistic rates and terms for illustrative purposes only; actual rates vary by lender and market.

Example 1: $100,000 over 5 years at 6% annual interest. With a 5-year amortization (60 payments), r = 0.06/12 = 0.005, n = 60. The monthly payment is approximately $1,933.28. Total interest over the 5 years is about $15,996.80.

Example 2: $500,000 over 10 years at 7% annual interest. With a 10-year amortization (120 payments), r = 0.07/12 ≈ 0.0058333, n = 120. The monthly payment is roughly $5,805.91. Total interest is about $196,709.20.

Example 3: Interest-only payments. For a $100,000 loan at 6% annual interest, the monthly interest-only payment is $100,000 × (0.06/12) = $500. During the interest-only period, you make no principal payments, so the full balance remains due at maturity.

Sources: Bureau of the Fiscal Service

Interest-Only and Balloon Payment Calculations

Interest-only periods are common on bridge loans, construction loans, and the early years of some permanent commercial loans. During an interest-only period, your monthly payment is simply the loan amount multiplied by the monthly interest rate: Loan Amount × (Annual Rate / 12).

For a balloon loan, you typically make payments based on a longer amortization schedule, but the remaining principal becomes due in full at the end of the loan term. The balloon payment is the outstanding balance at that point, which you can find from the amortization schedule.

Some commercial loans also use a 25- or 30-year amortization with a 5- or 10-year term, creating a significant balloon payment at maturity.

Sources: Bureau of the Fiscal Service, Mortgage Calculator

Inputs Needed for Accurate Estimation

To estimate your payment, you need four pieces of information: the loan amount, the annual interest rate, the amortization period, and the loan term. You may also want to know whether the loan includes an interest-only period or a balloon payment.

Lenders set the loan amount based on the property value and your debt service coverage ratio (DSCR), which compares net operating income to total debt service. Typical DSCR requirements range from 1.20x to 1.35x, and loan-to-value (LTV) ratios are usually 65% to 80%.

Your monthly payment may also include escrow for property taxes and insurance, even though these are not part of the principal and interest calculation.

• Loan amount
• Loan term (years)
• Interest-only period (if any)
• Balloon payment (if term < amortization)

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Interpreting Your Monthly Payment Result

The monthly payment from the formula represents principal and interest only. Your actual cash outlay might be higher if you must pay property taxes, insurance, or lender fees through an escrow account.

The payment amount is sensitive to the interest rate and the amortization period. A higher rate increases the payment; a longer amortization reduces it but increases total interest paid over time.

If your loan has a balloon payment, your regular payments may be lower than a fully amortizing loan with the same rate and term, but you will need to plan for the large final payment.

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

How Interest Rate and Term Affect Payments

Interest rate is a primary driver of your monthly payment. A higher rate means a larger portion of each payment goes to interest, increasing the total cost. Conversely, a lower rate reduces your payment and total interest.

The loan term affects when the balance must be repaid. A shorter term with a balloon payment means you face a large lump sum sooner, even though your regular payments might be lower because the amortization is longer.

Amortization length also matters: extending the amortization from 10 to 20 years reduces the monthly payment but increases total interest.

Sources: Bureau of the Fiscal Service

Common Calculation Mistakes

One frequent error is mixing up the loan term and the amortization period. Ensure you use the amortization period in the formula, not the term, unless the two are identical.

Another mistake is using the annual interest rate without converting it to a monthly rate. Always divide by 12.

Forgetting to account for a balloon payment can mislead your cash flow planning. If your term is shorter than the amortization, you must plan for the remaining balance.

Finally, remember that the formula does not include fees, taxes, or insurance, so your actual payment may be higher.

• To avoid confusion, always double-check that you are using the amortization period, not the loan term.
• To prevent rate errors, convert the annual rate to a monthly rate by dividing by 12 before applying the formula.
• To avoid cash flow surprises, calculate the balloon payment if your term is shorter than the amortization.
• To avoid underestimating your total payment, add escrow amounts for taxes and insurance to the principal and interest figure.

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Using the Commercial Loan Payment Calculator

Although this page explains the calculation method, you can apply the same steps in any spreadsheet. Enter your loan amount, annual interest rate, and amortization period, then use the formula to compute the monthly payment.

For interest-only loans, multiply the loan amount by the monthly rate. For balloon loans, compute the amortizing payment and read the ending balance from your schedule.

Worked examples like those above give you a quick reference, but your actual loan terms may differ. Always confirm current rates and fees with a lender.

Sources: Bureau of the Fiscal Service, Mortgage Calculator

Introduction to Commercial Loan Payment Calculation

Commercial loan payment calculation is a straightforward process once you understand the variables. You need the loan amount, the annual interest rate, and the number of payments, which is typically the amortization period in years multiplied by 12.

The standard formula works for fully amortizing loans. If your loan has an interest-only period or a balloon payment, adjust the calculation accordingly.

Sources: Bureau of the Fiscal Service

The Amortization Formula: Variables and Definitions

The monthly payment formula uses these variables: L is the loan amount, or the total principal borrowed; r is the monthly interest rate, which is the annual interest rate divided by 12; and n is the total number of monthly payments, which is the amortization period in years multiplied by 12.

The formula is: M = L × [r(1 + r)^n] / [(1 + r)^n - 1].

It assumes level payments and monthly compounding, which is standard for most commercial mortgages and term loans.

• L: loan amount (the amount borrowed)
• r: monthly interest rate (annual rate / 12)
• n: total number of monthly payments (amortization years × 12)
• M: monthly payment (principal and interest)

Sources: Bureau of the Fiscal Service, Mortgage Calculator

Step-by-Step Calculation for a Standard Term Loan

To calculate the monthly payment for a standard term loan with no interest-only period:

Step 1: Convert the annual interest rate to a monthly rate by dividing by 12.

Step 2: Determine the total number of payments by multiplying the amortization years by 12.

Step 3: Plug the loan amount, monthly rate, and number of payments into the formula.

Step 4: Compute the result to get the monthly payment.

• Step 1: Monthly rate = Annual rate ÷ 12
• Step 2: n = Amortization years × 12
• Step 3: Use the formula M = L × [r(1 + r)^n] / [(1 + r)^n - 1]
• Step 4: The result is your monthly principal and interest payment

Sources: Bureau of the Fiscal Service

Interest-Only Payment Calculation

For an interest-only loan, the monthly payment is calculated by multiplying the loan amount by the monthly interest rate: Loan Amount × (Annual Rate / 12).

During the interest-only period, no principal is repaid, so the principal balance remains unchanged. At the end of the period, the full amount is due unless the loan converts to amortizing payments.

Interest-only periods are common on bridge loans, construction loans, and the early years of some permanent loans.

Sources: Bureau of the Fiscal Service

Balloon Loan Payment Calculation

A balloon loan uses a longer amortization schedule to set the regular payment, but the loan matures before the principal is fully repaid. The balloon payment is the outstanding balance at maturity.

To calculate the balloon payment, first determine the monthly payment using the amortization period. Then, after the loan term's number of payments, calculate the remaining principal balance from the amortization schedule.

Most commercial mortgages have a term shorter than the amortization period, so a balloon payment is common in commercial real estate.

Sources: Bureau of the Fiscal Service, Mortgage Calculator

Common Errors

The most common errors involve using the wrong period, forgetting to convert the rate, or ignoring balloon payments. Double-check that you are using the amortization period, not the loan term, and that you have divided the annual rate by 12.

Also, remember that the formula yields principal and interest only. If your lender requires escrow for taxes and insurance, your total monthly payment will be higher.

For loans with variable rates, the payment can change, so the formula gives you only an estimate based on the current rate.

• Avoid these errors by carefully labeling your inputs and checking your formula against a known example.
• Use the amortization period, not the loan term, in the formula.
• Convert the annual rate to a monthly rate before calculating.
• Include escrow costs in your total payment estimate.

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Worked Examples with Different Loan Scenarios

The following scenarios illustrate typical commercial loan structures. All figures are illustrative; actual rates and terms vary.

Scenario 1: $500,000 commercial mortgage, 7% annual rate, 25-year amortization, 10-year term. Monthly payment (based on 25-year amortization) = about $3,534.58. After 10 years, the balloon payment would be approximately $407,000.

Scenario 2: $250,000 bridge loan, 10% annual rate, interest-only for 2 years. Monthly interest-only payment = $2,083.33. After the interest-only period, the loan may convert to amortizing or require a balloon.

Sources: Bureau of the Fiscal Service

Formula Limitations: Fees and Variable Rates

The standard amortization formula has limitations: it assumes a fixed interest rate and level payments, and it does not include lender fees, points, origination charges, or escrow for taxes and insurance. These can increase your actual monthly payment.

For variable-rate loans, the payment can change when the rate adjusts, so the formula provides only a current estimate.

Commercial loans may also have covenants or prepayment penalties, which are not reflected in the payment calculation but can affect your total borrowing cost.

• Excludes fees and points
• Excludes taxes and insurance
• Assumes fixed rate
• Variable-rate loans require periodic recalculation

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Understanding the Payment Formula

The payment formula is the core of any amortizing loan calculation. It ensures that each payment covers the monthly interest and reduces the principal by a small amount, so the loan is fully paid off by the end of the amortization period.

The formula is derived from the present value of an annuity. It is widely used and accepted for commercial mortgages and consumer loans alike.

Sources: Bureau of the Fiscal Service

Gathering Inputs: Loan Amount, Rate, Term

Before calculating, gather the key loan terms: the total loan amount, the annual interest rate, and the amortization period. You also need the loan term if it differs from the amortization.

Lenders typically require a loan-to-value ratio of 65% to 80% and a debt service coverage ratio of 1.20x to 1.35x, which influence how much you can borrow.

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Common Mistakes to Avoid

Avoid confusing the loan term with the amortization period, which is a frequent error. Always use the amortization period for the payment formula.

Ensure you convert the annual rate to a monthly rate. Forgetting to divide by 12 will significantly overstate your payment.

If your loan has a balloon, do not assume the regular payment amount represents the total cost. Plan for the large final payment.

Also, remember that property taxes, insurance, and fees are not included in the basic formula.

• Use the correct period (amortization, not term)
• Convert annual rate to monthly
• Account for balloon payments
• Include escrow and fees in your total payment estimate

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

How to Calculate a Commercial Loan Payment

To calculate a commercial loan payment, follow these steps:

Step 1: Determine the loan amount, annual interest rate, and amortization period.

Step 2: Convert the annual rate to a monthly rate by dividing by 12.

Step 3: Multiply the amortization years by 12 to get the number of payments.

Step 4: Apply the formula to find the monthly payment.

For interest-only loans, multiply the loan amount by the monthly rate. For balloon loans, use the formula and then calculate the remaining balance at the end of the term.

Sources: Bureau of the Fiscal Service

Example 1: $100,000 Over 5 Years at 6%

Annual rate: 6% (0.06)

Amortization period: 5 years (60 months)

Monthly rate r = 0.06 / 12 = 0.005

n = 60

Sources: Bureau of the Fiscal Service

Example 2: $500,000 Over 10 Years at 7%

Annual rate: 7% (0.07)

Amortization period: 10 years (120 months)

Monthly rate r = 0.07 / 12 ≈ 0.00583333

n = 120

Sources: Bureau of the Fiscal Service

Example 3: Interest-Only Payments

Annual rate: 6%

Sources: Bureau of the Fiscal Service

What Affects Your Payment?

Your monthly payment changes with the loan amount, interest rate, and amortization period. A higher loan amount or rate increases the payment; a longer amortization reduces it but increases total interest.

The loan term matters if it is shorter than the amortization, because you will owe a balloon payment at maturity.

Property taxes and insurance can also be included in your monthly payment, but they are not part of the principal and interest calculation.

• Interest rate
• Amortization period
• Loan term (balloon vs. fully amortizing)
• Escrow items (taxes and insurance)

Sources: Bureau of the Fiscal Service, Consumer Financial Protection Bureau

Using Examples to Plan Your Loan

Worked examples give you a realistic sense of payment levels for different loan sizes and terms. Use them as a starting point, then adjust for your actual rate and amortization.

Remember that the examples are illustrative; actual rates vary by lender, property type, and market conditions. Always confirm current pricing with a lender.

You can use the same formula in a spreadsheet to test different scenarios before approaching a lender.

Sources: Bureau of the Fiscal Service