ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
CREATOR PRICING CALCULATOR: HOW TO USE
2
Good luck! Share this sheet, use it, and adjust as your career grows. 💜
3
4
5
QUICK STARTDETAILED WALKTHROUGHCUSTOMIZATION TIPS
6
MAKE A COPY OF THIS FILE
7
STEP 1: MONTHLY EXPENSES TABExpense Customization:
8
1. Go to 'Monthly Expenses' and fill in YOUR costs (grey fields)• Delete placeholder rows and add YOUR expenses• Delete rows you don't need, add rows for costs unique to you
9
2. The sheet auto-calculates your Annual Expenses• Categories: Housing, Food, Health, Software, Tools, Equipment etc.• Update quarterly as expenses change
10
3. Go to 'Income Calculator' — your target income is already calculated• Only fill 'Monthly Cost' column — 'Annual Cost' auto-calculates (×12)
11
4. Adjust 'billable hours' to match your realistic work week• Add as many rows as you need; formulas will auto-extendTaxes & Buffer Customization:
12
5. Go to 'Service Pricing' and see what you should charge• The TOTAL ANNUAL EXPENSES at the bottom auto-updates• US freelancers: Use 25-30% for self-employment tax
13
• Non-US: Adjust based on your country's tax brackets
14
STEP 2: INCOME CALCULATOR TAB• Emergency buffer: Use 20% minimum; 30% if you want more security
15
KEY PRINCIPLESNO EDITING NEEDED, ADJUST IF THE DEFAULT DOESN'T WORK
16
- 30% for taxes (adjust based on your country)Billable Hours Customization:
17
• This sheet shows your MINIMUM rates based on YOUR expenses - 20% emergency buffer (adjust if you want more/less savings)• If you work full-time: 5 days/week, 6 hours/day = 1,440 hours/year
18
• Market rates may be higher (experience, reputation, demand matter) - 10% for reinvestment (tools, learning, growth)• If you're part-time: 2 days/week, 3 hours/day = 288 hours/year
19
Never price below 'Base Rate' — that's you working for freeADJUST BILLABLE TIME IF NEEDED• If you batch work: adjust as needed; be realistic
20
• 'Recommended Rate' is a safe starting point; you can charge more - 48 weeks/year assumes 4 weeks off (vacation, sickness)
21
• Review and update quarterly - 3 billable days/week = realistic (meetings, admin, life happen)Pricing Strategy Customization:
22
- 4 billable hours/day = conservative approach (deep work, no meets)• Use 25% markup for standard work (safe, reasonable)
23
- If you work more, adjust these numbers• Use 50%+ markup for rush jobs, high-visibility, or complex work
24
COMMON QUESTIONSThe sheet calculates your MINIMUM rates you need to charge• Use 10-15% discount for retainers (trade volume for stability)
25
• Use 2x+ markup for niche expertise or specialized services
26
Q: What if I don't work 48 weeks/year?STEP 3: SERVICE PRICING TAB
27
A: If you take 8 weeks off, use 44 weeks instead.• Pre-filled with common services: hourly, projects, day rates, retainers
28
• 'Base Rate' = your minimum (bare survival)
29
Q: What if my project sizes vary wildly?• 'Recommended Rate' = base + 25% markup (profit + buffer)
30
A: Use the 'Hours/Scope' column in Service Pricing to adjust. • Adjust the 25% markup for higher margins (use 1.5 instead of 1.25)
31
Common projects might be 15 hrs, 30 hrs, 60 hrs.• Modify 'Hours/Scope' for services you actually sell
32
33
Q: Should I offer discounts?
34
A: Yes, but only for retainers (recurring revenue is worth discounting).
35
Don't discount one-off projects — you'll run out of money.
36
37
Q: How do I know if my rates are competitive?
38
A: Research your niche (Twitter/Threads, industry surveys).
39
This sheet tells you what YOU need; market rates may be higher.
40
41
Q: Should I use 'Base Rate' or 'Recommended Rate'?
42
A: Always use 'Recommended Rate' or higher.
43
Base Rate is break-even; you need profit.
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100