Free loan amortization template

A loan amortization schedule shows you exactly where every dollar of your loan payment goes. It breaks down each payment into principal and interest, so you can see how your debt shrinks over time and how much borrowing actually costs you.

For finance teams, this clarity matters. Whether you're managing a business term loan, equipment financing, or an SBA loan, an accurate schedule helps you forecast cash flow, document compliance, and decide when extra payments make sense. Our free template handles the calculations for you—just plug in your loan details and get an instant breakdown.

What is a loan amortization schedule?

A loan amortization schedule is a table that breaks down each loan payment into principal and interest over the life of the loan. It shows you how much of every payment reduces your debt versus how much covers the cost of borrowing.

Each row in the schedule represents one payment period and includes three core components:

• Principal: The portion that reduces your outstanding loan balance
• Interest: The cost charged by the lender for borrowing
• Remaining balance: What you still owe after each payment

This structure gives you a complete view of your loan's repayment trajectory from day one through final payoff.

How loan amortization works

Amortization spreads your loan repayment across fixed, predictable payments. Even though the total payment amount stays the same, the split between principal and interest shifts with every period.

Principal vs. interest payments

Every fixed payment you make contains two parts: principal, which reduces your loan balance, and interest, which is what the lender charges you for the loan. Early in the loan, most of your payment goes toward interest because the outstanding balance is at its highest.

As the principal shrinks, the interest charge on each subsequent payment shrinks too. That means more of each payment starts going toward principal, accelerating the payoff as you near the end of the loan term.

How payment allocation changes over time

The shift from interest-heavy to principal-heavy payments is gradual but significant. Here's how it typically plays out across three stages:

This pattern is why making extra payments early in the loan has a much bigger impact on total interest than making them later.

Here's an illustrative example you can reproduce in the template, not a cited benchmark. On a $250,000 fixed-rate loan at 6.5% over 30 years, the monthly payment is about $1,580. Your first payment sends roughly $1,354 to interest and only about $226 to principal, and principal doesn't overtake interest until around payment 233.

The loan amortization formula

The standard formula for calculating a fixed monthly payment is:

M = P[r(1+r)^n] / [(1+r)^n − 1]

Each variable represents:

• M: Monthly payment amount
• P: Principal (original loan amount)
• r: Monthly interest rate (annual rate divided by 12)
• n: Total number of payments

You don't need to run this math by hand. Our template does the calculation automatically once you enter your loan details.

Free loan amortization schedule template for Excel and Google Sheets

Building an amortization schedule from scratch takes time and invites formula errors. Our free template gives you a pre-built, ready-to-use schedule that works in both Excel and Google Sheets.

What the template includes

The template covers everything you need to track a loan from start to finish:

• Payment number and date
• Beginning and ending balance for each period
• Principal and interest breakdown per payment
• Cumulative interest paid over the life of the loan
• Optional extra payment column for modeling early payoff scenarios

How to download and customize the template

Download the file, open it in Excel or Google Sheets, and enter your loan details in the designated input cells at the top of the sheet. The template auto-calculates your payment schedule the moment you enter your loan amount, interest rate, and term: no formulas to write or cells to format.

How to use a loan amortization schedule template

Once you've downloaded the template, building a complete schedule takes about a minute. Here's how to walk through it:

1. Enter your loan amount and interest rate

Input the total amount you're borrowing in the principal field and the annual interest rate as a percentage. These fields are typically labeled at the top of the template, where all your loan inputs live in one place.

2. Set the loan term and payment frequency

Enter the loan duration, either in months or years depending on the template field, and select your payment frequency. Most business loans are monthly, but the template supports bi-weekly or other schedules. Loan term simply means the total length of time you have to repay the loan.

3. Review your monthly payment breakdown

Once your inputs are in, the schedule populates automatically. Look for your fixed payment amount, the per-period split between interest and principal, and the remaining balance column to see how the loan winds down with each payment.

4. Model extra payment scenarios

Use the extra payment column to test what happens if you pay more than the minimum. Even small additions to each payment can shorten your loan term significantly and cut total interest paid. The template recalculates the payoff date and interest savings instantly.

5. Build your own schedule in Excel or Google Sheets with formulas

Three functions do all the work if you'd rather build a loan amortization schedule in Excel yourself: PMT, IPMT, and PPMT. They behave identically in Google Sheets, so the same amortization formula Excel uses will calculate correctly in either tool:

Put your rate, term, and loan amount in input cells at the top, then reference them in each formula. Number your payment periods down column A, point the IPMT and PPMT formulas at that column, and drag both rows down to the final period.

That gives you a full amortization schedule Excel or Sheets recalculates the moment you change an input. Building it yourself is worth the 10 minutes if you want to customize the math or trace it for an auditor. Our free template is the faster route when you just need the numbers.

Types of loans that use amortization schedules

Amortization schedules apply to any loan with fixed periodic payments. For finance teams, that covers most of the debt instruments you'll encounter on the balance sheet:

Business term loans

Business term loans deliver a lump sum upfront with fixed repayment over a set period, making them straightforward to amortize for general operating or growth needs. If you're evaluating financing options, understanding business banking fundamentals can help you compare structures before you commit.

