Business Loan Amortization Schedule Calculator

What Is a Loan Amortization Schedule?

A loan amortization schedule is a complete, period-by-period breakdown of every payment you will make over the life of a loan. Each row in the table tells you the payment date, the total payment amount, how much of that payment reduces your outstanding balance (principal), how much goes to the lender as interest, and what your remaining balance will be after the payment is made.

For most business loans — including SBA 7(a) loans — payments are structured as equal monthly installments. This is called a fully amortizing loan. Because your balance is highest at the beginning, interest charges are front-loaded: your first payment is mostly interest, and your last payment is almost entirely principal. This is not a trick — it is simply math. The interest charge each month is your current balance multiplied by the monthly interest rate (annual rate ÷ 12).

How SBA 7(a) Loans Amortize Differently From Conventional Loans

SBA 7(a) loans use the same standard amortization math as conventional business loans, but there are several important structural differences that affect your schedule:

• Variable interest rates: Most SBA 7(a) loans carry a variable rate tied to the WSJ Prime Rate plus a lender spread. This calculator assumes a fixed rate for simplicity; in practice, your payment will change whenever the Prime Rate changes. Check current SBA rates to use today's rate.
• Strict term limits: SBA limits acquisition loans (working capital and goodwill) to 10 years. Real estate loans can go to 25 years. The term you choose dramatically affects both your monthly payment and total interest — use the term dropdown to compare scenarios.
• Prepayment penalties: SBA 7(a) loans with terms of 15 years or longer carry a prepayment penalty: 5% in year 1, 3% in year 2, and 1% in year 3 of the loan. Loans under 15 years have no prepayment penalty. The balance shown in this schedule is your payoff amount at any point (excluding any applicable prepayment penalty).
• SBA guarantee fee rolled in: Many borrowers finance the SBA upfront guarantee fee into the loan, which increases the principal balance — and thus total interest paid over the life of the loan. Use the main SBA loan calculator to model this precisely.

Why You Need an Amortization Schedule Before Closing

Reviewing your amortization schedule before closing on a business loan is not optional — it is essential. Here is what experienced borrowers and advisors look for:

• Cash flow planning: Your amortization schedule gives you exact monthly payment figures for every month of the loan. Plug these into your cash flow model to confirm the business can sustain debt service throughout the loan term, not just at initial underwriting conditions.
• Breakeven analysis: By comparing your monthly payment to your projected net operating income, you can identify the minimum revenue needed each month to stay current on the loan. SBA lenders require a minimum 1.25x DSCR — your schedule makes this easy to verify.
• Interest cost awareness: On a $700,000 SBA loan at 10.25% over 10 years, total interest paid exceeds $400,000. Knowing this figure upfront helps you negotiate aggressively on purchase price or down payment to reduce the principal balance before amortization begins.
• Early payoff strategy: The schedule shows your exact balance at any payment date, so you can plan lump-sum payments during periods of high business revenue to reduce principal — especially valuable in years 4 and beyond when prepayment penalties no longer apply.

How to Read the Amortization Table Above

Each column in the table serves a specific purpose. Payment # and Date identify when each payment is due, starting one month after your selected start date. Payment is the fixed monthly amount you owe. Principal is the amount reducing your loan balance. Interest is the lender's compensation for the month. Balance is what you still owe after that payment is applied.

The Annual Summary view aggregates all 12 monthly payments per year into a single row, giving a high-level picture of how your total interest exposure shrinks year over year. Use this view for multi-year cash flow projections or when presenting to investors or partners.

The Download CSV button exports the complete schedule as a comma-separated values file. Open it in Microsoft Excel, Google Sheets, or Apple Numbers to build custom analyses — DSCR tracking, tax interest deduction estimates, or principal balance milestones for refinancing decisions.

Frequently Asked Questions

What is a loan amortization schedule?

A loan amortization schedule is a complete table of all scheduled payments on a loan from the first payment to the last. Each row shows the payment number, date, total payment, principal paid, interest paid, and the remaining loan balance. The schedule reveals the true cost of borrowing by making visible exactly how much total interest you pay over the full term — something that is not apparent from the monthly payment alone.

How is an SBA 7(a) loan amortized differently from a conventional business loan?

Structurally, SBA 7(a) loans use the same standard amortization formula as conventional loans — equal monthly payments with interest computed on the declining balance. The key differences are: SBA rates are typically variable (tied to Prime), not fixed; term limits are set by the SBA (10 years for goodwill/working capital, 25 years for real estate); and the SBA guarantee fee may be rolled into the loan balance, increasing the principal that is amortized. Conventional commercial loans often have balloon payments or are amortized over a longer period than their stated term, which SBA 7(a) loans do not permit.

Can I pay off my SBA loan early using the amortization schedule?

Yes. Your remaining balance at any payment is your exact payoff amount at that date (before any prepayment penalty). SBA 7(a) loans with terms of 15 years or more carry a prepayment penalty of 5% in year 1, 3% in year 2, and 1% in year 3. For loans under 15 years — which covers most business acquisition loans on the standard 10-year term — there is no prepayment penalty at any time. Making extra principal payments in the first few years can save tens of thousands of dollars in interest.

How do I download or print my amortization schedule?

Click Download CSV after generating your schedule to save the full table as a CSV file. This file opens in Excel, Google Sheets, or any spreadsheet application. Click Print Schedule to open your browser's print dialog with a pre-optimized layout — navigation bars, ads, and sidebar content are hidden automatically so your printout contains only the loan parameters and payment table. For best results, select landscape orientation in your print dialog if the table is wide.