Redwoods Park V2 — Financial Dashboard

Land benchmark coverage — Year 1

—

Active scenario & key assumptions

Low

Mid

High

Land developed—

Office / retail rent—

Office / retail occupancy—

Opex ratio / profit share—

Gross revenue / yr

—

all streams, Year 1

Redwoods net / yr

—

bottom line

Profit share to Bintaro

—

Build cost payback

—

Human capacity

—

at 8 m² / person

Year 1 economics

Gross revenue

—

Operating expenses

—

Profit share out

—

Redwoods net

—

Office vs commercial mix

By developed area

office

retail

By revenue

office

retail

Office / workspace—

Commercial (retail)—

Revenue waterfall

Revenue in

Deductions

Redwoods net

—

Land plan open full map →

Developed / commercialized—

Open space / park—

10-year outlook

Cum. revenue

—

all streams, 10 yr

Cum. Redwoods net

—

after opex + share

Cum. to Bintaro

—

profit share, 10 yr

Stabilised coverage

—

Year 10 vs benchmark

—

Live summary · updates with every assumption · Rp 6.75 B land benchmark · All figures IDR

Land development — master

Commercialized / developed75%

— built · — open space

Share of the leasable commercial GFA commercialised — 9,000 m² office (60%) + 6,000 m² F&B/retail (40%), aligned to the master plan. The BDD, theater, sustainable hub, park & sport areas earn via the creative-economy streams below, not office/retail rent. Rent, occupancy and profit-share scale off the developed area.

Financial scenario — master

Low

Mid

High

Market-baseline assumptions. Sets occupancy, rents, service charge and opex across every tab. The sliders below move with it — fine-tune any of them afterward.

Rent rates / m² / month

Office rent—

Bintaro avg Rp 90k–175k —

Retail rent—

Bintaro avg Rp 90k–175k —

Service charge / m² / month

Office SC—

Bintaro avg Rp 50k–60k —

Retail SC—

Bintaro avg Rp 50k–60k —

Occupancy & other revenue

Office occupancy85%

Retail occupancy80%

Membership revenue /yrRp 0 B

Creative-economy revenue /yr

Function hall & eventsRp 2.5 B

Material LibraryRp 1.2 B

Sponsorship / CSRRp 1.0 B

Weekend & design marketRp 0.8 B

BDD & programming streams on top of office/retail. These feed the P&L, the 10-year projection and the Revenue Plan tab. Membership & co-working are already in the model above.

Cost & profit sharing

Operating cost ratio40%

Profit share to Bintaro32%

—

Rp 0Rp 6.75 B target—

Gross revenue

—

rent + SC + membership

Net profit

—

after opex

Profit share out

—

Redwoods keeps

—

bottom line

Effective rates & sample tenant pricing

Office

Rent /m²/month—

Service charge /m²/month—

All-in /m²/month—

Hot desk (6m²) /month—

Private suite S (25m²) /month—

Private suite M (50m²) /month—

Half-floor (250m²) /month—

Library seat (4m²) /month—

Retail

Rent /m²/month—

Service charge /m²/month—

All-in /m²/month—

Café / kopi (40m²) /month—

Restaurant (200m²) /month—

Mini mart (60m²) /month—

Boutique shop (30m²) /month—

Salon / beauty (35m²) /month—

Pharmacy / clinic (50m²) /month—

Service charge total

Total SC revenue /yr—

Members needed (equal mix Basic / Pro / Premium)

—

Basic Rp 350k · Pro Rp 850k · Premium Rp 1.75 jt /month

Profit & loss — annual

Total revenue

—

all streams

Total costs out

—

opex + profit share

Redwoods net

—

bottom line

Net margin

—

of total revenue

Revenue

Office rent—

Retail rent—

Office service charge—

Retail service charge—

Membership fees—

Creative programs (hall · library · sponsorship · market)—

Gross revenue—

Operating expenses

Staff & management (40%)—

Maintenance & utilities (30%)—

Marketing & programs (20%)—

Admin & misc (10%)—

Total opex—

Net profit (before sharing)—

Profit share to Bintaro (—%)—

Land benchmark (Rp 450k × 15,000 m²)Rp 6.75 B

Coverage surplus / (shortfall)—

Redwoods net profit—

Revenue waterfall

Revenue

Service charge

Costs

Redwoods net

Projection assumptions

Build cost (total)50 B

Synced from the Build Cost tab. Adjust the cost/m² there to update payback, cash flow and the balance sheet.

