WB WorkbookBarn All workbooks

Free calculator · nothing to download

Annual Agent Business Plan

Type in the blue cells. Zero is a valid answer. An empty line is not.

THE TARGET
BUDGET — MARKETING
BUDGET — RUNNING THE BUSINESS
BUDGET — CAR AND TRAVEL
BUDGET — BUYING LEADS

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 sourceTypeBudgeted spendHours per monthLeadsAppointmentsClosingsCommission earnedCost per leadCost per closingLead to closingNet after costReturn on spendCommission 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.

Get the workbook

Keep it

Annual Agent Business Plan — the full workbook

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.

Buy on Etsy · $19.99What is inside →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

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.

WorkbookBarn · All free calculators · Workbooks