Understanding business: What will happen to cash if we postpone our product launch?
This was the initial question for building this scenario. We were interested in calculating a cash flow impact under certain input conditions like number of trucks, OPEX etc. to see how the monthly liquity flow changes comparing one scenario A to another scenario B.Â
Scenarioplay
Launch timing · cash & revenue model
Scenario A — early launch
Cash at t = 0 (€)
Launch month
3
Pre-launch burn (€/mo)
6k
Post-launch burn (€/mo)
8k
Price / engagement (€)
3k
Volume at launch (/ mo)
2
Monthly revenue growth (%)
8%
Scenario B — late launch
Cash at t = 0 (€)
Launch month
12
Pre-launch burn (€/mo)
6k
Post-launch burn (€/mo)
7k
Price / engagement (€)
5k
Volume at launch (/ mo)
2
Monthly revenue growth (%)
10%
Cash-out
—
—
Breakeven
—
—
Cash at month 24
—
—
Revenue / month (€)
Cash stock (€)
Monthly profit / loss (€)
Scenario A
Scenario B
Visual analytics instead of Excel: This scenario cash planning is based on two different model types: first you have a linear integration with the fuel price as driving factor and second a buffer model which is represented by the number of trucks and the initial cash amount.Â
Get in touch, if building visual scenarios sounds relevant for you. And yes, you can get this in Power BI (or other platforms) as well. We are glad to hear about your project.Â
Mail to office @designation.eu
Â