Essentials of financial modeling in Excel : a concise guide to concepts and methods

1. Modeling and Its Uses 2. Principles of Model Design 3. Menus, Operations, Functions and Features 4. Sensitivity and Scenario Analysis 5. Growth Calculations for Forecasting 6. Modular Structures and Summary Reports 7. Scaling and Ratio-driven Forecasts 8. Corkscrews and Reverse Corkscrews 9. Waterfall Allocations 10. Interpolations and Allocations 11. Breakeven and Payback Analysis 12. Interest Rates and Compounding 13. Loan Repayment Calculations 14. Discounting, Present Values and Annuities 15. Returns and Internal Rates of Returns 16. The Cost of Capital 17. Financial Statement Modeling 18. Corporate Valuation Modeling 19. Ratio Analysis 20. Statistical Analysis and Measures 21. Data Preparation. Sourcing, Manipulation, and Integration

This book offers a comprehensive introduction to financial modeling in Excel, focusing on common concepts and structures rather than the software itself. The book is divided into six parts, covering 21 chapters. Part I introduces financial modeling and factors to consider when designing, building, and using models. Part II discusses the core features of Excel, including operations, calculations, and scenarios. Part III covers fundamental structures and calculations commonly used in modeling, such as growth-based forecasting, ratio-driven calculations, and corkscrew structures. Part IV covers economic modeling, measurement, and evaluation, covering investments, interest calculations, loan calculations, returns analysis, discounting, and present values. Part V covers the core applications of modeling within corporate finance, including cost of capital, financial statements, cash flow valuation, and ratio analysis. Part VI covers statistical analysis and data preparation, manipulation, and integration.