What you'll get
- 0
- 0 Videos
- Course Level - All Levels
- Course Completion Certificates
- One-Year Access
- Mobile App Access
Curriculum:
[tabby title="Overview"][wbcr_snippet id="138762"]
Why this Fundamental Analysis – Education sector course?
-
CURRICULUM
[/tab][tab title="Highlights"]
Fundamental Analysis – Education sector Course Highlights:
This Fundamental Analysis on Education Sector course is divided into three modules:
- Basic Excel
- Basic & Advanced Accounting
- Report Writing Techniques
Basic Excel:
Learn Excel proficiency required for financial analyst through this model. This model includes following excel functions:
- Data Entry
- Populating the Case Study in Excel
- Formatting of worksheets
- Percentages Absolute References
- Percentages Absolute References
- Conditional Formatting
- IF Function
- COUNTIF and SUMIF
- Pivot Tables
- Freeze and Split
- Excel Shortcuts
- Many more!
Basic & Advanced Accounting:
Learn Details insights of financial statement like income statement, balance sheet, Cash flow statement through this module. This module covers following:
- Understanding the Income statement
- Understanding the Balance Sheet
- Understanding the Cash flow statement
- Financial Analysis Techniques
- Income Taxes
Report Writing Techniques:
Report writing is a skill which is very important in an organization. Organizations could not function effectively without written reports. This module on report writing takes you through every stage from introduction to Report writing case study. This module covers following topics like:
- Equity Research Report meaning
- Anatomy of Equity Research Report
- Comparing Equity Research Report
- Do’s Don’ts of Research Report Writing
- Case Studies
- Indian Media Sector Report
- Peer Analysis
- Exhibit Reliance Petroleum Research Report
- Reference Annual Reports
-
CURRICULUM
[/tab][tab title="Testimonials"]
Amit Gawade, Amravati
I found that the Fundamental analysis – education sector course was excellent. It helped me to understand financial statements deeply. I highly recommend the Edu CBA fundamental analysis training to anyone wishing to gain a good understanding of financial statements of company. Thank you again to the Edu CBA Team.
Sonal Deshmukh, Pune
I would like to take this opportunity to congratulate Edu CBA for such wonderful course on fundamental analysis. I found course content and study materials were wonderful .My experience with Edu CBA was very rewarding right from selection of course to the very end. Many thanks to your team for a job well done!
Aatish Surve, Mumbai
This course fundamental analysis – education sector was fantastic and one of the best. This online course was extremely helped me.as compared to the other courses I have looked at; this one was very complete, easy to understand. Thank you for your great course, great support, and fast response to queries.
-
CURRICULUM
[toggles type="accordion"][toggle title="Section 1: Basic Excel"]
| 1 | Getting Started Ribbons Quick Access Toolbar |
| 2 | Getting Started Surfing Excel HELP Function |
| 3 | Excel Case Study |
| 4 | Data Entry in Excel |
| 5 | Populating the Case Study in Excel |
| 6 | Calculations Addition Subtract Multiply Division |
| 7 | Formulas SUM MAX MIN AVERAGE |
| 8 | Formatting Number Formats |
| 9 | Formatting Table Formats |
| 10 | Updating a Calculation |
| 11 | Percentages and Absolute References |
| 12 | Conditional Formatting |
| 13 | IF Function |
| 14 | COUNTIF Function |
| 15 | SUMIF Function |
| 16 | Creating Charts and Graphs |
| 17 | Create Pie Charts |
| 18 | Sorts |
| 19 | Filter |
| 20 | Pivot Table |
| 21 | Freeze and Split |
| 22 | Presentation Table Formats |
| 23 | Presentation Indents and Formatting Charts |
| 24 | Printing the Worksheet |
| 25 | Printing Headers and Titles |
| 26 | Shortcuts Formatting and Navigation |
| 27 | Shortcuts Selection Data and Formula |
| 28 | Common Errors |
| 29 | Download all Excel and PDF files |
[/toggle][toggle title="Section 2: Basic Advanced Accounting"]
| 30 | Introduction to Accounting |
| 31 | Explaining and Business Cycle |
| 32 | Accounting for Income Statement |
| 33 | Accounting for Balance sheet Part 1 |
| 34 | Accounting for Balance sheet Part 2 |
| 35 | Accounting for Balance sheet Part 3 |
| 36 | Accounting for Cash Flows |
| 37 | Financial Statements Fiscal Year vs Calendar Year |
| 38 | Income Statement Format |
| 39 | Calculating Profit Margins |
| 40 | Non Recurring Items |
| 41 | Changes in Accounting Estimates |
| 42 | Final Remarks |
| 43 | Revenue Recognition Percentage Completion Completed Contract Part 1 |
| 44 | Revenue Recognition Percentage Completion Completed Contract Part 2 |
| 45 | Revenue Recognition Installment Method Cost Recovery |
| 46 | Downloading Colgates Income Statement part 1 |
| 47 | Downloading Colgates Income Statement part 2 |
| 48 | Analyst format of Colgates Income Statement |
| 49 | Formatting the Income Statement |
| 50 | Investigating the Nonrecurring charges |
| 51 | Seperating nonrecurring Items |
| 52 | Comparision of Margins before and after adjustments |
| 53 | Introduction to Balance Sheet |
| 54 | Introduction to Current Assets |
| 55 | Cash and Cash Equivalents |
| 56 | Cash and Cash Equivalents Colgate PG Microsoft |
| 57 | Accounts Receivables |
| 58 | Accounts Receivables Case Study part 1 |
| 59 | Accounts Receivables Case Study part 2 |
| 60 | Inventory |
| 61 | Inventory Case Study |
| 62 | Financial Reporting Standards |
| 63 | Inventory LCM |
| 64 | Inventory Valuations |
| 65 | Inventory Valuation Recap |
| 66 | Inventory Colgate |
| 67 | Prepaid Expenses |
| 68 | Current Liabilities |
| 69 | Other Current Assets Colgate |
| 70 | Current Liabilities Colgate |
| 71 | Long Term Assets |
| 72 | Depreciation Expense long lived asset |
| 73 | Introduction to Goodwill |
| 74 | Pooling Method of Accounting |
| 75 | Purchase Method of Accounting |
| 76 | Goodwill Impairment |
| 77 | Long Term Investments Part 1 |
| 78 | Long Term Investments Part 2 |
| 79 | Long Term Investments Example |
| 80 | Long Term Liabilities |
| 81 | Long Term Liabilities Risk Profile |
| 82 | Introduction to Shareholders Equity |
| 83 | Common Stock Par value and APIC |
| 84 | Treasury Stock or Shares |
| 85 | Retained Earnings Dividends |
| 86 | Additional Other Comprehensive Income |
| 87 | Introduction to Preference Shares |
| 88 | MacDonalds Shareholders Equity |
| 89 | Dividends Types |
| 90 | Cash and Property Dividend Example |
| 91 | Stock Dividends |
| 92 | Small Large Stock Dividends Example |
| 93 | Stock Split |
| 94 | Introduction to EPS |
| 95 | Basic EPS example |
| 96 | Calculating Weighted Average Shares |
| 97 | Effect of Stock Dividends and Stock Splits |
| 98 | Simple vs Complex Structures |
| 99 | Preferred Convertible Shares Dilution |
| 100 | Preferred Convertible Shares Dilution Example |
| 101 | Antidilutive Preferred Convertible Shares |
| 102 | Convertible Debt Dilution |
| 103 | Convertible Debt Dilution Example |
| 104 | Antidilutive Convertible Debt |
| 105 | Stock Options |
| 106 | Treasury Stock Method |
| 107 | Stock Option Dilution Example |
| 108 | Comprehensive Example |
| 109 | Introduction to Cash Flows |
| 110 | CFO Direct Method 1 |
| 111 | CFO Direct Method 2 |
| 112 | CFO Direct Method 3 |
| 113 | CFO Direct Method Example |
| 114 | CFO Indirect Method |
| 115 | CFO Indirect Method Example |
| 116 | CFI |
| 117 | CFF |
| 118 | Comprehensive Example CFO Direct Method 1 |
| 119 | Comprehensive Example CFO Direct Method 2 |
| 120 | Comprehensive Example CFO Indirect Method |
| 121 | Comprehensive Example CFI |
| 122 | Comprehensive Example CFF |
| 123 | Comprehensive Example Ending Cash Balance |
| 124 | Horizontal and Vertical Analysis |
| 125 | Income Statement Horizontal and Vertical Analysis Example |
| 126 | Balance Sheet Vertical Analysis Example |
| 127 | Introduction to Ratio Analysis |
| 128 | Activity Ratios |
| 129 | Activity Ratios Receivables Turnover |
| 130 | Activity Ratios Inventory and Payables Turnover |
| 131 | Activity Ratios Cash Conversion Cycle Discussion |
| 132 | Activity Ratios Working Capital and Fixed Asset Turnover |
| 133 | Liquidity Ratios |
| 134 | Solvency Ratios |
| 135 | Profitability Ratios |
| 136 | Comprehensive Example Activity Ratio Cash Conversion Part 1 |
| 137 | Comprehensive Example Activity Ratio Cash Conversion Part 2 |
| 138 | Comprehensive Example Activity Ratio Working Capital and Fixed Asset Turnover |
| 139 | Comprehensive Example Liquidity Ratios |
| 140 | Comprehensive Example Solvency Ratios |
| 141 | Comprehensive Example Profitability Ratios |
| 142 | ROE |
| 143 | ROE Example |
| 144 | Dividends Payout Ratio |
| 145 | Introduction to Income Taxes part 1 |
| 146 | Introduction to Income Taxes part 2 |
| 147 | Sources of Deferred Taxes |
| 148 | Deferred Tax Liabilities Example Part 1 |
| 149 | Deferred Tax Liabilities Example Part 2 |
| 150 | Deferred Tax Liabilities Example Part 3 |
| 151 | Deferred Tax Assets Example |
| 152 | Temporary and Permanent Difference |
| 153 | Valuation Allowance Deferred Tax Assets |
| 154 | Tax Base Deferred Taxes |
| 155 | Effect of Changes in Tax Rates on Deferred Taxes |
[/toggle][toggle title="Section 3: Report Writing Techniques"]
| 156 | Introduction |
| 157 | What is Equity Research Report Part 1 |
| 158 | What is Equity Research Report Part 2 |
| 159 | Anatomy of Equity Research Report |
| 160 | Comparing Equity Research Report |
| 161 | Do's Don'ts of Research Report Writing |
| 162 | Report Writing Case Studies |
| 163 | Useful Financial Websites |
| 164 | Indian Media Sector Report Part 1 |
| 165 | Indian Media Sector Report Part 2 |
| 166 | Indian Media Sector Report Part 3 |
| 167 | Peer Analysis part 1 |
| 168 | Peer Analysis part 2 |
| 169 | Peer Analysis part 3 |
| 170 | Peer Analysis part 4 |
| 171 | Peer Analysis part 5 |
| 172 | Peer Analysis part 6 |
| 173 | Peer Analysis part 7 |
| 174 | Exhibit Reliance Petroleum Research Report |
| 175 | Download all Excel and PDF files |
[/toggle][/toggles]
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
All Levels 