Hot Hand Emojji Images Intro price. Get comandfin.com for Big Sale upto 85% off.
New Registration
Search
Enroll Now

Your shopping cart

Education Images

AI-Powered Financial Analyst Course

Through financial analysis module gain practical skills in financial modeling, data interpretation, valuation techniques, and Excel proficiency to drive data-backed business decisions.

Best Seller Icon Bestseller
4.8
4.7 rating
12546 views students
Sophia Jaymes
By >CA Ankit Bajaj @ www.comandfin.com
  • Last updated Last updated June 2024
  • English
  • Certified Course
Preview this course
7999.00
12546 views students
  • TaglineExcel as a Financial Analyst
  • Enrolled2450 students enrolled
  • Rating4.7
  • Time70+ hours of video content published
  • LanguageEnglish
  • Views12546 views
  • AutherCA Ankit Bajaj
  • Last Update Last updated June 2024
Show More
About Images
Education Logo Images

Get Your Course Brochure Now

Fill In Your Details

Close

What you'll learn

AI-Powered Financial Analyst Course

Course Content

  • a. Introduction of Financial Reporting
    18:36
  • b. Understanding of Assets - Current and Non Current Assets
    22:06
  • c. Understanding of Current Assets
    07:37
  • d. Understanding of Equity and Liability
    16:41
  • e. Discussion of GAAP
    10:24

  • a. Income Statement Format
    11:27
  • b. Profit and Loss Account - Case 1
    17:16
  • c. Profit and Loss Account - Case 2
    06:40
  • d. Income Statement with Poona Bakery Example
    28:24
  • e. Income Statement From Annual Report - Revenue
    08:49
  • f. Income Statement Form Annual Report COMC, Purchase of Stock in Trade and Changes in Inventory
    09:35
  • g. Income Statement AR - Expenses and Exceptional Items
    13:12
  • h. Multi Step Profit and Loss Account
    18:04

  • a. Introduction of Balance Sheet
    07:06
  • b. Balance Sheet Format
    06:33
  • c. Non Current Assets
    06:07
  • d. Current Assets
    07:44
  • e. Share Capital
    03:57
  • f. Difference between Current Liability and Non Current Liability
    05:10
  • g. Non Current Liability and Current Liability
    05:11
  • h. Annual Report of Dabur - Assets
    06:00
  • i. Annual Report of Dabur - Share Capital
    04:59
  • j. Annual Report of Dabur - Current Liabiltiy and Non current Liability
    06:12

  • a. Introduction of Cash Flow Statement
    04:00
  • b. Operating Activity
    10:49
  • c. Operating Activity - 2
    08:46
  • d. Financing Activity
    06:44
  • e. Investing Activity
    07:48
  • f. Discussion of All 3 Activities - Cash Flow Statement
    06:21
  • g. Case 1 - Part 1 : Trial Balance, P and l and BS
    23:44
  • h. Case 1 - Part 2 : Trial Balance, P and l and BS
    11:42
  • i. Case 2 - Part 1 : Trial Balance, P and l, BS and CFS
    15:47
  • j. Case 2 - Part 2 : Trial Balance, P and l, BS and CFS
    47:57
  • k. Case 3 on Cash Flow Statement
    18:49
  • l. Case 3 on Cash Flow Statement
    31:27

  • a. Introduction of Excel
    01:31
  • b. Basics of Excel - Workbook and Sheet
    07:18
  • c. Introduction of Ribbons
    06:09
  • d. SUM Function
    01:33
  • e. Minimum and Maximum Function
    03:06
  • f. SUMPRODUCT Function
    05:41
  • g. IF Function
    05:38
  • h. IF with AND Function
    10:57
  • i. IF ERROR Function
    03:38
  • j. TRANSPOSE Function
    05:04
  • k. VLOOKUP Function
    07:59
  • l. Formatting - Bold, Merge, Sum Function, Hiding and Unhiding of Rows
    10:24
  • m. Formatting - Understanding of Borders
    20:03

  • a. Introduction of Financial Management - What is Financial Management
    15:10
  • b. Wealth Maximization and Profit Maximization
    13:45

  • a. Introduction of Time Value of Money
    18:45
  • b. Detailed Example of Present Value and Future value Concepts
    22:14
  • c. Cases on Future Value
    17:24
  • d. Continued Cases on Future Value
    14:58
  • e. Nominal Interest and Effective Interest Rate
    11:42

  • a. Sources of Finance
    03:37
  • b. Internal and External Sources of Finance
    06:26
  • c. Internal and External Sources of Finance - Part 2
    02:55

  • a. Discussion on Working Capital, Operating Cycle and Working Capital Ratios
    57:34
  • b. Cases on Working Capital
    51:54

  • a. Content of Fundamental Analysis
    04:29
  • b. Introduction of Fundamental Analysis
    07:24
  • c. Introduction of Fundamental Analysis Continued
    05:39
  • d. Introduction of Fundamental Analysis - CAGR
    06:04
  • e. Who can be Fundamental Analyst
    02:40
  • f. Important tools of Fundamental Analysis
    04:11
  • g. Mindset of Investor
    07:07
  • h. Qualitative analysis vs. Quantitative analysis
    07:30
  • i. Qualitative Analysis
    09:16
  • j. Quantitative Analysis
    04:17

  • a. Introduction of Annual Report
    02:30
  • b. Components of Annual Report
    03:51
  • c. Corporate Overview - Part 1
    08:27
  • d. Corporate Overview - Part 2
    06:25
  • e. Corporate Overview - Part 3
    04:30

  • a. Integrated Report - Part 1
    06:59
  • b. Integrated Report - Part 2
    07:21
  • c. Integrated Report - Part 3
    01:21

  • a. Board and Management Discussion
    03:24
  • b. Management and Discussion Analysis
    12:13

  • a. Report on Corporate Governane
    13:22
  • b. Directors Report
    10:13

  • a. Introduction of Financial Statement Analysis
    11:27
  • b. Horizontal Analysis of Balance Sheet
    10:51
  • c. Vertical Analysis of Balance Sheet - Part 1
    11:00
  • d. Vertical Analysis of Balance Sheet - Part 2
    03:57
  • e. Horizontal Analysis of Profit and Loss Account
    08:11
  • f. Vertical Analysis of Profit and Loss Account
    06:29
  • g. Introduction of Ratios - Adani Vs. Hindenberg
    08:57
  • h. Liquidity Ratios - Current Ratio and Case Study 1
    13:05
  • i. Quick Ratio and Practical Case
    09:39
  • j. Cash Ratio and Practical Case
    07:50
  • k. Case Study for Liquidity Ratios
    05:02

  • a. Solvency Ratios - Equity Ratio and Multiple cases
    22:03
  • b. Debt to Equity Ratio
    05:30
  • c. Case Study on Solvency Ratios
    05:25
  • d. Debt to Assets Ratio and Capital Gearing Ratio
    16:51

  • a. Introduction of Coverage Ratios
    09:42
  • b. Interest Coverage Ratio
    06:53
  • c. Debt Service Coverage Ratio
    06:38
  • "4. Preference Dividend Coverage Ratio "
    02:51

  • a. Profitability Ratios Related to Sales - Net, Gross and Operating Profit Ratio
    20:10
  • b. Case Study on Profitability Ratio Related to Sales
    06:13
  • c. Return on Investment, Asset, Capital Employed and Equity
    20:01
  • d. Case Study 1 on Return on Asset and Capital Employed
    12:28
  • e. Case Study 1 on Return on Asset, Equity and Capital Employed
    12:07
  • f. Earning Per Share and Dividend Per Share - Annual Report
    14:58
  • g. Practical case on DPS and Dividend Yield
    05:43

  • a. PE Ratio, Dividend Yield and Earning Yield
    14:56
  • b. PB Ratio - Price to Book Value Ratio
    07:58

  • a. Introduction of Turnover Ratios
    07:16
  • b. Total Asset, Fixed Asset, Capital Employed and Current Asset Turnover Ratio
    12:06
  • c. Practical Case on Turnover Ratios
    11:09
  • d. Operating Cycle - Amazon and Apple Case Study
    33:17
  • e. Inventory Turnover Ratio
    08:32
  • f. Receivable Turnover Ratio
    07:53
  • g. Payable Turnover Ratio
    06:10
  • h. L and T Case Study - Understanding of Turnover Ratios
    10:07

  • a. Financial Leverage
    40:41
  • b. Discussion about Operating Leverage
    29:20
  • c. Case on Operating Leverage
    13:35

  • a. Analysis of Balance Sheet of Tata Motors
    14:37
  • b. Balance Sheet Ratios of Tata Motors
    12:36
  • c. Balance Sheet Ratios Continued
    18:08
  • d. Balance Sheet Ratios Continued
    09:21
  • e. Financial Statement of Tata Motors
    09:02
  • f. Profit and Loss Ratios - Tata Motors
    14:24
  • g. Profit and Loss Ratios - Continued
    06:17
  • h. Financial Highlights of Tata Motors
    20:00

  • a. Ratios - EPS and CEPS
    09:01
  • b. Ratios - DPS, Adjusted DPS and EPS
    07:33
  • c. Ratios - Book Value Per Share
    04:14
  • d. Ratios - Margin Ratios
    04:28
  • e. Ratios - ROA, ROE, ROCE and ATO
    06:50
  • f. Ratios - DTO, ITO, WCTO and Sales to FA, Sales to WC
    06:16
  • g. Ratios - Efficiency Ratios, Growth Ratios and Financial Stability Ratios
    12:59

  • a. Introduction of Business Mathematics
    04:56
  • b. Simple Interest and Compound Interest
    08:41
  • c. Days Count Formula in Excel
    04:26
  • d. Calculation of Effective Rate in Excel
    06:18
  • e. Calculation of Nominal Rate in Excel
    03:02

  • a. Calculation of FV of Annuities Formula in Excel
    06:03
  • b. Calculation of FV Annuities - Case 1
    08:31
  • c. Calculation of FV Annuities - Case 2
    04:58
  • d. Calculation of FV Annuities - Case 3
    09:05
  • e. Calculation of FV Annuities - Case 4
    07:00

  • a. Introduction of NPER in Excel
    02:24
  • b. NPER - Case 1 in Excel
    05:55
  • c. Calculation of Rate in Excel
    01:54
  • d. Rate Case - 1 in Excel
    03:56
  • e. Rate Case - 2 in Excel
    04:57
  • f. Rate Case - 3 in Excel
    05:23
  • g. Rate Case - 4 in Excel
    04:52
  • h. Rate Case - 5 in Excel
    04:10

  • a. Introduction of Loan Amortization Schedule in Excel
    04:49
  • b. Loan Amortization Schedule Case - 1 in Excel
    08:49
  • c. Loan Amortization Schedule Case - 2 in Excel
    06:59
  • d. Loan Amortization Schedule Case - 3 in Excel
    05:06
  • e. Loan Amortization Schedule Case - 4 in Excel
    06:11
  • f. Loan Amortization Schedule Case - 5 in Excel
    05:05

  • a. Introduction of Mean in Excel
    04:07
  • b. Mean - Case 1 in Excel
    03:52
  • c. Median - Case 1 in Excel
    04:07
  • d. Median - Case 2 in Excel
    05:25
  • e. Introduction of Mode in Excel
    03:40
  • f. Mode - Case 1 in Excel
    02:56

  • a. Risk and Uncertainty - Standard Deviation
    25:26
  • b. Continuity of Risk and Uncertainity
    15:34
  • c. Understanding of Financial Risk
    29:09
  • d. Case Study on Financial Risk
    40:40

  • a. Introduction of Corporate Finance Module
    07:51
  • b. Introduction of Capital Budgeting
    10:31
  • c. Real Life Case to Understand the Capital Budgeting and Calculation of Cost of Debt - Kd
    21:05
  • d. Cost of Equity - Ke
    38:21
  • e. WACC - Weighted Average Cost of Capital
    05:40
  • f. Sales Forecasting
    19:43
  • g. Calculation of Cost of Sales and Customer Acquisition Cost
    14:04
  • h. Calculation Salary, Depreciation and Interest
    07:20
  • i. Preparation of Income Statements
    04:57
  • j. Calculation of Cash Profit, Present Values and Net Present Value
    27:48
  • k.Calculation of IRR and Profitability Index
    06:11
  • l. Sensitivity Analysis
    24:54

  • a. Equity Valuation - Valuation Methods
    12:22
  • b. Absolute and Relative Valuation Method
    17:26
  • c. Intrinsic Value and Mispricing
    19:11
  • d. Fair Value and Fair Market Value
    10:35
  • e. Dividend Discounting Valuation Model
    10:58
  • f. Single Holding Period Method - DDM
    18:02
  • g. Multiperiod Dividend Discounting Model
    18:52
  • h. Gordon Growth Model
    20:59
  • i. Case on Gordon Growth Model
    08:00

  • a. Introduction of Financial Model and Case Study
    52:18
  • b. Continuation of Financial Modelling Case Study
    25:32

  • a. Introduction of start up valuation, forecasting of sales, account receivables and cash collection
    42:10
  • b. Forecasting of COGS, inventory budget, purchase budget and account paybles
    23:10
  • c. Forecasting of expenses and preparation of fixed asset schedule
    28:13
  • d. Preparation of cash budget
    29:05
  • e. Preparation of balance sheet and cash flow statement
    34:29
  • f. Valuation of business and sensitivity analysis
    31:32

  • a. Introduction of Colgate Palmolive
    19:11
  • b. Introduction of Colgate annual report and fetching of data from annual report
    21:48
  • c. Profit and loss account, forecasting of sales and discussion about non controlling interest
    41:48
  • d. Forecasting of expenses, vertical analysis and working capital calculation
    45:51
  • e. Forecasting of property, plant and equipment balance
    53:02
  • f. Discussion about intangibles, shareholder equity and ESOP
    40:49
  • g. Detailed discussion about shareholder equity, EPS, ESOP and Options
    63:43
  • h. Detailed discussion about debt schedule and treasury shares
    51:20
  • i. Finalization of Cash Flow Statement and Balance Sheet
    29:35
  • j. Valuation of business, sensitivity analysis and formatting of model
    57:20

  • a. Introduction of Leverage Buyout
    27:48
  • b. Leverage Buyout Model
    37:08
  • c. Leverage Buyout Model Continued
    41:58

  • a. Introduction and Forecasting Standalone Income Statement
    47:40
  • b. Understanding of Assumptions and preparation of Proforma Profit and Loss a/c
    41:47
  • c. Debt Schedule and PPE Adjustment
    38:25
  • d. Finalization of BS, EPS Analysis and Sensitivity Analysis
    44:37

  • a. What is Equity Research
    14:01
  • b. How to do Equity Research
    18:37
  • c. Sector Analysis
    26:35
  • d. Introduction of Cement Manufacturing Process
    18:53

  • a. Discussion about ACC Limited
    26:56
  • b. Research on ACC Limited
    10:42
  • c. Discussion about ACC Analyst Call
    27:57
  • d. Extract of ACC Analyst Call for preparation of Financial Model
    31:45

  • a. Forecasting of Revenue and Cost of Inventory Consumed
    32:43
  • b. Continuity of Cost of Inventory Consumed
    17:17
  • c. Creation of Assumptions for Profit and Loss Account
    22:15
  • d. Forecasting of Property Plant and Equipment Value
    21:59
  • e. Forecasting of Balance Sheet Assumptions
    31:21
  • f. Creation of Working Capital and Operating Cycle Assumptions
    21:05
  • g. Creation of Liability Assumptions
    18:31
  • h. Forecasting of Profit and Loss Account
    16:46
  • i. Forecasting of Balance Sheet
    25:00

  • a. Preparation of Cash Flow Statement
    32:56
  • b. Completion of Cash Flow Statement and Balance Sheet
    17:01
  • c. Calculation of Present Value of Future Cash Flows
    18:28
  • d. Calculation of Terminal Value and Intrinsic Value of Stock
    09:28

  • a.Automation of Excel with AI
    9:21
  • b. Inserting pivot table using AI
    9:38
  • c. Structuring of data through AI
    10:01
  • d. Data Analysis with AI
    6:35
  • e. Descriptive Statistics and Pivot Table with AI
    11:10
  • e. Template Generator
    10.37

Copyright © 2023 COMandFIN Edutech. Website Design & Maintain by KP TECHNOSYS. All Rights Reserved