Financial & Managerial Modelling

This course is designed to provide a comprehensive coverage of different aspects of financial and managerial concepts by using Excel, and to provide participants with an understanding of the importance of financial modeling in a globalized business environment. The course will concentrate on budgetary controls, cost management, Investment Appraisal &presentation of financial statements.

In the other hand the course will deal with financial modeling of various financial assets, interest rates, exchange rates. It will deal with the valuation of financial products regarding the cost.

Main Goals of course :

To discuss and practically understand the financial Modelling for non-financial participants through using critical thinking, managerial techniques, technical support, and direct implementation by Excel.

At the end of each training day, we are expecting to cover the main outlines as below:

Day 1: Financial risk management / valuation

  • The importance of valuation.
  • Understanding enterprise value and equity value.
  • Financial Risk Management.
  • Evaluation of financial risks.
  • Project valuation.
  • Preparing of  financial plan.
  • Using Excel in finance

Day 2: presentation of financial statement

  • Link the three financial statements using formulas and calculations in Excel with model design and structure .
  • Build a financial forecast based off assumptions – use drivers to create an income statement, balance sheet, and cash flow statement
  • Learn important formulas and functions required to build a dynamic model.
  • Opportunity cost and alternatives modelling

Day 3: Sensitivity Analysis

  • Concept of scenario analysis
  • Create three discrete scenarios – a base case, an upside case, and a downside case
  • Build a scenario chooser and “live case” – use Excel’s CHOOSE function
  • Perform direct and indirect sensitivity analysis
  • Fixed, variable cost / Breakeven point analysis
  • Implementation of Scenario analysis on EPC and other procurement and costing in construction, Oil and Gaz and other Industrial fields.
  • Price elasticity of Demand
  • Two-way sensitivity analysis

Day 4: Useful techniques for modelling & investment Appraisal:

  • Financial functions.
  • Investment appraisal.
  • Interest rate and discounted rate.
  • Net present value NPV.
  • Payback period.
  • Asses the Internal Rate of Return (IRR) by investor type
  • SUM Function, AVERAGE Function, COUNT, MIN and MAX Function , SUMPRODUCT Function , IF Function .
  • Trade finance (Documentary (letter of) credit LC , letter of Guarantee LG
  • financing of Exporting and importing ….)
  • Risk of elements Shown in (off-balance sheet)

Day 5: financial analyzing

  • Financial ratios (profitability ratios , Debt ratios , Activity ratios , liquidity ratio , structure of fund resources ….).
  • Debt recovery report.
  • Traditional and Islamic Banking reports.
  • Tax management and modelling.
  • Financial leverage.
  • Operation leverage.
  • Presentation of ratios.
  • Assess performance of company