MOMosaic Financial Model
PropTech Startup Financials (Free Excel Download)
Technology-enabled residential construction company that uses proprietary software ("Dog") to deliver general/subcontracting services at greater speed and lower cost than legacy builders.
professionals from Deloitte
Used by professionals from
About this model
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.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
About Mosaic
joinmosaic.com
How to build a detailed financial model for Mosaic
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Mosaic model - distilled from its pitch deck and publicly available information.
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:
- Assumptions - all drivers with / tags
- Bookings & Backlog - new bookings by period, cumulative backlog, revenue recognized per period (waterfall from backlog)
- Revenue Build - homes contracted × ASP × recognition schedule
- Job Cost P&L - revenue, direct labor, materials, subcontracted trades, equipment, gross profit
- Operating P&L - gross profit less G&A, tech/R&D (Dog platform), sales
- CapEx & Equipment Schedule - equipment purchases/leases by market, depreciation
- Cash Flow - operating CF, CapEx, working capital (receivables vs. payment-on-completion timing)
- Market Expansion Tracker - AZ, TX, GA, Sun Belt Tier 2 activation dates and per-market bookings
- Scenario Toggle - Base / Bull / Bear switcher
- Dashboard - Bookings, Backlog, Revenue, Gross Margin %, Cash
Frequently asked
Is the Mosaic financial model free?+
Yes. The Mosaic model is a free Excel (.xlsx) download with live formulas. Sign up with your email and the workbook is yours to keep, review, and edit.
What's included in the model?+
A 5-year monthly forecast with P&L, cash flow and runway, valuation (exit multiple plus a DCF cross-check), MOIC/IRR returns, and unit economics, with live formulas throughout.
How was this model built?+
It was built from Mosaic's pitch deck and publicly available information, then structured to investment-banking standards as a fully editable Excel model.
Can I change the assumptions?+
Yes. You can change assumptions and the live formulas will recalculate in the downloadable Excel model.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other PropTech Startup Financial Models
Browse another startup in the same category.
Agora
Agora automates operations for real estate investment firms - investment accounting, fundraising, CRM, investor reporting, portal, and data room in one platform.
Briq
SaaS platform that automates money workflow management (budgeting, forecasting, cash flow, WIP) for construction companies.
Canary Technologies
B2B SaaS platform providing guest management and digital operations software to hotels
Geodesic.Life
Sustainable prefabricated geodesic dome houses for rural development, sold as a design + prefab kit + consultancy bundle to real estate partners.
Huboo
Full-stack, software-driven e-commerce fulfilment network built on a micro-warehousing model, targeting SME merchants across UK and Europe.
Immo
Tech-enabled iBuyer that acquires single-unit/single-family residential properties directly from homeowners, renovates and rents them under the IMMO Homes brand, and aggregates the portfolios into institutional investment products.
Kasa Living
Tech-enabled hospitality operator that manages furnished apartments and hotel units on behalf of property owners, capturing a share of room revenue without owning real estate.
Latch (Door.com)
Latch is an enterprise proptech company selling LatchOS, a full-building smart-access and SaaS operating system for multifamily residential buildings, going public via SPAC merger with TS Innovation Acquisitions Corp. (TSIA).
