Corporate Finance Management & Financial Modelling in Excel (Udemy.com)

Hi

This is a Corporate Financial management course from beginners to advanced level. It begins with understanding basic concepts and terms of financial management to application of the financial management in decision making. (Also there is Bonus Course on Financial Modelling in Excel in Module 16 : Lectures on Financial Modeling in Excel) The course consists of video lectures along with solved illustrations and Quiz that provides better understanding of concept. It is logically divided into various Sections :

Module 1 : Introduction

(Includes Section 1)

Introduction and understanding the meaning of financial management.

Module 2 : Sources of Finance

(From Section 2 to Section 6)

Here we are identifying and understanding different sources of Finance. This includes all long term finance and medium term finance such as Equity and Preference share capital , Bonds and Debentures, Venture Capital, Asset Securitization, Lease Financing, Depository Receipts, Trade Credit and accrued expenses. It also includes all short term finance such as Bridge Finance, Treasury Bills, Certificate of Deposits, Commercial paper etc. All the sources of finance are explained in video lectures along with illustrations.

Module 3 : Financial Ratios and Analysis

(From Section 7 to Section 11)

Here We discuss about different types of Financial Ratios such as Liquidity Ratios (Short term solvency ratios) , Leverage Ratios (Long Term solvency ratios) ,Activity Ratios (Turnover ratios) and Profitability Ratios.

Liquidity Ratios includes current ratio, quick ratio, cash ratio and Interval measure ratio. Each ratio is explained in video lecture along with illustrations.

Leverage Ratios include equity ratio, debt ratio, debt to equity ratio, debt to total assets ratio, proprietary ratio, capital gearing ratio, debt service coverage ratio, dividend coverage ratio, interest coverage ratio, fixed charges coverage ratio etc. Each ratio is explained in video lecture along with illustrations.

Turnover ratios include fixed assets turnover ratio, net assets turnover ratio, current assets turnover ratio, working capital turnover ratio, inventory turnover ratio, receivables turnover ratio, payables turnover ratio etc. Each ratio is explained in video lecture along with illustrations.

Profitability ratios include gross profit ratio, net profit ratio, operating profit ratio, expenses ratio, return on assets, return on capital employed, return on equity, earning per share, dividend per share, dividend payout ratio, price earning ratio, dividend and earning yield ratio, market value by book value ratio, Q ratio. Each ratio is explained in video lecture along with illustrations.

DuPont Analysis on ROI (Return on Investment) , ROA (Return on Assets)  and ROE (Return on Equity)

This module also includes a comprehensive solved illustration that explains how to calculate all types of ratios and how to use these ratios for analysis and decision making.

Module 4 : Time Value of Money

(From Section 12 to Section 15)

Here we discuss about the concept of Time Value of Money and how to use concept of time value of money. The relationship between inflation, purchasing power and Time value of money is separately discussed. Other topics included are Difference between Simple interest and compound interest, Present value and Future value of money, Formula for present value and future value, Discount Factor, Annuity, Present Value and Future Value of Annuity. All topics are explained in video lecture along with examples.

Module 5 : Cost of Capital

(From Section 16 to Section 19)

Here we will learn how to calculate cost of capital for individual capitals i.e Cost of Debentures/ Bonds, Cost of Preference shares , Cost of Equity shares and then How to calculate total cost of capital.

Cost of debt/Bonds and debentures includes calculation of Cost of Redeemable and Irredeemable debts using approximation method and Internal Rate of Return (IRR) Method. It also includes separate lecture wherein logic for using current price in calculating cost of capital is explained.

Cost of Preference shares using Approximation method and Internal Rate of Return (IRR Method)

Cost of Equity and Retained Earnings using Dividend Price Model, Earnings Approach model, Gordon's growth model, Realized Yield Approach, Capital Asset Price Model is explained along with examples. Besides Calculation of Growth Rate for Gordon's growth model, Beta , Types of Risks - Systematic and Unsystematic risks are explained in separate video lecture along with examples.

This section is concluded by calculating weighted average cost of capital (WACC) and Marginal cost of capital.

Module 6 : Leverages

(From Section 20 to Section 23)

Here we will be learning about different types of Leverages - Operational Leverage, Financial Leverage and Combined Leverage. This will be followed by Formula to calculate degree of operating leverage (DOOL/DOL), degree of Financial leverage (DOFL/DFL) and degree of combined leverage (DOCL/DCL). Operating and Financial break even points are analyzed in separate lectures and relationship of break even points with leverage is discussed. Some other topics include relationship between Margin of Safety and Operational leverage, Relationship between Break even point - Fixed cost and operational leverage, Why financial leverage is known as trading on equity and double edge sword.

Module 7 : Capital Structure

(From Section 24 to Section 33)

It includes meaning of capital structure and capital structure theories. Following theories are discussed in this module : Net Income approach, Traditional Approach, Net Operating Income approach, Modigliani and Miller approach , Trade off theory and pecking theory. Along with this following topics are also discussed - meaning of arbitrage with solved illustrations, Indifference points, Over capitalization and under capitalization.

Module 8 : Capital Budgeting

(From Section 34 to Section 49)

It begins meaning of Capital Budgeting and purpose of Capital Budgeting. This is followed by process of capital budgeting and types of Capital budgeting decisions - Replacement and Modernization decisions, Expansion decisions, Diversification decisions, Mutually Exclusive decisions, Accept or Reject decision, Contingent decision.