Plumbing Business 10 Year Financial Simulation

Description
This is a 10-year financial planner / simulator that takes into account as many aspects of starting/running or even acquiring a plumbing business. You can run all sorts of feasibility studies with this, test pricing, expenses, and various future effects that will effect revenues/expenses and cash requirements.


Starting any business should begin with a financial planning spreadsheet. You can easily enter expected one-time startup costs and expected operational assumptions in order to plan out minimum cash needs and expected financial performance of a plumbing business operationg by using this financial simulator built in MS Excel.


The template starts off by allowing the configuration of up to three service types, how much is charged on average for each completed job, hours it takes a plumber, materials/costs per job, and the growth of jobs per month.


You can also configure the hourly wages of plumbers that are working each service type and variable costs for each therein.


The focus here is scaling and figuring out key variables that can change the economics of an operationg, understanding patterns, and generating a mental model of what your long-term goal is.


Input fields include options for debt funding, capex schedules that have connected depreciation, and a cap table to organize who is investing what and their resulting share of the profits.


Output Reports:
 - Monthly and Annual Financial Statements (Income Statement, Balance Sheet, Cash Flow Statement)
 - DCF Analysis for all pools and the project as a whole
 - 10-Year Annual Executive Summary showing key financial results and cash flow
 - Lots of cool visualizations


I linked back the annual results to the assumptions tab so you can see if the inputs you are entering make sense and are feasible (based on things like average hours worked per plumber per month and average earnings per plumber per month). There are also KPI metrics caclulated such as average gross profit per job.


The exit value is based on trailing 12-month EBITDA against a defined multiple and you can select to include the exit value or not. If not, then the model will run as normal until the defined end month (up to a 10 year period).


Note, this could easily be adapted to an electrician business or any service business that pays workers some wage and charges a one-time fee for the jobs they do.

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 Financial Models Bundle: https://www.eloquens.com/tool/lrNGt2jL/strategy/business-plans/business-sector-bundle-35-bottom-up-financial-models