3-Statement Financial Model
FieldOS — Vertical SaaS for HVAC & Mechanical Contractors
Date: 2026-05-30 · Prepared by: Resolvix · Status: Sample Deliverable
Deliverable type: Financial Analysis — 3-Statement Financial Model (~$950)
Industry: Vertical SaaS / Field Service Management
Company stage: Year 3 of operations; $2.1M ARR entering model period; Series A completed
About this sample. This is one example of what a successful Resolvix deliverable looks like at this scope and type — not a template that every engagement follows. Your expert brings their own expertise and judgment to the work: the structure, the emphasis, which angles they dig into, and how they organize their findings will all vary based on your industry, your specific question, and where the research leads. What stays consistent across every engagement is the standard: analysis grounded in evidence, prioritized recommendations, concrete action steps, and a phased implementation plan. All company names, figures, and scenarios in this sample are illustrative.
Executive Summary
FieldOS is a vertical SaaS platform serving HVAC and mechanical contractors ($2M–$30M revenue) with scheduling, dispatching, invoicing, and job costing tools. Entering Year 4 with $2.1M ARR and 14 months of runway post-Series A ($4.5M raised), the business faces a critical inflection: growth is strong (87% YoY ARR growth in Year 3) but S&M spend efficiency is declining as the easy TAM gets saturated and CAC climbs. This model projects Years 4–6 across three integrated statements. The central finding: FieldOS reaches EBITDA breakeven in Q3 Year 5 on base assumptions, but a 15% miss on new logo targets pushes breakeven to Q1 Year 6 and reduces runway to 4 months of cushion. The company needs either (a) a deliberate CAC efficiency program before scaling headcount, or (b) a Series B raise by Month 8 of Year 4 to maintain strategic optionality. This model quantifies both paths.
Model Architecture & Key Assumptions
Revenue Model
| Driver | Year 4 | Year 5 | Year 6 |
|---|---|---|---|
| Beginning ARR | $2,100,000 | $3,570,000 | $5,640,000 |
| New logo ACV (avg.) | $8,400 | $8,800 | $9,200 |
| New logos added | 180 | 230 | 265 |
| New ARR from new logos | $1,512,000 | $2,024,000 | $2,438,000 |
| Expansion ARR (upsell/seats) | $189,000 | $356,000 | $620,000 |
| Churned ARR | $(231,000) | $(310,000) | $(450,000) |
| Ending ARR | $3,570,000 | $5,640,000 | $8,248,000 |
| Gross Revenue Retention | 89% | 91% | 92% |
| Net Revenue Retention | 98% | 104% | 111% |
Revenue recognition: ARR is recognized ratably on a monthly basis. New logos are assumed to close with uniform distribution across quarters (not year-end heavy — conservative for SaaS at this stage). Professional services (implementation, onboarding) recognized on completion; excluded from ARR.
Churn assumption: Year 4 churn reflects the cohort of early adopters who were acquired at lower ACVs and have lower feature utilization. Churn rate improves in Years 5–6 as the product matures and the customer success function scales from 1 to 3 CSMs.
Cost Structure Assumptions
| Cost Driver | Year 4 | Year 5 | Year 6 |
|---|---|---|---|
| COGS: Hosting & infrastructure (% rev) | 8% | 7% | 6% |
| COGS: Customer success (headcount) | 2 CSMs | 3 CSMs | 4 CSMs |
| COGS: Avg. fully-loaded CSM cost | $95,000 | $100,000 | $105,000 |
| S&M: AEs | 3 | 5 | 7 |
| S&M: SDRs | 2 | 3 | 4 |
| S&M: Avg. AE cost (fully loaded) | $130,000 | $135,000 | $140,000 |
| S&M: Avg. SDR cost (fully loaded) | $75,000 | $78,000 | $82,000 |
| S&M: Marketing programs | $180,000 | $280,000 | $420,000 |
| R&D: Engineers | 4 | 6 | 8 |
| R&D: Avg. engineer cost (fully loaded) | $155,000 | $162,000 | $170,000 |
| G&A: Finance, legal, HR, office | $320,000 | $420,000 | $520,000 |
| Capitalized software (% R&D spend) | 30% | 30% | 30% |
Income Statement (P&L)
All figures in USD. MRR recognized monthly; annual totals shown.
| Year 4 | Year 5 | Year 6 | |
|---|---|---|---|
| Revenue | |||
| SaaS subscription revenue | $2,730,000 | $4,572,000 | $6,927,000 |
| Professional services revenue | $163,800 | $228,600 | $311,715 |
| Total Revenue | $2,893,800 | $4,800,600 | $7,238,715 |
| Cost of Revenue (COGS) | |||
| Hosting & infrastructure | $(218,520) | $(320,042) | $(415,920) |
| Customer success payroll | $(190,000) | $(300,000) | $(420,000) |
| Professional services delivery | $(98,280) | $(137,160) | $(187,029) |
| Total COGS | $(506,800) | $(757,202) | $(1,022,949) |
| Gross Profit | $2,387,000 | $4,043,398 | $6,215,766 |
| Gross Margin | 82.5% | 84.2% | 85.9% |
| Operating Expenses | |||
| Sales & Marketing | |||
| — AE payroll | $(390,000) | $(675,000) | $(980,000) |
| — SDR payroll | $(150,000) | $(234,000) | $(328,000) |
| — Marketing programs | $(180,000) | $(280,000) | $(420,000) |
| — Travel & events | $(65,000) | $(95,000) | $(130,000) |
| Total S&M | $(785,000) | $(1,284,000) | $(1,858,000) |
| Research & Development | |||
| — Engineering payroll (gross) | $(620,000) | $(972,000) | $(1,360,000) |
| — Capitalized software development | $186,000 | $291,600 | $408,000 |
| — Software, tools, infra (dev) | $(55,000) | $(80,000) | $(110,000) |
| Total R&D (net of capitalization) | $(489,000) | $(760,400) | $(1,062,000) |
| General & Administrative | |||
| — Finance, legal, HR | $(220,000) | $(290,000) | $(360,000) |
| — Office & facilities | $(55,000) | $(75,000) | $(95,000) |
| — D&O insurance, compliance | $(45,000) | $(55,000) | $(65,000) |
| Total G&A | $(320,000) | $(420,000) | $(520,000) |
| Total Operating Expenses | $(1,594,000) | $(2,464,400) | $(3,440,000) |
| EBITDA | $793,000 | $1,578,998 | $2,775,766 |
| EBITDA Margin | 27.4% | 32.9% | 38.3% |
| Depreciation & amortization | $(62,000) | $(148,000) | $(265,000) |
| — Amortization of capitalized software | $(56,000) | $(138,000) | $(248,000) |
| — D&A on equipment | $(6,000) | $(10,000) | $(17,000) |
| EBIT (Operating Income) | $731,000 | $1,430,998 | $2,510,766 |
| Interest income (cash on hand) | $72,000 | $38,000 | $52,000 |
| Interest expense (if applicable) | $— | $— | $— |
| Pre-Tax Income | $803,000 | $1,468,998 | $2,562,766 |
| Income tax provision (25% effective) | $(200,750) | $(367,250) | $(640,692) |
| Net Income | $602,250 | $1,101,748 | $1,922,075 |
| Net Margin | 20.8% | 22.9% | 26.6% |
Note: EBITDA turns positive in Year 4 because the model enters Year 4 with $2.1M ARR already on the books — the Series A capital funded the headcount expansion in Years 2–3. The company is not profitable on a cash basis until mid-Year 4 after accounting for the Series A deployment. See Cash Flow Statement.
Balance Sheet
Snapshot at fiscal year-end.
| Year 3 (Actual) | Year 4 (Proj.) | Year 5 (Proj.) | Year 6 (Proj.) | |
|---|---|---|---|---|
| Assets | ||||
| Cash & cash equivalents | $3,240,000 | $2,890,000 | $3,680,000 | $5,920,000 |
| Accounts receivable (net) | $185,000 | $320,000 | $510,000 | $775,000 |
| Deferred contract costs | $42,000 | $68,000 | $108,000 | $162,000 |
| Prepaid expenses & other | $38,000 | $52,000 | $70,000 | $92,000 |
| Total Current Assets | $3,505,000 | $3,330,000 | $4,368,000 | $6,949,000 |
| Capitalized software (net) | $145,000 | $275,000 | $428,600 | $570,600 |
| Property & equipment (net) | $28,000 | $38,000 | $52,000 | $68,000 |
| Total Long-Term Assets | $173,000 | $313,000 | $480,600 | $638,600 |
| Total Assets | $3,678,000 | $3,643,000 | $4,848,600 | $7,587,600 |
| Liabilities | ||||
| Accounts payable | $48,000 | $65,000 | $95,000 | $138,000 |
| Accrued liabilities | $125,000 | $180,000 | $260,000 | $365,000 |
| Deferred revenue (current) | $420,000 | $714,000 | $1,128,000 | $1,649,600 |
| Total Current Liabilities | $593,000 | $959,000 | $1,483,000 | $2,152,600 |
| Deferred revenue (long-term) | $105,000 | $178,500 | $282,000 | $412,400 |
| Total Liabilities | $698,000 | $1,137,500 | $1,765,000 | $2,565,000 |
| Stockholders' Equity | ||||
| Common stock & APIC | $4,850,000 | $4,850,000 | $4,850,000 | $4,850,000 |
| Accumulated deficit / retained earnings | $(1,870,000) | $(1,267,750) | $(166,002) | $1,756,073 |
| Stock-based compensation (cumulative) | $— | $63,250 | $399,602 | $976,527 |
| Total Stockholders' Equity | $2,980,000 | $3,645,500 | $5,083,598 | $7,582,600 |
| Total Liabilities & Equity | $3,678,000 | $4,782,500 | $6,848,598 | $10,147,600 |
Deferred revenue is a key balance sheet item for SaaS: annual contracts billed upfront create a liability until the service is delivered. FieldOS's growing deferred revenue balance ($420K → $1.65M) reflects an increasing proportion of annual prepay contracts — a positive signal for cash collection and customer commitment.
Cash Flow Statement
| Year 4 | Year 5 | Year 6 | |
|---|---|---|---|
| Operating Activities | |||
| Net income | $602,250 | $1,101,748 | $1,922,075 |
| Depreciation & amortization | $62,000 | $148,000 | $265,000 |
| Stock-based compensation | $63,250 | $336,352 | $576,925 |
| Change in accounts receivable | $(135,000) | $(190,000) | $(265,000) |
| Change in deferred contract costs | $(26,000) | $(40,000) | $(54,000) |
| Change in prepaid expenses | $(14,000) | $(18,000) | $(22,000) |
| Change in accounts payable | $17,000 | $30,000 | $43,000 |
| Change in accrued liabilities | $55,000 | $80,000 | $105,000 |
| Change in deferred revenue | $367,500 | $570,000 | $651,600 |
| Net Cash from Operations | $991,000 | $2,018,100 | $3,222,600 |
| Investing Activities | |||
| Capitalized software development | $(186,000) | $(291,600) | $(408,000) |
| Purchase of property & equipment | $(16,000) | $(24,000) | $(33,000) |
| Net Cash from Investing | $(202,000) | $(315,600) | $(441,000) |
| Financing Activities | |||
| Proceeds from equity issuance | $— | $— | $— |
| Repayment of debt | $— | $— | $— |
| Net Cash from Financing | $— | $— | $— |
| Net Change in Cash | $(341,000) | $822,100 | $2,781,600 |
| Beginning cash | $3,240,000 | $2,890,000 | $3,680,000 |
| Ending Cash | $2,890,000 | $3,680,000 | $6,920,000 |
Free Cash Flow: $789,000 (Y4) → $1,702,500 (Y5) → $2,781,600 (Y6)
FCF Margin: 27.3% (Y4) → 35.5% (Y5) → 38.4% (Y6)
Cash note: The $350K cash decline in Year 4 despite positive EBITDA reflects timing: the new AE and SDR hires in Q1–Q2 Year 4 are fully expensed before the associated new logos close. Cash trough occurs in Q2 Year 4 at approximately $2.6M — 14 months of runway at the Year 4 burn rate. The company does not need additional capital under base assumptions, but a Series B in Year 4 would meaningfully accelerate the Year 5–6 growth trajectory.
Key SaaS Metrics Summary
| Metric | Year 3 (Actual) | Year 4 | Year 5 | Year 6 |
|---|---|---|---|---|
| ARR | $2,100,000 | $3,570,000 | $5,640,000 | $8,248,000 |
| ARR Growth (YoY) | 87% | 70% | 58% | 46% |
| MRR | $175,000 | $297,500 | $470,000 | $687,333 |
| Customers | 250 | 430 | 660 | 925 |
| ACV | $8,400 | $8,302 | $8,545 | $8,917 |
| Gross Revenue Retention | 87% | 89% | 91% | 92% |
| Net Revenue Retention | 94% | 98% | 104% | 111% |
| LTV (Gross Margin–adjusted) | $58,800 | $66,420 | $79,419 | $97,450 |
| CAC (blended) | $4,200 | $4,361 | $5,583 | $7,011 |
| LTV:CAC | 14.0x | 15.2x | 14.2x | 13.9x |
| CAC Payback (months) | 6.1 | 6.3 | 7.9 | 9.2 |
| S&M as % of Revenue | 34% | 27% | 27% | 26% |
| R&D as % of Revenue | 22% | 17% | 16% | 15% |
| G&A as % of Revenue | 14% | 11% | 9% | 7% |
| Rule of 40 Score | N/A | 97 | 91 | 84 |
CAC Payback rising: The increase from 6.3 months (Y4) to 9.2 months (Y6) is the model's primary risk signal. It reflects a natural progression as the highest-fit customers are acquired early and CAC increases as the company reaches further into the TAM. This is manageable at 9.2 months but warrants a focused efficiency program before headcount scales further. See Recommendations.
Sensitivity Analysis: Key Variables
| Scenario | New Logos Y4 | Churn Rate Y4 | ACV Growth | Y4 Ending ARR | Y5 EBITDA | Breakeven |
|---|---|---|---|---|---|---|
| Bull (+15%) | 207 | 8.5% | +5% | $3.82M | $2.1M | Q1 Y5 |
| Base | 180 | 11% | +5% | $3.57M | $1.58M | Q3 Y5 |
| Bear (−15%) | 153 | 13.5% | Flat | $3.16M | $820K | Q1 Y6 |
| Stress (−25%) | 135 | 16% | Flat | $2.81M | $(240K) | Y6+ |
The stress scenario — which assumes a sales execution miss concurrent with elevated churn — consumes the Series A runway by Q3 Year 5 and requires external capital. The probability of this scenario is low given current pipeline coverage (3.2x), but it defines the raise-now decision point.
6. Recommendations
-
Launch a CAC efficiency program in Q1 Year 4 before scaling the sales team to 5 AEs. CAC payback is already rising from 6.3 to 9.2 months over the model period. Adding 2 AEs in Year 5 before improving the efficiency of the current 3 compounds the problem. The target is to hold CAC payback at ≤ 8 months through the Year 5 scale. Specific levers: (a) introduce a product-led growth (PLG) free trial to generate inbound demo requests; (b) build a referral program targeting existing customers — field service contractors are highly networked; (c) audit the current outbound sequences and kill the lowest-converting motions.
-
Prioritize Net Revenue Retention improvement above new logo growth in Year 4. NRR of 98% in Year 4 means the existing customer base is roughly flat on a revenue basis (not a growth engine yet). Moving NRR from 98% to 104% — which Year 5 projects, but could be accelerated — is worth more in terminal value than adding 30 more new logos. The specific levers are expansion: upselling additional technician seats and the FieldOS Payments module (currently only 18% of customers have adopted it).
-
Begin Series B preparation by Month 6 of Year 4, regardless of immediate capital need. The base case doesn't require a raise, but the Series B process takes 4–6 months. Starting in Month 6 means closing by Month 12, which is before the cash trough in the stress scenario. A Series B of $8–12M at the Year 5 ARR trajectory funds the acceleration to $12M+ ARR and gives the board strategic flexibility. Waiting until the need is urgent means raising at a worse valuation or with less leverage.
-
Move to a 12-month minimum contract term with annual upfront billing. Currently 40% of customers are on monthly billing. Annual upfront converts these to positive cash flow at signing and improves GRR (annual customers churn at 7% vs. 18% for monthly customers in this segment). A 10% discount for annual prepay is ROI-positive within 3 months given the churn differential.
-
Capitalize R&D investment at a consistent 30% rate and track the amortization schedule explicitly. Capitalized software development improves reported EBITDA and gross margin, which matters for Series B valuation discussions. However, the amortization schedule must be tracked carefully — the $265K D&A in Year 6 is a significant number that will require explanation in investor materials. Build the capitalization policy document now, before the auditors need it for a Series B audit.
7. Action Steps
| # | Action | Owner | Time | Tied To |
|---|---|---|---|---|
| 1 | Define PLG free trial scope: which features are free, what triggers a conversion prompt, how onboarding is automated | Product + Marketing | 3 weeks | Recommendation 1 |
| 2 | Build customer referral program: mechanics, incentive structure ($500 credit or cash), tracking | Marketing + CS | 2 weeks | Recommendation 1 |
| 3 | Audit outbound sequences: kill bottom-quartile performing sequences; test 2 new message frameworks | Sales | 2 weeks | Recommendation 1 |
| 4 | Build FieldOS Payments upsell campaign: identify the 82% of customers not on Payments; build email + in-app sequence | CS + Marketing | 3 weeks | Recommendation 2 |
| 5 | Model the NRR improvement scenarios: what does NRR 104% vs. 98% do to Year 5 ARR? Present to board | Finance | 1 week | Recommendation 2 |
| 6 | Hire Series B advisor or engage investment bank for process prep; begin narrative deck | CEO + Board | Month 6 Y4 | Recommendation 3 |
| 7 | Draft annual billing migration email sequence for monthly customers; offer 10% discount for prepay | Finance + CS | 2 weeks | Recommendation 4 |
| 8 | Document R&D capitalization policy; review with auditors; build amortization tracking schedule | Finance | 3 weeks | Recommendation 5 |
8. Implementation Plan
Phase 1 — Model Operationalization & Early CAC Efficiency (Days 1–30)
Objective: Translate this model into live operating targets; launch the two fastest CAC efficiency levers.
- Share model with board; lock Year 4 targets (new logos, NRR, CAC payback)
- Begin referral program build
- Begin outbound sequence audit
- Start FieldOS Payments upsell campaign scoping
Success criteria: Board-aligned on Year 4 targets. Referral program launched. Outbound audit complete. Payments upsell campaign scoped.
Phase 2 — NRR Acceleration & Annual Billing Migration (Days 31–90)
Objective: Move the two highest-leverage recurring revenue levers.
- Launch FieldOS Payments upsell campaign to 82% of non-adopter base
- Launch annual billing migration offer for monthly customers
- Launch PLG free trial (if product is ready) or begin scoping
- Run first NRR sensitivity analysis; report to board at Month 3
Success criteria: ≥ 15% of monthly customers migrated to annual billing. ≥ 10% of non-Payments customers converted. NRR trending at or above 100%.
Phase 3 — Series B Preparation (Days 91–180)
Objective: Have a Series B-ready narrative and financial package ready by Month 6.
- Finalize Year 4 half-year actuals; reforecast Year 4–6 with real data
- Build Series B deck: ARR growth, NRR trajectory, CAC payback, Rule of 40 score
- Engage advisor; begin investor pipeline development
- Review capitalization policy with auditors
Success criteria: Series B deck at draft stage. Advisor engaged. Capitalization policy documented. Year 4 H1 actuals recast into the model.
Appendix: Model Conventions
- All figures in USD, not inflation-adjusted
- Revenue recognized per ASC 606 (ratable over subscription period)
- Capitalized software per ASC 350-40 (internal-use software); 3-year useful life
- Tax rate: 25% blended federal + state effective rate; NOL carryforward from Years 1–2 exhausted in Q2 Year 4
- Stock-based compensation: Black-Scholes valuation; 4-year vest, 1-year cliff; excluded from EBITDA (non-cash)
- No Series B proceeds assumed in base case
- Headcount additions assumed Q1 of each year unless otherwise noted