Car Wash Development Model | eFinancialModels

The Car Wash Development model projects annual future cash flows from a car wash facility from the purchase of the land, operations of the car wash to the sale of the business. This covers development costs, financing, levered free cash flow, and a cash waterfall for investors. The tabs included are:

Project Inputs
Annual Cash Flows through the purchase of the land, construction, and sale of property

The model starts with the Project Input tab is used to enter most of the assumptions that will drive the model. Here assumptions such as the construction schedule, development costs, finance terms, car wash product mix and car volume, and operating cost are entered and flow into the Annual Cash Flows tab. The model is built to allow for a refinance of the property; the refinance period, cap rate and loan to value can be adjusted. Holding period can be adjusted as well from a drop down menu on cell K44 with an associated cap rate.

The Annual Cash Flows includes a three-statement model with projected revenue from construction to the sale of the property. This also includes important aspects such as development costs, financing, levered free cash flow, and a cash flow waterfall for investors. In the Cash Flow Waterfall section, equity invested, cash flow distribution and IRR can be adjusted for GP/LP. In this section, IRR and NPV is calculated for GP/LPs and the project as a whole. Other metrics include Equity multiple and Unlevered/Levered Cash on Cash multiples.

All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.

File types: .xlsx and .pdf