Capstone
Ayuntamiento de MadridIE MRED 2026 · the city's view
auto-saved · synced with main model
Municipality perspective · interactive

The city's view

+€2.78 bnNet municipal position · 30 yr
72,477 residents 29,470 inhab/km²

The same ALMA densification, seen from the municipality. New residents bring tax but cost more in services; the city receives serviced land & a cession value, and must fund the transport, schools and health infrastructure the new population needs. Everything below reacts to the density & mix inputs. est = working estimate, not an appraised figure.

Density decides the public case

Infrastructure is not fixed — metro, tunnel and facilities scale aliquot to the resident count. But the net position still grows strongly with density, because the tax revenue on a growing stock outpaces the aliquot infrastructure and the marginal services it needs.

OriginalFAR 0.39 · today
Proposedblended FAR 0.97
Residents
14,770
37,651 ×2.5
Net density · inhab/km²
6,006
15,310 ×2.5
Operating result · 30 yr revenue − opex
€510 m
€2.99 bn ×5.9
− Net investing · capex, city-funded aliquot to residents
−€43 m
−€212 m aliquot to residents
= Net municipal position · 30 yr
+€467 m
+€2.78 bn
Even at today's low density the district is already +€467 m positive over 30 yr. Densifying lifts the resident count almost five-fold — so the aliquot infrastructure and services rise too (net investing −€43 m → −€212 m) — yet the net position still grows ×5.9 to +€2.78 bn, because tax revenue on the larger, appreciating stock scales faster than the infrastructure it funds.
Phase Iland 737,797 m²
Density · GFA / land0.80 m²e/m²
Affordable + social (% of housing)50 %
Phase II & IIIland 1,721,525 m²
Density · GFA / land1.05 m²e/m²
Affordable + social (% of housing)61 %
Assumptions est · all editable, everything reacts
Demand & population
Avg dwelling · m² útil
Persons per dwelling
Residential · % of GFA%
Saleable efficiency · % of GFA%
Fiscal · per resident / yr
Municipal cession · % of value%
Municipal tax (IBI+IVTM+fees+PIE)
Marginal cost (not education/health)
Prices & build cost
Sale price · free / economic
Sale price · affordable
Build cost · €/m²e
Construction co. margin (of build)%
Developer margin (of GDV, if city sells)%
City services · unit costs
Residents per bus line
School-age · % of population%
Pupils per school
Tunnel cost · €/m²
Tunnel length · mm
Tunnel width · mm
Metro
Density floor · inhab/km²
Line cost · €M/kmM
Line length · kmkm
Station cost · €M eachM
Stations · n
Inflation · escalation /yr
CPI · materials (capex, build)%
CPI · services (opex, fees)%
HPI · house prices (IBI, cession)%
Urbanised area for density = developable land 2,459,322 m² (2.459 km²). Per-resident figures & unit costs are working estimates typical of Madrid-area municipalities, not appraised figures. Cashflow, IBI, ICIO & fee rates are set inline in section C.
New population est
0 residents
Dwellings est
0
Residential m² útil est
0
Density · inhab/km² est
0
A · Demand & density

Residential floor area becomes dwellings, dwellings become people, people over the urbanised 2.459 km² give the population density that drives metro viability.

0
07,50015,000 inhab/km²
Residential m²e (housing only)0
m² útil (saleable)0
Dwellings (útil ÷ avg dwelling)0
Population (× persons/dwelling)0
Municipal jobs to run it (/1,000 res · cleaning·parks·police·admin·social — not education/health)0
Density · population ÷ 2.459 km²0
B · Municipal fiscal balance
Net annual fiscal balance est
€0
Tax revenue / yr · €915/resident€0
Marginal cost / yr · €900/resident€0
Revenue
€0
Expenditure
€0
Net / yr
€0
Cession · net realisable (land value of the 20%, §C)€0
Serviced public land handed over (0.50 × GFA)0 m²
— redes generales (0.20 × GFA)0 m²
— redes locales (0.30 × GFA)0 m²
Why marginal, not average: the city's average spend is ~€1,800/resident, but most of that is education & health (Comunidad de Madrid competence, not the Ayuntamiento) and fixed costs that already exist. A new district only adds the marginal services above — so comparing marginal tax against average spend would invent a false deficit. On a marginal basis new residents are roughly fiscally neutral; the city's real upside is the one-off cession value & serviced land.

C · City P&L est

The whole municipal case as a P&L — what the city earns (revenue) vs spends (opex + capex), netting to the bottom line. The same money phased over time is in D · Cashflow. Bus, tunnel, schools, health & metro are city capital; IBI, IAE, IVTM, plusvalía & ICIO are city income.

