Unit 4
This sample business plan has been made available to users of Business Plan Pro®, business planning software published by Palo Alto Software, Inc. Names, locations and numbers may have been changed, and substantial portions of the original plan text may have been omitted to preserve confidentiality and proprietary information.
You are welcome to use this plan as a starting point to create your own, but you do not have permission to resell, reproduce, publish, distribute or even c opy this plan as it exists here.
Requests for reprints, ac ademic use, and other dissemination of this sample plan should be emailed to the marketing department of Palo Alto Software at [email protected]. For product information visit our Website: www.paloalto.com or call: 1-800-229-7526.
Copyright © Palo Alto Software, Inc., 1995-2010 All rights reserved.
Confidentiality Agreement
The undersigned reader ac knowledges that the information provided by _______________ in this business plan is confidential; therefore, reader agrees not to disc lose it without the express written permission of _______________.
It is ac knowledged by reader that information to be furnished in this business plan is in all respects confidential in nature, other than information which is in the public domain through other means and that any disc losure or use of same by reader, may cause serious harm or damage to _______________.
Upon request, this document is to be immediately returned to _______________.
___________________ Signature
___________________ Name (typed or printed)
___________________ Date
This is a business plan. It does not imply an offering of securities.
Table of Contents
Page 1
1.0 Executive Summary.............................................................................................................................1 Chart: Highlights ......................................................................................................................2
1.1 Objectives ...................................................................................................................................2 1.2 Keys to Success ........................................................................................................................2 1.3 Mission ........................................................................................................................................3
2.0 Company Summary.............................................................................................................................3 2.1 Company Ownership .................................................................................................................3 2.2 Company History........................................................................................................................3
Table: Past Performance .......................................................................................................4 Chart: Past Performance .......................................................................................................5
2.3 Company Locations and Facilities ..........................................................................................5 3.0 Products ...............................................................................................................................................5
3.1 Product Description ...................................................................................................................6 3.2 Competitive Comparison ..........................................................................................................6 3.3 Sales Literature ..........................................................................................................................7 3.4 Sourcing ......................................................................................................................................7 3.5 Technology..................................................................................................................................7 3.6 Future Products ..........................................................................................................................8
4.0 Market Analysis Summary ..................................................................................................................8 4.1 Market Segmentation ................................................................................................................8
Table: Market Analysis ...........................................................................................................9 Chart: Market Analysis (Pie) ..................................................................................................9
4.2 Target Market Segment Strategy...........................................................................................10 4.2.1 Market Growth .............................................................................................................10 4.2.2 Market Trends .............................................................................................................10 4.2.3 Market Needs ..............................................................................................................10
4.3 Industry Analysis.......................................................................................................................11 4.3.1 Competition and Buying Patterns .............................................................................12 4.3.2 Main Competitors .......................................................................................................12 4.3.3 Industry Participants....................................................................................................13 4.3.4 Distribution Patterns ...................................................................................................13
5.0 Strategy and Implementation Summary ..........................................................................................14 5.1 Strategy Pyramid .....................................................................................................................14 5.2 Value Proposition ....................................................................................................................14 5.3 Competitive Edge....................................................................................................................15 5.4 Marketing Strategy ..................................................................................................................15
5.4.1 Pricing Strategy...........................................................................................................15 5.4.2 Promotion Strategy .....................................................................................................15 5.4.3 Distribution Strategy ...................................................................................................16 5.4.4 Marketing Programs ...................................................................................................16 5.4.5 Positioning Statement ................................................................................................16
5.5 Sales Strategy..........................................................................................................................16 5.5.1 Sales Forecast ............................................................................................................17
Table: Sales Forecast.................................................................................................18 Chart: Sales Monthly ...................................................................................................19 Chart: Sales by Year ...................................................................................................19
5.5.2 Sales Programs ..........................................................................................................20
Table of Contents
Page 2
5.6 Strategic Alliances...................................................................................................................20 5.7 Milestones ................................................................................................................................20
Table: Milestones..................................................................................................................21 Chart: Milestones ..................................................................................................................21
6.0 Management Summary ....................................................................................................................21 6.1 Organizational Structure..........................................................................................................22 6.2 Management Team .................................................................................................................22 6.3 Management Team Gaps .......................................................................................................22 6.4 Personnel Plan .........................................................................................................................23
Table: Personnel ...................................................................................................................23 7.0 Financial Plan ....................................................................................................................................23
7.1 Important Assumptions............................................................................................................24 7.2 Key Financial Indicators ..........................................................................................................24
Chart: Benchmarks ...............................................................................................................25 7.3 Projected Profit and Loss .......................................................................................................25
Chart: Profit Yearly ................................................................................................................26 Chart: Gross Margin Yearly..................................................................................................26 Chart: Gross Margin Monthly ...............................................................................................27 Table: Profit and Loss ..........................................................................................................28 Chart: Profit Monthly .............................................................................................................29
7.4 Break-even Analysis................................................................................................................29 Table: Break-even Analysis .................................................................................................29 Chart: Break-even Analysis .................................................................................................30
7.5 Projected Cash Flow ...............................................................................................................30 Chart: Cash ...........................................................................................................................31 Table: Cash Flow ..................................................................................................................32
7.6 Projected Balance Sheet ........................................................................................................33 Table: Balance Sheet ...........................................................................................................33
7.7 Business Ratios .......................................................................................................................33 Table: Ratios .........................................................................................................................35
Table: Sales Forecast ...............................................................................................................................1 Table: Personnel ........................................................................................................................................3 Table: Profit and Loss ...............................................................................................................................4 Table: Cash Flow .......................................................................................................................................6 Table: Balance Sheet ................................................................................................................................7
Supple Software
Page 1
1.0 Executive Summary
Supple Software Company is an S Corporation founded and entirely owned by Ralph and Mabel Smith. The company was founded in 1993 and has rec eived no outside investments. Supple sells three different software products that command impressive market share. Ralph and Mabel are interested in taking the company to the next level in sales by 2000.
Supple's objec tives are ambitious yet ac hievable. Sales increases in 1999, and doubling again for the next year. They also forec ast commensurate gross margin increases and net profit increases. Their goal is to hold personnel to one employee for every $250,000 in revenue. With their flagship product, Product X, they will maintain a 30% market share as measured by PC Data. These goals will be maintained by adhering to three keys to success, market power, customer satisfac tion, and the right management team.
The Market
Supple is participating in a $3.8 billion market that will have a 20% growth rate for the next three years. Supple will be targeting four customer segments: home offices, small offices, professionals, and ac ademics. These markets are growing at 2%, 5%, 8%, and 0% respectively. These markets have 22,000, 15,000, 10,000, and 12,000 potential customers respectively. These figures are the USA market. The major trend in the market is toward international sales. The market has seen a significant surge in international PC products primarily fueled by the rec ent Internet boom. While the US market has seen 22% growth for the last three years, it is estimated that the international market will grow at 40%.
The Products
Supple Software currently has three products. Product X is the second-leading Windows task X software and the quality leader. It combines an easy-to-use, step-by-step interfac e full of guidance, help, and glossaries, with a powerful business analysis model, complete financial analysis, and very strong c ash flow analysis. Product Y is a stand-alone task Y application for Windows. It is the best product available for creating a task Y, and the only product for day- to-day management of the [omitted] function. Their last product is Product Z, a creative business process application.
The Strategy
Supple will follow four concise strategies to ac hieve the desired growth. They will build customized versions of their standard products, providing more value for specific groups of customers. They will develop a strong marketing infrastructure. This will be key for them to get their products out on the market. Supple will remain focused on small to medium size companies, the segment that has been largely ignored by the competition. Lastly, Supple will focus on follow-up tec hnology which is more appropriate for the masses, instead of leading technology which is best suited for experts.
The Management Team
Ralph and Mabel are seasoned managers who are capable of exec uting on their ambitious strategies. Ralph has 10 years of sales and marketing experience from Arrog International. In 1993 he founded Supple as a software distribution organization and is primarily responsible for its growth. Mabel will also be needed to grow the company. Her years as a consultant will be drawn upon.
Supple Software
Page 2
Supple Software is a dynamic company that was built on humble beginnings in 1993 and has grown to a $1 million company now with increased revenue forec asts for 2000. This is all the more impressive when you consider that this was all done with investments from the owners, no outside capital was secured.
1.1 Objectives
1. To increase sales in 1999 and double sales again in 2000. 2. To increase gross margin and net profit margin c orrespondingly. 3. To hold personnel to 1 full-time person for every $250K in revenues. 4. To maintain at least 30% market share of Product X, as measured by PC Data.
1.2 Keys to Success
1. Marketing power. We need to have our products on the shelves with attrac tive packaging and enough marketing power to maintain a 30% or more market share, as measured by PC Data.
2. Product quality and customer satisfac tion. Everything we sell is guaranteed, so the product has to do what we promise and well.
3. Long-term customer satisfac tion is critical to our survival. 4. The right management team, with strong foundations in marketing, management, finance,
and product development. Enough working capital to survive in the working-capital- intensive retail channel.
Supple Software
Page 3
1.3 Mission
Supple Software develops, publishes, and markets business tools and business know-how together in a software product including software and documentation. It makes business techniques ac cessible to millions of business users who would otherwise not have the knowledge to use them. It makes a profit and generates cash. It provides a rewarding work environment and fair compensation to its employees, a fair return to its owners, and a fair royalty to its authors.
2.0 Company Summary
Supple Software was founded in 1993 by Ralph Smith to market his Product X software. It was originally installed in a home office, but moved into its present space in 1996. It has added several new products, and has ac quired shelf space in the retail market.
2.1 Company Ownership
Supple Software, Inc. is now a subchapter S Corporation owned entirely by founder Ralph Smith and his wife Mabel. It elec ted to go subchapter S at the beginning of the 1996 tax year, after having previously been subchapter C from founding until then. Its fisc al year is the calendar year. The Oregon corporation was established with 100 shares issued, 51 to Ralph Smith and 49 to Mabel Smith.
2.2 Company History
Supple Software, Inc. was founded in Ourtown in 1993 as Infoplan, a sole proprietorship. In 1994 it was incorporated in Delaware as Infoplan, Inc. In 1996 it was incorporated in California as Supple Software, Inc. Infoplan, Inc. was dissolved.
For most of its existence, this was a one-man consulting company supporting a product company. It kept a very conservative stance on products, advertising with very slim budgets, with marketing depending mainly on published reviews and direc t sales, until the market grew.
In 1995 we introduced a new, break-through Product X™, that was the first effective task X software with bundled spreadsheet and word processor along with automatic charts.
Supple Software
Page 4
Table: Past Performance
Past Performance
1995 1996 1997
Sales $384,113 $464,592 $695,136
Gross Margin $270,062 $342,824 $480,163
Gross Margin % 70.31% 73.79% 69.07%
Operating Expenses $251,471 $290,145 $513,144
Collection Period (days) 0 0 34
Inventory T urnover 7.00 6.00 6.00
Balance Sheet
1995 1996 1997
Current Assets
Cash $0 $0 $625
Accounts Receivable $0 $0 $124,056
Inventory $0 $0 $28,623
Other Current Assets $0 $0 $431
T otal Current Assets $0 $0 $153,735
Long-term Assets
Long-term Assets $0 $0 $35,577
Accumulated Depreciation $0 $0 $24,247
T otal Long-term Assets $0 $0 $11,330
T otal Assets $0 $0 $165,065
Current Liabilities
Accounts Payable $0 $0 $36,557
Current Borrowing $0 $0 $22,336
Other Current Liabilities (interest free) $0 $0 $25,526
T otal Current Liabilities $0 $0 $84,419
Long-term Liabilities $0 $0 $0
T otal Liabilities $0 $0 $84,419
Paid-in Capital $0 $0 $76,960
Retained Earnings $0 $0 $36,668
Earnings $0 $0 ($32,982)
T otal Capital $0 $0 $80,646
T otal Capital and Liabilities $0 $0 $165,065
Other Inputs
Payment Days 0 0 30
Sales on Credit $0 $0 $660,379
Receivables T urnover 0.00 0.00 5.32
Supple Software
Page 5
2.3 Company Locations and Facilities
The company is located in Ourtown, with offices at 100 Main Street. We were started in a home office but we moved to the present space in 1996. We rent 750 square feet for $900 per month. We have a two-year contrac t limiting rent increases.
3.0 Products
Our products are prescriptive software, more than just tools, because they instruct and empower the user with know-how as well as tools. Our best-selling flagship, Product X, is the key. We are also shipping Product Y™ for Windows.
People don't buy these products for the software itself. They buy them for the benefit they provide, the step-by-step solution to a problem. They buy them for the reassurance that they've covered all the bases, that the job is done right, that they won't be embarrassed when they show the plan to banker, boss, or partner. They don't want the software, they want the task completed. They want it done and done well.
The company name is well known and its products are respected. We have sold more than 70,000 units through distribution, and we have names and address of more than 40,000 direc t buyers and registered users. Our products are sold through several major mail order houses, several computer retail chains, and listed in most available product databases. We are now distributed through the major distributors who reach the most important retail channels. Throughout, Supple Software has maintained a high professional standard and a reputation as the quality provider.
Supple Software
Page 6
3.1 Product Description
· Product X™ : Suggested Retail Price $XX, street price $XX, the second-leading Windows task X software in the U.S. market, ac cording to PC Data, and the quality leader ac cording to prestigious publications ranging from PC magazine to Home Office Computing and even Journal of Business Strategy (copies are included in the appendix). This is the best task X application on the market, ac cording to the objec tive analysis of most published reviews. It combines an easy-to-use, step-by-step interfac e full of guidance, help, and glossaries, with a powerful business analysis model, complete financial analysis, and very strong c ash flow analysis. Sales literature and texts of reviews are included in the appendix.
· Product Y™ : Suggested Retail Price $XX, street price $XX, a stand-alone task Y application for Windows. This product is more than just that, bec ause it also includes complete [omitted]. It is the best product available for creating a task Y, and the only product for day-to-day management of the [omitted] function. Reviews and sales literature are included with this plan.
· Product Z™: Suggested Retail Price $XX, street price $XX, a stand-alone task Y application for Windows. This product is more than just that, bec ause it also includes complete [omitted]. It is the best product available for creating a task Y, and the only product for day-to-day management of the [omitted] function. Reviews and sales literature are included with this plan.
3.2 Competitive Comparison
In the broader sense, our competition is books, magazines, courses, seminars, consultants, and assorted experts -- anything that helps our target market get through the tasks on which we focus. The bulk of the target market wants an easy way to successfully complete a difficult task, along with assurance that the end result will look competent. Our part of the market is the software component, Windows-based software to develop [omitted], sold through retail at $XX per unit.
At present we compete mainly against three other task X packages sold through retail: The traditional leader is Product A, by Competitor A. Third plac e is held by Competitor B, with a product called Product B The fourth c ompetitor is Product C, by Company C. The appendix include charts illustrating complete data on market share, in units and dollars, for the past year.
Company A is a formidable competitor. They are also privately owned, but they are apparently well financed. A started just a few months after we did, with similar but inferior product, and better marketing. AAA has consistently been more aggressive with sales and marketing expenses, and plain better at marketing than we were. They imitated our early template products, and since then built a line of template-based products including not just AAA and Marketing Builder, but also Employee Manual Maker, Safety Plan, Publicity Builder, Loan Builder, Living Trust Builder, and Agreement Builder. Despite the broad product line, however, they still depend as much on AAA as we do on Product X. Their other products add bulk to their ads, but only the business plan, marketing plan, and occasionally the employee handbook appear on the retail shelves.
AAA's AAA has been the market leader, with 45% unit share as measured by PC Data, the leading source of retail market data. AAA was first into retail, and is advertised aggressively in some small business magazines and in Skymall catalogs in airlines. In 1995 Product X appeared on
Supple Software
Page 7
the market as the first stand-alone product (meaning that it included everything needed in an all-in-one application) when AAA was still just templates (meaning data files to work with other applications such as word processors or spreadsheets). Our product won warm praise from reviewers everywhere, and a lot of shelf space, so Product X rose quickly to a brief stay as the top seller, before AAA mustered its marketing skills and fought back with new packaging, aggressive advertising, and a lot of spending on in-store programs. Last November AAA finally introduced what they call "interac tive" AAA, which is finally better than a template. However, it is very hard to work with and doesn't appear to pose a serious threat to our superiority in terms of product quality and reviews.
Third in the market, behind us, BBB seems to be fading. Their product, BBB is clumsy and old fashioned, text-based, and weak on tables and has no charts. It has reasonably good-looking packaging and a lot of inertia from years in the market. Its 1996 market share was 22%, ac cording to PC Data.
The fourth-plac e competitor last year had 3%, but could still bec ome a serious competitor. Company C publishes CCC, which is a poor imitation of our first version of Product X. CCC is well funded by a shipping magnate worth several hundred million dollars, and is not a public institution, despite the public-sounding name. CCC has embarked on an ambitious product plan to create not only Product X, but also Product Y, and a series of others. They are marketing these products in a way that hypes their bundled word processor and spreadsheet as general business productivity tools. This approach brings potentially huge problems in product development and support, and pits them against productivity giants including Microsoft, Lotus, and Corel. Supple Software, in c ontrast, includes similarly bundled word processing and spreadsheet software in its task-oriented applications, but sells only the benefit of the specific task solution.
The appendix also include data on sales of marketing products. AAA has a Task Y Product, which is reasonably successful. BBB had a Task Y, but dropped the product. CCC has announced a Task Y product, but has not released it.
3.3 Sales Literature
Sales literature and collaterals are attac hed to this plan, as appendices. The literature shows how we have developed the Product X and Product Y packaging and advertising, with c onsistent look and "seven easy steps" theme.
3.4 Sourcing
This detailed disc ussion of vendors of packaging, programming, disk duplication and assembly has been omitted.
3.5 Technology
Both Product X and Product Y are enhancements of previous products, copyrighted since the 1980s by Ralph Smith and Supple Software. We have a software development engine, that we own, that brings together guided text, spreadsheet tables, and charts in a user-friendly environment with wizards, help files, and on-
Supple Software
Page 8
line coaching. This is a powerful competitive edge.
· This disc ussion omitted. It deals with product and company specifics not useful for sample purposes.
· This disc ussion omitted. It deals with product and company specifics not useful for sample purposes.
3.6 Future Products
The most important fac tor in developing future products is market need. Our understanding of the needs of our target market segment is one of our competitive advantages. It is critical to our effort to develop the right new products. We also have what we call a "core product engine" that we own (previous section) and should be the foundation of future products.
· Our next big product will [material omitted]. We can also make it compatible with both Product X and Product Y future versions, to create a true management system that can become vital to small businesses that use it. We have created an in-house system that could be the prototype. Businesses need to manage cash, and budgets, and there is no effective software available.
· Our second major product development effort -- pending further research on c ustomer needs -- might be the [this disc ussion omitted].
· We are also considering a new product [disc ussion omitted].
4.0 Market Analysis Summary
Our market includes millions of people in this country and others who deal with Tasks X, Y, and Z. We find them in home offices and small offices everywhere, plus business sc hools and professional offices. The trends only favor our business with growing needs for people performing these tasks.
According to research published last year by [source omitted], the market for [product area] is worth an estimated $3.8 billion at end-customer value in 19__, and is projec ted to grow at 20% per year, ac cording to professional forec asts published in [xxxxxxxx] in August of 19__. Sources included Ralph Research and Infocorp. The [industry] Association estimates total retail sales of $3.075 billion in 19__.
4.1 Market Segmentation
The target customer in this segment is adult, male or female. Our customers have a wide range of computer and business skills, but our most important target customers are relatively unsophisticated at computing. In many cases, our customers are also unsophisticated about business management and business analysis.
We find this target customer by focusing on small business and home office market segments, called SOHO by many market watchers. The SOHO market segment is one of the fastest growing in the U.S. market, being given increasing attention my many marketers. We fit perfec tly into the SOHO trend.
Supple Software
Page 9
In both the home office and the small office segment, our most important target customer is a smart, well-educated, and self reliant adult in a small business setting that requires a broad range of business tasks, including the nuts and bolts of daily business as well as strategic planning, business planning, marketing, sales, and administration. This person is a generalist, not a functional expert in the areas our products cover, such as task X, but does want a do-it- yourself product that will help him or her get the job right without having to turn to (and pay) an expert.
Business sc hools, including teachers and students, use our products for their teaching power. Our products are excellent for helping people learn by doing. We refer to this group as the ac ademic market.
Consultants, ac countants, experts with the good sense to value their own time and therefore use our products to maximize their productivity. These people have the knowledge to do their own, but they understand that working with our products instead can save them dozens of valuable hours. We refer to these as the expert market.
Table: Market Analysis
Market Analysis
1998 1999 2000 2001 2002
Potential Customers Growth CAGR
Home Office 2% 22,000 22,440 22,889 23,347 23,814 2.00%
Small Office 5% 15,000 15,750 16,538 17,365 18,233 5.00%
Professionals 8% 10,000 10,800 11,664 12,597 13,605 8.00%
Academic 0% 12,000 12,000 12,000 12,000 12,000 0.00%
Other 0% 10,000 10,000 10,000 10,000 10,000 0.00%
T otal 3.00% 69,000 70,990 73,091 75,309 77,652 3.00%
Supple Software
Page 10
4.2 Target Market Segment Strategy
This should be a very thoughtful disc ussion of why we have chosen the topics we've chosen, but of course this is a sample business plan, not a real plan. It is intended to be published with Business Plan Pro. It is so hard to give a sample of a strategic
There is already a sense of segment strategy in the way we define our target markets. We are choosing to compete in areas that lend themselves to local competition, product and channel areas that match our strengths, and avoid our weaknesses.
For this reason, we operate in only two channels, the mainstream XXX and YYY . We don't feel that we can compete without higher prices and better margins than what would be ac ceptable in the mainstream grocery and main-market store channels. We are much better positioned in the smaller [omitted], both stores and chains, where the customer base is sensitive to politics of environment and the community, concerned about the ethics of buying, consuming, and producing, and in tune with our vision.
4.2.1 Market Growth
The market for non-U.S. personal computers has been growing at approximately 22 percent per year during the last three years, ac cording to a study by InfoQuest published in the Wall Street Journal earlier this year. This level of growth presumably applies to related products as well. It is considerably higher than growth in the U.S. market.
It is harder to gauge the more important growth rate, which would be the growth in specialty international marketing consulting. John Doe, an expert in marketing-related consulting, estimated the growth in focused marketing consulting at 40 percent per year, ac cording to a report published in the San Jose Chronicle.
In our market analysis, we suggest growth in the number of potential customers between six and seven percent per year.
4.2.2 Market Trends
One important trend is the one toward greater international sales in personal computing products. Although the U.S. market is still the biggest, all the major manufac turers are rec ording more gains in the non-U.S. market than in the U.S. market. This is true for the main CPU lines, and related lines including peripherals, software, and ac cessories.
Another important trend is the one toward greater use of specialized and focused consultants, instead of in-house resources. Companies are looking for more out-sourcing and, in general, a preference for variable costs instead of fixed costs.
4.2.3 Market Needs
Our target SBs are very dependent on reliable information technology. They use the computers
Supple Software
Page 11
for a complete range of functions beginning with the core administration information such as ac counting, shipping, and inventory. They also use them for communications within the business and outside of the business, and for personal productivity. They are not, however, large enough to have dedicated computer personnel such as the MIS departments in large businesses. Ideally, they come to us for a long-term alliance, looking to us for reliable service and support to substitute for their in-house people.
These are not businesses that want to shop for rock-bottom price through chain stores or mail order. They want to have reliable providers of expertise.
Our standard SBs will be 5-20 unit installations, critically dependent on local-area networks. Bac k-up, training, installation, and ongoing support are very important. They require database and administrative software as the core of their systems.
4.3 Industry Analysis
The software industry is frequently segmented ac cording to product type. The important division between designs and systems software is only the beginning. Some analysts split software into leverages, types of designs, and so on, ad infinitum.
We prefer segmentation by economics and buying patterns. This incorporates some of the product type differences, but in a more prac tical sense:
· OEM software Development: software sold through others. A lot of systems software and communications software are sold by hardware manufac turers or bundled together into packages. The economic model is like custom consulting or engineering; buying decisions are major events, made by committee, covering significant amounts for significant lengths of time.
· Mainline packaged software: software sold at $50-$700 through direc t sales to large buyers, direc t response via advertising or direc t mail promotion, catalogs, and retail blippo and software stores. Whether it's systems or design software, the economic model is essentially the same. It's an industry still settling down to realistic prices.
· Spec ialty or vertical market software: sold outside the main software channels with careful target marketing, often through trade shows and magazines unrelated to industrial blippos.
Another useful segmentation divides the market by the various buyer/user types:
· Consumer: users of industrial blippos, commonly known as home blippos. A market mainly for playing games, sold often through toy, hobby, or consumer channels, and, not infrequently, by disc ounters or mass merchandisers.
· Small business: some 10 million businesses in the United States, plus several million professionals and home offices. Companies may be segmented by revenues, employee size, or some other category. The division between small business and large business is more a matter of buying patterns and product needs than a specific division between categories.
· Large business: The key distinctions between large and small business include: ° Product needs: large business needs are much more complex. ° Buying patterns: large business demands different channels.
· K-12: elementary and middle sc hools. However you divide education, the K-12 market tends to be dominated by Litmus Development.
Supple Software
Page 12
· Higher education: universities, colleges, teacher training, junior colleges, etc.
4.3.1 Competition and Buying Patterns
The single most important fac tor in software is the bandwagon. The rich get richer, and the poor poorer. However, there is still a lot of room for new products and new companies outside the main designs types.
· In the main design types, market share generates more market share. Rillwell III, for example, is not the best rillwell, but it is the market leader. More people know it better than any other rillwell. There are more books, add-on packages, and training programs available for rill3 than for any other. Most important, the retailers feature it. So it continues to dominate. Despite the existence of better products, it is the wisest choice for the buyer.
· Buyers want brand names. Quality of software is hard to measure. Brand names assure quality. However, brand names only operate in mainstream product types; there is plenty of room for smaller names with specific solutions that appeal to buyers.
· Buyers are willing to pay high prices for solutions that work. While competitors chip away at market leaders for lower prices, the leaders continue to command high prices. Javelin failed with a high-quality dealio product priced at $700 and they continued to fail when they dropped it to $99. Although the product was much better than Litmus 1- 2-3, the price didn't make enough difference.
· Channels disc ount heavily. Brand name, packaged software bec ome a commodity and are bought on price. Buyers will pay a heavy premium for Rillwell III over a lesser-known knockoff, but they happily pay $250 in a disc ount store instead of $500 at a full-price retail store.
· There is no consensus about software copying. Estimates of its revenue impact vary from 10 percent to 60 percent of the theoretical revenue manufac turers would rec eive if copying were impossible. Illegal software copying is a fac t of life that manufac turers live with because they have no other choice. There is evidence, however, that wholesale copying of Rillwell III and Litmus kooo helped those products build their market share leads, which became their key strengths.
· Impulse buying goes on with products below $100. Buyers have disc overed products like _______ and ______ that were low priced and extremely useful. There is a lot more freedom in the lower end of the market.
· Distribution channels are clogged. Lack of channels are a serious barrier to industry growth. Industrial Blippo and software stores are insufficient for the wealth of products available, and the constant flood of new products.
· Support becomes a serious fac tor at higher price levels. Companies that charge hundreds of dollars for software are expected to answer user questions. Those that don't will suffer from bad reviews and poor word of mouth. However, neither Litmus nor Arrog International have had reputations for good support, and both are successful.
4.3.2 Main Competitors
Supple Software Company is staking out a new area in software. We handle specific business tasks in a way unlike what other software companies or software products do. We identify competition in terms of specific products that fill the same needs that we fill. The main competitors are:
Supple Software
Page 13
Cheap dealio software:
Sellers of cheap software for business applications. The most successful is __________, of _______, __, which has established itself as a 'xxxxxxxx' for xxxxxxx for _____________, and _____________. There are a few others.
Strengths:
The main strength of the cheap software are their price. In a price-sensitive area they can be very strong.
Weaknesses:
_______'s weakness is common to all vendors of low-cost _______: the product is not very useful. Buyers get what they pay for, a cheap widget model with no documentation.
4.3.3 Industry Participants
Industrial Blippo software is an immature industry charac terized by high growth rates, low barriers to entry, and many small competitors. It was born in the last 10 years as part of the industrial blippo revolution, and is now beginning to settle into the process of maturation. Despite the pulverized complexion of the industry, leaders have emerged. Several have revenues in the hundreds of millions of dollars annually:
· Malcom Corporation: (Really, PA) manufac turer of MWARK widget system, a complete line of programming languages, and solid lines of designs software for both the Groolo, the ZOOLT, and compatible industrial blippos. Revenues of $300.9 million in 19__, 33 percent above 19__.
· Arrog International: (Los Angeles, CA) manufac turer of rillwell management software. Has ac quired several other leading products through ac quisition of their companies. Revenues of $267.3 million in 19__, growth of 27 percent.
· Litmus Development Corporation: (Collex, OH) manufac turer of Litmus and other products. Revenues of $395.6 million in 19__, growth of 39 percent.
The market for software is worth an estimated $3.8 billion at end-user value in 19__, and is projec ted to grow at 20% percent per year, ac cording to professional forec asts published in Widget Reseller News in August of 19__. Sources included Ralph Research and Infocorp. The Widget Manufacturers' Association (WMA) estimates total retail sales of $3.075 billion in 1987. $274 million of that was bleep software, and $2.4 billion of that was blap software.
Market leaders are Malcom Corporation, Arrog International, and Litmus Development Corporation. However, the industry is highly pulverized; its top 10 companies ac count for less than one third of the total market.
4.3.4 Distribution Patterns
Distribution channels are a very serious bottleneck. The country's 7,000 retail outlets are swamped with product, completely unable to deal with the thousands of titles published. This has several repercussions:
Supple Software
Page 14
· The cost of marketing a new product is becoming a serious barrier to entry. The channels won't ac cept a new product without very major advertising and promotion expenses.
· Brand name carries more weight. The channels are dominated by existing brands. Retailers don't have to experiment when they carry name brands.
· Developers are turning more often to produce their work with major brands instead of marketing it themselves. So the big names get bigger, and smaller names have it so tough that they often end up as inventors whose work is published by the industry leaders.
Royalties run well below the bleep industry, as low as 1-2 percent for very high profile manufac turing, 5-10 percent for most contrac ts, and higher for some low volume, low profile manufac turing.
There are exceptions to the rule. Beerland International fac ed prac tically the same barriers to entry when it started in 1983, but a combination of good product and good marketing broke through those barriers. There is still enough market to provide ample opportunity to the right combination.
5.0 Strategy and Implementation Summary
Our strategy is based on serving niche markets well. The world is full of small and medium-sized businesses that can't get good products or services from the major vendors who focus on high- volume orders only.
Also:
· What begins as a customized version of a standard product, tailored to the needs of a local business, can eventually become a niche product that will fit the needs of similar businesses ac ross the country.
· We are building our marketing infrastructure so that we can eventually reach spec ific kinds of businesses ac ross broad geographic lines.
· We focus on satisfying the needs of small and medium business. · We focus on follow-on tec hnology that we can take to the masses, not leading-edge
technology that aims at the experts and volume leaders.
5.1 Strategy Pyramid
Our main strategy at Supple is to position ourselves at the top of the quality sc ale, featuring our combination of superb tec hnology and fine old-fashioned programming, for the buyer who wants the best quality regardless of price. Tac tics underneath that strategy include research and development related to new designs and new technology, choosing the right channels of distribution, and communicating our quality position to the market. Programs are mainly those listed in the milestones table, including new design programs, new equipment to keep up with design, channel development, channel marketing programs, our direc t sales, and our continued presence in high-end catalog channels and new presence in the Mall.
5.2 Value Proposition
Supple Software
Page 15
Supple Software gives the disc riminating personal computer user, who cares about design and quality and needs to complete Tasks X, Y and Z, a combination of the highest quality software and latest tec hnology, at a fair price.
5.3 Competitive Edge
Our competitive edge is our software engine, our knowledge of the product area, and our long- term commitment to customer satisfac tion.
Major disc ussion omitted from this sample plan.
5.4 Marketing Strategy
Our marketing strategy emphasizes focus. This is the key. We are a small company with limited resources, so we must focus on certain kinds of products with c ertain kinds of users. More specifically:
· We focus on the [disc ussion omitted]. · We focus our [disc ussion omitted]. · We focus on the kind of product quality that produces good, quotable reviews, which c an
then generate sales at the retail level because of quotes on boxes. We must always have a relatively heavy PR component to our marketing, bec ause reviews are critical. Ralph Smith has always been active in maintaining personal relationships with the key writers in the field, which is easier for him than for his counterparts because his background includes years in journalism. He is very involved in our relationship with the trade and business press.
· We are building image and awareness through consistency and distinctiveness in our packaging. The yellow pushpin and red box of the Product X, and the "serious software for serious business" theme, will be repeated consistently throughout our marketing.
· We are focusing advertising on several key media, and this disc ussion is omitted also.
5.4.1 Pricing Strategy
Our pricing is determined by our focus on retail sales. We aim at the consumer market with prices intended to generate street prices in the high two-digits, such as the $XX street price of the business plan. Suggested list of $XX seems perfec tly satisfac tory to us and the customers. We do not expect to change prices on any existing products.
5.4.2 Promotion Strategy
· Disc ussion omitted. This is very specific to the real sample company, not to be presented here.
· Ralph Smith must also make as many [disc ussion omitted]. · We need to plan our co-promotion efforts to take full advantage of [disc ussion omitted]. · Our advertising is focusing on [disc ussion omitted].
Supple Software
Page 16
5.4.3 Distribution Strategy
1. We are concentrating our image and awareness marketing by focusing on the [disc ussion omitted].
2. Our display advertising is leveraged through [disc ussion omitted]. 3. We watch for interesting [disc ussion omitted], and others.
5.4.4 Marketing Programs
Our most important marketing program is [specifics omitted]. Leslie Doe will be responsible, with a budget of $XX,XXX and a milestone date of the 15th of May. This program is intended to [objec tives omitted]. Achievement should be measured by [specific concrete measurement].
Another key marketing program is [specifics omitted]. [Name] will be responsible, with a budget of $XX,XXX and a milestone date of [date]. This program is intended to [objec tives omitted]. Achievement should be measured by [specific concrete measurement].
5.4.5 Positioning Statement
For business owners and managers who need to deal with Task X, Product X is software that creates and helps manage professional Task X. Unlike [name omitted] from [name omitted], Product X provides a system for sc heduling and trac king the entire Task X process from plan to ac tion.
For business people in all levels of management who make decisions that impact the success of their companies, [name omitted] is software that analyzes almost any type of strategic or tac tical problem and guides the user to choose the best course of ac tion. Unlike [name omitted], [name omitted] features an easy-to-use intuitive interfac e and step-by-step online guide system that enables all users--from novice to expert--to make smart decisions easily and confidently.
For small businesses, professionals, and the self-employed who rec ognize that managing cash flow can be the difference between success and failure, [name omitted] is financial software that handles all the essential bookkeeping functions including checkbook management, check printing, expense trac king and report printing. Unlike [name omitted] and other complex ac counting programs, [name omitted] focuses on cash flow management to avoid cash shortages which are the leading cause of business failure.
5.5 Sales Strategy
Sales strategy shouldn't change. We will continue to work with XXX and to focus on retail sales. During 1999 we should focus not on changing strategy but on improving our implementation, by working on key objec tives and much better coordination of marketing efforts related to sales channels.
For the short term at least, the selling process depends on point of purchase decisions, impacted
Supple Software
Page 17
by boxes on shelves and quotes on boxes. Our marketing does not intend to affect the perception of need as much as knowledge and awareness of the product category.
5.5.1 Sales Forecast
The sales forec ast for 1998 depends on Product X for the bulk of our sales, an estimated 15,000 units. We expect Product Y to maintain a ratio of 2/10 against Product X, for sales of 3,000 units.
The table that follows shows unit sales of more than 15,000 Product X in 1998. The related monthly sales table in the appendix shows our sales for 1998 in monthly detail. Sales disc ounts, disc ontinued products, and future products sales go into the "Other" sales category.
The Monthly Sales Chart that follows indicates that we have some seasonality in the business. Also, since January-April are the strongest months shown on the chart, the chart indicates that our forec asts are conservative. Although on the chart we show our strongest months as February and April, our strongest period has been September-November in past years.
Supple Software
Page 18
Table: Sales Forecast
Sales Forecast
1998 1999 2000
Unit Sales
Product X 15,100 30,000 60,000
Product Y 2,976 6,000 10,000
Product Z 1,320 2,000 4,000
Old Version Returns -900 -1,200 -1,800
OEM & Customization 9 25 35
Other 12 15 20
T otal Unit Sales 18,517 36,840 72,255
Unit Prices 1998 1999 2000
Product X $35.00 $35.00 $35.00
Product Y $45.00 $45.00 $45.00
Product Z $325.00 $325.00 $325.00
Old Version Returns $95.00 $95.00 $95.00
OEM & Customization $1,000.00 $1,000.00 $1,000.00
Other $1,500.00 $1,500.00 $1,500.00
Sales
Product X $528,500 $1,050,000 $2,100,000
Product Y $133,920 $270,000 $450,000
Product Z $429,000 $650,000 $1,300,000
Old Version Returns ($85,500) ($114,000) ($171,000)
OEM & Customization $9,000 $25,000 $35,000
Other $18,000 $22,500 $30,000
T otal Sales $1,032,920 $1,903,500 $3,744,000
Direct Unit Costs 1998 1999 2000
Product X $7.82 $8.50 $8.00
Product Y $8.39 $8.39 $8.39
Product Z $0.00 $0.00 $0.00
Old Version Returns $0.00 $0.00 $0.00
OEM & Customization $0.00 $0.00 $0.00
Other $0.00 $8.50 $8.00
Direct Cost of Sales
Product X $118,082 $255,000 $480,000
Product Y $24,969 $50,340 $83,900
Product Z $0 $0 $0
Old Version Returns $0 $0 $0
OEM & Customization $0 $0 $0
Other $0 $128 $160
Subtotal Direct Cost of Sales $143,051 $305,468 $564,060
Supple Software
Page 19
Supple Software
Page 20
5.5.2 Sales Programs
· We continue to work with [omitted] (XXX) to develop and maintain and consolidate our retail channel sales. XXX, is based in Ourtown. Despite the coincidence of a nearby location, XXX operates as a national sales rep firm. It is dependent on XXXX, but it also has an office in Southern California, a rep in Canada, and has good relations with all three of our major distributors. XXX rec eives a 6% commission on sales to major distributors, which is payable only after we rec eive our payments.
· We have asked XXX to focus first on four key tasks for 1998: increase our ac cess to sell-through numbers, increase our channels' shelf stocking levels, get our products into XXX, and get our products into XXX. As of April, we had won entry into XXX, and stocking levels seem to have improved. We are still not in XXX, and our sell-through information is good, but not good enough.
· We need to improve our relationship with XXX, which is second to XXX among [omitted] of personal computer software to retail channels.
5.6 Strategic Alliances
Product development: the emphasis in this plan is getting products developed and into the market, espec ially the new versions of Product X and Product Y.
Marketing: we need to watch sell-through and performance very carefully, to measure the results of our 1997 marketing push. Our first sales review in May seemed to indicate a successful launch, but we need to keep watching.
Finance: we are also looking to enhance our capital structure and management team.
5.7 Milestones
The milestones table and chart show the specific detail about ac tual program ac tivities that should be taking plac e during the year. Each one has its manager, starting date, ending date, and budget. During the year we will be keeping trac k of implementation against plan, with reports on the timely completion of these ac tivities as planned.
Supple Software
Page 21
Table: Milestones
Milestones
Milestone Start Date End Date Budget Manager Department
ProdX V3 2/1/1998 6/1/1998 $5,000 ABC Department
ProdY V2 6/15/1998 7/15/1998 $15,000 ABC Department
ProdZ Beta 9/15/1998 11/30/1998 $10,000 ABC Department
ProdX Packaging 2/1/1998 3/31/1998 $15,000 ABC Department
ProdX V3 Release 4/30/1998 6/16/1998 $10,000 ABC Department
ProdY V2 Release 8/15/1998 9/30/1998 $5,000 ABC Department
Seminar Promotion 3/1/1998 5/15/1998 $10,000 ABC Department
Upgrade Promotion 7/1/1998 8/15/1998 $50,000 ABC Department
Year-end Promotion 11/1/1998 12/15/1998 $25,000 ABC Department
Channel Rebate Program 10/14/1998 12/15/1998 $5,000 ABC Department
T otals $150,000
6.0 Management Summary
We are a small company owned and operated by Ralph and Mabel Smith, husband and wife, as a Subchapter S corporation. Ralph is the developer and designer of the products, and Mabel manages the office.
Management style reflec ts the participation of the owners. The company respects its community of co-workers and treats all workers well. We attempt to develop and nurture the company as community. We are not very hierarchical.
Supple Software
Page 22
6.1 Organizational Structure
Ralph Smith, President, is responsible for overall business management. Our managers of finance, marketing, and sales report direc tly to Ralph.
Jim Graham, programmer, is responsible for product design and development.
As co-owners, Ralph and Mabel jointly develop business strategy and long-term plans. Ralph is strong on product know-how and technology, and Mabel is strong on management and business know-how.
6.2 Management Team
· Ralph Smith: President and founder. Smith worked for 10 years in sales and marketing with Arrog International before returning to California to found what has become Supple Software. He was sales manager of the eastern region when he founded the original software distribution company. MBA from Stanford, MA with honors from University of Oregon, BA magna cum laude from the University of Notre Dame. Forty years old, married, five children.
· Allen Lombard: on board of direc tors. ______, _________. Previously General Manager for ________, where sales increased during his 1982-1987 management from less than $3 million to $29 million annually. MBA Harvard Business School, BS Stanford.
· Mabel Smith: Consultant, general manager. Was the manager of XYZ Lumber in Standard before being hired by Acme six years ago. BA in Business Administration, University of North Carolina.
· Henry Callahan: on board of direc tors. Well-known and respec ted public relations and advertising consultant based in Blank.
· Perry Masonjar: attorney and secretary of board. Founding attorney of _____, _________, Austec, and other start-ups.
· Linda Wilson: Marketing Coordinator. 25 years old. BA Marketing, _____________.
6.3 Management Team Gaps
· The present team is very weak on professional sales. · The present team, though strong on how to market at a high level, is short on prac tical
front-line marketing experience. · Product development requires a stable of entrepreneurial inventors willing to work for
royalties.
Supple Software
Page 23
6.4 Personnel Plan
Our people are compensated well, for the Ourtown market. Compensation includes complete HMO health c are for the employee and all dependents, plus a dental plan, plus a 401K with generous profit sharing, plus two weeks of vac ations. The atmosphere at work is enhanced by teambuilding ac tivities including river rafting, roller skating, pizza parties, etc.
We do expect to increase personnel significantly as sales increase.
Monthly personnel details for 1998 are in the appendix.
Table: Personnel
Personnel Plan
1998 1999 2000
Production Personnel
T echnical Support Manager $33,300 $37,000 $41,000
T echnical Support Staff $0 $25,000 $50,000
Other $0 $0 $0
Subtotal $33,300 $62,000 $91,000
Sales and Marketing Personnel
Marketing Manager $48,000 $53,000 $58,000
Other $0 $0 $0
Subtotal $48,000 $53,000 $58,000
General and Administrative Personnel
President $60,000 $66,000 $73,000
Office Manager $30,000 $33,000 $36,000
Other $0 $0 $0
Subtotal $90,000 $99,000 $109,000
Other Personnel
Development $30,300 $50,000 $100,000
Other $0 $0 $0
Subtotal $30,300 $50,000 $100,000
T otal People 5 7 8
T otal Payroll $201,600 $264,000 $358,000
7.0 Financial Plan
Ideally, we would want to bring in some equity investment from investors compatible with our growth plan, management style, and vision, in return for some equity ownership. We are not going to talk about specifics of a deal until we have met the right partners. This plan does not call for equity from outside investors.
If and when the time for outside investors comes, we want compatible investors or no investors at all. Compatibility means:
1. A fundamental respect for giving our customers value, and for maintaining a healthy and
Supple Software
Page 24
happy workplac e. 2. Respec t for realistic forec asts, and conservative cash flow and financial management. 3. Cash flow as first priority, growth sec ond, profits third. 4. Located in Oregon or the Northwest. 5. Willingness to follow the company carefully and contribute valuable input to strategy
and implementation dec isions.
Of these, only the last two are flexible.
We want to establish a mec hanism for employees to ac quire fair stock options that can become valuable as the company grows.
7.1 Important Assumptions
The financial plan depends on important assumptions, most of which are shown in the following table. The key underlying assumptions are:
· We assume a slow-growth economy, without major rec ession. · We assume of course that there are no unforeseen changes in tec hnology to make
products immediately obsolete. · We assume ac cess to equity capital and financing sufficient to maintain our financial
plan as shown in the tables.
7.2 Key Financial Indicators
The following chart shows changes in key financial indicators: sales, gross margin, operating expenses, collec tion days, and inventory turnover. The growth in sales is the most obvious change, and operating expenses with sales. We believe the growing market for our products, the larger potential market, justifies the growth projec tions.
We expect to maintain gross margin at a high level without major changes.
The projec tions for collec tion days and inventory turnover show that we are already expecting improvements as our increasing sales gives us greater economies of sc ale, and greater negotiation strength with our channel partners.
Supple Software
Page 25
7.3 Projected Profit and Loss
The following table shows that we expect to maintain gross margin but increase net profit margin during the next three years. The single most important fac tor in the improving profit margin is the economies of sc ale in our general and administrative expenses. These expenses should decline as a percentage of sales from 1998 to 2000.
We don't expect to dec rease sales and marketing expenses as a percent of sales. The packaged software business requires heavy marketing expenses.
We also intend to maintain and increase the percent of revenue spent on development. By 2000 we'll be spending almost 7% of sales on product development. This is the key to our future.
The following table shows just the annual numbers. The detailed monthly projec tions for 1988 are included in the appendix.
Supple Software
Page 26
Supple Software
Page 27
Supple Software
Page 28
Table: Profit and Loss
Pro Forma Profit and Loss
1998 1999 2000
Sales $1,032,920 $1,903,500 $3,744,000
Direct Cost of Sales $143,051 $305,468 $564,060
Production Payroll $33,300 $62,000 $91,000
Freight $20,546 $29,000 $33,800
Royalties $103,298 $197,550 $385,200
T otal Cost of Sales $300,195 $594,018 $1,074,060
Gross Margin $732,725 $1,309,483 $2,669,940
Gross Margin % 70.94% 68.79% 71.31%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $48,000 $53,000 $58,000
Advertising/Promotion $210,000 $400,000 $770,000
Sales Commissions $61,981 $118,530 $231,120
Graphics and Collaterals $35,000 $70,000 $140,000
Printing $28,700 $57,000 $114,000
Public Relations $14,400 $29,000 $58,000
Research $2,000 $4,000 $8,000
T ollfree T elephone $6,000 $12,000 $24,000
T rade Shows and Events $6,000 $12,000 $24,000
Meals $4,300 $9,000 $18,000
T ravel $12,800 $26,000 $52,000
Other Sales and Marketing Expenses $12,000 $24,000 $48,000
T otal Sales and Marketing Expenses $441,181 $814,530 $1,545,120
Sales and Marketing % 42.71% 42.79% 41.27%
General and Administrative Expenses
General and Administrative Payroll $90,000 $99,000 $109,000
Marketing/Promotion $0 $0 $0
Depreciation $1,000 $1,250 $1,563
Online Services $3,600 $4,500 $5,625
Contributions $300 $375 $469
Dues and Subscriptions $600 $750 $938
Maintenance and Repairs $1,800 $2,250 $2,813
Office Supplies $1,200 $1,500 $1,875
Postage $2,400 $3,000 $3,750
Professional Fees $6,000 $7,500 $9,375
T elephone $9,000 $11,250 $14,063
Rent $10,800 $13,500 $16,875
Utilities $3,000 $3,750 $4,688
Insurance $6,000 $7,500 $9,375
Payroll T axes $0 $0 $0
Other General and Administrative
Expenses
$0 $0 $0
T otal General and Administrative
Expenses
$135,700 $156,125 $180,409
General and Administrative % 13.14% 8.20% 4.82%
Other Expenses:
Other Payroll $30,300 $50,000 $100,000
Consultants $0 $0 $0
Product Development $1,200 $15,000 $100,000
Supple Software
Page 29
T otal Other Expenses $31,500 $65,000 $200,000
Other % 3.05% 3.41% 5.34%
T otal Operating Expenses $608,381 $1,035,655 $1,925,529
Profit Before Interest and T axes $124,344 $273,828 $744,411
EBIT DA $125,344 $275,078 $745,974
Interest Expense $1,734 $234 $234
T axes Incurred $36,783 $82,078 $223,253
Net Profit $85,828 $191,516 $520,924
Net Profit/Sales 8.31% 10.06% 13.91%
7.4 Break-even Analysis
Our break-even analysis is based on our cost and price structure at present. As we grow, the fixed costs will grow in proportion to our employee numbers.
Table: Break-even Analysis
Break-even Analysis
Monthly Units Break-even 1,055
Monthly Revenue Break-even $58,848
Assumptions:
Average Per-Unit Revenue $55.78
Average Per-Unit Variable Cost $7.73
Estimated Monthly Fixed Cost $50,698
Supple Software
Page 30
7.5 Projected Cash Flow
The following chart is most important for illustrating our cash projec tions for the next 12 months. Bec ause of our dependence on sales through channels, and the channels' tendency to pay slow, there are wide variations that must be supported with working capital ac quired through short-term credit on rec eivables and inventory.
The table shows just the annual results, which are less significant. The key to our business plan is the monthly cash flow table, in the appendix, which also shows up as the key numbers of the following chart.
Supple Software
Page 31
Supple Software
Page 32
Table: Cash Flow
Pro Forma Cash Flow
1998 1999 2000
Cash Received
Cash from Operations
Cash Sales $413,168 $761,400 $1,497,600
Cash from Receivables $656,182 $1,068,245 $2,090,263
Subtotal Cash from Operations $1,069,350 $1,829,645 $3,587,863
Additional Cash Received
Sales T ax, VAT , HST /GST Received $0 $0 $0
New Current Borrowing $20,000 $0 $0
New Other Liabilities (interest-free) $24,966 $0 $0
New Long-term Liabilities $0 $0 $0
Sales of Other Current Assets $0 $0 $0
Sales of Long-term Assets $0 $0 $0
New Investment Received $0 $0 $0
Subtotal Cash Received $1,114,316 $1,829,645 $3,587,863
Expenditures 1998 1999 2000
Expenditures from Operations
Cash Spending $201,600 $264,000 $358,000
Bill Payments $727,966 $1,413,737 $2,788,178
Subtotal Spent on Operations $929,566 $1,677,737 $3,146,178
Additional Cash Spent
Sales T ax, VAT , HST /GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $40,000 $0 $0
Other Liabilities Principal Repayment $34,453 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $50,000 $100,000
Dividends $0 $0 $0
Subtotal Cash Spent $1,004,019 $1,727,737 $3,246,178
Net Cash Flow $110,296 $101,908 $341,686
Cash Balance $110,921 $212,829 $554,515
Supple Software
Page 33
7.6 Projected Balance Sheet
The table shows the annual balance sheet results, with a healthy projec ted increase in net worth. Detailed monthly projec tions are in the appendix.
Table: Balance Sheet
Pro Forma Balance Sheet
1998 1999 2000
Assets
Current Assets
Cash $110,921 $212,829 $554,515
Accounts Receivable $87,627 $161,481 $317,618
Inventory $7,680 $66,268 $105,816
Other Current Assets $431 $431 $431
T otal Current Assets $206,658 $441,009 $978,379
Long-term Assets
Long-term Assets $35,577 $85,577 $185,577
Accumulated Depreciation $25,247 $26,497 $28,060
T otal Long-term Assets $10,330 $59,080 $157,517
T otal Assets $216,988 $500,089 $1,135,896
Liabilities and Capital 1998 1999 2000
Current Liabilities
Accounts Payable $32,140 $123,725 $238,608
Current Borrowing $2,336 $2,336 $2,336
Other Current Liabilities $16,039 $16,039 $16,039
Subtotal Current Liabilities $50,515 $142,100 $256,983
Long-term Liabilities $0 $0 $0
T otal Liabilities $50,515 $142,100 $256,983
Paid-in Capital $76,960 $76,960 $76,960
Retained Earnings $3,686 $89,514 $281,029
Earnings $85,828 $191,516 $520,924
T otal Capital $166,474 $357,989 $878,913
T otal Liabilities and Capital $216,988 $500,089 $1,135,896
Net Worth $166,474 $357,989 $878,913
7.7 Business Ratios
Standard business ratios are included in the following table. The ratios show a plan for balanced, healthy growth. One of the more important indicators is the increase in working capital, which is critical to our channel sales strategy and our financial health.
The ratios for collec tion days and inventory turnover are different than the ones in the assumptions table, because those are used as estimators to projec t balance sheet items for every month, while the ratios shown in this table are calculated on annual basis, using the
Supple Software
Page 34
same formulas used by our ac countants, after the fac t.
The standard comparisons are for NAICS code 511210, Software Publishers. We feel that they illustrate the difference between software publishing and most other publishing businesses.
Supple Software
Page 35
Table: Ratios
Ratio Analysis
1998 1999 2000 Industry Profile
Sales Growth 48.59% 84.28% 96.69% 15.97%
Percent of T otal Assets
Accounts Receivable 40.38% 32.29% 27.96% 17.27%
Inventory 3.54% 13.25% 9.32% 3.49%
Other Current Assets 0.20% 0.09% 0.04% 46.98%
T otal Current Assets 95.24% 88.19% 86.13% 67.74%
Long-term Assets 4.76% 11.81% 13.87% 32.26%
T otal Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 23.28% 28.41% 22.62% 31.28%
Long-term Liabilities 0.00% 0.00% 0.00% 20.91%
T otal Liabilities 23.28% 28.41% 22.62% 52.19%
Net Worth 76.72% 71.59% 77.38% 47.81%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 70.94% 68.79% 71.31% 100.00%
Selling, General & Administrative Expenses 63.47% 57.79% 56.20% 72.26%
Advertising Expenses 20.33% 20.25% 19.99% 1.67%
Profit Before Interest and T axes 12.04% 14.39% 19.88% 1.78%
Main Ratios
Current 4.09 3.10 3.81 1.58
Quick 3.94 2.64 3.40 1.22
T otal Debt to T otal Assets 23.28% 28.41% 22.62% 62.02%
Pre-tax Return on Net Worth 73.65% 76.43% 84.67% 3.40%
Pre-tax Return on Assets 56.51% 54.71% 65.51% 8.96%
Additional Ratios 1998 1999 2000
Net Profit Margin 8.31% 10.06% 13.91% n.a
Return on Equity 51.56% 53.50% 59.27% n.a
Activity Ratios
Accounts Receivable T urnover 7.07 7.07 7.07 n.a
Collection Days 61 40 39 n.a
Inventory T urnover 9.84 8.26 6.56 n.a
Accounts Payable T urnover 22.51 12.17 12.17 n.a
Payment Days 29 19 23 n.a
T otal Asset T urnover 4.76 3.81 3.30 n.a
Debt Ratios
Debt to Net Worth 0.30 0.40 0.29 n.a
Current Liab. to Liab. 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $156,144 $298,909 $721,396 n.a
Interest Coverage 71.73 1,172.21 3,186.69 n.a
Additional Ratios
Assets to Sales 0.21 0.26 0.30 n.a
Current Debt/T otal Assets 23% 28% 23% n.a
Acid T est 2.20 1.50 2.16 n.a
Sales/Net Worth 6.20 5.32 4.26 n.a
Supple Software
Page 36
Dividend Payout 0.00 0.00 0.00 n.a
Appendix
Page 1
Table: Sales Forecast
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Unit Sales
Product X 0% 500 1,600 1,100 900 2,500 1,800 1,500 900 1,100 1,400 1,300 500
Product Y 0% 325 365 325 295 315 285 285 235 145 145 145 111
Product Z 0% 110 110 110 110 110 110 110 110 110 110 110 110
Old Version Returns 0% 0 0 0 0 0 0 0 -450 -300 -150 0 0
OEM & Customization 0% 3 0 0 0 0 3 0 0 0 3 0 0
Other 0% 1 1 1 1 1 1 1 1 1 1 1 1
Total Unit Sales 939 2,076 1,536 1,306 2,926 2,199 1,896 796 1,056 1,509 1,556 722
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Product X $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35.00
Product Y $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00 $45.00
Product Z $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00 $325.00
Old Version Returns $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00 $95.00
OEM & Customization $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
Other $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00
Sales
Product X $17,500 $56,000 $38,500 $31,500 $87,500 $63,000 $52,500 $31,500 $38,500 $49,000 $45,500 $17,500
Product Y $14,625 $16,425 $14,625 $13,275 $14,175 $12,825 $12,825 $10,575 $6,525 $6,525 $6,525 $4,995
Product Z $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750 $35,750
Old Version Returns $0 $0 $0 $0 $0 $0 $0 ($42,750) ($28,500) ($14,250) $0 $0
OEM & Customization $3,000 $0 $0 $0 $0 $3,000 $0 $0 $0 $3,000 $0 $0
Other $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Total Sales $72,375 $109,675 $90,375 $82,025 $138,925 $116,075 $102,575 $36,575 $53,775 $81,525 $89,275 $59,745
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Product X 0.00% $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82 $7.82
Product Y 0.00% $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39 $8.39
Product Z 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
Old Version Returns 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
OEM & Customization 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
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
Product X $3,910 $12,512 $8,602 $7,038 $19,550 $14,076 $11,730 $7,038 $8,602 $10,948 $10,166 $3,910
Product Y $2,727 $3,062 $2,727 $2,475 $2,643 $2,391 $2,391 $1,972 $1,217 $1,217 $1,217 $931
Product Z $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Appendix
Page 2
Old Version Returns $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
OEM & Customization $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 Direct Cost of Sales $6,637 $15,574 $11,329 $9,513 $22,193 $16,467 $14,121 $9,010 $9,819 $12,165 $11,383 $4,841
Appendix
Page 3
Table: Personnel
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
Technical Support Manager $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775
Technical Support Staff $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,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775
Sales and Marketing Personnel
Marketing Manager $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
General and Administrative Personnel
President $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Office Manager $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Other Personnel
Development $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800
Appendix
Page 4
Table: Profit and Loss
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $72,375 $109,675 $90,375 $82,025 $138,925 $116,075 $102,575 $36,575 $53,775 $81,525 $89,275 $59,745
Direct Cost of Sales $6,637 $15,574 $11,329 $9,513 $22,193 $16,467 $14,121 $9,010 $9,819 $12,165 $11,383 $4,841
Production Payroll $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775 $2,775
Freight $1,201 $2,056 $1,651 $1,479 $2,694 $2,146 $1,921 $1,434 $1,516 $1,741 $1,666 $1,041
Royalties 10% $7,238 $10,968 $9,038 $8,203 $13,893 $11,608 $10,258 $3,658 $5,378 $8,153 $8,928 $5,975
Total Cost of Sales $17,851 $31,373 $24,793 $21,970 $41,555 $32,996 $29,075 $16,877 $19,488 $24,834 $24,752 $14,632
Gross Margin $54,524 $78,302 $65,582 $60,055 $97,370 $83,079 $73,500 $19,698 $34,287 $56,691 $64,523 $45,113
Gross Margin % 75.34% 71.39% 72.57% 73.22% 70.09% 71.57% 71.65% 53.86% 63.76% 69.54% 72.27% 75.51%
Operating Ex penses
Sales and Marketing Ex penses
Sales and Marketing Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Advertising/Promotion $10,000 $20,000 $20,000 $20,000 $30,000 $20,000 $20,000 $10,000 $10,000 $20,000 $20,000 $10,000
Sales Commissions 6% $4,343 $6,581 $5,423 $4,922 $8,336 $6,965 $6,155 $2,195 $3,227 $4,892 $5,357 $3,585
Graphics and Collaterals $1,000 $1,000 $30,000 $2,000 $0 $0 $0 $500 $0 $0 $500 $0
Printing $2,200 $500 $500 $18,000 $5,000 $0 $0 $500 $500 $500 $500 $500
Public Relations $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Research $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,000
Tollfree Telephone $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Trade Shows and Events $2,000 $0 $0 $0 $2,000 $0 $0 $0 $0 $2,000 $0 $0
Meals $650 $250 $250 $250 $750 $450 $250 $250 $250 $250 $450 $250
Travel $2,000 $400 $400 $400 $2,000 $1,000 $500 $500 $1,700 $1,700 $500 $1,700
Other Sales and Marketing
Ex penses
$1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Sales and Marketing
Ex penses
$28,893 $35,431 $63,273 $52,272 $54,786 $35,115 $33,605 $20,645 $22,377 $36,042 $34,007 $24,735
Sales and Marketing % 39.92% 32.31% 70.01% 63.73% 39.44% 30.25% 32.76% 56.45% 41.61% 44.21% 38.09% 41.40%
General and Administrative Ex penses
General and Administrative Payroll $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Marketing/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000
Online Services $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Contributions $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Dues and Subscriptions $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Maintenance and Repairs $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Appendix
Page 5
Office Supplies $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Postage $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Professional Fees $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Telephone $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Rent $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Tax es 10% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative
Ex penses
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative
Ex penses
$11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $11,225 $12,225
General and Administrative % 15.51% 10.23% 12.42% 13.68% 8.08% 9.67% 10.94% 30.69% 20.87% 13.77% 12.57% 20.46%
Other Ex penses:
Other Payroll $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525 $2,525
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Product Development $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Other Ex penses $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625 $2,625
Other % 3.63% 2.39% 2.90% 3.20% 1.89% 2.26% 2.56% 7.18% 4.88% 3.22% 2.94% 4.39%
Total Operating Ex penses $42,743 $49,281 $77,123 $66,122 $68,636 $48,965 $47,455 $34,495 $36,227 $49,892 $47,857 $39,585
Profit Before Interest and Tax es $11,781 $29,021 ($11,541) ($6,067) $28,734 $34,114 $26,045 ($14,797) ($1,940) $6,799 $16,666 $5,528
EBITDA $11,781 $29,021 ($11,541) ($6,067) $28,734 $34,114 $26,045 ($14,797) ($1,940) $6,799 $16,666 $6,528
Interest Ex pense $186 $186 $186 $186 $186 $353 $353 $19 $19 $19 $19 $19
Tax es Incurred $3,479 $8,650 ($3,518) ($1,876) $8,564 $10,128 $7,708 ($4,445) ($588) $2,034 $4,994 $1,652
Net Profit $8,117 $20,184 ($8,209) ($4,377) $19,984 $23,633 $17,984 ($10,371) ($1,371) $4,746 $11,653 $3,856
Net Profit/Sales 11.21% 18.40% -9.08% -5.34% 14.38% 20.36% 17.53% -28.36% -2.55% 5.82% 13.05% 6.45%
Appendix
Page 6
Table: Cash Flow
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $28,950 $43,870 $36,150 $32,810 $55,570 $46,430 $41,030 $14,630 $21,510 $32,610 $35,710 $23,898
Cash from Receivables $62,028 $63,476 $44,171 $65,419 $54,058 $50,353 $82,898 $69,375 $60,225 $22,289 $32,820 $49,070
Subtotal Cash from Operations $90,978 $107,346 $80,321 $98,229 $109,628 $96,783 $123,928 $84,005 $81,735 $54,899 $68,530 $72,968
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 $0 $0 $0 $0 $0 $20,000 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $2,132 $6,313 $0 $0 $6,146 $0 $5,546 $0 $0 $866 $3,327 $636
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $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 $93,110 $113,659 $80,321 $98,229 $115,774 $116,783 $129,474 $84,005 $81,735 $55,765 $71,857 $73,604
Ex penditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Ex penditures from Operations
Cash Spending $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800
Bill Payments $37,918 $41,722 $68,146 $76,797 $69,221 $114,531 $69,206 $63,854 $25,014 $40,014 $62,473 $59,071
Subtotal Spent on Operations $54,718 $58,522 $84,946 $93,597 $86,021 $131,331 $86,006 $80,654 $41,814 $56,814 $79,273 $75,871
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 $0 $0 $0 $0 $0 $0 $0 $40,000 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $20,000 $0 $0 $0 $0 $4,453 $10,000 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $54,718 $58,522 $104,946 $93,597 $86,021 $131,331 $86,006 $125,107 $51,814 $56,814 $79,273 $75,871
Net Cash Flow $38,392 $55,136 ($24,625) $4,632 $29,753 ($14,548) $43,468 ($41,102) $29,921 ($1,049) ($7,416) ($2,267)
Cash Balance $39,017 $94,154 $69,529 $74,161 $103,914 $89,366 $132,834 $91,732 $121,653 $120,605 $113,189 $110,921
Appendix
Page 7
Table: Balance Sheet
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $625 $39,017 $94,154 $69,529 $74,161 $103,914 $89,366 $132,834 $91,732 $121,653 $120,605 $113,189 $110,921
Accounts Receivable $124,056 $105,453 $107,783 $117,837 $101,633 $130,930 $150,222 $128,869 $81,439 $53,479 $80,105 $100,850 $87,627
Inventory $28,623 $21,986 $17,132 $12,462 $10,464 $24,412 $18,114 $15,533 $9,911 $10,800 $13,381 $12,521 $7,680
Other Current Assets $431 $431 $431 $431 $431 $431 $431 $431 $431 $431 $431 $431 $431
Total Current Assets $153,735 $166,888 $219,499 $200,258 $186,689 $259,687 $258,133 $277,667 $183,512 $186,363 $214,521 $226,990 $206,658
Long-term Assets
Long-term Assets $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577 $35,577
Accumulated Depreciation $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $24,247 $25,247
Total Long-term Assets $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $11,330 $10,330
Total Assets $165,065 $178,218 $230,829 $211,588 $198,019 $271,017 $269,463 $288,997 $194,842 $197,693 $225,851 $238,320 $216,988
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $36,557 $39,461 $65,575 $74,543 $65,351 $112,220 $67,033 $63,036 $23,706 $37,928 $60,474 $57,963 $32,140
Current Borrowing $22,336 $22,336 $22,336 $22,336 $22,336 $22,336 $42,336 $42,336 $2,336 $2,336 $2,336 $2,336 $2,336
Other Current Liabilities $25,526 $27,658 $33,971 $13,971 $13,971 $20,117 $20,117 $25,663 $21,210 $11,210 $12,076 $15,403 $16,039
Subtotal Current Liabilities $84,419 $89,455 $121,882 $110,850 $101,658 $154,673 $129,486 $131,035 $47,252 $51,474 $74,886 $75,702 $50,515
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $84,419 $89,455 $121,882 $110,850 $101,658 $154,673 $129,486 $131,035 $47,252 $51,474 $74,886 $75,702 $50,515
Paid-in Capital $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960 $76,960
Retained Earnings $36,668 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686 $3,686
Earnings ($32,982) $8,117 $28,301 $20,092 $15,715 $35,698 $59,331 $77,315 $66,944 $65,573 $70,319 $81,972 $85,828
Total Capital $80,646 $88,763 $108,947 $100,738 $96,361 $116,344 $139,977 $157,961 $147,590 $146,219 $150,965 $162,618 $166,474
Total Liabilities and Capital $165,065 $178,218 $230,829 $211,588 $198,019 $271,017 $269,463 $288,997 $194,842 $197,693 $225,851 $238,320 $216,988
Net Worth $80,646 $88,763 $108,947 $100,738 $96,361 $116,344 $139,977 $157,961 $147,590 $146,219 $150,965 $162,618 $166,474