Financial modeling in Excel

Description

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. 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