Assumptions CAPEX = bus + tunnel + schools + health + metro · operating = bus + 2% maint. · IBI 0.456% × 50% cad. · ICIO 4% of private build · cession built via contractor at 12% margin · build 15 yr / 3 phases / 30 yr horizon — all editable above & inline.
Legend income / inflow cost / outflow one-off (CAPEX · cession · ICIO) recurring = €/yr
① P&L OVERVIEW · waterfall

What the development gives the city (cession, construction tax, recurring tax) against what it costs (operating + capital), netting to the bottom line. Full detail in the P/L table below (②).

② P/L STATEMENT · by category est
● Revenue · what the city earns€ / yr · over 20 yr
Recurring · €/yr
IBI — property tax (% cad · % mkt)
€0€0
Economic activity (IBI + IAE · retail/office/hotel)
€0€0
Waste tax · tasa de residuos (€/dwelling · mandatory 2025)
€0€0
IVTM + terraces + vados (€/dwelling)
€0€0
Plusvalía · IIVTNU (% built value/yr)
€0€0
State transfer · PIE (€/resident · ingresos del Estado)
€0€0
Current transfers · PICA + grants (€/resident · CM/State/EU corrientes)
€0€0
One-off · income
ICIO — construction tax (% private build)
€0
Works licence fee (% private build)
€0
Cession · net realisable (20% of rights, built & sold)
€0
└ gross sales of the 20%  −  construction  −  builder margin
Total revenue€0€0
● Opex · recurring cost€ / yr · over 20 yr
Bus operating (€1.5M / line)
€0€0
Local services & admin (€/res · water·sewage·lighting·cleaning·police·admin)
€0€0
Green & parks maintenance (€/m²/yr · corridor + parks)
€0€0
Infra maintenance (% of capex)
€0€0
Total opex€0€0
= Operating result (revenue − opex)€0€0
The €/yr column is recurring tax — for the city that is roughly break-even (≈€5 M/yr). The 30-yr total is driven by the one-off cession (the serviced-land value the city receives) + construction tax, delivered as each phase completes — which is why it far exceeds €/yr × 30. The city's real upside is the land cession, not annual tax.
● Capex · one-off capital outover 20 yr
Transport
Bus fleet — 0 line(s) (8 × €400k)
€0
Metro (line + stations · §E)
€0
Road tunnel (0×0 m)
€0
Social
Schools — 0 (€5M ea.)
€0
Health centres — 0 (€4M ea.)
€0
Civic, sports & culture (€M)
€0
Parks & green creation (€/m²)
€0
Total capex€0
Capital transfers · co-funding (PIR · State · EU · regional metro — % of capex)
€0
= Net CAPEX the city self-funds€0
= NET RESULT · over 20 yr (incl. asset value)€0

D · Cashflow — when does the money move? est

The same P&L money phased over the build. The P&L (C) counts the public assets the CAPEX creates; this cash view does not — it shows the funding gap the city must pre-finance before taxes & cession catch up.

CAPEX is spent on an S-curve (slow–fast–slow); operating & tax recur once delivered. The city does not get the cession up-front — it arrives in lumps as each phase completes (~3 yr each). The deepest cumulative point is the funding the city must pre-finance before the development pays it back. Flows are escalated (CPI materials/services + HPI). Absorption homes/yr → build 15 yr · each phase yr · + tail yr → horizon 30 yr
Build period is derived from density: more density → more dwellings → at a fixed market absorption rate, a longer buildout. Calibrated to real Madrid PAUs — Valdebebas (~14,000 homes) built out over ~15–20 yr, metro only ~yr 20 (2030).

Legend Build curve = S-curve construction intensity · CAPEX out (−) · Cession in (+) as a lump at each phase end ·P1/P2/P3 · Operating out (−) · Revenue in (+, recurring tax + ICIO one-off) · Cumulative green = ahead / red = pre-financing. Highlighted row = peak funding.
Cession · net realisable
€0
Peak funding the city pre-finances
€0
Net at horizon
€0
City cash-positive in

E · Metro sourced

Figures confirmed by Metro de Madrid (M. D. Ortiz Sánchez, 2026): line €100–110 M/km (complete operational km), station €30–50 M (depth 25–45 m, 2–4 slabs), and a density floor of ~5,000 inhab/km² "to begin considering a metro" — looking at density alone, before technical factors. Lead time 1.5 yr design + 2.5 yr construction.

