Forecasting Using Financial Statements
Learn where a company is headed and the resources it will need to succeed.
Forecasting with 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.
Topics include:
The four different types of financial statements
Moving averages
Seasonally adjusted trends
Pro forma statements
Sales forecasting
Forecasting expenses
Projecting cash flow
Regression analysis
* (1.11 MB
* (401.26 MB
Learn where a company is headed and the resources it will need to succeed.
Forecasting with 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.
Topics include:
The four different types of financial statements
Moving averages
Seasonally adjusted trends
Pro forma statements
Sales forecasting
Forecasting expenses
Projecting cash flow
Regression analysis
* (1.11 MB
* (401.26 MB