Equipment financing loans

Equipment financing terms typically align with the useful life of the asset being financed, so the loan is paid off around the time the asset needs replacement or major maintenance.

Commercial real estate mortgages

Commercial mortgages run on longer terms, and an amortization schedule helps you plan for decades of large, recurring payments while tracking equity buildup in the property.

SBA loans

SBA loans are government-backed and follow structured, fully amortized repayment schedules that often span longer terms than conventional business financing.

Loans that do not amortize the way you expect

A static amortization schedule assumes a fixed-rate, fully amortizing loan, and not every loan follows that pattern. For these structures, a standard template won't reflect the true cost of the debt:

• Interest-only loans: Payments cover only interest for an initial period. The balance doesn't move until full principal and interest payments begin.
• Balloon loans: The payment is calculated on a longer amortization schedule than the actual term. That leaves a large lump sum due at the end.
• Negative amortization: The payment is smaller than the interest due, so the shortfall gets added to the balance. Your debt grows instead of shrinking.
• Adjustable-rate loans: The schedule re-cuts at every rate reset. Any schedule you build is only valid until the next adjustment.
• Revolving credit, including cards and HELOCs: There's no fixed end date. The minimum payment floats with the outstanding balance.

How extra payments reduce total interest paid

Extra payments go directly toward your principal, which lowers the balance that accrues interest. A smaller balance means less interest charged on every future payment, so even modest extra payments can shorten the loan term and save thousands over the life of the loan.

There are three common ways to apply extra payments:

• Lump-sum payments: One-time extra payments funded by a tax refund, bonus, or surplus cash. These work well when your cash flow has an unexpected positive spike.
• Recurring extra payments: Adding a fixed amount to each scheduled payment. Even $50–$100 extra per month can meaningfully reduce total interest over a multi-year loan.
• Bi-weekly payments: Paying half your monthly amount every 2 weeks, which results in one extra full payment per year. This approach is simple to automate and adds up significantly over longer loan terms.

The math gets tangible fast. On that same illustrative $250,000 loan at 6.5% over 30 years, paying an extra $100 per month clears the balance roughly 4 years and 8 months early and saves about $58,860 in interest. Doubling that to $200 per month saves roughly $97,618.

Treat these figures as illustrative and recompute them in the template with your own loan terms. Before you commit, check the loan agreement for prepayment penalties, and tell your servicer to apply extra funds to principal rather than holding them as a prepaid future installment. Accurate records of every extra payment also matter at year-end—knowing how long to keep business tax records ensures you have the documentation if questions arise later.

Benefits of tracking your loan amortization schedule

For finance teams, an amortization schedule is more than a payment tracker. It's a planning tool that supports forecasting, compliance, and strategic decisions about your debt.

Cash flow forecasting and budgeting

Knowing your exact payment amounts, and how interest expense changes each period, lets you plan monthly and annual budgets with precision. You can anticipate when interest expenses peak and align debt service with other cash outflows. Once you know the payment dates, Ramp Business Banking's Cash Manager sweeps excess operating cash into an interest-earning account⁴ and pulls it back as bills come due.

Audit and compliance documentation

An amortization schedule provides clean, defensible records for auditors, lenders, and investors. If you have reporting requirements or covenants tied to debt, the schedule is essential supporting documentation for any review. Finance teams that rely on AI accounting software can automate much of this record-keeping, reducing the manual effort required to stay audit-ready.

Strategic debt payoff planning

Use the schedule to evaluate whether to pay off loans early, refinance at a better rate, or redirect cash toward higher-return uses. Seeing the interest savings from extra payments side-by-side with other capital decisions helps you allocate funds where they matter most. Understanding your tax provision obligations alongside your debt schedule can also sharpen how you model the after-tax cost of carrying a loan.

Close your books faster with Ramp's AI coding, syncing, and reconciling alongside you

Month-end close is a stressful exercise for many companies, but it doesn't have to be that way. Ramp's AI-powered accounting tools handle everything from transaction coding to ERP sync, so teams close faster every month with fewer errors, less manual work, and full visibility.

Every transaction is coded in real time, reviewed automatically, and matched with receipts and approvals behind the scenes. Ramp flags what needs human attention and syncs routine, in-policy spend so teams can move fast and stay focused all month long. When it's time to wrap, Ramp posts accruals, amortizes transactions, and reconciles with your accounting system so tie-out is smoother and books are audit-ready in record time.

Here's what accounting looks like on Ramp:

• AI codes in real time: Ramp learns your accounting patterns and applies your feedback to code transactions across all required fields as they post
• Auto-sync routine spend: Ramp identifies in-policy transactions and syncs them to your ERP automatically, so review queues stay manageable, targeted, and focused
• Review with context: Ramp reviews all spend in the background and suggests an action for each transaction, so you know what's ready for sync and what needs a closer look
• Automate accruals: Post (and reverse) accruals automatically when context is missing so all expenses land in the right period
• Tie out with confidence: Use Ramp's reconciliation workspace to spot variances, surface missing entries, and ensure everything matches to the cent

Try an interactive demo to see how businesses close their books 3x faster with Ramp.