Financial Modelling From Scratch Using Microsoft Excel

Intro: Creating input assumptions for your first financial model Preview 00:50

The video provides an introduction to building model inputs

Input assumptions of a financial model- Part 1 - Ground Rules Preview 06:34

In this lecture, we define some ground rules of modelling including

1. Identifying inputs and coloring them with a color scheme

2. Coloring derived output cells with a different color scheme

Input assumptions of a financial model- Part 2 - Revenue Assumptions Preview 03:50

In this lecture, we build the revenue assumptions of the Company including the following:

1. Defining the products/ services of the Company

2. Projecting the units to be manufactured over the next 3-5 years using monthly growth rates

3. Projecting the price of the product over the next 3-5 years using monthly growth rates

Input assumptions of a financial model- Part 3 - Direct Cost Assumptions Preview 14:35

In this lecture, we build the cost assumptions of various variables that are used directly to manufacture our product. We use different methods of projecting the Direct Costs including the following:

1. Based on no. of units of product manufactured

2. As a % of revenue

Input assumptions of a financial model- Part 4- Indirect Cost Introduction Preview 01:03

In this lecture, we introduce the concept of indirect costs and discuss their significance.

Input assumptions of a financial model- Part 5- Indirect Cost Assumptions Preview 11:08

In this lecture, we create assumptions for each of the indirect costs including the following using different modelling techniques:

1. Rental

2. Manpower Costs

3. Travel Costs

4. Miscellaneous Costs

Intro: Creating the first Profit and Loss Statement (P&L) Preview 00:43

This video provides an introduction to creating your first Profit and Loss Statement

Explained: How to create your first Profit and Loss Statement? Preview 17:15

In this lecture, we build a Profit and Loss Statement from scratch. We also discuss the following concepts:

1. Gross Profit

2. Gross Margin

3. Earnings Before Interest, Taxes, Depreciation and Amortization (EBITDA)

4. Earnings Before Interest and Taxes

5. Net Income or Profit After Tax or Net Comprehensive Income

Intro: Creating the inputs for your first Balance Sheet Preview 00:43

This video provides an introduction to creating the inputs for your first Balance Sheet.

Explained: How to create inputs for your first Balance Sheet? Preview 11:43

In this lecture, we explain some of the Balance Sheet Terms like

1. Accounts Receivables (Number of Days)

2. Accounts Payable (Number of Days)

3. Inventory/Stock (Number of Days)

4. Fixed Assets / PP&E

5. Capital Sources - Debt and Equity

We also discuss how we can make assumptions for these factors which will help us build the Balance Sheet in the next video.

Intro: Building your first Balance Sheet Preview 00:40

This video provides an introduction to creating your first Balance Sheet!

Explained: How to build your first Balance Sheet? Preview 22:26

In this lecture, we built Balance Sheet from the scratch by creating separate schedules for:

1. Debt Repayment

2. Depreciation

We then build the overall Balance Sheet using the Balance Sheet Assumptions from the previous lecture.

Intro: Creating your first cash flow statement Preview 01:07

Explained: How to create your first cash flow statement? Preview 19:25

In this lecture, we get down to building our first cash flow statement. The instructor highlights the important difference between the three financial statements and builds the Cash Flow Statement step by step. You can expect to learn to create the following by the end of the lecture

1. Cash Flow from Operating Activities

2. Cash Flow from Investing Activities

3. Cash Flow from Financing Activities

4. Cash Balances at the end and beginning of each period

5. Balancing the Balance Sheet using the outputs of Cash Flow Statement

This lecture will also help the student reach the goal of creating all the three financial statements of the Company

Yaay! You are a financial modeler now! Closing comments Preview 01:09

Congratulations on completing the course and becoming a highly skilled financial modeler. Stay connected for many new courses. Till then, signing off!