Interactive Power BI-style preview / Project 14

Treasury Working Capital

Treasury view prioritizing AR, DSO, cash runway, FX exposure, liquidity, and collection actions. This HTML version keeps the recruiter-facing interaction visible without requiring Power BI Service access.

Period: QTDRegion: AllBU: AllScenario: Base
cash balance$24.7M+3.8% vs plan
DSO days51needs recovery
overdue AR$6.2M+2.1 pts vs LY
cash runway months14.82 risk flag(s)
driver health score63%weighted from dashboard levers
owner actions3decision queue ready
Trend and forecast call

cash balance versus operating plan

JanDec
Actual / latest viewPlan / benchmark
Driver heatmap

What is moving the decision?

Cash
77%
AR quality
58%
DSO
48%
Collections
68%
Risk driverOverdue AR-$1.6M
Positive driverSupplier terms+$0.7M
Risk driverFX exposure-$0.4M
Scenario table

Decision scenarios

ScenarioPrimary valueGuardrailConfidenceDecision use
Actual$24.7M5162%Current run-rate
Base case$25.7M5169%Commit forecast
Upside$26.9M$6.2M75%Scale winners
Risk case$23.7M14.848%Protect downside
Bridge and ownership

Variance to action bridge

DriverImpactFinance callOwner
Overdue AR-$1.6MRecovery requiredTreasury
Supplier terms+$0.7MProtect momentumCommercial
FX exposure-$0.4MRecovery requiredFinance
Drilldown tabs

Owner action queue

ViewActionMetric / driverPriority
So what

cash balance is the headline signal, but the decision depends on whether the driver movement is structural or temporary.

Now what

Prioritize top overdue customers.

Governance

Bridge signs, scenario totals, and owner actions are reconciled before the pack is used in a management review.

Synthetic portfolio preview. No raw CSV, PBIX, local path, or confidential company data is required for the public site.