Program Overview

Forecasting Using Financial Statements

Course Description

Forecasting Using Financial Statements provides a deep dive into the mathematics of financial forecasting. The course covers how to build a complete forecast from start to finish, using Excel or Google Sheets. Instructor 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. Additionally, the course covers how to build cash flow projections, calculating earnings before interest and taxes, depreciation and capital expenditures, and net working capital. By the end of this course, students should be able to provide projections for a business using nothing more than commonly available financial statements.

Related Classes

• Personal Finance Tips and Tricks
  • Taught by Amanda Clayman
  • Covers personal finance tips and tricks for individuals at any stage of their financial life
• Using Power BI to be a Strategic Financial Partner
  • Taught by Joshua Rischin
  • Shows how to harness the full potential of Microsoft Power BI for financial analysis
• Personal Finance Tips Weekly
  • Taught by Amanda Clayman
  • Helps build a healthy financial life one week at a time
• Taxes for Small Business
  • Taught by Jane Barratt
  • Covers tax management and minimization strategies for small businesses
• Financial Record Keeping
  • Taught by Kay Stice
  • Covers the basics of bookkeeping and financial record keeping for businesses
• Finance Foundations: Risk Management
  • Taught by Jason Schenker
  • Introduces financial risk management concepts and strategies
• Excel: Analyzing and Visualizing Cash Flows
  • Taught by Curt Frye
  • Covers how to evaluate and visualize cash flows using Excel
• Business Math
  • Taught by Kay Stice
  • Covers basic math concepts for business applications
• Freelancing and Consulting in User Experience
  • Taught by Cory Lebson
  • Explores freelancing and consulting opportunities in user experience
• Financial Wellness for Couples and Families
  • Taught by Amanda Clayman
  • Covers financial wellness strategies for couples and families
• Managerial Economics
  • Taught by Stefan Michel
  • Applies economic concepts to managerial decision-making
• Financial Analysis: Making Business Projections
  • Taught by Rudolph Rosenberg
  • Covers financial analysis and projection techniques for businesses
• Running a Profitable Business: Calculating Breakeven
  • Taught by Kay Stice
  • Introduces breakeven analysis and cost-volume-profit analysis for businesses
• Finance Foundations: Business Valuation
  • Taught by Kay Stice
  • Covers business valuation concepts and methods
• Managing Your Personal Investments
  • Taught by Jane Barratt
  • Provides guidance on personal investment management
• Running a Profitable Business: Revenue Recognition
  • Taught by Kay Stice
  • Covers revenue recognition principles and practices
• Financial Wellness: Managing Personal Cash Flow
  • Taught by Amanda Clayman
  • Helps individuals manage their personal cash flow effectively
• Running a Profitable Business: Understanding Cash Flow
  • Taught by Kay Stice
  • Explains cash flow statement analysis and management
• Accounting Foundations: Managerial Accounting
  • Taught by Kay Stice
  • Introduces managerial accounting concepts and applications
• Finance Essentials for Small Business
  • Taught by Kay Stice
  • Covers essential finance concepts for small businesses