Financial modeling best practices
By SuperdayReps · Wharton MBA · ex-Greenhill · investment banking interview coaching
7 min read · updated July 2, 2026
Nobody grades your model on how big it is. They grade it on whether they can trust it. An MD has thirty seconds and one question: can I hand this to a client without it blowing up? A clean, checkable model beats a sprawling, clever one every time. So the whole game is auditability.
Here's the mindset. A model is a chain of decisions someone else has to follow. If a reviewer can't trace a number back to the assumption that drives it, the model is broken, even if the output is "right."
Inputs vs. formulas: the color code
The single most important convention in modeling is separating what you assume from what you calculate. You signal that with font color. This is standard across every bank, so learn it before your first day.
| Color | Means | Example |
|---|---|---|
| Blue | Hardcoded input (an assumption you typed) | Revenue growth of 8% |
| Black | Formula on the same sheet | Prior revenue × (1 + growth) |
| Green | Link pulling from another sheet | Debt balance from the debt schedule |
Why does this matter? Because a reviewer scanning your model needs to know, instantly, which cells are levers and which are consequences. Blue cells are the only ones anyone should ever change. Black and green cells update on their own. If you get this backwards, every review turns into an archaeology dig.
Blue is a promise. It says "this is a judgment call, and it lives here." Every other cell is downstream of a blue cell somewhere. When you can point at any output and walk the chain back to the blue assumptions that produced it, your model is auditable. That's the whole standard.
Keep reading
The rest of this lesson is free with an account
There's about 4 more minutes of Financial modeling best practices below this, plus every other lesson in Financial Modeling. Free account, no card.
Any partner school .edu
Frequently asked
- What does the color coding of cells mean in a financial model?
- Color signals where a number comes from. Blue is a hardcoded input you typed, like an 8% growth assumption. Black is a formula on the same sheet. Green is a link pulling from another sheet. This lets a reviewer instantly see which cells are levers and which are consequences.
- What is plugging a balance sheet and why is it a mistake?
- Plugging is forcing the balance sheet to balance by jamming in a number, like hardwiring retained earnings so assets equal liabilities plus equity. It makes the model look balanced while hiding a real error. When an assumption changes, the imbalance reappears somewhere you will never think to look.
- How should you build error checks into a model?
- Put a visible check formula in every forecast period that computes total assets minus liabilities plus equity, which should always equal zero. Add a sources-equals-uses check on any transaction and a cash tie-out confirming ending cash on the cash flow statement matches the balance sheet cash line.
LearnAI