Financial Modeling in Excel For Dummies
Description
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.
Table of Contents
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