SBA 504 Funding & Repayment Planner

See the complete funding requirement behind a two-loan SBA 504 scenario. Itemize shared project and cash-only costs, then compare up to three authored bank/CDC/borrower funding alternatives. Each loan has its own fixed note rate, amortization, maturity, financed fees, upfront fees and separate monthly servicing charge. Funding and closing-cash charts reconcile to the cent; payment charts expose maturity balloons beside regular payments. Inspect either loan at a chosen month, compare annual ledgers and export every input and schedule. This is a hypothetical funding and repayment planner, not an eligibility decision, official SBA calculator, fee schedule or lender quote. Actual permitted costs, contribution requirements, terms and fee treatment need confirmation with your lender and CDC.

SBA 504 funding scenarios

See the cash. See the balloon.

Compare project funding and closing cash, then follow both loans through repayment. Keep regular payments and maturity obligations visible.

Illustrative 10% project contribution: USD 155,000.00 closing cash; USD 659,718.49 financing cost at month 120.

Edit project costs and funding alternatives

Build a hypothetical bank, CDC and borrower funding structure using your quotes. The example shares are illustrative. Classification, arithmetic limits and results do not determine SBA eligibility, required equity or approval. Confirm permitted costs, contribution and fees with your lender and CDC.

Cash and comparison month

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. A shortfall remains visible; it does not change the financing assumptions.

Whole month 0–360. Month 0 is before repayments. Schedules still run through both loan maturities, even when this comparison is earlier.

Shared uses of funds

Use the same project for all alternatives. Allocated project costs are split by the entered shares. Cash-only costs are paid entirely by the borrower. This classification does not establish eligible 504 costs. Enter financing fees in the loan sections, avoiding duplication here.

Use of funds 1

1–80 characters; describe the purchase or other cost.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded.

Allocated costs use bank/CDC/borrower shares; cash-only costs bypass those shares.

Use of funds 2

1–80 characters; describe the purchase or other cost.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded.

Allocated costs use bank/CDC/borrower shares; cash-only costs bypass those shares.

Use of funds 3

1–80 characters; describe the purchase or other cost.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded.

Allocated costs use bank/CDC/borrower shares; cash-only costs bypass those shares.

Funding alternatives

Alternative 1

1–80 characters. Name the offer or funding assumption you are comparing.

0–100%, at most six decimal places. Bank + CDC must not exceed 100%; the remainder is borrower project contribution.

0–100%, at most six decimal places. These are authored shares, not confirmation of the program’s permitted financing.

Project cents use largest-remainder allocation so the three shares add up exactly. A tied remainder goes to bank, then CDC, then borrower. Financed fees increase loan principal separately; upfront fees increase closing cash.

Bank / third-party loan

0–50%, at most six decimal places. Use the note rate, not APR. Do not add fees already included in an effective quoted CDC rate; obtain a consistent rate and fee breakdown.

Whole months 1–360 used to calculate the regular payment. This arithmetic range is not a list of approved program terms.

Whole months 1 through amortization months. Remaining principal after this month’s regular payment is due as a separate balloon; no refinancing is assumed.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Added on top of the allocated project loan amount and repaid with interest.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Paid from borrower cash, not added to this loan balance.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Flat assumed charge while opening debt is positive, including the payoff month. This does not calculate an SBA or CDC fee schedule.

CDC loan

0–50%, at most six decimal places. Use the note rate, not APR. Do not add fees already included in an effective quoted CDC rate; obtain a consistent rate and fee breakdown.

Whole months 1–360 used to calculate the regular payment. This arithmetic range is not a list of approved program terms.

Whole months 1 through amortization months. Remaining principal after this month’s regular payment is due as a separate balloon; no refinancing is assumed.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Added on top of the allocated project loan amount and repaid with interest.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Paid from borrower cash, not added to this loan balance.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Flat assumed charge while opening debt is positive, including the payoff month. This does not calculate an SBA or CDC fee schedule.

Both loans start together with month-end payments. Regular payment is rounded half-up to cents once; monthly interest is rounded half-up separately. The maturity payment clears any remaining principal, including a small rounding residual. Actual loan billing may differ.

Alternative 2

1–80 characters. Name the offer or funding assumption you are comparing.

0–100%, at most six decimal places. Bank + CDC must not exceed 100%; the remainder is borrower project contribution.

0–100%, at most six decimal places. These are authored shares, not confirmation of the program’s permitted financing.

