Financial Modeling in Excel For Dummies

Cover
Title Page
Copyright
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
      Looking at Examples of Financial Models
   Chapter 2: Getting Acquainted with Excel
      Making Sense of the Different Versions of Excel
      Defining Modern Excel
      Recognizing the Dangers of Using Excel
      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
   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
      Format and Label for Clarity
   Chapter 5: Using Someone Else’s Financial Model
      Considering Templates for Building a Financial Model
      Inheriting a File: What to Check For
      Using Audit Tools to Find and Correct Errors
      Sharing and Version Control
Part 2: Diving Deep into Excel
   Chapter 6: Excel Tools and Techniques for Financial Modeling
      Referencing Cells
      Naming Ranges
      Dynamic Ranges
      Linking in Excel
      Using Shortcuts
      Restricting and Validating Data
      Goal Seeking
   Chapter 7: Using Functions in Excel
      Identifying the Difference between a Formula and a Function
      Finding the Function You Need
      Getting Familiar with the Most Important Functions
      Being Aware of Advanced Functions and Functionality
   Chapter 8: Applying Scenarios to Your Financial Model
      Identifying the Differences among Types of Analysis
      Building Drop-Down Scenarios
      Applying Sensitivity Analysis with Data Tables
      Using Scenario Manager to Model Loan Calculations
   Chapter 9: Charting and Presenting Model Output
      Deciding Which Data to Display
      Conveying Your Message by Charting Scenarios
      Deciding Which Type of Chart to Use
      Dynamic Charting
      Preparing a Presentation
Part 3: Building Your Financial Model
   Chapter 10: Building an Integrated Financial Statements Model
      Getting to Know the Case Study
      Entering Assumptions
      Calculating Revenue
      Calculating Expenses
      Building the Income Statement
      Building the Cash Flow Statement
      Building the Balance Sheet
      Building Scenarios
   Chapter 11: Building a Discounted Cash Flow Valuation
      Understanding How the Discounted Cash Flow Valuation Works
      Step 1: Calculating Free Cash Flow to Firm
      Step 2: Calculating Weighted Average Cost of Capital
      Step 3: Finding the Terminal Value
      Discounting Cash Flows and Valuation
   Chapter 12: Budgeting for Capital Expenditure and Depreciation
      Getting Started
      Output 1: Calculating Cash Required for Budgeted Asset Purchases
      Output 2: Calculating Budgeted Depreciation
      Output 3: Calculating the Written-Down Value of Assets for the Balance Sheet
Part 4: The Part of Tens
   Chapter 13: Ten Strategies for Reducing Error
      Using the Enter Key
      Checking Your Work
      Checking It Again
      Getting Someone Else to Check Your Work
      Documenting Assumptions
      Documenting Methodology with a Flowchart
      Stress-Testing with Sensitivity Analysis
      Conducting a Scenario Analysis
      Taking Note of Excel Error Values
      Including Error Checks
   Chapter 14: Ten Common Pitfalls to Avoid
      The Numbers Don’t Add Up
      You’re Getting #REF! Errors
      You Have Circular References
      The Model Has Too Much Detail
      The File Size Is Out of Control
      Your Model Is Full of “Spaghetti” Links
      The Formulas Are Unnecessarily Long and Complicated
      No One Is Paying Attention to the Model
      You Don’t Want to Let Go
      Someone Messes Up Your Model
Index
About the Author
Advertisement Page
Connect with Dummies
End User License Agreement