Security System Services Startup Financial Model - Includes Expansion MRR and Negative Churn

This financial model was built specifically for the security and alarm services business. It is very similar to a regular SaaS business where you have monthly recurring revenue for subscribers. I have built up to 3 pricing tiers for what customers may pay per month.



Pricing
You will be sent the template after purchase. This model is included in the 'as-a-service' bundle.

The biggest benefit of this template is that it shows the calculations and proper visuals for MRR expansion and negative churn. MRR expansion is when you upsell your current customers into higher paying subscription services. Negative churn is measuring the total value of upsells against the value of downsells and cancellations.

In order for that to work, I have added assumptions for the % of tier 1 customers that upsell to tier 2 and tier 2 upsold to tier 3. Also, I have assumptions to go from tier 3 to 2 and 2 to 1. You can't go from 1 to 3 or 3 to 1 in this build.

The other unique part of this model is the technician logic. In a security systems business, you generally have to have a technician or multiple technicians go out and install all the equipment. You have to buy the equipment and pay for labor. I have added logic so the user can enter the average installations a tech can do per month per budget type (up to 3 installation budgets) i.e. a tech may be able to do 5 low budget installations per month but only 1 high budget installation per month.

Along with logic that tells you how many technicians you need, it also allows you to define up to 3 hourly rates for them and the average hours a given installation will take (up to 3 types).

The rest of the model is super flexible and easy to use. You can define the amount of locations (or subscribers) that are added per month across each year as well as your expected margins for subscription revenues and installations (this backs into how much you pay for the service suppliers to monitor the locations as well as how much you charge a given customer to do an installation.

I have included logic to account for the possibility of a loan that is taken out, investor funding (you define the investors' funding amount and % of the company they get in return), and then owner funding if the investor and debt amounts don't cover the total cash requirements per the assumptions entered.

For costs, you can define the cost type, the month it starts, and the monthly amount. In this one, I did the future years a little different by adding a yearly % increase in General and Administrative costs. You can easily override that by manually entering a value into the cell if needed.

I have depreciation as a manual entry per month and there is logic to account for income taxes if you want to display that.

There are over 20 visuals that provide a quick overview of all the key metrics of the 5-year financial forecast. I really liked how the MRR expansion and negative churn ones came out. I included a monthly and annual detail to show how the assumptions end up affecting all areas of the cash flow and then did a high-level executive summary that is more geared toward a standard income statement and statement of cash flows.