CDP

Business

Coworking Desk Profitability Calculator

This calculator reconciles planned desk-months through vacancy or loss to realized memberships, revenue, variable service cost, contribution, fixed cost, operating profit, cash collection, and break-even desk volume.

Realized billable volume-
Gross recognized revenue-
Total variable cost-
Contribution before fixed cost-
Operating profit per period-
Contribution margin rate-
Break-even volume-
Estimated cash collected-
Cash collected less modeled costs-
Operating profit through horizon-

Decision view

Coworking desk occupancy and profit floor

Coworking desk occupancy and profit floorNamed desks are separated into occupied, vacant, and break-even capacity while revenue, contribution, fixed cost, and cash profit remain visible.
Exact scenario comparisonPlanned desk-months per period changes while all other entered assumptions remain constant.
Planned desk-months per periodRealized billable volumeGross recognized revenueTotal variable costContribution before fixed costOperating profit per periodContribution margin rateBreak-even volumeEstimated cash collectedCash collected less modeled costsOperating profit through horizon

Period-by-period detail

coworking desk period projection

The period table keeps volume, recognized revenue, costs, operating profit, cash collection, and cumulative profit attached to the same assumptions.

How to use Coworking Desk Profitability Calculator

  1. Define desk-month capacity after removing offices, meeting rooms, staff desks, and maintenance downtime.
  2. Use the collected average membership price after discounts rather than the advertised list price.
  3. Review both accounting profit and cash profit when invoicing or collection timing is material.

Calculator guide

Understanding Coworking Desk Profitability Calculator

Coworking profitability depends on sellable desk-months, paid occupancy, membership price, service cost, fixed facility expense, and collection—not simply the number of desks in the room.

Occupancy is not profit Paid desks must produce enough contribution to cover the facility.
Mix changes economics Hot desks and private offices should not be blended blindly.
Cash may lag revenue Collection is displayed separately from recognized revenue.
Capacity has a service limit Crowding can reduce retention before every nominal desk is sold.

Calculation method

How the calculation works

Reconcile the coworking desk from planned activity to realized billable volume, revenue, variable cost, contribution, fixed cost, operating profit, break-even volume, and cash collection. Reduce planned desk-months by the entered loss or vacancy rate, multiply realized volume by price and variable cost, subtract fixed facility cost, and compare the result with break-even and collection assumptions.

Floor economics

See which desks cover the fixed facility

The workspace diagram separates vacant capacity, occupied desks, break-even desk count, and contribution remaining after facility cost.

Sellable desks Desk-month capacity available to members.
Paid occupancy Realized desk-months after the vacancy assumption.
Break-even line Desk count needed to recover fixed cost.
Cash layer Collected cash after variable and fixed costs.

Worked situations

Practical examples

  • Twenty physical desks can create more than twenty memberships only when usage patterns safely support sharing.
  • High occupancy can remain unprofitable when access, cleaning, utilities, and member support consume most unit contribution.
  • Annual prepayments improve cash timing without changing the earned monthly revenue represented here.

Better inputs

Useful tips

  • Separate hot desks, dedicated desks, private offices, and virtual memberships when prices and costs differ.
  • Include rent, staffing, software, insurance, internet, cleaning, and common-area expense in fixed cost.
  • Track churn, delinquency, discounts, and day-pass usage outside the single average vacancy input.

Before relying on the result

Limitations and common mistakes

  • The model holds price, unit service cost, fixed cost, and growth constant across the entered periods.
  • Capacity peaks, meeting-room bottlenecks, deposits, taxes, capital improvements, and lease escalation are not modeled.
  • Cash collection percentage is a simplified period estimate and not an accounts-receivable schedule.

Reference

Key terms

Desk-month
One desk-equivalent made available for one billing month.
Realized volume
Planned desk-months remaining after the entered vacancy or loss share.
Unit contribution
Membership revenue less variable service cost per realized desk-month.
Break-even volume
Gross desk-months needed to cover fixed cost under entered assumptions.

Important note

Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.

Frequently asked questions

Should private offices be entered as desks?

Only if office revenue and cost are first converted to a consistent desk-equivalent.

Does the page calculate occupancy percentage?

The entered vacancy or loss rate determines realized volume; use physical capacity as planned volume.

Where should rent be entered?

Include it in fixed cost per period.

Why can cash profit differ from operating profit?

Cash profit applies the entered collection rate to recognized revenue.