The $6 Billion Spreadsheet

Every great business decision begins with a number. This book shows you how to build the ones that matter. A spreadsheet error cost JPMorgan Chase $6 billion. A flawed risk model helped trigger the worst financial crisis since the Great Depression. A copy-paste mistake lost a Canadian power company $24 million in a single afternoon. These were not failures of intelligence. They were failures of craft. $6 Billion Spreadsheet is the book that teaches you the craft — from the ground up, without the jargon, without the intimidation, and without a single wasted page. Whether you are an analyst building your first three-statement model, a CFO who wants to finally understand what your team is producing, an entrepreneur preparing for a funding round, or a project finance professional who needs institutional-quality outputs on deadline — this is the playbook you have been waiting for. What makes this book different from every other finance textbook on the shelf? It does not just explain concepts. It builds them. Across twenty chapters and five parts, you will follow a complete journey from accounting fundamentals to advanced valuation — with real-world examples, industry benchmarks, cautionary tales, and step-by-step model walkthroughs at every stage. You will learn: The accounting backbone that every financial model is built on — the three linked statements, accrual versus cash, and why profitable companies go bankrupt The Six Pillars of an accurate financial model: revenue forecasting, cost structure, working capital, capital expenditure, debt financing, and tax How to build a fully linked Income Statement, Balance Sheet, and Cash Flow Statement that balances every single time The Ten Golden Rules that separate professional models from dangerous ones How to perform DCF valuation, scenario analysis, and sensitivity testing like an investment banker The advanced techniques used in project finance: DSCR, LLCR, sculpted debt repayment, and covenant modelling How to avoid the twenty most expensive modelling mistakes — including the ones that have cost real companies billions And unlike most finance books, this one is honest. It tells you where models fail, why analysts get them wrong, and what the difference looks like between a model that tells the truth and one that flatters its author. Because a model that misleads a decision-maker is not just wrong — it is dangerous. By the final chapter, you will have the knowledge to build models that are accurate, auditable, and genuinely useful. Models that answer real questions. Models that hold up under scrutiny from investors, lenders, and boards. Models that give you an edge. This is not a textbook. It is a practitioner's playbook.