Overview
Close
Build a realistic financial forecast
1h 28min
Course nuggets
About this nugget ...
  • Add to favorites
  • Add to playlist
  • Share

Financial Forecasting Template (v4.43)

A simple-to-use spreadsheet that takes you through the process of building your sales, costs and investment forecasts.
45min

The Tool

To help you with your financial forecast we have constructed a simple-to-use template that is suitable for a startup business.
All you need to do is provide the three key sets of underlying data for the forecasting period (e.g 3-5 years) related to:

  1. What is owned and borrowed;
  2. Costs; and,
  3. Sales.

With this information, the spreadsheet will construct the three financial statements (the Profit and Loss Statement, the Cash Flow Statement and the Balance Sheet) and a dashboard of key performance metrics for you.

 

Startup-Accelerator Finance Template

 

Explainer Film

For a quick introduction to the spreadsheet, you can watch the film below:

 

 

Some Example Cases

Here are some example cases for you to follow, with full descriptions and video explanations:

  1. Example engineering case;
  2. Example ICT case; and,
  3. Example e-commerce case.

 

Attachments

Startup-Accelerator Finance Template v4.43

Download

You might also be interested in:

15min
15min
Financial Forecasting - Lifescience Example
An example financial forecast for a Lifescience startup case that uses our simple-to-use financial forecasting tool.
15min
15min
Financial Forecasting - ICT Example
An example financial forecast for an ICT startup case that uses our simple-to-use financial forecasting tool.
15min
15min
Financial Forecasting - Engineering Example
An example financial forecast for an engineering startup case that uses our simple-to-use financial forecasting tool.
15min
15min
Financial Forecasting - E-Commerce Example
An example financial forecast for an e-commerce startup case that uses our simple-to-use financial forecasting tool.