SaaS Financial Model Excel Template - Single Price Tier Version by Henry Sheykin - Financial Models https://finmodelslab.com/ Last version published: 08/05/2019
COVER PAGE
The cover page is the name of your business project, company or Food Truck name. This name is put in a yellow cell and appears on every file page afterward.
2
Time Series, Currency and Denomination Financial year end in the model - input the last month of the financial year. If you don't need to assume for the financial years, simply type in Dec. First Financial Year in the model - input the very first financial year you want to start from. If you have entered Dec in the Financial year end in the model, then, your calendar year equals the financial year. Model Currency - insert the currency sign or type in USD/EUR or any other abbreviation Denomination - use denomination if you want to show outputs in thousands, millions or billions
3
Dashboard - Customer Acquisition The model assumes that to acquire every new deal you are going to spend a marketing budget. The model has two acquisition channels: offline and online. In both sections, you can type in Monthly Marketing Budget and Cost Per Visit to estimate Visitors The model assumes that visits should be converted into the deals thru the 3-tier conversion. Finally, the total deals should be allocated to Monthly and Annual contracts
4
Customers Movement Setup - Churn
The model take into account the lost customers using churn rate typed in here. You should enter the monthly churn rate both for annual and monthly
5
Costs: Wages
The wages tab allows to easily calculate salaries for staff categories. Use 1 line per employee/category, and simply type in the hire date, fire date, and annual salary. Next, use the staff numbers section to type in FTE count for each year individually. An increase of FTEs means that you are going to hire additional FTE's. In case of decrease FTEs means you fired some FTEs. New FTEs will be hired/fired on Jan of the relevant year. If there are raises or changes in salaries, simply type in the annual Salary raise per position in the appropriate columns. The model will automatically calculate this cost going forward until the fire date. Finally, Monthly bonus as a % of monthly salary can be applied to every line as well as personal tax can
6
Costs: COSS Expenses
The model is built to be easy to use to enter expenses. Simply enter in the list of expenses you want to forecast in the rows COSS expense (i.e. ""cost of selling the services that earn revenue"").
7
Costs: Variable Expenses
Enter in the list of variable expenses you want to forecast in the rows Variable expense And type in the percentage of revenue to be spent in the specific year. Customer Acquisition Cost is grey and not allowed to change. This is the expense calculated by the model based on the marketing assumptions you have entered on the Dashboard
8
Costs: Fixed Expenses Enter in the list of fixed expenses (i.e. ""running the business"") you want to forecast in the rows Fixed expense You have multiple options of when to start to accrue the expense and when to end accruing. You may define periodicity of the accrue for each expense. It could be One-time, daily, weekly, bi-weekly, monthly, quarterly and annually. This gives you the flexibility to manage expenses.
9
Cap Table
10
Cap tables require some manual manipulation to make accurate. The structure enables you to make the necessary modifications. The Cap Table model takes you through multiple rounds of financings Showing how issued shares to new
Valuation
The model can do valuation of distribution of current cash flow to Investors - Discounted Cash Flow, and valuation based Perpetuity Growth method.
11
Reports: Burn
Burn tab is calculated as average cash balance divided by monthly average operating expenses to give you for reporting and planning.
12
Summary
The Summary sheet is a Summary of the key financial reports of the model.
13
Key Financial/Customer/SAAS Charts
14
The Key Financial/Customer/SAAS Reports tab is to provide detailed looks into key company KPIs in the model. It focuses on displaying information rather than creating forecasts. It summarizes information that is calculated elsewhere in the model.
Pricing & billing inputs, assets
15
The subscription plan pricing covers two of subscription business models: monthly, annual contract paid upfront, simply by typing in different inputs. You may purchase some assets on a specific date and depreciate it across typed in years using this tab
Thank you very much for your interest in my tools! If you enjoyed using my model, please let people know about your experience! Give 5-star feedback here & share this page across social networks If you have any suggestions or ideas of how to make this model more useful, don't hesitate, just send me a PM - Henry Sheykin