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 Crash Course

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.8 rating
19586 views students
Sophia Jaymes
By >CA Ankit Bajaj @ www.comandfin.com
  • Last updated Last updated Jan 2024
  • English
  • Certified Course
Preview this course
5599.00
19586 views students
  • Tagline
  • Enrolled875 students enrolled
  • Rating4.8
  • Time40+ hours of video content published
  • LanguageEnglish
  • Views19586 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

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

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