ABCDEFGH
1
2
3
4
Hello ๐Ÿ‘‹๐Ÿฝ and welcome to the ๐Ÿ’ฐ Marketing Scenario Builder ๐Ÿคฉ
5
Use this spreadsheet to estimate long-term financial metrics based on marketing performance - CAC, LTV and Performance Marketing spending
6
To get started:
7
1. Save a local copy to your Google Drive
8
2. Modify the parameters of Yearly Marketing spending and other spending, CAC (Customer Acquisition Cost), LTV (Life Time Value), and opening balance (in purple) in the 'Yearly view' Sheet as needed. Use our preset sample scenarios for inspiration - but be careful, because they'll override your input. *Note: All current inputs are made up values.
You can also change the assumed cohort's growth pace at the bottom of the 'Cohorts Sheet'.
9
3. Now that you have a basic version in place, it's time to start adding complexity ๐Ÿ˜. Add existing cohorts if you have them. Try adding other cost factors, such as salespeople salary or costs of hosting. Or add collection in addition to revenue to calculate cash flow and "real" rule of X. You're only limited by your imagination and the patience of your CFO.

Good luck!
10
Do you have thoughts or requests? โค๏ธ We'd love to get your feedback.