Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem! All you need is a basic understanding of Excel to start building simple models with practical hands-on exercises and before you know it, you'll be modeling your way to optimized profits for your business in no time. Excel is powerful, user-friendly, and is most likely already installed on your computer—which is why it has so readily become the most popular financial modeling software.

Introduction

Part 1: Getting Started with Financial Modeling

Chapter 1: Introducing Financial Modeling

Chapter 2: Getting Acquainted with Excel

Chapter 3: Planning and Designing Your Financial Model

Chapter 4: Building a Financial Model by the Rulebook

Chapter 5: Using Someone Else's Financial Model

Part 2: Diving Deep into Excel

Chapter 6: Excel Tools and Techniques for Financial Modeling

Chapter 7: Using Functions in Excel

Chapter 8: Applying Scenarios to Your Financial Model

Chapter 9: Charting and Presenting Model Output

Part 3: Building Your Financial Model

Chapter 10: Building an Integrated Financial Statements Model

Chapter 11: Building a Discounted Cash Flow Valuation

Chapter 12: Budgeting for Capital Expenditure and Depreciation

Part 4: The Part of Tens

Chapter 13: Ten Strategies for Reducing Error

Chapter 14: Ten Common Pitfalls to? Avoid

Index

About the Author
Danielle Stein Fairhurst (Sydney