Linkedin Learning
Linkedin Learning Logo

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
Read more
Details Icon

Financial Modeling and Forecasting Financial Statements
 at 
Linkedin Learning 
Course details

What are the course deliverables?
  • Financial Statement Analysis
  • Financial Modeling
More about this course
  • 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

Other courses offered by Linkedin Learning

– / –
1 hours
Intermediate
25 K
1 month
– / –
– / –
1 hours
Advanced
1.85 K
1 hours
Intermediate
View Other 504 CoursesRight Arrow Icon
qna

Financial Modeling and Forecasting Financial Statements
 at 
Linkedin Learning 

Student Forum

chatAnything you would want to ask experts?
Write here...