SaaS Financial Model (Premium Version) + 1 Hour Video
Originally published: 29/09/2020 10:44
Last version published: 28/05/2021 12:09
Publication number: ELQ-84376-6
View all versions & Certificate
certified

SaaS Financial Model (Premium Version) + 1 Hour Video

Financial Model Template for any SaaS / Subscription Model Business. Including 1 Hour Walkthrough Video.

Description
The Premium SaaS / subscription model Financial Model is a comprehensive model with a clear and user-friendly structure which makes it easy for you to adapt to your own business, and amend as you wish to make your own financial projections.

Looking for the Basic version instead ($39)? Please see link below:
https://www.eloquens.com/tool/EEjRSaJw/startups/financial-models/saas-financial-model-basic-version

Here is the detailed list of tabs I included within this model and the link between them:

1/ Settings
List key assumptions that flow through the model. This is your a tab where you can modify key inputs such as corporate tax rate, first forecasted month, financing assumptions (debt, equity), etc. without modifying any other tab. P&L, cash flow statement, balance sheet, metrics and charts will automatically update accordingly in their respective tabs.

2/ Dashboard
Charts of the main metrics and their monthly evolution (GMV, cash burn, CAC, etc.) for ease of use. Charts can conveniently be copy pasted in a pitch deck.

3/ Metrics
Exhaustive list of metrics their monthly and yearly evolution. Essentially similar to the dashboard, but without the charts and much more exhaustive.

4/ Operating Model
Main tab which consolidates the 3 financial statements: profit-and-loss, cash flow and balance sheet. All the following tabs flow through this sheet. Also includes some additional calculations such as corporate taxes / taxes carryforward, net interest and working capital.

5/ Fundraising
This tab calculates for a given fundraising round the breakdown of your net cash burn so you can assess how much you should raise, and how the money will be spent across the key expenses segments.

6/ Valuation
This tab calculates the Enterprise Value of your business based on the Discounted Cash Flow valuation method, so you can back up a tangible valuation for your next fundraising round.

7/ Marketing Funnel
This tab is the very start of the revenue build model. It calculates the number of new subscriptions from website traffic through paid ads, organic and social media channels. The output (new customers) flows through the Revenue Model tab.

8/ Revenue Model
Follow up with Marketing Funnel tab, this is the most heavy tab of the model which calculates subscription revenues from new customers, and factors in upsell, downsell and churn for a total of 4 product packages. It also calculates revenues both from monthly and annual subscriptions which will eventually impact the Deferred Revenue tab. Output flows through the Operating Model and Deferred Revenue tabs.

9/ COGS & SG&A
This tab calculates all expenses related to the business, both COGS and SG&A, and their evolution based on a series of editable assumptions. Expenses are specific to SaaS businesses and include, among others, hosting, sales & commissions, customer support, equipment and onboarding costs, etc. Flows through the Operating Model.

10/ Hiring Plan
Detailed list of all FTEs per team (Management, Engineering, Sales, Marketing, etc.) and salary costs. Includes salary indexation and salary increases assumptions. Flows through the Operating Model.

11/ Deferred Revenue
Important tab which impacts both the balance sheet and cash flow statement. It calculates the deferred revenue adjustment on both statements, stemming from the monthly vs. annual subscriptions revenues. Flows through the Operating Model tab.

12/ Capex & D&A
Capex (equipment, material, etc.) and the associated straight-line depreciation schedule which flows through the 3 financial statements.

Thank you!

Remi G.

This Best Practice includes
2 spreadsheets (Excel and Google Sheets) + a link to the 1 hour walkthrough video

Acquire business license for $99.00

Add to cart

Add to bookmarks

Discuss

Further information

This model template is for entrepreneurs, startup founders or established businesses looking for a comprehensive and dynamic financial model with all variables, assumptions and metrics specific to subscription model businesses.

It is a perfect tool for businesses looking for a rock-solid financial forecasts to use in their fundraising or budgeting efforts. IFRS compliant, it also includes all investor-friendly and industry-standard features such as 3 consolidated financial statements (P&L, balance sheet and cash flow statement), up to 5-year forecasts and charts and reports which can be re-used in investor or company presentations.

Looking for a simplified financial model instead? Our Basic version of the SaaS financial model template is made for you (available on Eloquens)


4.8 / 5 (4 votes)

please wait...