Start-up financial modeling for non-finance professionals
3.5 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
785 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Start-up financial modeling for non-finance professionals to your Wishlist.

Add to Wishlist

Start-up financial modeling for non-finance professionals

A guide for non-finance start-up entrepreneurs to prepare their financial projections hassle-free.
3.5 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
785 students enrolled
Created by Feanut Model
Last updated 6/2016
English
Price: Free
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand financial modeling for start-up business
  • Use provided end-to-end financial model to prepare start-up financial projections
  • Create their own start-up financial plan using the provided financial model
  • Understand key data inputs in the start-up financial model
  • Perform quick scenario modeling in the provided financial model
View Curriculum
Requirements
  • You should have a spreadsheet software - a copy of the financial model will be provided as part of the course.
  • Basic knowledge of MS Excel is required
  • No particular finance and accounting background is required - however, have a basic understanding of a business plan items - Sales, Cost of sales, Operational Expenses, Personnel, Capital Expenditures, Sources of financing
Description

This course is primarily aimed at start-up entrepreneurs with limited background in finance and accounting. As part of the course you will receive your copy of Feanut Financial Model - a tool that we developed to make it easy to prepare complex financial projections. Over this course you will learn how to use this model to prepare a professional financial plan, including the financial statements, financial ratio analysis, simplified business valuation and scenario analysis with the use of just a couple of input data that even a regular non-finance guy can understand so at the end of the course you will be able to prepare the finacial plan of your start-up business using our Feanut Financial Model.

No specific finance or accounting background is required, and the course is not aimed at teaching you the details of accounting mechanics nor complexities of financial modeling in Excel. The course contains of almost 4 hours of video lectures and as part of the course you will also receive a 90-page model giude.

Who is the target audience?
  • This course is best for start-up entrepreneurs with limted financial and accounting background who would like to prepare a financial plan for their business and would like to learn something about the financial modeling for start-ups.
  • This course is not intended to teach details of advanced Excel functions, nor it is an accounting course. It is aimed at those who need to put together financial projections without going deep into the details of financial statements, accounting rules or complex calculations in Excel.
Compare to Other Financial Modeling Courses
Curriculum For This Course
19 Lectures
03:55:12
+
Introduction
2 Lectures 18:01

Let us introduce ourselves and this course. We are a couple of finance and consulting professionals who decided to make life easier for start-up entrepreneurs by developing a financial model that even a non-finance guy will find easy to use to prepare the financial projections.

In this video you will learn:

  • Who we are
  • What is Feanut Financial Model
  • Why we did it
  • How it will help you
Introduction
02:56

In this video you will learn about the main sections of the models and about features that will help you to navigate through the spreadsheet.


Key topics:

  • Model structure
  • Numbering and color-coding
  • Links between worksheets
  • Navigation in the model
Model Structure and Navigation
15:05
+
Data inputs for financial modeling
10 Lectures 02:03:35

In this lesson we will explain the Main inputs worksheet, what inputs are provided here and how are they used.

Key topics:

  • Company information
  • Model dates
  • Tax inputs
  • Cash inputs
  • Valuation inputs


Backing track in the video from:
http://www.melodyloops.com

Main Inputs Worksheet - Part 1
11:14

In this lesson we will explain the Main inputs worksheet, what inputs are provided here and how are they used.

Key topics:

  • Company information
  • Model dates
  • Tax inputs
  • Cash inputs
  • Valuation inputs


Backing track in the video from:
http://www.melodyloops.com

Main Inputs Worksheet - Part 2
12:58

In this lesson you will learn how to use the Sales worksheet and what data inputs are required to model your sales projections.

Key topics:

  • Product sortiment
  • Unit prices
  • Launch dates
  • Volumes
  • Growth rates


Backing track in the video from:
http://www.melodyloops.com

Modeling Sales Projections
14:55

In this lesson we will have a look at the data inputs for the direct costs of your production - material and services costs.

Key topics:

  • Material costs
  • Services costs
  • Total unit costs of sales
  • Cost of sales inflation


Backing track in the video from:
http://www.melodyloops.com

Cost of Sales
07:48

In this worksheet we will explain different data inputs required to model your headcount plan and personnel expenses for different types of jobs.

Key topics:

  • Job roles
  • Salary and Other Compensation
  • Headcount
  • Driver dependency


Backing track in the video from:
http://www.melodyloops.com

Modeling Headcount (Personnel Worksheet)
15:01

This lesson will walk you through the capital expenditure data inputs - investments into assets of your company - and useful functionalities that the model offers for CAPEX modeling.

