JJENCP CalculatorsFree tools from JENCP Templates

SBA 7(a) loan calculator

Get the payment on a variable-rate SBA 7(a) loan, the cost of the guaranty fee, and what a move in Prime does to your debt service coverage.

Inputs

Loan terms (from your term sheet)
Before any financed fee.
Sample value. Enter today’s Prime.
10 for business acquisitions; up to 25 with real estate.
Then it amortizes over the rest of the term.
Guaranty fee (enter your lender’s quote)
% of the loan. SBA fees change each fiscal year.
Unchecked = paid in cash at closing.
Coverage check (optional)
EBITDA less owner pay, capex and taxes. 0 to skip.

Results

Loading… (this calculator needs JavaScript)

How the numbers are calculated

Rate = Prime + spread Guaranty fee = loan × fee % (added to the balance if financed) Interest-only pmt = balance × rate ÷ 12 Monthly payment = PMT(rate ÷ 12, months left after IO, balance) DSCR = annual cash flow ÷ (payment × 12)

Most 7(a) loans float at Prime plus a spread, so the payment you sign up for isn’t the payment you’ll always make. The rate-shock table reprices the loan at Prime −3% to +3% and recomputes DSCR so you can see how much room you have.

Worked example

A $1,200,000 loan at Prime 7.50% + 2.75% = 10.25% over 10 years, with a 3% guaranty fee financed. These are sample figures, not a quote.

Guaranty fee (3% × $1,200,000)$36,000
Balance with fee financed$1,236,000
Monthly payment (120 payments at 10.25%)$16,505.42
Annual debt service$198,065.05
Total interest over the loan$744,650

With $360,000 a year of cash flow available for debt service, DSCR is $360,000 ÷ $198,065 = 1.82x. If Prime rises 3 points the payment goes to $18,638 (+$2,132 a month) and DSCR drops to 1.61x, still above a 1.25x minimum.

Practitioner notes

  • The fee. SBA guaranty fees depend on loan size and maturity and are reset each fiscal year. Enter the figure from your lender’s term sheet rather than a rule of thumb.
  • Cash flow for DSCR should be after a market-rate salary for whoever runs the business, maintenance capex and taxes. Lenders will recast it that way, so you should too.
  • Interest-only months lower the early payment, but the remaining term is shorter, so the amortizing payment is higher than it would be without them.