Sheet 1: Disclaimer

	
	

		
Disclaimer
	
	

		


	
	

		
This document is provided as a reference and template, and the financial information included should not be considered as certified business valuation, or projection. The information and calculations provided in this document (the “Template”) is for general informational purposes only. All information and calculations in this Template are provided in good faith, however BaseTemplates Droste, Fleitmann GbR and the Author (“we”, “us”, or “our”) make no representation or warranty of any kind, express or implied, regarding the accuracy, adequacy, validity, reliability, availability or completeness of any information and calculations in this Template. UNDER NO CIRCUMSTANCE SHALL WE HAVE ANY LIABILITY TO YOU FOR ANY LOSS OR DAMAGE OF ANY KIND INCURRED AS A RESULT OF THE USE OF THE TEMPLATE OR RELIANCE ON ANY INFORMATION AND CALCULATIONS PROVIDED IN THIS TEMPLATE. YOUR USE OF THE TEMPLATE AND YOUR RELIANCE ON ANY INFORMATION AND CALCULATIONS IN THIS TEMPLATE IS SOLELY AT YOUR OWN RISK.

The Template cannot and does not contain financial advice. The financial information is provided for general informational and educational purposes only and is not a substitute for professional advice. Accordingly, before taking any actions based upon such information, we encourage you to consult with the appropriate professionals. We do not provide any kind of financial advice. THE USE OR RELIANCE OF ANY INFORMATION CONTAINED IN THIS TEMPLATE IS SOLELY AT YOUR OWN RISK.
	



Sheet 2: Manual & About >>>

	
	
	
	
	

		


		

 
		
		
	

		


		
	

		


		
	

		


		
	

		


		
	

		


		
	

		


		
	

		


		
	

		


		


		


		


	
	

		


		


		

 
		
		
	

		


		
Author: Christopher Mohrmann (hi@chrismo.vc)
		
	

		


		
Version: Free Example (Dummy Version)
		
	

		


		
Release Date: 14 may 2021
		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		
How to use this model
		


		


	
	

		


		
We recommend to walk through the business plan tab by tab (1. Cockpit, 2. Revenues, 3. Staff, 4. Costs, 5. Funding) and section by section (A, B, C) as described below: 
		


		


	
	

		


		


		


		


	
	

		


		
Tab
		
Section
		
Comments
	
	

		


		


		


		


	
	

		


		
1. Cockpit
		
general
		
Use this tab to enter general inputs for your business plan, e.g. name of your company, business plan version, starting point, currency and name for your SaaS plans

	
	

		


		
2. Revenues
		
general
		
Use this tab to enter your assumptions for revenue generations. In Section "A. Customer acquisition - Sales leads", you could define how you acquire your sales leads. Section "B. Customer base & product set up" is used to set the conversion rate and development of your subscriber base

	
	

		


		


		
A. Customer acquisition - Sales leads
		
Use this section to enter your assumptions for sales lead generation. You could enter different assumptions for organic lead acquisition (e.g. via your website, blog etc) and for up to three paid marketing channels (e.g. Google ads, Facebook ads, etc.).
The monthly marketing budget in combination with your assumptions for cost per lead defines the numbers of monthly leads per paid marketing channel
In addition, you could define how long an acquired sales lead remains relevant for conversion and how long it takes to translate converted leads into revenue
	
	

		


		


		
B. Customer base & product set up
		
Use this tab to define the assumptions for your service plans (e.g. "Basic", "Standard", "Premium"). Please enter the conversion rate per service plan for the different lead acquisition channels and your assumptions regarding churn, upgrades, downgrades and pricing. In general, this section defines your monthly user base and it's split between your service plans
	
	

		


		
3. Staff
		
general
		
Use this tab to enter your assumptions for your staff (number of employees, salaries etc.)

	
	

		


		


		
A. HR Forecast - Sales & Founder
		
In this section, you could enter the assumptions for your sales force and for the founders team.  In case your business model does not requires a dedicated salesforce, please  turn the sales team switch "off". 

Saels team: This model calculates the required sales headcount based on the newly acquired monthly revenue and the capacity per sales headcount ("New ARR per sales headcount"). Please enter your assumption for salary, non-wage labour costs, capacity and team structur in this section

Founder team: You could enter your assumptions for up to four founders in this section

	
	

		


		


		
B. HR Forecast - Other staff
		
Use this section to enter your assumption for other employees (e.g. developer, marketing etc). You could set the position (or employee) name, starting date and salary for every staff member individually

	
	

		


		
4. Costs
		
general
		
This tab is used to enter your assumption for the cost structure (except for salaries and labor costs which are considered in the "3. Staff" tab

	
	

		


		


		
A. Product related
		
Please enter your assumptions for all costs directly linked to your product 

	
	

		


		


		
B. Staff related
		
In this section, you could enter your assumption for costs linked to specific positions (e.g. Travel costs for sales employees, Operating costs for developers, etc.)

	
	

		


		


		
C. Other costs
		
Please enter total yearly amounts of all other cost items here. You could define upt to five additional cost items that should be recognized in your P&L

	
	

		


		
4. Funding
		
A. Financing rounds
		
Please enter your assumptions for your planned / required financing rounds (e.g. capital increases). You could specify volume, date and costs of up to six financing rounds

	
	

		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


		


	



Sheet 3: 1. Cockpit

	
	

		
Cockpit
		


		


		


		


		


	
	

		
Example Case - Version 1.0
		


		


		


		


		


	
	

		
Free Example (Dummy Version)
		


		


		


		


		


	
	

		
Input field
		
Do not change other cells
		


		


		


		


	
	

		


		


		


		


		


		


	
	

		


		


		


		


		


		


	
	

		
Project / Company  name
		


		


		

		Please enter name of your project or company name

		Example Case
		
	

		
Business plan version
		


		


		

		Please enter version of the business plan. We recommend to change this number, evertyime you implement major changes in your assumptions

		1.0
		
	

		


		


		


		


		


		


	
	

		


		


		


		


		


		


	
	

		
Start year
		


		


		

		Please enter the first year of your business plan

		2021
		
	

		
Start month
		


		


		

		Please enter the first month of your business plan (e.g. Start year = 2021, Start month = 8 --> first month of the business plan would be August 2021)
		5
		
	

		
Currency
		


		


		

		Please enter the currency of the business plan (e.g. EUR = Euro, USD = USD Dollar, etc.)

		EUR
		
	

		


		


		


		


		


		


	
	

		
Name of SaaS plan 1
		


		


		

		You could specify up to three different SaaS plans in this model. For each plan, you could enter specific assumption (conversion rate, pricing, etc.) in tab "2. Revenues".

Please enter the names of SaaS plans. In case you would like to use only one or two different plans, please just leave the remaining name field blank 

		Basic
		
	

		
Name of SaaS plan 2
		


		


		
Standard
		
	

		
Name of SaaS plan 3
		


		


		
Premium