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.
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.
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.
Funding alternatives
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.
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.
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
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.
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.
| Loan | Opening debt | Interest | Regular payment | Balloon | Servicing | Cash due | Ending debt |
|---|---|---|---|---|---|---|---|
| Bank | USD 474,369.17 | USD 2,569.50 | USD 4,118.76 | USD 472,819.91 | USD 20.00 | USD 476,958.67 | USD 0.00 |
| CDC | USD 376,937.45 | USD 1,884.69 | USD 3,169.96 | USD 0.00 | USD 35.00 | USD 3,204.96 | USD 375,652.18 |
Funding alternatives at month 120
| Alternative | Bank principal | CDC principal | Closing cash | Headroom / shortfall | Financing cost | Remaining debt |
|---|---|---|---|---|---|---|
| Illustrative 10% project contribution | USD 610,000.00 | USD 492,000.00 | USD 155,000.00 | USD 45,000.00 | USD 659,718.49 | USD 375,652.18 |
| Illustrative 15% project contribution | USD 610,000.00 | USD 432,000.00 | USD 215,000.00 | USD −15,000.00 | USD 627,517.53 | USD 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 / months | Interest | Regular payments | Balloons | Servicing | Principal paid | Total cash due | Ending debt |
|---|---|---|---|---|---|---|---|
| Year 1 · 1–12 | USD 68,635.20 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 18,829.44 | USD 88,124.64 | USD 1,083,170.56 |
| Year 2 · 13–24 | USD 67,420.54 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 20,044.10 | USD 88,124.64 | USD 1,063,126.46 |
| Year 3 · 25–36 | USD 66,127.37 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 21,337.27 | USD 88,124.64 | USD 1,041,789.19 |
| Year 4 · 37–48 | USD 64,750.66 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 22,713.98 | USD 88,124.64 | USD 1,019,075.21 |
| Year 5 · 49–60 | USD 63,284.92 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 24,179.72 | USD 88,124.64 | USD 994,895.49 |
| Year 6 · 61–72 | USD 61,724.47 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 25,740.17 | USD 88,124.64 | USD 969,155.32 |
| Year 7 · 73–84 | USD 60,063.14 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 27,401.50 | USD 88,124.64 | USD 941,753.82 |
| Year 8 · 85–96 | USD 58,294.42 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 29,170.22 | USD 88,124.64 | USD 912,583.60 |
| Year 9 · 97–108 | USD 56,411.31 | USD 87,464.64 | USD 0.00 | USD 660.00 | USD 31,053.33 | USD 88,124.64 | USD 881,530.27 |
| Year 10 · 109–120 | USD 54,406.46 | USD 87,464.64 | USD 472,819.91 | USD 660.00 | USD 505,878.09 | USD 560,944.55 | USD 375,652.18 |
| Year 11 · 121–132 | USD 22,105.67 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 15,933.85 | USD 38,459.52 | USD 359,718.33 |
| Year 12 · 133–144 | USD 21,122.91 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 16,916.61 | USD 38,459.52 | USD 342,801.72 |
| Year 13 · 145–156 | USD 20,079.54 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 17,959.98 | USD 38,459.52 | USD 324,841.74 |
| Year 14 · 157–168 | USD 18,971.81 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 19,067.71 | USD 38,459.52 | USD 305,774.03 |
| Year 15 · 169–180 | USD 17,795.75 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 20,243.77 | USD 38,459.52 | USD 285,530.26 |
| Year 16 · 181–192 | USD 16,547.16 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 21,492.36 | USD 38,459.52 | USD 264,037.90 |
| Year 17 · 193–204 | USD 15,221.57 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 22,817.95 | USD 38,459.52 | USD 241,219.95 |
| Year 18 · 205–216 | USD 13,814.20 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 24,225.32 | USD 38,459.52 | USD 216,994.63 |
| Year 19 · 217–228 | USD 12,320.03 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 25,719.49 | USD 38,459.52 | USD 191,275.14 |
| Year 20 · 229–240 | USD 10,733.72 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 27,305.80 | USD 38,459.52 | USD 163,969.34 |
| Year 21 · 241–252 | USD 9,049.56 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 28,989.96 | USD 38,459.52 | USD 134,979.38 |
| Year 22 · 253–264 | USD 7,261.51 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 30,778.01 | USD 38,459.52 | USD 104,201.37 |
| Year 23 · 265–276 | USD 5,363.20 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 32,676.32 | USD 38,459.52 | USD 71,525.05 |
| Year 24 · 277–288 | USD 3,347.78 | USD 38,039.52 | USD 0.00 | USD 420.00 | USD 34,691.74 | USD 38,459.52 | USD 36,833.31 |
| Year 25 · 289–300 | USD 1,208.08 | USD 38,039.52 | USD 1.87 | USD 420.00 | USD 36,833.31 | USD 38,461.39 | USD 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
- 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.
- 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.
- 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.
- 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.
- 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.Method sources
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
SBA 7(a) Loan Calculator & Guaranty Fee Planner
Compare FY 2027 SBA 7(a) guaranty fees, cash at signing, usable proceeds and loan payments. See how cash-paid and funded fees change your funding.
DSCR Loan Calculator
Compare DSCR loan capacity, LTV limits, interest-only payment changes and balloon repayments across property-income scenarios. Inspect schedules and export the full plan.
Construction Loan Calculator & Draw Planner
Plan construction draws and compare monthly interest payments with capitalized interest. Visualize loan balances, cash needs, fees and loan-limit shortfalls.
Loan Amortization Schedule Calculator
Build a payment-by-payment loan amortization schedule with extra payments and total interest savings.
