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