Start-up Funding | |
Start-up Expenses to Fund | $22,350 |
Start-up Assets to Fund | $444,223 |
Total Funding Required | $466,573 |
Assets | |
Non-cash Assets from Start-up | $320,000 |
Cash Requirements from Start-up | $124,223 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $124,223 |
Total Assets | $444,223 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $21,354 |
Long-term Liabilities | $180,000 |
Accounts Payable (Outstanding Bills) | $61,409 |
Other Current Liabilities (interest-free) | $16,810 |
Total Liabilities | $279,573 |
Capital | |
Planned Investment | |
Jim Hunt | $56,000 |
Mike Pacek | $36,000 |
New Investors | $75,000 |
Other | $20,000 |
Additional Investment Requirement | $0 |
Total Planned Investment | $187,000 |
Loss at Start-up (Start-up Expenses) | ($22,350) |
Total Capital | $164,650 |
Total Capital and Liabilities | $444,223 |
Total Funding | $466,573 |
The facilities are located in a rented building on an industrial estate in Newark, California.
A description of the technology involved in the production can be found in section 3.5 (Technology). The following is a description of the production layout.
The company is in the water purification business. H20 Industries is engaged in a specific branch of this business called “Service deionization.” Within this branch, the company plans to emphasize a further service specialization known as “segregated regeneration,” as opposed to “bulk regeneration.” This concept is explained in the following sections.
The service products offered by H20 Industries are segregated as well as bulk regeneration of portable H20 Industries exchange tanks. The service is offered in three tank sizes of 3.6, 2.5, and 1.4 cubic feet (cu ft). In these sizes, the company will offer:
The application of portable deionized water is broad. Practically all industries using water in processing are potential accounts. Size of company is rarely a determining factor. There are applications in electronics and high pressure boilers where flow rates of several hundred gallons per minute are provided by portable exchange systems. The main unique benefits are:
Providing the service to a customer is simple, usually requiring only minimal equipment. H20 Industries is available from a large competitor, US Filter and a few small competitors, such as Fluid Solutions of Lowell, MA. However, none of the competition can provide segregated regeneration (See Competitive Analysis below).
In the Northern California area, outside of a small company in Lowell which has to farm out its regeneration business to a “DI” company in Nevada, Simply Clean in Oregon, and a couple of independent Culligan agents, there is only the very large, fully-integrated US Filter (owner of Culligan) to compete with. This company, by virtue of its size and involvement in all fields of water treatment, is not suited to satisfying small users of DI, nor are they able to respond to niche needs. For example, US Filter cannot handle segregated resin. All resin treated by US Filter is regenerated on a bulk basis, which means that various customers’ depleted resin tanks are combined. This is not a problem for many users of DI, but the dialysis department of a hospital might well object to their resin being co-mingled with resin used in the metal plating industry. H20 Industries plans to specialize in portable segregated resin service. US Filter can try to service customers with a desire for segregated DI by promising to always supply tanks with new resin, however, there are technical problems with this.
US Filter’s prices for cation and anion regeneration are $31.25/cu ft and mixed bed $43.05/cu ft. H20 Industries’s prices for the same bulk regeneration are $32 and $43, respectively. The primary market thrust of H20 Industries’s sales will be the segregated regeneration which US Filter does not offer. This product sells at a premium ($57/cu ft and $63/cu ft, respectively). Some small players in the market offer regenerated resin (not segregated) in a price range of $63 to $80 per cu ft (mixed bed).
Sales literature will be written and printed. A provision for this has been made in the projected sales and marketing expenses.
The service provided by H20 Industries is the regeneration of ion exchange portable tanks. The tanks themselves are supplied to customers on either a monthly rental basis or offered for sale. These tanks, and any other hardware, are readily available from a number of suppliers. By virtue of the owners’ long involvement in the industry, they are fully knowledgeable of existing sources for all hardware, including resin, as well as the supply of the two major chemicals used in the process of regeneration. The only other variable cost of production is the salt used in the brine bath, this is also readily available from a number of suppliers.
Ion exchange is a major means of purifying water for industrial purposes. The degree of purity depends on the source of the water and it’s use. Companies, ranging from car washes to the pharmaceutical and semiconductor industries all need various amounts and degrees of purified water. Ion exchange is a chemical process by which ions, or ionic substances that are considered “undesirable” in water, are reduced or removed from water by use of ion exchangers or resins. Most ground water contains unwanted dissolved substances, such as calcium and magnesium, whose molecular structure contain charged ion particles.
The most common impurities with ions of a positive charge are: sodium, calcium, magnesium, potassium, iron, and manganese. These are called cations. The unwanted dissolved substances having negative ion charges, known as anions, are: bicarbonate, chloride, carbonate, sulfate, nitrate, and bisilicate. When a substance separates into ions, each ion is now able to combine with another ion with opposite charge, even if that ion is from a totally different type of molecule. Substances only separate into ions when immersed in water molecules. For example, a molecule of hydrochloric acid is made up of a hydrogen atom and a chloride atom. Hydrochloric acid (HCL), when immersed in water, will split apart into one positively charged hydrogen cation (H+) and one negatively charged chloride anion (CL-). If sodium hydroxide (NaOH) were added to this solution, the NaOH would split into Na+ and OH-, which would combine with the opposite charges of the hydrochloric acid ions to form sodium chloride, better known as “table salt” (Na+CL-) and leftover hydrogen and hydroxide atoms (H+OH-). The field of deionization, known as DI for short, utilizes this natural phenomenon by designing a cation exchange resin which will substitute hydrogen atoms (H+) for virtually all of the other cations, and designing an anion exchange resin which will substitute hydroxyl ions (OH-) for virtually all of the other anions. By means of this process we end up with only H+ and OH- which is equivalent to H2O (water). By forming this demineralized water, we create water which is no longer a conductor. We can measure the purity using an ohm meter. Ohms measure resistance. The higher the ohm count, the lower the conductivity. H20 Industries is routinely formed to 18 mega ohms per centimeter, which is very close to zero conductivity (18.23 at 25 degrees Centigrade). Without giving lengthy chemical explanations, what happens in the process is as follows:
The regeneration process can take place at the location where the water is being purified, however, most users of H20 Industries do not install the expensive equipment to do this but simply arrange for a service provider, such as H20 Industries, to replace the tanks and perform the regeneration process off-site.
As high-tech industries, such as electronics, communications, and pharmaceuticals, continue to grow, there will almost certainly be increasing use of deionization technology and deionized water. As instrumentation and analysis procedures improve, controlling and monitoring the deionization process will be easier and more efficient, and this will, undoubtedly, help create new uses for deionization that have not yet appeared, as well as make H20 Industries more affordable to sectors now using other methods of purification. As more people in the water treatment industry become familiar with the DI process, the industry for H20 Industries and equipment will benefit.
In addition to bulk and segregated portable H20 Industries, the company plans to expand sales of filters and DI cartridges. These sales have been disregarded in this business plan, but they could become more significant in the future. These products lend themselves to mail order type sales, as they are small and lightweight. Cartridges are disposable items. H20 Industries also has plans to develop a reusable shipping container for its smallest (8″ x 18″) DI exchange tank so that this can also be shipped via UPS. This product will be marketed on a website, as well as through conventional direct mail and yellow page advertising.
In the future, a logical off-shoot of the DI business is reverse osmosis (R/O) used in conjunction with DI exchange tanks. The inclusion of R/O in front of the DI tanks will extend the capacity of an exchange tank by 1000%. This addition to the product line could become a substantial element of total company sales.
Reverse osmosis and electric reversing deionization are beginning to compete with exchange tank DI technology. H20 Industries plans to offer service contracts to maintain this equipment at the customer’s location. This equipment may to either sold or leased.
The total market in Northern California for H20 Industries is between 670,000 and 925,000 cu ft of resin annually. H20 Industries’s total productive capacity will be only 36,400 cubic feet, or 3.9-5.4%. Since H20 Industries will have the unique capability of performing segregated regeneration, which is of special interest to the medical industry (dialysis, labs and pharmaceutical), the company will emphasize sales efforts in this segment for high purity H20 Industries. This segment is estimated at 167,000 cu ft annually. Next in terms of marketing emphasis will be the electronic (223,000 cu ft) and machine tool industries.
The market for H20 Industries encompasses many industries, and within them there is a wide range of purity needs. At the low end, a car wash might use H20 Industries in the final rinse only. Their need for purity might be only .5 Megohms (Ohms measure resistance). Water is only a good conductor because of the quantity of dissolved solids in the water. As the ion exchange process lowers the level of total dissolved solids (TDS) the resistance, measured in ohms, increases.
A purity level of .5 Megohms is pure enough for a car wash final rinse cycle, but not even close to pure enough for a electronics wafer manufacturer. They would need 18 Megohms, at which point the water would be pure and incapable of acting as a conductor. Generally speaking, those sectors of the market that need the highest levels of purity are the customers for H20 Industries’s main niche product of segregated DI exchange service. This means that the resin coming back from the customer is never mixed with any other company’s resin. This is a very strong sales feature when dealing with dialysis units of a hospital, labs and pharmaceutical manufacturers, and electronics makers. These customers are happy to pay a premium over the price charged for bulk DI regeneration service because they do not want their resin co-mingled with resin coming from a metal plater or a car wash.
Quantifying the market for segregated portable H20 Industries is not easy. Unlike the market for used cars, metal furniture, or nearly every product one can think of, there are no readily-available statistics on the market for portable DI exchange. There is overwhelming agreement that US Filter has the commanding market share of DI exchange business, opinions range from 85 to 95% majority.
According to the publisher of ULTRAPURE WATER®, (May-June 1999 volume 16, number 5) US Filter had sales of $1 billion in 1990, and has grown to $5 billion in 1999. Portable DI exchange is only a small portion of their business. Sales in Northern California of only DI portable exchange is estimated at $25 million. This has been confirmed from several sources. Firstly, one of the owners of H20 Industries is a former employee of US Filter. In 1996, their DI exchange business reached $12 million. This was only 65% of the market. Then the company acquired Culligan, adding another $8 million in portable DI exchange business in Northern California, and bringing the total to $20 million. It is assumed that sales have grown to $25 million over the past several years.
The relationship between input water and DI exchange capacity is charted. Assuming in-coming water quality of 200 parts per million of TDS in the far left column, a 3.6 cu. ft tank of regenerated resin can handle 10,800 gallons. This means that an average user with a flow rate of 10 gallons per minute would use up a 3.6 cu ft tank in 2.57 days, or 1.4 cu ft per day. Assuming the salesman was accurate in his statement of 2,000 customers, this would work out to 840,000 cu ft of regenerated portable DI exchange business per year. This figure is somewhat greater than the figure of 610,000, however, the subject of this business plan, H20 Industries, will have a productive capacity of only 140 cu ft per day, which represents between 4.5% and 6.3% of the total market in Northern California.
Taking the midpoint estimate for the total Northern California market of 780,000 cu ft annually, these high purity users would represent a market 558,000 cu ft
Hospital Dialysis Units and Stand alone Clinics:
California lists 16 stand-alone dialysis clinics, many of whom have multiple locations with varying numbers of stations. Every dialysis clinic, as least in Michigan according to BESCO, use H20 Industries for polishing, after initially running the water through a reverse osmosis system. Hospitals also have dialysis units. In addition, there is blood analysis work which is normally done using “wet” analysis equipment that requires H20 Industries. Assume this sector represents only 10% of the high purity market, or 55,000 cu ft annually.
Labs and pharmaceutical Manufacturers:
A list of labs and pharmaceutical makers in Northern California contains 330 names. A sample calling indicated that some use no pure water, others use such small qualities (10 gals/months) that they buy the water from suppliers like Hubbard-Hall, already made up. Others use so much H20 Industries that they have their own built-in DI system. The rest who have flow rate needs of between one and 20 gallons per minute are in the range most economically serviced by portable DI exchange. Assume this to represent 20% of the 558,000, or 112,000 cu ft.
Electronic Manufacturers:
Semiconductor manufacturers and other makers of electronic components need pure water to flush with. As microprocessors use wafers of ever-decreasing size, the requirements for pure water to rinse with increase, as do various other additional micro filtering. A list of electronics manufacturers in Northern California names 189 makers. Assume this sector represents 40% of 558,000, or 223,000 cu ft.
Machine Tools and Parts:
This is one of the fasting growing sectors as more and more manufacturers conform to the ISO 9000 standard, which requires delivered parts to be clean (defined as rinsed thoroughly with water of one Megohm purity or better). This category includes a need for H20 Industries in machines consuming cutting oil, any machine with cooling systems, and other uses. Assume this sector represents 30% of 558,000, or 167,000 cu ft.
This sector of the market will represent the market for DI exchange water lower than one Megohm in purity. Assume that the following industries take up the remaining 30% of the total market. Some industries that would be included in this “other” category would be:
The chart and table below summarize the total market potential for the DI exchange services in Northern California.
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Dialysis Units | 2% | 55,000 | 56,100 | 57,222 | 58,366 | 59,533 | 2.00% |
Labs and Pharmaceuticals | 5% | 112,000 | 117,600 | 123,480 | 129,654 | 136,137 | 5.00% |
Electronics Manufacturers | 0% | 223,000 | 223,000 | 223,000 | 223,000 | 223,000 | 0.00% |
Machine Tool and Parts | 7% | 167,000 | 178,690 | 191,198 | 204,582 | 218,903 | 7.00% |
Other | 10% | 222,000 | 244,200 | 268,620 | 295,482 | 325,030 | 10.00% |
Total | 5.43% | 779,000 | 819,590 | 863,520 | 911,084 | 962,603 | 5.43% |
The target markets that will receive the most attention will be the sectors which require the highest levels of pure water. This means the 70% of the market that wants quality of one Megohm or better. Within this sector, quantified as 558,000 cu ft annually, H20 Industries will emphasize those users wanting the top echelon of purity (18 Megohms).This sector of the market might be only one third of the 558,000, but even at one third (186,000), it totals more than 300% of H20 Industries’s total capacity, including its bulk portion.
One notable trend in industries is to out-source. Chief financial officers analyze the costs of producing something in-house versus the costs of farming it out. Water purification is no exception. Although many large users of H20 Industries will want to set up their own in-house capacity, the capital costs, the maintenance costs, and the costs of dealing with regenerate waste often make DI portable exchange a more economical solution. Down-sizing within a company with its own pure water manufacturing capability often will lead to a management decision to shut down their in-house plant and switch over to portable service.
Another trend is for more and more industries to need higher degrees of purity in their manufacturing process, which results in an ever-growing market for H20 Industries.
The reasoning behind the attention to the highest purity sector of the market is that H20 Industries is able to provide segregated DI exchange service. A customer’s in-coming tanks for regeneration are tagged, and after regeneration, the same resin is returned to the customer. This specialized service is a major selling feature over US Filter, who must co-mingle customers’ resin in a bulk regenerating facility. Also, bulk regeneration will not achieve the same deionization capacity as H20 Industries’s segregated method which utilizes more chemicals and longer regeneration times. A customer dealing with blood can easily be sold on segregated resin as he would not feel comfortable that his resin would be co-mingled with resin used in a totally different industry.
In addition to the feature mentioned above, H20 Industries will concentrate on those customers who place a premium on response speed and intensity of service. Again, mainly the higher quality users of H20 Industries exchange, where a shut-down would be very expensive, will demand the highest degree of quality available. Segregated exchange service from a smaller supplier is much more likely to satisfy than a huge conglomerate like US Filter where portable exchange can only be done on a bulk batching basis and represents only a small part of their overall business.
The market growth percentages used in the market analysis table were obtained from various articles appearing in ULTRAPURE WATER®, the definitive journal of high-purity water. Specific articles can be located from an index on their website, www.talloaks.com/.
The industry for providing portable H20 Industries service is dominated by one very large company–US Filter. US Filter controls between 90 to 95% of the H20 Industries service business in Northern California. The company has grown from $1 billion to over $5 billion in the past six years, primarily through an acquisition binge. The company is now finalizing its sale to Vivendi’s Generale des Eaux water subsidiary which will result in combined sales of $12 billion, making it the largest water business in the world. Originally, US Filter’s primary focus was industrial and high purity water. Its acquisitions in other areas include drinking water, waste water, municipal water, and water supply.
Now, less than 20% of its activities relate to technologies and markets connected with high purity water. A much smaller percentage is connected with H20 Industries, and a still-smaller percentage concerned with DI exchange service. After their merger, the percentage will drop even further from 20% to eight percent. This situation has resulted in a growing dissatisfaction with US Filter’s services for H20 Industries exchange. Both owners of this project have been hearing complaints from US Filter customers for quite some time. This is not just a condition evident in Northern California, other sections of the country have noticed it and competitors to US Filter’s DI exchange business have started to grow.
Users of H20 Industries have had little choice in regards to their provider. It is regenerated on a bulk basis only, with no option for segregated regenerated resin (see section on Market Segmentation). Some small customers have obtained the DI exchange service through their local Culligan man or similar water serviceman who in turn obtains it from US Filter. The fact that some small players in the market can capture some of this DI exchange business from US Filter despite a higher price ($63-$80 per cu ft versus $40 per cu ft from US Filter) is a good indication of the importance that service plays in the buying decision. Rarely does the price of H20 Industries represent a significant variable production cost in a manufacturing process. Much more of a factor is worry about quality level and service response time.
In reaction to the service complaints of customers for US Filter’s DI exchange, a couple of small competitors have sprung up in Northern California. Fluid Solutions in Lowell is one such company. This company has been supplying customers with H20 Industries exchange although they have no regeneration facilities of their own. They merely service the customers and send the tanks to a regeneration facility of another DI exchange company in Pennsylvania.
The prices charged by all local companies to regenerate are between $63 and $80 per cu ft for mixed bed. They charge $20 to $30, depending on tank size, as a monthly rental charge.
The market in Northern California is ripe for growth in competitors to US Filter which does not provide segregated regeneration and whose regenerated resin, on a bulk batch basis, will not serve as high a flow rate as non-bulk regeneration.
Industry participants are varied, as there are several means of obtaining purified water. There are companies which design and engineer reverse osmosis equipment. This equipment has a sizable share of the water market at the end close to the municipal water inlet. Reverse osmosis (R/O), in conjunction with carbon filtering and ultraviolet light, is used (for example in dialysis) to bring the TDS down to a lower level. Ion exchange, either fixed or portable, is then used to polish away the remaining impurities. Other companies may supply e-cell equipment which deionizes electrically. This technology has not advanced sufficiently to compete with traditional H20 Industries but is still occasionally sold in conjunction with a R/O system as the e-cell can only handle small levels of TDS. Some industry participants are primarily engaged in water softening and water filtration for drinking and household purposes. These companies may also utilize green sand to remove iron and magnesium hardness derived from aging municipal piping systems.
In short, there is a full range of industry participants from the local Culligan service representative mainly involved in private households, to large companies involved in engineering, design, consulting, component manufacturing, waste water treatment, etc. With respect to the narrower market for H20 Industries, there are chemical companies who supply (by the gallon) H20 Industries to very small users. There are a few small companies engaged in DI exchange service who do this only as an adjunct to their main business, such as water softening, and who only act as a distributor of DI exchange regeneration facilities located outside of Northern California.
Besides direct sales effort to large users of H20 Industries, a major element of the company’s marketing efforts will be to develop a distributor network through existing local water service companies. These companies provide local water service to small companies and homes throughout Northern California. Most of their business takes the form of water filtering, water softening, reverse osmosis maintenance, swimming pool service, etc. The best of these will be recruited to add H20 Industries service to their product line.
H20 Industries will offer segregated resin regeneration to customers wanting the highest levels of water purity. Segregated regeneration is not offered by any other company in Northern California and indications are, based on present pre-start-up sales, that users of H20 Industries are willing to pay a substantial premium for it. It represents a form of peace of mind which dialysis units, laboratories, etc. feel is important.
The second most important value proposition is service response. When H20 Industries tanks need changing customers insist on, and will receive, an immediate response.
H20 Industries’s ability to segregate a customer’s resin and return it to him regenerated to the maximum limit, should put the company in a strong competitive position.
Approximately all of H20 Industries’s business will be directed at the portable service DI market. This market emphasis should quickly be noticed by users of H20 Industries, who at present rely on US Filter. US Filter’s product range growth through acquisition and buy-outs has de-emphasized the importance of its H20 Industries exchange service.
Hence, the two major aspects of the firm’s competitive advantage would be high quality segregated resin regeneration and fast service response. It will be important to stress these advantages in the sales literature.
H20 Industries’s marketing strategy will be to execute and communicate its value proposition of service and market segmentation advantage in providing segregated regeneration of customers’ resin.
Wherever H20 Industries cannot economically sell directly, due to distance or quantities, it will utilize a network of water service companies. These companies will be carefully chosen for their quality of service. An arrangement will be set up whereby the distributor will offer DI exchange service along with its other water services. The installations can easily be handled by them. They would tag the tanks and return and pick up from the H20 Industries plant. Being able to offer this service increases the image of the local water service company. It fosters a feeling a one-stop shopping. A 33% discount off the retail price should be adequate to satisfy the distributors.
H20 Industries’s ability to regenerate resin on a segregated basis, rather than only bulk, is a capability that should provide quick and easy entry into the user market where the highest water purity is needed. These users, blood analysis, hemodialysis units, and medical laboratories for example, are especially sensitive to contamination risks. Simply pointing out to these users that bulk regeneration involves the co-mingling of their resin with resin used in the metal-finishing and car wash industries usually is quite convincing. Segregated regeneration results in the further advantage of achieving a higher DI capacity per cubic foot as greater quantities of chemicals are used during a longer regeneration period.
The second most important position statement is H20 Industries’s concentration on the DI exchange business. This concentration will force H20 Industries to provide a higher level of service, and more quickly, too. It must be remembered that the cost for H20 Industries in the market for the highest level of water purity is not a significant cost element in the overall cost structure. However, a service shutdown, for quality or for service reasons, would be very costly to high technology users of H20 Industries.
In line with the conclusions drawn in the positioning statements, H20 Industries can charge a higher price for its segregated regenerated resin. There is virtually no competition for this product in the Northern California market.
Charging $63 per cubic foot (mixed bed), as used in the sales projections, is more than a 65% increase over the price for US Filter’s bulk resin price for mixed bed. H20 Industries is currently successfully charging in excess of $70 for this product. It is essential that H20 Industries place a premium price consistent with its superior product.
Wholesale prices have been established to encourage the quick formation of a dealership network. Dealers are afforded a 33% discount.
The main focus of promotion will be two-pronged: promotion to H20 Industries end users, and promotion to wholesalers.
Promotion to wholesalers should receive primary stress due to the extended reach made possible by the wholesaler network with its existing customer base. The sales force of these wholesale distributors needs to be educated on H20 Industries’s positioning statement so that they all understand the important sales advantages of segregated resin. Being able to offer DI exchange service to a distributor’s customer list is a great advantage to the distributor, and this fact needs to be clearly spelled out to them. Therefore, the H20 Industries relationship with a dealership network is one in which both sides benefit.
H20 Industries should strive to create a small-town, friendly relationship with its customers. Company brochures will show a map with all the H20 Industries locations, including each newly acquired distributor. The distributor trucks, as well as H20 Industries vehicles, would carry the H20 Industries logo, helping all to achieve name recognition. Cost savings would result through sharing literature, leads (by territory and/or industry), co-op marketing costs, and the sharing of technical expertise.
Direct marketing to customers within easy reach of H20 Industries should stress service. As a major supplier of resin stated: “US Filter is a huge concern that closes down at 5 P.M. on Friday.” Customers for H20 Industries need to feel that they can get service after hours, and even on a Saturday if need be. These customers feel much more comfortable dealing with an exchange service that is closer in size to the customer, and where the exchange service is an important portion of total sales revenue of the supplier. Prompt deliveries, trouble-free installations, good technical advise, etc. are main building blocks of the promotion strategy.
The sales strategy is to concentrate on that segment of the market most easily captured by the following sales feature: segregated regeneration of portable resin. In addition, the fastest way to reach the sales goal for the first several years is by actively working to develop a dealership network for H20 Industries.
Sales Projections:
Sales (July 1999) are running at less than 15% capacity monthly, exclusive of rental revenue. This approximates 285 cubic ft per month. The plant capacity will be 100 cu ft per day, on a one-shift basis. Based on the potential market outlined in the Marketing Section of this plan, growth in sales of regenerated segregated resin should reach 433 cu ft per month by October (equals 20 cu ft/day) which is this plan’s starting point, and growing steadily each month until 80 cu ft per day is reached (80% capacity) by the end of the first year. Total production of segregated resin is assumed to be split into equal quantities of anion, cation, and mixed bed.
Once the 80% capacity utilization level is reached (October 2000), unit sales will grow modestly in year two and year three. This growth can be achieved within the capacity limits of 100 cu ft daily (26,000 cu ft per annum) without increases in production labor. Further increases in segregated regeneration would require overtime labor charges. Also, for the projection purposes, direct unit costs for years two and three remain at the level of year one.
The bulk regeneration pad will have a capacity of 20 cu ft and can handle two batches during an eight-hour shift, totaling 40 cu ft/day. We will assume sales for bulk regeneration will grow at the rate of 5 cu ft/day in the first month reaching capacity of 40 cu ft/day after eight months. Sales are split between mixed bed (50%), 25% anion, and 25% cation. Sales of bulk resin will grow 15% each of the first three years. As the bulk regeneration, unlike the segregated regeneration, is not labor intensive, this 15% growth can be achieved without increases in production labor.
In projecting unit prices per ten cu ft. Prices will be assumed at:
The above prices will be reduced for dealers who will deliver and pick up at the factory to:
We will assume that 50% of all sales will go through dealers, so the unit price weighted average of the retail and dealer prices will be:
Variable Unit Costs:
The costs connected with one cubic foot of segregated anion treatment involve the cost of:
Cost of replacing small amounts of lost resin.
Experience indicates that with each regeneration it is necessary to replace approximately two percent of the resin. Anion resin costs $130 per cu ft. Cost is $2.60 per cu ft of anion serviced.
Summary of Anion servicing costs:
Total for anion servicing: $10.74
The costs connected with servicing one cubic foot of segregated cation treatment involve the cost of:
Experience indicates that in the process of regeneration about 2% of the resin needs to be replaced. Cation resin costs $30 per cu ft. Cost is $.60 per cu ft of cation serviced.
Summary of Cation servicing costs:
Total: $8.78 for cation servicing.
Costs of servicing one cubic foot of mixed bed:
A mixed bed tank is more time-consuming as it requires a separation stage prior to regeneration. City water (not DI) is mixed with salt. This solution is used to bathe the anion and cation resin in a cone until the two resins separate, at which point the cation and anion are treated in the regeneration stage in the same manner as the single bed anion and cation. One mixed bed contains twice as much anion as cation. This aspect results in a weighted cost of $10.09 per cu ft Salt consumption: every cubic foot of mixed bed needs 1.5 cu ft of brine solution. There are 7.48 gallons per cu ft This comes to 11 gallons of brine needs. A 22% salt solution in this quantity of water would amount to amount two pounds. Salt is supplied by Hubbard-Hall Inc. at $.095 per pound. Adding the cost of the two pounds of salt to the weighted average cost of $10.09 comes to $10.28.
Total cost of mixed bed serving: $10.28 per cu ft.
Tank Rental Income:
Because of the high costs of purchasing tanks, many new customers opt for renting tanks on a monthly basis. For purposes of these projections we will assume that:
Tank Sales:
It is assumed that those customers who do not opt to rent their tanks will already have their own tanks or will purchase tanks from H20 Industries. Sales of tanks is assumed at only five percent of the number of monthly rental tanks. Sales price is $1,200. Cost equals $450.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Unit Sales | |||
Segregated Anion Service 10 cu ft | 445 | 728 | 764 |
Segregated Cation Service 10 cu ft | 445 | 728 | 764 |
Segregated Mixed Bed 10 cu ft | 445 | 728 | 764 |
Bulk Regen 10 cu ft (MB) | 367 | 598 | 687 |
Bulk Regen 10 cu ft (Cat) | 183 | 299 | 344 |
Bulk Regen 10 cu ft (An) | 183 | 299 | 344 |
Tank Rentals (each 3.6 cu ft): | 1,436 | 2,347 | 2,546 |
Tank Sales: | 67 | 117 | 127 |
Other | 0 | 0 | 0 |
Total Unit Sales | 3,572 | 5,844 | 6,340 |
Unit Prices | Year 1 | Year 2 | Year 3 |
Segregated Anion Service 10 cu ft | $476.00 | $476.00 | $476.00 |
Segregated Cation Service 10 cu ft | $476.00 | $476.00 | $476.00 |
Segregated Mixed Bed 10 cu ft | $526.00 | $526.00 | $526.00 |
Bulk Regen 10 cu ft (MB) | $359.00 | $359.00 | $359.00 |
Bulk Regen 10 cu ft (Cat) | $267.50 | $267.50 | $267.50 |
Bulk Regen 10 cu ft (An) | $267.50 | $267.50 | $267.50 |
Tank Rentals (each 3.6 cu ft): | $40.00 | $40.00 | $40.00 |
Tank Sales: | $1,200.00 | $1,200.00 | $1,200.00 |
Other | $0.00 | $0.00 | $0.00 |
Sales | |||
Segregated Anion Service 10 cu ft | $211,820 | $346,528 | $363,664 |
Segregated Cation Service 10 cu ft | $211,820 | $346,528 | $363,664 |
Segregated Mixed Bed 10 cu ft | $234,070 | $382,928 | $401,864 |
Bulk Regen 10 cu ft (MB) | $131,753 | $214,682 | $246,633 |
Bulk Regen 10 cu ft (Cat) | $49,080 | $79,983 | $92,020 |
Bulk Regen 10 cu ft (An) | $49,080 | $79,983 | $92,020 |
Tank Rentals (each 3.6 cu ft): | $57,440 | $93,880 | $101,840 |
Tank Sales: | $80,400 | $140,400 | $152,400 |
Other | $0 | $0 | $0 |
Total Sales | $1,025,462 | $1,684,911 | $1,814,105 |
Direct Unit Costs | Year 1 | Year 2 | Year 3 |
Segregated Anion Service 10 cu ft | $107.40 | $107.40 | $107.40 |
Segregated Cation Service 10 cu ft | $87.80 | $87.80 | $87.80 |
Segregated Mixed Bed 10 cu ft | $102.80 | $102.80 | $102.80 |
Bulk Regen 10 cu ft (MB) | $61.40 | $61.40 | $61.40 |
Bulk Regen 10 cu ft (Cat) | $69.50 | $69.50 | $69.50 |
Bulk Regen 10 cu ft (An) | $72.50 | $72.50 | $72.50 |
Tank Rentals (each 3.6 cu ft): | $0.00 | $0.00 | $0.00 |
Tank Sales: | $450.00 | $450.00 | $450.00 |
Other | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||
Segregated Anion Service 10 cu ft | $47,793 | $78,187 | $82,054 |
Segregated Cation Service 10 cu ft | $39,071 | $63,918 | $67,079 |
Segregated Mixed Bed 10 cu ft | $45,746 | $74,838 | $78,539 |
Bulk Regen 10 cu ft (MB) | $22,534 | $36,717 | $42,182 |
Bulk Regen 10 cu ft (Cat) | $12,752 | $20,781 | $23,908 |
Bulk Regen 10 cu ft (An) | $13,302 | $21,678 | $24,940 |
Tank Rentals (each 3.6 cu ft): | $0 | $0 | $0 |
Tank Sales: | $30,150 | $52,650 | $57,150 |
Other | $0 | $0 | $0 |
Subtotal Direct Cost of Sales | $211,347 | $348,769 | $375,852 |
The relationship between dealerships and H20 Industries could be called a strategic alliance. These water service companies have an extensive customer base. Most of the customers have needs such as water softening, filtration, reverse osmosis maintenance, swimming pool maintenance, etc., however, many dealership customers have H20 Industries needs as well. At present, these water service companies must direct their customers to US Filter or supply the customer through US Filter. Forming a relationship between H20 Industries and these dealerships would quickly result in substantial sales increases for H20 Industries and would result in increased prestige and profits for the dealerships.
The management of H20 Industries is made up of individual shareholders with extensive expertise in the water treatment industry, as well as commercial and financial background.
The management team is uniquely qualified to implement this business plan. The founders, John Jones and Dave Smith, have been active in the water treatment industry for years. John’s experience working with dealers in application engineering and sales has prepared him well to present the H20 Industries dealership to water service companies that he already knows. His years of calling on dealerships in all aspects of the water industry have allowed him a birds-eye view of the prevailing marketing and business practices.
Dave has been involved in the manufacturing sector of the water industry and is well respected and connected there. His training and certification as a Professional Engineer give him an advantage when consulting with customers and prospective customers.
The person planned for the position of general manager has wide-ranging experience in finance and manufacturing. He is a former vice president of Chase Manhattan Bank, team leader of a development bank (Saudi Industrial Development Fund), and founder/general manager of a factory which, after 10 years of profitable operations, was bought out in 1989.
The production manager is a chemical engineer by education and professional experience, and has demonstrated his know-how by successfully managing the production activity in the factory despite the challenges presented by the present incomplete production line.
Regeneration Personnel : A production manager must be a skilled chemical engineer with experience in water treatment applications. This person must be a hands-on individual supervising two assistants. The production manager will label the tanks as they are received to assure customer segregation and supervise the proper regeneration cycle, from separation through backwash, draw, flush, mix, and testing. The assistants will primarily be kept busy moving tanks from one stage in the regeneration cycle to the next, connecting the hosing, performing the chemical mix and draw according to the instructions of the production manager, adding salt to the brine tank, etc. The production manager is in place. One assistant is now in place. A second is needed.
An engineer/fitter is also needed to maintain the equipment and to make installations. This person is in place.
Sales and Marketing Personnel : It is planned that both owners will continue to maintain their present positions. These sales positions require them to move about the territory which provides an excellent source of knowledge of customers for H20 Industries. This information will be communicated to the sales and marketing manager who will spend his time calling and visiting potential H20 Industries users. He will be paid a base salary plus commissions. The commission will be higher for landing a new customer, and lower for repeat sales. The commission schedule will be constructed in such a way as to permit an annual total compensation that will encourage excellent sales results.
General and Administrative : An office manager is needed. Answering phones, primary contact with customers, incoming and outgoing mail, etc. He will be the main connection between the owners and the operations of the facility. Within six months, a part-time assistant will need to be added to keep pace with bookkeeping and management.
Delivery Personnel : One driver, who has additional responsibilities, is now in place. A second will need to be added after approximately four months.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Production Personnel | |||
Production Manager | $41,604 | $41,600 | $41,600 |
Assistant | $20,796 | $20,800 | $20,800 |
Assistant | $20,796 | $20,800 | $20,800 |
Engineer/fitter | $31,200 | $31,200 | $31,200 |
Drivers | $54,198 | $58,400 | $58,400 |
Other | $0 | $0 | $0 |
Subtotal | $168,594 | $172,800 | $172,800 |
Sales and Marketing Personnel | |||
Sales Manager (base) | $24,000 | $24,000 | $24,000 |
Sales Manager (commissions) | $38,660 | $51,000 | $60,000 |
Name or title | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Subtotal | $62,660 | $75,000 | $84,000 |
General and Administrative Personnel | |||
Office Manager | $39,996 | $40,000 | $40,000 |
Bookkeeper (part-time) | $9,100 | $15,600 | $15,600 |
Name or title | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Subtotal | $49,096 | $55,600 | $55,600 |
Other Personnel | |||
Name or Title | $0 | $0 | $0 |
Name or title | $0 | $0 | $0 |
Name or title | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Subtotal | $0 | $0 | $0 |
Total People | 9 | 9 | 9 |
Total Payroll | $280,350 | $303,400 | $312,400 |
As of August 1999, stockholder equity stood at $112,000. Additional infusion of equity from new shareholders will boost the equity capital.
To complete the necessary planned additions to plant and equipment, a 5-year term loan will be required from a financial institution. The projected cash-flow is sufficient to repay this loan in quarterly installments. This term loan should be sufficient to cover the increases in accounts receivable, as well as to support growth in inventory of rental tanks.
Tax rate reflects the present sliding scale:
Inventory Turnover:
Since this is a service business, the only inventory is that of chemicals and some resin, both of which do not need to be stored more than two weeks. Average is one week (inventory turnover rate of 48).
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | 1 | 2 | 3 |
Current Interest Rate | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% |
Tax Rate | 2.50% | 0.00% | 2.50% |
Other | 0 | 0 | 0 |
The following table and chart show the Monthly Units and Monthly Revenue Break-even calculations based on the Average Per-Unit Revenue, Average Per-Unit Variable Costs and the Estimated Monthly Fixed Costs, as drawn from the other financial tables in this plan.
Break-even Analysis | |
Monthly Units Break-even | 119 |
Monthly Revenue Break-even | $34,235 |
Assumptions: | |
Average Per-Unit Revenue | $287.08 |
Average Per-Unit Variable Cost | $59.17 |
Estimated Monthly Fixed Cost | $27,179 |
The following table and charts give the yearly projected profit and loss statement for H20 Industries. For a monthly analysis, please see attached appendix.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $1,025,462 | $1,684,911 | $1,814,105 |
Direct Cost of Sales | $211,347 | $348,769 | $375,852 |
Production Payroll | $168,594 | $172,800 | $172,800 |
Other | $0 | $0 | $0 |
Total Cost of Sales | $379,941 | $521,569 | $548,652 |
Gross Margin | $645,521 | $1,163,342 | $1,265,453 |
Gross Margin % | 62.95% | 69.04% | 69.76% |
Operating Expenses | |||
Sales and Marketing Expenses | |||
Sales and Marketing Payroll | $62,660 | $75,000 | $84,000 |
Advertising/Promotion | $16,500 | $12,000 | $12,000 |
Travel | $3,600 | $6,000 | $6,000 |
Fuel/oil for Vehicles: | $11,520 | $12,000 | $12,500 |
Vehicle Repair: | $20,004 | $20,000 | $20,000 |
Uniforms | $1,200 | $1,200 | $1,200 |
Miscellaneous | $10,800 | $10,800 | $10,800 |
Total Sales and Marketing Expenses | $126,284 | $137,000 | $146,500 |
Sales and Marketing % | 12.31% | 8.13% | 8.08% |
General and Administrative Expenses | |||
General and Administrative Payroll | $49,096 | $55,600 | $55,600 |
Sales and Marketing and Other Expenses | $0 | $0 | $0 |
Depreciation | $36,000 | $36,000 | $36,000 |
Leased Equipment | $15,252 | $15,252 | $15,252 |
Utilities | $2,250 | $2,250 | $2,250 |
Insurance | $11,796 | $11,800 | $11,800 |
Business Liab. Insurance: | $12,000 | $12,000 | $12,000 |
Printing and Postage: | $3,600 | $3,600 | $3,600 |
Telephone Expenses: | $8,004 | $8,000 | $8,000 |
Auditing: | $2,400 | $2,400 | $2,400 |
Rent | $24,000 | $24,000 | $24,000 |
Payroll Taxes | $35,464 | $38,380 | $39,519 |
Other General and Administrative Expenses | $0 | $0 | $0 |
Total General and Administrative Expenses | $199,862 | $209,282 | $210,421 |
General and Administrative % | 19.49% | 12.42% | 11.60% |
Other Expenses: | |||
Other Payroll | $0 | $0 | $0 |
Consultants | $0 | $0 | $0 |
Contract/Consultants | $0 | $0 | $0 |
Total Other Expenses | $0 | $0 | $0 |
Other % | 0.00% | 0.00% | 0.00% |
Total Operating Expenses | $326,146 | $346,282 | $356,921 |
Profit Before Interest and Taxes | $319,375 | $817,060 | $908,533 |
EBITDA | $355,375 | $853,060 | $944,533 |
Interest Expense | $19,755 | $12,323 | $9,948 |
Taxes Incurred | ($4,643) | $0 | $22,465 |
Net Profit | $304,263 | $804,737 | $876,120 |
Net Profit/Sales | 29.67% | 47.76% | 48.29% |
Cash Flow is an intrinsic projection for H20 Industries. We must maintain a suitable cash balance in the bank in order to be successful. The chart and table below outline our basic cash flow assumptions.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $0 | $0 | $0 |
Cash from Receivables | $774,831 | $1,523,736 | $1,782,529 |
Subtotal Cash from Operations | $774,831 | $1,523,736 | $1,782,529 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $50,000 | $6,250 | $6,250 |
New Other Liabilities (interest-free) | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $0 | $0 |
Sales of Other Current Assets | $50,000 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $0 |
New Investment Received | $0 | $0 | $0 |
Subtotal Cash Received | $874,831 | $1,529,986 | $1,788,779 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $280,350 | $303,400 | $312,400 |
Bill Payments | $439,684 | $559,027 | $590,514 |
Subtotal Spent on Operations | $720,034 | $862,427 | $902,914 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $56,252 | $0 | $0 |
Other Liabilities Principal Repayment | $16,810 | $0 | $0 |
Long-term Liabilities Principal Repayment | $60,000 | $30,000 | $30,000 |
Purchase Other Current Assets | $63,450 | $10,350 | $9,450 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $916,546 | $902,777 | $942,364 |
Net Cash Flow | ($41,715) | $627,209 | $846,415 |
Cash Balance | $82,508 | $709,717 | $1,556,132 |
The projected balance sheet for H20 Industries is presented below.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $82,508 | $709,717 | $1,556,132 |
Accounts Receivable | $250,631 | $411,806 | $443,382 |
Inventory | $28,886 | $47,669 | $51,370 |
Other Current Assets | $103,450 | $113,800 | $123,250 |
Total Current Assets | $465,476 | $1,282,992 | $2,174,135 |
Long-term Assets | |||
Long-term Assets | $220,000 | $220,000 | $220,000 |
Accumulated Depreciation | $36,000 | $72,000 | $108,000 |
Total Long-term Assets | $184,000 | $148,000 | $112,000 |
Total Assets | $649,476 | $1,430,992 | $2,286,135 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $45,461 | $45,991 | $48,763 |
Current Borrowing | $15,102 | $21,352 | $27,602 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $60,563 | $67,343 | $76,365 |
Long-term Liabilities | $120,000 | $90,000 | $60,000 |
Total Liabilities | $180,563 | $157,343 | $136,365 |
Paid-in Capital | $187,000 | $187,000 | $187,000 |
Retained Earnings | ($22,350) | $281,913 | $1,086,650 |
Earnings | $304,263 | $804,737 | $876,120 |
Total Capital | $468,913 | $1,273,650 | $2,149,770 |
Total Liabilities and Capital | $649,476 | $1,430,992 | $2,286,135 |
Net Worth | $468,913 | $1,273,650 | $2,149,770 |
The following table gives standard business ratios for the water treatment equipment manufacturer industry, as determined by the Standard Industry Classification (SIC) Index code 3589. The last column, Industry Profile, presents specific information and important ratios for this industry.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 64.31% | 7.67% | 8.10% |
Percent of Total Assets | ||||
Accounts Receivable | 38.59% | 28.78% | 19.39% | 25.10% |
Inventory | 4.45% | 3.33% | 2.25% | 21.60% |
Other Current Assets | 15.93% | 7.95% | 5.39% | 25.80% |
Total Current Assets | 71.67% | 89.66% | 95.10% | 72.50% |
Long-term Assets | 28.33% | 10.34% | 4.90% | 27.50% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 9.32% | 4.71% | 3.34% | 35.50% |
Long-term Liabilities | 18.48% | 6.29% | 2.62% | 21.30% |
Total Liabilities | 27.80% | 11.00% | 5.96% | 56.80% |
Net Worth | 72.20% | 89.00% | 94.04% | 43.20% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 62.95% | 69.04% | 69.76% | 32.10% |
Selling, General & Administrative Expenses | 33.28% | 21.28% | 20.22% | 17.80% |
Advertising Expenses | 1.61% | 0.71% | 0.66% | 0.90% |
Profit Before Interest and Taxes | 31.14% | 48.49% | 50.08% | 3.40% |
Main Ratios | ||||
Current | 7.69 | 19.05 | 28.47 | 2.12 |
Quick | 7.21 | 18.34 | 27.80 | 1.20 |
Total Debt to Total Assets | 27.80% | 11.00% | 5.96% | 56.80% |
Pre-tax Return on Net Worth | 63.90% | 63.18% | 41.80% | 4.50% |
Pre-tax Return on Assets | 46.13% | 56.24% | 39.31% | 10.40% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | 29.67% | 47.76% | 48.29% | n.a |
Return on Equity | 64.89% | 63.18% | 40.75% | n.a |
Activity Ratios | ||||
Accounts Receivable Turnover | 4.09 | 4.09 | 4.09 | n.a |
Collection Days | 56 | 72 | 86 | n.a |
Inventory Turnover | 10.91 | 9.11 | 7.59 | n.a |
Accounts Payable Turnover | 9.32 | 12.17 | 12.17 | n.a |
Payment Days | 31 | 30 | 29 | n.a |
Total Asset Turnover | 1.58 | 1.18 | 0.79 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.39 | 0.12 | 0.06 | n.a |
Current Liab. to Liab. | 0.34 | 0.43 | 0.56 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $404,913 | $1,215,650 | $2,097,770 | n.a |
Interest Coverage | 16.17 | 66.31 | 91.33 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.63 | 0.85 | 1.26 | n.a |
Current Debt/Total Assets | 9% | 5% | 3% | n.a |
Acid Test | 3.07 | 12.23 | 21.99 | n.a |
Sales/Net Worth | 2.19 | 1.32 | 0.84 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Unit Sales | |||||||||||||
Segregated Anion Service 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Segregated Cation Service 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Segregated Mixed Bed 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Bulk Regen 10 cu ft (MB) | 0% | 5 | 11 | 16 | 22 | 26 | 33 | 38 | 43 | 43 | 43 | 43 | 43 |
Bulk Regen 10 cu ft (Cat) | 0% | 3 | 5 | 8 | 11 | 13 | 16 | 19 | 22 | 22 | 22 | 22 | 22 |
Bulk Regen 10 cu ft (An) | 0% | 3 | 5 | 8 | 11 | 13 | 16 | 19 | 22 | 22 | 22 | 22 | 22 |
Tank Rentals (each 3.6 cu ft): | 0% | 37 | 54 | 70 | 86 | 101 | 118 | 135 | 151 | 160 | 168 | 178 | 178 |
Tank Sales: | 0% | 2 | 2 | 3 | 4 | 5 | 5 | 7 | 7 | 8 | 8 | 8 | 8 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 92 | 133 | 174 | 214 | 251 | 294 | 336 | 376 | 398 | 419 | 442 | 443 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Segregated Anion Service 10 cu ft | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | |
Segregated Cation Service 10 cu ft | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | |
Segregated Mixed Bed 10 cu ft | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | |
Bulk Regen 10 cu ft (MB) | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | |
Bulk Regen 10 cu ft (Cat) | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | |
Bulk Regen 10 cu ft (An) | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | |
Tank Rentals (each 3.6 cu ft): | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | |
Tank Sales: | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||||||||
Segregated Anion Service 10 cu ft | $6,807 | $8,806 | $10,805 | $12,804 | $14,804 | $16,803 | $18,802 | $20,801 | $22,800 | $24,800 | $26,799 | $26,989 | |
Segregated Cation Service 10 cu ft | $6,807 | $8,806 | $10,805 | $12,804 | $14,804 | $16,803 | $18,802 | $20,801 | $22,800 | $24,800 | $26,799 | $26,989 | |
Segregated Mixed Bed 10 cu ft | $7,364 | $9,731 | $11,940 | $14,149 | $16,359 | $18,568 | $20,777 | $22,986 | $25,195 | $27,405 | $29,614 | $29,982 | |
Bulk Regen 10 cu ft (MB) | $1,939 | $3,877 | $5,834 | $7,772 | $9,334 | $11,668 | $13,606 | $15,545 | $15,545 | $15,545 | $15,545 | $15,545 | |
Bulk Regen 10 cu ft (Cat) | $722 | $1,445 | $2,173 | $2,889 | $3,478 | $4,347 | $5,069 | $5,791 | $5,791 | $5,791 | $5,791 | $5,791 | |
Bulk Regen 10 cu ft (An) | $722 | $1,445 | $2,173 | $2,889 | $3,478 | $4,347 | $5,069 | $5,791 | $5,791 | $5,791 | $5,791 | $5,791 | |
Tank Rentals (each 3.6 cu ft): | $1,480 | $2,160 | $2,800 | $3,440 | $4,040 | $4,720 | $5,400 | $6,040 | $6,400 | $6,720 | $7,120 | $7,120 | |
Tank Sales: | $2,400 | $2,400 | $3,600 | $4,800 | $6,000 | $6,000 | $8,400 | $8,400 | $9,600 | $9,600 | $9,600 | $9,600 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $28,241 | $38,669 | $50,131 | $61,549 | $72,295 | $83,255 | $95,925 | $106,156 | $113,924 | $120,451 | $127,059 | $127,808 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Segregated Anion Service 10 cu ft | 0.00% | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 |
Segregated Cation Service 10 cu ft | 0.00% | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 |
Segregated Mixed Bed 10 cu ft | 0.00% | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 |
Bulk Regen 10 cu ft (MB) | 0.00% | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 |
Bulk Regen 10 cu ft (Cat) | 0.00% | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 |
Bulk Regen 10 cu ft (An) | 0.00% | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 |
Tank Rentals (each 3.6 cu ft): | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Tank Sales: | 0.00% | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 |
Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Segregated Anion Service 10 cu ft | $1,536 | $1,987 | $2,438 | $2,889 | $3,340 | $3,791 | $4,242 | $4,693 | $5,144 | $5,596 | $6,047 | $6,090 | |
Segregated Cation Service 10 cu ft | $1,256 | $1,624 | $1,993 | $2,362 | $2,731 | $3,099 | $3,468 | $3,837 | $4,206 | $4,574 | $4,943 | $4,978 | |
Segregated Mixed Bed 10 cu ft | $1,439 | $1,902 | $2,334 | $2,765 | $3,197 | $3,629 | $4,061 | $4,492 | $4,924 | $5,356 | $5,788 | $5,860 | |
Bulk Regen 10 cu ft (MB) | $332 | $663 | $998 | $1,329 | $1,596 | $1,996 | $2,327 | $2,659 | $2,659 | $2,659 | $2,659 | $2,659 | |
Bulk Regen 10 cu ft (Cat) | $188 | $375 | $565 | $751 | $904 | $1,129 | $1,317 | $1,505 | $1,505 | $1,505 | $1,505 | $1,505 | |
Bulk Regen 10 cu ft (An) | $196 | $392 | $589 | $783 | $943 | $1,178 | $1,374 | $1,570 | $1,570 | $1,570 | $1,570 | $1,570 | |
Tank Rentals (each 3.6 cu ft): | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Tank Sales: | $900 | $900 | $1,350 | $1,800 | $2,250 | $2,250 | $3,150 | $3,150 | $3,600 | $3,600 | $3,600 | $3,600 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $5,846 | $7,843 | $10,266 | $12,679 | $14,960 | $17,072 | $19,939 | $21,906 | $23,607 | $24,859 | $26,110 | $26,260 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Production Personnel | |||||||||||||
Production Manager | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | |
Assistant | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | |
Assistant | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | |
Engineer/fitter | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | |
Drivers | $3,467 | $3,466 | $3,467 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $13,000 | $12,999 | $13,000 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | |
Sales and Marketing Personnel | |||||||||||||
Sales Manager (base) | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales Manager (commissions) | $960 | $1,500 | $2,000 | $2,500 | $3,000 | $3,700 | $3,850 | $3,950 | $4,100 | $4,250 | $4,350 | $4,500 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $2,960 | $3,500 | $4,000 | $4,500 | $5,000 | $5,700 | $5,850 | $5,950 | $6,100 | $6,250 | $6,350 | $6,500 | |
General and Administrative Personnel | |||||||||||||
Office Manager | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
Bookkeeper (part-time) | $0 | $0 | $0 | $0 | $0 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | |
Other Personnel | |||||||||||||
Name or Title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total People | 7 | 7 | 7 | 7 | 8 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
Total Payroll | $19,293 | $19,832 | $20,333 | $22,232 | $22,733 | $24,732 | $24,883 | $24,982 | $25,133 | $25,282 | $25,383 | $25,532 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $28,241 | $38,669 | $50,131 | $61,549 | $72,295 | $83,255 | $95,925 | $106,156 | $113,924 | $120,451 | $127,059 | $127,808 | |
Direct Cost of Sales | $5,846 | $7,843 | $10,266 | $12,679 | $14,960 | $17,072 | $19,939 | $21,906 | $23,607 | $24,859 | $26,110 | $26,260 | |
Production Payroll | $13,000 | $12,999 | $13,000 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $18,846 | $20,842 | $23,266 | $27,078 | $29,360 | $31,471 | $34,339 | $36,305 | $38,007 | $39,258 | $40,510 | $40,659 | |
Gross Margin | $9,395 | $17,827 | $26,865 | $34,470 | $42,935 | $51,783 | $61,586 | $69,852 | $75,917 | $81,194 | $86,549 | $87,148 | |
Gross Margin % | 33.27% | 46.10% | 53.59% | 56.01% | 59.39% | 62.20% | 64.20% | 65.80% | 66.64% | 67.41% | 68.12% | 68.19% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $2,960 | $3,500 | $4,000 | $4,500 | $5,000 | $5,700 | $5,850 | $5,950 | $6,100 | $6,250 | $6,350 | $6,500 | |
Advertising/Promotion | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Travel | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Fuel/oil for Vehicles: | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Vehicle Repair: | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Uniforms | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Miscellaneous | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Total Sales and Marketing Expenses | $8,787 | $9,327 | $9,827 | $10,327 | $10,827 | $10,627 | $10,777 | $10,877 | $11,027 | $11,177 | $11,277 | $11,427 | |
Sales and Marketing % | 31.11% | 24.12% | 19.60% | 16.78% | 14.98% | 12.76% | 11.23% | 10.25% | 9.68% | 9.28% | 8.88% | 8.94% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Leased Equipment | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | |
Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | |
Business Liab. Insurance: | $0 | $0 | $0 | $0 | $0 | $6,000 | $0 | $0 | $0 | $0 | $0 | $6,000 | |
Printing and Postage: | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Telephone Expenses: | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | |
Auditing: | $0 | $0 | $0 | $2,400 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Payroll Taxes | 13% | $2,441 | $2,509 | $2,572 | $2,812 | $2,876 | $3,129 | $3,148 | $3,160 | $3,179 | $3,198 | $3,211 | $3,230 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $14,245 | $14,313 | $14,376 | $17,016 | $14,680 | $22,233 | $16,252 | $16,114 | $16,133 | $16,152 | $16,165 | $22,184 | |
General and Administrative % | 50.44% | 37.01% | 28.68% | 27.65% | 20.31% | 26.70% | 16.94% | 15.18% | 14.16% | 13.41% | 12.72% | 17.36% | |
Other Expenses: | |||||||||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Total Operating Expenses | $23,032 | $23,640 | $24,203 | $27,343 | $25,507 | $32,860 | $27,029 | $26,991 | $27,160 | $27,329 | $27,442 | $33,611 | |
Profit Before Interest and Taxes | ($13,636) | ($5,812) | $2,662 | $7,127 | $17,428 | $18,924 | $34,558 | $42,860 | $48,756 | $53,864 | $59,107 | $53,538 | |
EBITDA | ($10,636) | ($2,812) | $5,662 | $10,127 | $20,428 | $21,924 | $37,558 | $45,860 | $51,756 | $56,864 | $62,107 | $56,538 | |
Interest Expense | $1,840 | $1,773 | $1,769 | $1,765 | $1,698 | $1,694 | $1,689 | $1,622 | $1,618 | $1,614 | $1,547 | $1,126 | |
Taxes Incurred | ($4,643) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($10,834) | ($7,586) | $893 | $5,362 | $15,730 | $17,230 | $32,868 | $41,238 | $47,138 | $52,251 | $57,560 | $52,412 | |
Net Profit/Sales | -38.36% | -19.62% | 1.78% | 8.71% | 21.76% | 20.70% | 34.26% | 38.85% | 41.38% | 43.38% | 45.30% | 41.01% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Subtotal Cash from Operations | $0 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $50,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $50,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $100,000 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $19,293 | $19,832 | $20,333 | $22,232 | $22,733 | $24,732 | $24,883 | $24,982 | $25,133 | $25,282 | $25,383 | $25,532 | |
Bill Payments | $61,849 | $13,625 | $25,719 | $28,739 | $33,600 | $33,584 | $40,540 | $38,353 | $39,147 | $40,550 | $41,335 | $42,644 | |
Subtotal Spent on Operations | $81,142 | $33,457 | $46,052 | $50,971 | $56,333 | $58,316 | $65,423 | $63,335 | $64,280 | $65,832 | $66,718 | $68,176 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $50,521 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $16,810 | |
Long-term Liabilities Principal Repayment | $30,000 | $7,500 | $0 | $0 | $7,500 | $0 | $0 | $7,500 | $0 | $0 | $7,500 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $5,400 | $8,550 | $9,900 | $9,900 | $9,450 | $5,400 | $4,500 | $10,350 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $111,663 | $41,478 | $46,573 | $56,892 | $72,904 | $68,737 | $75,844 | $80,806 | $70,201 | $70,853 | $85,089 | $135,507 | |
Net Cash Flow | ($11,663) | ($40,537) | ($17,984) | ($17,840) | ($22,392) | ($6,830) | ($3,184) | $2,871 | $26,066 | $35,562 | $29,052 | ($14,836) | |
Cash Balance | $112,560 | $72,023 | $54,039 | $36,198 | $13,806 | $6,977 | $3,793 | $6,664 | $32,730 | $68,292 | $97,344 | $82,508 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $124,223 | $112,560 | $72,023 | $54,039 | $36,198 | $13,806 | $6,977 | $3,793 | $6,664 | $32,730 | $68,292 | $97,344 | $82,508 |
Accounts Receivable | $0 | $28,241 | $65,969 | $87,511 | $110,009 | $131,792 | $153,140 | $176,405 | $198,884 | $216,541 | $230,577 | $243,495 | $250,631 |
Inventory | $10,000 | $6,430 | $8,627 | $11,293 | $13,947 | $16,456 | $18,780 | $21,933 | $24,096 | $25,968 | $27,345 | $28,721 | $28,886 |
Other Current Assets | $90,000 | $40,000 | $40,000 | $40,000 | $45,400 | $53,950 | $63,850 | $73,750 | $83,200 | $88,600 | $93,100 | $103,450 | $103,450 |
Total Current Assets | $224,223 | $187,230 | $186,619 | $192,843 | $205,554 | $216,004 | $242,746 | $275,881 | $312,844 | $363,839 | $419,314 | $473,010 | $465,476 |
Long-term Assets | |||||||||||||
Long-term Assets | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 |
Accumulated Depreciation | $0 | $3,000 | $6,000 | $9,000 | $12,000 | $15,000 | $18,000 | $21,000 | $24,000 | $27,000 | $30,000 | $33,000 | $36,000 |
Total Long-term Assets | $220,000 | $217,000 | $214,000 | $211,000 | $208,000 | $205,000 | $202,000 | $199,000 | $196,000 | $193,000 | $190,000 | $187,000 | $184,000 |
Total Assets | $444,223 | $404,230 | $400,619 | $403,843 | $413,554 | $421,004 | $444,746 | $474,881 | $508,844 | $556,839 | $609,314 | $660,010 | $649,476 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $61,409 | $12,771 | $24,766 | $27,618 | $32,488 | $32,230 | $39,262 | $37,050 | $37,796 | $39,173 | $39,919 | $41,076 | $45,461 |
Current Borrowing | $21,354 | $70,833 | $70,312 | $69,791 | $69,270 | $68,749 | $68,228 | $67,707 | $67,186 | $66,665 | $66,144 | $65,623 | $15,102 |
Other Current Liabilities | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $0 |
Subtotal Current Liabilities | $99,573 | $100,414 | $111,888 | $114,219 | $118,568 | $117,789 | $124,300 | $121,567 | $121,792 | $122,648 | $122,873 | $123,509 | $60,563 |
Long-term Liabilities | $180,000 | $150,000 | $142,500 | $142,500 | $142,500 | $135,000 | $135,000 | $135,000 | $127,500 | $127,500 | $127,500 | $120,000 | $120,000 |
Total Liabilities | $279,573 | $250,414 | $254,388 | $256,719 | $261,068 | $252,789 | $259,300 | $256,567 | $249,292 | $250,148 | $250,373 | $243,509 | $180,563 |
Paid-in Capital | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 |
Retained Earnings | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) |
Earnings | $0 | ($10,834) | ($18,420) | ($17,527) | ($12,164) | $3,566 | $20,796 | $53,664 | $94,902 | $142,040 | $194,291 | $251,851 | $304,263 |
Total Capital | $164,650 | $153,816 | $146,230 | $147,123 | $152,486 | $168,216 | $185,446 | $218,314 | $259,552 | $306,690 | $358,941 | $416,501 | $468,913 |
Total Liabilities and Capital | $444,223 | $404,230 | $400,619 | $403,843 | $413,554 | $421,004 | $444,746 | $474,881 | $508,844 | $556,839 | $609,314 | $660,010 | $649,476 |
Net Worth | $164,650 | $153,816 | $146,230 | $147,123 | $152,486 | $168,216 | $185,446 | $218,314 | $259,552 | $306,690 | $358,941 | $416,501 | $468,913 |
Fill-in-the-blanks and automatic financials make it easy.
No thanks, I prefer writing 40-page documents.
Discover the world’s #1 plan building software
Intel considers splitting off foundry business, scrapping factory plans- Bloomberg
Investing.com-- Intel Corporation (NASDAQ:INTC) shares rose 8% Friday after it was reported the company is considering options to weather a historic slump, which include potentially splitting off its foundry business and scrapping plans for new factories, Bloomberg reported on Thursday.
The chipmaker is in talks with investment bankers over potential options and has met with Goldman Sachs Group Inc (NYSE:GS) and Morgan Stanley (NYSE:MS) over a path forward, Bloomberg reported, citing people with knowledge of the matter.
Intel had earlier in August suspended its dividend and slashed about 15% of its workforce as it struggled to catch up with rivals in the foundry space, chiefly Taiwan's TSMC (NYSE:TSM).
Once the world's leading chipmaker, Intel fell on hard times in the 2000's, amid increased competition from rivals such as Advanced Micro Devices Inc (NASDAQ:AMD), and as it struggled to keep pace with demands from the smartphone and mobile computing industry.
Apple Inc's (NASDAQ:AAPL) decision to develop its own silicon and stop using Intel chips was also a major blow to the chipmaker.
Intel's challenges came to a head in recent years, with NVIDIA Corporation's (NASDAQ:NVDA) dominance in artificial intelligence further cutting Intel's sales.
The Bloomberg report showed that Intel was now considering separating its product design and foundry business, while also scrapping plans for expansion as it seeks to streamline its operations.
The company could not be immediately reached for comment.
Related Articles
RTX to pay $200 million fine for export mistakes, State Department says
Wells Fargo analyst cuts target on Prospect Capital one day after berating by CEO
Wednesday 28th August 2024 11:30
Thames Water Utilities Limited has today submitted its response to Ofwat’s draft determination for 2025 to 2030, as part of Price Review 2024 (PR24). Link here.
Chris Weston, CEO Thames Water, said:
“We have proposed a highly ambitious business plan for 2025-2030 based on customers’ feedback and insight. Our customers told us to focus on delivering safe and resilient water supplies, and address concerns over our overall performance including on customer service and dealing with wastewater.
“On the basis of the draft determination given to us by Ofwat, both our own and independent analysis shows that our plan would be neither financeable nor investible and therefore not deliverable. It would also prevent the turnaround and recovery of the company.
“We have listened carefully to Ofwat’s feedback and have responded constructively to address the issues raised, updating our plan to reflect stretching goals, while offering changes that would give us the opportunity to secure the necessary investment so that our ambitious plan can be delivered for our customers and the environment.
“We want to deliver a considerable increase in investment in our infrastructure, with total expenditure of £20.7bn in our core plan and a further £3bn through gated mechanisms.
“Over the last three regulatory periods we are forecast to spend over £2.7billion more than our allowances. Structural underfunding has led to significant asset health challenges alongside a substantial increase in the group’s leverage.
“The money we’re asking for from customers will be invested in new infrastructure and improving our services for the benefit of households and the environment. They are not being asked to pay twice, but to make up for years of focus on keeping bills low. In parallel, we are increasing our support to bill payers by introducing an improved social tariff for those struggling to pay, increasing by nearly 70% the number of those who will benefit from this support, to 647,000 households.
“Despite our near-term financial resilience challenges, our essential services continue. We will continue to deliver 2.6 billion litres of water and remove 5.1 billion litres of wastewater for our 16 million customers each day including in one of the most congested and costly cities in the world.”
Sir Adrian Montague, Chairman of Thames Water said: “Thames Water’s plan has the full backing of the board. It sets out a path to adapt the business for the future and improves its service in the face of climate change and population growth.
“Ofwat’s draft determination and our response to it is one stage in the process - there will be many subsequent stages. “The company and its leadership team are absolutely focused on the ambitious outcomes it aims to deliver for customers and the environment, and the role we play in enabling growth across our economy.
“After decades of focusing on keeping bills low, now is the time for difficult choices. It’s the responsibility of the company, our regulators and the Government to seek solutions in the best interests of customers and the environment. We will continue to work collaboratively as we launch our process to raise the equity we need and seek a final determination that enables the delivery of our ambitious plan.”
Thames Water has an ambitious £20.7bn core plan with an additional £3bn through gated mechanisms that we believe we can deliver with the right regulatory settlement.
Even with this level of ambition, we have had to make tough choices. We cannot deliver everything for all stakeholders at pace and for the prices of the past. We will therefore focus on things that our customers have told us matter most. Our business plan will see customer bills increase to fund much needed investment. By the end of 2030, the average monthly customer bill will have increased by £18.99 from what they pay today in real terms. We are committed to doing our best to ensure that customers do not pay more than they need to for vital investment by becoming a more agile, efficient, and responsive company and we will ensure we support our customers who will struggle to pay.
We have listened carefully to Ofwat’s feedback. We have been through a rigorous process to challenge our plans and stretched ourselves to deliver more where we can. However, the scale of the cuts Ofwat proposes in its draft determination, a 25% decrease to our proposed expenditure, is not tenable and renders our plan uninvestible. This would leave us with a multi-billion pound gap between what we are allowed to charge our customers and what is needed to deliver against the ambitions that customers and stakeholders have set for us.
We accept many of Ofwat’s proposals including most of the water performance commitments, which reflects the material improvements in the overall performance of our water services.
However, we have significant concerns in other areas. This includes wastewater, where Ofwat has cut our proposed enhancement expenditure in half and has set targets that are unachievable. These expose the company to disproportionate penalties and excessive downside risk, impacting investibility and ultimately our ability to deliver better infrastructure. This is clearly an area of concern for our customers and it is important that this is addressed before the final determination.
In our response we have provided evidence, argument and independent assurance to demonstrate to Ofwat that this gap needs to be closed. We have provided a way forward that seeks to re-calibrate Ofwat’s decisions to enable us to meet customers’ expectations and ensure Thames Water is a viable and investible business.
With the right regulatory settlement, as well as the energy and commitment of the teams across our business, we can meet the challenges we face over the next control period and beyond; we can achieve our ambition to deliver greater resilience and improved operational, environmental and customer performance.
We know Ofwat will give full consideration to our response and we stand ready to work with our regulators in the best interests of customers and the environment.
Thames Water’s response to the PR24 draft determination consultation:
Investing £20.7 billion and an additional £3bn through gated mechanisms to maintain safe high quality drinking water, ensure security of water supplies and deliver further environmental improvements.
Our plan will deliver a reliable, secure and affordable service for customers by:
IMAGES
VIDEO
COMMENTS
Bottled Water Business Plan Over the past 20+ years, we have helped over 1,000 entrepreneurs and business owners create business plans to start and grow their bottled water production companies. On this page, we will first give you some background information with regards to the importance of business planning. We will then go through a bottled water business plan template step-by-step so you ...
Discover the key elements to include in your bottled water business plan. Our guide offers practical advice, templates, and examples to help you write your own.
Quench your entrepreneurial thirst by starting a bottled water business with insights on sourcing, purification processes, and market entry.
Are you about starting a bottled water production business? If YES, here is a complete sample bottled water production business plan template & feasibility report you can use for FREE. Starting a bottled water business is one of the best steps to take. This is especially so because of the level of profitability in the industry.
PlanBuildr's Bottled Water Company business plan template will help you to quickly and easily complete your Bottled Water Company business plan.
Explore the essentials of starting a bottled water business: from planning, setup, compliance, marketing to sustainable operations. Dive in today!
ClickUp's Business Plan Template for Water Companies provides a comprehensive framework to help water companies and entrepreneurs in the water industry create a strong business plan.
A bottled water business plan is a strategic document that outlines the objectives, strategies, and operational details of starting and running a bottled water venture. It serves as a roadmap ...
Learn how to start a bottled water company including business planning, key industry information, competitors, key startups costs, and more.
When you write the strategy section of your bottled water brand business plan, remember to cover key elements such as your competitive edge, pricing strategy, sales & marketing plan, milestones, and risks and mitigants. In the competitive edge subsection, elaborate on what makes your company stand out from competitors.
Learn how to start a bottled water business. Find out how much it will cost to start, typical target market, growth potential & more.
How to start a profitable bottled water business. Bottled water business plan tips. The mineral water business is very lucrative and profitable.
August 30, 2024 Do you want to start a mineral water business? Find here a detailed plan guide on how to start a mineral water plant business with costs, licenses, manufacturing process, machinery required, and more.
Are you about starting a sachet water production company? If YES, here is a complete sample sachet water production business plan template & feasibility report you can use for FREE.
This sample business plan outlines the essential elements of a good bottled water and mineral business plan template. If you stick to the format, you will create a solid bottled water factory building plan that will perfectly reflect your business and win you that loan you so desperately need.
Water purification and bottling business plan for starting your own business Bottled water is one commodity consumed in all parts of the world, and of course, those in the business of producing bottled water are known to generate sales all year round if the company is well-managed. The economic downturn hardly affects the consumption of bottled water simply because it is a commodity that is as ...
Learn how to start a profitable bottled water business with our 11+ step guide. From sourcing water to marketing, we cover it all. Start your business today! #bottledwater #entrepreneurship #smallbusiness
We can help with our water purification business plan template and how-to manual. Everything you need to construct a thorough business plan is included in our expertly produced template and instruction manual, from market analysis and financial predictions to marketing strategy and operational frameworks. Your ambition of starting a profitable ...
Learn about water factory costs, including how to setup a bottled water factory, and drinking water plant setup cost details.
To watch the full course, go to: https://www.learnatshaunacademy.com/bottled-water-business-courseIn this course, you will learn how to start a bottled water...
Read detailed business plan on how to start a mineral water plant project in India. Read about project cost estimation, required machinery and profit margin in this business.
Explore a real-world water purification business plan example and download a free template with this information to start writing your own business plan.
Intel considers splitting off foundry business, scrapping factory plans- Bloomberg. RTX to pay $200 million fine for export mistakes, State Department says.
Thames Water Utilities Limited has today submitted its response to Ofwat's draft determination for 2025 to 2030, as part of Price Review 2024 (PR24). Link here. Chris Weston, CEO Thames Water, said: "We have proposed a highly ambitious business plan for 2025-2030 based on customers' feedback and insight.