Redwoods Park — 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

—

—

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 15,000 m² turned into leasable commercial GFA. The remainder stays as park / open space and earns no rent. All revenue, occupancy and profit-share figures 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

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—

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

—