Argentina expansion simulator
Fleet, hub, cash and P&L scenarios to plan entry into Argentina.
Anonymized case · internal system
- Role
- Strategist · Builder
- Stack
- Google Apps Script · Sheets · Financial modeling
The problem
Entering a new country involves investment decisions with volatile assumptions —fleet, hubs, staffing and FX. The board needs comparable scenarios rather than a static spreadsheet that is hard to review.
The system
A web app that models P&L, fleet, hubs, cash and timeline per scenario, with a boardroom presentation mode. I used it to plan Argentina’s entry bottom-up.
One plan, three comparable scenarios.
The simulator brings capacity and cash decisions together to discuss entry into Argentina with visible assumptions. ESC1, ESC2 and ESC3 use the same components for comparison.
- 01
Assumptions
Fleet, hubs, headcount and exchange rates can change the plan. The tool makes those variables visible so the team can discuss what must be true.
- 02
Model
The web app shows P&L, cash and a timeline for each scenario. Changing assumptions lets the team compare their consequences live.
- 03
Decision
Presentation mode brings the alternatives to the board. Each scenario retains an operational and financial basis for the discussion.
What this simulator can evaluate
- Model inputs
- Fleet, hubs, staffing and exchange rates.
- Scenario outputs
- P&L, cash, capacity and timeline; this case compares ESC1, ESC2 and ESC3.
- What the screenshot shows
- The initial Comparison view, before any scenarios have been saved. The interface also shows Deep Dive, Cash and Timeline tabs, plus XLSX and PDF export options.
- Evidence limit
- The image documents the interface and its workflow; it does not show projections, financial figures or actual expansion results.
If you are building oneDesign lesson: define a baseline, assign owners to the assumptions and agree on signals that would call for a new plan. A scenario supports decisions under uncertainty.
Read the Spanish field note on growth and logistics in LATAM →
What changed
The work had to be felt in the operation.
- 01
Comparable scenarios, live
- 02
Basis of the operating-financial plan
- 03
Assumption governance built in
Do you have a similar operating challenge?