watching now
3 Students
42 Lessons
Beginner

#### What Will You Learn?

• You'll build a financial model from scratch
• You'll learn to frame assumptions properly
• You'll practice structuring a financial model in a correct order
• You'll create realistic financial projections

#### Curriculum

5h 21m
07:18
16:02
##### Section 3: Assumptions
57:51
Assumptions Introduction
02:36
Assumptions - Revenue 1
07:43
Assumptions - Revenue 2
06:15
Assumptions - COGS
04:49
Assumptions - Salaries
14:19
Assumptions - General and Admin
05:54
Assumptions - Sales and Marketing
06:49
Assumptions - Balance Sheet
09:26
##### Section 4: Profit and Loss Statement
40:12
Profit and Loss Introduction
01:29
Profit and Loss - Setup and Format
11:48
Profit and Loss - Totals Formulas
06:39
Profit and Loss - Revenue
10:05
Profit and Loss - Cogs and Op Ex
10:11
##### Section 5: Balance Sheet
50:04
Balance Sheet Introduction
00:49
Balance Sheet - Setup and Format
11:03
Balance Sheet - Formulas Part 1
13:48
Balance Sheet - Formulas Part 2
21:32
Balance Sheet - Inventory
02:52
##### Section 6: Statement of Cash Flow
40:52
Statement of Cash Flow Introduction
00:46
Cash Flow - Setup and Format
09:10
Cash Flow - Totals Formulas
07:12
Cash Flow - Formulas 1
07:13
Cash Flow - Formulas 2
12:52
Cash Flow - Formulas 3
03:39
##### Section 7: Inventory
34:28
Inventory Introduction
01:08
Inventory - Setup and Format
15:31
Inventory - Formulas 1
09:41
Inventory - Formulas 2
08:08
##### Section 8: Financial Tie Out
28:16
Financial Tie Out Introduction
01:34
Financial Tie Out - Error Checking
11:21
Financial Tie Out - Model Review
15:21
##### Section 9: Variance Analysis
21:46
Variance Analysis Introduction
01:03
Variance Analysis - Setup and Format
10:31
Variance Analysis - Formulas
10:12
##### Section 10: Financial Summary
20:04
Financial Summary Introduction
01:04
Financial Summary - Setup and Format
05:22
Financial Summary - Formulas
13:38
04:31
Course Summary
04:31

#### Requirements

• Microsoft Excel, Google Sheets or another spreadsheet installed on your computer
• Understanding of basic Excel formulas
• Basic understanding of accounting principals and financial statements
• A determination to learn about financial modeling for your business success

#### Chris Benjamin MBA & CFO

Reviews 2
Students 213
Courses 25

Chris Benjamin is a passionate instructor and management consultant. As a consulting Chief Financial Officer, he helps growth-stage companies to work with investors, do financial modeling, reporting, and analysis and put all the best accounts payable practices. Throughout his over 10 years of experience, Chris has already helped more than 100 startups to succeed.

Chris Benjamin has a passion for sharing his experience with students and teaching online. His focus is on teaching business-related topics like finance, accounting, Excel, and entrepreneurship. Chris is a creator of more than 85 courses and has over 30k students who enrolled in his courses.

Chris holds a Bachelor’s degree in accounting from the University College of the Fraser Valley and an MBA in business from the University of Washington.

On BitDegree, you can find some of the best Chris Benjamin’s courses and expand your knowledge. You can learn such things as economics, finance, public speaking, business management, and others. Choose the best course for yourself and take your skills to the next level in no time!

#### BitDegree platform reviews

Our students say Excellent
4.5 out of 5