| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||
2 | ||||||||||||||||
3 | PPC Budget Forecast | |||||||||||||||
4 | ||||||||||||||||
5 | Tip: | Only edit content that is BLUE | ||||||||||||||
6 | Set Your Country (Currency) | USD | ||||||||||||||
7 | STEP 1 Enter Your Business Information and Select Industry | |||||||||||||||
8 | Q1 | Select Your Industry | Legal | |||||||||||||
9 | ||||||||||||||||
10 | Q2 | How Much do you sell your product for? | $5,000.00 | |||||||||||||
11 | Q3 | What does it Cost to produce (COGS) | $2,000.00 | |||||||||||||
12 | Gross Profit Margin | $3,000.00 | (Autocalculates) | |||||||||||||
13 | Profit margin (%) | 60.00% | (Autocalculates) | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | |||||
14 | Enter Your first month Adwords Budget | Ad budget change per month | ||||||||||||||
15 | Q4 | Google Ads budget to spend | $1,000.00 | 2% | $1,000.00 | $1,020.00 | $1,040.40 | $1,061.21 | $1,082.43 | $1,104.08 | $1,126.16 | $1,148.69 | ||||
16 | Clicks | $5.88 | 170 | 173 | 177 | 180 | 184 | 188 | 192 | 195 | ||||||
17 | First Month Website Conversion Rate | Conversion improvement rate per month | ||||||||||||||
18 | Q5 | Website conversion rate | 10% | 0.10% | 10.00% | 10.10% | 10.20% | 10.30% | 10.40% | 10.50% | 10.60% | 10.70% | ||||
19 | Total Website Conversions | 17 | 17 | 18 | 19 | 19 | 20 | 20 | 21 | |||||||
20 | Enter your current lead conversion rate | Forecast improvement rate per month | ||||||||||||||
21 | Q6 | Qualified Lead To Sale Rate | 30% | 1% | 30% | 31% | 32% | 33% | 34% | 35% | 36% | 37% | ||||
22 | Total Web Driven Sales | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 8 | |||||||
23 | ||||||||||||||||
24 | REVENUE | Campaign Totals | ||||||||||||||
25 | Revenue from Conversions | $250,000.00 | $25,000.00 | $25,000.00 | $30,000.00 | $30,000.00 | $30,000.00 | $35,000.00 | $35,000.00 | $40,000.00 | ||||||
26 | COGS from sales | $100,000.00 | $10,000.00 | $10,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $14,000.00 | $14,000.00 | $16,000.00 | ||||||
27 | Gross Profit from Conversions | $150,000.00 | $15,000.00 | $15,000.00 | $18,000.00 | $18,000.00 | $18,000.00 | $21,000.00 | $21,000.00 | $24,000.00 | ||||||
28 | ||||||||||||||||
29 | OVERHEAD EXPENSES | |||||||||||||||
30 | Google Ads Expenses | $8,582.97 | Enter Any Monthly recurring overhead below | $1,000.00 | $1,020.00 | $1,040.40 | $1,061.21 | $1,082.43 | $1,104.08 | $1,126.16 | $1,148.69 | |||||
31 | Agency (Management Service Fees) p/month | $8 | $1.00 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | |||||
32 | Hosting Services | $8 | $1.00 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | $1 | |||||
33 | Insert Additional overhead | $0 | Enter Variable Expenses >> | |||||||||||||
34 | $8,599 | Expenses | $1,002 | $1,022 | $1,042 | $1,063 | $1,084 | $1,106 | $1,128 | $1,151 | ||||||
35 | ||||||||||||||||
36 | REVENUE - EXPENSES | $141,401.03 | Profitability | $13,998.00 | $13,978.00 | $16,957.60 | $16,936.79 | $16,915.57 | $19,893.92 | $19,871.84 | $22,849.31 | |||||
37 | ||||||||||||||||
38 | CUSTOMER REVENUE STATS | |||||||||||||||
39 | Total Marketing CAC | Cost per acquired Customer | $200 | $204 | $174 | $177 | $181 | $158 | $161 | $144 | ||||||
40 | Profit per Customer | Profit per customer | $2,800 | $2,796 | $2,826 | $2,823 | $2,819 | $2,842 | $2,839 | $2,856 | ||||||
41 | ||||||||||||||||
42 | Adwords CAC | Adspend Cost per acquired Customer | $200 | $204 | $173 | $177 | $180 | $158 | $161 | $144 | ||||||
43 | ||||||||||||||||
44 | ||||||||||||||||
45 |  | |||||||||||||||
46 | ||||||||||||||||
47 | ||||||||||||||||
48 | ||||||||||||||||
49 | ||||||||||||||||
50 | ||||||||||||||||