
In this section, we will go through setting up your financial model and building out a forecast for acquiring customers. This will include formatting the model and setting a structure for building out the rest of your forecast.
Now that we have the outline of the model complete and we know how we are getting our customers, we will work on translating these customers into revenue by building out our revenue formula.
Understanding your expenses is crucial for the cashflow of your company. In this section, we create a full budget including forecasting key hires and creating expense forecasts for a variety of operational items.
Revenue does not equal cash collected, and there are plenty of transactions that happen outside of the income statement that can have a large impact on cash. Account for this in this video where we dive into the drivers of the balance sheet.
Important Note: An error was found in this video. When adding expenses to the income Statement, be sure to include a line for paid ads from your growth section... this is a marketing expense. Please contact the instructor if you need help with this!
----
Learn how to forecast EBITDA, EBT, Net income, your margins, and more. In this section, we but together a Profit & Loss report (Income Statement) using the assumptions we created in section 1.
Here we forecast all aspects of the balance sheet, in preparation fore forecasting cash and understanding when our company will run out of funds.
In this final lecture, we bring everything together by creating the Statement of Cash Flows, and giving ourselves a 5 year cash forecast for our company.
Co-Founder and COO of Forecastr (Techstars 2020) breaks down how to build a financial model from scratch in this 7 part lecture.
In this course, we start with a totally blank excel sheet. This is unlike other financial modeling courses that start with a template - by starting from scratch, we guarantee that you will have a deeper level of understanding for how financial modeling works, and have more freedom to customize your projections for your own business.
At the end of this course, you will have a full 3 statement financial model (Income Statement, Balance Sheet, Statement of Cash Flows) forecasted monthly and formatted attractively. We focus heavily on showing you the calculation logic so that you will be able to tailor your model to your specific needs.
Why build a financial model?? Lots of reasons - but specifically a financial model will:
1.) Help you raise money for your business
Investors speak the language of finance - and a financial model is a great communication tool for investors. Presenting a model will inspire confidence that you'll be a good fiduciary of their investment, and that you are a competent operator that knows their metrics!
2.) Help you run your business better
A financial model is a mathematical simulation of your business. Once the simulation is build, there are endless questions that you can "ask it". What happens if you raise prices? Hire more people? Raise money? A good financial model is the closest thing a founder has to a "crystal ball"