Lemonade Stand's Ultimate Profit Margin Calculator for Internet Marketing Agencies
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEF
1
Lemonade Stand's Ultimate Profit Margin Calculator for Internet Marketing Agencies
2
Thanks for using this cool tool with the super long name. :) With this calculator, you'll be able to quickly calculate P&L for your SEO, PPC, & one-time clients while also keeping a running, interactive calculation of your entire book of business. You're free to use it for any private or agency use. I hope it will help make your life just a little bit easier or make things a little more organized for you and your team. Please feel free to contact me with your feedback and please share this tool with your friends and followers. SCROLL DOWN TO GET STARTED.
3
4
CreatorTwitter
Instructions, Tips, Updates, & More Tools
Scroll Down to Enter Important Data
5
John Rowa@JohnRowa
LemonadeStand.org/Ultimate-Profit-Calculator
6
AgencyAgency TwitterLatest Revision
7
Lemonade Stand@LemonadeStnd12/09/15 - Adjusted layout of The Bottom Line. Adjusted columns in One-Time Projects to be more easy-to-understand.|
8
|
9
Key|
10
Blue
<- Edit these fields. Data will be used to calculate P/L.
|
11
Gray
<- Edit these fields to save any notes.
|
12
White<- Informational.|
13
Cell with Black Triangle
<- Mouseover these cells to see tips, explanations, & other info.
V
14
Orange
<- Important Labels [ DO NOT EDIT ]
15
Green
<- Calculated Profit [ DO NOT EDIT ]
16
Red
<- Calculated Loss [ DO NOT EDIT ]
17
Yellow
<- Calculated Low Profit Margin or Outstanding P&L [ DO NOT EDIT ]
18
19
Get Started Here
20
Step 1Step 2Step 3
21
Save a copy of this Calculator to your Google Drive by going to 'File > Make a copy' -- that will be the version you edit.Scroll down and enter in the requested information below in the blue cells. We need the data from you to be able to make calculations within this tool.Select the sheet(s) at the bottom of the browser window that corresponds with your client/project type and fill in only the blue cells to begin calculating your profit margin.
22
23
Set Your Average Hourly Rate Levels
24
StandardLevel 1Level 2Level 3Level 4Level 5
25
$40.00$20.00$30.00$40.00$50.00$75.00
26
*Works on Recurring Clients only.* For agencies with a wide range of clients, this is very useful because some clients often require your higher-wage employees than others. Set up to 5 levels of your staff's average hourly rates to better calculate your employee overhead per client. We chose to use "Levels" instead of allowing individual client rates because this makes it easy to quickly adjust average wages and calculate profit across the board if there are increases or decreases in employee overhead such as insurance costs or wage hikes.
27
28
Additional Overhead
29
Include the average monthly cost of any additional overhead that will be calculated into "The Bottom Line."
30
Office Rent$2,500.00
31
Utilities$700.00
32
Hardware$200.00
33
Software$300.00
34
Hosting$500.00
35
Other Expenses$0.00
36
Total$4,200.00
37
Loading...
 
 
 
Get Started
Recurring Clients
PPC Clients
One-Time Projects
The Bottom Line
Data