What is Financial Modelling?

‘Financial Modelling’, involves application of accounting and financial concepts combined with quantitative techniques and information systems skills to the business drivers and constraints. In other words, ‘Financial Modelling’ refers to application of accounting & financial concepts and practices combined with Computer based Information Systems and quantitative techniques. It is useful in business and financial planning, projecting business and financial performance, refinement of strategies and plans and decision making.


    Course Overview

    This Course on Preparation of Operational and Financial Models for Hospitality Industry consists of the following Modules

    1. Financial Statements  -Preparation, Analysis and Planning
    2. MIS Statements in a typical hospitality industry unit
    3. Preparation of Budgets
    4. Application of Advanced MS Excel and VBA
    5. Financial Modelling Concepts and Methodology
    6. Preparation of Operational and Financial Models

    The course which spreads into 300 hours involves lectures and / or  self pace learning, recorded lectures, illustration of application of MS Excel and VBA, Assignments, Quizzes,  Project Work and end course assessment.

The course which spreads into 300 hours involves lectures and / or  self pace learning, illustration of application of MS Excel and VBA, Assignments, Quizzes,  Project Work and end course assessment.


Course Overview

This course empowers and equips small and retail investors in Stocks, Shares and other Securities of companies with the knowledge required to read various sections of the Annual Reports of companies and make informed investment decisions. This course consists of the following sections.

  1. Sections of Annual / Periodical Reports
  2. Financial Reporting Framework
  3. Financial Statements Analysis and Company's Guidance
  4. Relative Financial Statements Analysis and Investment Decisions

The course which spreads into 100 hours involves lectures and / or  self pace learning, illustration of application of MS Excel and VBA, Assignments, Quizzes,  Project Work and end course assessment.


 

Course Overview

Certificate Course in Financial Modelling consists of three modules.

  1. Financial statements preparation, financial statements analysis and planning
  2. Application of Advanced Excel in Financial statements preparation, financial statements analysis and planning
  3. Financial Modelling Methodology
  4. Preparation of Financial Models in MS Excel and VBA 

The course which spreads into 100 hours involves lectures and / or  self pace learning, illustration of application of MS Excel and VBA, Assignments, Quizzes,  Project Work and end course assessment.