Due to initial losses, resulting in a need to resort to shareholder loans, cash flow pressures caused accounts payable to be stretched out to 30 days and more. The financial projections have reduced this to 10 days for the year 2001 and beyond, in hopes of filling this gap with increased bank lines of credit. This would allow the company to take advantage of trade discounts. Failing to do so is expensive, as it becomes the most expensive form of credit (approximately 36% p.a.).
The hourly basic wage rates were totalled ($241.73) as were the total after FICA, State Unemployment, FUTA and health benefits ($291.66). The difference came to 21%. The actual burden of 21.95% is from the September, 2000 financials.
Looking at the various rates in effect (see Cash flow Section), 9% was taken as an average rate.
In order to show the cash flow effect we elected to assume 10 days so as to take advantage of all trade discounts. This change from 30 days to 10 days will take place in 2001. The cost of not taking the discounts is nearly 36% per annum. It is preferred to finance negative cash flow through bank lines of credit.
Collection days, after netting out down-payments with orders, average approximately 30 days.
The tax rate reflects the present sliding scale:
|$0 to $50,000||15%||9.5%|
|$50,000 to $75,000||25%||9.5%|
|$75,000 to $100,000||34%||9.5%|
|$100,000 to $335,000||39%||9.5%|
|$335,000 and up||34%||9.5%|
The break-even chart is not suitable for multiple custom woodwork items. However, if we use pilasters as an example, the unit price is $316.96 and the unit cost is $44.09 (material cost). If we assume that all plant labor is fixed, whether there is work for the staff or not, it would be necessary to produce and sell 136 pilasters per month. According to best estimates, one pilaster takes four man hours. With 8,000 man hours per year (666 man hours monthly) it is possible to produce 167 pilasters. So, to break even on pilasters alone it would be necessary to work at 81% of capacity.
If, instead, we take cabinets, and use a cost price of $57.66 per Linear Foot LF and a price of $194.76 per LF it would be necessary to produce 270 linear feet of cabinets monthly. At 1.65 man hours per LF, it would be possible to produce 404 linear feet. Break-even on cabinets needs 67% of capacity.
Doors (cope and stick) cost $130.53 per unit and sell for $592.35. Each door takes five hours to produce. It would require 80 doors to break even, out of a maximum capacity of 133 doors. This would be 60% of capacity to break even.
All other things being equal, based on the above analysis, it would be more profitable to produce doors than cabinets, and likewise more profitable to produce cabinets than pilasters.
In the calculations above, it has been assumed that there is no problem in keeping the six site carpenters working full time. The net profit from this activity has been deducted from fixed expenses. If, instead, we assume that the company makes no money on-site services, the monthly expenses would be $89,925 higher. In this case, it would take 96 doors monthly, rather than only 80, to break even.
As mentioned in the chapter on Company History, a more in-depth analysis of past performance is listed on an Excel spreadsheet in Appendix A. The top two rows summarize 1999 and 1998 financial sheet information in an easy to read format. These categories of information are then used to calculate important ratios to compare Comgate results will industry averages. The ratios have been organized into five main groups: Liquidity, Safety, Profitability, Balance Sheet, and Operations Management. Brief comments are made below concerning these ratio comparisons:
Liquidity decreased from 1.27 in 1998 to 1.19, due entirely to a large project on Orange. The large commercial contractor involved took far longer to pay than was anticipated. The project has since been completed and all outstandings have been settled. Despite the 1.19 current ratio for 1999, it is still superior to the average of 1.01 for all AWI members and fairly close to those members in the Northeast Region (1.24).
The debt-to-equity ratios have been calculated reflecting certain adjustments. Owner loans have been removed from long-term liabilities and placed into equity. The Debt/Equity ratio for 1999, of 11 to 1, is far higher than the average. It reflects the early start-up losses; however, the leverage improved remarkably from 1998, when it was 25 to 1.
The gross margins are substantially higher than the average, which reflects the higher-end nature of the company's work. Operating profit saw a healthy increase from 6.12% in 1998, to 9.67% in 1999. This is not as good as the operating results of the top 25% of AWI members (22.4%) but still more than double the margin for all AWI members (4.2%).
The ratio of Sales to Net Fixed Assets is a good measure of efficiency. Comgate's ratio of 9.53 is not only a substantial increase over 1998, but is nearly equal to the top 25% of all AWI member results. Obviously the very high operating results to equity ratio merely reflects the narrow equity situation. The same can be said for the fixed assets to equity ratio. The A/R turnover (in days) as well as the A/P days turnover were slowed by the above-mentioned large Orange project. The low inventory days turnover reflects the proportionally lower material content of the high-end business.
The most remarkable ratio in this group of ratios is the very high percentage of non-plant produced sales to total sales. This reflects the revenue from outside on-site subcontracted carpenters and installers.
Note: appendices A - K have been omitted from this sample plan presentation.
Other Expenses (CoGS): There are several expenses that are included here:
These CoGS expenses come to to $3,088.55 (January-August) and $5,538.55 per month after August, 2000. Beginning January, 2001 the total grows to $7,538 due to the increased space and rent.
Sales and Marketing Expenses:
General & Administrative:
In the first nine months of 2000, $110,412 was added in new machinery and equipment.
Increase (decrease) Other Liabilities:
At the end of 1999, there was $49,884 outstanding in shareholder loans. After netting out loans due from shareholders amounting to $20,396, loans from shareholders were reduced by $8,126.23. No further changes in years 2001 and 2002.
Change in Other Short-term assets:
At the end of 1999, there were only $1,465 in other short-term assets. This has been increased due to pre-paid insurance, and reflected in April, 2000 of $2,855. No change in 2001 or 2002.
Long-term Borrowing (repayment):
The following table represents Comgate's balance sheet.
The table below shows some of the more important ratios. The table also includes business industry data for Standard Information Code (SIC) 2541, wood partitions and fixtures.