Build A Financial Forecasting Model for your next Startup
Focused View
11:48:13
10 View
01 S01 0 Introduction to the Class (Build Unique Financial Model).mp4
06:56
02 S01 1 Financial Modelling Course Roadmap And Outline.mp4
02:34
03 S01 2 What Is Financial Modelling.mp4
02:07
04 S01 3 Financial Modelling What Are The Inputs And Outputs.mp4
00:51
05 S01 4 What Is Financial Modelling Used For.mp4
05:46
06 S01 5 What Are The Key Components Of Financial Modelling.mp4
03:16
07 S01 6 Short Overview Of The Completed Financial Model.mp4
06:25
08 S02 1 Accounting Basics And Equation For Financial Models.mp4
04:06
09 S02 2 Accounting Basics What are the Debits And Credits.mp4
07:41
10 S02 3 Accrual v Cash Accounting for Financial Modelling.mp4
06:05
11 S02 4 Prepaid Expense And Unearned Revenue With Accrual V Cash Accounting.mp4
04:16
12 S03 1 What is a Balance Sheet.mp4
06:10
13 S03 2 What Is Income Statement Or Profit Or Loss Statement.mp4
04:57
14 S03 3 What is a Cashflow Statement.mp4
04:13
15 S03 4 Two Methods of Cashflow Statements Explained.mp4
05:08
16 S03 5 Indirect Method of Cashflow Statement Explained.mp4
11:53
17 S04 1 Introduciton to Formulas and Function for Financial Modelling.mp4
03:39
18 S04 2 CHOOSE Function Explained.mp4
13:06
19 S04 3 MAX and mIN Function Explained.mp4
07:10
20 S04 4 IF Functions Basics Explained.mp4
07:03
21 S04 5 IF Function with Nested IF Statements.mp4
06:11
22 S04 6 IFS Function Explained.mp4
07:29
23 S04 7 VLOOKUP Function Explained.mp4
06:07
24 S04 8 MATCH Function Explained.mp4
10:54
25 S04 9 VLOOKUP Function with MATCH Function (Advanced Version).mp4
06:24
26 S04 10 SUMIF Function Explained.mp4
05:06
27 S04 11 OFFSET Function Explained.mp4
14:21
28 S05 1 Financial Modelling Process Overview.mp4
01:24
29 S05 2 Excel Basics of Financial Modelling.mp4
06:01
30 S05 3 Detailed Walkthrough of Completed Financial Model.mp4
17:22
31 S06 1 Revenue and Sales Forecast - Basic Structure.mp4
05:47
32 S06 - 2 Revenue Sales Forecast - Growth Rate and Valiation tab.mp4
10:07
33 S06 3 Revenue Sales Forecast - Growth Type Selection with Form Controls.mp4
07:24
34 S06 4 Revenue Sales Forecasting Finalisation.mp4
06:45
35 S06 5 Model Cost of Goods Sold - Opening Stock.mp4
03:49
36 S06 6 Model Cost of goods sold - Growth Rates modeling.mp4
08:28
37 S06 7 Model Cost of Goods Sold - Setting up formulas for Gross Profit.mp4
06:41
38 S06 8 Cost of Goods Sold Modelling Finalisation.mp4
11:07
39 S06 9 Why to setup Cost of Goods Sold Gross Profit Change (Logic behind it).mp4
03:15
40 S06 10 Modelling Direct cost and Gross Profit.mp4
05:05
41 S06 11 S06 - 11. Modelling Indirect Opearting Overheads - Dynamic Property Rent Costs.mp4
10:27
42 S06 12 Modelling Indirect Opearting Overheads - Other Overheads.mp4
05:50
43 S06 13 Model Indirect Operating Overheads - Using IFS Function.mp4
06:07
44 S06 14 Model Fixed Assets and Depreciation Schedule.mp4
05:28
45 S06 15 Fixed Assets Schedule - Setting Gross Cost and Depreciation.mp4
06:59
46 S06 16 Fixed Assets Schedule - Finalising and Linking Depreciation to PL.mp4
06:43
47 S06 17 Fixed Assets Schedule - Sales and Purchase of Assets.mp4
02:53
48 S06 18 Model Equity and Loan Schedule - Preparation and Linking to PL.mp4
08:50
49 S06 19 Finishing up Income Statement Modelling.mp4
02:33
50 S07 1 Cash Inflow - Cash Sales And Collection From Credit Sales.mp4
14:28
51 S07 2 Cash Inflow - Dynamic Growth Rate Setup With Form Controls.mp4
04:28
52 S07 3 Cash Inflow - Credit Days Selection Drop Down With Form Controls.mp4
03:37
53 S07 4 Cash Inflow - Dynamic Collection Days With Offset Function.mp4
08:39
54 S07 5 Cash Outflow - Model Cash Purchases And Payments To Suppliers.mp4
11:51
55 S07 6 Cash Outflow - Direct Overheads And Indirect Overheads.mp4
12:16
56 S07 6 Cash Outflow - Direct Overheads And Indirect Overheads (Revised).mp4
12:21
57 S07 7 Cash Conversion Ratio - Measure Net Profit To Cashflow For Business.mp4
04:11
58 S07 8 Cash Outflow - Capex Payment, Line Of Credit And Funding Movment.mp4
07:27
59 S08 1 Line Of Credit Schedule Build Up.mp4
06:57
60 S08 2 Line Of Credit - Interest Modelling.mp4
02:19
61 S08 3 Line Of Credit - Linking LOC Funding To Cashflow Statement.mp4
11:21
62 S09 1 How To Setup Validation And Error Check For The Entire Model.mp4
08:15
63 S09 2 How To Setup Validation And Error Check For The Entire Model.mp4
05:56
64 S09 3 How To Setup Validation And Error Check - Conclusion.mp4
03:10
65 S10 1 Fixed Assets Schedule Expansion And Why We Need It.mp4
03:26
66 S10 2 Fixed Assets Scheduel Expansion - Building It Step By Step.mp4
15:17
67 S10 2 Fixed Assets Scheduel Expansion - Building It Step By Step (Revised).mp4
15:29
68 S11 1 Indirect Method Of Cf Statement - Building Balance Sheet Assets Side.mp4
10:15
69 S11 2 Indirect Method Of Cf Statement - Building Balance Sheet Liab Side.mp4
07:54
70 S11 3 Indirect Method Of Cf Statment - Cashflow Building.mp4
07:56
71 S11 4 Indirect Method Of Cf Statment - Cashflow Building.mp4
05:56
72 S11 5 Indirect Method Of Cf Statment Updating Error Checks And 11.mp4
07:04
73 S11 6 Creating Kpi Cards For New Business Financial Model.mp4
08:22
74 S12 1 Building Existing Business Financial Model- Updating Ranges Tab.mp4
06:28
75 S12 2 Building Existing Business Financial Model - Creating Periods.mp4
06:20
76 S12 3 Building Existing Business Financial Model - Updating Validaitons And Error Checks.mp4
11:22
77 S12 4 Building Existing Business Financial Model - Finalisation And Kpi Cards.mp4
11:11
78 S13 1 Overview Of The New Business Dashboard.mp4
08:41
79 S13 2 Data Table Preparation For The Charts 1.mp4
09:13
80 S13 3 Data Table Preparation For The Charts 2.mp4
04:28
81 S13 4 Data Table Preparation For The Charts 3.mp4
03:19
82 S13 - 5. Building First Column Chart - Sales And Gross Profit.mp4
04:11
83 S13 6 Building Column Chart - With Max And Min GP %.mp4
05:45
84 S13 7 Building Column Chart - With Max And Min NP %.mp4
04:07
85 S13 8 Building Column Chart For 12 Months Sales And Gross Profit.mp4
03:18
86 S13 9 Building Column Chart For 12 Months GP % and NP %.mp4
09:07
87 S13 10 Building Column Chart For Cashflow, Collection And Payments For 12 Months.mp4
08:02
88 S13 11 Building Column Chart For Trend Of Ocf For 12 Months.mp4
08:26
89 S13 12 Building Donut Chart - Sales Products Distribution.mp4
06:49
90 S13 13 Download Free Stock Images For Dashboard Background.mp4
05:24
91 S13 14 Importing Background Image And Setting Up Dashboard.mp4
05:19
92 S13 15 Creating Chart Backgrounds For Amazing Visual Effect.mp4
05:46
93 S13 16 Finalising New Business Dashboard With Kpi Cards.mp4
09:22
94 S13 17 Existing Business Dashboard Creation - Reusing Nb Dashboard.mp4
11:54
95 S13 18 Waterfall Chart for Net Cashflow Performance.mp4
14:41
96 S14 - 1 Overview of the Financial Model in Google Sheet.mp4
19:05
97 S14 - 2 Creating Waterfall Chart for Net Cashflow in Google Sheet.mp4
07:05
98 Class Wrap up and Thank you.mp4
00:56
More details
User Reviews
Rating
average 0
Focused display
Category
SkillShare
View courses SkillShareSkillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
- language english
- Training sessions 98
- duration 11:48:13
- English subtitles has
- Release Date 2024/01/28
