Adjust the percentage of target stores operational each year to model different rollout strategies.
Current Configuration: Y1: 40% | Y2: 60% | Y3: 80% | Y4: 90% | Y5: 100%
Annual return on investment
Net profit in present value
Time to recover initial investment
Shows how changes in growth rate and profit margin affect IRR. Green indicates favorable outcomes, yellow is neutral, red requires attention.
Growth Rate → Margin ↓ | -10% | -5% | +0% | +5% | +10% |
|---|---|---|---|---|---|
| -10% | 427.6% | 437.6% | 447.6% | 457.6% | 467.6% |
| -5% | 435.1% | 445.1% | 455.1% | 465.1% | 475.1% |
| +0% | 442.6% | 452.6% | 462.6% Base | 472.6% | 482.6% |
| +5% | 450.1% | 460.1% | 470.1% | 480.1% | 490.1% |
| +10% | 457.6% | 467.6% | 477.6% | 487.6% | 497.6% |
Interpretation: Base scenario (center, gold border) shows 462.6% IRR. If growth drops 10% and margins compress 5%, IRR falls to approximately 435.1%.
Phased market entry plan with Wolfpak partnership. Phase 1 and 2 durations are not yet finalized.
Initial setup, compliance, labeling
First store placements, market testing
Expansion to target store count
Full market penetration, optimization
Important: There is no written commitment from Wolfpak regarding Phase 1 and 2 durations. Timeline estimates above are subject to change based on actual market conditions and negotiation outcomes.
Run 1,000 randomized scenarios to assess risk and probability distributions.
Adjust standard deviations for each variable to model conservative or aggressive risk scenarios.
Lower = Conservative (predictable growth), Higher = Aggressive (uncertain growth)
Reflects uncertainty in pricing power and competitive pressure
Potential for delays or acceleration in store rollout schedule
Click 'Run Simulation' to start the Monte Carlo analysis.
| Year | Investment | Revenue | COGS | Trade Spend | Wolfpak Fee | OpEx | Net Cash Flow | Cumulative CF |
|---|---|---|---|---|---|---|---|---|
| 0 | -$250,000 | - | - | - | - | - | -$250,000 | -$250,000 |
| 1 | - | $9,360,000 | $4,687,500 | $2,640,000 | $101,625 | $936,000 | $994,875 | $744,875 |
| 2 | - | $16,146,000 | $8,085,937 | $4,554,000 | $175,303 | $1,614,600 | $1,716,159 | $2,461,034 |
| 3 | - | $24,757,200 | $12,398,437 | $6,982,800 | $268,798 | $2,475,720 | $2,631,444 | $5,092,479 |
| 4 | - | $32,029,627 | $16,040,479 | $9,033,997 | $347,758 | $3,202,963 | $3,404,431 | $8,496,910 |
| 5 | - | $40,926,746 | $20,496,167 | $11,543,441 | $444,357 | $4,092,675 | $4,350,106 | $12,847,016 |