Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
  • Janitorial Service Business: Financial Model - 5 Year
Originally published: 03/04/2018 07:52
Last version published: 14/01/2019 16:28
Publication number: ELQ-93257-3
View all versions & Certificate
certified

Janitorial Service Business: Financial Model - 5 Year

A financial model for any kind of people-based service business. This is geared toward a janitorial cleaning service.

cleaning serviccost per hourfinancial modelfinancial projectionsjanitorial servicep&lpro formarevenue per hourwaterfall distribution

Description
*Recently updated to have logic 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 business tool includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

A forecast for any business with some kind of service labor as its primary income source.

A cleaning / janitorial services business.

A business that does not primarily use labor as its method of revenue generation.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Janitorial Service Business: Financial Model - 5 Year?

The user community and author are here to help. Go ahead!

please wait...