Coworking Space
Operating Businesses Financial Model (Free Excel Download)
Forecast desks, occupancy, memberships, meeting-room revenue, fit-out costs, staffing, and lease obligations to evaluate coworking-space profitability.
professionals from Deloitte
Used by professionals from
About this model
A coworking-space operating model maps a single facility's 5-year economics across three membership tiers (Hot Desk, Dedicated Desk, Private Office) plus ancillary revenue from meeting rooms and member services. The workbook is built around the constraint that every coworking facility shares: capacity is fixed by the lease, occupancy ramps over time, rent is paid on all seats regardless of who shows up, and the unit economics live or die on the rent-per-seat versus revenue-per-seat spread. Six sheets - Cover, Assumptions, Members, Revenue, P&L, Dashboard - tie everything to a single Assumptions tab where every input is a named range.
The Members sheet builds three blocks: capacity per tier (constant across years; capex out of scope), occupancy per tier (starts at the user-set starting occupancy and grows linearly by the user-set annual lift, capped at 100%), and paying members per tier (capacity × occupancy). A blended-occupancy KPI sits underneath. The Revenue sheet splits membership revenue per tier (members × monthly rate × 12) from two ancillary lines - meeting room and member services - each scaling with total paying members. The P&L then layers rent (total capacity × rent per seat × 12, capturing that rent is paid on every seat the operator leases regardless of occupancy), variable seat cost (members × variable rate per tier × 12, capturing the cost of consumables and per-member overhead), a fixed annual staff line, utilities and S&M as percentages of revenue, EBITDA, a small D&A ratio, tax (with a MAX guard so a loss year doesn't generate a tax benefit), and net income.
The Dashboard rolls everything into eight headline metrics with traffic-light status: Y5 revenue, Y5 EBITDA and EBITDA margin (with on-track / watch / stretched flags against user thresholds), blended occupancy averaged across all years, revenue per occupied seat, Y5 contribution per seat (revenue net of variable seat cost and rent, divided by paying members), Y5 rent ratio, and Y5 paying members. A Y5 tier-mix block underneath shows the share of total paying members coming from each tier. Operators, founders, CFOs, and real-estate investors use the template for single-facility underwriting, tier-mix optimisation, and rate-card review - every assumption is a single named-range cell that can be flexed without breaking the workbook.
What every model includes
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.
What's inside the Coworking Space
- Three membership tiers with editable capacity, starting occupancy, annual occupancy lift, monthly rate, and variable cost
- Members sheet with capacity, occupancy %, paying members per tier and a blended-occupancy KPI
- Revenue split between per-tier membership revenue and ancillary meeting-room and member-services revenue
- P&L with rent on total capacity, variable seat cost on paying members, fixed staff, utilities, S&M, EBITDA, D&A, EBIT, tax, net income
- Dashboard with Y5 revenue, EBITDA margin, blended occupancy, revenue per occupied seat, contribution per seat, rent ratio, paying members
- User-set on-track and watch thresholds for margin, occupancy, and revenue-per-seat status
Coworking Space Financial Model: How the Operating Template Works
This coworking space financial model is a five-year operating template for a single flexible-workspace site, with optional consolidation of three sites. It tracks membership tiers, occupancy, lease economics, costs and retention, then rolls everything into EBITDA, unit economics, cash-flow durability and covenant headroom.
Demand drivers: tier mix, occupancy and churn
The model separates capacity into five contract types: hot desk, dedicated desk, private office, team suite and enterprise. Capacity is planned over five years, so the template can reflect a shift toward higher-value offices and suites.
- Occupancy is applied per tier through a ramp curve that reaches a stabilised level, while annual churn varies by tier. These three inputs determine paying members each period.
- The scenario toggle adjusts stabilised occupancy, rent escalation and churn together, so Base, Bull and Bear cases change the shape of demand and retention without rebuilding the model.
Calculation flow: from members to net income
The model converts contract units into seat-equivalents using average headcount per unit, then uses that footprint base for rent and fit-out. Membership revenue comes from paying members multiplied by tier rate.
- Ancillary revenue adds meeting rooms, events, food and beverage, printing, parking, virtual office and partnership income. Operating costs include rent, variable seat cost, headcount-driven staff, utilities and sales and marketing.
- D&A follows capex rather than revenue, and the tax calculation uses taxable EBIT after any available tax losses.
Outputs: unit economics, WALE and covenants
Outputs cover several lenses on the business. LTV and CAC are calculated by tier, including gross margin, an allocation haircut, tenure and payback, with a blended view.
- The cohort sheet shows retention and survival, while WALE measures weighted-average contract duration across the year-five member base. Site-level results include EBITDA, margin, payback and yield proxies, and the three-site consolidation adds staggered opening dates and corporate overhead.
- Covenant checks track DSCR, minimum liquidity, debt-to-EBITDA and an occupancy floor. Under the Bear scenario, the design expects covenant pressure in the earlier ramp years.
Practical use and documented limitations
This template is for a single-site diagnostic or a three-site portfolio evaluation. It is designed to flex tier mix, stabilised occupancy, lease terms, churn and acquisition cost, then observe the impact on earnings quality and debt headroom.
- A few areas are deliberately simplified: the public download is a values-only preview, not a live model. The lease treatment is a lite version, retention is shown on a logo basis, and the sensitivity grids are computed surfaces rather than native Excel data tables.
- The balance sheet is also intentionally narrow. These constraints keep the model focused on operating drivers rather than full accounting detail.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
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!
Frequently asked
What is a coworking space financial model?+
A coworking space financial model translates a facility's physical footprint, membership tier mix, and pricing into a multi-year P&L. It is how operators, founders, and investors pressure-test whether a new location can clear breakeven before signing a long-term lease - or how an existing operator decides which tier mix maximises EBITDA at steady-state occupancy.
How does occupancy ramp work in the model?+
Each tier has a starting occupancy and an annual occupancy lift. Year 1 starts at the starting occupancy and the lift adds linearly each year, capped at 100% with a MIN guard. To model a fast open-and-stabilise curve, raise the lift; to model a slow ramp, lower it.
Why is rent computed on total capacity instead of paying members?+
Rent is a fixed lease payment on the full footprint regardless of who is sitting in the chairs. Modelling rent as a percentage of revenue or per occupied seat would understate cash burn during ramp-up and hide the operator's biggest fixed cost.
How are private offices treated - per desk or per office?+
Per office. The Private Office tier's capacity is the number of office units (not the desks inside them), and the monthly rate is the room rate, not the per-seat rate. This mirrors how operators actually sell that inventory.
Can the model handle multi-location operators?+
No. This is a single-facility template. For a multi-location operator, build one workbook per facility and roll up the P&Ls, or extend this template by duplicating the Members and Revenue sheets per location and aggregating in a new total sheet.
Have more financial modelling questions? Contact us
Related templates
Gym and Fitness Studio Operating Model
Operating model for fitness franchises and independent gyms including membership revenue, class scheduling, and facility utilization.
Self-Storage Operations Dashboard
Monthly operations tracker for self-storage managers with occupancy, pricing, expense variance, and KPI trending.
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
