Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Financial Modeling Using MS Excel

No Reviews Yet

Sector-59 Mohali, Chandigarh

Course ID: 16844

Sector-59 Mohali, Chandigarh

Students Interested 2 (Seats Left 0)

₹ 1,000

No Reviews Yet

Date and Time

Not decided yet.

Dr. Manvinder Singh

B.Com., M.Com., ACS, LL.B., LLMMBA (Gold Medalist)

About Dr. Manvinder Singh

Professor Dr. Manvinder Singh is having a very good academic record at his credit with excellent professional credentials. He also a qualified Company Secretary. He is a Gold Medalist in LL.M. & M.B.A . He has completed his LL.B. with merit position. He is a recognized Supervisor for Ph.D-Doctoral Research work at several renowned Indian Universities.
He has also worked as CFO of Cactus Menswear Fashions Pvt . Ltd, a subsidiary of FBC Inc, New York. He has also been Legal and Financial Consultant to a number of companies to name a few : Winding up of Ashirwad TV a National Channel, IPO worth Rs. 600 crores of Janki Corps Ltd, Merger of Five companies to form the renowned BikaJi Foods Ltd at Rajasthan High Court, and consistent corporate consultant to listed companies like Shri Rajasthan Syntex Ltd, BSL etc during his practice as CS and Corporate Lawyer.
He has a harvest of rich experience of 15 years which is a rare blend of Academia, Industry and Research.He has participated at numerous National & International Conferences, Chaired the Sessions and his research papers are published in referred national and international journals.
He has conducted and delivered several special courses & MDPs to various private as well as PSUs in India in his area of expertise. He is also a regular invitee for a number of AICTE and UGC sponsored FDPs on Research Methodology and SPSS.
He has guided 5 Ph.D. scholars and 7 more are working under his guidance.
No reviews currently

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 Covered

Session 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 attend

Students of B.Com., BBA, MBA, M.Com., CA, CS, ICWA, CFA, Working Finance Professionals, Insurance Agents, Mutual Fund Agents, Bankers etc.

Pre-requisites

Some knowledge of finance and maths is required.

What you need to bring

Your charged laptop and long extension cable for charging the laptop, a note book and pen.

Key Takeaways

Efficiency of resolving finance problems and making decisions, Increase in Placement Ability and competency and a certificate

Reviews

No reviews currently

Gallery (2)

Discussions

Students Interested 2 (Seats Left 0)

₹ 1,000

Post your requirement and let us connect you with best possible matches for Personal Financial Planning Classes Post your requirement now
₹ 1,000 Enquire