Front cover of Financial Statement Modeling manual in Basic Package

Financial Statement Modeling is the foundation of all subsequent valuation modeling modules.

Trainees learn how to build full, dynamic financial statement projection models in Excel from scratch, using real case studies, industry best practices, and sensitivity analyses.

Simple, intuitive, step-by-step instructions reinforce theoretical intuition while teaching the mechanics of the model building process.

Introduction

• Learn to integrate assumptions and drivers into financial models
• Excel techniques and shortcuts for financial modeling
• Learn formatting and structural best practices
• Learn Implications of new FASB and IFRS regulations on financial models

Project the core financial statements

• Income statement , Balance sheet , and Cash flow statement
• Supporting schedules: Working Capital, Deferred Taxes, PP&E / Depreciation, Intangible Assets, Retained Earnings , and Debt & Interest
• Financial Ratios Output Sheet

Error-Proofing

• Learn best practices for check models for errors, accuracy and integrity
• Check and fix circular reference and iteration problems (#REF)
• Insert circularity toggles and learn other tools for formula auditing
• Customize Excel for effective modeling using macro shortcuts
• Balancing the model and inserting automated crosschecks

Presentation and Scenarios

• Perform sensitivity analysis using data tables
• Perform scenario analysis using data validation
• Integrating drop down menus and other “bells & whistles”