Table of Content
Are you planning to open an internet café ?
Internet penetration across the globe has grown exponentially and everyone these days relies on a stable internet access for both work and play. Even though the latest technologies including mobile technology is widely used across the world, there is still a high demand for good quality internet cafes offering superior quality service. People want to walk into a professionally managed facility with fast-speed internet infrastructure.
For a cyber café business to succeed, the first step is to have a well-structured business plan that will guide the entire process of business set-up. Before embarking on a starting a cyber café, you need to have a well-laid out business plan that will effectively take care of all issues that need your attention.
In case you aren’t sure of how to come up with a professional business planning for your cyber café company, here is a detailed sample plan written for an upcoming cyber cafe, YellowNet in Manhattan.
Executive Summary
The Cyber Café Business
2.1 The Business
YellowNet Cyber Café will be located on Street X in downtown Manhattan which is an busy area with a lot of activity. The neighborhood was selected because it is the heart of business, leisure and entertainment activities. With a number of world famous landmarks within the vicinity, it is the perfect place to open internet café business. The café is situated within one of the world’s busiest Central Business Districts. The internet café will be situated in close proximity to world renowned landmarks such as The Metropolitan Museum of Art, Central Park, Empire State Building and One World Observatory among others. The location was selected to serve city dwellers as well as visitors and tourists.
YellowNet will be run by Michael Thicke and his wife. Michael has extensive experience working for various Internet Service Provider companies while his wife has worked with various business management consultancy firms. With experience in the internet service provision and business consultancy, the couple is well versed with intricate details of how to open an internet café and successfully run it. Michael knows too well he has to be innovative and think outside the box to offer a unique and exemplary service that meets the demands of his customers. Michael will be in charge of the day-to-day running of the cyber café business. He has studied other similar business models to craft a winning strategy for starting an internet café.
2.2 Objectives
YellowNet Cyber Café has set up its objectives it intends to achieve the following in the first three years of operation. The objectives have been summarized as follows:
- Creation of a cozy, unique and quiet environment different from other competitors where customers can comfortably enjoy services.
- Make the community aware on what services the cyber café offers.
- Ensure the environment is conducive and can accommodate people with diverse beliefs, cultures and backgrounds.
- Provide great coffee and sumptuous bakery items at affordable prices.
2.3 Keys to Success
YellowNet Cyber Café has set up its objectives it intends to achieve the following in the first three years of operation. The objectives have been summarized as follows:
- Creation of a cozy, unique and quiet environment different from other competitors where customers can comfortably enjoy services.
- Make the community aware on what services the cyber café offers.
- Ensure the environment is conducive and can accommodate people with diverse beliefs, cultures and backgrounds.
- Provide great coffee and sumptuous bakery items at affordable prices.
2.4 Risks
The following risks have been identified with starting YellowNet:
- Is YellowNet in Manhattan providing services which are in demand?
- Will internet craze continue to become popular in order to support the café’s growth?
- Will customers be willing to part with their money for YellowNet’s services?
- Will the cost of home internet drop so significantly that YellowNet will no longer find customers interested in Internet café services?
- Will access of internet via mobile platforms become so popular that customers will prefer to instead use their mobile gadgets to access the internet?
2.5 Company Targets and Forecasts
Michael’s target is to become the best internet café in New York and be a trendsetter by providing a unique, highly-customized and professional service. Michael has forecasted a 15% market share and calculated an average gross and net profit margin expected in the next three years. He strongly believes in his business model which will gradually begin with lower net margins, but pick up to bring in a good net profit margin in the second and third year.
Company Summary
3.1 Who is the Owner?
- YellowNet is owned and operated by Michael Thicke.
- He has vast experience in the internet service provision industry spanning a total of 12 years.
- Throughout his life, Michael has worked for various internet service providers, and therefore thoroughly understands how the industry works.
- Michael is a graduated with a degree in Information Technology from Pace University in New York, He also holds an MBA from Columbia Business School.
- Working in the technology division, Michael was instrumental in the SME technical support division.
- During the course of his career, he helped several local small businesses successfully set up their internet infrastructure.
- He rose through the ranks and served as an IT Manager in the various companies that he worked for.
3.2 Why did he start his business?
- Having been in the industry for long, Mike knew how to start a internet café.
- Despite increase in domestic internet use, he knew there was still a demand for cyber cafes especially in densely populated areas of the city.
- He had seen how other cyber cafes operated and seen the loopholes he could exploit to offer a unique and customized service.
- There was need to offer a great internet facility where residents, visitors and tourists could access high-speed internet services in NYC City.
- Online gaming inspired Michael to think about starting a gaming café where he could provide a cozy environment for customers looking to have fun online.
3.3 How the business will be started
The total startup cost for YellowNet will be drawn for Mike’s personal savings which he has accumulated during his career life. However, there is a funding shortfall which will be covered by a loan.
The proposed site for the business will be on 3rd avenue Manhattan and will be leased for an initial period of 2 years from June 2018 with an option to extend. Reasons for choosing 3 rd avenue include;
- Proximity to a large downtown business community
- Close to major tourist attractions frequented by many tourists
- Availability of sufficient parking
- Reasonable rent rates compared to other areas of the city
- Premises is strategically located and highly visible
Even though Michael has been in the internet service provision industry, he plans to hire five additional staff to help in running the internet café.
START UP REQUIREMENTS | |
Legal | $500 |
Stationery etc. | $250 |
Brochures | $250 |
Consultants | $1,200 |
Insurance | $700 |
Rent | $800 |
2 Group Commercial expresso machine | $7,000 |
Bean grinder | $150 |
Computer systems(x9),software,printer,scanner | $18,450 |
Popcorn machine | $200 |
Fixtures/Remodel9decor,counters,stools,chairs) | $11,850 |
Communication Lines | $500 |
TOTAL START-UP EXPENSES | $41,850 |
Start-up Assets | |
Cash Required | $12,000 |
Start-up Inventory | $1,200 |
Other Current Assets | $0 |
Long-term Assets | $0 |
TOTAL ASSETS | $13,200 |
Total Requirements | $55,050 |
Services for Customers
YellowNet will be a professionally managed and equipped with the latest cutting edge technologies to meet the demands of clients. In a bid to stand out as a unique and modern establishment, the business intends to go an extra mile and cultivate strong relationships with its customers. The intention of offering a wide variety of services under one roof is to offer clients the best value for money, and at the same time make profits in accordance to the law,
The quality of service is expected to be exemplary right from accessing the internet to general customer service etiquette. The target is to ensure customers enjoy themselves while at the facility and look forward to coming back again.
Products and services to be offered at YellowNet include:
- Offer fast and secure internet browsing services
- Help clients access reliable and affordable international internet calls
- Avail the required hardware and software to facilitate video teleconference services
- Provision of document printing and scanning services
- Offer highly sophisticated infrastructure for computer gaming
- Sale of call cards and internet bundles from various service providers
- Offer caffeine, snacks and various types of soft drinks
- Provide consultancy and advice in internet related services
YellowNet has invested heavily in a wide array of internet applications. As part of internet café business introduction strategy, the establishment intends to harness the latest technologies to ensure the business is fully technology compliant.
With the realization that many people are increasingly becoming keen on online gaming, Michael is keen on branding his business as a computer game café with the best gaming applications you cannot find anywhere else.
In future, YellowNet intends to establish a small internet training center that will offer learners a chance to be trained by experts on how to effectively use the internet.
Marketing Analysis of Cyber Café Business
Comprehensive cyber cafe business plans always offer a detailed analysis of the target market. YellowNet is expected to operate in a highly profitable environment that will allow the business be a trendsetter in the cyber-café industry. With a growing number of people embracing the coffee culture and more people looking for fast internet facilities, the business caters for both groups. This is no doubt an excellent concept that is poised for success. This internet café business model is a combination of two related businesses under one roof.
5.1 Target Market Segment
YellowNet intends to offer people looking for somewhere quiet, comfortable and cozy to browse the internet. The establishment admits both experienced internet users as well as novices willing to gain knowledge on utilizing the internet. YellowNet’s customers can be divided into two broad categories. The business is targeting an age group of between 18 to 60 years and beyond.
Group One consists of customers who are internet savvy and are just looking for a comfortable and inviting facility aside from their homes and offices to browse the internet and enjoy a cup of coffee and snacks. Group Two consists of customers who aren’t yet familiar with the internet but for various reasons, have to visit an internet café to accomplish various tasks.
Basically, anyone who has a passion for computers and internet is a potential customer. Because many people have internet at home or on their mobile gadgets, it is difficult to find a social setting especially in the Central Business District where you can access high-speed internet.
YellowNet intends to target both local and travellers who wish to check their emails, work or play games in a friendly environment. Customers coming into the premises will either use YellowNet’s PCs or plug in their notebooks and tablets into internet ports. The business targets a wide demographic; from youngsters who’re computer savvy to computer novices who’ve realized computer and internet knowledge is a must have.
This well-laid out internet café business plan focuses on these market segments:
5.1.1 University Students
University students are an important target niche in this cyber cafe business plan because they’re always in constant need of internet access and various computer programs. Because they’re always working on projects and assignments, they will find it helpful to work from a cyber cafe where they can have access to unlimited internet. Because they don’t earn an income, students might not be able to afford to pay for home internet packages and therefore, will opt for an internet café which could be cheaper.
In addition, they’re always in need of scanning, printing and document preparation tasks. On many occasions, students remain in the cyber café for extended time are an excellent target for YellowNet. The growing number of students in universities means there is a steady demand for quality yet affordable internet service.
5.1.2 Office Workers
These are professionals who either reside in New York City or travelling professionals who have visited NYC for conferences. Modern career professionals are always on the move and require quick access to fast internet and other cyber-related utilities to effectively perform their work. Often they will need a quiet, well managed and professional internet café to either read work emails, print, scan or work with diverse applications such as Google, Microsoft Office and Adobe Photoshop. YellowNet understands office workers are sensitive and knows too well professionalism must be top-notch.
5.1.3 Teenagers
Teenagers are excited with anything to do with technology landscape. Therefore, they are a major target for YellowNet. If you’re thinking how do internet cafes make money, you cannot afford to ignore teenagers. These tech savvy youngsters want to be online the entire day playing online games, chatting online and posting photos and multimedia content on social networks. For them, life without internet is worthless. YellowNet intends to always have the newest hardware and software to facilitate intensive online gaming sessions.
5.1.4 Seniors
Seniors are not so much fascinated about computers and the internet. However, they do need to accomplish tasks that require them to visit an internet café. In most cases, seniors are a unique but very lucrative target niche for any cyber related business. Because of their old age, they need somewhere comfortable and friendly to access the internet. In most cases, they will need to be assisted by employees to accomplish various tasks such as browsing, printing and scanning. Seniors always need good customer service because they’re sensitive and require staff to be patient with them.
Market Analysis | |||||||||
YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | |||||
Growth | CAGR | ||||||||
University Students | 7% | 10,000 | 10,700 | 12,600 | 13,200 | 14,000 | 7.00% | ||
Office Workers | 3% | 15,000 | 15,500 | 16,600 | 17,000 | 18,000 | 3.00% | ||
Seniors | 4% | 20,000 | 20,700 | 21,000 | 21,700 | 23,000 | 4.00% | ||
Teenagers | 5% | 13,000 | 13,700 | 14,200 | 15,000 | 15,700 | 5.00% | ||
Others | 0% | 23,000 | 23,000 | 23,000 | 23,000 | 23,000 | 0.00% | ||
Total | 4% | 81,000 | 83,600 | 87,400 | 89,900 | 93,700 | 3.80% |
5.2 Pricing of Packages
YellowNet offers competitive pricing after carefully evaluating the pricing structure for competitors. Since the business targets middle income customers, prices have been structured to effectively cater for this economic and social group.
A summary of YellowNet Prices is indicated below:
- Browsing per Minute $0.05
- Document Printing Per Page $1
- Scanning per Page $2
- Gaming Per Hour $5
- Special Packages $2 per hour (After browsing for three hours)
Prices are client-conscious in order to allow them see value in services offered by YellowNet. There are also special packages in place for those who wish to browse the internet for extended hours or print large volumes of documents. Prices outlined in this business plan are friendly to both the customer to ensure they get the best value for their money, while at the same time ensure the business makes good profits from services rendered.
5.3 Business Target of the Company
While there are many internet cybers operating , YellowNet plans to follow a business strategy services that will deliver good results for the business. Before setting up shop, the business has analyzed customer demand, trends and behaviors in order to respond better to their needs.
Fortunately, YellowNet is the first cyber café to be set up on 3 rd Street and enjoys a niche-market that extends over one kilometer. The business targets to enjoy great advantages especially in brand recognition and customer loyalty. Initially, the company will command an almost 100 percent market share in the immediate surroundings. However, in the next couple of years, chances are high, other internet cafes may open. The goal is to still retain over 70% of the market share in the wake of competition.
After doing extensive market research, the following was concluded:
- YellowNet cyber will need to adjust its working hours in order to get more clients. For instance, the cyber will open earlier that competitors and remain open till late after other internet cafes have closed.
- Charge a slightly lower browsing, printing and scanning rates compared to what others are offering their clients.
- There will be a large number of clients visiting the premises especially when international conferences, shows and exhibitions are taking place in the surrounding.
- The cyber will be extremely busy especially during the weekends and weekday evenings as people seek somewhere to browse the internet and socialize as they enjoy a cup of their favorite drink.
- A lot of customers particularly those reading emails only will visit the premises for a shorter period of time compared to those doing research and projects.
- Always have admin on duty to assist special customers especially seniors and those who may need someone to quickly respond to general enquiries.
- Fully implement this gaming café business plan to ensure YellowNet is popular for online gaming as its latest catch especially amongst the youth.
Strategy
Without a solid strategy, opening an internet café will be a failed mission. In this section, we look at the strategies that YellowNet intends to put in place to ensure it meets its expectations. This cyber has formulated three key strategies which include;
- Focus on attracting a higher number of novice internet users with a friendly and accommodating environment that doesn’t make novices feel intimidated. YellowNet aims to put in place training opportunities to grow and maintain a loyal customer base.
- Attract more Power Internet users who’re extremely knowledgeable when it comes to using the internet. This is an important customer segment for YellowNet as they’re always in need of cyber café services. Their web-browsing experience makes them to be admired by novice internet users.
- Focus on establishing a friendly and comfortable social setting for YellowNet customers. A good social environment incorporates entertainment attracting customers that would ordinarily not need to access the internet from a cyber café. Once in the cyber, these customers should find an entertaining environment that will make them realize how fun it is to access the internet in a cyber café.
6.1 Sales Strategy Pyramid
The following points outline specifics on how YellowNet will implement the three strategies outlined above. Strategy pyramid graphics can be found in the appendix section of this plan.
6.1.1 Attract Power Internet Users
This strategy will place more emphasis on putting in place initiatives that will attract power internet users. These users are critical to the success of YellowNet and the following strategies will be used to attract these customers;
- Stay abreast and offer the best computing technologies; these users love using the latest technologies.
- Offer printing and scanning services
- Allowing clients to access powerful software applications.
6.1.2 Offer a Social Hub
This strategy lays emphasis on building a safe, nice and friendly environment for YellowNet customers. Starting a cyber café goes beyond just offering PCs and internet.
- The cyber will focus on availing standard entertainment facilities on the premises to entice more customers to come in. Soon clients who come in to enjoy entertainment will realize there is fast internet on site that they can utilize.
- Invest in beautiful and well-designed sitting areas, tasteful furniture and decorate appropriately with lively themes that promote comfort.
6.1.3 Entice Novice Internet Users
YellowNet’s sales strategy involves reaching out to more novice internet users. This is a lucrative market that many cyber café business plans tend to neglect. Even though these customers don’t have browsing experience, they can be transformed into loyal cyber café customers. YellowNet intends to attract novice customers by:
- Ensure YellowNet is known for a novice friendly environment. The facility will be staffed by knowledgeable and experienced personnel to ensure novice customers feel welcomed and their needs are promptly attended to.
- A customer service desk will be manned by YellowNet personnel throughout to offer any help in case a customer has a question or wishes to raise a concern.
- YellowNet hopes to introduce internet and email classes for beginners. The goal of these classes is to help novice users familiarize themselves with internet browsing and how to use computer systems available at the cyber café.
6.2 SWOT ANALYSIS
The purpose of SWOT analysis is to enable us understand both internal strengths and weaknesses that YellowNet must deal with. It also points out opportunities available for the business as well as the potential threats.
YellowNet has numerous strengths and advantages that will offer the business a competitive advantage and drive success. Before the plan to start an internet café was initiated, adequate market survey was done to identify the strengths, weaknesses, threats and opportunities.
6.2.1 Strengths
- Well trained, professional and friendly staff. YellowNet has gone an extra mile to hire and train staff who have a passionate to train and help clients.
- High-tech equipment which includes super-fast PCs, flat screen displays and high quality printers.
- Fine ambience. Every customer who walks into YellowNet should immediately feel comfortable and welcomed.
- A well-laid out vision as YellowNet knows what it takes to effectively meet client needs.
6.2.2 Weaknesses
- Rapid changing technologies means YellowNet has to always keep abreast of the latest technology.
- Significant expenses associated with keeping sophisticated hardware and software. YellowNet must -find ways to balance technology with other key business needs.
6.2.3 Opportunities
- Rapid population increase of internet users means more people will need YellowNet services.
- Social bonds and networks built as a result of the internet gives the business a platform to grow communities by establishing dedicated chat areas and community programs.
6.2.4 Threats
- Massive reduction of internet access costs. The cost of internet is dropping rapidly and may end becoming cheap that nobody may be willing to visit a cyber café. YellowNet is aware of this reality and will constantly monitor pricing.
- Emerging local competition: In future, new cyber cafes will be opened but YellowNet is well-prepared to take on this challenges.
6.2.5 Competitors
- Because of Michael’s experience in the internet service provision industry, YellowNet has a competitive advantage over other cyber cafes.
- The business has a unique sales and marketing strategy that effectively addresses how do internet cafes work in a highly competitive environment.
6.2.6 Sales Forecast
- YellowNet Cyber is expected to get a regular influx of customers throughout the day and the sales are expected to vary from day to day and month.
- YellowNet has based projected internet sales based on number of hours every terminal is active. Coffee and espresso sales are based on a financial data provided by Kobrick Coffee Company.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Unit Sales | |||
Coffee (Based on average) | 19,500 | 29,500 | 39,500 |
Specialty Drinks | 19,500 | 29,500 | 39,500 |
Email membership | 96150 | 106,150 | 116150 |
Baked Goods | 249500 | 259500 | 269500 |
Hourly Internet fees | 194900 | 204900 | 214900 |
TOTAL UNIT SALES | 579,550 | 629,550 | 679,550 |
Unit Prices | Year 1 | Year 2 | Year 3 |
Coffee (Based on average) | $1.50 | $1.50 | $1.50 |
Specialty Drinks | $2.50 | $2.50 | $2.50 |
Email membership | $12.00 | $12.00 | $12.00 |
Hourly Internet fees | $3.50 | $3.50 | $3.50 |
Baked Goods | $2.00 | $2.00 | $2.00 |
Sales | |||
Coffee (Based on average) | $29,500 | $44,250 | $59,250 |
Specialty Drinks | $48,750 | $73,750 | $98,750 |
Email membership | $1,153,800 | $1,273,800 | $1,393,800 |
Hourly Internet fees | $682,150 | $717,150 | $752,150 |
Baked Goods | $499,000 | $519,000 | $539,000 |
TOTAL SALES | 2413200 | 2627950 | 2842950 |
Direct Unit Costs | Year 1 | Year 2 | Year 3 |
Coffee (Based on average) | $0.38 | $0.38 | $0.38 |
Specialty Drinks | $0.63 | $0.63 | $0.63 |
Email membership | $3.00 | $3.00 | $3.00 |
Hourly Internet fees | $0.88 | $0.88 | $0.88 |
Baked Goods | $0.50 | $0.50 | $0.50 |
Direct Cost of Sales | |||
Coffee (Based on average) | $7,410 | $11,210 | $15,010 |
Specialty Drinks | $12,285 | $18,585 | $24,885 |
Email membership | $288,450 | $318,450 | $348,450 |
Hourly Internet fees | $171,512 | $180,312 | $189,112 |
Baked Goods | $124,750 | $129,750 | $134,750 |
Subtotal Direct Cost of Sales | $640,407 | $658,307 | $712,207 |
6.2.8 Milestones
The Yellow Net Cyber Café has come up with some basic milestones to keep the business priorities in check. Responsibility of implantation will be overseen by Mike Thicke and his wife Tracy Thicke, who is the manager of the business. The milestone table below will be updated with an actual table as the year progresses.
Milestone | Start Date | End Date | Duration |
Complete Business Plan | 1/1/2018 | 1/5/2018 | 110 |
Sign Rental Contract | 3/20/2018 | 3/20/2018 | 0 |
Convert Premises | 4/1/2018 | 4/30/2018 | 50 |
Hire Car Wash Staff | 4/20/2018 | 4/20/2018 | 0 |
Hire Admin Staff | 4/20/2018 | 4/20/2018 | 0 |
Open for Business | 5/1/2018 | 5/1/2018 | 0 |
Distribute Flyers | 4/28/2018 | 5/5/2018 | 15 |
Press Release | 4/29/2018 | 4/29/2018 | 0 |
Follow-up on Press Release | 4/30/2018 | 4/30/2018 | 0 |
Personnel Plan
Michael Thicke is the CEO and Owner of YellowNet Cyber. He manages and oversees all daily activities in the internet café. Mike will be helped by his wife Tracy, who is the Manager and will oversee financial books for the business. Both Mike and Tracy are responsible for making key management decisions.
Three staff members are Admin Assistants working part-time earning $7.00 per hour for 30 hours per week. There is one full-time technician working 40 hours per week at $12 per hour. The role of the technician is to offer technical support to clients and fix minor terminal bugs while Admin Assistants perform general administration duties. Intensive interviews and training is done to ensure only qualified personnel work in the establishment.
The simple staff structure ensures efficient distribution of duties and seamless workflow. It also allows better communication among team members to facilitate quick decision making. YellowNet management knows the secret to success is how to start your own internet café business with minimal but efficient personnel.
The following table is a representation of employee salaries for the next three years.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Owner | $26,000 | $28,000 | $30,000 |
Manager | $5,000 | $20,000 | $22,000 |
Admin Part Time 1 | $10,080 | $10,080 | 10,080 |
Admin Part Time 2 | $10,080 | $10,080 | $10,080 |
Admin Part Time 3 | $10,080 | $10,080 | $10,080 |
Techinician-Full Time | $23,040 | $24,000 | $25,000 |
TOTAL PEOPLE | 6 | 6 | 6 |
Total Payroll | $84,280 | $102,240 | $107,240 |
Financial Plan
YellowNet has developed the following financial plan which outlines how this cyber will achieve its financial goals within first three years. A financial way forward of how to start an internet cafe is essential to help the business realize its financial targets. There are plans in the pipeline to launch other establishments in NYC. For this to happen, the company must formulate a workable financial plan that will drive success.
Start-up Funding | ||
START-UP FUNDING | ||
START-UP FUNDING | $41,850 | |
Start-up Expenses to Fund | $13,200 | |
Start-up Assets to Fund | $55,050 | |
TOTAL FUNDING REQUIRED | ||
Assets | ||
Non-cash Assets from Start-up | $1,000 | |
Cash Requirements from Start-up | $10,000 | |
Additional Cash Raised | $0 | |
Cash Balance on Starting Date | $11,000 | |
TOTAL ASSETS | ||
Liabilities and Capital | ||
Liabilities | ||
Current Borrowing | $27,000 | |
Long-term Liabilities | $10,000 | |
Accounts Payable (Outstanding Bills) | $0 | |
Other Current Liabilities (interest-free) | $0 | |
TOTAL LIABILITIES | 37000 | |
Capital | ||
Planned Investment | ||
Mike Thicke | $2,000 | |
Mike Thicke’s Wife, Tracy Thicke | $8,050 | |
Other | $0 | |
Additional Investment Requirement | $0 | |
TOTAL PLANNED INVESTMENT | $28,050 | |
Loss at Start-up (Start-up Expenses) | $41,850 | |
TOTAL CAPITAL | $13,800 | |
TOTAL CAPITAL AND LIABILITIES | $11,000 | |
Total Funding | $55,050 |
8.1 Important Assumptions
Basic assumptions are indicated in the table below. These assumptions are expected to show variations due to various factors, but the result will not have any significant effect on the company’s financial strategy.
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | 1 | 2 | 3 |
Current Interest Rate | 6.00% | 6.00% | 6.00% |
Long-term Interest Rate | 8.00% | 8.00% | 8.00% |
Tax Rate | 25.00% | 25.00% | 25.00% |
Other | 0 | 0 | 0 |
8.2 Brake-Even Analysis
Brake-even data for YellowNet is illustrated in the chart and table below.
Brake-Even Analysis | |
Monthly Units Break-even | 6000 |
Monthly Revenue Break-even | $12,000 |
Assumptions: | |
Average Per-Unit Revenue | $3.00 |
Average Per-Unit Variable Cost | $1.00 |
Estimated Monthly Fixed Cost | $10,000 |
8.3 Projected Profit and Loss
Payroll Expense: The founder of YellowNet, Michael Thicke will get a salary of $26,000 in year one, $28,000 in year two, and $30,000 in year three. YellowNet has put in place plans to hire 3 part-time after first year ends for $6 per hour while a full-time technician will earn $12 per hour.
Lease Expenses: The facility intends to lease a 1,500 square foot facility at $1.875. According to the lease agreement signed by YellowNet, rent due every month totals to $800 for a total of 24 months. After five hundred and twenty days, the lease is availed for consideration. Right to renew or cancel the agreement is based on issues at hand.
Utilities Expense: As indicated in the signed lease agreement, the lessor is responsible for utility payments which include; real estate taxes, gas and garbage disposal among others. YellowNet is expected to cater for the internet cafe business phone bill expenses.
Marketing Expenses: YellowNet has allocated $20,000 for promotion related expenses for year one. This money will cater for placing adverts in local dailies to boost customer awareness.
Insurance Expenses: YellowNet Cyber has allocated $7,000 for insurance for the first year, second and third year. In future, the business intends to spend more on insurance coverage.
Taxes: Since YellowNet is an LLC, it is not taxed but there is a 15% payroll obligation.
A Comprehensive profit and Loss data is illustrated in the table below.
Pro Forma Profit And Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $240,000 | $300,000 | $320,000 |
Direct Cost of Sales | $50,000 | $70,000 | $80,000 |
Other | $0 | $0 | $0 |
TOTAL COST OF SALES | $50,000 | $70,000 | $80,000 |
Gross Margin | $160,000 | $200,000 | $240,000 |
Gross Margin % | 75.00% | 75.00% | 75.00% |
Expenses | |||
Payroll | $84,280 | $102,240 | $107,240 |
Marketing Promotion | $20,000 | $26,000 | $32,000 |
Depreciation | $0 | $0 | $0 |
Leased Equipment | $0 | $0 | $0 |
Utilities | $8,000 | $8,000 | $8,000 |
Insurance | $7,000 | $7,000 | $7,000 |
Rent | $10,000 | $10,000 | $10,000 |
Payroll Taxes | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $129,280 | $153,240 | $164,240 |
Profit Before Interest and Taxes | $30,720 | $46,760 | $75,760 |
EBITDA | $30,720 | $46,760 | $75,760 |
Interest Expense | $2,000 | $2,000 | $2,000 |
Taxes Incurred | $4,000 | $4,000 | $4,000 |
Net Profit | $10,000 | $10,000 | $10,000 |
Net Profit/Sales | 4.00% | 4.80% | 5.00% |
8.4 Projected Cash Flow
YellowNet’s projected cash flow is shown in the table below.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $240,000 | $300,000 | $320,000 |
SUBTOTAL CASH FROM OPERATIONS | $240,000 | $300,000 | $320,000 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $1,000 | $3,000 | $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 | $241,000 | $303,000 | $320,000 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $84,280 | $102,240 | $107,240 |
Bill Payments | $100,000 | $130,000 | $160,000 |
SUBTOTAL SPENT ON OPERATIONS | $184,280 | $232,240 | $267,240 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $7,000 | $1,000 | $0 |
Principal Repayment of Current Borrowing | $0 | $0 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $8,000 | $4,000 | $3,500 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
SUBTOTAL CASH SPENT | $199,280 | $237,240 | $270,740 |
Net Cash Flow | $41,720 | $65,760 | $49,260 |
Cash Balance | $20,000 | $40,000 | $52,000 |
8.5 Projected Balance Sheet
YellowNet’s projected balance sheet is shown in the table below.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $20,000 | $40,000 | $52,000 |
Inventory | $5,000 | $6,500 | $7,000 |
Other Current Assets | $0 | $0 | $0 |
TOTAL CURRENT ASSETS | $25,000 | $46,500 | $59,000 |
Long-term Assets | |||
Long-term Assets | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 |
TOTAL LONG-TERM ASSETS | $0 | $0 | $0 |
TOTAL ASSETS | $25,000 | $46,500 | $59,000 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $11,000 | $11,700 | $11,200 |
Current Borrowing | $1,000 | $3,000 | $3,000 |
Other Current Liabilities | $0 | $0 | $0 |
SUBTOTAL CURRENT LIABILITIES | $12,000 | $14,700 | $14,200 |
Long-term Liabilities | $11,000 | $7,400 | $3,600 |
TOTAL LIABILITIES | $23,000 | $22,100 | $17,800 |
Paid-in Capital | $30,000 | $30,000 | $30,000 |
Retained Earnings | $50,500 | $37,500 | $28,004 |
Earnings | $10,200 | $15,600 | $13,110 |
TOTAL CAPITAL | $2,000 | $24,400 | $41,200 |
TOTAL LIABILITIES AND CAPITAL | $25,000 | $46,500 | $59,000 |
Net Worth | $2,000 | $24,400 | $41,200 |
8.6 Business Ratios
The SIC (Standard Industrial Classification) code for Internet Service Provider Industry is “Remote data base information retrieval “7375.9903. “information retrieval services” 7375 report was used to generate the industry profile. YellowNet is also a food café so it could have used “Eating Places” ratios based on SIC classification 5812. YellowNet Café belongs to two business segments that makes the ratios a combination of two industries.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | INDUSTRY PROFILE | |
Sales Growth | 0.00% | 15.00% | 2.00% | 0.40% |
Percent of Total Assets | ||||
Inventory | 14.50% | 13.40% | 12.00% | 2.00% |
Other Current Assets | 0.00% | 0.00% | 0.00% | 84.78% |
Total Current Assets | 100.00% | 100.00% | 100.00% | 86.95% |
Long-term Assets | 0.00% | 0.00% | 0.00% | 13.05% |
TOTAL ASSETS | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 30.00% | 26.00% | 25.20% | 24.00% |
Long-term Liabilities | 30.20% | 14.00% | 4.20% | 12.10% |
Total Liabilities | 70.20% | 34.30% | 25.40% | 34.50% |
NET WORTH | 10.15% | 30.10% | 52.30% | 45.25% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 55.00% | 55.00% | 55.00% | 100.00% |
Selling, General & Administrative Expenses | 59.89% | 59.18% | 59.93% | 80.00% |
Advertising Expenses | 0.00% | 0.00% | 0.00% | 1.00% |
Profit Before Interest and Taxes | 8.00% | 9.00% | 6.60% | 1.30% |
Main Ratios | ||||
Current | 2.2 | 2.5 | 3.2 | 0 |
Quick | 0.8 | 2 | 2.15 | 0 |
Total Debt to Total Assets | 74.74% | 44.80% | 35.50% | 0.00% |
Pre-tax Return on Net Worth | 320.80% | 100.20% | 45.25% | 0.00% |
Pre-tax Return on Assets | 50.00% | 47.48% | 33.20% | 0.00% |
Additional Ratios | Year 1 | Year 4 | Year 5 | |
Net Profit Margin | 4.10% | 6.20% | 4.10% | N.A. |
Return on Equity | 200.20% | 60.11% | 30.65% | N.A. |
Activity Ratios | ||||
Inventory Turnover | 10 | 8.5 | 7.02 | N.A. |
Accounts Payable Turnover | 9.15 | 10 | 9.12 | N.A. |
Payment Days | 20 | 27 | 27 | N.A. |
Total Asset Turnover | 2.71 | 2.42 | 2.13 | N.A. |
Debt Ratios | ||||
Debt to Net Worth | 4.4 | 2.21 | 0.7 | N.A. |
Current Liab. to Liab. | 0.33 | 0.69 | 0.86 | N.A. |
Liquidity Ratios | ||||
Net Working Capital | $15,500 | $25,000 | $30,500 | N.A. |
Interest Coverage | 7 | 15.1 | 19 | N.A. |
Additional Ratios | ||||
Assets to Sales | 0.12 | 0.15 | 0.18 | N.A. |
Current Debt/Total Assets | 35% | 26% | 20% | N.A. |
Acid Test | 1 | 2 | 2.4 | N.A. |
Sales/Net Worth | 35.3 | 10.15 | 5.02 | N.A. |
Dividend Payout | 0 | 0 | 0 | N.A. |
Download planning to start a cyber-café sample in pdf
OGScapital also specializes in writing business plans such as business plan for cafe, business plan of the cat cafe startup, craft brewery business plan, distillery business plan, microbrewery start up business plan, wine bar business plan and many other business plans.
OGSCapital’s team has assisted thousands of entrepreneurs with top-rated document, consultancy and analysis. They’ve helped thousands of SME owners secure more than $1.5 billion in funding, and they can do the same for you.