Certified Financial Modelling for Decision Making

Day 1: Foundations and Best Practices in Financial Modelling

• Introduction to Advanced Financial Modelling: Purpose and Applications
• Defining the Scope and Structure of Complex Financial Models
• Establishing Best Practices in Model Design and Construction: Layout, Formula Integrity, Documentation
• Avoiding Common Pitfalls and Worst Practices in Financial Modelling

Day 2: Advanced Forecasting Techniques and Technical Study

• In-depth Exploration of Forecasting Guidelines: Linkage, Injection, Time Series Analysis
• Applying Statistical Forecasting Methods: Regression Analysis and its Applications
• Understanding and Implementing Monte Carlo Simulation for Scenario Planning
• Technical Study Deep Dive: Modelling Capital Expenditure, Operational Expenses, Pricing Strategies, and Cost Structures

Day 3: Building the Integrated Financial Statements

• Projecting the Income Statement: Detailed Modelling of Revenue, Cost of Goods Sold (COGS), and Operating Expenses (OpEx)
• Projecting Working Capital: Understanding and Modelling Inventory, Receivables, and Payables
• Projecting Capital Expenditure (CapEx) and Depreciation Schedules
• Developing the Balance Sheet: Ensuring Accounting Equation Integrity and Interlinkages

Day 4: Modelling Capital Structure, Cost of Financing, and Free Cash Flow

• Projecting the Capital Structure: Incorporating Debt and Equity Financing
• Building the Loan Amortisation Schedule for Complex Debt Structures
• Projecting the Cost of Financing: Detailed Calculation of Cost of Equity (CAPM, Multi-Factor Models) and Cost of Debt
• Modelling the Free Cash Flow (FCF) Statement: Deriving FCF from Financial Statements

Day 5: Discounted Cash Flow Valuation and Other Valuation Methods

• Building a Comprehensive Discounted Cash Flow (DCF) Model in Excel: Discount Rates, Terminal Value Calculation
• Calculating and Interpreting Key Feasibility Indicators: Payback Period (PBP), Discounted Payback Period (DPBP), Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index (PI)
• Understanding and Applying Non-Forecasting Valuation Methods: Methods of Comparable, Multiple Screening, Asset-Based Valuation
• Overview of Other Forecasting Valuation Methods: Dividends Discounting, Residual Earnings Analysis, Earnings Growth Analysis