Why take this course?

  • Excel Knowledge

    Microsoft Excel is an important skill to learn. It is widely used in the workplace because it increases productivity, improves analysis, and it strengthens your analytical skills. It also enhances your resume value.

  • Base Model

    The Three Statement Financial model is an important foundational model. It connects the three core financial statements in a fully integrated and dynamic model. Mastering this model is essential and serves as a strong foundation for more complex models.

  • Financial Modeling

    You will learn financial modeling best practices, including functions, formulas, and approaches that will make you more efficient. Financial modeling helps individuals and businesses make informed decisions.

What is included?

  • Videos

    This course incudes over 90 videos covering how to build a three statement Excel model. From the initial set up to building a dashboard. We will discuss best practices, appropriate functions, formulas, shortcuts and tips.

  • Downloads

    You will have access to all the files referenced throughout the course. You will be able to download the completed model, with all the respective functionality, at the end of the course.

Video

Course curriculum

  • 1

    Course Introduction

    • Introduction

    • Completed Model Preview

    • Course File Download

    • Course File Description
  • 2

    Income Statement - History

    • Income Statement Worksheet Setup

    • Headings

    • Years - Set Up

    • Years - Custom Format

    • Format & Formulas

    • Format & Constants

    • Section Quiz
  • 3

    Balance Sheet - History

    • Create Balance Sheet Worksheet

    • Headings & Years

    • Format

    • Formulas: Subtotals & Totals

    • Balance Sheet Check

    • Section Quiz
  • 4

    Cash Flow Statement - History

    • Worksheet Setup

    • Headings & Years

    • Format & Formulas - Part I

    • Format & Formulas - Part II

    • Section Quiz
  • 5

    Supporting Schedules

    • Worksheet Setup

    • Format

    • Formulas

    • Section Quiz
  • 6

    Debt Schedule

    • Format

    • Formulas

    • Error Handling

    • Section Quiz
  • 7

    Inputs Worksheet

    • Inputs & Drivers File

    • Description

    • Initial Setup

    • Format

    • Future Value

    • Percent Change

    • Formulas - Historical Years - Part I

    • Accounts Receivable Days

    • Inventory Days

    • Accounts Payable Days

    • Formulas - Historical Years - Part II

    • Forecast Years

    • Section Quiz
  • 8

    Income Statement Forecast

    • Gross Profit

    • Total Expenses

    • Net Income

    • Section Quiz
  • 9

    Balance Sheet Forecast

    • Accounts Receivable

    • Inventory

    • Accounts Payable

    • Short Term Debt

    • Long Term Debt

    • Equity

    • Section Quiz
  • 10

    Cash Flow Statement Forecast

    • Operating Cash Flows

    • Financing Cash Flows

    • Section Quiz
  • 11

    Supporting Schedules Forecast

    • Operating Accounts

    • Property, Plant & Equipment

    • Income Statement References

    • Balance Sheet References

    • Cash From Operations References

    • Investing Cash Flows References

    • Balance Sheet Cash

    • Section Quiz
  • 12

    Additional Automation

    • Inputs Worksheet - Years

    • Financial Statements Years

    • Debt

    • Model Units

    • Balance Sheet Check - Actual Years

    • Balance Sheet Check - Forecast Years

    • Balance Sheet Checks - Conditional Formatting

    • Automation - Actual Years

    • Footnotes - Part I

    • Footnotes - Part II

    • Footnotes - Final Comments

    • Section Quiz
  • 13

    Model Format and Structure

    • Gridlines

    • Freeze Panes

    • Worksheet Colors

    • Blue Bar Formula

    • Section Quiz
  • 14

    Dashboard

    • Introduction

    • Initial Setup

    • Income Statement Headings

    • Income Statement Years

    • Income Statement Years Orientation

    • Income Statement Data

    • Income Statement Graph Setup

    • Income Statement Graph Format

    • Cash Flow Statement Data

    • Cash Flow Statement Graph

    • Current Ratio

    • Liquidity Data

    • Liquidity Graph

    • Final Format Changes

    • Section Quiz
  • 15

    Cover Sheet

    • Introduction

    • Initial Setup

    • Dynamic Worksheet Name

    • MID Function

    • Remaining Worksheet Names

    • Hyperlinks

    • Print Ranges

    • Headers & Footers

    • Section Quiz
  • 16

    Course Wrap Up

    • Course Wrap Up

    • Congratulations!!!