Balance Sheet Forecast - How to build a balance sheet forecast in excel

Поделиться
HTML-код
  • Опубликовано: 3 окт 2024

Комментарии • 21

  • @reynaldofigueroa3059
    @reynaldofigueroa3059 Год назад

    Thanks for te video, it would help to quickly explain the assumptions on each line of the balance sheet! but thanks for providing this video for free!

  • @bencoleman8171
    @bencoleman8171 8 дней назад

    When did you put in the cash forecast?

  • @maxeigenbrod4579
    @maxeigenbrod4579 Год назад +1

    Could you make a video on how to do Balance Statement Forecasting Using Method 1 - "bottoms up" forecasting ?

  • @MZAHIDSHAFI
    @MZAHIDSHAFI 8 месяцев назад

    Hi Thanks for the video really appreciate that, I just wanted to know how you took the cash balance ?

  • @girishakhurana3075
    @girishakhurana3075 2 года назад +1

    How did you balance the balance sheet? Was there any balancing figure?

  • @kailaliak
    @kailaliak 3 года назад +1

    Hello! May I know why the common stock under stakeholder’s equity remains constant throughout the years?

    • @CorporateFinanceAcademy
      @CorporateFinanceAcademy  3 года назад

      it was just an assumption that no additional common stock was issued over that time period. make sense?

  • @amitghanekar7492
    @amitghanekar7492 Год назад

    Why you take 5000 as short term borrowong and 5000 for long term payment????

  • @keithhustak1946
    @keithhustak1946 2 года назад

    Hi- i have tried to access the excel spreadsheet but even after submitting my email i am not getting it. I also tried to use contact us link but also did not work? Love the content

  • @mahanajdi9497
    @mahanajdi9497 Год назад

    thanks for explanation, can i get the excel please.

  • @Hamza-yv6uy
    @Hamza-yv6uy 2 года назад +1

    Hello ! Can you please send me the file ? Really appreciate it.

  • @HishamPM
    @HishamPM 3 года назад

    What's behind the $C$96 cell in 4:47?

    • @CorporateFinanceAcademy
      @CorporateFinanceAcademy  3 года назад

      It is the 5 year average of depreciation expense as a % of PP&E (in this case it is assuming that 18% of your P&PE depreciates each year). If you go to our website and sign-up for the mailing list you can download the free template!

    • @HishamPM
      @HishamPM 3 года назад

      @@CorporateFinanceAcademy Thank you so much! Honestly, I never thought I'd receive a reply. I just signed up on your website. How would I download the template?