How to Create A Financial Model

Description

Timestamps

[00:00] – Introduction to Financial Model
[01:50] – Free resources
[04:30] – Three Uniques about your company
[05:46] – Basic Elements to a business plan
[06:59] – Steps To Create A Financial Model
[08:35] – Select the products to produce
[09:42] – Create Unit Demand For each of those products
[11:40] – Set Price for each unit
[14:24] – Estimate Cost of Goods
[14:50] – Estimate Headcount
[15:26] – Estimate Sales & General Administration expenses (SGA)
[16:04] – Example of Financial Model
[22:00] – Headcount Plan
[23:20] – SGA Expenses
[25:30] – EBITDA
[29:06] – Capital Equipment Plan
[30:32] – Balance Sheet
[32:50] – How long to receive payment
[35:23] – Cash Flow Statement
[38:07] – Charts to show investors
[40:20] – Dr. Jon’s Writing Formula
[43:55] – Use a proven outline
[45:52] – Online vs Retail Channel
[48:00] – The true benefit of the business plan

LISTEN to this episode: