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

[@bencoleman8171]

When did you put in the cash forecast?

[@maxeigenbrod4579]

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

[@CorporateFinanceAcademy]

we will add it to our list!

[@kailaliak]

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

[@CorporateFinanceAcademy]

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

[@girishakhurana3075]

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

[@CorporateFinanceAcademy]

no - it all balances!

[@Hamza-yv6uy]

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

[@CorporateFinanceAcademy]

It’s available on the home page!

[@amitghanekar7492]

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

[@keithhustak1946]

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

[@MZAHIDSHAFI]

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

[@CorporateFinanceAcademy]

sorry - not sure your question?

[@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!

[@CorporateFinanceAcademy]

Thanks for the feedback!

[@mahanajdi9497]

thanks for explanation, can i get the excel please.

[@CorporateFinanceAcademy]

It’s available on the home page if you sign up there!

[@HishamPM]

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

[@CorporateFinanceAcademy]

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]

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