Type in the blue cells. Zero is a valid answer. An empty line is not.
WHAT THE BUSINESS COSTS
Marketing—
Running the business—
Car and travel—
TOTAL BUSINESS BUDGET—
Which is this every month—
WHAT YOU MUST EARN
Pre-tax profit required—
GROSS COMMISSION REQUIRED—
You keep this much per closing—
CLOSINGS THE PLAN NEEDS—
Closings per month—
Sales volume that represents—
IS THE BUDGET SANE
Closings before you earn a cent—
Expenses as a share of commission—
Marketing and lead spend as a share—
What each closing costs to produce—
What each closing puts in your pocket—
Whole expense budget per closing—
Lead Source ROI
One row per source. Fill spend now, fill the rest as the year goes.
Lead source
Type
Budgeted spend
Hours per month
Leads
Appointments
Closings
Commission earned
Cost per lead
Cost per closing
Lead to closing
Net after cost
Return on spend
Commission per hour
1
—
—
—
—
—
—
2
—
—
—
—
—
—
3
—
—
—
—
—
—
4
—
—
—
—
—
—
5
—
—
—
—
—
—
6
—
—
—
—
—
—
7
—
—
—
—
—
—
8
—
—
—
—
—
—
9
—
—
—
—
—
—
10
—
—
—
—
—
—
11
—
—
—
—
—
—
12
—
—
—
—
—
—
13
—
—
—
—
—
—
Where that leaves you
—
Want it as a spreadsheet you own?
The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts,
and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.
Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.
We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
Last updated: October 2026
Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.