
This lecture gives you a brief outline of the course and also a brief description of the various lectures.
In this lecture, you will know what are Financial Statements, what is the purpose, how they are prepared, and also different types of Financial Statements like Profitability Statement Cash Flow Statement, and Balance Sheet.
This lecture, tells you the Balance Sheet Structure and its various concepts. It also discusses in detail the Liabilities side of the Balance Sheet with examples.
In this lecture, you will learn about Fixed Assets. You will learn in detail the concept of Gross Block and Net Block. You will also learn what is Depreciation and how to calculate Depreciation under SLM and WDV.
In this lecture, you will learn in detail about Intangible Assets, Investments, and Current Assets. You will know the difference between Tangible Assets and Intangible Assets. Under Current Assets, you will also learn about the Operating Cycle.
In this lecture, you will learn all about an Income Statement and how it is prepared. You will come to know the fundamentals of Manufacturing & Profit & Loss Account in case of a Manufacturing Firm and also Trading Account and Profit & Loss Account in case of Trading Firm.
In this lecture, you will experience a Hands-on Income Statement and its Analysis step by step. At the end of the lecture, you will be able to draw up and analyze an Income Statement on your own.
In this lecture, you will learn the most important concept of the Working Capital Cycle and also Gross Operating Cycle and Net Operating Cycle. You will also learn how to calculate the Holding Period of Stocks, Debtors Collection Period and Creditors Payment Period.
This lecture explains what are ratios and their importance. It also tells you the different types of ratios for example Liquidity Ratios, Solvency Ratios, Turnover Ratios, and Profitability Ratios.
In this lecture, you will learn the concepts of Liquidity Ratios. You will learn in detail about the Current Ratio, Quick Ratio, and also Benchmark ratios of Banks. You will also especially learn about the relationship between the Current Ratio and Net Working Capital.
In this lecture, you will have a practical hands-on experience with the Liquidity Ratios case study. At the end of the lecture, you will be able to calculate the Current Ratio & Quick Ratio from the Balance Sheet and analyze them on your own.
In this lecture, you will know the concepts of Solvency Ratio and learn about Proprietary Ratio, TOL/TNW Ratio, and also Debt-Equity Ratio and the benchmark ratio of the banks. Here you will have practical hands-on experience with Proprietary Ratio, TOL/TNW Ratio, and also Debt-Equity Ratio case study.
In this lecture, you will learn the concepts of Turnover Ratios and learn how to calculate Stock Turnover Ratio, Debtor’s Turnover Ratio, and Creditor’s Turnover Ratio. You will also have practical hands-on experience with Liquidity Ratios. At the end of the lecture you will be able to work out the Stock Turnover Ratio, Debtor’s Turnover Ratio, and Creditor’s Turnover Ratio from the Balance Sheet and the Income Statement confidently.
In this lecture, you will how to calculate the various Profitability Ratios like Return on Sales Ratios, Return on Investment Ratios. Under Return on Sales Ratios, you will learn Gross Profit Ratio, Net Profit Ratio, Operating Ratio, and Operating Profit Ratio. Under Return on Investment Ratios, you will learn Return on Asset Ratio, Return on Capital Employed, and Return on Equity. You will have Practical experience of working on the excel sheet and work out the ratios yourself.
In this lecture, you will learn how to analyze and interpret the various ratios that we have worked out earlier.
In this lecture, you will learn the concept of DSCR and also practically learn how to calculate Gross DSCR and Net DSCR. You will also learn the acceptable benchmark DSCR of banks.
In this lecture, you will learn the importance of Security Coverage Ratios and also how to work out Asset Coverage Ratio and Collateral Coverage Ratio. You will also learn the acceptable benchmark ratio of banks.
Do you find difficulty in understanding the basic concepts of Finance? Are you comfortable with Balance Sheet Analysis, Profitability Analysis, Ratio Analysis, DSCR, the concept of Working Capital and Break Even?
If you are a student of commerce, finance, preparing for any competitive exam or a banker, lawyer, entrepreneur, or a small investor, having conceptual weakness, this course is ideally meant for you. This course will help you develop the concepts and provide you with hands-on knowledge on how to work out the various calculations in an excel sheet. You also have tons of MCQs to check your understanding. This course will give you the confidence to pursue advanced levels of learning in finance.
How this course is different?
Focus on Finance Concepts with Case Studies
Step by Step Calculation of Financial Statements in Excel Sheet with examples and Analysis.
Step by Step Calculation of Financial Ratios in Excel Sheet with Interpretation.
MCQs at the end to Self-Test your understanding.
Download Course Completion Certificate at the end of the course.
24x7 Live Support in case of any query.
Course Outline
The Course is divided into 7 Modules with several lectures in each of them.
The 1st Module deals with Financial Statements containing 1 lecture. Here you will learn the meaning of financial statements and their types.
The 2nd Module deals with Balance Sheet Concepts containing 3 lectures. You will learn with examples the Balance Sheet Structure and its interrelationships, the calculation of Reserves & Surplus, Concept of Depreciation and its calculation, the concept of Gross Block & Net Block, concepts of Intangible Assets, Investments and Current Assets.
The 3rd Module deals with Income Statement in detail and its analysis with examples and case studies in 2 lectures.
The 4th Module deals with Operating Cycle in detail containing 1 lecture.
The 5th Module deals with Ratio Analysis and its Interpretation in 7 lectures. Here, you will learn about the Ratios in general and Liquidity Ratios, Solvency Ratios, Turnover Ratios, and Profitability Ratios with hands-on working with case studies in excel format. In the end, you will find an interpretation of the Ratios with case studies.
The 6th Module deals with other important ratios in 2 lectures e.g. Debt-Service Coverage Ratio and Security Coverage Ratio with examples.
Finally, the 7th Module deals with Break Even Concept along with Case Study in excel sheet.
Advice to Students:
1. Go through each lesson and take notes.
2. Attempt all the MCQs at the end of each module.
3. Go through the course reference materials and cement your understanding.
4. Don't hesitate to contact me for any query or assistance.
See you inside the course.