Introduction
  • Course Introduction and Goals
  • Course Reviews and Feedback System
  • Expanded Introduction to the Course Material
  • Excel Basics - Formatting, Reports and Charts
  • Introduction to the Excel Model
Terminology & Excel Functions
  • Section 2 Worksheet
  • Excel Introduction
  • Excel Functions and Features
Assumptions
  • Section 3 Worksheet
  • Assumptions Introduction
  • Assumptions - Revenue 1
  • Assumptions - Revenue 2
  • Assumptions - COGS
  • Assumptions - Salaries
  • Assumptions - General and Admin
  • Assumptions - Sales and Marketing
  • Assumptions - Balance Sheet
Profit & Loss Statement
  • Section 4 Worksheet
  • Profit and Loss Introduction
  • Profit and Loss - Setup and Format
  • Profit and Loss - Totals Formulas
  • Profit and Loss - Revenue
  • Profit and Loss - Cogs and Op Ex
Balance Sheet
  • Section 5 Worksheet
  • Balance Sheet Introduction
  • Balance Sheet - Setup and Format
  • Balance Sheet - Formulas Part 1
  • Balance Sheet - Formulas Part 2
  • Balance Sheet - Inventory
Statement of Cash Flow
  • Section 6 Worksheet
  • Statement of Cash Flow Introduction
  • Cash Flow - Setup and Format
  • Cash Flow - Totals Formulas
  • Cash Flow - Formulas 1
  • Cash Flow - Formulas 2
  • Cash Flow - Formulas 3
Inventory
  • Section 7 Worksheet
  • Inventory Introduction
  • Inventory - Setup and Format
  • Inventory - Formulas 1
  • Inventory - Formulas 2
Financial Tie Out
  • Section 8 Worksheet
  • Financial Tie Out Introduction
  • Financial Tie Out - Error Checking
  • Financial Tie Out - Model Review
Variance Analysis
  • Section 9 Worksheet
  • Variance Analysis Introduction
  • Variance Analysis - Setup and Format
  • Variance Analysis - Formulas
Financial Summary
  • Section 10 Worksheet
  • Financial Summary Introduction
  • Financial Summary - Setup and Format
  • Financial Summary - Formulas
Course Summary
  • Section 11 Worksheet
  • Course Summary
  • 2020 Update - What's New In The Business For 2020
  • 2021 Entrepreneur Trends To Watch
  • Financial Modeling Assignment
  • Recommended Next Steps
  • Bonus Lecture: Discount For ALL Of My Other Courses AND Free Ebook