Financial Modelling in Excel

PROGRAMME DETAILS

Day One
Introduction to Financial Modelling
What is a model?
Spreadsheet models
Types of models
Principles of Financial Modelling
Steps in model building
Best practice guidelines and spreadsheet modelling standards
Designing for flexibility and scalability
Designing for consistency
Designing for usability and functionality
Designing checks and balances
Using VBA in financial models
Examples
Day Two
Principles of Risk Return
Volatility
Capital Structures
Weighted Average Cost of Capital (WACC)
Cost of Equity Capital
Valuation: Theory and Application
Role of valuation
Approaches to valuation
Accounting concepts behind balance sheet, income statement and cash flow
Analysing past performance
Discounted cash flow modeling
Adding Risk Techniques to financial analyst/valuation model
Sensitivity analysis and an introduction to Monte Carlo Simulations
Interpreting results
Examples
Day Three
Financial Model Auditing/Review
Why is Audit?
Excel’s auditing tools
Automated testing tools: role, purpose and limitations
Model documentation
Overview, purpose, advantages, disadvantages
Demonstration
Day Four
Reporting
Management Reporting and Forecasting
Reporting
Consolidations
Analysis of company financial data
Examples
Exercise: Produce a management summary report with charts