Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Internet icon ISP Business Plan

Start your plan

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:

  1. Increase personnel to handle sales, service, and development efforts.
  2. Increase marketing to assure future customers are aware of our offerings and aggressive pricing.
  3. 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.
  4. Perform research and development to bring new products to market.
Isp business plan, executive summary chart image

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.

Isp business plan, company summary chart image

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.

Isp business plan, market analysis summary chart image

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:

  1. Basic service: for customers looking for a simple, inexpensive way to connect their home or business to the Internet.
  2. 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:

    1. Functionalities (“Server Hotel”) facilities.
    2. Web hosting.
    3. Dialup access.
    4. 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:

    1. Destinations. Destinations are places, or websites, located on the Internet where people can go for information, entertainment, or commerce.
    2. 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.
    3. 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.
    4. 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).
    5. 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.
    6. 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.
    7. Auctions. The online market for auctions is headed by eBay Inc., (1998 revenues of $86.1 million, with $745 million of gross merchandise sales).
    8. 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.

    Isp business plan, strategy and implementation summary chart image

    Isp business plan, strategy and implementation summary chart image

    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

    1. 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.
    2. 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.
    3. 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.

    Isp business plan, financial plan chart image

    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.

    Isp business plan, financial plan chart image

    Isp business plan, financial plan chart image

    Isp business plan, financial plan chart image

    Isp business plan, financial plan chart image

    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.

    Isp business plan, financial plan chart image

    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