INTRODUCTION


The program aims to empower participants with Model building and Valuation skills through extensive coverage of Modeling, Revenue Build-up techniques and Valuation, all applied on a listed company.


CERTIFICATE OF FINANCIAL MODELING


WHO WILL BENEFIT


The course is aimed at groups with different levels of responsibility:

    • CFOs and finance directors
    • Financial controllers
    • Analysts
    • Accountants
    • Corporate finance personnel
    • Treasury managers
    • Risk managers
    • Middle office staff
    • General managers
    • Personnel in banks, corporate and government who make complex decisions and who could benefit from a modeling approach
    • Academics, business and MBA students


HOW LONG IS THE COURSE


This course is 45 hours. At the end of the course you will take an exam and will be provided a certificate in case you pass the exam.


SYLLABUS



PART A DEVELOPING FINANCIAL MODELS


    1. Overview
    2. Design introduction
    3. Features and techniques
    4. Sample model
    5. Excel model


PART B DEVELOPING FINANCIAL MODELS


    1. Analyzing performance
    2. Cash flow
    3. Forecasting models
    4. Cash flow
    5. Forecasting models
    6. Forecasting financials
    7. Variance analysis
    8. Breakeven analysis
    9. Portfolio analysis
    10. Cost of capital
    11. Bonds/stock
    12. Investment analysis
    13. Risk analysis
    14. Depreciation
    15. Leasing
    16. Company valuation
    17. Optimization
    18. Decision trees
    19. Risk management
    20. Modeling checklist


WHY FIC


    • Personal attention
    • Batch size never exceeds 20
    • Participant will not work on templates
    • “Follow-the-Trainer" approach not used
    • Focus on real world, Excel based application
    • Model Building without ‘plugs’
    • Analysis of Revenue Build up techniques
    • Valuation follows ‘Mckinsey’ Approach
    • Comprehensive Take Home Material