About the Course
MS Excel is a very powerful tool for those who are working in industry may it be finance or non finance. Particularly for those students who are looking for their career in a financial or consultancy based industry, the knowledge of MS Excel becomes more important. This is the applied part of the theoretical knowledge of financial management being taught in the class rooms from books and is directly helpful in making the students capable of being placed.
The knowledge of MS Excel is a must for working in the industries like Business Process Outsourcing, Financial Research, Financial Consultancies, Project Management and Financing, Banking, Non Banking Finance Companies, stock trading, personal finance, insurance to take a name of few. Besides the knowledge of excel helps in data mining, data validation and much more for non finance based industries.
In all, the knowledge of MS Excel is vital for all and helps in placement of students of all the streams.
Topics CoveredSession 1 (1.5 Hour)
Introduction to MS Excel, Types of Formats and Cell Entries
Formulas and Constants, Worksheet Basics, Formatting and Entering Information, Formulas and Errors (With Reasons and Explanation), Functions and Their Combinations
Cell References and Its Types, Data Types and Data Validation, Logical Values, Financial Functions
Session 2 (1.5 Hour)
Time Value of Money, PV and PVA, FV and FVA, Growing Annuities, Real and Nominal Rate of Interest, Capital Recovery and Loan Amortization, Deferred Annuities
PV and FV of Uneven Cash Flows
Session 3 (1.5 Hour)
Cost of Capital, Cost of Debt, Cost of Preference Capital
Cost of Equity – Constant Growth, Normal Growth and Zero Growth, Capital Asset Pricing Model (CAPM),
Calculation of Beta (?), Security Market Line (SML)
Session 4 (1.5 Hour)
Overall Cost of Capital and Investment Decision,
Weighted Average Cost of Capital (WACC), Case Study – HLL, Investment Decision, Determination of Cash Flows
Initial Cash Flows, Relevant Cash Flows, Adjustment in Cash Flows, Case Study – Bharat Machinery Tools Ltd, Discussion and Investment Decision using Excel
Who should attendStudents of B.Com., BBA, MBA, M.Com., CA, CS, ICWA, CFA, Working Finance Professionals, Insurance Agents, Mutual Fund Agents, Bankers etc.
Pre-requisitesSome knowledge of finance and maths is required.
What you need to bringYour charged laptop and long extension cable for charging the laptop, a note book and pen.
Key TakeawaysEfficiency of resolving finance problems and making decisions, Increase in Placement Ability and competency and a certificate