Type in the blue cells. Set THE HOUSE RULES once; every other tab reads them.
1 · THE REVENUE
(A) TOTAL GROSS REVENUE—
2 · THE HOUSE TAKE — OFF THE TOP
House fee—
3 · THE HARD COSTS (COGS)
(B) TOTAL HARD COSTS—
4 · THE PROFIT CHECK
Total net profit (A − fee − B)—
ACTUAL NET MARGIN—
Distance above the floor—
Distance from the target—
Price this job needed, to clear the floor—
Price this job needed, to hit target—
How far under the floor price it was signed—
5 · THE COMMISSION CALCULATION
Commission tier earned—
Gross commission (A × tier)—
Less: booking draw already paid—
Less: back-charges—
(C) FINAL COMMISSION PAYOUT—
WHAT THE FLOOR JUST DID
Had it cleared the floor, it would have paid—
What pricing it thin cost the closer—
Commission as a share of this job's net profit—
What the company keeps after commission—
AGAINST A FLAT PERCENTAGE
A flat % of revenue would have paid—
What you would have kept, flat plan—
The ladder keeps you ahead by—
Same tier rate, paid on net profit instead—
Job Log
One row per settled job. Margin, tier and commission compute themselves from THE HOUSE RULES.
Settled
Job #
Scope
Gross revenue
Hard costs (COGS)
House fee
Net profit
Net margin
Tier rate
Commission
Company keeps
What happened
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.