To calculate a business loan payment manually, use the standard amortization formula: PMT = P × r(1+r)^n ÷ ((1+r)^n – 1), where P is the principal, r is the periodic interest rate, and n is the total number of payments. Plug that into Excel as =PMT(rate,nper,pv) or compute by hand to verify any lender quote. Below, I’ll walk through a real $1,000,000 SBA case study, show how fees and balloons alter the math, and give you a founder’s checklist to negotiate from strength.
Why Founders Should Learn the Manual Formula (Not Just Click a Calculator)
When I first tried to model a $850,000 equipment loan for a manufacturing client, I trusted a popular online calculator and missed a 1.5% origination fee that got rolled into the balance. The monthly payment looked $640 lower than reality. That mistake delayed our hire plan by two months.
The thing nobody tells you about most business loan calculators is they assume a clean principal, monthly compounding, and zero fees. Lenders rarely offer that clean a deal. If you know the underlying math, you can spot when a term sheet hides costs in the APR or the amortization schedule.
I later sat across from a regional bank VP who quoted a $4,200 monthly payment on a $700k line. My back-of-envelope PMT gave $4,980. Turned out he’d quoted interest-only for the first year. That’s legal, but it is not a fully amortizing payment, and it masked the real burden.
Manual calculation is also a negotiation weapon. When a banker quotes a payment, you can recreate it in seconds and ask pointed questions about the assumed rate, term, and fees. That signals you’re not a rookie.
The most dangerous gap in automated tools is they rarely model the interaction of fees, compounding, and balloons simultaneously. You need the manual framework to see second-order effects—like a low payment on a 30-year amortization with a 10-year balloon that leaves $800k to refinance.
If you’d rather automate the repetition after learning the formula, our Business Loan Payment Calculator mirrors the PMT logic and lets you stress-test variables. But the goal here is to make you independent of any black-box tool.
The Core PMT Formula: Breaking Down Every Variable
The amortization formula looks intimidating, but it’s just a geometric series sum. At its heart, it divides the principal plus total interest into level payments that cover compounding.
What each symbol means
P (Principal): The amount you actually borrow and must repay. Crucially, this is not always the loan face value—if fees are capitalized, P includes them.
r (Periodic rate): The interest rate per payment period. For a 6.5% APR with monthly payments, r = 0.065 ÷ 12 = 0.0054167. If compounding is daily, the effective monthly rate differs.
n (Number of payments): Term in years multiplied by payments per year. A 10-year loan paid monthly has n = 120. Balloon loans still use the full amortization period for payment calculation, not the balloon date.
Excel and Google Sheets implementation
In Excel or Google Sheets, the formula is =PMT(rate, nper, pv, [fv], [type]). For our base example: =PMT(0.065/12, 300, 1000000) returns -$6,754. The negative sign simply means cash outflow.
Use absolute cell references when building a model. I typically put rate in B1, nper in B2, pv in B3, then =PMT($B$1,$B$2,$B$3). This lets you drag variations without breaking the link.
Most people don’t realize the PMT function assumes payments occur at period end. If your loan requires beginning-of-month payments (rare for business term loans but common in leases), add a 1 as the type argument.
Reverse engineering: solving for rate or term
If you know the payment and principal, you can solve for the implied rate with =RATE(nper, pmt, pv) or for term with =NPER(rate, pmt, pv). I use this to decode dealer financing that quotes “$499 a month” on unknown terms.
Interest-only vs amortizing misconception
Many think the PMT formula applies to every loan. Interest-only structures use PMT = P × r with zero principal reduction. That payment is lower initially but leaves the full P due at maturity. Confusing the two is the most common error I see in founder cash-flow models.
Step-by-Step: Calculating a $1,000,000 SBA 7(a) Loan With the 20% Rule
Let’s apply the founder’s formula to a real scenario. Suppose you’re buying a commercial building priced at $1.25M. Under SBA 7(a) owner-occupied real estate guidelines, the agency expects a 20% equity injection on the total project cost, as outlined in the SBA 7(a) program standards. The exact equity requirement varies by loan type and lender underwriting; the SBA provides guidelines but delegates specifics to CDCs and banks.
That 20% rule means you must bring $250,000 in cash. The SBA-backed loan covers the remaining $1,000,000. Too many borrowers think they can borrow the full price; the equity rule directly shrinks the financed principal and changes the payment base.
Assume a 25-year term (300 months), fixed 6.5% APR, monthly compounding. Step 1: r = 0.065/12 = 0.0054167. Step 2: (1+r)^n = (1.0054167)^300 ≈ 5.056. Step 3: numerator = 1,000,000 × 0.0054167 × 5.056 = $27,390. Step 4: denominator = 5.056 – 1 = 4.056. Payment = $27,390 ÷ 4.056 = $6,754/month.
Now layer in fees. A typical SBA guarantee fee on the guaranteed portion (say 75% of $1M = $750k) runs about 3%, or $22,500. An origination fee of 1% adds $10,000. If both are financed into the loan, new P = $1,032,500.
Recalculate with P = 1,032,500: PMT = 1,032,500 × 0.0054167 × 5.056 ÷ 4.056 ≈ $6,975/month. That’s $221 more than the clean quote—money that goes to fees, not principal.
SBA funding often takes 60–90 days. If you don’t lock the rate, that 6.5% could move before closing, altering the math. Always ask for a rate-lock expiration date in writing.
Here is a sensitivity table for the same $1M base (before fees) and the fee-inclusive $1,032,500 balance at common rates:
| APR | Clean PMT (P=$1M) | PMT with $32.5k fees |
|---|---|---|
| 6.0% | $6,443 | $6,652 |
| 6.5% | $6,754 | $6,975 |
| 7.0% | $7,068 | $7,299 |
When weighing two term sheets, our Loan Comparison Calculator can lay them side by side, but only after you’ve verified each input manually as we just did.
How Fees, Compounding, and Balloon Payments Distort the Number
Even a perfect PMT calculation fails if the inputs are wrong. Here are three areas where lender quotes diverge from manual reality.
Hidden fees that get capitalized
Beyond origination and SBA guarantee, watch for underwriting ($5k–$15k), appraisals ($3k–$8k), and legal fees. If the lender “rolls them in,” your P rises. Always ask for the final disbursed principal used in the payment calc.
In one construction loan I closed, the lender charged a 0.5% inspection fee per draw, totaling $12k, which was capitalized into the balance. That invisible addition bumped the payment by $92/month on a 20-year term.
Compounding frequency traps
APR is a nominal rate. If a line of credit compounds daily, the effective annual yield is higher. For 6.5% APR daily compounded: EAR = (1 + 0.065/365)^365 – 1 ≈ 6.71%. Your true monthly r becomes (1.0671)^(1/12) – 1 ≈ 0.005426, slightly above the simple division.
On a $1M balance, that tiny rate difference adds about $10–$12 per month—small but symbolic of how calculators that assume monthly compounding understate cost on daily-compounded debt.
Balloon payment math
Many commercial mortgages use a 25-year amortization but balloon in 5 years. You calculate the payment using n=300, but after 60 payments a large balance remains. The remaining balance formula: B = P(1+r)^p – PMT × (((1+r)^p – 1) ÷ r).
Using our $1M, 6.5%, $6,754 payment, after p=60 months: (1.0054167)^60 ≈ 1.378. First term = $1,378,000. Second term: (0.378 ÷ 0.0054167)=69.78; ×6,754 = $471,400. B ≈ $906,600. You pay $6,754/mo for 5 years, then owe ~$907k.
Most borrowers confuse the balloon payment with the monthly amount. The true cost of capital includes refinancing risk on that balloon—something no simple calculator shows. I always model the balloon balance as a future cash outflow in year five.
Fixed vs. Variable Rates: Recalculating When the Index Moves
A fixed-rate loan locks r for the term, so PMT stays constant. A variable loan ties r to an index (SOFR, Prime) plus a margin. You must recalculate whenever the index resets.
Example: Start with SOFR at 3% + 3% margin = 6% (r=0.005). PMT on $1M, 300 months = $5,995. If SOFR climbs to 5%, all-in rate 8% (r=0.006667). PMT jumps to $7,718—a $1,723 increase that can sink cash flow.
Credit quality directly affects the margin. A founder with a 780 score might get Prime + 1%; a 680 score could be Prime + 3%. On a $1M loan, that 2% margin difference is roughly $1,200/month at current Prime levels. The thing nobody tells you: lenders often quote the index low and profit on the margin.
Trade-off: Variable usually starts cheaper and caps upside in falling markets, but fixed protects against inflation shocks. I advise clients to model both at the 5-year balloon horizon before choosing.
Below is a rough margin-by-score table for a $1M loan with SOFR at 3% (illustrative, not a guarantee):
| Credit score | Typical margin | All-in rate | PMT (300 mo) |
|---|---|---|---|
| 780+ | +1.0% | 4.0% | $5,258 |
| 720 | +2.0% | 5.0% | $5,845 |
| 680 | +3.0% | 6.0% | $6,443 |
Common Misconceptions That Cost Borrowers Thousands
Beyond the interest-only confusion, founders routinely misread loan quotes. Here are the top traps I’ve personally untangled.
A low monthly payment is always better
Extending term to 30 years drops the payment but multiplies total interest. On $1M at 6.5%, a 10-year term costs $341k interest; a 25-year term costs $1.03M. The lower payment hid a $690k extra cost.
APR already includes every fee
APR captures most finance charges but excludes some third-party costs and often assumes you hold to maturity. Balloon refinance costs are absent. Manual PMT with capitalized fees is the only true picture.
The bank’s calculator is infallible
I’ve caught three lender calculators that defaulted to 360-day years or ignored the SBA guarantee fee. Verify with your own sheet before signing.
A Founder’s Verification Checklist (Apply This Before Signing)
Use this checklist to manually verify any business loan offer. It has saved me from three bad term sheets.
- 1. Confirm principal basis: Is P the face value or face + capitalized fees? Request the exact financed amount in writing.
- 2. Verify compounding: Ask “how often is interest compounded?” If not monthly, compute effective r before using PMT.
- 3. Apply equity rules: For SBA/CDC deals, subtract required injection (20% in our case) before trusting loan amount covers the purchase.
- 4. Check balloon terms: If amortization ≠ maturity, calculate remaining balance at balloon date using the formula above.
- 5. Stress-test rate: Add 200 bps to variable indexes and recompute PMT to see worst-case cash flow.
- 6. Compare APR vs payment: A low payment with long term may hide higher total cost; use PMT to see monthly, then sum all payments.
- 7. Model fees on default: Late fees and sweep provisions can alter effective r; read the covenant sheet, not just the term sheet.
Print this and bring it to the lending meeting. When you ask question #2, the loan officer will know you’ve done the math.
Advanced Edge Cases: Seasonal and Interest-Only Structures
Some businesses take loans with seasonal payments or initial interest-only periods. The PMT formula still works if you adjust n and P appropriately. For a 12-month interest-only period, compute P × r for those months, then amortize the remaining balance over the shortened term.
For seasonal swings, I build a monthly cash-flow grid in Sheets where the PMT is paid only in high-revenue months. The annual total must still cover the accrued interest plus principal reduction, or the loan amortizes slower than quoted.
The thing nobody tells you about customized schedules is that lenders often use a 365-day year-count convention for daily accrual, which slightly changes r versus a 360-day banker’s year. Always ask the convention.
When to Use a Calculator vs. Manual Math
Manual calculation is for verification, negotiation, and understanding edge cases. A calculator is for speed and scenario stacking. I do both: hand-build the model in Sheets, then cross-check with an online tool.
The key is never accepting a payment number you can’t recreate. Whether it’s a $50k microloan or a $1M SBA purchase, the founder’s formula puts you in control. Start with the PMT equation, layer in fees and rules, and you’ll calculate business loan payment with banker-level precision.