Instructor for this course
more

Balance sheet forecasting sounds terribly tough, but it’s not. If you can forecast your P & L, then balance sheet forecasting is just an extension that can strengthen the quality of your earnings forecast and actually help predict the future financial health of your organization. For example, a balance sheet forecast provides that critical cash flow dimension which will assure banks and investors that you can match sources with uses of funds to achieve everyone’s financial goals. Bruce Lynn, a corporate treasury consultant specializing in cash and working capital management, walks through a “how to” to suggest practical best practices in balance sheet forecasting, using examples and numbers to help cement the learning. 

The course discusses why balance sheet forecasting is important and how to link it to a P & L forecast. The course also covers the assumptions required to forecast key components of any balance sheet with its ability to provide insight into future financial ratios, working capital (A/R, Inventory and A/P), cash and investments, CAPEX, debt and equity. 

By the end of the course you and your planning team will be able to initiate a balance sheet forecast and integrate this forecast with the other parts of your financial plan.

Learning Objectives

  • Recognize why balance sheet forecasting is important and how to link it to a P & L forecast
  • Identify the assumptions required to forecast key components of any balance sheet
  • Discover how to initiate a balance sheet forecast

16 Reviews (72 ratings)Reviews

4
Member's Profile
Very good class but the audio was a little low. Had to have my speakers a bit higher than some of the other classes. Not sure why... Focused more on ratios than I anticipated but good coverage of the process and the players involved.
4
Member's Profile
Forecasting a balance sheet in the near term is essential, but corroborative, with a direct model in the short term. Long term balance sheet forecasting is more aspirational, but should be directionally accurate.
3
Anonymous Author
This a good course with a lot of real world examples. However, the audio is muffled and the graphics contained a lot of details, which made it difficult to follow at a good pace.
3
Anonymous Author
There were good examples, like the Apple business case, but not enough other business cases to assist with forecasting. The instructor was not as engaging as other courses.
5
Member's Profile
Good presentation that provided examples and supplemental charts to effectively cover key points. Presenter is very knowledgeable on the topic and recommend course.
4
Anonymous Author
This course provided good high level information. It was good from an upper management point of view.
2
Member's Profile
Included true and essential info, but not any take aways to implement into my current model
4
Member's Profile
Interesting - just now getting looking at starting balance sheet forecasting - very helpful
Anonymous Author
i had expected more practical explantion with examples about balance sheet forecast.
3
Anonymous Author
The content was good, but it was very difficult to hear in quite a few spots.
5
Anonymous Author
This is a good high level review of why to do a balance sheet forecast.
4
Anonymous Author
Great overview and explanation of need for Balance Sheet Forecasting
4
Anonymous Author
Was hoping for more working capital estimating techniques.
4
Anonymous Author
Some real good takeaways.
4
Anonymous Author
Overall good course.
5
Anonymous Author
excellent review

Prerequisites

Course Complexity: Intermediate

Knowledge of key finance terms along with an understanding of how the balance sheet works, and how it interplays with the P&L and the cash flow statement.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
Better Planning
  9:44Importance of Forecasting
  5:25Links to P&L Forecast
  12:00Forecasting Criteria
  9:35Forecasting Criteria (Continued)
Measuring Success
  8:14Measuring Forecast Success
  8:11Measuring Forecast Success Example
CONCLUSION
  10:33Initiating Balance Sheet Forecasting and Conclusion
Continuous Play
  1:04:24Better Planning Through Balance Sheet Forecasting
SUPPORTING MATERIALS
  PDFSlides: Balance Sheet Forecasting
  PDFBalance Sheet Forecasting Glossary/Index
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM