Build a Unique Financial Forecasting Model in Excel for Your Next Startup | Prashant Panchal | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Build a Unique Financial Forecasting Model in Excel for Your Next Startup

teacher avatar Prashant Panchal, Excel Expert and Data Transformation

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

98 Lessons (11h 48m)
    • 1. S01 0 Introduction to the Class (Build Unique Financial Model)

      6:56
    • 2. S01 1 Financial Modelling Course Roadmap And Outline

      2:34
    • 3. S01 2 What Is Financial Modelling?

      2:07
    • 4. S01 3 Financial Modelling What Are The Inputs And Outputs

      0:51
    • 5. S01 4 What Is Financial Modelling Used For

      5:46
    • 6. S01 5 What Are The Key Components Of Financial Modelling

      3:16
    • 7. S01 6 Short Overview Of The Completed Financial Model

      6:25
    • 8. S02 1 Accounting Basics And Equation For Financial Models

      4:06
    • 9. S02 2 Accounting Basics What are the Debits And Credits

      7:41
    • 10. S02 3 Accrual v Cash Accounting for Financial Modelling

      6:05
    • 11. S02 4 Prepaid Expense And Unearned Revenue With Accrual V Cash Accounting

      4:16
    • 12. S03 1 What is a Balance Sheet?

      6:10
    • 13. S03 2 What Is Income Statement Or Profit Or Loss Statement?

      4:57
    • 14. S03 3 What is a Cashflow Statement?

      4:13
    • 15. S03 4 Two Methods of Cashflow Statements Explained

      5:08
    • 16. S03 5 Indirect Method of Cashflow Statement Explained

      11:53
    • 17. S04 1 Introduciton to Formulas and Function for Financial Modelling

      3:39
    • 18. S04 2 CHOOSE Function Explained

      13:06
    • 19. S04 3 MAX and mIN Function Explained

      7:10
    • 20. S04 4 IF Functions Basics Explained

      7:03
    • 21. S04 5 IF Function with Nested IF Statements

      6:11
    • 22. S04 6 IFS Function Explained

      7:29
    • 23. S04 7 VLOOKUP Function Explained

      6:07
    • 24. S04 8 MATCH Function Explained

      10:54
    • 25. S04 9 VLOOKUP Function with MATCH Function (Advanced Version)

      6:24
    • 26. S04 10 SUMIF Function Explained

      5:06
    • 27. S04 11 OFFSET Function Explained

      14:21
    • 28. S05 1 Financial Modelling Process Overview

      1:24
    • 29. S05 2 Excel Basics of Financial Modelling

      6:01
    • 30. S05 3 Detailed Walkthrough of Completed Financial Model

      17:22
    • 31. S06 1 Revenue and Sales Forecast - Basic Structure

      5:47
    • 32. S06 - 2 Revenue/Sales Forecast - Growth Rate and Valiation tab

      10:07
    • 33. S06 3 Revenue/Sales Forecast - Growth Type Selection with Form Controls

      7:24
    • 34. S06 4 Revenue/Sales Forecasting Finalisation

      6:45
    • 35. S06 5 Model Cost of Goods Sold - Opening Stock

      3:49
    • 36. S06 6 Model Cost of goods sold - Growth Rates modeling

      8:28
    • 37. S06 7 Model Cost of Goods Sold - Setting up formulas for Gross Profit

      6:41
    • 38. S06 8 Cost of Goods Sold Modelling Finalisation

      11:07
    • 39. S06 9 Why to setup Cost of Goods Sold Gross Profit Change (Logic behind it)

      3:15
    • 40. S06 10 Modelling Direct cost and Gross Profit

      5:05
    • 41. S06 11 S06 - 11. Modelling Indirect Opearting Overheads - Dynamic Property Rent Costs

      10:27
    • 42. S06 12 Modelling Indirect Opearting Overheads - Other Overheads

      5:49
    • 43. S06 13 Model Indirect Operating Overheads - Using IFS Function

      6:07
    • 44. S06 14 Model Fixed Assets and Depreciation Schedule

      5:28
    • 45. S06 15 Fixed Assets Schedule - Setting Gross Cost and Depreciation

      6:59
    • 46. S06 16 Fixed Assets Schedule - Finalising and Linking Depreciation to PL

      6:43
    • 47. S06 17 Fixed Assets Schedule - Sales and Purchase of Assets

      2:53