Module 1: 3 Statement Model in Finance
Introduction
Types of financial models
Forecasting revenues down to EBITDA
Financial modeling best practices
Complete cash flow statement
Model setup and assumptions
Forecast capital structure
Review and audit
Case study
Module 2: Forecasting and Budgeting
Introduction to forecasting and budgeting
Forecasting techniques
Applied budgeting tools and techniques in Excel
Solver tool
pivot tables in Excel
Goal seek tool in Excel
Budgeting within a strategic framework
A practical guide to developing budgets
Tracking budget performance with variance analysis
Barriers to strategy execution
Interactive exercise
Building a robust budgeting process
Three categories of budgets
Retail company example
The master budget
Top-down vs bottom-up involvement
Steps in the budgeting process
Manufacturing company example
Psychology and target setting
Module 3: Sensitivity and Scenario Analysis in Excel
Introduction to Sensitivity and scenario analysis
Completed model
Scenario analysis
Presenting results from sensitivity analysis
Model integration
Sensitivity analysis
Module 4: Fundamentals of Financial Analysis
Introduction to financial analysis
Cash flow statement analysis
Profitability analysis
Financial ratios
Balance sheet analysis and ratios
Case study
Module 5: Pitchbooks and PowerPoint
PowerPoint tutorial
Layout overview
Formatting techniques
Design methodologies
Style
Principles
Timeline
Structure
Interactive exercise
Presenting live
Setting up functions in PowerPoint
Example
Module 6: Principles and Standards in Accounting
Principles in Accounting
Introduction
Fundamental accounting principles
Matching principle
Materiality principle
Historical cost principle
Going concern principle
Consistency principle
Monetary principle
Conservatism principle
Objectivity principle
Accounting for financing fees and transaction costs
Accounting for income taxes
The usefulness of financial information
Accounting for leases
Accounting for business combinations
Detailed accounting standards
Accounting for share-based payments
Module 7: Valuation Modeling in Business
Introduction to corporate valuation
Art vs science
Interactive exercise
Valuation multiples
Weighted Average Cost of Capital (WACC)
Precedent M&A transactions
Equity value vs enterprise value
Discounted cash flow (DCF) model
Comparable company analysis
Case study
Comparable company analysis
Public information book
Using comparable company information to assess acquisition opportunities
Module 8: Data Visualisation and Dashboard
Introduction
Design principles
Visuals
Dashboard
Focusing attention
Context
Module 9: Excel Fundamentals
Introduction
Excel settings
Advanced financial analysis setup
Excel layout
Functions and formulas
IF statements
Yearfrac function
Min, max, small, and large functions
Sum, average, sum-product, and median
Date functions and periods
Examples
1309 G Street NW, Suite 900, Washington, DC 20005, USA
+1 919-503-4999
