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

Security systems / alarm services businesses fall into the product + service systems business category. This financial model was built specifically for security and alarm services businesses. It is very similar to a regular SaaS business where you have monthly recurring revenue for subscribers, except you will also make margins on installation of hardware.

$125.00 USD

The template will be immediately available to download after purchase. This is included in the SaaS financial model template bundle.

security system

Latest Updates: Added interconnected financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) as well as a capitalization table (cap table) and improved formatting conventions / global control configuration.

The biggest benefit of this spreadsheet 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 down sells 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.

For pricing help, see this SaaS pricing simulator.

Also, check out this SaaS Rolling Revenue Forecast.