Project cents use largest-remainder allocation so the three shares add up exactly. A tied remainder goes to bank, then CDC, then borrower. Financed fees increase loan principal separately; upfront fees increase closing cash.

Bank / third-party loan

0–50%, at most six decimal places. Use the note rate, not APR. Do not add fees already included in an effective quoted CDC rate; obtain a consistent rate and fee breakdown.

Whole months 1–360 used to calculate the regular payment. This arithmetic range is not a list of approved program terms.

Whole months 1 through amortization months. Remaining principal after this month’s regular payment is due as a separate balloon; no refinancing is assumed.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Added on top of the allocated project loan amount and repaid with interest.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Paid from borrower cash, not added to this loan balance.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Flat assumed charge while opening debt is positive, including the payoff month. This does not calculate an SBA or CDC fee schedule.

CDC loan

0–50%, at most six decimal places. Use the note rate, not APR. Do not add fees already included in an effective quoted CDC rate; obtain a consistent rate and fee breakdown.

Whole months 1–360 used to calculate the regular payment. This arithmetic range is not a list of approved program terms.

Whole months 1 through amortization months. Remaining principal after this month’s regular payment is due as a separate balloon; no refinancing is assumed.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Added on top of the allocated project loan amount and repaid with interest.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Paid from borrower cash, not added to this loan balance.

USD 0–1,000,000,000, with at most two decimal places. Enter explicit zero if excluded. Flat assumed charge while opening debt is positive, including the payoff month. This does not calculate an SBA or CDC fee schedule.

Both loans start together with month-end payments. Regular payment is rounded half-up to cents once; monthly interest is rounded half-up separately. The maturity payment clears any remaining principal, including a small rounding residual. Actual loan billing may differ.

Closing cash and financing cost

Cash needed at closing
USD 155,000.00
Project contribution + cash-only costs + upfront fees
Cash headroom / shortfall
USD 45,000.00
Available cash minus closing cash; negative means shortfall
Financing cost at month 120
USD 659,718.49
Upfront and financed fees + interest + servicing paid
Peak total monthly payment
USD 480,163.63
Month 120; includes balloons and servicing

Lowest closing cash: Illustrative 10% project contribution. Lowest financing cost at month 120: Illustrative 15% project contribution. These comparisons do not establish SBA eligibility, loan approval or the best financing choice.

At the selected comparison month, cash paid including closing is USD 1,509,066.31 and debt remaining is USD 375,652.18. Principal repayment is not financing cost. No refinancing is assumed at maturity.

Project allocation and complete funding

Allocated project costs: USD 1,200,000.00. Cash-only costs: USD 25,000.00. Complete funding bars share a 0–USD 1,257,000.00 scale and include financed fees. Solid = bank loan; diagonal = CDC loan; vertical = borrower closing cash.

Illustrative 10% project contribution

Project-only allocation: bank USD 600,000.00 · cdc USD 480,000.00 · borrower USD 120,000.00.

  • bank: USD 610,000.00
  • cdc: USD 492,000.00
  • cash: USD 155,000.00

Total sources = total uses: USD 1,257,000.00.

Illustrative 15% project contribution

Project-only allocation: bank USD 600,000.00 · cdc USD 420,000.00 · borrower USD 180,000.00.

  • bank: USD 610,000.00
  • cdc: USD 432,000.00
  • cash: USD 215,000.00

Total sources = total uses: USD 1,257,000.00.

What must come from cash

Shared 0–USD 215,000.00 scale. Solid = borrower project contribution; diagonal = cash-only uses; vertical = upfront fees. Dashed marker = available cash, USD 200,000.00.

Illustrative 10% project contribution · USD 155,000.00

  • project-contribution: USD 120,000.00
  • cash-only: USD 25,000.00
  • upfront-fees: USD 10,000.00

Headroom / shortfall: USD 45,000.00.

Illustrative 15% project contribution · USD 215,000.00

  • project-contribution: USD 180,000.00
  • cash-only: USD 25,000.00
  • upfront-fees: USD 10,000.00

Headroom / shortfall: USD −15,000.00.

Repayment and maturity obligations

Payment bars show Illustrative 10% project contribution on a shared 0–USD 480,163.63 monthly cash scale. Solid = regular payment; diagonal = balloon; vertical = servicing. Full schedules extend through both maturities, independently of the financing-cost comparison month.

