watching now
2 Students
42 Lessons
Beginner

What You Will 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
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

Description

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

About the Instructor

Reviews 1
Students 13
Courses 23

Welcome Students!

I have created over 85 courses with 100,000+ students!  I love teaching on online, and empowering students with knowledge in accounting, finance, entrepreneurship, Excel and other business topics. 

In my day to day life, I work as a consulting CFO, Chief Financial Officer.  Mainly I work with growth stage companies, helping them put in place all the best accounting practices, financial modeling, working with investors, and financial reporting and analysis.   

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo