Business Loan Schedule Calculator

Enter loan details

Loan Amount

Annual Interest Rate (%)

Loan Term Value

Term Unit

Payments Per Year

First Schedule Date

Payment Structure

Interest-Only Periods

Balloon Amount

Extra Principal Per Payment

Origination Fee

Insurance Per Payment

Tax Or Service Charge Per Payment

Rounding Mode

Responsive fields use three columns on large screens, two on tablets, and one on mobile screens.

Example data table

Use this sample to test the calculator quickly.

Loan Amount	Rate	Term	Payments/Year	Type	Balloon	Extra Principal	Origination Fee
250,000.00	11.50%	60 Months	12	Amortized	15,000.00	200.00	2,500.00
500,000.00	9.25%	7 Years	12	Interest Only	100,000.00	0.00	6,000.00
120,000.00	8.90%	36 Months	26	Amortized	0.00	50.00	1,200.00

Formula used

Periodic interest rate: r = annual rate / payments per year

Standard amortized payment: Payment = P × r / (1 - (1 + r)^-n)

Balloon-adjusted payment: the future balloon is discounted to present value first, then the payment is calculated on the reduced financed balance.

Interest each period: Interest = Opening Balance × r

Principal each period: Principal = Payment - Interest + Extra Payment

Closing balance: Closing Balance = Opening Balance - Principal

APR estimate: it is approximated using the internal rate of return of the loan cash flows after deducting origination fees from proceeds.

How to use this calculator

Enter the business loan amount and annual interest rate.
Choose the term value, term unit, and payment frequency.
Select amortized or interest-only structure.
Add balloon payment, extra principal, and fee inputs if needed.
Click Calculate Schedule to view results above the form.
Review the chart, summary cards, and detailed amortization table.
Use the CSV button for spreadsheets and the PDF button for printable reports.

FAQs

1. What does this calculator show?

This calculator builds a payment schedule with dates, payment amounts, principal, interest, fees, taxes, and remaining balance for a business loan.

2. Can it handle balloon loans?

Yes. Enter a balloon amount to leave part of the balance unpaid until the final scheduled payment. The tool adjusts interim payments accordingly.

3. What is the difference between amortized and interest-only?

Amortized loans reduce principal throughout the term. Interest-only loans mainly pay interest first, with principal paid later or at maturity.

4. How does extra payment affect the schedule?

Extra principal lowers the balance faster, reduces future interest, and may shorten the effective payoff timeline if the balance reaches zero early.

5. Is the APR exact?

The APR is an estimate based on cash-flow math using origination fee deductions and scheduled payments. Lender disclosures may still differ slightly.

6. Can I export the amortization table?

Yes. Use the CSV download for spreadsheet analysis or the PDF download for a clean printable report of the chart and schedule.

7. Why include insurance and taxes per payment?

Some lenders bundle insurance, servicing charges, or tax-like fees into each installment. Adding them gives a more realistic cash requirement.

8. Can this support weekly or biweekly payments?

Yes. Choose the desired payment frequency. The schedule will adjust the periodic rate, dates, and amortization timing to match.