Web Solutions, Inc.
Executive Summary
Web Solutions, Inc. (Web Solutions) is an Internet Service Provider (ISP) based in Phoenix, Arizona. The company offers the following services to its customers:
- Dialup and dedicated Internet access (up to 64 Kbps).
- High bandwidth Internet access (128 Kbps).
- Integrated Services Digital Network (ISDN).
- Digital Subscriber Line (DSL).
- Wireless.
- Website and virtual domain hosting.
- Server co-location.
- Network design, installation, and administration services.
- Web design (currently outsourced).
Web Solutions is a company driven to provide customers with a complete solution to their entire current and future Internet and private network needs. The company’s customer base includes all consumers and all small- to medium-sized businesses, including start-ups.
Web Solutions benefits from several strategic alliances by receiving very competitive pricing on most services, allowing the company to offer competitive pricing on its services to customers.
ISPs offer a way for people to enter the Internet. According to International Data Corporation (IDC), an information technology research and consulting firm located in Framingham, Massachusetts, the consumer ISP market will expand from $10.7 billion in 1998 to $37 billion in 2003.
Competitive threats come from other ISPs located in or around Phoenix, including the following companies: Jump.Net, Arizona.Net, EarthLink, and Mindspring. Most competitors offer solutions for Windows, and perhaps Macintosh, but ignore all other operating systems. With the rise of Linux and other alternative operating systems, there is potential for Web Solutions to surpass its competitors.
Web Solutions has a world-class management team with direct knowledge of the industry, extensive research experience, and unique administration skills. Its team includes Mr. Jason Williams, Mrs. Amy Williams, and Ms. Geena James.
Projected revenues for 2000 through 2002 substantial steady growth. The company is seeking a major investment to fund four areas of growth in the company:
- Increase personnel to handle sales, service, and development efforts.
- Increase marketing to assure future customers are aware of our offerings and aggressive pricing.
- Expand our base of operations (using wholesale providers, partnerships, and other mechanisms) to include at least the top 100 U.S. markets for dialup and dedicated Internet access.
- Perform research and development to bring new products to market.
1.1 Mission
The mission of Web Solutions is to provide customers with a complete solution to all their current and future Internet and private network needs.
Web Solutions has established a reputation for quality work and plans to continue to enhance its image in the industry. The company seeks to become a well-known and respected provider of advanced network solutions by:
- Increasing service offerings.
- Increasing availability and accessibility to current and future customers.
- Creating innovative, unique, and cost-effective solutions to problems currently faced by customers.
Company Summary
Web Solutions, Inc. is a C-class corporation, incorporated in the State of Arizona in July, 1997. The company’s principal offices are currently located in Phoenix, AZ. All operations, from administration to product development, take place at this leased office location. The company plans to move to a bigger facility as it expands and its staff grows beyond its current four full-time employees.
Past Performance | |||
1997 | 1998 | 1999 | |
Sales | $550,000 | $825,000 | $1,237,500 |
Gross Margin | $490,000 | $765,000 | $1,177,500 |
Gross Margin % | 89.09% | 92.73% | 95.15% |
Operating Expenses | $160,100 | $180,100 | $200,100 |
Collection Period (days) | 0 | 0 | 0 |
Balance Sheet | |||
1997 | 1998 | 1999 | |
Current Assets | |||
Cash | $50,050 | $75,075 | $112,613 |
Accounts Receivable | $10,875 | $15,400 | $23,500 |
Other Current Assets | $15,400 | $23,100 | $34,650 |
Total Current Assets | $76,325 | $113,575 | $170,763 |
Long-term Assets | |||
Long-term Assets | $147,400 | $221,100 | $331,650 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $147,400 | $221,100 | $331,650 |
Total Assets | $223,725 | $334,675 | $502,413 |
Current Liabilities | |||
Accounts Payable | $50,750 | $65,125 | $70,688 |
Current Borrowing | $40,150 | $60,225 | $90,337 |
Other Current Liabilities (interest free) | $0 | $0 | $0 |
Total Current Liabilities | $90,900 | $125,350 | $161,025 |
Long-term Liabilities | $287,100 | $430,650 | $645,975 |
Total Liabilities | $378,000 | $556,000 | $807,000 |
Paid-in Capital | $0 | $0 | $0 |
Retained Earnings | ($154,275) | ($221,325) | ($304,587) |
Earnings | $0 | $0 | $0 |
Total Capital | ($154,275) | ($221,325) | ($304,587) |
Total Capital and Liabilities | $223,725 | $334,675 | $502,413 |
Other Inputs | |||
Payment Days | 0 | 0 | 0 |
Sales on Credit | $0 | $0 | $0 |
Receivables Turnover | 0.00 | 0.00 | 0.00 |
Services
Web Solutions currently delivers Internet service to dialup and ISDN customers, and will commence to sell DSL services by February of this year. The company currently hosts approximately 30 websites and has five co-located servers. Additionally, the company is evaluating e-commerce software, looking for the solution which provides the greatest flexibility while allowing operations to remain simple for its customers.
All services are competitively price and targeted to small “Mom-and-Pop” businesses and small office/home office (SOHO) customers. Web Solutions feels that this market segment has largely been neglected because of the amount of “hand-holding” required by this segment, and the inability to pay the astronomical fees charged by many ISPs for typically poor service and user support.
By working to simplify the creation, management, and support of our services, the company will enable customers to perform many tasks themselves, or automating these tasks based on the customer’s stated needs. This will make our pricing more competitive, the customers perception of service high, and the operation as a whole more reliable and profitable.
With current hardware and facilities, the company can do the following:
- Handle an unlimited number of dialup users.
- Handle up to 46 dedicated channels.
- Handle up to 1,000 email users.
3.1 Service Description
Web Solutions is a traditional, full-service ISP, offering dialup and dedicated Internet access, Web and virtual domain hosting, server co-located, and network-related professional solutions (design, installation, management, etc.). The company allows people and companies to access and publish documents on the World Wide Web without the need to hire full-time system administrators, costly high-speed network connections, dedicated servers, and other similar expenses or expertise.
The company provides many of the services that customers need to get online. The company provides both connectivity and consulting on topics ranging from office automation to Web server planning. The company has ongoing research and development to provide solutions to current customer issues (e-commerce, ease-of-use features, etc.) and to develop new products and services which enable the company to enter and compete in new markets and attract new customers.
Web Solutions selects products which meet the following criterion:
- Benefit to customers/company: the product must materially benefit the customer or the company in some way. This may manifest itself as a side benefit, an improvement on current services, or additional revenue stream to the company.
- Cost/benefit ratio: the benefits realized must be at least as great as the cost of implementation, production, and maintenance of the product.
- Maintainability: the product must be maintainable by PhoenixARIZONA.COM personnel. The company has had some experience with products where source code and other maintenance resources are unavailable and has had major difficulties with these restrictions. The company has a strong preference for Open Source and similar distribution methods where source code is available to personnel to correct problems which vendors consider too unimportant to warrant effort on.
Web Solutions makes a concerted effort to keep customers informed and to remedy problems in the shortest possible times. The company has lost very few customers to technical support issues, and will continue to make high quality support one of its primary goals.
Web Solutions offers telephone support during extended business hours (8 a.m. to 8 p.m.) and has an on-call pager for emergencies (network-down and server-down situations). In the future, the company plans to implement a 24/7 network operations center (NOC) and a toll-free technical support phone number.
When the voice/video/data (VVD) product goes into production, the company plans to have constant monitoring of network connectivity and take preemptive measures to solve developing problems before the customer even notices them. For instance, if it is determined that there is a failing component on the customer’s premise equipment, it would trigger a call to the customer and the scheduling of a replacement part before the customer even realizes that the problem exists.
3.2 Fulfillment
Currently, all products are implementations of Open Source products. The groupware product will be based upon OpenDesk.com’s software, which is available under an Open Source license. Web Solutions will be extending the functionality of this product, and release those changes back to the development community.
With the VVD product, the company will have to design and manufacture custom equipment for customers to receive the data and convert it to video or voice.
Currently, the company has no products to return. The company’s usage policy states that it will refund a portion of the customers’ monthly access fee if there are extended network outages due to events within our control.
The company gives technical advice to pre-sales customers and technical support is offered for all purchases by the customer. These services are offered by Web Solutions at no cost to our clientele.
3.3 Future Services
Free (advertiser supported) back-office service with email, file sharing, calendaring/scheduling, and other applications are options for future services from Web Solutions. This would allow groups (both for-profit and nonprofit) to have the collaboration enjoyed by major corporations with multimillion-dollar management information systems (MIS) budgets for little or no cost. It also would produce an avenue through which to offer future free and pay services.
Web Solutions plans to have the initial launch of the back-office product by March 31st. The company currently has a potential customer (a local radio station) who wishes to privately brand this product and offer it to their customers.
Web Solutions is in the process of researching a future service of integrated voice, video, and data over high speed TCP/IP network connections (DSL, etc.) so as to merge the traditional telephone, cable, and ISP functionalities, extend them, and affordably offer them to consumers. This product would compete directly with traditional cable and telephone companies, and provide new and innovative revenue streams. Current plans for this product are to price the consumer product very aggressively and take the profit from secondary services such as advertising. Web Solutions plans to have a working prototype of the server and clients needed for the VVD product by October 1, 2000, and a limited launch by March 1, 2001.
Market Analysis Summary
The topics which follow discuss our customers, our competitors, and conditions within our industry. The Market Analysis data found in the following table and chart is taken from the 1997 U.S. Census.
4.1 Market Segmentation
The company’s customer base includes all consumers and all small- to medium-sized businesses, including start-ups. The company plans to concentrate on SOHO clients, as these are perfect targets for our new high-speed offerings, and hold the greatest growth potential for the company. Web Solutions feels that these market segments have special pricing and service needs, and make more dedicated, reliable customers.
Market Analysis | |||||||
2000 | 2001 | 2002 | 2003 | 2004 | |||
Potential Customers | Growth | CAGR | |||||
Household Consumers | 10% | 101,041,000 | 111,044,059 | 122,037,421 | 134,119,126 | 147,396,919 | 9.90% |
Small Office/Home Office | 3% | 16,963,070 | 17,404,110 | 17,856,617 | 18,320,889 | 18,797,232 | 2.60% |
Total | 8.94% | 118,004,070 | 128,448,169 | 139,894,038 | 152,440,015 | 166,194,151 | 8.94% |
4.2 Service Business Analysis
The following sub-topics look at the size and concentration of businesses in this group, the way services are bought and sold, and specific competitors.
4.2.1 Competition and Buying Patterns
Web Solutions believes that its customers choose its products and services based on the following criteria:
- Price.
- Experience.
- Reputation.
- Service.
- Accessibility.
4.2.2 Main Competitors
Competitive threats come from other ISPs, including the following companies: Jump.Net, Arizona.Net, AOL, EarthLink, Mindspring, and Prodigy Internet. Most of our competitors offer solutions for Windows, and perhaps Mac, but ignore all other operating systems. With the rise of Linux and other alternative operating systems, there is potential for Web Solutions to surpass its competitors.
Key competitors are detailed as follows:
Jump.Net
Jump.Net offers a wide variety of services to match customer needs. They have split information into two categories:
- Basic service: for customers looking for a simple, inexpensive way to connect their home or business to the Internet.
- Complete details: for customers who need a custom solution for unique requirements, Jump.net offers the following services:
- Connectivity:
- ADSL & SDSL.
- Modem service.
- ISDN.
- Nationwide access.
- Special Services:
- Functionalities.
- FTP services.
- Hardware sales.
- Leased lines.
- Telnet-only service.
- Web hosting.
Arizona.Net
Arizona.Net is San Antonio’s first and largest ISP. Locally owned and operated since 1994, Arizona.Net specializes in modem dial-up, ISDN, dedicated local area network (LAN) access and T1 (a high-speed network link that transmits data at 1.5 Mbps) to the Internet. Arizona.Net now serves Phoenix, San Antonio, Houston, Dallas, Spring, Georgetown, Dripping Springs, Bandera, New Braunfels, and Boerne.
For dialup connections, Arizona.Net uses an all-digital modem pool consisting of equipment from US Robotics, Ascend, and Livingston. All of their locations maintain a full 56k modem pool, upgraded to the latest version of the v.90 standard. These digital modems allow for a more reliable connection, and enable them to make ISDN connections on the same equipment, so they can offer 64k ISDN service with all dialup accounts. To make sure that customers can get to their services, Arizona.Net maintains a no-busy-signal policy.
If customers report a busy signal, Arizona.Net has the ability to connect as many telephone lines as necessary to relieve the problem. Currently, none of their locations are having any problems with busy signals. Arizona.Net maintains multiple separate T3 (a high-speed network link that transmits data at 45 Mpbs) connections to the Internet backbone through multiple backbone providers. These separate connections give Arizona.Net more than enough bandwidth to handle future growth as well as provide the security of uninterrupted service.
EarthLink
EarthLink helps its members have an enjoyable and productive Internet experience by providing reliable, unlimited Internet access and Web hosting services, outstanding technical support, useful information, and innovative services. Prices are among the lowest in the industry. EarthLink offers the following services:
- Internet access.
- High-speed access.
- Web hosting.
- EarthLink Sprint bundle.
Mindspring
MindSpring Biz delivers complete Business Internet Solutions for any small business backed with its award winning service and support. Its business plans–whether Web Hosting, e-commerce, high speed dedicated access, or Web Design–are packaged to fit customer needs today and are tailored to grow along with business for tomorrow. Mindspring offers the following business solutions:
- Web hosting.
- Business access.
- E-commerce.
- Domain reservation.
- Dedicated access.
- MindSpring dialup access.
- SDSL Waiting Lis.
- Promotional solutions.
- Help desk.
4.2.3 Risks
The company recognizes that it is subject to both market and industry risks. The company’s view of its risks, as well as how each is being addressed, is as follows:
- Regulations. Possible problems caused by a sudden increase in regulation by local, State, or Federal authorities. One way the company can reduce this risk is to diversify into several different, but related, business areas. If one area becomes too heavily regulated it may be sold and the profit rolled back into the company to bolster the remaining business or start a new venture.
- Monopolistic pricing. Aggressive or monopolistic pricing by large or heavily-funded providers. By holding prices down, it becomes difficult for competitors to “low-ball” the company. By diversifying, we can protect business in one area by bundling it with offerings from another area, meeting the needs of the customers and strengthening their ties to the company.
- Legal matters. Lawsuits stemming from user abuse or accessibility of pornographic or questionable materials. The courts have historically classified ISP’s as “carriers” unless the ISP made an incomplete effort to actively filter material posted by or made available to its users. The company’s usage policy clearly states that illegal behavior will result in termination of service, but we do not otherwise attempt to control the access of its users or their content, thus maintaining the company’s stance as a “carrier” in the eyes of the law. If the legal environment should change, the company will modify its policies and procedures to conform to the prevailing legal environment.
- Technology. Sudden and unexpected shifts in technology or the popularity of the Internet. The company will maintain an active research and development effort, as well as ongoing review of forthcoming technologies from competitors and vendors, in order to stay near the top of the technological curve. Also, the diversification of the company’s business allows it to respond to shifts in revenue by redistributing material and personnel into those efforts most likely to generate the highest return on investment.
4.2.4 Business Participants
The company is competing in the low-cost Internet access and website hosting niche of the industry. The industry is moving in the direction of a fusion of VVD services over a single common media (ref. The AOL-Time/Warner merger). This is where all media players must move in order to compete in the coming decade.
The alternative is to be a content provider. This is a less desirable position as it leaves the company too much at the whim of the public and forces the company to renew its efforts continuously to provide usable content.
The ISP industry has begun the process of specialization. Many companies who began by filling all needs (as we do today) have moved into areas which utilize their strengths. These specializations include:
- Functionalities (“Server Hotel”) facilities.
- Web hosting.
- Dialup access.
- Content provision.
Additionally, there are a few new markets emerging, such as Applications Service Providers.
- Access services ISPs offer a way for people to enter the Internet. According to IDC, America Online (including subscribers to CompuServe, which AOL acquired in September, 1997), has approximately a 43% share of the total subscribers in the ISP segment, followed by Microsoft’s MSN, and AT&T Corporation’s WorldNet. After these major players, roughly 5,000 ISPs fight over the remainder of the market. IDC estimates that the consumer ISP market will expand from $10.7 billion in 1998 to $37 billion in 2003.
When users access the Internet, they dial into the local point of presence (POP) of an ISP or online service provider (OSP). ISPs offer basic, flat-rate Internet access to customers, either through their own networks, or through networks leased from other ISPs. Users dial into an ISP’s network through ordinary phone lines and, using a browser, access the Web. OSPs, such as America Online, provide original content in areas such as shopping, news groups, gaming groups, investor information, and magazines.
Access fees for both ISPs and OSPs typically range from $19.95 to $21.95 per month for unlimited Internet use. The flat rate system was pioneered by America Online in 1996 and has led to an explosion of subscribers. Flat rates have also served to increase the amount of time that users spend online, which has forced many local telephone service companies to upgrade capacity in order to accommodate the heavy usage. - A taxing issue One nettlesome issue that could potentially slow the growth of e-commerce is the taxation of goods and services. Currently, fees paid to ISPs and OSPs are tax-free, except in a few states. Purchases, however, are subject to the same taxes that apply to goods sold in a store or catalog. When online purchases are made, purchasers are technically responsible for remitting state and local taxes. The only exception occurs when a consumer buys from a corporation with a physical presence in that consumer’s home state. In actuality, however, online shoppers rarely pay this cyber-taxation.
While state and local governments are disturbed at this loss of revenue–and the potential loss of immense future revenue–federal governmental officials have adopted a hands-off policy with regard to Internet taxation. In October, 1998, the Internet Tax Freedom Act was passed, placing a three-year ban on any new Internet sales taxes or taxes on ISPs. During this three-year time frame, a committee of government and business representatives known as The Advisory Commission on Electronic Commerce will meet to discuss a more permanent tax policy. The 19 members of the commission include three federal officials, eight business and consumer leaders, and eight representatives of state and local governments. - ISPs face challenges The rise in Internet users has proven to be a boon for Internet service providers, which charge monthly subscription fees in return for providing access. While business has been good for many of these ISPs, a number of challenges threaten the long-term growth and profitability of these companies.
- Broad access becomes more prevalent Today, most residential Internet users gain access to the Web via commonplace copper telephone wires. Download speeds are limited to a maximum 56 Kbps and are often significantly slower than that, resulting in frustration among impatient Web surfers. The lack of speed has provided an opportunity for broadband service providers to gain market share. LLC’s RoadRunner, which provides high-speed online access, has begun to attract users who desire more speed and are willing to pay a higher price. As of the second quarter of 1999, cable modem users numbered over 1 million, still a small percentage of total Internet users, but growing very rapidly.
- “Free” Internet access proves viable While most headlines or advertisements proclaiming free Internet service are actually a bit misleading, the impact of this business model is starting to be felt. The most prominent and successful example of a free ISP is in the United Kingdom, where Freeserve plc does not charge its customers access fees. Unlike the United States, however, local calls in the United Kingdom are billed on a per-minute basis, so heavy Internet users may actually pay more than in the United States.
In the United States, different types of “free” plans are being marketed. One strategy gives a subscriber free service in exchange for having advertisements scroll constantly across his or her PC screen. A different slant to this marketing scheme allows a consumer to earn a free personal computer, provided that he or she signs up for a few years of Internet service in advance.
The following is a list of services which various websites provide:
- Destinations. Destinations are places, or websites, located on the Internet where people can go for information, entertainment, or commerce.
- Content providers. This type of website offers mostly original content (like news articles) to subscribers. Some of the major content providers include ESPN Sports Zone (a joint venture between Infoseek Corp. and Walt Disney Co.), SportsLine USA Inc., privately held The Motley Fool Inc., and MSNBC (a joint venture between Microsoft and NBC). With new websites being established every day, it’s difficult to come up with a reasonable estimate for the size of this market.
- Portals. These websites tend to gather content into one place rather than creating it themselves. Some of the major portals include Yahoo! Inc. (1998 sales of $206 million), Infoseek Corporation ($63 million in fiscal year 1998), and Lycos Inc. ($56 million in fiscal year 1998). Although e-commerce has started to become a larger promotion of these companies’ business, portals typically rely on the sale of advertising space to generate revenue.
According to Jupiter Communications, a market research firm based in New York City, advertisers spent approximately $2 billion for online ads in 1998. Jupiter believes that this number will hit $9 billion in 2002. - Communities. Communities are similar to portals, in that their primary revenue streams come from advertisers. Some of the major community sites include Geocities (1998 sales of $18.4 million), now a part of Yahoo! Xoom.com Inc. ($8.3 million), and theglobe.com Inc. ($5.5 million).
- Business-to-consumer e-commerce. Estimates for the amount of online spending by consumers in 1998 range from $7 billion to $13 billion, with at least 25% occurring during the Christmas shopping season. Forrester Research, an information technology research firm in Cambridge, Massachusetts, believes that online retail spending will hit $108 billion in 2003.
Some of the major publicly traded online retailers included Amazon.com Inc. (1998 sales of $610 million), CDnow Inc. ($98 million), barnesandnoble. com Inc. ($62 million), and Beyond.com corp. ($37 million). A variety of “real-world” companies including Gap Inc., Lands’ End Inc., and Macy’s have established retail operations on the Internet. - Business-to-business e-commerce. Although there are very few pure business-to-business e-commerce firms, this segment dwarfs the business-to-consumer sector. Forrester believes that this market, which totaled $43 billion in 1998, should rise to $1.3 trillion by 2003.
Most companies in this category, like Cisco Systems and Dell Computer Corporation, have other sales channels, but are increasingly using the Internet to lower costs and reach a wider customer base. Dell generates an estimated $30 million in sales every day via the Internet, while Cisco estimates that it produces approximately $33 million a day in sales through the Internet. - Auctions. The online market for auctions is headed by eBay Inc., (1998 revenues of $86.1 million, with $745 million of gross merchandise sales).
- Hardware: networking equipment. The hardware sector provides the infrastructure on which the Internet is built. Hardware companies provide the equipment that forms the interconnections between the networks that comprise the Internet. Their products steer traffic through a spiderweb of routes to the correct destination. One critical piece of networking equipment is the router, which acts as a traffic officer by directing data to the proper destination. Another key element of the Internet infrastructure is a remote access concentrator. Access concentrators link employees and customers to an organization’s internal network, and link consumers to the Internet via their ISP.
Strategy and Implementation Summary
The Web Solutions strategy is to achieve name recognition and attract customers by aggressively pricing its services. Once customers have been acquired, the company will seek to offer them additional services which will increase margins and provide them with useful solutions they would not otherwise find.
The company will also implement a low-cost strategy. This will be achieved by working to establish and develop agreements with local media companies to exchange services for discounted advertising and other exposures. Web Solutions’ market strategy is to build on its core portfolio of products and services using the company’s expertise in the ISP industry.
The company will leverage its discounted services to help provide secondary income streams. For instance, the company plans to launch free email services, business directories, and other similar services which will attract current and potential customers to our Web pages. These “page views” will be used to generate advertising revenue, as well as increase exposure of our own products and services.
Web Solutions will be able to excel in the market because the company is small, highly focused, and motivated. The company can respond quickly to changing opportunities and take advantage of the latest technologies.
The company plans to expand its marketing efforts, service offerings, and production. It is anticipated that additional services will be offered and more personnel hired within 30 days of initial capital funding. Web Solutions plans to capitalize on the following areas of growth:
- High-speed Internet connectivity via DSL, Wireless, and other technologies.
- Web hosting and design tailored to small, local businesses.
- E-commerce and associated online databases.
5.1 Competitive Edge
Web Solutions is currently the lowest-priced provider in Phoenix for most commercial services, and its reputation has been consistently high. Size gives the company a competitive advantage, in that it can see where the industry is going and move in that direction more quickly than the competition. This also allows the company to be more efficient at recruiting and hiring highly creative and talented individuals who tend to shy away from large “corporate” environments. The company has worked to overcome old mistakes made by existing ISPs by hiring technically-savvy individuals.
5.2 Marketing Strategy
The concentrated marketing activities of Web Solutions focus on the business mission and are comprehensive in nature. The following activities are the marketing department’s mission:
- Advertising design and placement.
- Public relations schedules and press releases throughout each year.
- Creation of annual advertorial (advertisement/tutorial) themes for trade journals and industry conferences.
- Planning and execution of all industry conferences, including the reservation of space, booths, personnel, messages, literature, etc.
- Collection, analysis, and internal dissemination of competitive information.
- Creation and maintenance of all corporate literature.
- Design, maintenance, and monitoring of websites.
- Design and creation of sales support material.
- Collection and dissemination of client testimonials.
5.2.1 Marketing Programs
To generate sales, the company uses direct marketing, computer reseller and repair facilities, and high-traffic areas (e.g. store checkout stands). Currently, several local companies display the company’s CD-ROMs at their checkout stands in the Phoenix area in exchange for free Web hosting.
Marketing initiatives will focus on four areas: efficient (“Server Hotel”) facilities, Web hosting, dialup access, and content provision. Marketing activities will be concentrated in the following categories:
- Contact Campaigns. This initiative will encompass various methods of reaching potential customers to generate interest, followed by direct mail to the potential customer.
- Print Advertising. Ads will be developed and placed in several industry publications.
- Trade Shows. The company will participate in selected local and national shows that will provide an opportunity to develop exposure. This is a very effective tool in creating awareness and stimulating lead activity.
- Industry Organizations and Associates. The recommendation is to join a number of organizations that are relevant to the company as a whole. This initiative will create awareness of the company within the industry, and provide networking opportunities.
- Telemarketing Campaign. Telemarketing activities geared to identify qualified leads, follow-up on sales progress to the qualified leads, and assurance that new potential contact lists are current and accurate.
- Promotional GiveAways. This is a traditional way of advertising a company’s name by giving something away. This will be used in conjunction with community service organization fund-raising efforts and traditional advertising.
5.3 Sales Forecast
The sales forecast chart and table are presented below. Final sales forecasts are based on predictions mentioned in the Executive Summary.
Sales Forecast | |||
2000 | 2001 | 2002 | |
Sales | |||
Dialup Internet Access | $1,155,000 | $3,015,000 | $4,275,000 |
High-bandwidth Internet Access | $105,000 | $765,000 | $2,025,000 |
Website and Virtual Domain Hosting | $45,000 | $135,000 | $225,000 |
Network Services | $75,000 | $225,000 | $375,000 |
Server Colocation | $75,000 | $225,000 | $375,000 |
Other | $45,000 | $135,000 | $225,000 |
Total Sales | $1,500,000 | $4,500,000 | $7,500,000 |
Direct Cost of Sales | 2000 | 2001 | 2002 |
Dialup Internet Access | $39,996 | $39,996 | $39,996 |
High-bandwidth Internet Access | $22,000 | $22,000 | $22,000 |
Website and Virtual Domain Hosting | $4,800 | $4,800 | $4,800 |
Network Services | $6,000 | $10,000 | $12,000 |
Server Colocation | $2,400 | $3,500 | $4,000 |
Other | $2,400 | $4,000 | $6,000 |
Subtotal Direct Cost of Sales | $77,596 | $84,296 | $88,796 |
5.4 Strategic Alliances
Web Solutions currently has strategic relationships with:
- World Communications for Internet service.
- Phoenix DSL Networks for DSL resale.
- Phoenix Communications for high-speed wireless.
- Internet of Phoenix for dialup connectivity (they provide wholesale pricing in the Phoenix area).
Web Solutions benefits from these relationships by receiving very competitive pricing on most of these services, allowing the company to offer competitive pricing on its services to customers.
The company is currently pursuing an agreement with a local radio station to provide Web-hosting services which will eventually include extended email services and dial-up access offered to their listeners under a co-branding agreement. There have also been discussions about this becoming a nationwide collaboration between Web Solutions and the stations’ parent company, Jordan’s Media.
The company plans to develop community calendaring and groupware applications for use by the company and the afore-mentioned radio station. This will provide a simple, useful tool for organizations, businesses, and individuals to organize, plan, announce, and track projects and events. This is being based on the Open Source project maintained at www.opendesk.com and will most likely be developed to contain both Open Source and proprietary components.
In the future, the company plans to partner with backbone providers, wholesale carriers, and other strategic organizations to:
- Reduce cost of goods and services utilized.
- Increase the number and variety of goods and services offered to customers.
- Chart the growth of the company into new territories.
At this time, the company is establishing re-seller agreements with DSL and Wireless high-bandwidth providers, and other services which will allow the company to compete in these markets, thus allowing for broader consumer recognition.
Management Summary
The company’s management philosophy is based on responsibility and mutual respect. Web Solutions has an environment and structure that encourages productivity and respect for customers and fellow employees. The company’s goal is to create an environment where:
- Creativity can flourish.
- Generating new ideas and products is well rewarded.
- Management structure is relatively flat and communication is encouraged.
- Mutual respect and sharing of knowledge is encouraged.
6.1 Management Team
Web Solution’s management is highly experienced and qualified. Key members of its management teams are listed below.
- Donald Williams – President
- Amy Williams – Secretary
- Geena James – Treasurer
6.2 Personnel Plan
The Web Solutions annual Personnel Plan is shown below. First year monthly expenses are included in the appendix.
Personnel Plan | |||
2000 | 2001 | 2002 | |
Donald Williams | $30,000 | $30,000 | $40,000 |
Amy Williams | $30,000 | $30,000 | $40,000 |
Geena James | $36,000 | $45,000 | $45,000 |
Dialup Services Manager | $45,000 | $55,000 | $65,000 |
R & D Manager | $60,000 | $60,000 | $70,000 |
R & D Researcher | $60,000 | $60,000 | $70,000 |
Technical Support Personnel | $31,200 | $31,200 | $31,200 |
Technical Support Personnel | $15,600 | $31,200 | $31,200 |
Total People | 8 | 8 | 8 |
Total Payroll | $307,800 | $342,400 | $392,400 |
Financial Plan
This section presents our financial projections for the term of the plan.
The company is raising a large investment for the purpose of growth and operations. This funding will cover operating expenses and product development during this period. The following is a breakdown of how the funds will be used.
Expenses: |
Costs: |
Advertising | $50,000 |
Legal Fees |
$10,000 |
Office | $40,000 |
Working Capital | $100,000 |
Miscellaneous | $50,000 |
Sub-total | $250,000 |
Product Development: | $1,250,000 |
Total | $1,500,000 |
7.1 Important Assumptions
- Nature and Limitation of Projections. This financial projection is based on sales volume at the levels described in the revenue section and presents, to the best of management’s knowledge and belief, the company’s expected assets, liabilities, capital, revenues, and expenses. The projections reflect management’s judgement of the expected conditions and its expected course of action, given the hypothetical assumptions.
- Revenues. The company’s revenue is derived primarily from subscriptions. Revenue projections are based on the 1999 sales in the comparable market nationwide, based on industry average. The exact numbers can be found in the Sales Forecast table and chart section.
- Expenses. The company’s expenses are primarily those of salaries, sales commissions, and administrative costs. Other expenses are based on management’s estimates and industry averages.
General Assumptions | |||
2000 | 2001 | 2002 | |
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 | 25.42% | 25.00% | 25.42% |
Other | 0 | 0 | 0 |
7.2 Break-even Analysis
The following table and chart reflect the company’s break-even estimates. These are based on fixed and variable cost estimates derived from past income statement data. Given that Web Solutions has little in the way of marginal costs, the break even analysis reflects the industry’s high gross margins. Unless one of the potential future risks seriously impacts profitability, or the company loses its ability to rapidly adjust to changing market conditions, the company does not see this as a serious issue.
Break-even Analysis | |
Monthly Revenue Break-even | $41,368 |
Assumptions: | |
Average Percent Variable Cost | 5% |
Estimated Monthly Fixed Cost | $39,228 |
7.3 Projected Profit and Loss
Web Solutions is in the early stage of development, thus initial projections have only been made on accounts that are believed to most drive the income statement. The following table provides Web Solution’s projected income statements for 2000-2002.
Pro Forma Profit and Loss | |||
2000 | 2001 | 2002 | |
Sales | $1,500,000 | $4,500,000 | $7,500,000 |
Direct Cost of Sales | $77,596 | $84,296 | $88,796 |
Other | $0 | $0 | $0 |
Total Cost of Sales | $77,596 | $84,296 | $88,796 |
Gross Margin | $1,422,404 | $4,415,704 | $7,411,204 |
Gross Margin % | 94.83% | 98.13% | 98.82% |
Expenses | |||
Payroll | $307,800 | $342,400 | $392,400 |
Sales and Marketing and Other Expenses | $41,468 | $41,468 | $41,468 |
Depreciation | $0 | $0 | $0 |
Legal Fees | $300 | $300 | $300 |
Utilities | $3,600 | $3,600 | $3,600 |
Insurance | $4,200 | $4,200 | $4,200 |
Mortgage | $67,200 | $67,200 | $67,200 |
Payroll Taxes | $46,170 | $51,360 | $58,860 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $470,738 | $510,528 | $568,028 |
Profit Before Interest and Taxes | $951,666 | $3,905,176 | $6,843,176 |
EBITDA | $951,666 | $3,905,176 | $6,843,176 |
Interest Expense | $62,256 | $43,614 | $27,097 |
Taxes Incurred | $226,397 | $965,390 | $1,732,420 |
Net Profit | $663,013 | $2,896,171 | $5,083,659 |
Net Profit/Sales | 44.20% | 64.36% | 67.78% |
7.4 Projected Cash Flow
This chart and table show our cash flow and cash balance projections.
Pro Forma Cash Flow | |||
2000 | 2001 | 2002 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $1,275,000 | $3,825,000 | $6,375,000 |
Cash from Receivables | $213,735 | $605,470 | $1,055,470 |
Subtotal Cash from Operations | $1,488,735 | $4,430,470 | $7,430,470 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $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,488,735 | $4,430,470 | $7,430,470 |
Expenditures | 2000 | 2001 | 2002 |
Expenditures from Operations | |||
Cash Spending | $307,800 | $342,400 | $392,400 |
Bill Payments | $560,320 | $1,197,305 | $1,961,269 |
Subtotal Spent on Operations | $868,120 | $1,539,705 | $2,353,669 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $60,000 | $30,338 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $150,000 | $150,000 | $150,000 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $1,078,120 | $1,720,043 | $2,503,669 |
Net Cash Flow | $410,615 | $2,710,427 | $4,926,801 |
Cash Balance | $523,228 | $3,233,655 | $8,160,456 |
7.5 Projected Balance Sheet
The following table outlines Web Solution’s projected balance sheets for fiscal years 2000-2002.
Pro Forma Balance Sheet | |||
2000 | 2001 | 2002 | |
Assets | |||
Current Assets | |||
Cash | $523,228 | $3,233,655 | $8,160,456 |
Accounts Receivable | $34,765 | $104,295 | $173,825 |
Other Current Assets | $34,650 | $34,650 | $34,650 |
Total Current Assets | $592,643 | $3,372,600 | $8,368,931 |
Long-term Assets | |||
Long-term Assets | $331,650 | $331,650 | $331,650 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $331,650 | $331,650 | $331,650 |
Total Assets | $924,293 | $3,704,250 | $8,700,581 |
Liabilities and Capital | 2000 | 2001 | 2002 |
Current Liabilities | |||
Accounts Payable | $39,555 | $103,679 | $166,351 |
Current Borrowing | $30,337 | ($1) | ($1) |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $69,892 | $103,678 | $166,350 |
Long-term Liabilities | $495,975 | $345,975 | $195,975 |
Total Liabilities | $565,867 | $449,653 | $362,325 |
Paid-in Capital | $0 | $0 | $0 |
Retained Earnings | ($304,587) | $358,426 | $3,254,597 |
Earnings | $663,013 | $2,896,171 | $5,083,659 |
Total Capital | $358,426 | $3,254,597 | $8,338,256 |
Total Liabilities and Capital | $924,293 | $3,704,250 | $8,700,581 |
Net Worth | $358,426 | $3,254,597 | $8,338,256 |
7.6 Business Ratios
Standard business ratios are shown in this table. Industry Profile ratios are based on NAICS code 518111 for Internet Service Providers.
Ratio Analysis | ||||
2000 | 2001 | 2002 | Industry Profile | |
Sales Growth | 21.21% | 200.00% | 66.67% | 15.97% |
Percent of Total Assets | ||||
Accounts Receivable | 3.76% | 2.82% | 2.00% | 23.91% |
Other Current Assets | 3.75% | 0.94% | 0.40% | 56.89% |
Total Current Assets | 64.12% | 91.05% | 96.19% | 85.48% |
Long-term Assets | 35.88% | 8.95% | 3.81% | 14.52% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 7.56% | 2.80% | 1.91% | 28.28% |
Long-term Liabilities | 53.66% | 9.34% | 2.25% | 19.52% |
Total Liabilities | 61.22% | 12.14% | 4.16% | 47.80% |
Net Worth | 38.78% | 87.86% | 95.84% | 52.20% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 94.83% | 98.13% | 98.82% | 100.00% |
Selling, General & Administrative Expenses | 50.52% | 33.89% | 30.75% | 74.12% |
Advertising Expenses | 1.67% | 0.56% | 0.33% | 1.33% |
Profit Before Interest and Taxes | 63.44% | 86.78% | 91.24% | 2.07% |
Main Ratios | ||||
Current | 8.48 | 32.53 | 50.31 | 2.18 |
Quick | 8.48 | 32.53 | 50.31 | 1.67 |
Total Debt to Total Assets | 61.22% | 12.14% | 4.16% | 59.04% |
Pre-tax Return on Net Worth | 248.14% | 118.65% | 81.74% | 3.94% |
Pre-tax Return on Assets | 96.23% | 104.25% | 78.34% | 9.61% |
Additional Ratios | 2000 | 2001 | 2002 | |
Net Profit Margin | 44.20% | 64.36% | 67.78% | n.a |
Return on Equity | 184.98% | 88.99% | 60.97% | n.a |
Activity Ratios | ||||
Accounts Receivable Turnover | 6.47 | 6.47 | 6.47 | n.a |
Collection Days | 59 | 38 | 45 | n.a |
Accounts Payable Turnover | 13.38 | 12.17 | 12.17 | n.a |
Payment Days | 31 | 21 | 24 | n.a |
Total Asset Turnover | 1.62 | 1.21 | 0.86 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 1.58 | 0.14 | 0.04 | n.a |
Current Liab. to Liab. | 0.12 | 0.23 | 0.46 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $522,751 | $3,268,922 | $8,202,581 | n.a |
Interest Coverage | 15.29 | 89.54 | 252.54 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.62 | 0.82 | 1.16 | n.a |
Current Debt/Total Assets | 8% | 3% | 2% | n.a |
Acid Test | 7.98 | 31.52 | 49.26 | n.a |
Sales/Net Worth | 4.18 | 1.38 | 0.90 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
Appendix
Sales Forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | |||||||||||||
Dialup Internet Access | 0% | $98,250 | $98,500 | $97,250 | $98,250 | $96,250 | $96,250 | $96,250 | $96,250 | $96,250 | $96,250 | $93,000 | $92,250 |
High-bandwidth Internet Access | 0% | $9,250 | $9,750 | $9,500 | $9,250 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $7,750 | $7,000 |
Website and Virtual Domain Hosting | 0% | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
Network Services | 0% | $8,000 | $8,000 | $7,000 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $5,000 | $3,250 |
Server Colocation | 0% | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 |
Other | 0% | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
Total Sales | $129,250 | $130,000 | $127,500 | $127,500 | $125,000 | $125,000 | $125,000 | $125,000 | $125,000 | $125,000 | $119,500 | $116,250 | |
Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Dialup Internet Access | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
High-bandwidth Internet Access | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Website and Virtual Domain Hosting | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Network Services | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Server Colocation | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Other | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Subtotal Direct Cost of Sales | $4,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 |
Personnel Plan | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Donald Williams | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Amy Williams | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Geena James | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Dialup Services Manager | 0% | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 |
R & D Manager | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
R & D Researcher | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Technical Support Personnel | 0% | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
Technical Support Personnel | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 |
Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 |
General Assumptions | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Sales | $129,250 | $130,000 | $127,500 | $127,500 | $125,000 | $125,000 | $125,000 | $125,000 | $125,000 | $125,000 | $119,500 | $116,250 | |
Direct Cost of Sales | $4,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $4,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | $6,633 | |
Gross Margin | $124,617 | $123,367 | $120,867 | $120,867 | $118,367 | $118,367 | $118,367 | $118,367 | $118,367 | $118,367 | $112,867 | $109,617 | |
Gross Margin % | 96.42% | 94.90% | 94.80% | 94.80% | 94.69% | 94.69% | 94.69% | 94.69% | 94.69% | 94.69% | 94.45% | 94.29% | |
Expenses | |||||||||||||
Payroll | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 | |
Sales and Marketing and Other Expenses | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | $3,456 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Legal Fees | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Mortgage | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | $5,600 | |
Payroll Taxes | 15% | $3,653 | $3,653 | $3,653 | $3,653 | $3,653 | $3,653 | $4,043 | $4,043 | $4,043 | $4,043 | $4,043 | $4,043 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $37,733 | $37,733 | $37,733 | $37,733 | $37,733 | $37,733 | $40,723 | $40,723 | $40,723 | $40,723 | $40,723 | $40,723 | |
Profit Before Interest and Taxes | $86,884 | $85,634 | $83,134 | $83,134 | $80,634 | $80,634 | $77,644 | $77,644 | $77,644 | $77,644 | $72,144 | $68,894 | |
EBITDA | $86,884 | $85,634 | $83,134 | $83,134 | $80,634 | $80,634 | $77,644 | $77,644 | $77,644 | $77,644 | $72,144 | $68,894 | |
Interest Expense | $5,990 | $5,844 | $5,698 | $5,553 | $5,407 | $5,261 | $5,115 | $4,969 | $4,823 | $4,678 | $4,532 | $4,386 | |
Taxes Incurred | $24,268 | $19,947 | $19,359 | $19,395 | $18,807 | $18,843 | $18,132 | $18,169 | $18,205 | $18,242 | $16,903 | $16,127 | |
Net Profit | $56,626 | $59,842 | $58,077 | $58,186 | $56,420 | $56,530 | $54,397 | $54,506 | $54,615 | $54,725 | $50,709 | $48,381 | |
Net Profit/Sales | 43.81% | 46.03% | 45.55% | 45.64% | 45.14% | 45.22% | 43.52% | 43.60% | 43.69% | 43.78% | 42.43% | 41.62% |
Pro Forma Cash Flow | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $109,863 | $110,500 | $108,375 | $108,375 | $106,250 | $106,250 | $106,250 | $106,250 | $106,250 | $106,250 | $101,575 | $98,813 | |
Cash from Receivables | $11,750 | $12,396 | $19,391 | $19,488 | $19,125 | $19,113 | $18,750 | $18,750 | $18,750 | $18,750 | $18,750 | $18,723 | |
Subtotal Cash from Operations | $121,613 | $122,896 | $127,766 | $127,863 | $125,375 | $125,363 | $125,000 | $125,000 | $125,000 | $125,000 | $120,325 | $117,535 | |
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 | $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 | $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 | $121,613 | $122,896 | $127,766 | $127,863 | $125,375 | $125,363 | $125,000 | $125,000 | $125,000 | $125,000 | $120,325 | $117,535 | |
Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Expenditures from Operations | |||||||||||||
Cash Spending | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $24,350 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 | $26,950 | |
Bill Payments | $72,297 | $48,192 | $45,783 | $45,070 | $44,940 | $44,226 | $44,105 | $43,650 | $43,540 | $43,431 | $43,276 | $41,810 | |
Subtotal Spent on Operations | $96,647 | $72,542 | $70,133 | $69,420 | $69,290 | $68,576 | $71,055 | $70,600 | $70,490 | $70,381 | $70,226 | $68,760 | |
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 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | |
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 | $114,147 | $90,042 | $87,633 | $86,920 | $86,790 | $86,076 | $88,555 | $88,100 | $87,990 | $87,881 | $87,726 | $86,260 | |
Net Cash Flow | $7,466 | $32,854 | $40,133 | $40,943 | $38,585 | $39,286 | $36,445 | $36,900 | $37,010 | $37,119 | $32,599 | $31,275 | |
Cash Balance | $120,078 | $152,932 | $193,065 | $234,008 | $272,593 | $311,880 | $348,325 | $385,225 | $422,235 | $459,354 | $491,953 | $523,228 |
Pro Forma Balance Sheet | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $112,613 | $120,078 | $152,932 | $193,065 | $234,008 | $272,593 | $311,880 | $348,325 | $385,225 | $422,235 | $459,354 | $491,953 | $523,228 |
Accounts Receivable | $23,500 | $31,138 | $38,241 | $37,975 | $37,613 | $37,238 | $36,875 | $36,875 | $36,875 | $36,875 | $36,875 | $36,050 | $34,765 |
Other Current Assets | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 | $34,650 |
Total Current Assets | $170,763 | $185,866 | $225,824 | $265,690 | $306,271 | $344,481 | $383,405 | $419,850 | $456,750 | $493,760 | $530,879 | $562,653 | $592,643 |
Long-term Assets | |||||||||||||
Long-term Assets | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 | $331,650 |
Total Assets | $502,413 | $517,516 | $557,474 | $597,340 | $637,921 | $676,131 | $715,055 | $751,500 | $788,400 | $825,410 | $862,529 | $894,303 | $924,293 |
Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Current Liabilities | |||||||||||||
Accounts Payable | $70,688 | $46,665 | $44,281 | $43,571 | $43,465 | $42,755 | $42,650 | $42,198 | $42,093 | $41,987 | $41,881 | $40,446 | $39,555 |
Current Borrowing | $90,337 | $85,337 | $80,337 | $75,337 | $70,337 | $65,337 | $60,337 | $55,337 | $50,337 | $45,337 | $40,337 | $35,337 | $30,337 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $161,025 | $132,002 | $124,618 | $118,908 | $113,802 | $108,092 | $102,987 | $97,535 | $92,430 | $87,324 | $82,218 | $75,783 | $69,892 |
Long-term Liabilities | $645,975 | $633,475 | $620,975 | $608,475 | $595,975 | $583,475 | $570,975 | $558,475 | $545,975 | $533,475 | $520,975 | $508,475 | $495,975 |
Total Liabilities | $807,000 | $765,477 | $745,593 | $727,383 | $709,777 | $691,567 | $673,962 | $656,010 | $638,405 | $620,799 | $603,193 | $584,258 | $565,867 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) | ($304,587) |
Earnings | $0 | $56,626 | $116,468 | $174,544 | $232,730 | $289,151 | $345,680 | $400,077 | $454,583 | $509,198 | $563,923 | $614,632 | $663,013 |
Total Capital | ($304,587) | ($247,961) | ($188,119) | ($130,043) | ($71,857) | ($15,436) | $41,093 | $95,490 | $149,996 | $204,611 | $259,336 | $310,045 | $358,426 |
Total Liabilities and Capital | $502,413 | $517,516 | $557,474 | $597,340 | $637,921 | $676,131 | $715,055 | $751,500 | $788,400 | $825,410 | $862,529 | $894,303 | $924,293 |
Net Worth | ($304,587) | ($247,961) | ($188,119) | ($130,043) | ($71,857) | ($15,436) | $41,093 | $95,490 | $149,996 | $204,611 | $259,336 | $310,045 | $358,426 |