What Is Amortization in Commercial Lending?
Amortization is the process of spreading a loan's repayments over time so that each payment covers both interest and a portion of the principal. For commercial loans, amortization determines how much of each payment goes toward reducing the balance you owe versus covering the lender's cost of funds.
Each payment is calculated based on the current outstanding balance. Early in the loan, a larger portion of each payment goes toward interest, and a smaller portion goes toward principal. As the balance decreases, the interest portion of each payment becomes smaller and the principal portion grows.
Understanding amortization is important for your business because it affects cash flow, the total interest you pay, and your ability to plan for future payments or a final balloon payment if the loan's term is shorter than its amortization period.
Sources: Consumer Financial Protection Bureau, Investopedia, Commercial Loan Direct, Janover Pro
Why Amortization Matters for Your Business
Amortization matters because it directly influences your monthly payment amount and the total interest cost over the life of the loan. A longer amortization period reduces your monthly payment but increases total interest paid over time. A shorter amortization period increases the monthly payment but reduces total interest.
For commercial real estate loans, the amortization period is often longer than the loan term. This is a common structure that allows borrowers to have lower monthly payments during the initial term, with the remaining balance due as a balloon payment at maturity.
Sources: Commercial Loan Direct, Janover Pro
The Amortization Formula for Commercial Loans
The standard formula for calculating the fixed monthly payment on an amortizing loan is:
M = P × [r(1+r)^n] / [(1+r)^n – 1]
Where P is the principal loan amount, r is the monthly interest rate (annual rate divided by 12), and n is the number of monthly payments. This formula gives the same payment amount each month for a fully amortizing loan.
To build an amortization schedule, for each payment period you calculate the interest on the current balance, then determine the principal portion of the payment, and then reduce the balance by that principal amount.
- Interest for the period = current balance × monthly interest rate
- Principal payment = fixed monthly payment – interest for the period
- New balance = previous balance – principal payment
- Repeat for each payment period until the balance reaches zero
Sources: Investopedia, Janover Pro
How to Build an Amortization Schedule
You can build an amortization schedule using a spreadsheet or by hand. The key is to start with the loan amount, the annual interest rate, and the number of payments. Here’s the general process:
First, convert the annual interest rate to a monthly rate by dividing by 12. Next, use the payment formula to determine the fixed monthly payment. Then, for each payment, calculate the interest on the current balance, subtract that from the payment to get the principal portion, and update the balance accordingly.
Continue this until the balance reaches zero. The schedule will show each payment’s breakdown and the remaining balance after each payment.
- List the payment number, payment amount, interest portion, principal portion, and remaining balance for each period.
- Verify that the final payment brings the balance to exactly zero (or adjust for rounding).
- You can replicate this in Excel or Google Sheets using formulas for each column.
Sources: Investopedia
Creating a Schedule in Excel
You can create a complete amortization schedule in a spreadsheet program with a few formulas. The steps below describe the standard method for setting up the rows and columns.
Start by entering your assumptions in separate cells: the loan amount (P), the annual interest rate, and the number of payments (n). Then label the columns: Payment Number, Payment, Interest, Principal, Balance.
In the first row for the first payment, enter the fixed payment amount using the formula for M. Then calculate the interest for that period as the current balance times the monthly rate. The principal is the payment minus the interest. The new balance is the previous balance minus the principal.
For each subsequent row, copy the formulas down, making sure the balance reference moves to the previous row's ending balance. Continue copying the rows until the balance reaches zero. The last payment may need to be adjusted for rounding so that the balance ends at exactly zero.
Sources: Investopedia
Reading an Amortization Schedule: Principal vs. Interest
An amortization schedule is a table that shows each payment’s breakdown between principal and interest, and the remaining balance after each payment. The first column typically shows the payment number, then the payment amount, the interest portion, the principal portion, and the ending balance.
In the early payments, the interest portion is high and the principal portion is low. Over time, as the balance decreases, the interest portion shrinks and the principal portion grows. This is because interest is calculated on the current outstanding balance.
- Interest portion = current balance × monthly interest rate
- Principal portion = payment – interest portion
- Ending balance = previous balance – principal portion
Amortization vs. Term: What's the Difference?
The loan term is the length of time before the loan matures, while the amortization period is the schedule over which payments are calculated. For commercial loans, these two are often different.
Commercial mortgage terms are typically shorter than the amortization period, often 3 to 10 years for the term while amortization is 20 to 30 years. When the term is shorter than the amortization period, the remaining balance is due as a balloon payment at maturity.
Understanding this difference is critical for planning since a balloon payment can be a large cash outlay.
Sources: Commercial Loan Direct, Janover Pro
Types of Amortization: Full, Interest-Only, Balloon
Commercial loans can have different amortization structures. A fully amortizing loan pays off the entire principal by the end of the amortization period. An interest-only loan has a period during which payments cover only interest, and the principal balance does not decrease. A balloon loan has a term shorter than the amortization period, so a large final payment is required.
Interest-only periods are common on bridge loans and some CMBS loans, and are also available on certain construction or low-leverage loans. These structures can help borrowers with cash flow early on but often come with a lump-sum payment later.
- Full amortization: payments cover both interest and principal, loan is fully repaid by end of the schedule.
- Interest-only: during the interest-only period, payments cover only interest; the principal balance stays the same.
- Balloon: the loan term is shorter than the amortization period; a balloon payment at maturity covers the remaining balance.
Sources: Commercial Loan Direct, Janover Pro
How Amortization Differs from Residential Mortgages
Residential mortgages typically have a term equal to the amortization period, such as a 30-year fixed mortgage that is fully amortized over 30 years. Commercial loans, however, often have a shorter term than the amortization period.
Because commercial loans frequently have balloon payments, the monthly payment is based on a longer amortization schedule than the actual term. This means lower monthly payments but a large payment due when the loan matures.
Understanding this distinction helps you evaluate commercial loan offers and prepare for potential future financing needs.
Sources: Commercial Loan Direct, Janover Pro
Choosing the Right Amortization Schedule
The right amortization schedule depends on your business’s cash flow and long-term plans. A longer amortization period reduces monthly payments but increases total interest. A shorter period does the opposite. Interest-only periods can provide temporary cash flow relief but may increase the final payment.
Consider your expected revenue stability, how long you plan to hold the property or asset, and whether you anticipate refinancing before the term ends. A commercial lender can help you model different scenarios.
Sources: Commercial Loan Direct, Janover Pro
How to Read Your Amortization Table
Your amortization table typically lists payment number, payment amount, interest paid, principal paid, and remaining balance. Each row shows how a single payment is split.
Early rows will show a high interest portion and a low principal portion. As you move down the table, the interest portion decreases and the principal portion increases. The final row shows the last payment that brings the balance to zero.
Sources: Investopedia
Extra Payments on the Schedule
Making extra principal payments can reduce the total interest you pay and shorten the time needed to pay off the loan. Because interest is calculated on the current balance, paying down principal faster means less interest accrues in future periods.
For example, on a $300,000 loan at 5% annual interest with a 30-year term, adding an extra $50 to each monthly payment shortens the loan term by 23 months and saves $21,662.67 in interest.
Before making extra payments on a commercial loan, check with your lender about any prepayment penalties or restrictions.
- Extra payments directly reduce the principal balance, which reduces future interest charges.
- A small extra amount per month can shorten the loan term and save significant interest over time.
Sources: U.S. Bank
Interest-Only and Balloon Amortization
Interest-only loans have a period during which payments cover only interest, so the principal balance is not reduced. This can be beneficial for cash flow but means you will owe the full principal at the end of the interest-only period or at maturity.
Balloon loans occur when the loan term is shorter than the amortization period. The monthly payments are based on the longer amortization, but at the end of the term, the entire remaining balance is due as a balloon payment.
These structures are common in commercial real estate, especially for bridge loans, CMBS loans, and some construction or low-leverage loans.
Sources: Commercial Loan Direct, Janover Pro
Uses of Amortization Schedules for Tax and Accounting
An amortization schedule can help you track the interest portion of each payment, which may be relevant for tax and accounting purposes. However, the deductibility of interest depends on the specific loan purpose, applicable tax laws, and your business situation.
Because tax treatment varies, it is advisable to consult a qualified tax professional for guidance on your specific circumstances. The schedule provides a clear record of interest paid that can be useful during tax preparation.
Sample Schedule for a $500,000 Commercial Loan
The following table shows the first three payments and the final payment (which would be a balloon if the term is shorter than the amortization period).
The schedule below shows how each payment is split.
| Payment Number | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | $3,582.16 | $2,500.00 | $1,082.16 | $498,917.84 |
| 2 | $3,582.16 | $2,494.59 | $1,087.57 | $497,830.27 |
| 3 | $3,582.16 | $2,489.15 | $1,093.01 | $496,737.26 |
| 240 (Balloon) | $3,582.16 | $17.85 | $3,564.31 | $0.00 |
Sources: Investopedia, Janover Pro
Prepayment and Amortization: What Happens?
If you make additional principal payments, the amortization schedule changes because the interest is calculated on a lower balance. This accelerates the payoff and reduces total interest. The exact effect depends on the amount and timing of the extra payments.
For example, on a $300,000 loan at 5% interest over 30 years, an extra $50 per month shortens the term by 23 months and saves $21,662.67 in interest.
Always review your loan agreement for prepayment penalties or restrictions before making extra payments.
Sources: U.S. Bank
Frequently asked questions
What is the difference between amortization and loan term?
Amortization is the schedule over which payments are calculated to pay off the loan, while the loan term is the length of time before the loan matures. For commercial loans, the term is often shorter than the amortization period, leading to a balloon payment at maturity.
Sources: Commercial Loan Direct, Janover ProHow can I create an amortization schedule for a commercial loan?
You can create an amortization schedule by using the standard formula to calculate the fixed monthly payment, then, for each payment period, calculate interest on the current balance, subtract that from the payment to get the principal portion, and update the balance. This can be done in a spreadsheet or by hand.
Sources: InvestopediaWhy does the interest portion decrease over time?
The interest portion decreases because interest is calculated on the outstanding principal balance. As you make payments, the principal balance decreases, so the interest charged on that smaller balance becomes less each period.
Sources: Consumer Financial Protection Bureau, InvestopediaWhat happens if I make additional principal payments?
Additional principal payments reduce the outstanding balance faster, which decreases the interest you pay over time and can shorten the loan term.
Sources: U.S. BankWhat is the difference between a payment schedule and an amortization schedule?
A payment schedule typically just lists the payment amounts and due dates, while an amortization schedule also shows the breakdown between principal and interest and the remaining balance after each payment.
Sources: Investopedia, Commercial Loan DirectWhy is the interest portion higher in the early years?
Because the outstanding principal balance is highest at the start of the loan. Since interest is calculated on that balance, the interest portion of each early payment is larger. As the balance decreases, the interest portion shrinks.
Sources: Consumer Financial Protection BureauCan I get an amortization schedule from my lender?
Many commercial lenders provide amortization schedules as part of the loan documents. You can request one from your lender, or you can create your own using the standard formula and steps described in this guide.
Sources: Commercial Loan Direct, InvestopediaHow does a balloon payment appear on the schedule?
If the loan term is shorter than the amortization period, the final payment on the schedule is the balloon payment, which is the entire remaining principal balance due at maturity. This appears as a large final payment that pays off the loan completely.
Sources: Commercial Loan Direct, Janover ProSources
- What is amortization and how could it affect my auto loan? — Consumer Financial Protection Bureau
- Commercial Loan Calculator & Amortization Schedule — Commercial Loan Direct
- What Is Amortization in Commercial Real Estate? — Janover Pro
- Amortization Schedule: Definition, Formula, and Calculation — Investopedia
- What is amortization, and why does it matter? — U.S. Bank