--For dummies

Includes index

part 1. Getting started with financial modeling: Introducing financial modeling ; Getting acquainted with Excel ; Planning and designing your financial model ; Building a financial model by the rulebook ; Using someone else's financial model -- part 2. Diving deep into Excel: Excel tools and techniques for financial modeling ; Using functions in Excel ; Applying scenarios to your financial model ; Charting and presenting model output -- part 3. Building your financial model: Building an integrated financial statements model ; Building a discounted cash flow valuation ; Budgeting for capital expenditure and deprecation -- part 4. The part of tens: Ten strategies for reducing error ; Ten common pitfalls

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