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

www.corporatefinanceacademy.com/​
In Corporate Finance forecasting (also called planning or budgeting) is an important responsibility, especially in FP&A functions. Forecasting is tied to planning the strategic direction of a company and helps to lay out what the future looks like. This video dives into how to forecast the balance sheet.
If you missed it, you can see the income statement forecast here:
• Income Statement Forec...
Please be sure to subscribe to our channel!
be sure to head to our website and sign-up for our our mailing list, more details coming soon!
www.corporatefinanceacademy.com/
0:00​ Intro to forecasting
1:14​ Cash and Working Capital
4:00​ Property Plant and Equipment
7:46​ Common Stock and Retained Earnings
8:37​ Summary and Conclusion

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

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

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

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

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

[@girishakhurana3075]

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

[@CorporateFinanceAcademy]

no - it all balances!

[@amitghanekar7492]

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

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

[@mahanajdi9497]

thanks for explanation, can i get the excel please.

[@CorporateFinanceAcademy]

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

[@Hamza-yv6uy]

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

[@CorporateFinanceAcademy]

It’s available on the home page!