# Mosaic Financial Model Technology-enabled residential construction company that uses proprietary software ("Dog") to deliver general/subcontracting services at greater speed and lower cost than legacy builders. - Canonical: https://finamodel.com/startups/mosaic - Excel download: https://finamodel.com/startup-models/mosaic.xlsx - Category: PropTech - Model type: Marketplace / GMV - Funding round: Series A - Funding: $14M - Founded: 2020 - Geography: Arizona primary (Phoenix, Flagstaff, Prescott); expansion planned to Texas, Georgia, and broader Sun Belt from 2021 onward. - Customer: B2B ## About the company Mosaic is a technology-enabled residential construction company using proprietary software to deliver faster, lower-cost general and subcontracting services. It earns construction-contract revenue, not software licence fees, with technology intended to improve project execution and job economics. Arizona is the primary market, including Phoenix, Flagstaff, and Prescott, with planned expansion to Texas, Georgia, and the broader Sun Belt. Revenue is recognised from signed projects over one to three years, so bookings and backlog are the correct operating bridge. The model forecasts bookings, backlog, projects, contract value, and revenue recognition by period. Labour, materials, subcontractors, equipment, working capital, and software-driven productivity determine job margin, cash requirements, and the returns from geographic expansion. ## What's included - 5-year monthly revenue build with stage-appropriate growth assumptions - Full P&L, headcount plan, and operating-expense schedule - Cash-flow statement, runway, and burn-rate tracking - Valuation via exit multiple with a DCF cross-check - Returns analysis with MOIC and IRR - Unit economics including CAC, LTV, payback, and cohort retention ## Product & value proposition - Proprietary programming language called "Dog" that codes building construction into computational steps (software-executed) and physical steps (human-executed). - Dog automates planning, purchasing, supply chain management, quality control, and on-site sequencing across all trades. - Generates per-trade crew instructions, enabling existing workforce to build faster without retraining. - Standardizes process, not product - enabling design diversity (vs. homogeneous prefab). - Pilot community: Timber Sky, 35-home community in Flagstaff, AZ. - CapEx is low and asset-light: equipment mix is 54% construction equipment, 42% vehicles, 5% office equipment - no factory, no land. ## Market - US residential homebuilders sold 617k units and earned >$203b in revenue in 2018. - Market is fragmented: top 25 builders = 229k units / $91b revenue; 16k+ infill builders = 388k units / $113b revenue. - Largest public homebuilder (D.R. Horton implied): 48,856 units / $18.8b revenue in 2018. - 7.3m shortfall in new housing units cited for the year of the deck (approx. 2019–2020). - Arizona focus: Phoenix MSA = 2nd fastest-growing MSA 2017–2018; Maricopa County = fastest-growing US county 3 years running; ~25k homes/yr being built in Phoenix with tight supply. - Tier 1 expansion markets (Texas + Georgia) account for 47% of new home permits in the top 15 homebuilding markets nationally. - SAM/SOM not explicitly segmented beyond the total US residential market figures above. ## Revenue model - Revenue source: construction contracts signed with homebuilders; Mosaic acts as general contractor or subcontractor. - Revenue is recognized over the life of the contract (1–3 years per contract). - Payment trigger: completion of work milestones, not home sale. - Consolidates multiple trades under a single invoice to the homebuilder. - No software licensing, SaaS fees, or consumer-facing revenue. - Key metric terminology: Bookings = signed contract revenue; Pipeline = qualified opportunities in process. ## Traction & metrics - Cumulative contracted revenue has grown from to over this year, with a total pipeline of over. - Chart axis spans 2019–2024, showing Annual Contracted Revenue and Annual Pipeline Revenue; bar values are fully redacted. - Company states it anticipates doubling contracted revenue year over year. - Timber Sky (35-home community, Flagstaff AZ) is the only named active project. - No customer count, no recognized revenue, no unit margin disclosed. ## Unit economics - No CAC, LTV, or payback period disclosed. - CapEx profile described qualitatively: Low CapEx, Low Capital Risk, High Liquidity. Equipment is depreciating physical assets (no proprietary factory). - Revenue recognition lag: 1–3 years from contract signing to full revenue recognition implies significant working capital requirements. ## Competition / moat - Closest competitors: self-performing general contractors (rare, hard to scale, fragmented, licensing-constrained). - Subcontractors: regional, single-trade, not scalable across markets. - Homebuilders: clients, not competitors; their capital structure optimized for land/finance, not construction execution. - Prefab/modular: high CapEx, geographically constrained by shipping logistics, design-limited. - Mosaic's claimed differentiation: Efficient + Scalable + Customizable + Capital Light + Design Focus - unique combination vs. all alternative archetypes. - Moat is proprietary Dog language + operational playbook; no IP/patent language in deck. ## Team & funding ask / use of funds - Website shown on back cover: www.mosaic.us. --- ## Recommended financial model - **Archetype + why:** Construction services revenue recognition model (project-based P&L + backlog/bookings waterfall). Not a SaaS or marketplace model - revenue flows from signed construction contracts recognized over 1–3 years. The right frame is a project-backlog model: track Bookings → Backlog → Revenue recognized per period, layered with a job-cost P&L (labor, materials, subcontractors, equipment). Closest analogy: specialty contractor or homebuilder subcontractor model. - **Forecast horizon & granularity:** 5 years (2020–2024 per deck's own chart axis), quarterly for Years 1–2 (to capture contract timing and revenue recognition lags), annual thereafter. - **Key drivers & assumptions:** | Driver | Value / Source | | -- | -- | | Number of homes contracted per year | ; start Year 1 = ~35 units (Timber Sky pilot), grow ~2x/yr per management guidance | | Contract value per home (ASP) | ~$150k–$200k per unit (subcontractor scope of work; ~40–50% of median new-home construction cost of ~$350k) | | Revenue recognition period per contract | 1–3 years; average 18 months | | Gross margin (job-cost margin) | 20–30%; residential subcontractors typically 15–25%; tech-enabled efficiency supports upper end | | Labor as % of contract revenue | 40–50%; construction industry norm | | Materials/subcontracted trades as % of revenue | 30–40% | | G&A / overhead | heavy in early years (~30% of revenue), declining to ~15% at scale | | CapEx per new market/crew | modest - equipment lease or purchase ~$500k–$1M per operating crew based on equipment-mix profile in deck | | Revenue CAGR (management target) | ~2x per year (doubles annually) | | Geographic expansion timeline | AZ in 2020; TX + GA in 2021+; broader Sun Belt Tier 2 thereafter | | Bookings-to-revenue conversion lag | ~6–18 months | | Pipeline conversion rate | 30–50% of qualified pipeline converts to bookings | - **Scenarios (Base / Bull / Bear - which variables flex):** - **Base:** 2x annual bookings growth, 18-month avg recognition, 22% gross margin, AZ + 1 new market by Year 3. - **Bull:** 2.5x bookings growth, faster recognition (12 months), 27% gross margin, 2 new markets/year from Year 2. - **Bear:** 1.3x bookings growth (supply chain / labor disruption), 15% gross margin, AZ-only through Year 3. - Flex variables: contract win rate, avg contract size, gross margin, recognition speed, market expansion pace. - **Required sheets / outputs:** 1. **Assumptions** - all drivers with / tags 2. **Bookings & Backlog** - new bookings by period, cumulative backlog, revenue recognized per period (waterfall from backlog) 3. **Revenue Build** - homes contracted × ASP × recognition schedule 4. **Job Cost P&L** - revenue, direct labor, materials, subcontracted trades, equipment, gross profit 5. **Operating P&L** - gross profit less G&A, tech/R&D (Dog platform), sales 6. **CapEx & Equipment Schedule** - equipment purchases/leases by market, depreciation 7. **Cash Flow** - operating CF, CapEx, working capital (receivables vs. payment-on-completion timing) 8. **Market Expansion Tracker** - AZ, TX, GA, Sun Belt Tier 2 activation dates and per-market bookings 9. **Scenario Toggle** - Base / Bull / Bear switcher 10. **Dashboard** - Bookings, Backlog, Revenue, Gross Margin %, Cash ## Frequently asked questions ### Is the Mosaic financial model free? Yes. The Mosaic model is a free Excel download with live formulas. ### Can I change the assumptions? Yes. The workbook is editable and its live formulas recalculate when assumptions change.