When does an electrical crew turn work into profit and cash?
Illustrative case · Small licensed residential electrical service and installation crew: one master/owner plus one journeyman and one van · Texas, United States; local authority, address and service radius not selected
Explore this business · Profitability and payback
This base case generates $300,441 Year 1 revenue and $11,614 EBITDA after owner compensation, but −$14,730 profit before income tax. Year 1 cash after working capital and debt changes by −$8,072. A positive operating margin does not make depreciation, interest, principal or collection delays disappear.
Build sales from sold hours and completed job scope
At base prices, a two-hour service call has an illustrative invoice of $580 including materials and the blended permit allowance. An eight-hour installation has an invoice of $2,830. These are lump-sum job equivalents, not advertised tariffs. Service work takes 60.0% of billed hours; installation uses the remainder. Job counts are therefore outputs from hours and durations, not a second independent sales forecast.
Demand loads usable capacity from 35.0% in month 1 to 90.0% in month 12 before seasonality. January-start multipliers are planning assumptions, not measured Texas demand. Production stops at capacity and unmet requested hours are recorded. The same two-person payroll remains paid during the ramp; owner time is not made free to improve launch profitability.
| Period | Revenue | EBITDA | Profit before tax | Cash change after debt | Closing cash |
|---|---|---|---|---|---|
| Year 1 | $300,441 | $11,614 | −$14,730 | −$8,072 | $41,928 |
| Year 2 | $377,593 | $59,706 | $34,001 | $43,769 | $85,697 |
| Year 3 | $392,440 | $62,593 | $37,602 | $46,564 | $132,262 |
| Year 4 | $407,149 | $65,080 | $40,886 | $49,039 | $181,301 |
| Year 5 | $422,418 | $67,662 | $44,356 | $51,607 | $232,909 |
Read contribution, EBITDA and cash as different measures
Materials, permit cost, fuel, consumables, card fees and credit losses are variable. Wages are a fixed paid roster: $6,400 owner wage, $5,280 journeyman wage and $2,102 employer-cost allowance each initial month. Fixed nonpayroll overhead is $3,300. BLS’s US employee wage comparison supports a labor benchmark only; it does not verify a Texas offer or self-employed owner income.
Contribution before paid roster equals revenue less those variable costs. EBITDA then deducts fixed payroll and overhead. Profit before tax further deducts book depreciation and interest. Cash deducts interest and principal and adjusts for stock, receivables and payables. Borrowing proceeds are opening financing, not revenue. Reserve is cash, not an operating expense.
The downside cannot be funded into profitability
| Scenario | Year 1 sales | Year 1 EBITDA | Minimum cash | Unfunded gap | Pre-debt project recovery |
|---|---|---|---|---|---|
| Downside | $154,134 | −$109,578 | −$488,229 | $488,229 | No recovery in 60 months |
| Base | $300,441 | $11,614 | $20,830 | $0 | Month 41 |
| Upside | $390,705 | $89,032 | $39,765 | $0 | Month 18 |
Downside prices are 0.9 times base, material cost is 1.2 times base, travel consumes 30.0% of paid time and callbacks consume 8.0% of billed time. Service-hour mix falls to 40.0% and installation collection slows to 40.0% in the same month. Those drivers produce persistent losses and negative cash from month 4; no rescue credit line is inserted.
At Year 1 downside economics the cash threshold exceeds usable crew capacity. The failure is structural: even a fuller diary cannot cover the assumed wage bill, overhead and debt at those margins. Reprice, narrow the territory, improve scope control or change staffing/commitments before committing more capital. The gap is the modeled cumulative deficit, not a recommendation to borrow it.
Upside improves prices, routing, callbacks and collections while retaining the same people and van. It does not assume that a busy month adds free crew capacity. Demand above the cap is unserved, and earnings do not include a second crew’s revenue.
A first-month result can tie even when it loses cash
| Measure | Value | Interpretation |
|---|---|---|
| EBITDA | −$9,795 | Revenue less variable costs and paid roster/overhead |
| Depreciation | $1,347 | Noncash book asset consumption |
| Interest | $871 | Debt expense and cash outflow |
| Profit before tax | −$12,013 | EBITDA less depreciation and interest |
| Working-capital increase | −$147 | Inventory/receivables less supplier payables; negative means release |
| Operating cash after interest | −$10,519 | EBITDA less interest and working-capital increase |
| Principal | $438 | Financing cash outflow, not an income expense |
| Closing cash | $39,043 | Opening reserve plus cash change |
Reducing base same-month installation collections from 70.0% to 40.0% lowers the minimum cash to $17,391 while leaving sales and EBITDA unchanged. The ordinary earnings statement cannot diagnose that timing risk alone. The model independently reconciles every month’s direct receipts and supplier payments to cash and balances assets against debt, payables, contributed equity and retained earnings.
Define the investment before quoting recovery
Project recovery here means cumulative pre-income-tax cash before debt service and after working-capital changes reaches total opening uses of $144,996. It includes the opening reserve in the investment basis and assumes no later asset replacement, sale or distribution. Base reaches that basis in month 41; downside does not reach it within 60 months; upside reaches it in month 18. This is a comparison convention, not an investor return or a promise.
Equity cash recovery instead compares cumulative cash after scheduled debt service with contributed equity. It has a different month and still leaves a loan balance. Neither measure includes owner income taxes, terminal value or a new van after the book life. EBITDA divided by debt service is shown separately from cash available after working-capital changes; neither is labeled a lender’s underwriting DSCR.
Owner compensation is already paid in the model
Year 1 gross owner pay is $76,800, for 20 paid days per month at $40 per paid hour. It covers on-site work, travel and administration inside the stated time budget. Burden is applied to both workers; no unpaid master-supervisor role is hidden outside payroll.
That wage is not take-home pay, dividend cash or the full return on equity. The reference ledger excludes income taxes and owner distributions. Leaving cash in the company protects the ramp and the ability to replace stock; withdrawing the accumulated balance would require an explicit new distribution/covenant scenario. Record the owner’s required household cash separately before adopting this case.
Compare the monthly cash path
| Month | Base | Downside | Upside |
|---|---|---|---|
| 1 | $39,043 | $34,053 | $43,426 |
| 2 | $29,904 | $18,856 | $39,765 |
| 3 | $24,258 | $4,683 | $40,757 |
| 4 | $21,374 | −$7,896 | $46,588 |
| 5 | $20,830 | −$18,790 | $55,062 |
| 6 | $22,523 | −$28,994 | $64,723 |
| 7 | $25,825 | −$37,951 | $74,579 |
| 8 | $29,383 | −$46,897 | $84,434 |
| 9 | $32,663 | −$55,392 | $94,290 |
| 10 | $36,135 | −$64,329 | $104,146 |
| 11 | $39,099 | −$72,439 | $112,876 |
| 12 | $41,928 | −$81,048 | $121,770 |
Read all sixty monthly balances
| Month | Base | Downside | Upside |
|---|---|---|---|
| 1 | $39,043 | $34,053 | $43,426 |
| 2 | $29,904 | $18,856 | $39,765 |
| 3 | $24,258 | $4,683 | $40,757 |
| 4 | $21,374 | −$7,896 | $46,588 |
| 5 | $20,830 | −$18,790 | $55,062 |
| 6 | $22,523 | −$28,994 | $64,723 |
| 7 | $25,825 | −$37,951 | $74,579 |
| 8 | $29,383 | −$46,897 | $84,434 |
| 9 | $32,663 | −$55,392 | $94,290 |
| 10 | $36,135 | −$64,329 | $104,146 |
| 11 | $39,099 | −$72,439 | $112,876 |
| 12 | $41,928 | −$81,048 | $121,770 |
| 13 | $42,972 | −$90,110 | $128,002 |
| 14 | $43,660 | −$99,832 | $134,387 |
| 15 | $46,310 | −$109,202 | $143,733 |
| 16 | $50,689 | −$117,276 | $153,786 |
| 17 | $55,491 | −$124,814 | $163,840 |
| 18 | $61,006 | −$132,339 | $173,894 |
| 19 | $66,943 | −$139,330 | $183,947 |
| 20 | $72,169 | −$146,333 | $194,001 |
| 21 | $76,259 | −$153,883 | $204,054 |
| 22 | $79,926 | −$161,969 | $214,108 |
| 23 | $82,881 | −$170,068 | $223,002 |
| 24 | $85,697 | −$178,696 | $232,065 |
| 25 | $86,793 | −$187,797 | $238,584 |
| 26 | $87,601 | −$197,818 | $245,319 |
| 27 | $90,452 | −$207,472 | $254,895 |
| 28 | $95,101 | −$215,777 | $265,147 |
| 29 | $100,189 | −$223,526 | $275,399 |
| 30 | $106,019 | −$231,261 | $285,650 |
| 31 | $112,289 | −$238,440 | $295,902 |
| 32 | $117,818 | −$245,633 | $306,154 |
| 33 | $122,165 | −$253,396 | $316,406 |
| 34 | $126,073 | −$261,714 | $326,658 |
| 35 | $129,239 | −$270,047 | $335,942 |
| 36 | $132,262 | −$278,930 | $345,463 |
| 37 | $133,495 | −$288,305 | $352,338 |
| 38 | $134,430 | −$298,635 | $359,439 |
| 39 | $137,491 | −$308,582 | $369,249 |
| 40 | $142,421 | −$317,128 | $379,699 |
| 41 | $147,808 | −$325,095 | $390,149 |
| 42 | $153,801 | −$333,047 | $400,600 |
| 43 | $160,153 | −$340,421 | $411,050 |
| 44 | $165,899 | −$347,810 | $421,500 |
| 45 | $170,516 | −$355,792 | $431,950 |
| 46 | $174,675 | −$364,352 | $442,401 |
| 47 | $178,063 | −$372,927 | $452,090 |
| 48 | $181,301 | −$382,074 | $462,089 |
| 49 | $182,678 | −$391,733 | $469,336 |
| 50 | $183,746 | −$402,383 | $476,818 |
| 51 | $187,026 | −$412,635 | $486,866 |
| 52 | $192,251 | −$421,428 | $497,514 |
| 53 | $197,951 | −$429,621 | $508,163 |
| 54 | $204,108 | −$437,798 | $518,812 |
| 55 | $210,535 | −$445,373 | $529,460 |
| 56 | $216,506 | −$452,965 | $540,109 |
| 57 | $221,403 | −$461,174 | $550,758 |
| 58 | $225,825 | −$469,984 | $561,406 |
| 59 | $229,444 | −$478,809 | $571,517 |
| 60 | $232,909 | −$488,229 | $582,014 |
Download all scenario cash values (CSV). This educational case export is separate from the planned personalized Excel model.
Sources and scope
- SBA Loan: illustrative planning-case methodology · Checked 2026-10-04 · Declared authoring assumptions, not supplier prices, observed demand, loan offers or a real company.
- BLS Occupational Outlook Handbook: Electricians · Checked 2026-10-04 · US May 2025 employee wages, all electrician license levels; not Texas licensed-master compensation.
- Texas Comptroller: real property repair/remodeling · Checked 2026-10-04 · Residential real-property repair, lump-sum versus separated contracts; commercial and mixed-use differ.
- Texas TDLR: new electrical contractor license · Checked 2026-10-04 · Texas statewide contractor license, master of record, annual license and liability limits; not project-specific approval.
- Texas TDLR: compliance guide · Checked 2026-10-04 · State code edition, local inspections, invoice/vehicle license identification.