Live recalc

Assumptions

Every driver from Ember's Assumptions tab — AI home-energy manager, 5-year forecast.

Funding / Financingcapital raises

Raise 1
Raise 2
Raise 3
Raise 4 (optional)

User (Home) Growthper year

DriverY1Y2Y3Y4Y5
New homes target
Churn rate
Total homes (active)
New homes vs total (annual)

Subscription RevenueEmber Home / Ember Max

Ember Home
DriverY1Y2Y3Y4Y5
% of homes on Ember Home
Monthly subscription fee ($)
Ember Max
DriverY1Y2Y3Y4Y5
% of homes on Ember Max
Monthly subscription fee ($)
Transaction income (per home / month)
Savings-share revenue ($)
Grid services / VPP revenue ($)
Revenue by category (annual)

Cost Of Goods Soldper year

Driver ($/mo)Y1Y2Y3Y4Y5
Cloud & AI compute
Connectivity & data
Support & success
Payment processing
Hardware & fulfilment
COGS by line (annual)

SalariesTeam

Annual increase %
Recruitment cost (% of 1mo salary)
Team roster (18)
RoleMonthly $Start date
Co-founder & CEO
Co-founder & CTO
Senior Firmware Engineer
Senior ML / Optimization Engineer
Full-stack Engineer
Energy Data Analyst
Head of Growth
Customer Success Lead
Firmware Engineer II
Growth Marketer
Support Specialist
Data / Grid Partnerships Lead
Senior Backend Engineer
Product Designer
VP Sales & Partnerships
Finance & Ops Manager
ML Engineer II
Regional Success Manager
Salary split (annual, from Statements)

(Marketing split shown here doubles as the salary-adjacent cost view; see Dashboard for the full salary-split chart wired to the sheet's own Salary Split rows.)

MarketingTwo spend lines (sheet itself labels both "Indirect Marketing")

Driver ($/mo)Y1Y2Y3Y4Y5
Marketing block 1
Marketing block 2

The live sheet's own Assumptions tab labels both marketing rows "Indirect Marketing" — a pre-existing label duplication in the source, not a build error here. Both feed the P&L's Indirect / Direct Marketing lines respectively.

Marketing spend (annual, from Statements)

OverheadsG&A

Driver ($/mo)Y1Y2Y3Y4Y5
Office & facilities
Software & tools
G&A, legal & accounting
Insurance & compliance
Overheads (annual, from Statements)

Product Development

Driver ($/mo)Y1Y2Y3Y4Y5
Development costs
Product development spend (annual, from Statements)

CAPEXAsset purchases

Asset (Year 1 spend, $)Period to depreciate (mo)Cost
Lab, test & certification equipment
Office fit-out & servers
Field & install tooling

Depreciation on these 3 asset schedules (~$170k/yr, <0.3% of Y5 revenue) is frozen to the live sheet's own computed snapshot in this build — HyperFormula cannot parse the sheet's dynamic OFFSET-based amortization formula, so editing these CAPEX inputs will not re-flow into the depreciation line (Net Income/Cash elsewhere still fully live). CAPEX spend itself flows through Cash Flow and the Balance Sheet in full.

Tax

Annual corporate tax rate
First tax payment date
Tax payment interval (months)

Statements

Profit & Loss, Cash Flow and Balance Sheet · 5-year annual · $ · live.

Profit & Loss

$Year 1Year 2Year 3Year 4Year 5

Cash Flow

$Year 1Year 2Year 3Year 4Year 5

Balance Sheet

$Year 1Year 2Year 3Year 4Year 5

Dashboard

Headline KPIs · live.

Revenue, Gross Profit & EBITDAannual

Cash at year end

Where it goes5yr cumulative spend split

Use of funds5-year waterfall

Revenue by category

COGS by line