I've done a janitorial cleaning financial model template in the past, but that was only geared toward hourly based billing and wages. This new model is for commercial or residential cleaning service businesses that operate with recurring revenue contracts and/or have flat fee jobs. All the assumptions are geared towards those revenue streams. You can create clean financial projections with ease by using this spreadsheet.
After purchase, the template will be immediately available to download. This is also included in the industry-specific financial model, SaaS / Recurring Revenue financial model and the service business bundles.
This is a dynamic Excel spreadsheet model that the user can download and edit for their own situations. All light yellow cells are editable. The model can be used to forecast for up to 5 years.
Template Features
Revenue Stream Option 1 - Recurring Contracts
- Define up to 3 customer tiers.
- Define new customers added per month by tier.
- Define the total contract value per tier.
- Define the number of months a contract lasts for by tier.
- Define increase in contract value at renewal if relevant by tier.
- Define the average customer retention rate at renewal by tier.
- Define the total monthly cost of supplies / materials per month per customer by tier.
- Define the count of service workers needed per existing customer (up to two types) and their salaries / efficiency ratios.
- All of these assumptions are adjustable for each year.
- For recurring revenue, I included advanced metrics such as average customer LTV, LTV to CaC Ratio, monthly churn rate, and months to pay back CaC.
- Define the number of jobs completed per month by tier.
- Define the average price per job by tier.
- Define the average count of service workers required and cost per worker by job by tier.
- Define the average supplies / materials required per job by tier.
- All of these assumptions are adjustable for each year.
- CAPEX to define the timing of depreciable purchases / depreciation.
- Debt schedule (user has the option to use leverage to fund a portion of the initial costs)
- Fixed Costs to account for other corporate overheads, ad spend, general managers, and other items.
- Cap Table to define who is contributing the minimum equity requirement (can be inside or outside investors / owners / operators).
- Monthly / Annual financial statements (3-statement modeling integration)
- Monthly / Annual pro forma detail / cash flow / EBITDA
- Annual Executive Summary
- Annual DCF Analysis
- Minimum equity required analysis and resulting IRR
