🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
4 Students

Description

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

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
  • NFT Certificate
  • 42 Lessons
  • Beginner
  • English
  • 4.5 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 5h 21min of content, in total.

Section 2: Terminology and Excel Functions
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
Section 11: Course Summary
04:31
Course Summary
04:31

About the Instructor

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!

See All Instructor Courses

BitDegree platform reviews