Financial Modeling and Forecasting Financial Statements

This course is a part of Become a Financial Analyst, a 10-course series from LinkedIn Learning.

Financial reports are not just summaries of the past—they also include predictions for the future. In fact, most financial institutions are more interested in future performance than historical trends. Banks want to know your future cash flow; investors want to know future profits. In this course, Jim and Kay Stice explains how to create forecasted financial statements for your company. Learn how to use past data such as cost of goods sold, depreciation expenses, and levels of inventory, and understand what caused those numbers to fluctuate over time. Then you can learn how to use the information as the basis for forecasting, applying a simple but powerful equation: assets = liability + equity. You get hands-on practice building three different documents: a forecasted income statement, a forecasted balance sheet, and a forecasted statement of cash flow. Throughout the course, Jim and Kay use famous business cases—like Home Depot’s 1985 cash-flow crisis—to illustrate the importance of accurate financial forecasts and their impact on business decisions.

Contents:

• Introduction
• 1. Who Uses Forecasted Financial Statements?
• 2. It All Starts with an Accurate Sales Forecast
• 3. What Causes Financial Statement Numbers to Change?
• 4. Constructing a Forecasted Income Statement
• 5. Constructing a Forecasted Balance Sheet
• 6. Constructing a Forecasted Statement of Cash Flows
• Conclusion