Financial Modeling in Excel For Dummies

Introduction 1Part 1: Getting Started with Financial Modeling 5CHAPTER 1: Introducing Financial Modeling 7CHAPTER 2: Getting Acquainted with Excel 15CHAPTER 3: Planning and Designing Your Financial Model 31CHAPTER 4: Building a Financial Model by the Rulebook 49CHAPTER 5: Using Someone Else's Financial Model 65Part 2: Diving Deep into Excel 89CHAPTER 6: Excel Tools and Techniques for Financial Modeling 91CHAPTER 7: Using Functions in Excel 121CHAPTER 8: Applying Scenarios to Your Financial Model 159CHAPTER 9: Charting and Presenting Model Output 181Part 3: Building Your Financial Model 211CHAPTER 10: Building an Integrated Financial Statements Model 213CHAPTER 11: Building a Discounted Cash Flow Valuation 247CHAPTER 12: Budgeting for Capital Expenditure and Depreciation 257Part 4: The Part of Tens 275CHAPTER 13: Ten Strategies for Reducing Error 277CHAPTER 14: Ten Common Pitfalls to? Avoid 287Index 299