askedii

Home / Free tools

Business loan payment calculator

The payment on a fixed-rate business loan, the same PMT formula Excel and lenders use.

The formula
Payment = L x r / (1 - (1 + r)^-n), where r is the monthly rate and n the number of months. It is the same as Excel's PMT.
SBA rates
SBA 7(a) rates are the prime rate plus a capped spread that depends on the loan size; ask your lender for today's rate.
Variable rates
Many SBA loans are variable. Run the calculator at a rate 2 points higher to see how much room your plan has.

See it for all 5 years of your plan

Industry templates with monthly cash flow, DSCR by year and sources and uses. $39 Choose your business

Other free tools: DSCR calculator · Break-even calculator