Monthly regular payments, balloons and servicingMonth zero begins at the left and the final shared month is at the right. Zero is at the bottom. Read the selected-month breakdown and annual ledger for exact amounts. The selected month is marked with a dashed vertical line.
Month 0Month 300

Month 120: regular payments USD 7,288.72 + balloons USD 472,819.91 + servicing USD 55.00 = USD 480,163.63 cash due. Remaining debt: USD 375,652.18.

LoanOpening debtInterestRegular paymentBalloonServicingCash dueEnding debt
BankUSD 474,369.17USD 2,569.50USD 4,118.76USD 472,819.91USD 20.00USD 476,958.67USD 0.00
CDCUSD 376,937.45USD 1,884.69USD 3,169.96USD 0.00USD 35.00USD 3,204.96USD 375,652.18

Funding alternatives at month 120

AlternativeBank principalCDC principalClosing cashHeadroom / shortfallFinancing costRemaining debt
Illustrative 10% project contributionUSD 610,000.00USD 492,000.00USD 155,000.00USD 45,000.00USD 659,718.49USD 375,652.18
Illustrative 15% project contributionUSD 610,000.00USD 432,000.00USD 215,000.00USD −15,000.00USD 627,517.53USD 329,840.82

Annual debt ledger · Illustrative 10% project contribution

All amounts are USD. Annual regular payments exclude the separate balloon and servicing columns. A final partial year includes only its listed months. Monthly interest and payment rounding follow the stated planning convention.

Year / monthsInterestRegular paymentsBalloonsServicingPrincipal paidTotal cash dueEnding debt
Year 1 · 1–12USD 68,635.20USD 87,464.64USD 0.00USD 660.00USD 18,829.44USD 88,124.64USD 1,083,170.56
Year 2 · 13–24USD 67,420.54USD 87,464.64USD 0.00USD 660.00USD 20,044.10USD 88,124.64USD 1,063,126.46
Year 3 · 25–36USD 66,127.37USD 87,464.64USD 0.00USD 660.00USD 21,337.27USD 88,124.64USD 1,041,789.19
Year 4 · 37–48USD 64,750.66USD 87,464.64USD 0.00USD 660.00USD 22,713.98USD 88,124.64USD 1,019,075.21
Year 5 · 49–60USD 63,284.92USD 87,464.64USD 0.00USD 660.00USD 24,179.72USD 88,124.64USD 994,895.49
Year 6 · 61–72USD 61,724.47USD 87,464.64USD 0.00USD 660.00USD 25,740.17USD 88,124.64USD 969,155.32
Year 7 · 73–84USD 60,063.14USD 87,464.64USD 0.00USD 660.00USD 27,401.50USD 88,124.64USD 941,753.82
Year 8 · 85–96USD 58,294.42USD 87,464.64USD 0.00USD 660.00USD 29,170.22USD 88,124.64USD 912,583.60
Year 9 · 97–108USD 56,411.31USD 87,464.64USD 0.00USD 660.00USD 31,053.33USD 88,124.64USD 881,530.27
Year 10 · 109–120USD 54,406.46USD 87,464.64USD 472,819.91USD 660.00USD 505,878.09USD 560,944.55USD 375,652.18
Year 11 · 121–132USD 22,105.67USD 38,039.52USD 0.00USD 420.00USD 15,933.85USD 38,459.52USD 359,718.33
Year 12 · 133–144USD 21,122.91USD 38,039.52USD 0.00USD 420.00USD 16,916.61USD 38,459.52USD 342,801.72
Year 13 · 145–156USD 20,079.54USD 38,039.52USD 0.00USD 420.00USD 17,959.98USD 38,459.52USD 324,841.74
Year 14 · 157–168USD 18,971.81USD 38,039.52USD 0.00USD 420.00USD 19,067.71USD 38,459.52USD 305,774.03
Year 15 · 169–180USD 17,795.75USD 38,039.52USD 0.00USD 420.00USD 20,243.77USD 38,459.52USD 285,530.26
Year 16 · 181–192USD 16,547.16USD 38,039.52USD 0.00USD 420.00USD 21,492.36USD 38,459.52USD 264,037.90
Year 17 · 193–204USD 15,221.57USD 38,039.52USD 0.00USD 420.00USD 22,817.95USD 38,459.52USD 241,219.95
Year 18 · 205–216USD 13,814.20USD 38,039.52USD 0.00USD 420.00USD 24,225.32USD 38,459.52USD 216,994.63
Year 19 · 217–228USD 12,320.03USD 38,039.52USD 0.00USD 420.00USD 25,719.49USD 38,459.52USD 191,275.14
Year 20 · 229–240USD 10,733.72USD 38,039.52USD 0.00USD 420.00USD 27,305.80USD 38,459.52USD 163,969.34
Year 21 · 241–252USD 9,049.56USD 38,039.52USD 0.00USD 420.00USD 28,989.96USD 38,459.52USD 134,979.38
Year 22 · 253–264USD 7,261.51USD 38,039.52USD 0.00USD 420.00USD 30,778.01USD 38,459.52USD 104,201.37
Year 23 · 265–276USD 5,363.20USD 38,039.52USD 0.00USD 420.00USD 32,676.32USD 38,459.52USD 71,525.05
Year 24 · 277–288USD 3,347.78USD 38,039.52USD 0.00USD 420.00USD 34,691.74USD 38,459.52USD 36,833.31
Year 25 · 289–300USD 1,208.08USD 38,039.52USD 1.87USD 420.00USD 36,833.31USD 38,461.39USD 0.00

