Description
Book SynopsisTable of ContentsAbout This Book
The Author
Dedication
PART I: INTRODUCTION TO MODELING
Chapter 1: Modeling and Its Uses
Chapter 2: Principles of Model Design
PART II: ESSENTIALS OF EXCEL
Chapter 3: Menus, Operations, Functions and Features
Chapter 4: Sensitivity and Scenario Analysis
PART III: GENERAL CALCULATIONS AND STRUCTURES
Chapter 5: Growth Calculations for Forecasting
Chapter 6: Modular Structures and Summary Reports
Chapter 7: Scaling and Ratio-driven Forecasts
Chapter 8: Corkscrews and Reverse Corkscrews
Chapter 9: Waterfall Allocations
Chapter 10: Interpolations and Allocations
PART IV: ECONOMIC FOUNDATIONS AND EVALUATION
Chapter 11: Breakeven and Payback Analysis
Chapter 12: Interest Rates and Compounding
Chapter 13: Loan Repayment Calculations
Chapter 14: Discounting, Present Values and Annuities
Chapter 15: Returns and Internal Rates of Returns
PART V: CORPORATE FINANCE AND VALUATION
Chapter 16: The Cost of Capital
Chapter 17: Financial Statement Modeling
Chapter 18: Corporate Valuation Modeling
Chapter 19: Ratio Analysis
PART VI: DATA AND STATISTICAL ANALYSIS
Chapter 20: Statistical Analysis and Measures
Chapter 21: Data Preparation: Sourcing, Manipulation, and Integration
