The programme is designed to improve analytical thinking so that you can quickly scan business news and the general environment and assess the impact on businesses top and bottom line. You will think about revenue and profitability and learn to strategise 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 on both 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 programme is helpful for learners of all
background who aspire to manage businesses as employees or entrepreneurs in business
start-up. Financial and business modelling acumen will help in your career development, because it teaches you to use free software to your strengths and back business decisions 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: Free for BSBI students
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.
Dr. Kanika Gupta has worked in academia for more than 15 years, and has acted as a dean for Amity University, online department. She managed entire students’ life cycles for the Open University validated programmes and incepted the academic delivery model conductive to online learning. She also formed policies and regulations for the validation of these programmes. She has also taught for several business institutes like European Business School, Rushford Business School, International School of Management, etc. Her core areas of teaching and research are accounting and finance, but due to her immense academic administration experience, she is also interested in students’ learning experiences, academic governance and regulations. She has profound experience in curriculum development at varied levels of higher education and has also been a key member of the accreditation committee.