The tab structure is really easy to follow.
- Tab1: Cost - This is where you will enter all the costs for equipment relevant to the dry cleaning business, if you are going to purchase or rent the building, and enter all relevant on-going expenses related to the operations of the business. Over 30 startup cost and on-going cost spaces are available so you can be sure to capture all relevant costs for you specific scenario. This tab also allows you to pick a % if any that you want to finance of the startup costs as well as the % growth of on-going expenses and the amount of years you want that growth to effect.
- Tab2: Revenue - Here is where you drive the amount of annual revenue you plan on making. It is pretty simply. You will enter the amount of items you plan on doing a day, the average item ticket, and the amount of working days per year. This will then populate an estimated annual revenue figure.
- Tab3: Financing - If you choose to finance some of the dry cleaning startup costs / liquid capital requirements, than the resulting $ amount borrowed will show up here as a loan. It is a full monthly schedule that will in-turn populate your annual debt service coverage obligations. Note that on the P&L summary you will need to manually enter the mortgage balance if you plan on selling the business before the loan is paid back.
- Tab4: Returns - This is where you see how the project looks from an aggregate and annualized perspective. Metrics will include break-even year, IRR, net and total ROI $/% as well as how much net cash flow you will see flowing per year based on the total cash returns of the project.
- Tab5: P&L - This is the pro forma. All of the revenues and cost items will iterate here over the amount of years you enter as your "Operating Years" input on the 'Revenue' tab. This includes growth and potential sale based on EBITDA multiple you choose.
Note that you will have to use this at your own risk of profit/loss and this is an excel financial model meant to help give the user an idea of what kind of money they can make in the dry cleaning business if given their own written in assumptions.