Video Tutorial:
Recent Updates: Interconnected Income Statement, Balance Sheet, and Cash Flow Statement added (monthly and annual), cap table for inside and outside investors, capex schedule with depreciation, and improved global assumptions formatting.
This model has got a lot of bells and whistles. It starts off with assumptions about potential debt, investor equity, and owner equity. Owner equity is a calculation that is determined by the actual cash flow resulting from the assumptions. You can also define the month of exit and an exit valuation multiple.
You will see that the revenue assumptions below allow for MRR expansion and negative churn calculations to be done for each month.
The revenue assumptions start off by defining the start month of revenue and the number of locations added per month in each of the 5 years. It then gets into the 3 subscription services for monitoring services. Since you can have some locations with more advanced services and add-ons, the best way to build a model for this is to simply allow for up to 3 pricing tiers.
Further Assumptions:
1. % of new locations that sign-up for a given pricing tier.
2. Monthly churn of each tier.
3. % of Installations that are low/mid/high budget.
4. Avg. equipment cost for low/mid/high budget.
5. Avg. installs a tech can do per month for low/mid/high budget installs.
6. Avg. hours per installation per type and the hourly rate paid to techs per the type of install a tech is working on.
7. Margin earned per installation per type.
8. Upsells (tier 1 subscription to tier 2 and tier 2 to tier 3.
9. Downsells (tier 3 to tier 2 and tier 2 to tier 1)
10. Service calls per location per year/hours per service call/charge per service call.
The costs involve defining the margin you make on the monitoring service. i.e. if you are charging $28/month, and you want to make 60% margin on that, then your cost is $11.20 per month. This is how the costs are defined for your monitoring service provider for each pricing tier.
The rest of the fixed monthly costs are defined by the start month, the monthly amount in year 1, and the yearly % increase.
There are also assumptions for credit card fees and income taxes as well as depreciation. I built a ‘depreciation helper’ tab.
There is a monthly and annual detail to show the result of the assumptions and their impact on cash flow.
There is a distribution/contribution summary to show the owner and investors cash requirements and cash returns as well as their IRR, DCF analysis and NPV as well as their equity multiples respectively.
File types: MS Excel – .xlsx
Similar Products
Other customers were also interested in...
Locksmith Business – DCF 10 Year Financial M...
The financial model for our locksmith business is a dynamic and robust tool designed to forecast and... Read more
Startup Business Plan – Security Company
If you dream to start a security business, the template is the first step in making your dream into ... Read more
Cyber Security Financial Model Excel Template
Cyber Security Financial Model Impress bankers and investors with a proven, strategic business plan ... 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
Product + Subscription Financial Model
Build a strategy for adding recurring revenues services to your product. Includes financial statemen... Read more
Startup Model: General Rental Business of Tangible...
This is a 5-year startup model for the rental business. There is specific logic to show the projecti... 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
Daycare Service Facility Financial Simulation R...
Dynamic assumptions to create pro forma financial statements for a daycare service facility. Include... Read more
Industry Based Financial Models (Variety Bundle)
There are currently 52 unique financial models included in this bundle. Nearly all of that include a... Read more
Laundromat Financial Model – 10 Year
This template allows the user to produce financial statements based on assumptions specific to the l... Read more
You must log in to submit a review.