Handled by Morning Book a free look

Business loan calculator

Enter the amount, rate and term of a business loan, SBA or bank, to see the monthly payment, the total interest and a payoff table. Below that: what extra payments save, and your debt service coverage ratio, which shows whether your income covers the payments. It is plain arithmetic, and nothing you type leaves this page.

The loan

The numbers already in the boxes are an example. Type over them.

Payoff table, year by year

For the loan above, without extra payments. The download has every month.

Pay a little extra each month

Check with your lender that extra payments go to the amount you owe and whether early payoff carries a charge.

Can your income carry it?

Income available to pay debt is your yearly profit before you take out interest, tax, and the yearly write-down of equipment and other assets. It uses the loan from the first box.

Want to know your coverage before the lender asks?

I connect your books read-only and send one page each morning with your profit, cash and debt payments, checked against your own totals. A free 30-minute look shows what your systems could answer today.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

The payment formula

monthly payment = amount × r ÷ (1 − (1 + r)−n)

Here r is the yearly rate divided by 12 and n is the number of monthly payments. At 9% for 10 years, r is 0.0075 and n is 120, so $250,000 costs $3,166.89 a month. At a 0% rate the payment is simply the amount divided by the number of payments.

Each payment first covers the interest on what you still owe, and the rest pays down the loan. That is why early payments are mostly interest and late ones mostly principal, and why extra payments early on save the most.

The debt service coverage ratio

coverage ratio = yearly income available to pay debt ÷ yearly debt payments

The ratio counts every loan payment you make in a year, principal and interest, including the new loan. At 1.00 the income exactly covers the payments with nothing left over. Below 1.00 it does not cover them. Above 1.00 there is room to spare: 1.25 means $1.25 of income for every $1 of payments.

The largest loan figure runs the formula backwards: it takes the income, divides by your target ratio, subtracts the debt you already pay, and finds the loan whose payments fit in what is left at the rate and term above. If you are applying for a loan, ask the lender what ratio and what income figure it uses.

Questions

Does this work as an SBA loan calculator?

Yes, for any loan with a fixed rate and equal monthly payments. If your rate moves with a published rate, the payment changes when the rate does; type today's rate to see today's payment. Fees are not included. If fees are added to the loan, add them to the amount borrowed.

Where do I find the income figure?

Start from yearly net profit on your profit and loss report, then add back interest, income tax, depreciation and amortization. If a lender works the figure out differently, use theirs.

Why does the last payment look smaller?

With extra payments, the loan is paid off part way through a month, so the final payment is only what is left.

Is anything I type sent anywhere?

No. The arithmetic runs in your browser.

Who made this?

Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.