Forecasting Using Financial Statements
By: Yash Patel
Duration: 2h 5m
Released: November 8, 2017
Learn where a company is headed and the resources it will need to succeed. Forecasting Using Financial Statements provides a deep dive into the mathematics of financial forecasting. Dig into the numbers and find out how to build a complete forecast from start to finish, using Excel or Google Sheets. Yash Patel dissects an income statement and balance sheet to calculate pro-forma predictions for revenue, equipment, sales cost, and more. He also shows the math behind simple forecasting techniques, such as the naive approach, simple moving average, and exponential smoothing. He also shows how to build cash flow projections, calculating earnings before interest and taxes, depreciation and capital expenditures, and net working capital. Yash also uses data to create regressions that can extrapolate and forecast for a given independent value. By the end of this course, you should be able to provide projections for a business using nothing more than commonly available financial statements.
- The four different types of financial statements
- Moving averages
- Seasonally adjusted trends
- Pro forma statements
- Sales forecasting
- Forecasting expenses
- Projecting cash flow
- Regression analysis
Table of Contents:
- 1. Finance Basics
- 2. Simple Financial Forecasting
- 3. Pro Forma Financial Statements
- 4. Projecting Cash Flows
- 5. Introduction to Regression Analysis
Yash Patel is an instructor and instructional designer at LinkedIn Learning.
He comes from a teaching background and has taught learners ranging from middle school science students to adult software developers. Yash is passionate about empirical and data-driven decision making and strives to empower others with knowledge on how to design experiments, ask the right questions, and derive meaningful results. Yash lives on the sunny California coast and enjoys playing tennis in his free time.