Departments & Roles
Fill in the blanks for who staffs each department, by state/territory. Adjustable boxes everywhere except owner equity.
📣 Marketing Department
Lead Gen / Ad BuyerGoogle LSA/PPC, Buyer's Guide placements
—
Hrs/week (adjustable)
📞 Sales Department
Sales ManagerOversees reps, pipeline, closing support
Rep — per rep, hrs/weekPitch, Zoom estimate, close
Secretary — per secretary, hrs/weekIntake call, app download, file build
🔧 Revisions Department
Revisions CoordinatorQA upgrades, material changes, re-quote
Revision split — Roofer
$3,000 / job locked
Revision split — Nat'l Install
$5,000 / job locked
Revision avg total value
Revision dept fee (% of revision)
%🚚 Dispatch
Dispatch LiaisonConnects sales floor → contractor schedule
Man-Hours Per Sales Stage (per closed deal)
Adjust hours at each stage of the sale. These roll up into total labor hours per deal and per day at your volume target.
| Stage | Role Responsible | Avg Time (min) | Adjust |
|---|---|---|---|
| 1. Inbound Call / Intake | Secretary | 15 min | |
| 2. App Download + Client File Creation | Secretary | 10 min | |
| 3. Photo Collection (all sides of home) | Secretary / Homeowner | 10 min | |
| 4. Eagle Eye Overlay / Map Measure Prep | Rep | 15 min | |
| 5. Zoom Walkthrough / Quote Presentation | Rep | 45 min | |
| 6. Financing Application (phone-based) | Rep | 20 min | |
| 7. Close + Deposit Collection | Rep | 15 min | |
| 8. Dispatch Handoff to Contractor | Dispatch | 10 min | |
| TOTAL MAN-MINUTES PER CLOSED DEAL | — | — |
Rep-facing time (stages 4–7): — | Secretary-facing time (stages 1–3): — | Dispatch time (stage 8): —
Lead Funnel & Conversion Ratios
Every box below is adjustable. Change leads/day, pitch rate, or close rate and every table on every tab recalculates.
| Funnel Stage | Per Day | Per Week | Per Month | Per Quarter | Per Year |
|---|---|---|---|---|---|
| Leads Purchased
/day
|
— | — | — | — | — |
| Cost Per Lead
$/lead
|
— | — | — | — | — |
| Pitch Rate (Lead → Zoom Quote)
%
|
— | — | — | — | — |
| Close Rate (Quoted → Sold)
%
|
— | — | — | — | — |
| Cost Per Acquisition (closed deal)
$/deal
|
— | ↳ Actual CPA from lead spend ÷ deals closed (compare to your $1,500 target at left) | |||
Staffing Required at This Volume
Leads per Rep/Secretary pair per day
Reps Needed
—
Secretaries Needed
—
Per-Rep Performance Check
Sold deals / rep / day
—
Sold deals / rep / week
—
Target check
—
Adjust Leads/Day, Pitch Rate, or Close Rate above and watch Reps/Secretaries Needed and Sold/Rep/Week update — use this to find the staffing level that matches your real-world rep capacity.
Revenue Forecast
Driven by the Funnel tab. Adjust average sale price and revision economics here.
| Revenue Stream | Daily | Weekly | Monthly | Quarterly | Yearly |
|---|---|---|---|---|---|
| Avg Roof Sale Price | ↳ Used to calculate Initial Sales revenue below | ||||
| Initial Roof Sales | |||||
| Roofs Sold | — | — | — | — | — |
| Gross Revenue — Initial Sales | — | — | — | — | — |
| Revisions / Upgrades | |||||
| Revision Rate (% of sold deals that revise)
%
|
↳ Default models ~40 revisions per 48 sold deals; adjust freely | ||||
| Revisions Completed | — | — | — | — | — |
| Gross Revenue — Revisions | — | — | — | — | — |
| TOTAL GROSS REVENUE | — | — | — | — | — |
Expense & Distribution Forecast
Descending order, greatest cost to least. Every line adjustable as % or $ except where marked locked. Owner distribution is the remainder — never directly edited.
| Distribution Line | Basis | Daily | Weekly | Monthly | Quarterly | Yearly |
|---|---|---|---|---|---|---|
| 1. Roofer — Initial Install | $14,000/roof locked | — | — | — | — | — |
| 2. Roofer — Revision Share | $3,000/revision locked | — | — | — | — | — |
| 3. Lead Generation Spend | $270/lead × leads | — | — | — | — | — |
| 4. Buyer's Guide / Authority Placement | Forbes/US News/Consumer Affairs — float total / day float |
— | — | — | — | — |
| Sales Team Commission Pool — 10% of Initial Sale Price (adjustable) | ||||||
| 5a. Sales Commission Pool (Total) | % of sale | — | — | — | — | — |
| 5b. → Rep Share | % of pool | — | — | — | — | — |
| 5c. → Secretary Share | % of pool | — | — | — | — | — |
| 5d. → Sales Manager Share | 5% of pool remainder | — | — | — | — | — |
| Revisions Department — 7% of Revision Value (adjustable on Org tab) | ||||||
| 6. Revisions Dept Fee | 7% of $8,000 | — | — | — | — | — |
| 7. CRM / App Fee — Ongoing | % of gross revenue | — | — | — | — | — |
| 8. Secretary Wages (W-2) | $/wk per secretary | — | — | — | — | — |
| 9. Accountant Fee | $/wk | — | — | — | — | — |
| 10. Rent | $/day | — | — | — | — | — |
| 11. Merchant Processing | $/day | — | — | — | — | — |
| 12. Tithe | % of gross | — | — | — | — | — |
| TOTAL EXPENSES (excl. tax & owner draw) | — | — | — | — | — | |
CRM/App build fee ($16,000 — 50% deposit / 50% on completion) is a one-time setup cost, modeled separately on the Owner Equity tab as a startup cost, not in recurring expense flow.
Profit Forecast
Gross Revenue → minus Total Expenses (incl. roofer COGS) → Pre-Tax Net Income → minus Tax Reserve → Net Distributable Profit.
| Line | Daily | Weekly | Monthly | Quarterly | Yearly |
|---|---|---|---|---|---|
| Total Gross Revenue | — | — | — | — | — |
| Total Expenses (all lines above) | — | — | — | — | — |
| PRE-TAX NET INCOME | — | — | — | — | — |
| Federal Tax Reserve (%) | — | — | — | — | — |
| State Tax Reserve (%) | — | — | — | — | — |
| NET DISTRIBUTABLE PROFIT | — | — | — | — | — |
Federal/State % shown are planning reserves, not filed tax calculations. Actual S-corp pass-through liability depends on each shareholder's full personal return — confirm with a CPA before relying on these for real disbursement.
Quarterly & Annual Tax Reserve
S-corp pass-through — no entity-level federal tax. Reserve is modeled at the entity level for planning purposes only; actual liability is assessed on each shareholder's personal return.
| Period | Pre-Tax Net Income | Federal Reserve | State Reserve | Total Tax Reserve | Net After Tax |
|---|---|---|---|---|---|
| Q1 (Jan–Mar) | — | — | — | — | — |
| Q2 (Apr–Jun) | — | — | — | — | — |
| Q3 (Jul–Sep) | — | — | — | — | — |
| Q4 (Oct–Dec) | — | — | — | — | — |
| ANNUAL TOTAL | — | — | — | — | — |
Quarterly estimated payment deadlines (calendar year, federal): Q1 — Apr 15 · Q2 — Jun 15 · Q3 — Sep 15 · Q4 — Jan 15 (following year). State deadlines generally mirror federal but confirm per state of incorporation/operation.
Tennessee has no personal state income tax. The 7% state reserve modeled above is a placeholder — replace with the actual TN franchise/excise tax rate (or the applicable rate for NC/GA/AL as those markets launch) once confirmed with your CPA.
Owner Equity & Distributions — Locked
Ownership percentages are fixed and do not adjust with performance scenarios. Dollar distributions below scale automatically with Net Distributable Profit from the Profit Forecast tab.
| Shareholder | Equity % | Investment | Daily | Weekly | Monthly | Quarterly | Yearly |
|---|---|---|---|---|---|---|---|
| Josh Morales locked | 20% | $100,000 | — | — | — | — | — |
| Investor 2 — locked | 40% | $100,000 | — | — | — | — | — |
| Principal (Chris) locked | 20% | Sweat Equity | — | — | — | — | — |
| Brother 1 (Age 19) locked | 10% | Family Share | — | — | — | — | — |
| Brother 2 (Age 20) locked | 10% | Family Share | — | — | — | — | — |
| TOTAL (100%) | 100% | $200,000 + Sweat/Family | — | — | — | — | — |
Open item: 20% (Josh) + 40% (Investor 2) + 20% (Chris) + 10% + 10% (brothers) = 100%. This assumes the brothers split the original "20% family" line into 10%/10%. Confirm exact split before finalizing cap table.
One-Time Startup Costs (Not in Recurring Expense Flow)
| Item | Total | Payment Structure |
|---|---|---|
| CRM / App Build Fee | $ | 50% deposit to start, 50% on completion |
| Buyer's Guide / Authority Placement (Forbes, US News, etc.) | $ | 90–120 day float |
| TOTAL STARTUP CAPITAL NEEDED | — |