Reverse-Engineer Your 2027 Income Goal: The Worksheet Denver Agents Actually Use

Jerad Larkin

6 hours ago

7 min read

How do you set a real estate income goal that actually turns into a plan instead of a wish?

Start with your target GCI, work backward through your real average commission per closed side and your real lead-to-close rate, then turn the result into a weekly number you can track every Monday.

Every September, I ask agents what their number is for next year. Most give me something round: $150,000, maybe $200,000 if it has been a good year. Almost none of them can tell me how they get there. It is a wish wearing a business plan's clothes.

According to NAR's 2026 Member Profile, the median REALTOR earned $59,200 in gross income from real estate activity in 2025, up from $58,100 the year before, off a median of just nine closed transaction sides. Nine. If your number for 2027 is bigger than that, and it should be, you need a way to know what has to happen between now and December to get there.

That is the reverse GCI method. It is not complicated, and you do not need new software to run it. You need your own numbers, a blank spreadsheet, and about 30 minutes before the fourth quarter gets away from you.

What the Reverse GCI Method Actually Is

Most business plans start at the wrong end. An agent picks an income number, feels good about writing it down, and never connects it to a daily or weekly action. The reverse GCI method flips the order:

Start with the income number you actually want.
Divide by what a closed transaction actually pays you, on average.
That tells you how many transactions you need.
Divide that by your real conversion rate to find how many leads or conversations you need.
Divide by 52 (or 12) to get a weekly or monthly activity target you can actually see on a calendar.

Every number after step one comes from your own history, not a guess. That is what makes it a plan instead of a hope.

Step 1: Pick a Real GCI Number, Not a Round One

Start with what you actually earned last year, from your brokerage's year-end commission statement, not your memory of it. Then decide on a real increase: 15%, 25%, whatever is genuinely achievable given your database, your market area, and how much time you actually plan to work.

If you skip this step and just pick a number that sounds good, every number after it in this worksheet will be fiction too.

Step 2: Find Your Real Average Commission Per Side

This is the step most agents fudge, because they assume a standard percentage. There is no standard percentage anymore. Commission is negotiated deal by deal, and it varies by agent, by brokerage, and by transaction since the industry-wide changes to buyer representation agreements. Do not plug in a rate you read somewhere. Pull your own.

Take your total commission income for the last 12 months and divide it by the number of sides you closed. That is your real number.

For example, say your last 10 closed sides averaged out to $9,000 in commission each after your split and brokerage fees. That is your planning number, not a market average, not what a coach told you, yours.

Denver Metro's median close price sat at $594,495 in August 2026, according to DMAR's August 2026 market data, which tells you what the typical home is selling for right now, but it tells you nothing about what your commission structure actually nets you per side. Only your own statements can do that.

Step 3: Divide to Find Your Transaction Number

GCI goal, divided by average commission per side, equals the number of transaction sides you need this year.

$150,000 divided by $9,000 per side is about 17 sides. That is a real, concrete number you can hold up against your current pipeline and ask, honestly, whether it is realistic.

Step 4: Apply Your Real Conversion Rate

Now work backward one more step. If you know your lead-to-close ratio, from your CRM, from your own tracking, use it. If you close roughly 1 in 20 leads you work, 17 sides means you need around 340 leads or meaningful conversations worked over the year.

If you do not know your conversion rate, that is the actual finding here, not the math. Start tracking it now in whatever CRM you already use so next year's worksheet is built on real data instead of an industry guess.

Step 5: Let Your Database Cut That Number in Half First

Before you go build a lead generation machine from scratch, look at where your business already comes from. NAR's 2026 Member Profile found that the typical REALTOR earned 28% of their business from repeat clients and another 22% from past-client referrals, 50% combined, without a single cold lead involved.

That means half of your transaction number in Step 3 may already be sitting in your database, waiting on a system to activate it rather than a new lead source to chase. I laid out a five-step plan for exactly that in the 2027 database plan post. Run that plan against your database before you spend a dollar on new lead generation.

If your database can realistically deliver half your goal, your Step 4 lead number for new business gets cut in half too, and the whole plan gets a lot more achievable.

Step 6: Turn the Annual Number Into a Weekly One

