for dummies store - a Wiley Brand
  • Print
  • Share
Financial Modeling in Excel For Dummies (1119357543) cover image

Financial Modeling in Excel For Dummies

ISBN: 978-1-119-35754-4
Paperback
336 pages
April 2017
US $29.99 Add to Cart

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

  • Print
  • Share