Save all alternatives and loan schedules

CSV includes every input, funding source, individual and combined loan ledger, annual total and chart value. Fields ending Cents are integer USD cents; this keeps exact accounting. The selected alternative and month do not limit the export.

How to use this calculator

  1. Open Edit project costs and funding alternatives. Enter available closing cash and the month at which you want to compare financing cost; month zero is before repayments.
  2. Add shared uses of funds. Mark each as allocated project or cash-only according to your scenario. Classification is not an eligible-cost determination, and financing fees should not also be duplicated in project costs.
  3. Name each alternative and enter bank and CDC project shares. The remainder is borrower project contribution. Add a blank alternative or duplicate one explicitly to compare different terms.
  4. For each bank and CDC loan, enter the fixed nominal note rate, amortization months, maturity month, financed fees, upfront fees and any separate flat monthly servicing charge. Confirm the rate and fee basis with the lender.
  5. Inspect funding and closing cash, select a payment month, and switch between monthly payments and remaining debt. Review the separate maturity balloons, annual and monthly ledgers, then Download SBA funding CSV or Show CSV text to save all alternatives.

The Formula

The mathematical logic powering this calculation is:

Sum uses marked allocated project into project cost; sum cash-only uses separately. Bank and CDC percentages are authored assumptions. Borrower project percentage = 100 − bank percentage − CDC percentage, with the first two summing to no more than 100. To conserve cents, calculate each exact percentage allocation, floor each to whole cents, and distribute leftover cents to the largest fractional remainders. Ties go bank, then CDC, then borrower. Thus allocations always sum to the project amount, including one-cent cases.
Bank principal = bank project allocation + bank financed fees; CDC principal is analogous. Closing cash = borrower project allocation + cash-only costs + both upfront fees. Cash headroom = available cash − closing cash and may be negative. Total uses = project + cash-only costs + financed fees + upfront fees = total initial debt + closing cash. Financed fees are not automatically treated as permissible SBA project costs.
Each loan starts at month 0. Let P be principal in cents, r the nominal annual note rate / 1200 and n amortization months. Scheduled monthly payment = P × r × (1+r)^n / [(1+r)^n − 1], or P/n at zero rate, rounded half-up to cents once. Each month, interest = opening balance × r, separately rounded half-up to cents. Regular payment is capped at opening balance plus interest. At maturity, any remaining principal after the regular payment is an additional balloon, including a small rounding residual at full amortization. The separate servicing charge applies only when opening principal is positive, including the payoff month, and stops after an early payoff. These are stated planning conventions, not a guarantee of actual loan billing.
Combined payments sum bank and CDC regular payments, balloons and servicing without merging their loan terms. Annual rows group months 1–12, 13–24 and so on. Complete schedules run through the later of both maturities and the comparison month. Financing cost at month H = all upfront and financed fees + cumulative interest + cumulative servicing through H. It also equals closing cash + debt payments to date + remaining debt − project cost − cash-only costs. Principal repayment is not financing cost. Peak monthly payment includes balloons and servicing; all ties remain visible.
Supported arithmetic: 1–12 uses, 1–3 alternatives, each money input USD 0–1000000000 with at most two decimal places. Shares are 0–100% with at most six places. Note rates are 0–50% with at most six places. Amortization is 1–360 whole months; maturity is 1 through amortization months. Comparison month is 0–360. Exact rational annuity arithmetic and integer-cent accounting avoid floating-point cancellation and preserve reconciliations. Numerical limits and editable terms do not establish program eligibility.
The example 50/40/10 split is illustrative, not a universal requirement. The tool does not calculate SBA guarantee or CDC fees, verify eligible costs, apply loan caps or special-property rules, infer required equity, model interim advances or variable rate resets, calculate APR, assume refinancing, or include prepayment penalties, extra payments or tax effects. Use a note rate and separate fees consistently; do not double-count fees already embedded in an effective CDC quote rate.

