20h (edited) • General discussion
The Owner's Calculator - free spreadsheet
The calculators from Knowing Your Numbers and Lead Generation & Prospecting as an actual spreadsheet, because nobody works through seven steps in their head.
Six tabs:
GOAL CALCULATOR - start with what you want to take home this year, end with how many calls you need to make this week. It builds the marketing budget your goal requires into the target instead of leaving it out, which is where most goal-setting quietly goes wrong.
BREAK-EVEN - the revenue you have to clear before you earn a dollar. If you don't know that number off the top of your head, start on this tab.
MARGIN BY LINE - which parts of your business actually make money and which are being carried by the rest. Watch the last two columns.
CAC & LTV - fill this one in FIRST. What a customer costs you to win and what they are worth over their whole life. The Goal Calculator cannot be right until this tab is done.
BENCHMARKS - ranges to sanity-check yourself against.
START HERE - the colour legend. Yellow cells are yours to change. Everything else calculates itself.
It comes pre-filled with example numbers so it does something the moment you open it. Type over them. Two lines people skip: the marketing budget and a buffer for unplanned costs. Leave either one out and the take-home number at the top is fiction.
One caveat worth saying plainly: this is arithmetic and rules of thumb, not accounting advice. Run your real numbers past your bookkeeper or CPA before you make decisions on them.
If something breaks, or there's a tab you wish it had, say so in the comments and I'll fix it.
0
0 comments
The Owner's Calculator - free spreadsheet
skool.com/thebuilderstable
For business owners who'd rather compare notes with people who get it than go it alone. Real numbers, honest talk, weekly conversations.
Powered by