Car Wash Tunnel or Multiple Bay Startup Financial Model
Review: 5 - "A masterpiece of literature" by , written on May 4, 2006
I really enjoyed this book. It captures the essential challenge people face as they try make sense of their lives and grow to adulthood.

Car Wash Tunnel or Multiple Bay Startup Financial Model

Available: In Stock
$75.00

Latest Updates: monthly and annual three statement model added as well as a capitalization table.

Video Tutorial:


A recent update was added to show average profit per car as well as a visual therin.

A car wash tunnel or car wash bays can be a great investment with the right financial planning and careful management. This financial model tries to give a potential startup operator as much logic as possible to create a 5-year monthly and annual projection of the equity requirements and potential performance of such a business.

 

Oftentimes a car wash is going to be seasonal, so above all else, this logic was built-in  so the user can easily define busier months and slower months. This is more important in the early stages of the business when cash flow is tight.

 

The model has a simple layout. The first tab is for startup costs, funding sources, and the start date of the project and the lead time before revenue starts.

 

The next tab is for operating costs. They are set up to scale with the car counts. The following can be defined in each of the 5 years per car:

  • Electricity

  • Natural Gas

  • Water

  • Detergents

  • Claims

  • Repair & Maintenance

Other fixed costs can be defined per year as a dollar value:

  • Site Labor

  • Office Labor

  • Marketing

  • Accounting

  • Insurance

  • Other Fees

  • Management

  • Rent

  • Property Tax

  • Other Fixed Costs 1

  • Other Fixed Costs 2

  • Other Fixed Costs 3

  • Other Fixed Costs 4

  • Other Fixed Costs 5

The next tab is for revenue. It starts off by defining year 1 expected car count and the percentage that grows each year. There is then up to 6 wash types where the user defines the price of each, the percentage of cars falling into each wash type per year, and the average number of minutes each wash type takes (in order to run logic tests to make sure assumptions are reasonable/possible).

 

There is a simulation where the user can choose a given projected year and based on the assumptions, a monthly summary will display for 12 months to show seasonality. The following are displayed:

  • % of Yearly Volume in each Month

  • Year 1 Expected Monthly Car Count

  • Avg. Cars per Day per Location

  • Avg. Cars per Hour per Location

  • Actual Expected Minutes per Car

  • % of Max Capacity Used

Further inputs for revenue include: 

  • Days Open per Month

  • Hours Open per Day

  • # of Locations

The next area is for potential exit of the business and in this case the user has the option to determine:

  • Valuation Method

  • EBITDA Multiple

  • % of Sales

  • Exit Date if Applicable

Final output summaries include a monthly and annual pro-forma detail, executive summary of high level financial line items, visualizations, and a contribution / distribution summary that includes IRR and DCF Analysis.

 

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
  • Safe Payments
  • Instant Download
  • One-Time Payment