Worked Example

If you input:

  • Shared costs: USD 1000000 building + USD 200000 equipment allocated as project; USD 25000 cash-only costs
  • Available cash and comparison: USD 200000 available; compare financing cost at month 120
  • Alternative 1 shares: Bank 50%; CDC 40%; borrower residual 10%
  • Bank loan in both alternatives: 6.5% fixed nominal note rate; 300-month amortization; maturity month 120; USD 10000 financed fees + USD 6000 upfront fees + USD 20/month servicing
  • CDC loan in both alternatives: 6% fixed nominal note rate; 300-month amortization and maturity; USD 12000 financed fees + USD 4000 upfront fees + USD 35/month servicing
  • Alternative 2 shares: Bank 50%; CDC 35%; borrower residual 15%; other terms unchanged

Result:

Alternative 1 allocates the USD 1200000 project as USD 600000 bank, USD 480000 CDC and USD 120000 borrower contribution. Adding financed fees gives bank principal USD 610000 and CDC principal USD 492000. Closing cash is USD 155000: USD 120000 contribution + USD 25000 cash-only costs + USD 10000 upfront fees, leaving USD 45000 cash headroom. Total sources and uses both equal USD 1257000. At month 120, combined regular payments are USD 7288.72, the bank balloon is USD 472819.91 and servicing is USD 55.00, for USD 480163.63 cash due. Remaining CDC debt is USD 375652.18. Financing cost through month 120 is USD 659718.49. These are illustrative cent-rounded scenario results, not loan offers or approval.

Frequently Asked Questions

Does this determine whether my project qualifies for SBA 504 financing?

No. The planner evaluates authored financing assumptions only. It does not determine eligible business or project costs, loan caps, required contribution, special-property rules or approval. Confirm the structure and fee treatment with your lender and Certified Development Company.

Is the borrower contribution always 10%?

No. The example uses a commonly illustrated 50% bank, 40% CDC and 10% borrower split, but actual required contributions and permitted shares can differ. This planner accepts your shares and shows their consequences; arithmetic acceptance is not program approval.

Why is closing cash larger than the borrower project share?

Closing cash also includes cash-only uses and fees paid upfront for both loans. Financed fees instead increase debt. The sources-and-uses view reconciles all these amounts so a percentage down payment does not hide other cash needs.

Why does a bank loan have a balloon if its regular payment amortizes the debt?

The regular payment uses the amortization period, which may be longer than the legal maturity. At maturity, the outstanding principal after that month’s regular payment is also due. The planner shows that balloon separately and does not assume refinancing will be available.

Should I enter the CDC effective rate or note rate?

Enter a consistent fixed nominal note rate and separate fees. An effective quoted rate may already include servicing or other costs; adding those again can double-count them. The flat monthly charge here is your scenario input, not a reproduction of the official CDC or SBA fee schedule.

Why can the calculated contribution differ by a cent from a percentage product?

Money is allocated in whole cents. Each percentage allocation is initially floored and remaining cents go to the largest fractional remainders, with bank, CDC and borrower breaking ties in that order. This keeps total funding equal to total uses even for very small amounts.

What does financing cost at the comparison month include?

It includes upfront and financed fees plus interest and servicing paid through that month. Principal repayments reduce debt and are not financing cost. Cash paid and remaining debt are shown separately; the full loan schedules continue through maturity even when your comparison month is earlier.

What happens at zero interest, early payoff or insufficient cash?

Zero interest divides principal by amortization months before cent rounding. If rounding pays a small balance early, later interest and servicing stop. Any residual at maturity is paid as a balloon. A closing-cash shortfall remains visible while the hypothetical schedule is retained; no missing funding is silently supplied.

Similar Calculators