The financial and business modelling program facilitates your growth to top-level management by inculcating skills that help you make advanced level decisions that enhance value of the organisation.
The program is designed to equip you with analytical mind in quickly scanning the business news and environment, assess their impact on businesses top and bottom line, also known as revenue and profitability and to also strategize business decisions. The modelling techniques include employment of spreadsheet modelling productively for applications like financing, investment, and valuation decisions. It also equips you with forecasting techniques in order to enhance your visionary insight. The focus will be both of managing financial data as well as making meaningful sense of the data for informed business decisions.
Financial and business acumen is required in all departments, from marketing to operations, purchase, and production, etc. The program is helpful for learners of all background who aspire to manage businesses as employees or entrepreneurs in business start-up. In fact, financial and business modelling acumen helps in your development in organisational hierarchy, because it teaches you to use free software to your strengths and back business decision with data.
This course is developed for professionals aspiring to manage an organisation and make high level business decisions backed by data. In specific, the following will benefit most from the course:
Duration: 4 weeks, 4–6 hours per week
Fees: €1,320 for Non-BSBI student | Free for BSBI students on academic degree programmes
Introduction to Financial Modelling
This module elaborates on the meaning of financial modelling. You will acknowledge the differentiation between a spreadsheet and a financial model including other various types of financial models. The module will cover reflecting on model design, structure, layout and planning to prepare well-thought-out design to project a clear plan for building a model. The golden rules and design flaws will also be discussed.
Modelling Risk and Realities
This module allows you to analyse historical stock returns downloaded from market websites on a daily, weekly and monthly basis. Regression analysis will be conducted to estimate beta. The analysis will help you to build upon portfolio and select stocks for reducing the unsystematic risk. Learning the fundamentals such as mean-variance portfolio selection and modelling formulae will enable you to select stocks very quickly.
Building a Model and Presenting the Output
This module will allow you to build tools using popular techniques, gain an understanding of the most common errors and best ways to avoid them, and reflect upon the issues and decisions a financial modeller will encounter. To prepare the model, you will learn common excel functions that are relevant for business decisions like Pivot, V lookup, finance functions, logical functions, absolute and relative references. Further to this you will review the commonly used input, workings and output presentation of a model.
Forecasting Cash Flows and Modelling Cost of Capital
This module reiterates the fundamentals of accounting and finance such as three financial statements, cost of capital, key variables within the statements and their analysis so as to prepare assumptions for forecasting income statements, balance sheet and cash flows. The module will then elaborate modelling cost of capital that will help value the company or the project.
Stress Testing, Scenarios and Sensitivity in Financial Modelling
Scenarios and sensitivity analysis allows you to perform stress testing and decipher the robustness of your model. It also allows you to understand that future forecasting is subject to market sensitivity, and therefore preparing scenarios to incorporate the same ensures adequate planning and preparing for the future. The accuracy of the scenarios lies in the accuracy of the assumptions forecasted in the model.
After the end of this programme, you will be able to:
Dr. Amina Momin has a Doctorate in Capital Markets having a decade of experience in teaching, guiding and evaluating post graduate students in several business schools in India. She is a renowned Portfolio Manager and Investment Consultant. She has an expertise in Industry-Student interaction and has conducted many national and international conferences.
Her core areas of teaching and research are Finance and Portfolio Management, but, due to her immense academic experience, she is being working with reputable business schools and universities for setting up advanced programmes, mentor and prepare the leaders for tomorrow. She has also been key member of university programs accreditation committees.