| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Grow! IMS™ Marketing Budget Calculator | ||||||
2 | Purpose | The purpose of this spreadsheet is to help you determine what your marketing budget should be based on your growth goals. It assumes that you know your marketing numbers from the previous year. If you don't, thats ok. Take your best guess and adjust throughout the year as you validate your numbers | |||||
3 | |||||||
4 | Conventions | Cells that are yellow such as this one should be modified with your numbers. All other cells are calculated by the spreadsheet | |||||
5 | |||||||
6 | How to use | To use this spreadsheet, complete the tabs in order. That is: 1. Complete CPL/CPS sheet with your total paid leads and total conversion rate for those leads. 2. Complete the RPL/RPS sheet with the revenue you generated with your sales from the previous year. 3. Complete the TARGET REVENUE sheet with your target revenue for the upcoming year. *Notes: These numbers assume that your upcoming year performance will be close to your previous years performance. Of course, no one can know that and these numbers should be viewed as a guide to help you set approximate budget numbers. | |||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||