OVERVIEW

The ability to create and understand financial models is one of the most valued skills in business and finance today .When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative. In today’s ever-changing business environment, the capability to just manipulate spreadsheets is not enough. You have to be able to incorporate all the “what if” scenarios and stress test any proposal to its limits. A working financial model can facilitate and improve the reliability and quality of your decision-making. Modelling techniques are used in many different areas, such as investment appraisal, capital planning, budgeting, valuation, financial analysis and forecasting. Banks and businesses worldwide rely on the information produced by financial models – for many it is the key to success.

WHAT YOU WILL LEARN

  • Model design and structure
  • International spreadsheet best practice
  • Testing and auditing a model
  • Forecasting techniques
  • Sensitivity and risk
  • Optimisation and targeting
  • Management dashboards and reporting
  • Understand the different types of financial models and their application
  • Construct models that are robust and scalable
  • Learn financial modeling using advanced Excel tools.
  • Build financial models through stepwise projection of Income statement, balance sheet and cash flows
  • Learn business valuation using comparable and discounted cash flow approach
  • Master Trading Comps valuation (P/E, P/B,EV, EBITDA etc.)
  • Apply scenario and sensitivity analysis
  • Learn circular reference technique and check sheets
  • Design Data Dashboards
  • Produce management reports, summaries and meaningful charts

WHO SHOULD ATTEND

  • CFOs
  • Financial Controllers and Managers
  • Financial and Business Analysts
  • Accountants
  • Corporate Treasury Managers
  • Middle Office Staff

  • Credit managers
  • Risk managers
  • Mergers, acquisitions and buyout specialists
  • Corporate finance staff
  • General Managers

REGISTER NOW
“It has been one of the best course and clearly deserving of the title “Financial Modelling in Excel Masterclass”. The instructor has real life experience and he is able to articulate the instructions quite clearly.”
“This course exceeded my expectations. The instructor is a world-class trainer and made a complex subject very interesting and understandable. My learning curve in Financial Modelling accelerated sharply during the course. I would definitely recommend BIZENIUS for financial modeling courses.”
“The trainer had my full attention throughout the day – a great use of examples and strong teaching style to keep people focused. The course was very informative – I have much to take away. “

Our Upcoming Trainings

SME Banking Masterclass
SME Banking Masterclass
Asset & Liability Management
Asset & Liability Management
Digital Banking Leadership
Digital Banking Leadership
Product Management and Development for Retail Banks
Product Management and Development for Retail Banks

Our Happy Clients