20 2021
FINANCIAL
MODELLING
USING EXCEL (ONLINE/OFFLINE)
This workshop will dedicate a total of 30 hours to explain Excel Financial
Functions, Financial Statements, Developing Company Financial Models, Project
Finance Modeling, Portfolio Optimization and Risk And Corporate Valuations.
Dr. Laxmi Goritiyal (PhD, MFM, [Link], [Link], DBM)
VESBS
About VES Business School
The VES Business School (VBS) carries with it the rich legacy of
Management teaching methods of its parent, VESIM. VBS was
initiated as the standalone Institute to offer the autonomous
programme of PGDM, in keeping with the rules of the apex body,
All India Council for Technical Education (AICTE) that oversees
technical education in the country.
Vivekanand Education Society’s Institute of Management Studies
& Research (VESIM) and the newly established Vivekanand
Education Society’s Business School (VBS) are separate entities,
established by VES to impart management education.
As a business school set up by a highly-respected entity of
Mumbai, the VES Business School (VBS) strives to uphold the
values and interests of the students and the community at large.
We have committed ourselves to empower today’s students for
tomorrow’s world of business. VBS will channel its energies to
build and make its name and become a well-respected business
school with highly-qualified and experienced faculty and thus
appeal to the top talents and career-focused students. These
industry-ready candidates would be able to get bright
opportunities and career prospects with top corporates.
VBS is now well-poised to be counted amongst the Top Business
Schools in Mumbai. In the endeavor to build India’s future
business leaders and managers, VBS offers a two-year, full-time
Post Graduate Diploma in Management (PGDM) that has been
1
Page
VESBS |FINANCIAL MODELLING USING EXCEL
approved by the All India Council for Technical Education
(AICTE).
It will become a world-class institute by ensuring high teaching
standards, professionalism, and values that are needed to be
counted in that league.
Workshop on Financial Modeling Using Excel
Financial Modeling covers standard financial models in the areas of
corporate finance and financial statement simulation. The aim of this
course is to explain clearly and concisely the implementation of models
using Excel.
2
Page
VESBS |FINANCIAL MODELLING USING EXCEL
Module Learning Objective/Outcome:
To define the different types To explain different
of Excel functions to improve
Excel proficiency valuation models
Module Learning
Objective/Outcome
To compute value of To examine the characteristics of
company shares and bonds equity report writing on the basis
and apply various of financial modeling to
frameworks to analyze understand the methods used in
particular business situations industry for decision making.
3
Page
VESBS |FINANCIAL MODELLING USING EXCEL
Module
Financial Modelling Using Excel
Practical session on
Total Duration Computer Lab/Laptop 30 Hours
Online Mode/Computer
Lab
Day Particulars Allocated
Duration
1 10 hours
Session 1:
Excel Financial Functions:
IF, AND, SUM IF, SUM COUNT, RAND, PV,FV, PMT;
Session 2: Lookup Functions; Pivot table;Sensitivity Analysis with
data tables; Summarizing Data using Histograms
Session 3:Using Solver for capital budgeting;The Goal Seek
command;
2 Session 4: 4 hours
Financial Statements: Valuation based on the Consolidated
Statement of Cash Flow; Pro Forma Financial Statement Modeling;
Session 5:Identify Factors that Impact a Sector’s Valuation and
Performance
3 Session 6: 10 hours
Develop Company Financial Models: Forecast Scenarios for the
Most Critical Factors through different companies along with historical
weighted average cost of capital.
Session 7:
Additional Training on:Corporate Valuations: Introduction
Session 8
Valuation approaches
Brief demo on Creating Spread sheet for Company
4
Page
VESBS |FINANCIAL MODELLING USING EXCEL
4 Session 9: 3 hours
Project Finance Modelling: Risks- analysis and mitigation,financial
model, inputs, sensitivity, and cost of capital,
construction,borrowingand output, Session 10:
preparingprojected financial statementsincluding cash flow, evaluating
a projects debt capacity and cash flow waterfall, measuring expected
rates of return,
Session 11:
sensitivity analysis through Toll Project Case Study
5 Session 12: 3 hours
Portfolio Optimization and Risk: Develop model based on two
assets portfolio, develop model based on more than two assets ( n
assets) portfolio,
Session 13:
variance covariance matrix, creating efficient frontier for asset
allocation, using solver to find minimum variance portfolio and
optimal(market portfolio) in asset case,
Session 14:
CML model, calculation of beta based on data gathered from any
stock exchange.
Total Hours 30
Hours
Benefits of attending workshop:
Certification (Based on Grades scored in Exams)
Project based examination will be conducted post completion of 30
hours
Complete guidance will be provided via email during the tenure of
workshop.
5
Page
VESBS |FINANCIAL MODELLING USING EXCEL
Five Days Workshop (6 hours per day)
Maximum Number of seats will be 200 per batch
Mode of conducting the workshop will be Online/offline.
Study Material will be in the form of Cases, spread sheet templates
Who should attend? – Those who intend to make career in Finance, Corporate
Finance and Other related area of Finance
Pre-requirements will be personal laptop & Wi-Fi.
Resource person will be Ms. Laxmi Goritiyal (PhD, MFM, [Link], [Link], DBM),
[Link]@[Link] , LinkedIn Profile : [Link]
1318b423
Feedback –
We will conduct an online quiz at the end of the class based on the contents taught in
the lecture. This quiz will be a graded activity carrying marks as part of Continuous
Evaluation. Before the beginning of the next class, we will check the responses and
give a feedback to the participants based on it.
We will also give formal as well as informal feedback on the assignments, flipped
presentations, project reports etc.
6
Page
VESBS |FINANCIAL MODELLING USING EXCEL
