Financial Modeling and Forecasting Financial Statements (2019)
1h 54mIntermediate2019-10-02
Authors

Jim Stice
Professor of Accounting at BYU

Kay Stice
Professor of Accounting at the BYU Marriott School of Management
Course details
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.
Learning objectives
Explain the importance of financial statements
Interpret the factors of a sales forecast
Determine the types of impacts that cause financial statement numbers to change
Differentiate the elements of a forecasted income statement
Apply the accounting equation to reconciling a balance sheet
Explain what is needed to deduce cash flow
Learning objectives
Explain the importance of financial statements
Interpret the factors of a sales forecast
Determine the types of impacts that cause financial statement numbers to change
Differentiate the elements of a forecasted income statement
Apply the accounting equation to reconciling a balance sheet
Explain what is needed to deduce cash flow
Skills covered
Accounting SkillsCorporate FinanceFinance and AccountingDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Projecting the financial future
- 02 - What you should know
1. Who Uses Forecasted Financial Statements
- 03 - Use the past to understand the future
- 04 - Keys to running a business
- 05 - Financial forecasts and loans
- 06 - Financial forecasts and investment decisions
- 07 - Use financial forecasts to understand new information
2. It All Starts with an Accurate Sales Forecast
- 08 - IBM and the famously bad sales forecast
- 09 - Combine historical trends with current plans
- 10 - Incorporate seasonal patterns and recent developments
- 11 - The costs of being wrong
3. What Causes Financial Statement Numbers to Change
- 12 - Home Depot 1985 - Three weeks to live
- 13 - The impacts of natural changes
- 14 - The impacts of long-term planning decisions
- 15 - The impacts of financing choices
4. Constructing a Forecasted Income Statement
- 16 - The Gap and predictable change
- 17 - Forecasting sales-based expenses
- 18 - Fixed costs and variable costs
- 19 - Forecasting interest and income taxes
5. Constructing a Forecasted Balance Sheet
- 20 - The power of the accounting equation
- 21 - Identifying the missing number
- 22 - Easy plugs - Cash, investments, paid-in capital
- 23 - Realistic but challenging plug - Loans
6. Constructing a Forecasted Statement of Cash Flows
- 24 - The Home Depot story revisited
- 25 - How to deduce cash flows
- 26 - Forecasting operating cash flow
- 27 - Forecasting investing cash flow
- 28 - Financing cash flow
Conclusion
- 29 - Dynamic modeling