Type in the blue cells. The chain on the right rebuilds itself as you go.
THE GOAL
Gross commission you must earn—
...of which comes from listings—
...of which comes from buyers—
LISTING SIDE, WORKED BACKWARDS
You keep this much per listing sold—
Listings that must close—
Listings you must sign—
Listing appointments you must hold—
Listing leads you must generate—
BUYER SIDE, WORKED BACKWARDS
You keep this much per buyer closing—
Buyer sides that must close—
Buyer agreements you must sign—
Buyer appointments you must hold—
Buyer leads you must generate—
THE WEEK IN FRONT OF YOU
Closings for the year—
Closings per month—
Average gross commission per closing—
New leads to generate each week—
Appointments to hold each week—
CONVERSATIONS EACH WEEK—
Spare capacity each week—
Conversations per working day (5-day week)—
Weekly Plan
One row per week. Log what you actually did. Target and gap fill themselves in.
Week starting
Conversations
New leads
Appts set
Appts held
Agreements signed
Under contract
Closings
Commission banked
Conversation target
Ahead / behind
What happened this week
1
—
—
2
—
—
3
—
—
4
—
—
5
—
—
6
—
—
7
—
—
8
—
—
9
—
—
10
—
—
11
—
—
12
—
—
13
—
—
14
—
—
15
—
—
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: August 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.