Let's Build a Financial Model from Scratch | Session 1

Поділитися
Вставка
  • Опубліковано 27 гру 2024

КОМЕНТАРІ • 44

  • @Muhammad_Shahnawaz
    @Muhammad_Shahnawaz 2 роки тому +6

    Hi Honourable. Accept my Thanks for Your "The Best of A Teacher" tune.
    It's almost 80% role of Fintree in my study of ACMA-Pakistan.
    I am Your big fan equal to Honourable Kapil Dev.
    Stay Blessed and Happy. Prayers from Pakistan.

    • @FintreeIndia
      @FintreeIndia  2 роки тому

      🙏thank you for your kinds words !

  • @govindgoel369
    @govindgoel369 2 роки тому +6

    -What will we learn about
    1)IS, BS, CFS
    2)Variety of different ratio on practical basis
    3)Case study
    4)Earning call transcript also known as confrance call
    5)Annual report
    6)Industry report
    7)Hardcoding
    8)Modeling-Assumption tab, revenue model, cost model
    9)Valuation
    -Income statement
    1)we are looking for performance of company!
    Ways to watch company performance is sales/Revenue/Topline.
    2)Ebitda -: Add -Top Line. 100
    Less - COGS. 40
    Gross profit - 60
    Less - Selling general admin cost 20 EBITDA is also known Cash op profit-40
    Less-Dep 10
    Ebit - 30
    interest expenditure - 5
    EBT- 25
    Tax expen - 10
    Pat/Eat/Np/NI/Bottom Line = 15
    -screener - 1)profit margin- Manufacturing cost +material cost
    2)creat screen - Put formula
    3)OPM- Net profit / Sales
    -Annual report
    Find out value by ITC business model
    1)GPM - NP-COGS/sales
    2)OPM- EBIT/SALES
    3)NPM-Net profit / Sales
    4)PAT GROWTH
    5)YOY REVENUE GROWTH
    6)Any other observation - Company Top income surge comparison to (PY) but NP increase.
    7)Net revenue (net of excise) - Collect by government and apply for minor sector.
    8)Sir put -1 for getting value in percentage.

  • @abdullahkamalpasha4579
    @abdullahkamalpasha4579 2 роки тому +2

    Great work, keep it up. Regards

  • @BabygirlTara
    @BabygirlTara 2 роки тому +4

    wonderful session

  • @jayatijoshi1111
    @jayatijoshi1111 2 роки тому

    Your teaching style is really good

  • @govindgoel369
    @govindgoel369 2 роки тому +3

    Can you please check your GPM and OPM again please at the end 2:00:00 because money control and your margin has far changes.

  • @s.m.hassan3887
    @s.m.hassan3887 2 роки тому +15

    fintree pls upload all the lectures of financial modeling not just 3. Thnks

    • @mayankjain5836
      @mayankjain5836 2 роки тому +10

      pay for it brother. everything doesnt come for free

    • @govindgoel369
      @govindgoel369 2 роки тому +2

      @@mayankjain5836 Sir everyone doesn't have money like me I just cleared my 12th and wanna learn it so I wanna learn this skill ambitiously. please ho saka toon aur video daliya

    • @shivanshshukla5883
      @shivanshshukla5883 2 роки тому +2

      @@govindgoel369 If you don't have money earn it, nowadays you earn money online if you have skills. There are even excel part time jobs, why wiuld anyone give his time and effort and built up knowledge for free?

    • @govindgoel369
      @govindgoel369 2 роки тому +2

      @@shivanshshukla5883 this type of course is available on udemy which more content in just 600. I didn't under why are you buying his course at 33k.

  • @surendramourya6345
    @surendramourya6345 2 роки тому +2

    Thank you Sir 😊

  • @praggyab
    @praggyab 2 роки тому +2

    Woah! Thanks for this

  • @tradewidtejas2249
    @tradewidtejas2249 2 роки тому +1

    sir, indeed very nice teaching style . try to upload all session on youtube

  • @alejandrarivera8620
    @alejandrarivera8620 2 роки тому +1

    Hi! Which app is the teacher using for copy-paste in Mac when he downloads the .pdf annual report? I want to be ready for whatever comes next. Thanks! (By the way, I am enjoying this course! So thankful for giving us a hint with the first three sessions :)

  • @sushil6509
    @sushil6509 Рік тому +1

    47:00

  • @ishaqfashioncenter4806
    @ishaqfashioncenter4806 Рік тому

    Thanks for sharing such a beautiful video for disbursing knowledge. Sir will you please elaborate how tackle non-controlling interest (minority interest) in cash flow statement (for financial modeling). Thanks in advance

  • @kailashverma6566
    @kailashverma6566 2 роки тому

    Hi sir
    Kya kisi small private limited company ki financial statement ko analysis krke y pta cal skta h
    Company kha non value addition activity m expenses kr rhi h during their operations
    And uske basis pr cost control measures suggest kiye ja skte h

  • @Gaurav_Modi
    @Gaurav_Modi 2 роки тому +4

    Thanks. Pls upload the complete series (all sessions) of financial modelling

    • @shivanshshukla5883
      @shivanshshukla5883 2 роки тому +1

      He needs money

    • @maheshrawat7572
      @maheshrawat7572 2 роки тому

      @@shivanshshukla5883 how much? whats the complte duration hrs ?

    • @shivanshshukla5883
      @shivanshshukla5883 2 роки тому +1

      @@maheshrawat7572 website pe dekh na bc yaha kya poch rha hai. Course acha hai par maine nahi liya

  • @arjungupta2687
    @arjungupta2687 2 роки тому +3

    will you upload the complete series ?

    • @FintreeIndia
      @FintreeIndia  2 роки тому +5

      First three sessions

    • @indernegi9668
      @indernegi9668 2 роки тому

      @@FintreeIndia Sir first of all thanks a lot for the series, it is a great learning opportunity for people like me who are from non-finance backgrounds. sir, what's after that? is there a course that we can join to continue learning?

    • @parthmonani2744
      @parthmonani2744 2 роки тому +1

      @@FintreeIndia how many sessions is there??

    • @FintreeIndia
      @FintreeIndia  2 роки тому

      @@parthmonani2744 ~ 18 to 20 sessions

    • @parthmonani2744
      @parthmonani2744 2 роки тому

      @@FintreeIndia price of all lecture???

  • @hardiksanghvi3522
    @hardiksanghvi3522 2 роки тому

    How many sessions are there?

  • @ujjwalpathak4606
    @ujjwalpathak4606 2 роки тому

    Top Line

  • @arindambanerjee3326
    @arindambanerjee3326 2 роки тому

    What is the fees for the programme?

  • @sacredbulls7187
    @sacredbulls7187 2 роки тому

    hwere th other sessions will be uploaded after 3 sessions

  • @jhapangbevdi
    @jhapangbevdi 2 роки тому

    hi this is megha. please see if you can check for any hospital

  • @jhapangbevdi
    @jhapangbevdi 2 роки тому

    take hospital industry

  • @ujjwalpathak4606
    @ujjwalpathak4606 2 роки тому

    EBIT

  • @ujjwalpathak4606
    @ujjwalpathak4606 2 роки тому

    Gross profit

  • @ujjwalpathak4606
    @ujjwalpathak4606 2 роки тому

    Bottom line

  • @jhapangbevdi
    @jhapangbevdi 2 роки тому

    hospital