Report this item to Etsy

SBA Loan Calculator Spreadsheet, SBA 7a Loan Payment and Amortization Schedule, Variable Rate Business Loan, Excel & Google Sheets

NowPrice:$6.40

Original Price: $8.00

Loading

20% off

•

Sale ends on December 9

You can only make an offer when buying a single item

Highlights

What will the SBA loan really cost you each month, and what if Prime moves? Get the payment, the fee and the full schedule in a minute.

INSTANT DIGITAL DOWNLOAD for Microsoft Excel and Google Sheets. No physical item will be shipped.

Enter the loan amount, Prime, your spread over Prime, the term, whether the guaranty fee is financed, and any interest-only months. The Results tab shows the monthly payment, financed fee, annual debt service, total interest, the cost per $100,000 financed and a DSCR check against your lender's minimum. A rate shock table shows the payment if Prime moves up or down.

WHAT'S INSIDE
- Inputs tab: amount, Prime, spread, term, interest-only months, fee (you enter your lender's quote), optional cash flow for the DSCR check
- Results tab: payment, annual debt service, total interest, cost per $100k, DSCR
- Rate shock table: payment at -3% to +3% (edit the steps)
- Principal vs. interest by year, with a chart
- Schedule tab: month-by-month amortization for up to 25 years
- Sample fictional loan: $1,200,000 at Prime + 2.75% over 10 years, which gives a $16,505 payment

HOW TO USE IT
Enter the terms from your lender's term sheet, then use the rate shock table to see what a rate move does to the payment.

READY FOR MORE?
Checking if the business can carry the payment? Try the SBA 7(a) Business Quick Screener, or the full SBA 7(a) Business Acquisition Model.

Note: You enter the rate and fee your lender quotes; SBA rules and fees change, so confirm current terms with your lender. The schedule assumes the rate stays fixed at today's Prime + spread (real loans can reprice). Not affiliated with or endorsed by the U.S. Small Business Administration.

HOW TO OPEN IT
- Excel: after purchase go to Etsy > You > Purchases and reviews, click "Download Files", save the .xlsx and open it in Excel 2016+ or Microsoft 365. If Excel opens it in Protected View, click Enable Editing so the numbers calculate.
- Google Sheets: upload the .xlsx to Google Drive, then right-click it and choose Open with > Google Sheets (or use File > Import in a new Sheet).
- Start on the Inputs tab and replace the sample numbers in the blue cells. Read the answer on the Results tab.

PLEASE NOTE
- Digital file only; nothing is shipped. All sales are final. If something isn't working, message me and I'll help.
- Educational tool, not investment, lending, tax or legal advice. Example figures are fictional.
- Single-user license. Please do not resell or share the file.

Created by Kyle H, CFA · JENCPTemplates

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 28, 2026