What Actually Goes Into a Finance Cheat Sheet
A finance cheat sheet is just a compressed reference document. It takes the things you look up constantly and puts them on one or two pages so you aren't digging through textbooks or spreadsheets every time you need a ratio, a formula, or a tax rule. That's the whole idea. People overcomplicate them by trying to make them comprehensive. Comprehensive is the enemy of useful. I built my first one back when I was doing FP&A at a mid-market manufacturing firm. We had a new controller who came from banking and kept asking where the debt covenant headroom calculation lived. I just typed it into a Google Doc along with ten other formulas that showed up in pretty much every model we built. That became our Essential Finance Cheat Sheet and it stayed relevant for three years until we moved to a different ERP and the covenants changed enough that I had to redo the whole thing.
Essential Finance Cheat Sheet
Here's what actually belongs on it. Ratios go in the first section because that's what everyone reaches for. Liquidity ratios like current ratio and quick ratio. Profitability ratios including gross margin, operating margin, EBITDA margin, and net margin. Leverage ratios like debt-to-equity, debt-to-EBITDA, and interest coverage. Turnover ratios such as receivables days, payables days, and inventory days. Write the formula next to each one. Write what a healthy range looks like next to that. Most people skip the healthy range part and regret it when they're reviewing a company and can't tell if a number is good or bad without running a search. The second section should be time value of money formulas. Present value, future value, annuity factors, perpetuity values. Net present value and internal rate of return. These are non-negotiable. If you're doing any kind of valuation work and you're pulling up a PV calculator online every time, you're wasting hours across a quarter. I keep the discount factor table for common rates—8%, 10%, 12%, 15%—right on the sheet. It saves me from opening a financial calculator for routine work. Then there's the accounting conventions section. Revenue recognition principles under ASC 606, the difference between capitalizing and expensing R&D, how lease accounting changed with ASC 842. You don't need the full standard text. You need the decision tree: does this transaction transfer control, is performance obligation satisfied over time or at a point in time, what's the standalone selling price. That's what matters when you're sitting in a meeting and someone asks whether a particular arrangement should be recognized now or later.
How to Build One That Doesn't Become Junk
Start with the problems you actually encounter. Not the problems you might encounter someday. The ones you dealt with last month. I used to build cheat sheets by going through my textbook chapter by chapter. That produced something that looked good but took up forty pages and nobody used it. Now I track my lookups. Every time I open a new document or tab to find a formula or a rule, I log it. After two weeks I have a list of the actual things I need. That becomes the skeleton of the sheet. Keep it to two pages maximum. If it doesn't fit on two pages, you're not being aggressive enough about editing. Remove anything that requires a paragraph to explain. If a concept needs more than two lines, it doesn't belong on a cheat sheet. Put it in your working notes instead and reference them from the sheet. Use consistent notation. I've seen people mix up EBITDA definitions across sections—one place it's adjusted EBITDA, another it's reported EBITDA, and somewhere else it's EBITDA before restructuring charges. This causes real problems when you're cross-referencing numbers quickly. Define your terms once at the top and stick with them.
Get the Full Details
The formatting matters more than you'd think. Color-code the sections. Bold the key formulas. Put the most commonly used items in the top third of the page where your eyes land first. I use a light yellow background for the ratio section and white for everything else. It takes two seconds to find what you need instead of scanning the whole page.
Common Mistakes People Make
The biggest one is treating a cheat sheet like a textbook summary. These documents try to explain concepts rather than serve as quick references. You're not learning the material when you use a cheat sheet. You're applying it. Write for application, not for understanding. A formula with the units and the typical range is more useful than a paragraph describing where it comes from. Another mistake is not updating it. I have a version from 2019 that I found when digging through old files. It still had the pre-TCJA corporate tax rate of 35% and the old GAAP lease guidance. I almost ran a model using the old lease rules before catching it. Whatever tax law or accounting standard changed in the last two years, check whether your sheet reflects it. People also tend to include formulas that are easily generated by their tools. If you're using Excel and you already have a standardized model template with built-in formula references, you don't need those on the sheet. The sheet should contain things that aren't in your tool or that you need to reason about without running a calculation. Conceptual frameworks, decision trees, and rules of thumb belong here. Plug-and-chug formulas belong in your calculator.
A Specific Problem I Ran Into
Last year I was modeling a cross-border acquisition and needed the effective tax rate for a jurisdiction that used a hybrid entity structure. The standard formulas on my cheat sheet assumed a straightforward corporate tax calculation. The actual rate depended on how the flow-through entity was classified under both the source country's rules and the U.S. check-the-box regulations. My sheet had a generic foreign tax credit section but it didn't account for the mismatch. The workaround was adding a small footnote section on the sheet for edge cases like this. I created a quick decision matrix: if the entity is classified as a corporation in the source country and a pass-through in the U.S., calculate the foreign tax credit limitation separately for each jurisdiction and note the potential for dual inclusion income. I kept this as an addendum rather than cluttering the main formulas. It's now in section three alongside other special-case treatments like variable interest entity consolidation rules and transfer pricing safe harbors.
Where These Sheets Fall Short
A finance cheat sheet will not teach you judgment. It gives you the tools but not the context for when to use which tool and when to ignore the formula entirely. I've seen junior analysts apply a standard DCF framework to a company with negative working capital trends and highly cyclical revenues without questioning whether the model structure was appropriate. The sheet told them how to calculate WACC but it couldn't tell them that the discount rate was masking a structural risk in the business. They're also useless for regulatory work that requires citation to primary sources. If you're preparing a filing or responding to an auditor, a cheat sheet won't hold up. You need the actual standard or regulation. Use the sheet for day-to-day analysis and modeling. Go to the source documents when the stakes are high enough to matter in a review. If you're looking for something more formal than a personal cheat sheet, professional organizations like CFA Institute and AICPA publish reference materials that cover the same ground with more depth and authority. Those cost money and they're heavier, but they're useful when you need to validate something your sheet doesn't cover.
Where to Get Started
There isn't one definitive download of an Essential Finance Cheat Sheet that works for everyone. The best ones are personal. Start with a blank document. Open your last three models or analyses and pull out every formula and rule you had to look up. That's your first draft. Refine it over the next few weeks as you add more real problems to it. When it stops growing, it's ready. If you want a starting template, search for the AICPA CPA Exam cheat sheets or the CFA Level 1 formula sheets. They're free and they cover the core concepts accurately. Adapt them to your actual workflow rather than using them as-is. The people who get the most out of these documents are the ones who treat them as living references, not one-time study aids.
