# Financial Model Tabs (Google Sheets Ready)

Import each CSV as a separate tab:
1. assumptions.csv
2. usage_and_revenue.csv
3. costs_and_margin.csv
4. scenarios.csv
5. kpi_dashboard.csv

## Suggested formula links
- `usage_and_revenue!B2` (MRR Pro): `=assumptions!B2*assumptions!B7`
- `usage_and_revenue!B3` (MRR Team): `=assumptions!B3*assumptions!B8`
- `usage_and_revenue!B6` (Pro run volume): `=assumptions!B2*assumptions!B4`
- `usage_and_revenue!B7` (Team run volume): `=assumptions!B3*assumptions!B5`
- `usage_and_revenue!B8` (Total run volume): `=B6+B7`
- `usage_and_revenue!B9` (Total MDT consumed): `=B8*assumptions!B6`
- `usage_and_revenue!B12` (Top-up revenue): `=B11*assumptions!B9`
- `usage_and_revenue!B13` (Total MRR): `=B4+B12`
- `costs_and_margin!B2` (Variable consumed cost): `=usage_and_revenue!B9*assumptions!B10`
- `costs_and_margin!B3` (Top-up sold cost): `=usage_and_revenue!B11*assumptions!B10`
- `costs_and_margin!B4` (Gross profit): `=usage_and_revenue!B13-B2-B3`
- `costs_and_margin!B5` (Gross margin): `=B4/usage_and_revenue!B13`

## Scenario toggle pattern
- Add a dropdown cell `scenario` with values: `Low, Base, High`.
- Use `XLOOKUP`/`INDEX-MATCH` against `scenarios.csv` to swap key assumptions:
  - Pro subscribers
  - Team seats
  - Avg skills per user
  - Avg MDT per run
  - Top-up conversion

## Notes
- Keep all money values in USD.
- Keep MDT as a separate unit column.
- Add charts:
  - MRR split (subscription vs top-up)
  - MDT consumption trend
  - Gross margin trend