An annual number sitting in a spreadsheet does not change your calendar. Take your leads-needed figure and divide it by 52. That is your weekly target: calls, notes, database touches, whatever your actual conversion activity is.

This only works if you protect the time to do it. If your calendar fills up with showings and paperwork before lead activity ever gets a slot, the plan stays a spreadsheet forever. I wrote about how to build that protection into your week in this time blocking guide.

Building the Worksheet in Google Sheets

You do not need anything fancier than Google Sheets or Excel. Set up these columns:

Column A: Month. January through December.
Column B: GCI Goal. Your annual number, divided evenly or weighted toward your market's stronger months.
Column C: Avg Commission Per Side. Your real number from Step 2.
Column D: Sides Needed. Formula: equals B divided by C.
Column E: Conversion Rate. Your real number from Step 4, or a placeholder while you start tracking.
Column F: Leads Needed. Formula: equals D divided by E.
Column G: Weekly Activity Target. Formula: equals F divided by 4.3, roughly the number of weeks per month.

Add a column tracking actual closed sides and actual leads worked each month next to the targets, and use conditional formatting to flag any month running behind pace. That turns the sheet from a one-time planning exercise into something you actually open every week.

Revisit the numbers quarterly, not just once in January. Denver Metro's closings fell nearly 19% year over year in August 2026 even as prices held essentially flat, which is exactly the kind of shift that makes a conversion rate you set in the spring stop matching reality by fall. A plan that never gets revised is really just last year's guess with a new date on it.

As an Account Executive with Chicago Title of Colorado, I sit across the table from Denver Metro agents building exactly this kind of plan every week of the year. The ones who write the actual number down and reverse-engineer it consistently outperform the ones setting a goal and hoping the market cooperates.

Three Mistakes That Break the Worksheet

I have watched a lot of agents build this exact spreadsheet and then quietly abandon it by February. It is almost always one of three things.

Using an assumed commission rate instead of a real one. Plugging in a flat percentage because that is what an agent has always heard skips the entire point of Step 2. Your split, your brokerage fees, and your negotiated rate on each deal are yours alone. A borrowed number produces a borrowed plan.
Guessing at the conversion rate instead of tracking it. If you do not know whether you close 1 in 10 leads or 1 in 40, every number after Step 4 is a guess dressed up as math. Start tracking it this quarter even if the first few months are rough data.
Never opening the sheet again after building it. A reverse GCI worksheet only works as a living document. Block 15 minutes on your calendar the first Monday of every month to update actual numbers against the target column, the same way you would check a bank balance.

None of these mistakes are complicated to fix. They just require treating the worksheet as a working tool instead of a one-time exercise you build in September and forget about by the holidays. If you want more context on how the industry's experience gap plays into this, I broke that down in this look at NAR's 2026 Member Profile.

Frequently Asked Questions

What is the reverse GCI method?

It is a way of building a real estate business plan backward: start with your income goal, divide by your real average commission per side to find your transaction number, then divide by your real conversion rate to find how many leads or conversations you actually need.

How many transactions does the average real estate agent close in a year?

According to NAR's 2026 Member Profile, the typical REALTOR closed a median of nine transaction sides in 2025, with a median gross income of $59,200 from real estate activities.

What percentage of a real estate agent's business comes from repeat clients and referrals?

NAR's 2026 data found the typical REALTOR earned 28% of their business from repeat clients and another 22% from referrals by past clients, 50% of production combined, before any new lead generation.

Do I need special software to build a reverse GCI worksheet?

No. A basic Google Sheets or Excel spreadsheet with a handful of formulas is enough to run this. The value is in using your own real numbers, not the tool you build it in.

How often should I update my business plan worksheet?

At minimum quarterly. Market conditions shift enough within a year, as they did across Denver Metro in 2026, that a conversion rate or average commission figure set in January can be out of date by fall.

Want More Tools Like This?

If you want a second set of eyes on your numbers, or you are trying to figure out where your 2027 business can realistically come from before you write the goal down, reach out to me.

Want more tools, tactics, and resources like this? Subscribe to my weekly emails at milehightitleguy.com. I share real estate marketing ideas, AI tools, and exclusive invites to upcoming classes and events across Colorado.