Financial Management in Excel : Beginner to Advanced

Name: Financial Management in Excel : Beginner to Advanced
Rating: 4.6 (13 reviews)

Learn all about finance i.e. investment decision making, time value, financial ratios, working capital.

Created byAnkit Kumar Bajaj

Last updated 2/2023

English

What you'll 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

Course content

5 sections • 31 lectures • 7h 51m total length

Introduction of Module5:23
Why Financial Management4:22
Helps in Financial Planning. Assists in acquiring and managing funds. Helps in funds allocation. Provides insights to make critical financial decisions.
Importance of Financial Management6:49
Financial management provides pathways to attain goals and objectives in an organisation. The main duty of a financial manager is to measure organisational efficiency through proper allocation, acquisition and management.
Objective of Financial Management4:42
Objective of Financial Management Continued6:13

Introduction of Cost of Capital2:52
In this session, students will be able to understand about the importance of cost of capital
Cost of Debt12:39
Students will be to understand how to compute the cost of debt and also about tax benefits.
Cost of Equity28:35
Students will be able to understand how to compute the cost of equity by using the real data of the company
Cost of Equity Continued10:19
Students will be able to understand how to compute the cost of equity by using the real data of the company
Weighted Average Cost of Capital15:03
Students will be abe to compute the overall cost of capital of business
Weighted Average Cost of Capital Continued6:05
Students will be abe to compute the overall cost of capital of business

Introduction of Capital Budgeting48:05
Students will learn how to do the analysis of a project and how to compute the PV of cash inflows and NPV
Capital Budgeting - PV of cash flows, NPV, IRR44:21
Students will learn how to do the analysis of a project and how to compute the PV of cash inflows and NPV
Capital Budgeting - Pay Back Period30:39
Students will learn how to do the analysis of a project and how to compute profitability index, payback period and discounted payback period

Liquidity Ratios - Current Ratio8:52
The current ratio is a liquidity ratio that measures a company's ability to pay short-term obligations or those due within one year.
Liquidity Ratios - Current Ratio Continued6:08
The current ratio is a liquidity ratio that measures a company's ability to pay short-term obligations or those due within one year.
Liquidity Ratios - Quick Ratio10:34
The quick ratio is an indicator of a company’s short-term liquidity position and measures a company’s ability to meet its short-term obligations with its most liquid assets.
Capital Structure Ratios - Equity Ratio12:41
The equity ratio is a financial metric that measures the amount of leverage used by a company. It uses investments in assets and the amount of equity to determine how well a company manages its debts and funds its asset requirements.
Capital Structure Ratios - Debt to Equity Ratio6:07
Capital Structure Ratios - Debt to Asset Ratio11:20
The debt-to-total-assets ratio shows how much of a business is owned by creditors (people it has borrowed money from) compared with how much of the company's assets are owned by shareholders.
Capital Structure Ratios - Capital Gearing Ratio14:44
The gearing ratio is a measure of financial risk and expresses the amount of a company's debt in terms of its equity. A company with a gearing ratio of 2.0 would have twice as much debt as equity.
Interest Coverage Ratios14:54
The interest coverage ratio is a debt and profitability ratio used to determine how easily a company can pay interest on its outstanding debt.
Market Rations - Earning Per Share and Cash Earning Per Share8:34
Earnings per share or EPS is a common metric used to carry out corporate value. It can be defined as the value of earnings per outstanding share of common stock of the company.
Market Ratios - Diluted Earning Per Share7:33
Diluted earnings per share (EPS) is a measurement of a company's earnings per share if all convertible securities were converted. Dilutive securities are securities that can be converted to common stock.
Market Ratios - Book Value Per Share4:10
The book value per share (BVPS) is a ratio that weighs stockholders' total equity against the number of shares outstanding. In other words, this measures a company's total assets, minus its total liabilities, on a per-share basis.
Margin Ratios4:24
Return of Assets, Return of Equity, Return of Capital Employed, Asset Turnover6:49
Debtor Turnover Ratio, Inventory Turnover Ratio, Working Capital Turnover Ratio6:13
A turnover ratio represents the amount of assets or liabilities that a company replaces in relation to its sales.
Efficiency Ratios, Growth Ratios and Financial Stability Ratios12:55
The efficiency ratio is typically used to analyze how well a company uses its assets and liabilities internally. An efficiency ratio can calculate the turnover of receivables, the repayment of liabilities, the quantity and usage of equity, and the general use of inventory and machinery.

Requirements

Students can approach with fresh mind

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.

Who this course is for:

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??

Financial Management in Excel : Beginner to Advanced

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 27min

Cost of Capital6 lectures • 1hr 16min

Capital Budgeting3 lectures • 2hr 3min

Working Capital Management2 lectures • 1hr 49min

Financial Statement Analysis15 lectures • 2hr 16min

Requirements

Description

Who this course is for: