# Coworking Space A 5-year operating model for a single coworking facility: three membership tiers (Hot Desk, Dedicated Desk, Private Office), capacity and occupancy per tier, monthly rates, ancillary meeting-room and member-services revenue, and a P&L from revenue through rent, variable seat cost, staff, utilities, and S&M to net income. - Canonical: https://finamodel.com/templates/coworking-space - Excel download: https://finamodel.com/templates/coworking-space.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Founders & operators, CFOs & FP&A, Operators, Founders, Real estate investors - Tags: coworking, membership, occupancy, unit economics, operating model ## Overview 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's included - 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 - Three membership tiers: Hot Desk, Dedicated Desk, Private Office with editable capacity, occupancy ramp, monthly rate, and variable cost per tier - Members sheet with capacity, occupancy %, paying members per tier and a blended occupancy KPI - Revenue sheet splitting membership revenue per tier from ancillary meeting-room and member-services revenue - P&L from revenue through rent, variable seat cost, staff, utilities, S&M, EBITDA, D&A, EBIT, tax, and net income - Dashboard with Y5 revenue, EBITDA margin, blended occupancy, revenue per occupied seat, contribution per seat, rent ratio, and paying members ## 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. ## Built for capacity-constrained operators A coworking facility cannot serve more members than it has seats, no matter how strong demand is. This template caps occupancy at 100% per tier and prices rent on the full footprint regardless of how many seats are filled. ## Designed for tier-mix decisions Hot desks, dedicated desks, and private offices each carry their own capacity, occupancy, rate, and variable cost. Flex any one tier and see revenue, EBITDA, and contribution per seat recompute against the other two. ## Audit-friendly mechanics Every assumption is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, and dead-assumption scans. ## Built for capacity-constrained operators A coworking facility cannot serve more members than it has seats, no matter how strong demand is. This template caps occupancy at 100% per tier and prices rent on the full footprint regardless of how many seats are filled. ## Designed for tier-mix decisions Hot desks, dedicated desks, and private offices each carry their own capacity, occupancy, rate, and variable cost. Flex any one tier and see revenue, EBITDA, and contribution per seat recompute against the other two. ## Audit-friendly mechanics Every assumption is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, and dead-assumption scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: tier inputs, ancillary rates, operating parameters, status thresholds. - Per-tier capacity, starting occupancy, annual occupancy lift, monthly rate, variable cost - Meeting-room and member-services revenue per occupied member per month - Rent per seat per month on total capacity, fixed annual staff cost - Utilities, S&M, and D&A as percentages of revenue, plus tax rate - EBITDA margin, blended occupancy, and revenue-per-seat thresholds ### Members Capacity, occupancy, and paying members per tier across 5 years. - Capacity block: per-tier constant across all years - Occupancy block: starting occupancy + annual lift, capped at 100% - Paying members = capacity × occupancy per tier per year - Total paying members and blended occupancy at the bottom ### Revenue Membership revenue per tier plus ancillary meeting-room and member-services lines. - Membership revenue per tier = paying members × monthly rate × 12 - Meeting room and member services = total paying members × rate × 12 - Subtotals for membership and ancillary plus a total revenue line - Revenue per occupied seat at the bottom ### P&L Revenue to net income with rent, variable cost, staff, utilities, S&M, EBITDA, D&A, EBIT, tax. - Rent = total capacity × rent per seat × 12 (paid on all seats, not just occupied) - Variable seat cost = paying members per tier × per-tier variable cost × 12 - Fixed staff cost, utilities and S&M as % of revenue - EBITDA → D&A → EBIT → tax (MAX guard on loss years) → net income - EBITDA and net margin lines plus a P&L identity check ### Dashboard Y5 headline metrics with traffic-light status plus a Y5 tier-mix block. - Y5 revenue, EBITDA, EBITDA margin with status flag - Blended occupancy averaged across all years with status flag - Revenue per occupied seat averaged across all years with status flag - Y5 contribution per seat = (revenue − variable seat cost − rent) ÷ paying members - Y5 rent ratio and Y5 paying members - Y5 tier mix: paying members and share of total per tier ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: tier inputs, ancillary rates, operating parameters, status thresholds. - Per-tier capacity, starting occupancy, annual occupancy lift, monthly rate, variable cost - Meeting-room and member-services revenue per occupied member per month - Rent per seat per month on total capacity, fixed annual staff cost - Utilities, S&M, and D&A as percentages of revenue, plus tax rate - EBITDA margin, blended occupancy, and revenue-per-seat thresholds ### Members Capacity, occupancy, and paying members per tier across 5 years. - Capacity block: per-tier constant across all years - Occupancy block: starting occupancy + annual lift, capped at 100% - Paying members = capacity × occupancy per tier per year - Total paying members and blended occupancy at the bottom ### Revenue Membership revenue per tier plus ancillary meeting-room and member-services lines. - Membership revenue per tier = paying members × monthly rate × 12 - Meeting room and member services = total paying members × rate × 12 - Subtotals for membership and ancillary plus a total revenue line - Revenue per occupied seat at the bottom ### P&L Revenue to net income with rent, variable cost, staff, utilities, S&M, EBITDA, D&A, EBIT, tax. - Rent = total capacity × rent per seat × 12 (paid on all seats, not just occupied) - Variable seat cost = paying members per tier × per-tier variable cost × 12 - Fixed staff cost, utilities and S&M as % of revenue - EBITDA → D&A → EBIT → tax (MAX guard on loss years) → net income - EBITDA and net margin lines plus a P&L identity check ### Dashboard Y5 headline metrics with traffic-light status plus a Y5 tier-mix block. - Y5 revenue, EBITDA, EBITDA margin with status flag - Blended occupancy averaged across all years with status flag - Revenue per occupied seat averaged across all years with status flag - Y5 contribution per seat = (revenue − variable seat cost − rent) ÷ paying members - Y5 rent ratio and Y5 paying members - Y5 tier mix: paying members and share of total per tier ## Features - **Capacity-first economics:** Every tier carries a fixed capacity and an occupancy curve that caps at 100% - so the model can never accidentally serve more members than the physical space allows, and the blended-occupancy KPI sits below that ceiling. - **Rent on all seats, not just occupied:** Lease rent is computed against total capacity rather than paying members, mirroring how a coworking operator actually pays the landlord regardless of occupancy. - **Ancillary revenue split out:** Meeting rooms and member services sit on their own lines and scale with paying-member counts, so the operator can flex the membership rate independently from the ancillary mix. ## Use cases - **Single-facility underwriting:** Pressure-test whether a new facility can clear breakeven before signing a 10-year lease: flex rent per seat, opening occupancy, and ramp speed to find the minimum viable mix. - **Tier-mix optimisation:** Compare a hot-desk-heavy plan against a private-office-heavy plan on the same footprint to see which mix produces higher revenue per occupied seat and contribution at steady state. - **Rate-card review:** Use the dashboard's revenue-per-seat status to gut-check whether the rate card is keeping up with rent per seat and a 15-25% target EBITDA margin. ## Frequently asked questions ### 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. ## Related templates - [Gym and Fitness Studio Operating Model](https://finamodel.com/templates/gym-model) - [Self-Storage Operations Dashboard](https://finamodel.com/templates/self-storage-ops-model) - [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model)