Financial Modelling for entrepreneurs

Name: Financial Modelling for entrepreneurs
Rating: 3.6 (16 reviews)

Develop your financial model in a simple and effective way

Created byTimmermans Laurent

Last updated 10/2014

English

What you'll learn

Create a financial model for your project

Course content

3 sections • 17 lectures • 57m total length

Introduction0:43
The purpose of this lesson is to introduce the content of the course
Definition2:01
The purpose of this lesson is to define the concept of financial modeling and give our own definition. The one we will use throughout the course.

Cost-Revenues Introduction0:50
The purpose of this lesson is to introduce the first part of the course and the concepts of costs and revenues.
Fixed Costs1:22
The purpose of this lecture is to introduce the concept of fixed costs. How to identify them and what to do with them.
Variable Costs1:07
The purpose of this lecture is to introduce the concept of variable costs. How to identify them and what to do with them.
Investments3:10
The purpose of this lecture is to introduce the concept of Investments. How to identify them and what to do with them.
Revenues1:16
The purpose of this lecture is to introduce the concept of revenues. How to identify them and what to do with them.
Break-even2:00
The purpose of this lecture is to introduce the concept of break-even and how to calculate it (to take together with lecture 9 and 10).
Example 1: Cost and Revenues3:03
The purpose of this lesson is to give a simple example in which we estimate costs, revenues...
Example 2: Margin and Breakeven1:53
In the second part of the example we will learn how to calculate the margin and break-even.
Result1:25
The purpose of this lecture is to introduce the concepts of results, profit and loss. As well as how to calculate them.
Scenarios - "What if?"10:17
The purpose of this lecture is to simulate different situation (scenarios) and see how it affects our results.

Check in the course material to download the excel file.
Cash2:42
The purpose of this course is to understand the concept of cash and the importance to estimate our cash requirement.
ROI - Return On Investment0:51
The purpose of this lecture is to understand what is ROI and how to calculate it.

Example 1: Year 111:25
The purpose of this session is to show how to create your planning in a table through an example. In year one we will plan with the parameter we had from previous exercise.

Don't forget to download the excel file to be able to get access to all the formulas I used.
Example 2: Year 27:50
The purpose of this session is to show how to create your planning in a table through an example. In year two we will forecast growth and will introduce some fixed costs.
Example 3: Year 3 + Conclusion5:30
The purpose of this session is to show how to create your planning in a table through an example. In year three we will forecast growth and include investment.

This session will also conclude this course.

Requirements

basic knowledges of excel (cell, basic functions like "+-x/")

Description

You have a new brilliant idea and you want to see if the numbers make sense?

This course is for you!

No worries you don’t need business or accounting background. This course is more based on common sense than accounting rules.

We will learn:

How to differentiate and identify you cost (Investment, Fixed Cost, Variable Cost)?
How to estimate your revenues?
How to calculate your margin?
How to calculate your break-even?
How to calculate your profit/loss?
How to estimate cash requirement?
How to calculate your ROI?
How to create a simple 3 year financial plan?
How to play around the model using scenarios (in excel)?

This course is short! Because i want my courses to be short. It’s difficult to keep attention and motivation with e-learning. Therefore, I spend a lot of time preparing my courses to convey my message in the most concise (yet precise) way as possible. The whole course is scripted and recorded using green screen and encrusting keynotes with animation to support.

This means that in just a little bit more than one hour, your are good to go.

This course is really practical and I advise you to work on your own case as you through the lectures (the excel file for the examples are provided).

Who this course is for:

Entrepreneurs
Wantrepreneurs
Managers
Business Students

Financial Modelling for entrepreneurs

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

Part 1: Cost, Revenues, Breakeven, cash, Result12 lectures • 30min

Part 2: Planning3 lectures • 25min

Requirements

Description

Who this course is for: