The cursor blinks in cell AF207 like a taunting heartbeat. It is 3:47 AM, and the blue light of the monitor has begun to feel like a physical weight against David’s retinas. He is staring at a Seven-year forecast for a company that has existed for exactly Seven months. The absurdity of the task isn’t lost on him, even in his sleep-deprived state. He is currently trying to calculate how a marketing hire in the third quarter of 2027 will impact the LTV/CAC ratio in the spring of 2029. It is a tower of assumptions built on a foundation of guesses, wrapped in the aesthetics of mathematical certainty.
I’m writing this while my left foot is pulsating with a very specific, damp coldness because I just stepped in a mystery puddle in the kitchen while wearing fresh wool socks. It’s that same feeling-the sudden, jarring realization that your environment isn’t as controlled as you thought it was-that David is experiencing. The spreadsheet says he will have 7,777 customers by Year 7. The puddle on my floor says I should have looked where I was walking. Both are reminders that the systems we build to manage reality are often far flimsier than the reality itself.
David clicks ‘Trace Precedents.’ A spiderweb of red and blue arrows explodes across the screen. Each arrow represents a causal link he has fabricated. If he decreases the churn rate by 0.7%, the net present value of the company jumps by $777,000. It’s voodoo. It’s the kind of high-stakes creative writing that would make a novelist blush, yet we call it ‘Financial Modeling.’ We treat these documents as if they are blueprints for a skyscraper, when in reality, they are more like a child’s drawing of a rocket ship. They represent intent, not destiny.
[The spreadsheet is a haunted house where the ghosts are unexamined assumptions.]
The Piano Tuner’s Wisdom vs. Founder’s Fixation
I used to know a man named Drew A.-M., a piano tuner with a temperament as precise as a metronome. He told me once that you can never truly tune a piano to perfection because the wood is constantly breathing. The 87 keys are in a state of perpetual rebellion against the strings. If you tune the middle C to a perfect frequency, the humidity change from a single rainy afternoon will pull it 7 millihertz out of alignment by nightfall. Drew A.-M. didn’t see this as a failure of his craft; he saw it as the nature of the instrument. Founders, however, rarely have Drew’s zen-like acceptance of volatility. They want their Excel sheets to stay in tune forever. They want the 47 variables they’ve hard-coded into their ‘Assumptions’ tab to remain static in a world that is fundamentally fluid.
This desire for precision is a trap. David is currently falling into it. He believes that if he can just find the ‘correct’ number for his virality coefficient in Year 7, the investors will finally see the brilliance of his vision. He is missing the point entirely. Investors don’t actually believe the $107 million revenue target he’s projected for the future. They aren’t looking for a crystal ball; they are looking for a stress test. They want to see if David knows which levers to pull when the wood starts to warp and the strings start to snap.
Investor Focus: Stress Test vs. Certainty
Belief in Static Projections
Understanding Volatility
Novelists of the Balance Sheet
Most financial models are built backward. You start with the exit price you want, and then you manipulate the growth rates until the bottom right cell shows the number that makes you look like a genius. It’s a dishonest way to work, but it’s the standard. We’ve become novelists of the balance sheet. We describe a world where customer acquisition costs never rise, where competitors never enter the fray, and where the economy behaves like a well-trained golden retriever.
When you stop using the model as a thinking tool and start using it as a shield, you’ve lost. You’re no longer preparing for the future; you’re just decorating a fantasy. This is often why external perspective is so vital. Working with a
isn’t just about getting the math right; it’s about having someone who can look at your fictional universe and tell you where the plot holes are. It’s about moving from ‘What number makes me look good?’ to ‘What logic holds this business together when things go wrong?’
I’m still thinking about my wet sock. The irritation is localized, but it’s distracting enough to ruin my focus. Financial models have their own version of wet socks-small, ignored errors in the logic that eventually soak through the entire narrative. Maybe it’s a failure to account for credit card processing fees, or a misunderstanding of how long the sales cycle actually takes. These aren’t just ‘small’ mistakes; they are the puddles that tell you your house has a leak.
The Grind to ‘Final’
(The file name reads: ‘Final_v7_ActualFinal_V2.xlsx’)
David finally hits ‘Save.’ The file is named ‘Final_v7_ActualFinal_V2.xlsx.’ He knows it’s a lie. Tomorrow, he will wake up and realize that his hiring plan is too aggressive or that his server costs are too low. He will dive back into the rows and columns, tweaking the 77 different parameters he’s created to simulate a world that hasn’t happened yet. He is a novelist who will never finish his book because the characters-his customers, his employees, his rivals-keep rewriting the script on him.
We create these complex artifacts to give ourselves the illusion of control. The spreadsheet is a psychological defense mechanism against the chaos of the market. If we can map it out in 27 columns, surely we can master it. But the market doesn’t care about your nested IF statements. It doesn’t care about your elegant XLOOKUPs. It only cares about value.
Drew A.-M. once said that the best way to keep a piano in tune is to play it. The vibration of the music actually helps the strings settle into their tension. Perhaps the same is true for startups. The best way to ‘tune’ your financial model isn’t to sit in a dark room at 3:47 AM tweaking Year 7 projections. It’s to get out into the world and actually build something. The data you gather from 7 real customers is infinitely more valuable than the 777 hypothetical ones you’ve programmed into your growth engine.
The Power of 7 vs. 777
Precision is the consolation prize for those who lack a plan.
Precision is the consolation prize for those who lack a plan.
The Diagnostic of Thought
There is a specific kind of beauty in a well-constructed model, though. When the logic flows clearly from one tab to the next, when the drivers are transparent and the risks are laid bare, it becomes a piece of art. It’s not a map of the destination, but a map of the founder’s mind. It shows how they think about scale, how they perceive risk, and how they prioritize resources. In that sense, David isn’t just wasting his time. He’s performing a diagnostic on his own strategy. He’s finding the contradictions in his own thinking.
By the time he finally goes to bed, his wet sock has mostly dried on his foot, leaving a stiff, uncomfortable patch of wool. He’s too tired to change it. He falls asleep dreaming of cells turning green and ratios that actually make sense. He’s convinced himself that he’s ready for the pitch, but the truth is that the model is only the beginning. The spreadsheet is the script, but the performance happens in the real world, where the wood warps, the puddles are cold, and nothing ever adds up to exactly 107%.
We need to stop pretending that the numbers are the point. The point is the conversation that the numbers start. If your model doesn’t provoke a difficult question, it’s not a model; it’s a brochure. And in a world where everyone is writing fiction, the person who tells the most grounded, honest story-the one who acknowledges the damp socks and the out-of-tune strings-is usually the one who gets the funding.