Janitorial Service Business: Financial Model - 5 Year

Description
Recent updates include a fully integrated 3-statement (3-way) model with monthly and annual income statement, balance sheet, and cash flow statement as well as a cap table and better global assumptions.

Logic added for exit proceeds based on an applied revenue multiple. All summaries and implications adjusted accordingly.

The revenue specific logic for this model is that you have 50 workers. You can define a revenue earned per worker as well as a cost per worker. Based on the assumptions on how many hours each type is working per month, the revenue and costs populate.

If you only have a few worker types, but 100's of workers, you can simply enter the worker types you have and their revenue generation / costs (wages) per hour and then put in the total hours per month you expect each type to do. I say this so you know you don't have to limit a single individual person to each line if you have many people working at the same rate.

The month that each worker type starts can vary.There are also full assumption lists for running monthly costs (variable start month) and startup costs.

The possibility for a loan is available and you can enter its assumptions as needed.

All of these assumptions come together in a clean monthly and annual P&L/cash flow summary.Just to talk about the revenue logic again, this has multiple use cases and there is a lot of flexibility into what it may be used for. 

Anything that needs to match a cost per hour to a revenue generated per hour for various line items would fit here. I have had people use this model for a wide array of uses.

The goal I have committed to in this financial model is to be able to allow for enough flexibility that the widest array of cases can fit without fundamentally breaking the logic.

A final area of this specific model is a waterfall distribution between an investor and a sponsor (business owner) that is based on a portion of the capital requirement being provided by those two groups. The % is split based on the total equity contributed by each group.

***Update from video: the waterfall distribution between investor/sponsor has been updated. The previous logic as seen in the video is based on no financing. The logic has now been updated to account for financing and still assign the right % share to each group in the distribution portion of this template.

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- Industry-Specific: https://www.eloquens.com/tool/lrNGt2jL/strategy/business-plans/business-sector-bundle-35-bottom-up-financial-models