Key topics:

  • CAPEX items
  • Useful life
  • Driver dependency
  • CAPEX categorization


Backing track in the video from:
http://www.melodyloops.com

Modeling Capital Expenditures (CAPEX)
15:27

In this video we will explain what data inputs are needed to model other operational expenses, such as distribution costs, energy and utilities, IT, rents or travel expenses.

Key topics:

  • Other OPEX categories
  • Start and End date
  • Driver dependency


Backing track in the video from:
http://www.melodyloops.com

Other Operational Expenses (OPEX)
09:58

In this video we will talk about input data for equity finance - common and preferred shares, dividends and share re-purchases.

Key topics:

  • Types of equity
  • Issue date
  • Dividends
  • Share re-purchase


Backing track in the video from:
http://www.melodyloops.com

Equity Financing
09:35

In this video we will continue with debt financing of your business - loans, bonds, installments, re-payment and interest rates.

Key topics:

  • Types of debt
  • Short term vs. Long term
  • Re-payment schedules
  • Interest rates


Backing track in the video from:
http://www.melodyloops.com

Debt Financing
12:33

In this lesson you will learn about data inputs for modeling of working capital - cash collection cycle, inventory cycle and payables cycle.

Key topics:

  • Payment terms for Receivables and Payables
  • Bad debt
  • Inventory cycle
  • Scrap material


Backing track in the video from:
http://www.melodyloops.com

Working Capital
14:06
+
Outputs of the financial model - Financial statements and ratios
3 Lectures 40:00

This lesson will focus on 3 worksheet - Inputs Summary, List of Tables and Control Sheet that contains several sense checks embedded into the model.

Key topics:

  • Inputs Sumary
  • List of Tables
  • Technical and Soft Controls


Backing track in the video from:
http://www.melodyloops.com

Inputs Summary and Controls Sheet
19:24

In this video we will have a closer look at the results of the modeling - in particular at the modeled financial statements.

Key topics:

  • Income statement
  • Balance sheet
  • Cash flow statement
  • Statement of changes in equity


Backing track in the video from:
http://www.melodyloops.com

Financial Statements
14:17

In this this lesson we will introduce the financial ratios worksheet with the calculation of the most common financial ratios calculated in financial models.

Key topics:

  • Financial ratios
  • Calculation formulae
  • Annual vs. monthly ratios


Backing track in the video from:
http://www.melodyloops.com

Financial Ratios
06:19
+
Valuation and Scenario Analysis
2 Lectures 32:00

In this video you will learn abouts simplified calculation of the value of your company using the discounted cash flow valuation method.

Key topics:

  • DCF valuation method
  • Stage I vs Stage II cash flows
  • Valuation calculation steps


Backing track in the video from:
http://www.melodyloops.com

Business Valuation
17:01

Today you will learn how to quickly set up alternative scenarios to calculate the impact on the results by changing selected key input variables of the model.

Key topics:

  • Base case
  • Setuping scenarios
  • Switching between scenarios


Backing track in the video from:
http://www.melodyloops.com

Scenario Analysis
14:59
+
Executive Summary
2 Lectures 21:36

In this video we will introduce the chart worksheet with 22 pre-designed charts presenting the most important results from the financial model.

Key topics:

  • Pre-designed charts
  • Break-even point chart


Backing track in the video from:
http://www.melodyloops.com

Charts
09:04

This is the last video of our online course. We will show you the final executive summary worksheets where you can provide the comments on your business plan alongside with the selected results from the model.

Key topics:

  • Business plan comments
  • Key financials
  • Saving as PDF


Backing track in the video from:
http://www.melodyloops.com

Executive Summary
12:32
+
Final quiz
0 Lectures 00:00

This quiz is a final test of your knowledge gained throughout our online course. It foucses on the specifics of the Feanut Financial Model and of the financial modeling for start-up businesses.

Start-up financial modeling for non-finance professionals
20 questions
About the Instructor
Feanut Model
3.5 Average rating
3 Reviews
785 Students
1 Course
Financial modeling for a peanut

I am a professional with 8 years of experience in finance, strategy, management consulting, controlling, financial planning and analysis. I have developed Feanut Financial Model to help start-up entrepreneurs with limited financial bakcground to develop their financial projections easier. Over my career I met great people trying to start their own businesses, pursuing innovative ideas and beign experts in their respective fields. However, they often lack the financial acumen and struggle to put together the financial plan - the blueprint of their business. That's why I decided to help them at least with that part of their business venture - and this course and the model is the result of that effort.