Opening year2026

Annual rent escalation5%

Annual opex growth3%

Year 1 base rates

Synced from Financial Model tab. Adjust sliders there to update projections here.

Occupancy ramp-up

Year 1 occupancy60%

Stabilised occ. (Yr 3+)85%

Yr 1 → ramp → stabilised from Yr 3

Scenario

Base

Bear

Bull

Standard assumptions as set above.

10-yr cum. revenue

—

all streams

10-yr cum. Redwoods net

—

after opex + share

10-yr cum. profit share

—

to Bintaro

Build cost payback

—

at Rp 50B cost

10-year revenue & profitability

Gross revenue

Redwoods net

Profit share (Bintaro)

10-year P&L detail YoY change arrows

Line item	—	—	—	—	—	—	—	—	—	—	10-yr total

Bintaro land coverage — year by year

Profit share to Bintaro

Rp 6.75 B benchmark

10-year cash flow statement

Operating cash inflow

Cash outflows

Net free cash flow

Cash flow detail

Line item	—	—	—	—	—	—	—	—	—	—

10-year balance sheet

Total assets

Total liabilities

Net equity

Balance sheet detail

Line item	—	—	—	—	—	—	—	—	—	—

Build cost recovery progress

Build cost

—

total investment

Recovered by Yr 10

—

cumulative net

Remaining at Yr 10

—

unrecovered balance

Payback year

—

full recovery

Annual Redwoods net

Cumulative recovered

Build cost target

Year-by-year recovery detail

Parcels

03 — 4,604 m²

05 — 4,585 m²

06 — 3,624 m²

07 — 2,866 m²

Occupancy per parcel

Sync occupancy from Financial Model

Office parcels use the model's office occupancy; retail parcels use retail occupancy; mixed uses the average.

Parcel 03 80%

Parcel 05 85%

Parcel 06 75%

Parcel 07 60%

Use type per parcel

Parcel 03

Parcel 05

Parcel 06

Parcel 07

View mode

Low

High

Developed area

15,075 m²

commercialized GFA

Weighted occupancy

—

area-weighted avg

Productive area

—

m² in active use

Est. annual revenue

—

from occupied area

Office vs commercial (retail) mix

By land area

—office—retail

office

retail

Office / workspace—

Commercial (retail)—

By economics (est. revenue /yr)

—office—retail

office

retail

Office / workspace—

Commercial (retail)—

—

Parcel breakdown

Parcel Area Occupancy Productive m² Est. rev /yr Rev / m²

Parcel 034,604 m² —— ——

Parcel 054,585 m² —— ——

Parcel 063,624 m² —— ——

Parcel 072,866 m² —— ——

Total15,075 m² —— ——

Land productivity & value density

Productive (occupied)

Idle (developed, unoccupied)

Open space / park

Build cost rate

Cost / m²—

Construction cost per m² of commercialized (leasable) GFA. Rp 2 Jt – Rp 20 Jt.

Park / amenity cost / m²—

Lower rate for built-but-non-revenue space (park, plaza, landscape). Rp 0.5 Jt – Rp 8 Jt.

Commercialized vs built

Extra park / amenity built—

Non-productive built area as a % of the commercialized area. Built on top of it — costs money, earns no rent.

Commercialized (productive)—

Park / amenity (non-prod.)—

Total built area—

Productive ratio—

Cost preset (commercialized)

Economy

Standard

Premium

Quick-set the commercialized cost/m². Fine-tune with the sliders above.

Total build cost

—

Cost / m²

—

Blended cost / m² (built)

—

total ÷ built area

Total built area

—

commercialized + park

Total build cost

—

rate × developed area

Cost vs 10-yr net

—

build cost ÷ Redwoods net

Productive vs non-productive cost

Commercialized (productive, earns rent)

Park / amenity (built, no revenue)

Component Of comm. Cost

Structure & shell (comm.)55%—

Fit-out & interiors (comm.)30%—

MEP & services (comm.)15%—

Park / amenity (non-revenue)——

Total build cost100%—

Sensitivity — total cost across the commercialized rate range

—

Ownership · Cap Table

Equity & valuation

Add owners and their stake, and see how it translates into company valuation and each holder's equity — derived live from the Financial Projection. Change any assumption on the Model/Projection tabs and these numbers move with it.

Company valuation

Valuation basis

Valuation multiple5.0×

Implied company valuation

—

Ownership breakdown

—

Cap table

OwnerClassOwnershipEquity valueAnnual profit share

Total———

How this works & what a cap table tracks

Valuation is computed live from the Financial Projection — change a slider on the Model/Projection tabs and this updates.
Equity value per owner = ownership % × company valuation.
Annual profit share = ownership % × stabilised (Yr-10) Redwoods net profit — a simple dividend proxy.
Ownership should total 100%; any gap shows as “unallocated” in the pie.
Full cap tables also track share class, capital invested, price per share, an option pool, and dilution across funding rounds — tell me and I'll extend this into a round-by-round model.

Concept · Creative Economy Hub

Indonesia's Creative Economy Hub

A privately-led creative district that behaves like a public institution — modelled on Thailand's CEA / TCDC and layered with Redwoods Park's commercial & community DNA. Two engines under one roof: a revenue-anchoring commercial core and a defensible, brand-funded creative ecosystem (BDD Center).

Total land

15,000 m²

1.5 ha · Bintaro

Total GFA

~28,000 m²

across 3 floors

FAR

~1.87

3-storey envelope

Existing parking

1,531 m²

communal, south end

Office share

60%

revenue anchor

Two engines

Engine A · Commercial

Redwoods Park

Cash-flow anchor — opens early, builds weekly footfall

Office rent (60% of leasable) — the anchor
F&B market — coffee, resto, food hall
Function hall — corporate venue hire
Basketball & community sport
Weekend market — 33–50 stalls
Retail & convenience store

Engine B · BDD Center

Bintaro Design District

TCDC-inspired — unique, brand-funded, defensible

Material Library — brands pay to display
Co-working & studio rental
Creative & maker space
Black box theater — discourse & performance
Education, workshops & online academy
Membership & brand support

The CEA / TCDC playbook we adopt

Resource & Material LibraryPhysical samples + brand cabinets for architects & designers

Creative EducationWorkshops, seminars, certified programs

Research & DataCreative-economy insight & reports

Incubation & ConsultingBusiness support for creative ventures

Online AcademyContent platform & remote courses

Exhibition & DiscourseShows, talks, community programming

Concept synthesised from the shared CEA / TCDC reference and the Redwoods Park brief. Figures are planning estimates for discussion, not committed projections. V1 remains the original baseline; this Creative-Economy layer lives only in V2.

Master Plan · Zone Layout

Site zoning — 1.5 ha

Schematic arrangement (north → south). The real parcel is a tapering trapezoid along the curved road — click any zone for area, floors & revenue model.

↑ NorthSchematic — not to scale

Basketball Court

Community sport

Function Hall

Events · venue hire

F&B Market

2,000 m² · 3F

Inner Park

Courtyard · market

Office Block

3,000 m² · 3F

Mini Golf & Play

Leisure

Sustainable Hub

Waste mgmt · herbal lab · cooking lab · urban farm · 3,000 m²

Black Box Theater

1,000 m²

Design Center (BDD)

3,000 m² · 3F

Communal Parking & Main Entry

1,531 m² · St. Pd Ranji (south)

Revenue · Planning Model

Revenue scenarios

Year 1 revenue

Rp 14.4 B

first full operating year

Year 3 revenue

Rp 26.8 B

at programme maturity

3-yr growth

1.9×

Year 1 → Year 3

Year 1 revenue by stream —

Computed live from the Financial Model tab.

Three streams worth prioritising

01 · HIGH-MARGIN VENUE

Function Hall by-the-hour

Corporate venue hire for the BSD / Bintaro corridor (Samsung, Astra, Unilever). ~Rp 50 jt / full day, filled 2–3 days a week.

—

02 · RECURRING

"Redwoods Card" membership

One card, all zones — library, co-working day pass, sport, workshop discounts. Makes the community sticky.

—

03 · DEFENSIBLE

Material Library (reversed)

Brands pay to display to visiting architects & designers. 150–400 cabinets at Rp 300–500k/mo, near-zero opex.

—

Three-phase roadmap

Phase 1

Soft launch

Months 0–6

Office leasing & convenience store
Co-working opens
Weekend market begins
Goal: anchor cash flow + footfall

Phase 2

Cultural activation

Months 6–18

Material Library + Design Center
Black box theater programming
Function hall corporate hire
Redwoods Card membership launch

Phase 3

Full ecosystem

Months 18–36

Sustainable Hub labs live
Online academy & research
Sponsorship / CSR at scale
Mature mix: events + sponsorship ≈ 50%

Figures are computed live from the Financial Model and 10-year Projection.