The Spreadsheet That Talked Me Out of the Agency Job Everyone Wanted

The email sat in my inbox for two full days before I opened it properly. A senior design role at an agency I'd had a crush on since grad school — the kind of place whose case studies I'd screenshot and saved to a folder titled "someday." Good salary, actual benefits, a title with the word "lead" in it.

My first instinct was to say yes before they came to their senses. My second instinct was to open Google Sheets. What followed was the most honest two hours I've spent on my career, and I want to walk you through it, because the math surprised me — and I built the thing.

Column One: The Money (Which Was Not the Story)

The base salary was roughly 30% more than my best freelance year, and I had to stop and sit with that. On paper, freelancing was losing.

But spreadsheets are only as honest as your rows. So I added the ones people forget:

• Taxes. My freelance rate looks bigger until you remember I pay both halves of Social Security, quarterly, with my own trembling hands. The salary gap shrank by about 8% right there.
• Health insurance. My marketplace plan costs more per month than my car payment. The agency covered most of it. Another chunk gone.
• The commute. Their office was 45 minutes each way in Chicago traffic. At my current rate, that's roughly $6,000 of billable time a year, plus whatever a therapist would charge for what the Kennedy Expressway does to my soul.

When I added it all up, the real gap was closer to 10–12%. Real money! But no longer the kind of money that makes decisions for you.

Column Two: The Hours Nobody Bills

Here's where I got uncomfortable. I made a list of everything I do in a week that a job description would never capture:

• Choosing which clients to pursue (and which to dodge)
• Deciding what my work is even about
• Turning down projects that pay fine and make me feel hollow
• Taking a Tuesday afternoon off because the light was good and my brain needed it

Then I asked: which of these does the job keep? Answer: none. Every single one gets handed to a manager, a pipeline, a Monday-morning standup.

I gave each item a gut-level value from 1 to 10, which is fake precision, I know. But the total was the highest number in the whole spreadsheet, and it lived entirely outside the salary column.

Column Three: Career Compounding, or "Where Am I in Five Years?"

This was the tiebreaker, so I drew two little projection rows.

Scenario A — the agency. I'd learn a ton in year one, honestly. Big clients, bigger systems, people smarter than me down the hall. But years two through five looked, to me, like a narrowing: deeper in their process, more senior in their org chart, increasingly expensive to extract. Prestige compounds, but it compounds on their domain name, not mine.

Scenario B — staying independent. Less shiny. Some months genuinely lean. But every project I took added to my portfolio, my network, my weird specialty. I'd already watched three friends go agency-first and struggle to get their autonomy back at 40. The exit door doesn't stay propped open forever.

The Moment the Numbers and the Gut Finally Agreed

I expected the spreadsheet to be a formality — a rational costume over a decision I'd already made. Instead, it flipped on me halfway through.

Looking at the honest salary gap — a real but survivable 10% — I felt something unexpected: relief. Not FOMO. Relief. My gut, which had been sending vague dread signals since the offer arrived, finally had data to point at. The numbers weren't overriding my instincts. They were translating them.

The surprising part wasn't that I turned it down. It's that turning it down stopped feeling brave the moment the spreadsheet was done. It just felt like arithmetic.

If You're Holding a Similar Offer

A few things I'd do the same way:

1. Price the invisible stuff. Commute, insurance, taxes, the psychological cost of a badge. Most "dream salary" comparisons skip half the ledger.
2. Put a number on autonomy. List what you'd lose control of, and rate how much each one matters. Be ruthless. "I'd miss picking my projects" scored higher for me than any dollar figure.
3. Project five years, not five weeks. Prestige is front-loaded; ownership is back-loaded. Decide which compounding curve you're buying.
4. Let the spreadsheet argue with you. I genuinely expected it to say yes. If your math keeps saying yes, take the job! The point isn't freelancing. The point is deciding on purpose.

I sent the decline on a Thursday, from a coffee shop, at 11 a.m., in sweatpants. The salary would've been nice. But so is owning the whole spreadsheet — including the rows nobody else gets to fill in.