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

Al-Enhanced Financial Modeling Program

Learn to build financial models from scratch! This course equips you with the essential tools and techniques to forecast financial performance, analyze company valuation

Best Seller Icon Bestseller
4.8
4.9 rating
23982 views students
Sophia Jaymes
By >CA Ankit Bajaj @ www.comandfin.com
  • Last updated Last updated Jan 2024
  • English
  • Certified Course
Preview this course
7999.00
23982 views students
  • Tagline
  • Enrolled861 students enrolled
  • Rating4.9
  • Time80+ hours of video content published
  • LanguageEnglish
  • Views23982 views
  • AutherCA Ankit Bajaj
  • Last Update Last updated Jan 2024
Show More
About Images
Education Logo Images

Get Your Course Brochure Now

Fill In Your Details

Close

What you'll learn

What you'll learn

The Financial Modelling course is designed to provide participants with the skills and knowledge required to create robust financial models for a variety of applications, including valuation, budgeting, forecasting, and investment analysis. This practical, hands-on course is ideal for finance professionals, analysts, and anyone looking to advance their expertise in financial modelling.

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 & 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&l and BS
    23:44
  • h. Case 1 - Part 2 : Trial Balance, P&l and BS
    11:42
  • i. Case 2 - Part 1 : Trial Balance, P&l, BS & CFS
    15:47
  • j. Case 2 - Part 2 : Trial Balance, P&l, BS & 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. 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

  • 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&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 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 & 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 & 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 & 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