Financial Analysis - A Conceptual & Practical Approach
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.
Overview
1.7KSTUDENTS*
96.2%RECOMMEND*
This course includes:
- 2.5 hours of on-demand video
- Certificate of completion
- Direct access/chat with the instructor
- 100% self-paced online
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? 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.
The Course is divided into 7 Modules with several lectures in each of them.
The 1st Module deals with Financial Statements and contains 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, the Concept of Depreciation and its calculation, the concept of Gross Block & Net Block, and the concepts of Intangible Assets, Investments, and Current Assets.
The 3rd Module deals with Income statements 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 work 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.
Skills You Will Gain
Balance sheet
Break Even Analysis
Financial Statements
Income Statement
Learning Outcomes (At The End Of This Program, You Will Be Able To...)
- Learn Types of Financial Statements.
- Learn Balance Sheet Structure and its concepts with case studies.
- Learn Income Statement and how to Analyze Income Statement in excel sheet.
- Learn 20 Ratios and their Interpretation in an excel sheet.
- Learning about standard benchmark ratios applicable in banks.
- Understanding DSCR Concept with a case study for Term Loans & Security Coverage Ratio along with standard benchmark ratios in banks.
- Learn Break Even Analysis with a case study in excel sheet.
Prerequisites
- None
Who Should Attend
- This course is ideally suited for those preparing for competitive exams, students of commerce, finance, bankers, lawyers, entrepreneurs, small investors, and others who have a passion for the subject.
- This course is for those individuals who have discovered their weaknesses & gaps in knowledge and skills and wish to overcome them
