Trusted by 25,000+ startup founders, investors and CPAs
Clean Assumptions, Clear Forecasts
Megan Carter, TX
This template pulled pricing, costs, and growth into one place, so I spent less time untangling assumptions and more time planning. It saved me about 6 hours on the first pass.
Scenario Planning Without The Headache
Derek Collins, FL
Low, base, and high cases were already set up, so I could compare options without rebuilding the model three times. I had a clean scenario view ready for a meeting the same day.
Started With A Real Model
Priya Shah, NJ
I didn’t have to face a blank spreadsheet, which made getting started much easier. I had a usable first draft in under an hour and could focus on the business instead of the setup.
Model review
What does the financial model of a product called Secret Services include?
It is an editable five-year Excel and Google Sheets workbook that models customer acquisition, active service groups, recurring fees, scenarios and financial statements.
Use it to plan the growth of customers based on marketing, mix of service levels, customer life, monthly fees, operating costs, staff, cash needs and financial results.
The editorial assumptions flow through monthly and annual forecasts, Low/Base/High scenarios, basic financial statements and management reports over the five-year horizon.
Built for the exchange of servicesChange of assumptions regarding the acquisition, allocation of levels, customer life, monthly fees, costs, employment or financing and review of the related forecast.
Recurring services revenue engine
How does the secretarial service model calculate revenue?
The model transforms marketing expenses into new customers via CAC, allocates them to levels, maintains active cohorts and charges a monthly fee to each active customer.
01
Get customers
Divide marketing spend by CAC to calculate new customers in each period.
02
Layers
Deploying new customers in different service levels using edited allocation percentages.
03
Hold the cohort
Maintain any cohort active for a certain life or apply the churn convention workbook.
04
Prices of active customers
Multiplication of active clients at each level by its monthly fee for each active client.
05
Calculation of revenue
Add recurring revenues at the level of all active customers and the predicted months.
Basic formulaRevenue = Active customers × Monthly fee per active customer
01 / Revenue assumptions
What revenue influences the forecast of the secretariat services?
The spreadsheet of revenue assumptions allows you to edit start-up time, marketing budget, seasonality, CAC, level allocation, customer life and monthly fees.
Revenue assumptions
The assumptions regarding revenue show the acquisition, customer levels, life expectancy, active customers and monthly fees.
02 / COGS & OPEX
How are the service costs of the model structured?
The COGS & OPEX spreadsheet organises COGS for revenue, variable costs and fixed operating costs for the schedule and monthly calculations.
COGS & OPEX
COGS & OPEX separates COGS from revenue, variable costs and fixed operating costs.
03 / Analysis of the scenario
What's there to compare in scenario analysis?
The analysis of the scenario compares the Low, Base, and High levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Analysis of scenarios
The scenario analysis shall show the results of the revenue and the margins of the Low, Base, and High levels over five years.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the navigation desktop to review model configuration, multiple scenarios, key indicators, revenue mixes, profitability, cash flow and investment return in one place.
Dashboard
The navigational desktop combines configuration controls, scenario results, revenue mix, profitability, cash flow and return charts.
Product adjustment
Is the financial model of the secretariat services suitable for you?
It corresponds to often occurring secretariat services that obtain customers through marketing and charge for active levels per month; significantly different revenue logic may require individual modelling.
Model ready
It fits perfectly
You will gain new customers through betting marketing expenses and cost of acquiring customers.
You're distinguishing customers at different levels of service with different monthly fees.
Model customer retention through life-based cohorts or churn workbook convention.
You need related cost schedules, low / base / high value scenarios, dashboard views and basic financial statements.
Order structure
Think about the model
Your revenue is mainly hourly, based on a project, a task or commission, instead of recurring monthly fees.
You need invoicing of contract, usage prices, minimum obligations or other provisions on revenue other than active customers' subscriptions.
You need operational schedules or reporting structures outside the existing workbook architecture.
You need a model remodeled around different times of cohort, service units or management results.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize a model when you need a different revenue logic, operational schedule or financial reporting.
After purchase you will receive an editable secretariat workbook for immediate download, with combined operating schedules, scenarios and financial statements.
01
Editable workbook
Open and modify the Excel and Google Sheets model using the provided editing entries.
02
Five-year forecast
Review of monthly and annual forecasts within the five-year model forecasting horizon.
03
Analysis of scenarios
Comparison of Low, Base, and High levels of each revenue and profitability measure.
04
Financial statements
Look at the income statement, the cash flow statement, the balance sheet, the dashboard and the related reports.
Before purchase
Secretariat services of Financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How is revenue calculated in the financial model of secretariat services?
Revenues are calculated by multiplying active customers at each service level by a monthly fee of this level and then combining the level revenues over the entire forecast. New customers come from marketing expenses divided into CAC and remain active according to the logic of life or churn.
02
Which assumptions can I change?
You can edit the start date, initial customers, annual marketing budget, monthly seasonality, CAC, level allocation, customer lifetime or churn and monthly fees by level.
03
What can be compared to low/base/high scenario analysis?
It allows comparison of low, underlying and high revenues, gross margin, coverage margin and EBITDA in the framework of a five-year forecast.
04
What financial results are taken into account?
The workbook contains the profit and loss account, cash flow report, balance sheet, navigation desktop, summary, profitability threshold, ROIC, charts, KPIs and display displayed in the product gallery.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. Financial Models Lab can build or customize the model based on different revenue logic, operating schedules or reporting requirements.
06
Is forecasting in the workbook a guarantee of efficiency?
No. The workbook is a forecast of planning based on edited assumptions, not a guarantee of financial or operational results.
What Does the Secretarial Services Financial Model Contain?
This Secretarial services financial model provides a complete, user-friendly framework to forecast revenue, manage expenses, and secure investment for your administrative support business.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue assumptions
COGS & OPEX
Analysis of scenarios
Dashboard
