Financial Modeling in Excel for Dummies

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- Icons Used in This Book -- Beyond the Book -- Where to Go from Here -- Part 1 Getting Started with Financial Modeling -- Chapter 1 Introducing Financial Modeling -- Defining Financial Modeling -- What it is -- Who uses it -- Why it matters -- Looking at Examples of Financial Models -- Project finance models -- Pricing models -- Integrated financial statement models -- Valuation models -- Reporting models -- Chapter 2 Getting Acquainted with Excel -- Making Sense of the Different Versions of Excel -- A rundown of recent Excel versions -- Focusing on file formats -- Defining Modern Excel -- Recognizing the Dangers of Using Excel -- Capacity -- Lack of discipline -- Errors -- Looking at Alternatives and Supplements to Excel -- Chapter 3 Planning and Designing Your Financial Model -- Identifying the Problem That Your Financial Model Needs to Solve -- Designing How the Problem's Answer Will Look -- Gathering Data to Put in Your Model -- Documenting the Limitations of Your Model -- Considering the Layout and Design of Your Model -- Structuring your model: What goes where -- Defining inputs, calculations, and output blocks -- Determining your audience -- Chapter 4 Building a Financial Model by the Rulebook -- Document Your Assumptions -- Create Dynamic Formulas Using Links -- Only Enter Data Once -- Model with Consistent Formulas -- Build in Error Checks -- Allowing tolerance for error -- Applying conditional formatting to an error check -- Format and Label for Clarity -- Chapter 5 Using Someone Else's Financial Model -- Considering Templates for Building a Financial Model -- Why templates can be appealing -- What's wrong with using templates -- Why you should build your own model -- Inheriting a File: What to Check For.