Private Library for Business-Only Content.

Lynda – Yash Patel – Forecasting Using Financial Statements

Lynda – Yash Patel – Forecasting Using Financial Statements
[29 FLV, 36 XLSX]

This product can only be requested by members. To get this product, you must be a member
Apply for Membership


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 regreessions 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
  • Reviews

    There are no reviews yet.

    Be the first to review “Lynda – Yash Patel – Forecasting Using Financial Statements”
    Quick Navigation