EDUCBA

Home Training Courses Fundamental Analysis – Education sector

Overview

This is a Fundamental Analysis course on Education Sector, where the education sector companies will be evaluated by its financial statements, by analyzing the performance of the peer companies in this sector, economy analysis. In this course you will be learning about concept on basic excel, basic on advanced accounting, you will also learn report writing techniques. Various such as concepts you will be learning through this course.

13
0 | 0 Videos | 4123 Views | Appropriate for all  All Levels
trigger text
hidden content

Why this Fundamental Analysis – Education sector course?

Learn a detailed and practical approach to evaluating financial statements like income statement, balance sheet and cash flow statement. Also learn MS Excel which is very important to any finance professional. This course includes Downloadable PDF’s, Downloadable excel templates and many more. 

wbcr_snippet

 

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Target Audience:

  • MBA (Finance)
  • Finance professionals
  • Employees in Analytic firms
  • ICWA Students

  • CURRICULUM

[/tab][tab title=”Highlights”]

Fundamental Analysis – Education sector Course Highlights:

This Fundamental Analysis on Education Sector course is divided into three modules:

  1. Basic Excel
  2. Basic & Advanced Accounting
  3. Report Writing Techniques

Basic Excel:

Learn Excel proficiency required for financial analyst through this model. This model includes following excel functions:

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

View Offline

View courses without internet connection with a Lifetime Membership
View courses without internet connection with a Lifetime Membership

View Offline - Internet-free viewing with your iOS or Android App

Watch offline with your iOS/Android app.

Start Your Free Trial Now

You can download courses from your iOS/Android App.

[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]