$45.00 USD
Recent update: Added 3-statement model with monthly/annual financial statements that are fully interconnected to the assumptions as well as a cap table and capex schedule with depreciation logic.
The functionality is super easy to follow and one of the newest features I have added as the all elusive waterfall analysis along with IRR returns and equity return multiple.
General specs:
**Update: The logic to determine the percentage of available cash flow split between investor / business owner (operator) has now been updated so that if financing assumptions are introduced the percentage breakdown is still accurate. Previously, it worked only if $0 were financed.
General specs:
- Will also work for a home health care agency
- Goes out 5 years.
- Has monthly/annual P&L breakdowns
- Allows for up to 50 service workers
- Dynamically pick worker start date, hours/month, billable rate.
- Build your startup costs and on-going operational expenses.
- The EBITDA/equity distributions automatically fill in.
- Visuals for revenue/expenses/EBITDA as well as running cash position/debt.
- Auto integrated debt service assumptions and flow to cash flow projections.
- Instructions and notes are included.
The key difference between most financial models is just the way you build revenue and expense assumptions. For this type of industry you are going to have crews going out and working at various places. In turn, you need a way to show how many works you have through the first 5 years of operations, what you are making from their work, and how much they are costing.
The interesting thing about cleaning and janitorial businesses is the cost is low. If you can gain the clients, there is not too much overhead to deal with. Obviously expansion would mean paying a bit of administrative support as well as figuring out where to put all the cleaning supplies / equipment as well as keeping up with safety standards.
This model is nice because you get industry specific variable analysis as well as general financial summaries that are nice and clear to investors and users. It gives you a clear way to articulate and back up all of your assumptions.
**Update: The logic to determine the percentage of available cash flow split between investor / business owner (operator) has now been updated so that if financing assumptions are introduced the percentage breakdown is still accurate. Previously, it worked only if $0 were financed.
More Industry-Specific Bottom-up Financial Models: