Coliving Financial Model Walkthrough — Lisbon 20-Bed Example

About This Financial Model

This walkthrough builds a complete financial model for a real-world coliving scenario: a 20-room master-leased property in Lisbon, Portugal. We will cover every assumption, calculate startup costs, build a monthly P&L at stabilization, project month-by-month cash flow for Year 1, and run a 3-year projection with sensitivity analysis.

Use this as a template for your own model, adjusting the assumptions for your market. For an interactive version, try our ROI calculator, or download our financial model template.

Key Assumptions

Parameter	Assumption	Notes
Location	Graça, Lisbon	Popular neighbourhood for remote workers
Property type	Former guesthouse, 20 rooms	Mix of room sizes
Model	Master lease	10-year term, 3% annual escalation
Monthly rent	€7,500	3-month deposit + rent-free fit-out
Room mix	14 single (€600-€700), 4 double (€850-€950), 2 en-suite (€900-€1,000)	Weighted average €650/room
Target occupancy	92% at stabilization (month 5+)	Conservative ramp-up
Average length of stay	3.5 months	Mix of 1-month and 6-month residents

Startup Costs Breakdown (€45,000)

Category	Amount	Details
Deposit (3 months)	€22,500	Refundable at lease end
Legal and licensing	€3,500	Lease review, AL license, business formation
Furnishing (rooms)	€60,000	€3,000/room mid-range (20 rooms)
Common area furnishing	€18,000	Kitchen, living room, coworking
Technology	€8,000	Smart locks, WiFi, security, PMS setup
Marketing launch	€4,000	Photography, website, initial ad spend, signage
Insurance (first year)	€2,000	Property, liability, contents
Working capital	€7,000	Cash buffer for first 2 months of operations
Total (excl. deposit)	€102,500
Total (incl. deposit)	€125,000	Deposit is recoverable at lease end

Note: The property has a 3-month rent-free period for fit-out, so no rent is paid during months 1-3 of the lease. First rent due in month 4.

Monthly P&L at Stabilization (Month 5+)

Line Item	Monthly Amount	% of Revenue
Revenue
Room revenue (20 rooms x 92% occ x €650 avg)	€11,960	100%
Operating Expenses
Rent	€7,500	62.7%
Utilities (electricity, gas, water)	€900	7.5%
Internet (500 Mbps)	€80	0.7%
Cleaning (12 hours/week @ €14/hr)	€672	5.6%
Community manager (part-time)	€1,500	12.5%
Maintenance and repairs	€350	2.9%
Software (PMS, accounting, comms)	€200	1.7%
Marketing	€400	3.3%
Cleaning supplies and consumables	€150	1.3%
Insurance (monthly)	€167	1.4%
Miscellaneous	€200	1.7%
Total Operating Expenses	€12,119	101.3%
Net Operating Income	-€159	-1.3%

Wait — the model shows a small loss at 92% occupancy? This highlights an important reality: at €7,500 rent and €650 average room rate, this property is marginally profitable. Let us see what happens when we optimize pricing.

Scenario with optimized pricing (€700 avg)

Line Item	Monthly Amount	% of Revenue
Revenue (20 x 92% x €700)	€12,880	100%
Total Operating Expenses	€12,119	94.1%
Net Operating Income	€761	5.9%

A €50 increase in average room rate transforms the model from a loss to a €761 monthly profit — €9,132 per year. This demonstrates the extreme sensitivity of coliving unit economics to small pricing changes.

Year 1 Month-by-Month Cash Flow

Month	Occupancy	Revenue	Expenses	Cash Flow	Cumulative
1 (fit-out)	0%	€0	€5,000	-€5,000	-€5,000
2 (fit-out)	0%	€0	€3,000	-€3,000	-€8,000
3 (soft launch)	25%	€3,500	€6,500	-€3,000	-€11,000
4	50%	€7,000	€10,500	-€3,500	-€14,500
5	70%	€9,800	€11,500	-€1,700	-€16,200
6	85%	€11,900	€12,000	-€100	-€16,300
7	90%	€12,600	€12,100	€500	-€15,800
8	92%	€12,880	€12,119	€761	-€15,039
9	92%	€12,880	€12,119	€761	-€14,278
10	95%	€13,300	€12,200	€1,100	-€13,178
11	92%	€12,880	€12,119	€761	-€12,417
12	92%	€12,880	€12,119	€761	-€11,656

Year 1 cumulative cash flow: -€11,656. This is the operating cash deficit that your startup working capital must cover. Combined with the €125,000 startup costs, total capital required is approximately €136,000.

3-Year Projection

Metric	Year 1	Year 2	Year 3
Average occupancy	72%	91%	93%
Average room rate	€700	€730	€760
Annual revenue	€121,000	€159,500	€169,700
Annual expenses	€132,600	€148,000	€153,500
Annual NOI	-€11,600	€11,500	€16,200
Cumulative NOI	-€11,600	-€100	€16,100

This model shows break-even on cumulative operating cash flow late in Year 2. Full payback of startup capital (€125,000) would take approximately 10-12 years at this property's current economics — which is marginal.

Sensitivity Analysis

Small changes in key variables have dramatic effects:

Variable Change	Impact on Year 2 NOI
Rent reduced by €500/month	+€6,000 (NOI doubles)
Average rate +€50/room	+€11,000 (nearly triples)
Occupancy -5% (86%)	-€5,200 (near break-even)
Utilities +20%	-€2,160
Adding 2 more rooms (22 total)	+€14,600 (transforms economics)

The lesson: coliving profitability is highly sensitive to the rent-to-revenue ratio. Negotiating even a small rent reduction or achieving slightly higher room rates has outsized impact.

Key Metrics Summary

• Break-even occupancy: 86% (at €700 avg rate)
• Rent-to-revenue ratio: 58-63% (target below 55% for healthy margins)
• CPOR (Cost Per Occupied Room): €658 at stabilization
• NOI margin at stabilization: 5.9% (marginal — target 15-25%)
• Cash-on-cash return (Year 2): 9.2% on capital invested
• Payback period: 10-12 years at current economics

This model reveals that this specific deal is workable but not outstanding. Better economics require: negotiating rent below €7,000, achieving average rates above €730, or adding rooms to spread fixed costs. Use these insights when evaluating your own properties.

Frequently Asked Questions

What is a good rent-to-revenue ratio for coliving?

Target below 55%. Between 50-55% gives healthy margins. Between 55-60% is workable but tight. Above 60% makes profitability very difficult — you need exceptional occupancy and premium pricing to make the numbers work. The example above at 58-63% shows why operator negotiation on rent is so critical.

How conservative should my financial projections be?

For investor presentations, model three scenarios: conservative (85% occupancy, lower pricing, slower ramp-up), base case (92% occupancy, market pricing, 5-month ramp-up), and optimistic (95%+ occupancy, premium pricing). Run your investment decision based on the conservative scenario — if it works at conservative, you have margin for error.

What is the typical break-even timeline for coliving?

Monthly cash-flow break-even typically occurs at month 5-8 (once occupancy exceeds 80-85%). Full startup capital payback varies widely: well-structured deals achieve payback in 18-30 months, while marginal deals (like the Lisbon example above) may take 8-12 years. If payback exceeds 5 years, the deal needs restructuring.

Should I include the security deposit in my total investment calculation?

Yes and no. The deposit is technically recoverable at lease end, so it is not a sunk cost. However, it is cash that is locked up and unavailable for the duration of the lease. Include it in your total capital requirement calculation but note it separately as recoverable. For ROI calculations, you can exclude it or include it depending on whether you are measuring return on total capital deployed or return on non-recoverable investment.