Neighborhood grocery store profitability: margin, stock and cash
Illustrative case · Independent small general-assortment grocery store in leased former food-retail premises; no fuel, pharmacy, liquor or food preparation · United States; Sacramento County, California regulatory reference; hypothetical January 2027 opening
Explore this business · Profitability and payback
The base case earns $135,908 first-year EBITDA after paid owner work and $95,514 pre-income-tax profit after depreciation and interest. Cash generated after debt and working-capital changes is $121,829. The lower case instead reports −$156,364 pre-income-tax profit and requires $126,779 additional funding. These are conditional model outputs; revenue depends on an unproven transaction and basket hypothesis.
Sales come from transactions and department baskets
At a normalized 30-day mature month the case requests 260 transactions per day at $26.00 net sales each, producing $202,800. The model uses actual calendar days, a January 2027 opening, an explicit first-year ramp and department mix. The base ramp starts at 0.5 of mature traffic and reaches full level in the last two opening-year months. Seasonal factors and annual price/volume growth are assumptions, not measured Sacramento trading patterns.
The same shopper can buy across several departments, so department mix allocates basket revenue rather than adding five separate customers. Full trading capacity does not establish demand. Daily volume is capped by paid task hours, total checkout availability and a separate peak window. Revenue above a cap is retained as unserved demand, not silently recognized. Model assumptions.
Keep product margin and company profit separate
| Measure | Case value | Definition |
|---|---|---|
| Net sales | $202,800 | Customer basket excluding sales tax |
| Gross profit | $56,987 | Sales less cost of sold stock and separate cost-valued write-offs |
| Basket contribution | $6.62 | Gross basket less blended payment fees and packaging; payroll not deducted here |
| Department contribution total | $51,647 | Sales less product costs, losses, fees and packaging |
| Paid payroll including owner and burden | $20,754 | Calendar-hours baseline; extra shift steps excluded from this normalized example |
| Recurring fixed expenses | $9,890 | Occupancy, power, upkeep, insurance and administrative budgets |
| EBITDA | $21,003 | Contribution less payroll and recurring fixed expenses |
| Scheduled debt payment | $2,812 | Interest plus principal; principal is not an income expense |
The weighted cost of products actually sold is 70.5% of net sales; write-offs add 1.4% on the same sales basis. The loss rate is a cost-valued expense, not missing retail revenue or a percentage of purchased units. Higher losses require more purchases to keep the same stock target. That double effect is visible in inventory and cash, rather than hiding losses inside a margin line.
Refrigeration electricity is $600 per month in the starting case, separate from other utilities and maintenance. It is a budget hypothesis. Measure actual bills or equipment kWh, tariff, ambient conditions and opening hours. ENERGY STAR’s grocery guidance supports attention to refrigeration upkeep, not this store’s bill or a guaranteed saving. Energy evidence scope.
Read the downside before relying on the base
| Scenario | Net sales | EBITDA | Net income | Cash change | Minimum cash over 60 months |
|---|---|---|---|---|---|
| Lower | $1,129,421 | −$115,970 | −$156,364 | −$138,331 | −$126,779 |
| Base | $1,987,382 | $135,908 | $95,514 | $121,829 | $67,308 |
| Higher | $2,599,183 | $281,012 | $240,618 | $283,636 | $70,000 |
Lower traffic is 0.72x of base maturity, baskets are 0.95x of base, the ramp is slower, purchase cost ratios rise by 2.0 percentage points, cost-valued loss rates rise to 1.50x of base and refrigeration energy to 1.35x of base. Supplier credit is unavailable. Funding, owner salary and the other initial operating inputs remain the same.
Higher traffic is 1.20x of base and baskets 1.03x of base, with faster ramp, modest purchase-cost improvement and lower losses. It assumes 21-day terms on eligible purchases after the initial cash-on-delivery period. Extra paid clerk shifts and second-lane coverage turn on as demand crosses the stated thresholds; higher sales are not treated as free labor. The higher result is a scenario, not a promised return.
| Model year | Net sales | EBITDA | Net income | Cash change after debt/WC | Closing cash |
|---|---|---|---|---|---|
| 1 | $1,987,382 | $135,908 | $95,514 | $121,829 | $191,829 |
| 2 | $2,574,819 | $272,191 | $233,171 | $236,576 | $428,405 |
| 3 | $2,672,110 | $284,305 | $246,825 | $248,615 | $677,020 |
| 4 | $2,776,814 | $295,215 | $259,461 | $259,814 | $936,833 |
| 5 | $2,880,471 | $300,871 | $267,054 | $265,950 | $1,202,783 |
Recovery depends on the cash definition
Project recovery is first reached in base month 20 when cumulative unlevered operating cash, after inventory, supplier and card timing, covers $314,750 of opening funding including reserve. Equity recovery first occurs in month 12 when cumulative cash after debt covers $114,750 initial equity. Opening reserve itself is not counted as a new operating receipt; no sale value or recovered deposit is added at the horizon. These two measures answer different questions.
The lower case reaches neither recovery measure during 60 months. Negative cash represents obligations that the stated funding cannot pay, not a preapproved overdraft. EBITDA/debt service is 4.03x in base Year 1; the cash-available/debt-service ratio is 4.61x. Neither is a lender’s prescribed coverage test. Supplier terms and inventory releases can temporarily improve cash coverage without improving trading economics. Linked-statement preparation.
Pay the work before estimating distributions
The owner is budgeted $5,000 per month, $60,000 initially per year, for 40 paid weekly hours. Only 24 hours enter the productive store-hours pool; the remainder covers buying, accounts and management. This is economic paid-work treatment. Confirm the legal entity and tax/payroll arrangement before using it as actual bookkeeping. The projected company cash is retained rather than distributed on top of salary.
Clerks are budgeted $19.00 per hour and the lead $22.00, above the observed 2026 California state floor of $16.90. A future January 2027 opening requires updated local/state terms. The modeled 16.0% loading includes more than federal payroll taxes and needs actual UI, workers-compensation and benefit costs. Historical BLS metro wage context does not verify these hiring budgets. DIR; Employer tax components; Wage scope.
Track department write-offs, labor hours, inventory at cost and unrestricted cash each month. If net sales miss the plan, reduce or redesign purchasing while keeping enough paid coverage and food safety controls. Concealing owner work or postponing due supplier bills can create a positive-looking profit without a viable business.
Compare the monthly cash path
| Month | Base | Lower | Higher |
|---|---|---|---|
| 1 | $79,201 | $67,050 | $84,634 |
| 2 | $70,762 | $47,716 | $85,034 |
| 3 | $67,308 | $28,952 | $90,080 |
| 4 | $90,100 | $12,183 | $161,184 |
| 5 | $93,575 | −$2,802 | $182,974 |
| 6 | $99,683 | −$16,029 | $205,022 |
| 7 | $109,634 | −$27,569 | $229,191 |
| 8 | $122,218 | −$37,864 | $254,648 |
| 9 | $135,692 | −$47,538 | $278,685 |
| 10 | $152,421 | −$55,677 | $304,142 |
| 11 | $170,594 | −$62,845 | $328,179 |
| 12 | $191,829 | −$68,331 | $353,636 |
Read all sixty monthly balances
| Month | Base | Lower | Higher |
|---|---|---|---|
| 1 | $79,201 | $67,050 | $84,634 |
| 2 | $70,762 | $47,716 | $85,034 |
| 3 | $67,308 | $28,952 | $90,080 |
| 4 | $90,100 | $12,183 | $161,184 |
| 5 | $93,575 | −$2,802 | $182,974 |
| 6 | $99,683 | −$16,029 | $205,022 |
| 7 | $109,634 | −$27,569 | $229,191 |
| 8 | $122,218 | −$37,864 | $254,648 |
| 9 | $135,692 | −$47,538 | $278,685 |
| 10 | $152,421 | −$55,677 | $304,142 |
| 11 | $170,594 | −$62,845 | $328,179 |
| 12 | $191,829 | −$68,331 | $353,636 |
| 13 | $210,946 | −$72,424 | $381,439 |
| 14 | $227,193 | −$76,256 | $405,450 |
| 15 | $245,704 | −$81,268 | $431,150 |
| 16 | $263,365 | −$84,081 | $455,408 |
| 17 | $283,599 | −$85,263 | $481,108 |
| 18 | $303,578 | −$87,419 | $505,365 |
| 19 | $324,923 | −$87,923 | $531,066 |
| 20 | $346,388 | −$88,240 | $556,766 |
| 21 | $365,923 | −$89,280 | $581,023 |
| 22 | $386,766 | −$90,988 | $606,724 |
| 23 | $407,429 | −$93,735 | $630,981 |
| 24 | $428,405 | −$93,593 | $656,681 |
| 25 | $448,767 | −$91,761 | $682,712 |
| 26 | $464,926 | −$95,811 | $705,424 |
| 27 | $484,676 | −$100,557 | $731,362 |
| 28 | $503,517 | −$103,021 | $755,833 |
| 29 | $525,043 | −$103,782 | $781,771 |
| 30 | $546,297 | −$105,563 | $806,243 |
| 31 | $568,979 | −$105,617 | $832,181 |
| 32 | $591,786 | −$105,478 | $858,119 |
| 33 | $612,577 | −$106,098 | $882,590 |
| 34 | $634,737 | −$107,405 | $908,528 |
| 35 | $654,700 | −$109,800 | $932,999 |
| 36 | $677,020 | −$109,212 | $958,937 |
| 37 | $698,688 | −$106,796 | $985,202 |
| 38 | $715,963 | −$110,550 | $1,008,116 |
| 39 | $736,994 | −$115,009 | $1,034,285 |
| 40 | $757,075 | −$117,099 | $1,058,965 |
| 41 | $779,955 | −$117,412 | $1,085,134 |
| 42 | $800,482 | −$118,791 | $1,109,813 |
| 43 | $822,433 | −$118,368 | $1,135,983 |
| 44 | $846,646 | −$117,744 | $1,162,152 |
| 45 | $868,755 | −$117,916 | $1,186,831 |
| 46 | $892,294 | −$118,797 | $1,213,001 |
| 47 | $913,564 | −$120,851 | $1,237,680 |
| 48 | $936,833 | −$119,849 | $1,263,850 |
| 49 | $959,811 | −$116,716 | $1,290,341 |
| 50 | $977,949 | −$120,153 | $1,311,467 |
| 51 | $1,000,325 | −$124,302 | $1,337,862 |
| 52 | $1,019,579 | −$125,994 | $1,362,742 |
| 53 | $1,041,682 | −$125,829 | $1,389,136 |
| 54 | $1,063,550 | −$126,779 | $1,414,016 |
| 55 | $1,086,905 | −$125,849 | $1,440,411 |
| 56 | $1,110,395 | −$124,709 | $1,466,805 |
| 57 | $1,133,886 | −$124,405 | $1,491,685 |
| 58 | $1,156,675 | −$124,831 | $1,518,080 |
| 59 | $1,178,829 | −$126,613 | $1,542,960 |
| 60 | $1,202,783 | −$125,080 | $1,569,354 |
Download all scenario cash values (CSV). This educational case export is separate from the planned personalized Excel model.
Sources and scope
- Illustrative planning case methodology · Checked 2026-10-05 · Case inputs are hypotheses, not market averages. Local demand, rents, purchase margins, stock days and all supplier terms are assumed.
- ENERGY STAR grocery-store energy guidance · Checked 2026-10-05 · Refrigeration upkeep and bill/usage measurement; no measured kWh or guaranteed savings for this case. 600 USD/month refrigeration electricity is assumed.
- California DIR 2026 minimum wage · Checked 2026-10-05 · State floor 16.90 USD/hour effective 1 January 2026; 19/22 hourly hiring budgets are case assumptions, and 2027/local terms require checking.
- IRS Publication 15, 2026 · Checked 2026-10-05 · Employer Social Security and Medicare are components, not the entire modeled 16 percent burden. Actual workers compensation, UI, benefits and owner/entity treatment remain quote/tax questions.
- BLS Sacramento May 2024 wage overview · Checked 2026-10-05 · Historical metro, cross-industry wage context only; not a grocery clerk wage quote. Detailed current occupation endpoint was unavailable.