Thu, Oct 22 | Webinar
Financial Statement Modeling Workshop
Financial statement modeling is the foundation of most valuation and transaction analyses. In this workshop, you'll build a full, dynamic financial statement projection model in Excel. You will learn how to structure your model, set up drivers and assumptions and build scenarios and sensitivities.
Eintrittskarten stehen nicht zum Verkauf
When & Where
Oct 22, 2020, 9:00 AM – 5:00 PM
Review key Excel skills for financial modeling
- Basic Excel techniques and keyboard shortcuts
- The most accurate way to perform Excel’s basic functions without the mouse
- Customize Excel’s default settings for effective modeling
Learn to format and structure financial models to limit errors and simplify auditing
- Standard modeling structures and formulas
- Best practices in modeling
- Learn the correct way to check models for errors, accuracy and integrity
- Check and fix circular reference and iteration problems (#REF)
- Tools for formula checking and auditing
Learn how to present financial statement models
- Create a ratios page
- Prepare a model for distribution
- Learn summary and sensitivity analysis using data tables
Financial statement model development
- Learn to build projection drivers
- Learn to integrate assumptions into financial models – learn what makes a good assumption
- Build core statements: Cash flow statement, Balance sheet, Income statement
- Build supporting schedules: Debt schedule, Working capital, Interest schedule, Retained earnings, PP&E analysis
- Understand the interconnectivity of the core financial statements and learn how the cash flow statement, income statement, and balance sheet are linked.
- Learn to apply automatic “balance checks”
- Understand treatment of non-recurring charges and tax implications on financial models
- Understand implications of new FASB regulations on financial models used by investment banks and other financial institutions.
- Prerequisites: Basic accounting and Excel knowledge
- Laptop: Students must bring a laptop running Excel to the session (PCs are recommended but Macs will be fine).