|Lemonade Stand's Ultimate Profit Margin Calculator for Internet Marketing Agencies|
|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.|
Instructions, Tips, Updates, & More Tools
|Scroll Down to Enter Important Data|
|Agency||Agency Twitter||Latest Revision|
|Lemonade Stand||@LemonadeStnd||12/09/15 - Adjusted layout of The Bottom Line. Adjusted columns in One-Time Projects to be more easy-to-understand.||||
<- Edit these fields. Data will be used to calculate P/L.
<- Edit these fields to save any notes.
|Cell with Black Triangle|
<- Mouseover these cells to see tips, explanations, & other info.
<- Important Labels [ DO NOT EDIT ]
<- Calculated Profit [ DO NOT EDIT ]
<- Calculated Loss [ DO NOT EDIT ]
<- Calculated Low Profit Margin or Outstanding P&L [ DO NOT EDIT ]
|Get Started Here|
|Step 1||Step 2||Step 3|
|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.|
|Set Your Average Hourly Rate Levels|
|Standard||Level 1||Level 2||Level 3||Level 4||Level 5|
|*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.|
|Include the average monthly cost of any additional overhead that will be calculated into "The Bottom Line."|