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.
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