Tutorial Video:
Recent Updates: Added a fully integrated monthly and annual Income Statement, Balance Sheet, and Cash Flow Statement as well as capex with depreciation and a capitalization table.
This model forecasts out for a period of 5 years. There are monthly and annual summaries to display assumption effects. The logic is based primarily on ratios.
Ratios Include:
1. Amount of AE’s per SDR’s plus SDR’s added per month in each of the 5 years.
2. Quota per AE per month.
3. Quota attainment in first 3/6/9/12 months per AE.
4. Count of CS reps per new monthly deals and per active users.
5. Percentage of revenue allocated to engineering.
The above ratios are the main calculations that make the scaling of this model smarter. There are also assumptions for up to 3 pricing tiers, churn per tier, and running fixed expenses as well as COGS. COGS run off of a cost per active user per month and/or a direct % of revenue.
You can enter the possibility of a P+i loan as well as investor equity. Any additional cash required will automatically flow to owner equity requirements. The user can define the % of the company the investor gets with their investment as well.
There are equity contributions and distributions that run based on the free cash flow as well as a high-level executive summary that shows the project operations.
Advanced metrics for this include CaC, LTV, revenue per employee and per user, CaC payback, and LTV to CaC ratio. All metrics have accompanying charts. There are additional charts that show general financial performance, cash flow, user growth by type, and MRR by type.
Logic exists for one-time revenue of new customers if applicable i.e. setup fees.
Anything that does not apply to your situation can be zeroed out.
File type: .xlsx
Similar Products
Other customers were also interested in...
5-Year Enterprise SaaS Financial Model – 3 C...
A dynamic financial model to forecast monthly and annual customers/revenues/expenses for a SaaS comp... Read more
Product-as-a-Service (PaaS) Financial Model
This is a true PaaS model with flexible build-out assumptions, capacity sanity checks, and direct sa... Read more
Subscription Box Financial Model – Up to 72 ...
Test many variables in this financial model for a subscription box company. Includes up to six prici... Read more
Data-as-a-Service Financial Feasibility Study
This model is built for data-as-a-service startups. If you have valuable data to monetize, this temp... Read more
Product + Subscription Financial Model
Build a strategy for adding recurring revenues services to your product. Includes financial statemen... Read more
Website / App Financial Model (Recurring Revenue S...
A great tool to model out any recurring revenue service that acquires users through a website or app... Read more
Marketplace with 3 Subscription Tiers: 5 Year Fina...
I built marketplace assumptions on to of my best subscription forecasting model to get this beautifu... Read more
SaaS Financial Model Bundle
This is a bundle of Financial Model Templates for SaaS businesses and their related sectors such as ... Read more
Property Management Business Financial Model
Create a wide range of scenarios for the financial forecasting of a property management business. In... Read more
Function-as-a-Service (serverless computing) Finan...
Create financial projections for a FaaS cloud computing services business. This is a recurring reven... Read more
You must log in to submit a review.