Note: 5,000 is the threshold to begin considering, not comfortable viability — Madrid's densest districts (e.g. Chamberí) exceed 30,000 inhab/km².

Metro — viability verdict
Reality check · density does not get you a metro — us vs the neighbour
MetricEl Cañaveral (neighbour)ALMA (this model, live)
Residents>17,000 now · ~37,000 full0 (at current density)
Density · inhab/km²~6,962 (full build)0 net · 0 gross
vs 5,000 floor×1.4×0 (net)
Occupiedsince ~2017 (~9 yr)from 2027–28
Metronone — buses, no datenot on the current plan
El Cañaveral — the development next door — is occupied since ~2017, has >17,000 residents (heading to ~37,000 across ~14,000 homes), and a full-build density of ~6,962 inhab/km², well above the 5,000 floor. It still has no metro — only buses.
Combined catchment · ALMA + El Cañaveral the real argument
Combined residents0ALMA (model) + El Cañaveral
Combined homes0~28,000 dwellings
Combined gross density0over ~10.1 km² together
The two developments share a border — only the thin Merinas strip between them. A metro station at the shared edge (bulevar del Sílex crossing) would serve both at once. 0 residents across ~10 km² of contiguous new city is a far stronger case to the Comunidad de Madrid than ALMA alone — this is how the metro argument should be framed: not "our 14k homes" but "the El Cañaveral–ALMA corridor."
Who else is waiting for the metro · the SE developments
DevelopmentHomesResidents (target)OccupiedMetroWaiting
El Cañaveral~14,000~37,000 (>17k now)~2017none · buses~9 yr, no date
Valdebebas (NE)~14,000~40,000~2013Cercanías; metro ~2030~13 → ~17+ yr
Valdecarros51,656~135,000urbanisingplanned ~2030+from start
Los Berrocales22,285~58,000homes 2027–29L9 Ahijones-Berrocales ~2030first to get it
Los Ahijones18,724~49,000homes 2027–29L9 station ~2030first to get it
ALMA (this model)~14,000~37–40,0002027–28not on the current planTBD
The whole SE — ~118,000 homes, ~300,000+ future residents — is to be served by one planned metro station (L9 Ahijones-Berrocales, ~2030, still "prevista"). El Cañaveral (occupied 9 yr) & ALMA are not even on it. Metro follows the line route + regional budget, not density. sourced · nuevosureste.es · valdecarros.com
Population vs metro minimum

How many residents the area has versus the minimum the density floor needs (= floor × 2.459 km²). Surplus = metro justified; deficit = residents still missing.

0
metro min
0 residents0
Line capex
€0
0 km × €105M/km
Stations capex
€0
0 × €40M
Total metro capex
€0
line + stations
Lead time ≈ 4 years1.5 design → 2.5 construction
Design 1.5 yr
Construction 2.5 yr
Yr 0Yr 1.5Yr 4 · open
Line cost €100–110M/km (complete operational km); station cost €30–50M each (depth 25–45 m). Capex is not included in the section-C infrastructure total.

Road tunnel — schematic

Bury the main road under a deck that reconnects the new neighbourhood to the park. Deck area = length × width; cost = area × €/m².

Deck length
1,200 m
Deck width
30 m
Deck area
36,000 m²
Cost @ €/m²
€144 m

F · Value coefficient by use

Homogenisation weight for value across uses (free-market = 1.00). Affordable/social carries a 0.50 policy weight; the city's 20% cession is taken on these weighted value units.

Use€/m²Coefficient
Free-market residential€01.00
Affordable / social€00.00
Economic€00.00
Social 0.43 Residential 1.00 Economic 1.00
Value weight (homogenisation coefficient) used for the aprovechamiento cession: free-market & economic = 1.00, affordable/social = 0.50 (VPO policy weight, per the Excel model).
Levers & assumptions · edit anything, everything reacts
Method: residential GFA is generated from the phase densities on the total-land basis (GFA = density × each phase's land share, phases 30 / 35 / 35 % of the 4.73 M m² total — matches the Excel Model), split residential / economic and affordable / free, converted to m² útil, dwellings and population. Population over the urbanised developable area (2,459,320 m² = 2.459 km²) gives the density that drives metro viability. Fiscal balance, infrastructure capex and the cession value all react live. All figures are working assumptions for this model, not appraised values.
Informational only — an internal analytical model, not an investment prospectus or a public offering of securities. All figures are indicative and not guaranteed.
Net municipal position · 30 yr+€1.17 bn
Phase I density0.80
Phase II & III1.05