Table of Contents

Introduction 1

Part 1: Getting Started with Financial Modeling 5

CHAPTER 1: Introducing Financial Modeling 7

CHAPTER 2: Getting Acquainted with Excel 15

CHAPTER 3: Planning and Designing Your Financial Model 31

CHAPTER 4: Building a Financial Model by the Rulebook 49

CHAPTER 5: Using Someone Else's Financial Model 65

Part 2: Diving Deep into Excel 89

CHAPTER 6: Excel Tools and Techniques for Financial Modeling 91

CHAPTER 7: Using Functions in Excel 121

CHAPTER 8: Applying Scenarios to Your Financial Model 159

CHAPTER 9: Charting and Presenting Model Output 181

Part 3: Building Your Financial Model 211

CHAPTER 10: Building an Integrated Financial Statements Model 213

CHAPTER 11: Building a Discounted Cash Flow Valuation 247

CHAPTER 12: Budgeting for Capital Expenditure and Depreciation 257

Part 4: The Part of Tens 275

CHAPTER 13: Ten Strategies for Reducing Error 277

CHAPTER 14: Ten Common Pitfalls to Avoid 287

Index 299

About the Author

Danielle Stein Fairhurst is the principal financial modeler for Plum Solutions with many years' experience in the field. Her "Financial Modelling in Excel" LinkedIn group has more than 40,000 subscribers. She is also the author of several articles and other books as well as a financial modeling newsletter.