Model study · SBA 504

    A 120-Slot Infant, Toddler and Preschool Center in Middlesex County, Massachusetts: An SBA 504 Model Study

    By Sarrah Allen, MAI, Principal · Updated

    Model study: an illustrative feasibility analysis built on public data for Middlesex County, Massachusetts; not a client engagement.

    Project summary

    ItemModelled project
    AssetPurchase and conversion of an existing one-story commercial building of about 11,500 sq ft into a licensed early education and care center: two infant rooms, three toddler rooms and four preschool rooms, with fenced play yards
    Size120 licensed slots (14 infant, 27 toddler, 79 preschool); about 28.5 full-time-equivalent staff at full enrollment
    LocationSuburban Middlesex County, Massachusetts; no specific parcel or town is modelled
    ProgramSBA 504 (13 CFR part 120 [1]; SOP 50 10 8.1 [2]), owner-occupied, owner-operated
    Total project cost$5,898,750 ($49,156 per licensed slot); total capital with pre-opening costs and the operating reserve held outside the 504 project: $6,608,750
    Loan structureBank first mortgage $2,949,375 (50%); 504 debenture $1,769,625 net, $1,822,000 gross (30%); owner equity $1,179,750 (20%)
    Stabilized DSCR1.59x in Year 4; 1.12x in Year 2; Year 1 runs a $497,040 shortfall after debt service, covered by a $525,000 owner-funded reserve
    ReturnsUnlevered IRR 9.5%; levered IRR 13.7%; equity multiple 3.39x over 10 years at an 11.5% exit capitalization rate on EBITDA
    DeterminationFinanceable as structured only with conditions: 20% equity, a funded ramp reserve, pre-opening enrollment evidence, a tuition study for the actual trade area, and full owner guaranties

    All figures in this table are model results or assumptions, not market facts.

    The credit question

    A lender reviewing a file like this does not need to be convinced that Middlesex County has young children or that its parents work. The census data settle both. The question is narrower and harder: can a center with no operating history, no state operating grant and no subsidy contract fill about 110 of 120 slots at premium prices, pay educators enough to keep its classrooms open, and do so fast enough that the second year of operations covers debt service of $412,608?

    Five things have to be true.

    First, the project must be eligible and correctly classed. Only for-profit businesses are eligible for SBA business loans [2]. The operating company in this model is new, so its owner must contribute at least 15% of project cost, and 20% if the building is also a limited or special purpose property [1], [2]. Child care centers do not appear on the SOP's list of example limited or special purpose properties, but the list is not all-inclusive and the CDC must address the question in its credit memorandum and explain its conclusion [2]. The base case funds 20% so the structure works under either answer.

    Second, enrollment must reach about 95 full-time-equivalent children by Year 4 for coverage of 1.00x, and about 99 for 1.15x. The modelled base is 110. That 15-child margin is the core of the file.

    Third, tuition must hold. The modelled infant price of $34,200 a year in 2027 is more than twice the 2025 national average price of infant care in a center, $15,636 [3], and it sits below the state cost study's 2024 estimate of the full cost of infant care in Metro-region centers [4]. A 10% tuition shortfall at base occupancy takes Year 4 coverage to 0.84x.

    Fourth, wages must stay within the plan. Personnel is 59.4% of stabilized revenue. Every 1% of wage cost moves Year 4 coverage by about 0.045x, and a classroom cannot run short of staff without breaking the licensing ratios the staffing plan assumes.

    Fifth, cash must last through the ramp. Year 1 loses $84,431 before debt service and $497,040 after it. SBA allows a projection-based 504 file to show repayment in Year 2 rather than Year 1 only if the borrower shows liquidity to cover the Year 1 shortfall [2].

    Location and county economy

    Middlesex is part of the Boston labor market north and west of the city.

    IndicatorLatest valueComparisonSource
    Resident population, July 20251,669,9791,631,912 at the 2020 estimates base (+2.3%); Massachusetts +1.7%[5]
    Births, 202515,68715,593 in 2021; Massachusetts 68,055[5]
    Natural change, 2025+4,048Net migration +1,924 (international +13,193, domestic -11,269)[5]
    Median household income, 2025$131,725 (margin of error $4,052)Massachusetts $106,539 (+23.6% for the county)[6]
    Median family income, married couples with own children under 18, 2025$235,971Female householder, no spouse, with own children: $61,725[6]
    Private employment, 2023963,41744,624 establishments; average annual payroll per employee $101,547[7]

    Three readings matter for this asset. First, the county is growing slowly, and the growth comes from international arrivals and births, not domestic movers. In 2025 the county lost 11,269 residents to domestic migration and gained 13,193 from abroad [5]. Births have been flat at about 15,600 to 16,200 a year since 2021 [5]. A child care center therefore cannot count on a rising tide of children; it has to win share of a stable cohort.

    Second, income is high but uneven by family type. The median married couple with children earns $235,971, while the median single mother with children earns $61,725 [6]. At the modelled infant price, care costs 14.5% of the first figure and 55.4% of the second. The model's private-pay price only works for the first group. The second group depends on state financial assistance, whose availability to new families this model study could not confirm (see the market analysis).

    Third, the county's job base is weighted to high-paying sectors (below). That supports demand from two-earner households but makes educators harder to hire.

    Employment base

    Sector, 2023 (NAICS)EmployeesShare of county private employmentSource
    Professional, scientific and technical services (54)159,47116.6%[7]
    Health care and social assistance (62)126,00213.1%[7]
    Educational services (61)92,0869.6%[7]
    Retail trade (44-45)79,1158.2%[7]
    Accommodation and food services (72)68,2587.1%[7]
    Manufacturing (31-33)67,6267.0%[7]
    Information (51)67,3687.0%[7]

    Shares computed from [7].

    Professional services, health care and education account for 39.2% of private employment [7]. They produce the parent profile a full-day center depends on: two working parents, a predictable weekday schedule and the income to pay private tuition. The same sectors also explain the wage problem. Average payroll per private employee in the county is $101,547 [7], while child day care payroll per employee is $36,568 (next section). A center hires from a labor pool that has better-paid options nearby.

    Market analysis

    Demand drivers

    Measure, Middlesex County, 2025ValueMassachusettsSource
    Children under 580,968344,377[6]
    Children under 3 (in households)48,664203,472[6]
    Children age 3 and 4 (in households)32,304140,905[6]
    Own children under 697,215403,088[6]
    Own children under 6 with all resident parents in the labor force75,935 (78.1%)319,539 (79.3%)[6]
    Children under 6 in two-parent families with both parents working61,792 of 78,814 (78.4%)219,498 of 285,514 (76.9%)[6]

    The labor force figure is the one that matters. In 78.1% of Middlesex homes with a child under 6, every parent present is in the labor force [6]. In two-parent homes, both parents work in 78.4% of cases. These households need non-parental care for about 50 hours a week, 50 weeks a year. Children under 3 make up 60.1% of the under-5 population in households [6], which is relevant because infant and toddler care is both the scarcest and the most expensive to provide.

    Supply

    Child day care services (NAICS 624410), Middlesex County20192023ChangeSource
    Establishments with paid employees634624-1.6%[8], [7]
    Employees (mid-March)9,74510,079+3.4%[8], [7]
    Annual payroll$273.2 million$368.6 million+34.9%[8], [7]
    Payroll per employee$28,040$36,568+30.4%[8], [7]

    County Business Patterns counts employer establishments, so it includes centers but excludes most family child care homes, which usually have no employees. Between 2019 and 2023 the number of employer child care establishments fell slightly while employment rose and payroll per employee rose 30.4% [8], [7]. The industry consolidated into fewer, larger operations and paid more for the same labor. That supports the modelled wage assumptions and warns that a new entrant will face the same cost curve.

    Nationally, Child Care Aware of America found that the supply of licensed centers fell in 26 of the 43 states with complete data from 2024 to 2025, about 1% overall, while Massachusetts was one of seven states where the supply of family child care homes grew [3]. A new center in 2027 opens into a state where competing providers also draw on a large state operating grant (see below), which is a caution for a lender.

    Trade-area licensed capacity could not be retrieved for this model, so the supply figures below are assumptions to be replaced with an EEC count for the actual site.

    Public pre-K and the preschool book

    Preschool is 79 of the 120 slots and 58.6% of gross potential tuition in the model, so public pre-K is a direct revenue risk. Cambridge already offers free preschool for all of its 4-year-olds and prioritized 3-year-olds through public and community-based providers, covering the school-day, school-year portion, with possible additional costs for full-day, full-year care depending on family income [9]. The model's site is assumed to be in a town without universal pre-K. Scenario C in the stress tests removes 20 points of preschool enrollment from Year 4 onward to show what happens if that changes.

    Demand method: penetration and required capture

    The appropriate method for a child care center is a penetration test: estimate the number of working-parent children in the trade area who use center care, compare it with existing licensed capacity, and measure the share the new center must capture to stabilize and to break even.

    StepCountyModelled trade areaBasis
    Children under 580,9683,239County from [6]; trade area assumed at 4.0% of county
    Share with all parents in labor force78.1%78.1%Under-6 rate applied to under-5 [6]
    Working-parent children under 563,2442,530Computed
    Share using paid center-based care45%45%Assumption
    Center-care demand (children)28,4601,138Computed
    Existing licensed center capacity, ages 0 to 4Not retrieved1,000Assumption; replace with EEC count
    Unmet demand before the project138Computed
    Modelled stabilized enrollment (Year 4)110.4Model
    Capture of trade-area center demand at stabilization9.7%Computed
    Enrollment needed for DSCR 1.00x in Year 495.4Model
    Capture needed for DSCR 1.00x8.4%Computed

    The center needs about 8.4% of local center-care demand to cover debt service and 9.7% to reach the base case, a share a new facility can win within three years. But the assumed unmet demand of 138 children barely exceeds the center's 120 slots, so it must also draw children from existing programs. Price, quality and staffing stability are therefore competitive variables, not just capacity.

    Turnover matters as much as capture. About a third of enrollment, 35 to 40 children, must be replaced each year as preschoolers leave for kindergarten, against about 627 births a year in the trade area (4.0% of the county's 15,687 births [5]).

    Price position

    BenchmarkInfantToddlerPreschoolSource
    Modelled 2027 tuition (annual, full time)$34,200$31,200$23,700Assumption
    U.S. center average, 2025 (average of state averages)$15,636$12,555 (age 4)[3]
    Estimated daily cost of current care in centers, Metro region, 2024$154$120$64[4]
    Same, annualized at 250 operating days$38,500$30,000$16,000Computed; 250 days is a model assumption
    Estimated daily cost of current care in centers, Northeast region, 2024$147$114$61[4]
    Modelled infant tuition as share of median married-couple-with-children income14.5%Computed from [6]

    The cost-of-care study that the Massachusetts Department of Early Education and Care (EEC) contracted for is the most useful public input for a lender reviewing a Massachusetts center [4]. It estimated that the daily cost of current care in Metro-region centers was $154 for infants, $120 for toddlers and $64 for preschoolers in 2024, and that per-child costs for centers rose 14% to 26% from 2022 to 2024, with facility costs up 28% to 29% and staff compensation up 7% to 9% [4]. The modelled infant price is below that cost estimate, the toddler price is near it and the preschool price is well above it. That is the normal economics of the sector: the study notes that programs often use preschool revenue to cross-subsidize the age groups that are more expensive to serve [4]. The preschool rooms carry the margin. The study's figures are 2024 estimates, and the 250-day annualization is this model's own assumption.

    Subsidy and state operating grants

    Two state programs could support revenue, and the model gives limited credit to one and none to the other.

    Child Care Financial Assistance (CCFA) pays providers a daily rate for eligible children. In 2024 the center CCFA rate covered only 69% to 78% of the estimated cost of current infant care, depending on region, but 125% of preschool cost in the Metro region [4]. Whether income-eligible families in the site's region can obtain new vouchers should be confirmed with EEC; this model study could not reach EEC's own pages. The model assumes 12% of enrolled children are CCFA-funded, mostly agency referrals, at rates 7% below private tuition, a deduction of 0.84% of gross tuition.

    Commonwealth Cares for Children (C3) is the state's operational grant to licensed providers. The FY 2027 General Appropriations Act provides $475 million for operational grants to child care providers, distributed under the statutory formula [10], and the Senate Ways and Means summary describes the C3 program at $475 million, $375 million matched by $100 million from the Early Education and Care Operational Grant Fund [11]. Whether a center that opens in 2027 can receive C3 grants was not confirmed in any source this study could fetch. The base case therefore includes no C3 revenue. If EEC makes the grant available to the new center, it is upside to coverage, not a component of it.

    Forecast

    The model forecasts average enrollment of 55% of licensed capacity in Year 1, 84% in Year 2, 91% in Year 3 and 92% thereafter. A 55% first year implies opening with 35 to 40 pre-enrolled children and adding five to six a month. It is the most important assumption in the model.

    Site and technical

    Site requirements

    RequirementDesign standard assumedModelled design
    Indoor activity spaceAt least 35 sq ft of activity space per child, excluding hallways, bathrooms and adult-only areas4,200 sq ft minimum for 120 children; design provides about 6,300 sq ft in nine rooms (about 52 sq ft per child)
    Outdoor play spaceAt least 75 sq ft per child outdoors at one time; sun and shade; hazards fenced4,500 sq ft minimum for 60 children outside at once; design provides about 9,000 sq ft in separate infant-toddler and preschool yards
    Toilets and sinksAt least one toilet and sink for every 20 children, close to activity spaceSix required; design provides child-height fixtures in or beside each toddler and preschool room
    DiaperingRunning water next to each diapering area; tempered hot waterDiapering station and sink in each infant and toddler room
    StairsBarriers where children under three are servedSingle-story building avoids the issue
    Building and fireCertificate of inspection under the state building code and fire code complianceConversion designed to the occupancy the building official assigns
    Lead paintLead inspection and compliance for children under fivePost-1978 building preferred; if older, deleading in the budget
    SBA environmentalChild-occupied facilities built before 1978 need a lead risk assessment and lead testing at all taps and fountains children may use, within one year of the SBA loan number [2]Included in soft costs

    The design standards in this table, other than the SBA row, are model assumptions drawn from the draft's reading of EEC's licensing regulations (606 CMR 7.00), whose official text this study could not fetch. Each must be confirmed with EEC and the local building official before design.

    The site also needs a safe drop-off loop for about 120 morning arrivals, land for 9,000 sq ft of play yards, a location on parents' commuting path and a clean Phase I. A former office or retail building on about 1.3 acres meets those needs better than a downtown storefront.

    Classroom plan

    Room typeRoomsChildren per roomRatio and group size assumedEducators per room in ratioLicensed slotsEducators in ratio
    Infant (up to 15 months)271:3, plus one educator for 4 to 7 infants; maximum group 72144
    Toddler (15 to 33 months)391:4, plus one educator for 5 to 9 toddlers; maximum group 92276
    Preschool (33 months to school age), full day420, 20, 20, 191:10; maximum group 202798
    Total912018

    Ratios and group sizes are staffing assumptions taken from the draft's reading of 606 CMR 7.10; confirm them against the official regulation and with EEC.

    The ratio table drives the business. Each infant room of seven needs two educators, so an infant room earns at most seven tuitions to pay two salaries. A preschool room of 20 needs the same two educators and earns 20 tuitions. That is why the room mix in the plan is weighted to preschool, and why a lender should ask whether the mix fits local demand rather than just the operator's preference. The staffing plan also assumes each room is led by an educator certified for its age group and that a second trained adult is always available.

    Ratio positions cover only the core of the day. A center open from 7 a.m. to 6 p.m. runs 11 hours, while an educator works eight. The six assistant and floater positions in the staffing plan cover opening and closing shifts, breaks, planning time and absences. The model assumes rooms can be combined in the first and last hours of the day, subject to EEC's rules.

    Zoning and permits

    Massachusetts law limits local control over child care. Under the zoning act, no city or town zoning ordinance or bylaw may prohibit, or require a special permit for, the use of land or structures for a child care facility, defined as a child care center or school-age program; land and structures may still be subject to reasonable regulations on bulk and height, yard sizes, lot area, setbacks, open space, parking and building coverage [12]. For a lender, this removes the largest entitlement risk, a use denial, but not the practical ones. Parking and drop-off rules, site plan review where a town applies it to protected uses, and building and fire code requirements for the change of use still govern cost and schedule. EEC licensing comes last, and its steps and timing should be confirmed with EEC.

    Construction approach and schedule

    The conversion is interior work on an existing shell: classroom walls, child-height fixtures and diapering stations, a kitchen, HVAC upgrades, a fire alarm and sprinklers if the building official requires them.

    PhaseMonths from contractKey outputs
    Due diligence0 to 3Phase I, lead and water testing plan, zoning confirmation, EEC pre-licensing consultation, design concept, contractor pricing
    Acquisition closing3Bank interim loan funds purchase; 504 authorization issued
    Design and permits3 to 5Construction documents, building permit, site plan approval if required
    Construction4 to 12Nine-month conversion and site work
    Inspections and licensing11 to 12Certificate of inspection, fire sign-off, EEC licensing visit
    Staff hiring and pre-enrollment9 to 12Director and lead teachers hired; deposits from first families
    Opening (start of Year 1)13Operations begin
    504 debenture funding14 to 15Debenture sale takes out the 504 share of the interim loan

    The schedule is a model assumption. The model capitalizes nine months of interim interest in the project budget. Any delay in licensing extends that carry and pushes opening into a less favorable enrollment month. A September opening fits the enrollment cycle best.

    Development budget

    Development budget

    LineAmountPer licensed slotShare
    Building and land acquisition (11,500 sq ft, about 1.3 acres)$2,600,000$21,66744.1%
    Acquisition closing costs$40,000$3330.7%
    Interior conversion, $175 per sq ft$2,012,500$16,77134.1%
    Site work, fenced play yards, drop-off loop$340,000$2,8335.8%
    Furniture, fixtures and equipment ($1,800 per slot)$216,000$1,8003.7%
    Architecture, engineering, permits, legal, appraisal, environmental and lead testing$255,000$2,1254.3%
    Hard cost contingency (10% of conversion and site work)$235,250$1,9604.0%
    Interim construction interest and fees$200,000$1,6673.4%
    Total project cost$5,898,750$49,156100.0%

    All budget lines are assumptions; the land, building and conversion prices need an appraisal of the actual site and a contractor's guaranteed maximum price. The $175 per sq ft conversion cost assumes a sound shell and roof, and the 10% contingency reflects the hidden conditions typical of older buildings.

    Sources and uses

    SourceAmountShare of project
    Owner equity (cash injection)$1,179,75020.0%
    Bank first mortgage$2,949,37550.0%
    SBA 504 debenture, net proceeds$1,769,62530.0%
    Total sources$5,898,750100.0%
    Capital held outside the 504 projectAmountFunded by
    Pre-opening costs (hiring and training two months before opening, marketing, licensing, initial supplies)$185,000Owner cash
    Operating and debt service reserve (pledged account)$525,000Owner cash
    504 project (from the table above)$5,898,750Equity, bank and 504
    Total capital$6,608,750Owner cash $1,889,750 (28.6%)

    All rows are model results.

    The 504 program finances fixed assets, so working capital and start-up losses sit outside the project. The $525,000 reserve is sized to the Year 1 shortfall after debt service of $497,040 plus the $12,420 needed to lift Year 2 coverage from 1.12x to 1.15x, rounded up. The owner therefore needs about $1.89 million of cash before opening. That figure, not the 20% injection, is the real equity test in this file.

    The 504 debenture's administrative costs are financed: the $1,769,625 net debenture grosses up to $1,822,000 after the CDC processing fee, SBA guaranty and funding fees, closing and legal costs, and the fee for selling the debenture, rounded up under the SOP's procedure [2]. Exact fee amounts should be confirmed against the CDC's fee schedule.

    Revenue build and operating expenses

    Assumptions

    AssumptionValueRationale
    Monthly tuition, 2027Infant $2,850; toddler $2,600; preschool $1,975Reflects Middlesex incomes [6]; infant below and preschool above the 2024 Metro cost of care [4]; to be tested by a local tuition study
    Tuition growth3.5% a yearBelow the 14% to 26% two-year cost rise found for 2022 to 2024 [4], so a modest real price increase only
    Occupancy ramp55%, 84%, 91%, then 92%New center opening with pre-enrollment; 92% allows for transitions and age-group mismatch
    Discounts and bad debt3.0% of gross tuitionAssumption; sibling and staff discounts
    CCFA mix and rate gap12% of enrollment at 7% below private tuitionAssumption; voucher access to be confirmed with EEC
    C3 operating grantNoneConservative assumption; eligibility of a new center not confirmed
    Registration fees$125 per enrolled child a yearAssumption
    Classroom wages, 2027Lead $24.00; teacher $21.50; assistant $19.00 per hourIllustrative assumption
    Support salaries, 2027Director $92,000; assistant director $64,000; office $48,000; cook $45,760; part-time custodian $24,960Illustrative assumption; director set at a market salary for a 120-slot center
    Wage growth4.0% a yearAbove tuition growth to reflect rising child care payroll per employee [8], [7]
    Payroll taxes and benefits22% of wagesAssumption: employer taxes, workers' compensation, paid leave contributions and partial health coverage
    Classroom staffing curve70% of full staffing at 55% occupancy, 93% at 84%, 100% at 92%Rooms open ahead of enrollment; ratios cannot flex below a full room's needs
    Food and supplies$5.25 per child-day for 250 days; $450 per child a yearAssumption; no federal food program reimbursement assumed
    Property tax$66,000 in Year 1 ($16.50 per $1,000 on $4.0 million)Assumption; commercial rates vary by town
    Other operating costsUtilities $3.25 and repairs $1.50 per sq ft; insurance $42,000; cleaning $30,000Assumption
    Bank loan7.50% fixed, 25-year amortization, 10-year termAssumption; Prime 7.00% and 10-year Treasury 4.88% on November 9, 2026 [13]
    504 debenture6.75% effective, 25 yearsAssumption; debentures are usually benchmarked to the 10-year Treasury [2], [13]; includes ongoing fees
    Exit11.5% capitalization rate on Year 11 EBITDA, 3% sale costsCombined real estate and operating business; about 8.7x EBITDA
    Trade area4.0% of county children under 5; 45% center-care use; 1,000 existing center slotsAssumptions pending an EEC capacity count

    Revenue build

    YearOccupancyEnrolled FTEGross tuitionDiscounts and bad debtCCFA rate gapRegistration feesNet revenue
    155%66.0$1,756,425-$52,693-$14,754$8,250$1,697,228
    284%100.8$2,776,429-$83,293-$23,322$12,978$2,682,792
    391%109.2$3,113,071-$93,392-$26,150$14,481$3,008,010
    492%110.4$3,257,435-$97,723-$27,362$15,080$3,147,429
    592%110.4$3,371,446-$101,143-$28,320$15,532$3,257,514
    692%110.4$3,489,446-$104,683-$29,311$15,998$3,371,449
    792%110.4$3,611,577-$108,347-$30,337$16,478$3,489,370
    892%110.4$3,737,982-$112,139-$31,399$16,972$3,611,416
    992%110.4$3,868,811-$116,064-$32,498$17,481$3,737,730
    1092%110.4$4,004,220-$120,127-$33,635$18,006$3,868,464

    All rows are model results.

    Gross potential tuition at 100% occupancy is $3,193,500 in Year 1. In Year 4 the center earns $28,509 of net revenue per enrolled child. By age, Year 4 enrollment is about 12.9 infants, 24.8 toddlers and 72.7 preschoolers.

    Staffing and wages

    RoleFTEHourlyAnnual
    Lead teachers (one per room)9$24.00$449,280
    Teachers (second educator per room)9$21.50$402,480
    Assistants and floaters (open, close, breaks, absence)6$19.00$237,120
    Director (owner-operator, market salary)1salaried$92,000
    Assistant director and education coordinator1salaried$64,000
    Enrollment and office administrator1salaried$48,000
    Cook1salaried$45,760
    Custodian (part time)0.5salaried$24,960
    Total28.5$1,363,600

    All rows are model assumptions.

    Massachusetts law treats a wage of less than $15.00 an hour as oppressive and unreasonable [14]. The modelled lead teacher rate of $24.00 is an illustrative assumption, set high enough for a new center to hire certified lead teachers away from established programs. The weighted classroom rate is $21.81 an hour.

    The owner is modelled as the director at a market salary of $92,000, so the projections show what a replacement director would cost.

    Wages are the margin. Personnel costs fall from 74.4% of revenue in Year 1 to 59.4% in Year 4, and drift back up to 61.2% by Year 10 because wages grow at 4.0% against tuition at 3.5%. A market-wide wage step would be faster; that is Scenario B.

    Stabilized expense structure, Year 4

    LineAmountShare of revenuePer enrolled child
    Classroom wages$1,224,59738.9%$11,092
    Support wages$309,0239.8%$2,799
    Taxes and benefits$337,39610.7%$3,056
    Food$158,3365.0%$1,434
    Supplies$54,2871.7%$492
    Occupancy costs (excluding debt)$138,3674.4%$1,253
    Property tax$71,0752.3%$644
    Administration$165,8805.3%$1,503
    Replacement reserve$32,7821.0%$297
    Total operating expenses$2,491,74279.2%$22,570
    EBITDA$655,68820.8%$5,939
    Debt service$412,60813.1%$3,737

    All rows are model results.

    Debt service is 13.1% of stabilized revenue. For an owner-occupied center that is the equivalent of rent, and it sits in the range a leased center would pay for occupancy.

    10-year pro forma

    LineY1Y2Y3Y4Y5Y6Y7Y8Y9Y10
    Net revenue1,697,2282,682,7923,008,0103,147,4293,257,5143,371,4493,489,3703,611,4163,737,7303,868,464
    Classroom wages760,3101,058,3741,167,8991,224,5971,273,5811,324,5241,377,5051,432,6051,489,9091,549,506
    Director, office, kitchen, custodial wages274,720285,709297,137309,023321,384334,239347,608361,513375,973391,012
    Payroll taxes and benefits227,707295,698322,308337,396350,892364,928379,525394,706410,494426,914
    Total personnel1,262,7371,639,7811,787,3441,871,0161,945,8572,023,6912,104,6382,188,8242,276,3772,367,432
    Food86,625136,269152,053158,336163,086167,979173,018178,209183,555189,062
    Classroom supplies29,70046,72152,13354,28755,91557,59359,32161,10062,93364,821
    Utilities, repairs, cleaning, insurance126,625130,424134,336138,367142,518146,793151,197155,733160,405165,217
    Property tax66,00067,65069,34171,07572,85274,67376,54078,45380,41582,425
    Administration, marketing, payment processing179,972168,968160,571165,880171,013176,305181,762187,389193,190199,172
    Replacement reserve30,00030,90031,82732,78233,76534,77835,82236,89638,00339,143
    Total operating expenses1,781,6592,220,7122,387,6052,491,7422,585,0052,681,8122,782,2972,886,6042,994,8783,107,272
    EBITDA (cash flow available for debt service)-84,431462,080620,405655,688672,509689,638707,073724,812742,853761,192
    Bank debt service261,547261,547261,547261,547261,547261,547261,547261,547261,547261,547
    504 debt service151,061151,061151,061151,061151,061151,061151,061151,061151,061151,061
    Total debt service412,608412,608412,608412,608412,608412,608412,608412,608412,608412,608
    Cash flow after debt service-497,04049,471207,797243,079259,900277,029294,464312,204330,244348,584
    DSCR-0.20x1.12x1.50x1.59x1.63x1.67x1.71x1.76x1.80x1.84x

    All rows are model results in dollars. EBITDA is before owner distributions and income taxes; a global cash flow analysis must also cover the owner's personal taxes and debts.

    Debt structure

    TrancheAmountShare of projectRateTerm and amortizationAnnual debt service
    Bank first mortgage$2,949,37550.0%7.50% fixed (assumption)10-year term, 25-year amortization; balloon or reset at Year 10$261,547
    SBA 504 debenture (gross, incl. fees)$1,822,00030.0% net6.75% effective (assumption)25-year, fully amortizing$151,061
    Owner equity$1,179,75020.0%n/an/an/a
    Total$5,898,750100.0%$412,608

    All rows are model results on assumed rates.

    The structure follows the 504 pattern for a project that is a new business and may be a limited or special purpose property: at least 20% from the borrower, no more than 30% from the debenture and at least 50% from the third-party lender [2], [1]. If the CDC concludes that the building is not limited or special purpose, the new-business rule alone sets the floor at 15%, and the debenture may rise to 35% [2], [1]. Under that alternative, modelled equity falls to $886,762, the gross debenture rises to $2,130,000, debt service rises to $438,721 and coverage falls to 1.05x in Year 2 and 1.49x in Year 4. The 20% version is the better credit, and the difference in owner cash is about $293,000.

    The bank loan needs a term of at least 10 years when paired with a 20- or 25-year debenture [2]. The 504 rate is set at debenture sale, most commonly benchmarked to the 10-year Treasury [2], which stood at 4.88% on November 9, 2026 [13]. Neither modelled rate is a quote. During construction the bank's interim loan carries the whole debt; the debenture takes out the 504 share after completion. By Year 10 the 504 balance falls to $1,422,565.

    At Year 10 the bank balance is $2,351,168, which must be refinanced or reset. With Year 10 EBITDA of $761,192, the refinancing risk is modest, but it is real if rates are higher then.

    DSCR and break-even

    YearEBITDADebt serviceDSCRCash after debt serviceReserve balance at year end
    1-$84,431$412,608-0.20x-$497,040$27,960
    2$462,080$412,6081.12x$49,471$27,960
    3$620,405$412,6081.50x$207,797$27,960
    4$655,688$412,6081.59x$243,079$27,960
    5$672,509$412,6081.63x$259,900$27,960
    10$761,192$412,6081.84x$348,584$27,960

    All rows are model results.

    SBA's 504 standard is a debt service coverage ratio of at least 1.15, measured as EBITDA over combined debt service after the transaction [2]. For a projection-based project the CDC must analyze at least two years of projections, justify the assumptions, and, if repayment appears in Year 2 but not Year 1, show liquidity sufficient to cover the Year 1 shortfall [2]. This model passes the liquidity test with the reserve, reaches repayment in Year 2 at 1.12x, and clears 1.15x from Year 3. A credit officer will read the Year 2 figure as the weak point. The $525,000 reserve covers the Year 1 shortfall plus the $12,420 gap to 1.15x in Year 2.

    Break-even measure, Year 4OccupancyEnrolled FTE childrenCushion below base
    DSCR 1.00x79.5%95.412.5 points (15 children)
    DSCR 1.15x82.7%99.29.3 points (11 children)
    DSCR 1.25x84.8%101.77.2 points (9 children)

    All rows are model results.

    The break-even figures include the staffing curve: as enrollment falls, the model reduces classroom staff, but not in proportion, because rooms cannot run below ratio. Each point of occupancy is worth about 0.05x of coverage. At stabilization, debt service is covered at 1.00x with 95 children, which leaves a cushion of about 15 enrolled children. For a center that loses a third of its preschoolers to kindergarten every September, that cushion has to be rebuilt each autumn.

    Returns

    MeasureValue
    Unlevered investment (project plus pre-opening costs)$6,083,750
    Equity investment at closing (injection plus pre-opening costs)$1,364,750
    Exit value at end of Year 10 (Year 11 EBITDA of $779,825 at 11.5%)$6,781,090
    Net sale proceeds after 3% costs$6,577,657
    Loan balances repaid at exit (bank $2,351,168; 504 $1,422,565)$3,773,733
    Unlevered IRR9.5%
    Levered IRR13.7%
    Equity multiple3.39x
    Payback of equity from cash after debt service8.7 years
    Debt yield, Year 4 (EBITDA over total debt of $4,771,375)13.7%
    Loan-to-cost including financed 504 fees80.9%

    All rows are model results.

    The levered return counts the Year 1 shortfall of $497,040 as owner cash. A 9.5% unlevered return is thin for a start-up; the levered return works because 504 financing is long and fixed, and the owner's market salary is already in expenses.

    The exit value, about 8.7 times EBITDA for business and real estate together, is the most uncertain line; a lender should treat it only as evidence that collateral holds value if the business performs.

    Collateral is the other lens. At an income value of Year 4 EBITDA capitalized at 11.5%, the stabilized going-concern value is about $5.70 million, which puts total debt at about 84% of that value. An appraisal of the real estate alone, before the business is proven, may come in below cost. Child care conversions add value for child care use only, and where the collateral is special purpose property the appraiser must be experienced in the industry [2].

    Sensitivity and stress tests

    Grid A: Year 4 DSCR, tuition level against stabilized occupancy

    Tuition vs base80%84%88%92%96%
    -10%0.37x0.53x0.68x0.84x1.11x
    -5%0.70x0.87x1.04x1.21x1.50x
    +0%1.03x1.21x1.40x1.59x1.89x
    +5%1.35x1.56x1.76x1.96x2.29x

    Model results.

    Grid B: Year 4 DSCR, wage level against bank rate

    Wage level vs base6.50%7.50%8.50%9.50%
    -5%1.92x1.82x1.72x1.63x
    +0%1.68x1.59x1.50x1.42x
    +5%1.44x1.36x1.29x1.22x
    +10%1.20x1.14x1.07x1.02x

    Model results.

    The grids rank the risks. Price moves coverage fastest: 5% of tuition is worth about 0.37x, because tuition falls straight through to EBITDA. Occupancy is next, at about 0.05x a point. Wages follow: 10% higher wages cut Year 4 coverage from 1.59x to 1.14x. The bank rate matters least; a full two points of rate costs about 0.17x, because only half of the capital stack floats with the bank's pricing and the 504 rate is fixed at sale.

    Downside scenarios

    ScenarioY2 DSCRY3 DSCRY4 DSCRLowest Y4 to Y10Cash shortfall after debt service, Y1 to Y3
    Base case1.12x1.50x1.59x1.59x$497,040
    A. Slow ramp: 45%, 68%, 80%, then 86%0.41x1.00x1.31x1.31x$914,538
    B. Wage shock: wages 8% higher from Year 3, no tuition response1.12x1.16x1.23x1.23x$497,040
    C. Public pre-K: preschool enrollment 20 points lower from Year 41.12x1.50x1.09x1.09x$497,040
    D. Price resistance: tuition 7% lower, growth 2.5%0.61x0.87x0.86x0.48x$826,039
    E. Combined: 88% occupancy, wages +4%, tuition -3%0.69x0.99x1.01x1.01x$731,277

    All rows are model results.

    Scenario A is the most likely way the file goes wrong. A slower ramp consumes $914,538 in three years, $389,538 more than the reserve, yet the center still reaches 1.31x at 86%. That is a liquidity failure, not a viability failure, so owner liquidity beyond the reserve matters.

    Scenario B shows the wage risk. An 8% market-wide wage step from Year 3, with no tuition response, takes coverage to 1.16x in Year 3 and 1.23x in Year 4. The center still pays its debt, but with little room.

    Scenario C models a town-level public pre-K program, of the kind Cambridge already runs [9], removing 20 points of preschool enrollment from Year 4. Coverage falls to 1.09x. Because preschool carries the margin, losing 15 preschoolers does more damage than losing the same number of toddlers.

    Scenario D is the one the structure cannot absorb. If the market will not pay the modelled premium, and tuition is 7% lower and grows only 2.5% a year, coverage never reaches 1.00x and declines over time as wages outgrow tuition. The tuition study for the real trade area is therefore the single most important piece of due diligence.

    Scenario E combines three moderate risks and lands at 1.01x: the project has room for one problem at a time.

    Program compliance

    RequirementRuleModelled position
    For-profit applicantNon-profit businesses are not eligible; for-profit subsidiaries of non-profits may be [2]For-profit operating company: meets
    SizeNAICS 624410 Child Care Services: $9.5 million in receipts [15]$3.1 million stabilized revenue: meets, subject to affiliates
    Occupancy, existing buildingOccupy at least 51% of rentable property; lease up to 49% [1], [2]100% occupied by the operating company: meets
    Borrower contributionAt least 15% for a new business or for a limited or single purpose building; 20% if both [1], [2]20.0% cash: meets under either classification
    Special purpose determinationCDC must address it in the credit memorandum; child care is not on the SOP's example list, which is not all-inclusive [2]Open question; structured to the stricter answer
    Funding sharesDebenture no more than 30% and third party at least 50% when the borrower contributes 20% [2]30% and 50%: meets
    Third-party loan termAt least 10 years for a 20- or 25-year debenture [2]10-year term, 25-year amortization: meets
    Debenture limit$5,000,000 outstanding per borrower and affiliates [1]$1,822,000 gross: meets
    Job opportunitiesOne job per $95,000 guaranteed by SBA; a job opportunity is created within two years of receipt of 504 funds [2]20 needed; about 28.5 FTE created: meets
    MaturityUp to 25 years for real estate [2]25-year debenture
    Debt service coverageAt least 1.15; projections of at least two years; Year 1 shortfall covered by liquidity [2]1.12x in Year 2 and 1.50x in Year 3; $525,000 reserve: conditional
    Personal guarantiesEvery individual owning 20% or more provides an unlimited full guaranty [2]Condition of approval
    Child-occupied facilityPre-1978 buildings need a lead risk assessment and lead testing at taps children may use [2]Budgeted; condition before disbursement
    Credit standardLoans must be so sound as to reasonably assure repayment (13 CFR 120.150) [1]Supported at stabilization; ramp risk mitigated by reserve
    SOP versionSOP 50 10 8.1 applies to applications issued an SBA loan number on or after October 1, 2026 [16]Applies

    Risks and mitigants

    RiskWhy it mattersMitigant a lender would look for
    Slow enrollment rampScenario A needs $914,538 of cash in three yearsPre-opening deposits from at least 40 families; reserve of $525,000; owner liquidity beyond the reserve
    Tuition premium not supportedA 5% price shortfall cuts coverage by about 0.37xIndependent tuition survey of licensed centers in the trade area before approval
    Educator shortageA room cannot open without qualified staff in ratioLead teachers hired before opening; wage plan set to compete with established programs
    Wage inflation10% higher wages take Year 4 coverage to 1.14xAnnual tuition reviews; covenant to report staff turnover and vacancies
    No C3 grantEligibility of a new center not confirmedBase case excludes C3; any future grant is upside
    Subsidy accessLower-income families cannot enroll without vouchersPrivate-pay model; subsidy only 12% of enrollment
    Public pre-K expansionFree preschool removes the margin-carrying rooms [9]Site in a town without universal pre-K; ability to convert a preschool room to toddler
    Licensing or safety eventEEC action or a serious incident can close rooms or the centerExperienced director, documented policies, abuse and molestation insurance
    Collateral shortfallConversion improvements add value only for child care use20% equity; full guaranties; a lien on other owner real estate where available
    Construction overrunOlder shells hide conditions10% contingency; guaranteed maximum price contract; Phase I and lead testing before closing
    Key personOwner-operator is director and guarantorLife and disability insurance assigned to the lender; named assistant director
    Year 10 balloon$2,351,168 bank balance to refinanceYear 10 coverage of 1.84x; 504 portion fully amortizing

    Model determination

    The modelled project is financeable under SBA 504 as structured, but only with conditions, and the conditions are the substance of the credit. At stabilization the center covers debt service 1.59x, earns a 20.8% EBITDA margin and needs only 95 enrolled children to cover its debt. The demand base is deep: 75,935 Middlesex children under 6 live in homes where every parent works [6], and the 504 structure keeps debt service near 13% of revenue. The weaknesses are timing and price. Year 2 coverage of 1.12x sits below the SBA 1.15 standard [2], the model gives the new center none of the state operating grant its competitors may receive, and the base case depends on tuition more than twice the national average for center infant care [3].

    A lender would likely set these conditions:

    1. An owner cash injection of at least 20% of project cost, regardless of the special purpose conclusion, plus $185,000 of pre-opening funds.
    2. A pledged operating and debt service reserve of at least $525,000, released only after two consecutive quarters at 1.15x coverage.
    3. Evidence of pre-opening enrollment, such as deposits from at least 40 families, before the interim loan funds construction.
    4. A third-party tuition and capacity study of licensed centers within the trade area, confirming prices within 5% of the model and center capacity for children under 5.
    5. A guaranteed maximum price construction contract, a completed Phase I, and lead testing where required, before closing.
    6. Unlimited personal guaranties from every 20% owner [2], with life and disability insurance assigned.
    7. Quarterly enrollment, staffing and financial reporting, with a 1.15x coverage covenant tested annually from Year 3.
    8. A written plan from the operator for converting rooms between age groups if preschool demand falls.

    If the tuition study shows prices 5% or more below the model, the file should be restructured with more equity or fewer infant rooms before it goes forward.

    Frequently Asked Questions

    Is a child care center a special purpose property under SBA 504?
    Not automatically. SOP 50 10 8.1 lists examples of limited or special purpose properties, such as hotels, car washes and nursing homes, and child care centers are not on it. The list is not all-inclusive, and the CDC must state its conclusion and reasons in the credit memorandum. A converted commercial shell may not qualify, while a purpose-built center might. This model funds 20% equity so the answer does not change the structure.
    How much equity does an owner need for a new child care center under 504?
    At least 15%, or 20% if the property is also limited or special purpose. In this model the 20% injection is $1,179,750, but the owner also funds $185,000 of pre-opening costs and a $525,000 ramp reserve outside the 504 project. Total owner cash is about $1.89 million, or 28.6% of total capital. Lenders should test that full amount, not just the injection.
    How does the model staff its classrooms?
    With two educators in ratio in each of nine rooms, 18 in all, plus six assistants and floaters for opening, closing, breaks and absences. The plan assumes ratios of 1:3 for infants, 1:4 for toddlers and 1:10 for preschoolers, with groups of 7, 9 and 20. Those ratios are model assumptions to confirm against Massachusetts licensing rules with EEC. They set the minimum classroom payroll and explain why infant rooms earn less per educator than preschool rooms.
    Why does the model assume no C3 grant revenue?
    Because a new center's access to the grant could not be confirmed. The FY 2027 budget provides $475 million for operational grants to child care providers, but this model study could not reach EEC's pages on which programs qualify. A center opening in 2027 should not count on the grant. If EEC makes it available, it would improve coverage, but a lender should not rely on it.
    Can a Massachusetts town block a child care center through zoning?
    No. Under Chapter 40A, section 3, a city or town may not prohibit a child care facility or require a special permit for one. It can still apply reasonable rules on building bulk and height, yard sizes, setbacks, lot area, open space, parking and building coverage. The center must also meet the state building code and fire code and obtain an EEC license, which together drive cost and schedule.
    What occupancy does the center need to cover its debt?
    About 79.5% in Year 4. At that level, about 95 full-time-equivalent children, the center covers debt service at 1.00x. It needs 82.7%, about 99 children, for the SBA standard of 1.15x. The base case assumes 92%, so the cushion is about 15 children. Because preschoolers leave for kindergarten each year, that cushion must be rebuilt every autumn.
    How sensitive is the deal to wages?
    Very. Personnel costs are 59.4% of stabilized revenue. Each 1% change in wages moves Year 4 coverage by about 0.045x, and wages 10% above plan take coverage from 1.59x to 1.14x. The modelled lead teacher rate of $24.00 an hour is an illustrative assumption set to hire certified staff away from established centers.
    What is the biggest risk in this file?
    Price. A 7% tuition shortfall with slower price growth keeps coverage below 1.00x for the whole forecast, a risk the reserve cannot cure. The modelled infant price is more than twice the 2025 national average for center infant care. An independent tuition and capacity study of the actual trade area is the most important condition a lender would set before approval.

    Sources

    1. 1.U.S. Government Publishing Office, GovInfo. Code of Federal Regulations, Title 13, Part 120, Business Loans (revised as of January 1, 2026). https://www.govinfo.gov/content/pkg/CFR-2026-title13-vol1/xml/CFR-2026-title13-vol1-part120.xml (accessed 2026-11-11)
    2. 2.U.S. Small Business Administration. SOP 50 10 8.1, "Lender and Development Company Loan Programs" (effective October 1, 2026). https://www.sba.gov/document/sop-50-10-lender-development-company-loan-programs (accessed 2026-11-11)
    3. 3.Child Care Aware of America. "Child Care in America: 2025 Price and Supply" (published May 2026). https://info.childcareaware.org/price-and-supply-2025 (accessed 2026-11-11)
    4. 4.American Institutes for Research, for the Massachusetts Department of Early Education and Care. "Massachusetts Child Care Cost Models: Report on 2024 Cost Research and Cost Model Updates" (March 2025). https://www.air.org/sites/default/files/2025-05/MA-EEC-Phase1-Cost-Model-March-2025.pdf (accessed 2026-11-11)
    5. 5.U.S. Census Bureau. "County Population Totals and Components of Change: April 1, 2020 to July 1, 2025" (Vintage 2025, co-est2025-alldata.csv). https://www2.census.gov/programs-surveys/popest/datasets/2020-2025/counties/totals/co-est2025-alldata.csv (accessed 2026-11-11)
    6. 6.U.S. Census Bureau. American Community Survey 2025 1-year estimates, table-based summary file, tables B01001, B09001, B19013, B19126 and B23008. https://www2.census.gov/programs-surveys/acs/summary_file/2025/table-based-SF/data/1YRData/ (accessed 2026-11-11)
    7. 7.U.S. Census Bureau. "County Business Patterns 2023," county file (cbp23co.zip). https://www2.census.gov/programs-surveys/cbp/datasets/2023/cbp23co.zip (accessed 2026-11-11)
    8. 8.U.S. Census Bureau. "County Business Patterns 2019," county file (cbp19co.zip). https://www2.census.gov/programs-surveys/cbp/datasets/2019/cbp19co.zip (accessed 2026-11-11)
    9. 9.City of Cambridge, Department of Human Service Programs. "Cambridge Preschool Program to Accept Additional Applications for 2026-2027 School Year." https://www.cambridgema.gov/departments/humanserviceprograms/news/2026/02/cppspringenrollment2026 (accessed 2026-11-11)
    10. 10.Massachusetts Legislature. FY 2027 Final Budget (Acts of 2026, Chapter 137), line item 3000-1045. https://malegislature.gov/Budget/FY2027/FinalBudget (accessed 2026-11-11)
    11. 11.Massachusetts Senate Committee on Ways and Means. FY 2027 Budget, Executive Summary. https://malegislature.gov/Budget/FY2027/SenateWaysMeansBudget/Executive_Summary (accessed 2026-11-11)
    12. 12.Massachusetts General Laws, Chapter 40A, Section 3. https://malegislature.gov/Laws/GeneralLaws/PartI/TitleVII/Chapter40A/Section3 (accessed 2026-11-11)
    13. 13.Board of Governors of the Federal Reserve System. "H.15 Selected Interest Rates (Daily)," release of November 10, 2026. https://www.federalreserve.gov/releases/h15/ (accessed 2026-11-11)
    14. 14.Massachusetts General Laws, Chapter 151, Section 1. https://malegislature.gov/Laws/GeneralLaws/PartI/TitleXXI/Chapter151/Section1 (accessed 2026-11-11)
    15. 15.U.S. Government Publishing Office, GovInfo. 13 CFR 121.201, size standards by NAICS industry (revised as of January 1, 2026). https://www.govinfo.gov/content/pkg/CFR-2026-title13-vol1/xml/CFR-2026-title13-vol1-sec121-201.xml (accessed 2026-11-11)
    16. 16.U.S. Small Business Administration. Information Notice 5000-880695, "Issuance of SOP 50 10 8.1" (published August 14, 2026; effective October 1, 2026). https://www.sba.gov/document/sop-50-10-lender-development-company-loan-programs (accessed 2026-11-11)