Illustrative demonstration only. All data shown is synthetic and generated for this demo. Not official Toyota data. Toyota name and logo are used for illustrative purposes and this material is not affiliated with or endorsed by Toyota Motor Corporation.
← Back to the lakehouse demo

TMA FY2026 Financial Performance

Toyota Motor Asia — Actual vs Budget | Apr 2025 – Mar 2026 | Generated 20 Aug 2026
$20M Below Plan
i

Sum of gross_margin_usd from tma_sales.fact_sales_monthly, joined to dim_calendar and filtered to fiscal_year_label = 'FY2026'.

SELECT SUM(s.gross_margin_usd)
FROM tma_sales.fact_sales_monthly s
JOIN tma_shared.dim_calendar c
  ON s.month_key = c.month_key
WHERE c.fiscal_year_label = 'FY2026'
Actual Gross Profit
$500.0M
−$20.0M vs plan (−3.9%)
i

Sum of units_total from tma_sales.fact_sales_monthly for FY2026 (Apr 2025–Mar 2026).

SELECT SUM(s.units_total)
FROM tma_sales.fact_sales_monthly s
JOIN tma_shared.dim_calendar c
  ON s.month_key = c.month_key
WHERE c.fiscal_year_label = 'FY2026'
Retail Volume
163,464
−4,257 units vs plan (−2.5%)
i

Count of markets where actual GP < budget GP. Budget from FY2026_Budget_by_Market_and_Month.csv (Quick Spaces). Actuals from Redshift.

Markets Below GP Plan
3 / 6
Vietnam, Malaysia, Indonesia
i

TMA-wide HEV units / total units from fact_sales_monthly, FY2026. HEV delivers ~14.3% margin vs 11.8% ICE — the key margin lever.

SELECT
  SUM(units_hev)*100.0/SUM(units_total)
FROM tma_sales.fact_sales_monthly s
JOIN tma_shared.dim_calendar c
  ON s.month_key = c.month_key
WHERE c.fiscal_year_label = 'FY2026'
HEV Mix (Margin Engine)
23.7%
45.8% of GP in the FYTD model-level table
Actual vs Budget by Market
i

Gross Profit gap = Actual GP (Redshift fact_sales_monthly, FY2026) minus Budget GP (Quick Spaces CSV). Sorted worst to best. Green = above plan, red = below plan.

i

Unit volume gap = actual units_total − budget_units, aggregated by market for FY2026. Budget from Quick Spaces CSV.

i

Volume split by ICE/HEV/BEV from fact_sales_monthly columns units_ice, units_hev, units_bev, grouped by market for FY2026.

SELECT m.market_name,
  SUM(s.units_ice), SUM(s.units_hev),
  SUM(s.units_bev)
FROM tma_sales.fact_sales_monthly s
JOIN tma_shared.dim_market m ...
WHERE c.fiscal_year_label = 'FY2026'
GROUP BY m.market_name
i

Gross profit by powertrain from fact_sales_by_model joined to dim_model.powertrain, grouped by market. Shows margin leverage: HEV produces outsized GP relative to its volume share.

SELECT mk.market_name, md.powertrain,
  SUM(f.gross_margin_usd) AS gp_usd
FROM tma_sales.fact_sales_by_model f
JOIN tma_sales.dim_model md ...
JOIN tma_shared.dim_market mk ...
GROUP BY mk.market_name, md.powertrain
i

Average gross margin % by powertrain per market from fact_sales_by_model. HEV premium over ICE ranges +1.9pp to +3.2pp across markets.

Market Performance Summary
Market Budget Units Actual Units Unit Gap Gap % Budget GP ($M) Actual GP ($M) GP Gap ($M) Gap %
Vietnam19,66917,104−2,565−13.0%63.8449.72−14.13−22.1%
Malaysia23,53621,396−2,140−9.1%76.9865.89−11.09−14.4%
Indonesia50,26549,766−499−1.0%162.40155.76−6.64−4.1%
Singapore6,7416,74100.0%19.9020.20+0.30+1.5%
Philippines25,51026,032+522+2.0%74.2379.25+5.02+6.8%
Thailand42,00042,425+425+1.0%122.67129.19+6.52+5.3%
TMA TOTAL167,721163,464−4,257−2.5%520.03500.01−20.03−3.9%

CFO Insights & Recommendations

Data Sources: Redshift Lakehouse (tma_sales, tma_shared schemas) · Quick Spaces (FY2026_Budget_by_Market_and_Month.csv)
Period: FY2026 (Apr 2025 – Mar 2026)