A co-working spaces business provides flexible, shared office environments where freelancers, startups, and companies can rent desks, private offices, and meeting rooms on short- or long-term plans. It typically offers bundled amenities such as high-speed internet, printing, reception services, cleaning, and community programming, creating a professional workspace without the commitment of a traditional lease. Revenue is driven by membership subscriptions, space utilization, and add-ons like event hosting and mailbox services, while success depends on location, occupancy, member retention, and efficient facility operations.
This 10-year Co-working spaces financial model is built to forecast growth, profitability, and cash flow for a Co-working location as it scales. It models revenue by product line (hot desks, dedicated desks, private offices, virtual offices, meeting rooms, and event space) and captures key drivers such as capacity, occupancy/desk utilization, pricing tiers, churn, and ancillary income (parking, F&B, sponsorships). On the cost side, it captures headcount planning, sales and marketing, overhead, and working-capital dynamics. The model supports long-term forecasting, profitability analysis, and capacity planning, with flexible inputs for location performance, service offerings, and market demand. It provides a robust financial framework to assess scalability, optimize utilization, and guide strategic growth.
The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.
Detailed instructions on the use of the model are included in the Excel file.
Model Structure
Inputs:
• General Business Info & Property Metrics (Total SF, Rentable SF, Parking Spaces)
• Spaces Allocation based on the area/unit for 5 different types of spaces (Hot Desks, Dedicated Desks, Private Offices, Meeting Rooms, Events Area)
• Memberships Revenue Assumptions (Hot Desks, Dedicated Desks, Private Offices, Virtual Offices
• ANcillary Revenue Assumptions (Meeting Rooms Rentals, Events, Parking, F&B, Sponsorships)
• Payroll, OpEx and CapEx Assumptions
• Financing & Capital Structure – Uses & Sources of Cash analysis (Financing through Equity & Debt)
• Valuation & Exit Assumptions (Exit Multiple, Discount Rate)
Model Outputs
• Monthly Operating Budget & Budget summary per Year
• Budget vs. Actual Variance Analysis
• 10-Year Financial Forecast (3 Statement Model)
• Annual Direct Cash Flow
• Breakeven Analysis
• KPIs and Financial Ratios (Revenue & Cost Metrics, ROE, ROIC, Profit Margins, etc.)
• Performance Dashboard
• Business Valuation (incl. DCF, Terminal Value, Unlevered & Levered Cash Flow, Project Return Metrics & Sensitivity Analysis)
• Investors Distribution Waterfall Model
• Professional Executive Summary
Detailed instructions on the use of the model are included in the Excel file.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user's needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Coworking, Integrated Financial Model Excel: Co-working Spaces - Dynamic 10 Year Financial Model Excel (XLSX) Spreadsheet, Profit Vision
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |