Minor in Financial Modelling

Minor in Financial Modelling | MinorInFinancialMdln

Financial modelling is a representation in numbers of a company's operations in the past, present, and the forecasted future. Such models are intended to be used as decision-making tools. Company executives might use them to estimate the costs and project the profits of a proposed new project. Financial analysts use them to explain or anticipate the impact of events on a company's stock, from internal factors, such as a change of strategy or business model to external factors such as a change in economic policy or regulation.

Financial models are used to estimate the valuation of a business or to compare businesses to their peers in the industry. They also are used in strategic planning to test various scenarios, calculate the cost of new projects, decide on budgets, and allocate corporate resources. Minor in Financial modelling will help the student to prepare basic financial models using Microsoft excel and enrich their knowledge and experience, enabling them to understand the financial aspects of an organisation and its presentation; thereby expanding their career opportunities.

show more... show less...

Key Information

  • Duration
    3 Year
  • Programme Code
    ST3161
  • Course Type
    Minor Degree
  • Mode of study
    Full time
  • Campus
    Vidyavihar - Mumbai
  • Institute

Objectives

  • To understand the use of different, excel functions
  • To understand the use and importance of different functions related to finance
  • To understand the different components of financial statements
  • To calculate ebitda, carry out expenses and revenue modelling
  • To prepare sensitivity analysis, regression models, DCF model

Learning Outcomes

Student will be able to

  • Use Microsoft excel efficiently
  • Use finance related functions in excel
  • Interpret financial statements using excel and IND AS 1.
  • Calculate EBITDA, expense and revenue models
  • Perform scenario and sensitivity analysis.
Assessment Method

Class participation, Presentation, Practical, Viva/ test, End Semester Exam

List of Courses
  • Basics of Excel
  • Basics of Financial Statements
  • Forecasting
  • Modelling – I
  • Modelling – II

Apply Now Enquire Now