Financial Modeling and Forecasting Financial Statements
- Offered byLinkedin Learning
Financial Modeling and Forecasting Financial Statements at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,400 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Financial Modeling and Forecasting Financial Statements at Linkedin Learning Highlights
- Earn a sharable certificate
- 1 exercise file
- 6 quizzes
- Access on tablet and phone
- Continuing Education Units
Financial Modeling and Forecasting Financial Statements at Linkedin Learning Course details
- Financial Statement Analysis
- Financial Modeling
- In this course, Jim and Kay Stice explains how to create forecasted financial statements for 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
- Learner 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
Financial Modeling and Forecasting Financial Statements at Linkedin Learning Curriculum
Introduction
Projecting the financial future
What you should know
Who Uses Forecasted Financial Statements?
Use the past to understand the future
Keys to running a business
Financial forecasts and loans
Financial forecasts and investment decisions
Use financial forecasts to understand new information
It All Starts with an Accurate Sales Forecast
IBM and the famously bad sales forecast
Combine historical trends with current plans
Incorporate seasonal patterns and recent developments
The costs of being wrong
What Causes Financial Statement Numbers to Change?
Home Depot 1985: Three weeks to live
The impacts of natural changes
The impacts of long-term planning decisions
The impacts of financing choices
Constructing a Forecasted Income Statement
The Gap and predictable change
Forecasting sales-based expenses
Fixed costs and variable costs
Forecasting interest and income taxes
Constructing a Forecasted Balance Sheet
The power of the accounting equation
Identifying the missing number
Easy "plugs": Cash, investments, paid-in capital
Realistic but challenging "plug": Loans
Constructing a Forecasted Statement of Cash Flows
The Home Depot story revisited
How to deduce cash flows
Forecasting operating cash flow
Forecasting investing cash flow
Financing cash flow
Conclusion
Dynamic modeling