loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Financial Modeling Using MS Excel

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Manvinder

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

Financial Modeling Using MS Excel

Financial Modeling Using MS Excel

Sector-59 Mohali, Chandigarh

1,000

No Reviews Yet
2 Interested

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
Gallery
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Dr. Manvinder Singh

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


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.
Seats Left-

Students Interested 2

Course Id: 16844