Loan Calculator with Amortization Schedule (Business & Personal)

Before you sign for an equipment loan, an SBA loan, a car or a line of credit, you want three numbers: the payment, the total interest and how fast the balance goes down. This free loan calculator shows all three, plus a full payment-by-payment amortization schedule and how much you save by paying a little extra.

Loan payment calculator

Enter the amount you’re borrowing, the APR and the term. Choose monthly, biweekly, weekly or quarterly payments, and add an optional extra payment to see how much sooner you’d be done.

When you’re done, use the buttons under the result to print or save it as a PDF, download it for Excel, Word or CSV, copy a share link or email it. Your numbers stay in your browser.

The loan payment formula

r = APR / 100 / payments per year
n = years x payments per year
Payment = Loan x r / (1 - (1 + r)^-n)
Interest this period  = Balance x r
Principal this period = Payment - Interest

Each payment covers that period’s interest first, and the rest reduces the balance. Early on most of the payment is interest; by the end almost all of it is principal. That’s why extra payments made early save the most.

Worked example

A small business borrows $50,000 for equipment at 8.5% APR over 5 years, paid monthly.

  • Monthly rate: 8.5% / 12 = 0.7083%; number of payments: 60
  • Monthly payment: $1,025.83
  • Total paid: $61,549.59, of which $11,549.59 is interest
  • Adding $200 a month extra pays it off in 49 payments instead of 60 and saves $2,332.16 in interest
YearPaidPrincipalInterestBalance at year end
1$12,309.92$8,381.45$3,928.47$41,618.55
2$12,309.92$9,122.30$3,187.62$32,496.25
3$12,309.92$9,928.63$2,381.29$22,567.62
4$12,309.92$10,806.23$1,503.69$11,761.40
5$12,309.92$11,761.40$548.52$0.00

How to record a loan in your books

Only the interest part of each payment is a business expense. The principal part reduces the loan balance (a liability) and is not deductible. Use the schedule above to split each payment: record interest to an “Interest expense” account and principal against “Loan payable”. If you keep books in a spreadsheet, our bookkeeping in Excel guide shows how to set up those accounts.

Common mistakes when taking a loan

  • Comparing interest rates instead of APR. The APR includes most upfront fees, so it is the better number for comparing two offers.
  • Ignoring prepayment penalties. Some business loans charge a fee if you pay early, which cancels out the savings from extra payments. Check the agreement before you plan to pay ahead.
  • Expensing the whole payment. Only the interest part of each payment is a business expense. The principal part reduces the loan balance on your balance sheet.
  • Missing a balloon payment. Some loans have small payments followed by a large final payment. Make sure the schedule you’re quoted pays the loan to zero, or plan cash for the balloon.

Rate news: interest rates feed straight into loan payments and savings growth. See what the Fed’s October 2026 rate decision means for small businesses.

FAQ

What is an amortization schedule?

It is a table that shows every payment over the life of the loan, split into interest and principal, with the balance left after each one.

Is APR the same as the interest rate?

Not always. APR includes some fees, so it is usually a little higher than the note rate. For a quick estimate either works; for the exact schedule use the rate on your loan agreement.

Does biweekly payment save interest?

Paying every two weeks means 26 half-payments, or 13 full monthly payments a year, so the loan is paid off sooner and you pay less interest. Check with your lender that extra payments go to principal.

Is loan interest tax deductible for a business?

Interest on money borrowed for business use is generally deductible as a business expense; the principal is not. Rules differ for personal loans and mortgages, so check with a tax professional.

Sources

This calculator is for general information and planning. It isn’t tax, legal, accounting or financial advice. For your own situation, talk to a qualified professional.

Comments

4 responses to “Loan Calculator with Amortization Schedule (Business & Personal)”

  1. […] Loan Calculator With Amortization Schedule […]

  2. […] Loan Calculator with Amortization Schedule […]

  3. […] At prime + 2% (9.00%), a fully drawn $50,000 line costs about $375 a month in interest. A future 0.25-point cut would save about $10 a month; a 0.25-point hike would cost about $10 more. Run your own loan with our loan calculator with amortization schedule. […]