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 businessOther free tools: DSCR calculator · Break-even calculator