Financial Management in Excel : Beginner to Advanced
Learn all about finance i.e. investment decision making, time value, financial ratios, working capital.
Description
This Specialization covers the fundamentals of strategic financial management, including financial accounting, investments, and corporate finance. You will learn to evaluate major strategic corporate and investment decisions and to understand capital markets and institutions from a financial perspective, and you will develop an integrated framework for value-based financial management and individual financial decision-making.
When you complete the Financial Management Specialization, you will:
· Have a solid foundation in developing an integrated framework for strategic financial decision-making.
· Have a thorough understanding of financial statements and the financial information they provide, and be able to critically evaluate and analyze financial statements.
· Have a thorough understanding of investment decision-making and how to manage the working capital of the business.
· Understand how to incorporate risk and uncertainty into investment decisions and understand how companies make financing and investment decisions.
Goals and functions of financial management, short-term financial planning, capital markets, risk and return, valuation of financial assets, cost of capital, and capital budgeting decisions. The course will develop analytical and decision-making skills in finance through the use of theory questions, practical problems, and mini-cases. Many of the problems/assignments will require the application of an electronic spreadsheet program such as Excel.
The course will emphasize the tools that support business decision-making. Students will study essential topics in the financial management of profit-seeking organizations.
What You Will Learn!
- Understand the Basics of Financial Management
- Carry out Financial Ratio Analysis
- Learn Finance in Excel
- Understand Working Capital Management, Inventory Management, Treasury Management, Debtors Management, Creditors Management
- Appreciate Importance of Time Value of Money
- Calculate Cost of Capital (WACC & Marginal)
- Understand Capital Budgeting Process, Payback, NPV, IRR, Profitability Index, Discounted Payback Perio
Who Should Attend!
- Welcome to one of the comprehensive ever course on Financial Management – relevant for any one aspiring to understand Financial Management and useful for students pursing courses like BCOM, BBA, MBA, PGDM, MCOM, Professional Courses etc. A Course with several lectures explaining each and every concept in Financial Management followed by Solved Case Studies (Video), Conversational Style Articles explaining the concepts, Hand outs for download, Quizzes and what not??