Executive Summary
Executive Summary
Executive Summary
The Market
The very nature of the computing industry, with its extraordinary rate of technological
development, creates a constant need for businesses skilled in updating and advising customers
on computer-related issues. In town, the majority of potential customers are dissatisfied with
existing options, creating an attractive niche for an innovative start-up. Small business PC
users will provide the majority of our business revenue. Business Week expects the computing
industry to grow at a rate of 12% and the processor speeds to continue to expand for years to
come, providing a rich resource for sales.
PC Repair has decided to focus mainly on the small business market, as these customers
typically don't have a full-time IT person, but have full-time IT needs. PC Repair will offer an
affordable, on-demand service for these customers. We can also offer maintenance agreements
that generate additional monthly income. For our residential customers, we will offer a very
affordable and helpful service with a very flexible schedule to meet their needs. Our target
market will focus on Ramsford-on-Bitstream and the surrounding areas. Market research
indicates there is an abundance of business for a small company such as PC Repair.
1.1 Objectives
4. To generate customer satisfaction so that at least 40% of our customer base is repeat
business.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
1.2 Mission
Our goal is to set the standard for on-site computer solutions through fast, on-site service and
response. Our customers will always receive one-on-one personal attention at a very affordable
price. Our customers will receive the highest quality of customer service available. Our
employees will receive extensive training, a great place to work, fair pay and benefits, and
incentives to use their own good judgement to solve customers' problems.
Quality: getting the job done right the first time, offering 100% guarantee.
The owner, Jack Hacker, has 10 years of experience in the fields of technical support,
networking, and computer training and repair. Jack has also spent the last three years as the
manager of a custom computer building and repair store, and understands the computer needs
of small businesses.
Total start-up expenses include initial expenses for establishing our website, setting up the
business, and doing our pre-opening advertising. Exact allocations are shown in the table.
The bulk of our start-up requirements are asset needs: we need diagnostic and repair
equipment, half of which will be contributed to the business by the owner from his own
materials. We are treating this equipment as assets because we expect it to last at least three
years, and to have some resale value when we are through with it; we will buy additional
expensed equipment in years two and three. We also need start-up inventory which includes
RAM, spare hard drives, cables, and cases. Although we will keep expenses to a minimum for
the first three months, before we move, we will also need cash at start-up, to see us through the
next several months with a positive cash balance.
We plan to fund our total start-up requirements direct owner investment (including the
contributed assets), and a three-year loan secured with the owner's collateral (his home equity).
We should be able to easily repay this loan within three years, even with a much lower sales
revenue than projected. (See the Cash Flow table for projected repayment.)
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
Uniforms $300
CPA $275
Advertisement $1,200
TOTAL START-UP EXPENSES $3,025
Start-up Assets
Cash Required $28,000
Start-up Inventory $1,200
Other Current Assets $10,000
Long-term Assets $0
TOTAL ASSETS $39,200
Total Requirements $42,225
Need real financials
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
Create your own business plan
START-UP FUNDING
Start-up Expenses to Fund $3,025
Start-up Assets to Fund $39,200
TOTAL FUNDING REQUIRED $42,225
Assets
Non-cash Assets from Start-up $11,200
Cash Requirements from Start-up $28,000
Additional Cash Raised $0
Cash Balance on Starting Date $28,000
TOTAL ASSETS $39,200
Liabilities and Capital
Liabilities
Current Borrowing $19,225
Long-term Liabilities $0
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
TOTAL LIABILITIES $19,225
Capital
Planned Investment
Owner $23,000
Investor $0
Additional Investment Requirement $0
TOTAL PLANNED INVESTMENT $23,000
Loss at Start-up (Start-up Expenses) ($3,025)
TOTAL CAPITAL $19,975
TOTAL CAPITAL AND LIABILITIES $39,200
Total Funding $42,225
Services
PC Repair will offer computer repairs, training, networking and upgrade service to clients in
two major categories: home PC users and small business users. As PC Repair and the client
demands grow, we will offer software development to our business clients.
From the very first day, we will offer on-site repair and consulting services, so that our clients
don't need to take time out of their busy days to haul a computer in to our workshop. This is
the single biggest frustration Jack has seen among small business owners needing computer
help. Much of our diagnostic equipment is portable, and we will remove a PC to our workshop
only when the problem requires more detailed diagnosis or repair. We will also offer free pick-
up and delivery of PCs needing repair. To meet the growing demand for this service, we will
purchase a company vehicle in the third month.
We will also offer extended maintenance contracts, so that business clients can deal with
technical support and repair needs as a single line-item expense, rather than having to plan for
unexpected crashes and problems with a rainy-day fund they may never use. Maintenance
contracts yield a high gross margin for us, and provide peace of mind for the customer.
We will offer limited software support (installation and compatibility issues), and focus on
hardware and networking support - this is a vital distinction, since software is evolving much
more rapidly than hardware, and our clients will have such diverse software needs that we
couldn't possibly keep up with all of them. We will encourage clients to register their software
and use the software's own support options to their full potential. We will, however, keep up to
date with multiple operating systems and networking developments, working with clients to
make sure they have the most appropriate combinations of hardware, OS, networking, backup
systems, and software. Backup and security are becoming higher priorities for all our potential
customers, as internet usage (and its pitfalls) becomes more common, and as more and more
daily records are stored electronically.
Personal market research by the owner indicates an attractive market niche for our services, of
which PC Repair will take full advantage. The very nature of the computing industry, with its
extraordinary rate of technological development, creates a constant need for businesses skilled
in updating and advising customers on computer-related issues.
National chains, such as "Geeks on Call," and Best Buy's "Geek Squad" have seen rapid
growth in demand for these services in the last few years. Customers are seeking skilled help
with everything from installation of software and hardware components, to networking, to
transferring files from an old computer to a new one. Those who can often enlist their tech-
savvy children's help, but others are not so fortunate, and small-business owners need reliable
and quick help with all their computer needs, since every hour down may mean an hour or
more of lost revenue, especially for any business with a website or those doing e-commerce.
The existing computer service market is so extensive that categorizing it is rather difficult. We
have broken our potential market down into two groups, based on their needs: home PC users
and small business clients.
Home PC User
Our home PC user market includes non-tech-savvy residents of the local area (15 mile radius),
generally between the ages of 30 and 70, with at least one home computer. We are not
expecting income from users below 30, who tend to be more comfortable with technology and
willing to attempt repairs and upgrades on their own, without seeking professional assistance.
Such home users generally own a computer to do email, play games, write letters, scan and
print photos, and occasionally to do bookkeeping or taxes. Home PC users with more
sophisticated applications generally have enough tech savvy, from tech experience at work, to
do their own repairs and upgrades. Their hardware needs will include the computer itself,
monitors, keyboards, mouse, printer, and scanner.
This group is growing slightly faster than the overall population growth in our area, in part due
to the increasing demand for computers among retired people and young families, about 7% a
year.
The portion of the small business market we are targeting is growing at around 2% a year.
Need actual charts?
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
MARKET ANALYSIS
YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Potential Customers Growth CAGR
Home PC Users 7% 25,000 26,750 28,623 30,626 32,770 7.00%
Small Business Users 2% 10,000 10,100 10,201 10,303 10,406 1.00%
Other 0% 0 0 0 0 0 0.00%
Total 5.39% 35,000 36,850 38,824 40,929 43,176 5.39%
We recommend using LivePlan as the easiest way to create automatic financials for your
own business plan.
Create your own business plan
Both the software and hardware side of the computer industry continue to turn out new and
revised computer components at alarming rates. For PC Repair this means job security well
into the future. As reported by the Wall Street Journal, there seems to be no end to the
development of the computer market. Business Week expects the computing industry to grow
at a rate of 12% and the processor speeds to continue to expand for years to come.
Secondary market research shows computer service customers tend to be very loyal to
providers that do good work and satisfy their needs. An analysis of PC Repair's main
competitors shows no overwhelming strengths that would be significant barriers to entry into
the market, as our local competitors have serious weaknesses.
The computer maintenance and repair industry is fragmented, with a few large, national
players and hundreds of small, local stores. While most computers are actually repaired in-
store, near the customer, parts for the repair come from major manufacturers and distributors;
delays in receiving necessary parts can significantly slow down the repair process. Large
chains have solved this problem by keeping vast amounts of inventory in stock at all times,
while local stores offer customers the trade-off of personal interaction and trust that may make
up for some delay.
Customers choose computer repair and assistance services based on reputation, previous
experience, and price. They may choose to return to a mediocre provider with whom they're
familiar, rather than try out a new unknown company about whom they've heard nothing.
Large stores, especially the service departments of national chains, have a great advantage
simply in their affiliation with an established brand. Establishing our brand identity and a great
reputation in the first few months is critical to our success. Once we have broken in to the local
market, our great service will turn new clients into permanent clients.
Our services will be second to no one and our prices will be very reasonable for the high
quality service we offer. By providing superior service, word of mouth alone will bring in
many new clients. The satisfaction our consumers find will keep them coming back. There are
two main competitors for the computer upgrade and repair business in this area:
2. Competitor B. Smaller and less known then A, B provides many services for residents
living in east and south parts of town. They are more willing to spend time with a client,
figuring out exactly what his or her needs are, and suggesting new options than competitor
A. However, they have an inefficient ordering system and an unkempt shop, which deters
potential customers and can turn existing customers to the competition. They also do not
offer on-site services, although they are considering instituting a trial pick-up/drop-off
service. They are in the best position to copy our innovations and steal customers, but their
management is complacent and may not respond to competition.
Both of these companies charge rates in excess of PC Repair; we will be able to attract the
price-sensitive market without much work.
1. A value proposition of timely and practical solutions, at a reasonable rate, coupled with
a 100% guarantee.
Quick response: PC Repair will provide same day and after hours service.
A flat rate policy: This undermines the competition, who charge by the hour. The
pricing has been set to reflect the average amount of time it takes to perform the task.
With this strategy we can undercut most competitors and gain local market power.
On-site and pick-up/drop-off services: This will minimize the time and effort a
customer needs to put into dealing with his computer problem.
Suprisingly, our small size is an advantage: customers will recognize me (and future
employees), and will know they will get the same great service every time they call.
To develop good business strategies, perform a SWOT analysis of your business. It's easy
with our free guide and template. Learn how to perform a SWOT analysis
Our marketing strategy will aggressively exploit our competitors' weaknesses. During the
start-up phase, we will run large ads in the business section of the local newspaper, asking,
"Are you fed up with poor customer service for your computer needs?" These ads will focus
on our advantages, including on-site service, competitive rates, and quick response and turn-
around times. They will announce our opening date, and include a coupon for free diagnostic
service for the first 20 customers.
We will follow up on these opening ads with a smaller direct-marketing campaign to small
business owners, with lists drawn from the local Chamber of Commerce. Jack will use his
contacts with business customers from his years as a manager to create a "buzz" about this new
business.
We will offer a promotion during the first 90 days of business to generate business traffic and
word of mouth. Our promo is Spyware removal on any desktop PC for $70 including tax and
software. Spyware is a huge problem for a lot of residential and small business customers, and
the offer should draw a lot of interest.
Our marketing strategy will generate customer inquiries. We will close the deals by offering an
outstanding service and a very reasonable price. Happy customers generate repeat business and
word of mouth. Our toll free number is operational 24 hours a day, seven days a week, and
from 8am to 9pm, I will be available to answer calls. At other times, or when I am on the
phone, an answering service we have hired will catch callers and give them an estimated wait
time for a call-back; this is another step towards delivering a complete solution to our
customers.
Sales forecast figures are based on industry figures for the typical growth of a start-up and
reflect repeat business generated through meeting customer needs.
The sales strategy is a prediction of controllable growth for the first year. PC Repair will focus
on quality and attention to detail to avoid some potential pitfalls encountered by many new
businesses. The predicted growth is moderate in the home PC market and in the small business
arena. However, with aggressive advertising and word of mouth, this will increase. Our
agressive TV advertising will increase our residential and small business customer base as well
as word of mouth within the first year. Within a few months we will have the need for
additional employees to handle the work load. At that time, we will move into a leased space
with additional square footage, and buy a company vehicle to help with the on-site calls.
Our competitors average 75+ calls a month. Given that our advertising will be aggressive, we
expect the same results. The sales forecast is conservative, which gives us a chance to gauge
our experience and adjust the plan accordingly.
We will service all of Ramsford-on-Bitstream, and the surrounding area. We expect that the
majority of our jobs will be performed in the immediate town area. A service technician can
perform an average of 3 jobs per day. Our sales forecast predictions are less than that. With
our agressive advertising campaign we expect nominal growth. We predict it will take a few
weeks for the marketing to settle in with customers. However, we are going to offer a promo
for our services which should generate some substantial results.
The one element of sales not represented in the table below is direct costs for our maintenance
contracts. We estimate these costs at 12% of sales revenue, but expect a delayed occurrence -
that is, we will sell maintenance contracts starting in February, but do not expect to actually
perform maintenance on computers guaranteed under them for the first few months. We will
incur more and more costs from these as time goes on, and the computers age - most of the
service in a maintenance contract is performed within the last quarter of the specified period.
Projections for the direct costs for these contracts can be found in the Profit and Loss Table, as
other costs of sales.
Need actual charts?
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
Create your own business plan
SALES FORECAST
YEAR 1 YEAR 2
Unit Sales
Home PC Unit 166 200
Small Business Unit 264 300
Promo 235 0
Maintenance Contracts 32 60
TOTAL UNIT SALES 697 560
Unit Prices Year 1 Year 2
Home PC Unit $280.00 $300.00
Small Business Unit $500.00 $600.00
Promo $50.00 $0.00
Maintenance Contracts $400.00 $600.00
Sales
Home PC Unit $46,480 $60,000
Small Business Unit $132,000 $180,000
Promo $11,750 $0
Maintenance Contracts $12,800 $36,000
TOTAL SALES $203,030 $276,000
Direct Unit Costs Year 1 Year 2
Home PC Unit $84.00 $90.00
Small Business Unit $105.00 $126.00
Promo $4.00 $0.00
Maintenance Contracts $0.00 $0.00
Direct Cost of Sales
Home PC Unit $13,944 $18,000
Small Business Unit $27,720 $37,800
Promo $940 $0
Maintenance Contracts $0 $0
Subtotal Direct Cost of Sales $42,604 $55,800
Need real financials
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
Create your own business plan
5.4 Milestones
Our milestones, listed in the table below, outline the major events that will promote, as well as
insure the success of PC Repair and keep it a going concern well into the future. We will
measure our success in meeting these milestones every month, and adjust the plan to keep up
with our objectives. Name recognition, in particular, is very important to breaking into this
market - we will conduct a survey by calling 200 randomly selected small businesses from the
Chamber of Commerce listings on the specified dates and asking them whether they have
heard of PC Repair, and if so, what their impression is of our service. If any of the respondents
have actually used our services, we will elicit feedback on their experience with us, and
suggestions for improvement. We will also ask if they would recommend us to a colleague.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
MILESTONES
Milestone Start Date End Date Budget Manager Department
Procurement of materials 12/1/2004 2/1/2005 $1,200 JMH Department
for opening
Start-up Ad Campaign 12/15/2004 2/6/2005 $1,200 JMH Department
Get Loan Approved 1/1/2005 1/17/2005 $0 JMH Department
Open Business 2/7/2005 2/8/2005 $0 JMH Department
Name Recognition by 5% 2/28/2005 2/28/2005 $0 JMH Department
of potential market
Meet with Leasing Agent 3/1/2005 3/10/2005 $0 JMH Department
Interview potential Techs 3/1/2005 4/25/2005 $0 JMH Department
Move into Leased Space 4/1/2005 4/10/2005 $2,000 JMH Department
Sign on Leased Vehicle 4/15/2005 4/20/2005 $6,000 JMH Department
Targeted Ads Begin 4/15/2005 5/15/2005 $4,000 JMH Department
1st Tech Starts 5/1/2005 5/1/2005 $0 JMH Department
2nd Round Tech 7/1/2005 7/31/2005 $0 JMH Department
Interviews
Direct marketing to 7/1/2005 9/30/2005 $8,000 JMH Department
Small Businesses
Increase Name 8/1/2005 8/2/2005 $0 JMH Department
Recognition to 20%
2nd Tech Starts 8/1/2005 8/7/2005 $0 JMH Department
Totals $22,400
Management Summary
PC Repair will be owned and managed by Jack Hacker. Jack has 10 years of experience in the
fields of technical support, networking, and computer training and repair. Jack has also spent
the last three years as the manager of a custom computer building and repair store, and
understands the computer needs of small businesses. Jack is adept at managing his time, and at
quickly responding to multiple customer calls and needs.
For the first three months, Jack will be in charge of all aspects of the business. In the third
month, when another tech is hired, Jack will shift some of his energy from directly responding
to customer needs, to training and managing others to do this work effectively. Jack will
maintain direct control over inventory ordering and bookkeeping, and will try to do as many of
the on-site calls as possible himself. Part of our brand recognition strategy is to identify PC
Repair with Jack's efficiency, friendliness, and technical expertise. The easiest way to
associate the two is for Jack to be a major part of many customers' experiences with us. He
will delegate technical repairs later in the year to the techs working in the leased office space,
and will also train them in his method of direct phone support.
Jack has worked extensively with computer technicians and support staff in the past, and
knows that they work best when given free rein within a set of mutually-agreed-upon
guidelines. The first week of each tech's employment will be dedicated to helping them
understand PC Repair's guidelines:
the customer is frustrated, upset, or confused - but that doesn't make the customer a
problem;
Within this framework, the techs can solve the customer's problem the best way they see fit -
Jack is not a micro manager.
Jack Hacker will be the only employee for the first few months; his salary is directly related to
the success of the business, and will never exceed 18% of sales revenue. In the third month,
we will move to a leased office space and hire a second employee, with a third hire planned for
August, if projections are on target. We plan to hire additional part-time employees in the
second year, to better handle the increasing sales.
Our employees will be skilled professionals, with equally strong technical and people skills. It
is very important to Jack that they be paid salaries commensurate with their abilities and
dedication- happy tech support people make for happy customers. To that end, our full-time
employees will receive health benefits (premiums split between the employee and PC Repair),
paid holidays, and sick time. Those benefits are included in the payroll totals listed below.
PERSONNEL PLAN
YEAR 1 YEAR 2 YEAR 3
Owner $33,000 $38,000 $40,000
Tech1 $21,600 $30,000 $30,000
Tech2 $14,400 $30,000 $30,000
Part Time $0 $12,000 $15,000
TOTAL PEOPLE 3 5 5
Total Payroll $69,000 $110,000 $115,000
Need real financials
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
Create your own business plan
Financial Plan
The following sections include the annual estimates for the standard set of financial tables.
Detailed monthly pro-forma tables are included in the appendix.
Our financial plan calls for limited growth in the first three months, followed by much higher
sales when we move and hire additional employees. These projections are based on sound
market research and ratios for comparable businesses. As we grow, we will keep our operating
expenses down, and maintain a positive cash balance as we repay our three-year loan.
PC Repair's customer base would fluctuate if there was a recess in the economy or other
extenuating circumstances that pertain directly to consumer or industry behavior. However,
given the steady increase in computer users despite the recent recession, we assume that sales
forecasts are unlikely to be dramatically altered by economic events. The table below shows
some of our other assumptions.
GENERAL ASSUMPTIONS
YEAR 1 YEAR 2
Plan Month 1 2
Current Interest Rate 7.00% 70.00%
Other 0 0
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
Fixed costs are projected at a monthly average for the first year. This includes payroll, moving
expenses and rent, purchase of a company vehicle, and other necessities like cell phones and
the answering service. Variable costs (inventory used in repairing or servicing computers) are
projected as well. At these levels, what we need to bring in per month to break even is shown
in the table and chart below. We will reach our break-even point mid-year, although we expect
sales in November and December to dip below this level because of holidays.
Need actual charts?
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
BREAK-EVEN ANALYSIS
Assumptions:
The table below shows our projected profit and loss. There are two lines for direct cost of sales
- the second line shows projected inventory costs of fulfilling our maintenance contracts. The
marketing/promotion line shows our planned advertising program expenses. Although these
are aggressive, we must spend heavily in the first year in order to establish the brand
recognition that will help us break in to the local market.
This table also shows our projected expense increases as we hire more employees and move
into a larger rented space. Before the move, the owner will absorb expenses related to utilities.
In years two and three, we have budgeted for additional expensed equipment to expand our
diagnostic and repair capabilities to keep up with orders.
We are seeking a modest net profit in the first year. As our reputation grows, we will see
higher revenues and net profit over the next three years.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
YEAR 1 YEAR 2
Expenses
Depreciation $0 $0
We recommend using LivePlan as the easiest way to create graphs for your own business
plan.
YEAR 1 YEAR 2
Cash Received
Dividends $0 $0
Our projected growth is much higher than the industry average; in part, this is because we are
a start-up, growing sales steadily in these first three years. We are sure that our sales forecast is
conservative, given the dissatisfaction among local computer users with existing options, and
our planned aggressive marketing campaign.
RATIO ANALYSIS
Percent of Sales
Main Ratios
Activity Ratios
Debt Ratios
Liquidity Ratios
Additional Ratios
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
The Balance Sheet shows a steadily increasing net worth over the next three years. Since we
are planning to rent, and because computer technology changes so rapidly, we will have only
short-term assets, such as computer equipment and furniture. This will make our net worth
much more liquid than many similar businesses.
Assets
Current Assets
Long-term Assets
Long-term Assets $0 $0 $0
Accumulated Depreciation $0 $0 $0
Current Liabilities
Long-term Liabilities $0 $0 $0
SALES FORECAST
Unit
Sales
Home 3 5 3 15 18 20 20 20 17 15 10 20
PC Unit
Small 3 3 3 10 25 35 40 45 50 15 10 25
Busines
s Unit
Promo 0 0 10 30 40 0 40 40 40 0 0 35
Mainte 0 1 1 2 3 3 3 4 4 3 4 4
nance
Contrac
ts
Unit Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont
Prices h1 h2 h3 h4 h5 h6 h7 h8 h9 h 10 h 11 h 12
Home $280 $280 $280 $280 $280 $280 $280 $280 $280 $280 $280 $280
PC Unit .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
Small $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Busines .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
s Unit
Promo $50. $50. $50. $50. $50. $50. $50. $50. $50. $50. $50. $50.
00 00 00 00 00 00 00 00 00 00 00 00
Mainte $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
nance .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
Contrac
ts
Sales
Home $840 $1,4 $840 $4,2 $5,0 $5,6 $5,6 $5,6 $4,7 $4,2 $2,8 $5,6
PC Unit 00 00 40 00 00 00 60 00 00 00
Small $1,5 $1,5 $1,5 $5,0 $12, $17, $20, $22, $25, $7,5 $5,0 $12,
Busines 00 00 00 00 500 500 000 500 000 00 00 500
s Unit
Mainte $0 $400 $400 $800 $1,2 $1,2 $1,2 $1,6 $1,6 $1,2 $1,6 $1,6
nance 00 00 00 00 00 00 00 00
Contrac
ts
TOTAL $2,3 $3,3 $3,2 $11, $20, $24, $28, $31, $33, $12, $9,4 $21,
SALES 40 00 40 500 740 300 800 700 360 900 00 450
Direct Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont
Unit h1 h2 h3 h4 h5 h6 h7 h8 h9 h 10 h 11 h 12
Costs
Home 30.0 $84. $84. $84. $84. $84. $84. $84. $84. $84. $84. $84. $84.
PC Unit 0% 00 00 00 00 00 00 00 00 00 00 00 00
Small 21.0 $105 $105 $105 $105 $105 $105 $105 $105 $105 $105 $105 $105
Busines 0% .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
s Unit
Promo 8.00 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0 $4.0
% 0 0 0 0 0 0 0 0 0 0 0 0
Mainte 12.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0
nance 0% 0 0 0 0 0 0 0 0 0 0 0 0
Contrac
ts
Direct
Cost of
Sales
Home $252 $420 $252 $1,2 $1,5 $1,6 $1,6 $1,6 $1,4 $1,2 $840 $1,6
PC Unit 60 12 80 80 80 28 60 80
Small $315 $315 $315 $1,0 $2,6 $3,6 $4,2 $4,7 $5,2 $1,5 $1,0 $2,6
Busines 50 25 75 00 25 50 75 50 25
s Unit
Mainte $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
nance
Contrac
ts
Subtot $567 $735 $607 $2,4 $4,2 $5,3 $6,0 $6,5 $6,8 $2,8 $1,8 $4,4
al 30 97 55 40 65 38 35 90 45
Direct
Cost of
Sales
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
PERSONNEL PLAN
MON MON MON MON MON MON MON MON MON MON MON MON
TH 1 TH 2 TH 3 TH 4 TH 5 TH 6 TH 7 TH 8 TH 9 TH TH TH
10 11 12
Owne 0 $2,0 $2,0 $2,5 $2,5 $3,0 $3,0 $3,0 $3,0 $3,0 $3,0 $3,0 $3,0
r % 00 00 00 00 00 00 00 00 00 00 00 00
Tech 0 $0 $0 $0 $2,4 $2,4 $2,4 $2,4 $2,4 $2,4 $2,4 $2,4 $2,4
1 % 00 00 00 00 00 00 00 00 00
Part 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Time %
TOTA 1 1 1 2 2 2 3 3 3 3 3 3
L
PEO
PLE
Total $2,0 $2,0 $2,5 $4,9 $5,4 $5,4 $7,8 $7,8 $7,8 $7,8 $7,8 $7,8
Payro 00 00 00 00 00 00 00 00 00 00 00 00
ll
GENERAL ASSUMPTIONS
MON MON MON MON MON MON MON MON MON MON MON MON
TH 1 TH 2 TH 3 TH 4 TH 5 TH 6 TH 7 TH 8 TH 9 TH TH TH
10 11 12
Plan 1 2 3 4 5 6 7 8 9 10 11 12
Mont
h
Curre 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00 7.00
nt % % % % % % % % % % % %
Inter
est
Rate
Long- 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
term % % % % % % % % % % % %
Inter
est
Rate
Tax 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00
Rate % % % % % % % % % % %
Other 0 0 0 0 0 0 0 0 0 0 0 0
Sales $2,340 $3,30 $3,240 $11,5 $20,7 $24,3 $28,8 $31,7 $33,3 $12,9 $9,40 $21,4
0 00 40 00 00 00 60 00 0 50
Direct Cost of $567 $735 $607 $2,43 $4,29 $5,35 $6,04 $6,56 $6,83 $2,83 $1,89 $4,44
Sales 0 7 5 0 5 8 5 0 5
Costs of $0 $0 $48 $96 $144 $144 $144 $192 $192 $144 $192 $192
Fulfilling
Maintenance
Contracts
TOTAL COST $567 $735 $655 $2,52 $4,44 $5,49 $6,18 $6,75 $7,03 $2,97 $2,08 $4,63
OF SALES 6 1 9 4 7 0 9 2 7
Gross Margin $1,773 $2,56 $2,585 $8,97 $16,2 $18,8 $22,6 $24,9 $26,3 $9,92 $7,31 $16,8
5 4 99 01 16 43 30 1 8 13
Gross Margin % 75.77 77.73 79.78 78.03 78.59 77.37 78.53 78.68 78.93 76.91 77.85 78.38
% % % % % % % % % % % %
Expenses
Payroll $2,000 $2,00 $2,500 $4,90 $5,40 $5,40 $7,80 $7,80 $7,80 $7,80 $7,80 $7,80
0 0 0 0 0 0 0 0 0 0
Marketing/Prom $4,000 $1,00 $3,000 $2,00 $2,00 $3,00 $3,00 $2,00 $2,00 $2,00 $2,00 $2,00
otion 0 0 0 0 0 0 0 0 0 0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Lease $0 $0 $1,000 $1,00 $1,00 $1,00 $1,00 $1,00 $1,00 $1,00 $1,00 $1,00
0 0 0 0 0 0 0 0 0
Expensed $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Equipment
Insurance $150 $0 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Website $40 $40 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Answering $200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Service
Mileage $80 $85 $95 $100 $200 $300 $300 $300 $300 $300 $300 $300
Vehicles $0 $0 $6,000 $800 $800 $800 $800 $800 $800 $800 $800 $800
Cell Phones $0 $60 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Utilities $0 $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Internet 15 $0 $0 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
%
Moving $0 $0 $2,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expenses
Total Operating $6,470 $3,18 $15,83 $10,0 $10,6 $11,7 $14,1 $13,1 $13,1 $13,1 $13,1 $13,1
Expenses 5 5 40 40 40 40 40 40 40 40 40
Profit Before ($4,69 ($620 ($13,2 ($1,06 $5,65 $7,06 $8,47 $11,8 $13,1 ($3,21 ($5,82 $3,67
Interest and 7) ) 50) 6) 9 1 6 03 90 9) 2) 3
Taxes
EBITDA ($4,69 ($620 ($13,2 ($1,06 $5,65 $7,06 $8,47 $11,8 $13,1 ($3,21 ($5,82 $3,67
7) ) 50) 6) 9 1 6 03 90 9) 2) 3
Interest $109 $106 $103 $99 $96 $93 $90 $87 $83 $80 $77 $74
Expense
Taxes Incurred ($1,44 ($218 ($4,00 ($350 $1,66 $2,09 $2,51 $3,51 $3,93 ($990 ($1,77 $1,08
2) ) 6) ) 9 0 6 5 2 ) 0) 0
Net Profit ($3,36 ($508 ($9,34 ($816 $3,89 $4,87 $5,87 $8,20 $9,17 ($2,30 ($4,12 $2,51
4) ) 7) ) 4 8 0 1 5 9) 9) 9
Cash
Receive
d
Cash
from
Operatio
ns
Cash $2,3 $3,3 $3,2 $11, $20, $24, $28, $31, $33, $12,9 $9,4 $21,
Sales 40 00 40 500 740 300 800 700 360 00 00 450
SUBTO $2, $3,3 $3,2 $11, $20, $24, $28, $31, $33, $12, $9,4 $21,
TAL 340 00 40 500 740 300 800 700 360 900 00 450
CASH
FROM
OPERA
TIONS
Addition
al Cash
Receive
d
Sales 0.0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Tax, 0%
VAT,
HST/GS
T
Receive
d
New $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Current
Borrowi
ng
New $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other
Liabilitie
s
(interest
-free)
New $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-
term
Liabilitie
s
Sales of $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other
Current
Assets
Sales of $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-
term
Assets
New $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Investm
ent
Receive
d
SUBTO $2, $3,3 $3,2 $11, $20, $24, $28, $31, $33, $12, $9,4 $21,
TAL 340 00 40 500 740 300 800 700 360 900 00 450
CASH
RECEIV
ED
Expendit Mon Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont Mont
ures th 1 h2 h3 h4 h5 h6 h7 h8 h9 h 10 h 11 h 12
Expendit
ures
from
Operatio
ns
Cash $2,0 $2,0 $2,5 $4,9 $5,4 $5,4 $7,8 $7,8 $7,8 $7,80 $7,8 $7,8
Spendin 00 00 00 00 00 00 00 00 00 0 00 00
g
Bill $10 $3,1 $2,3 $10, $8,9 $13, $15, $15, $16, $16,2 $4,5 $4,1
Payment 5 02 53 424 54 556 209 896 290 82 50 52
s
SUBTO $2, $5,1 $4,8 $15, $14, $18, $23, $23, $24, $24, $12, $11,
TAL 105 02 53 324 354 956 009 696 090 082 350 952
SPENT
ON
OPERA
TIONS
Addition
al Cash
Spent
Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Tax,
VAT,
HST/GS
T Paid
Out
Principal $54 $547 $547 $547 $547 $547 $547 $547 $547 $547 $547 $547
Repaym 7
ent of
Current
Borrowi
ng
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Liabilitie
s
Principal
Repaym
ent
Long- $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
term
Liabilitie
s
Principal
Repaym
ent
Purchas $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
e Other
Current
Assets
Purchas $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
e Long-
term
Assets
Dividend $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
s
SUBTO $2, $5,6 $5,4 $15, $14, $19, $23, $24, $24, $24, $12, $12,
TAL 652 49 00 871 901 503 556 243 637 629 897 499
CASH
SPENT
Net ($31 ($2, ($2, ($4,3 $5,8 $4,7 $5,2 $7,4 $8,7 ($11, ($3,4 $8,9
Cash 2) 349) 160) 71) 39 97 44 57 23 729) 97) 51
Flow
Cash $27, $25, $23, $18, $24, $29, $34, $42, $50, $39,1 $35, $44,
Balance 688 340 179 809 647 444 688 145 868 39 642 593
Need real financials
We recommend using LivePlan as the easiest way to create automatic financials for your own
business plan.
M M M M M M M M M M M M
O O O O O O O O O O O O
N N N N N N N N N N N N
T T T T T T T T T T T T
H H H H H H H H H H H H
3 4 5
1 2 6 7 8 9 1 1 1
0 1 2
As S
se t
ts a
r
ti
n
g
B
a
l
a
n
c
e
s
Cu
rr
en
t
As
se
ts
Ca $ $ $ $ $ $ $ $ $ $ $ $ $
sh 2 2 2 2 1 2 2 3 4 5 3 3 4
8 7 5 3 8 4 9 4 2 0 9 5 4
, , , , , , , , , , , , ,
0 6 3 1 8 6 4 6 1 8 1 6 5
0 8 4 7 0 4 4 8 4 6 3 4 9
0 8 0 9 9 7 4 8 5 8 9 2 3
In $ $ $ $ $ $ $ $ $ $ $ $ $
ve 1 6 8 1 2 4 5 6 7 7 4 2 4
nt , 3 9 , , , , , , , , , ,
or 2 3 8 2 6 7 8 6 2 5 6 7 8
y 0 9 7 2 9 4 2 2 8 9 9
0 1 3 7 1 4 2 2 7 7 0
Ot $ $ $ $ $ $ $ $ $ $ $ $ $
he 1 1 1 1 1 1 1 1 1 1 1 1 1
r 0 0 0 0 0 0 0 0 0 0 0 0 0
Cu , , , , , , , , , , , , ,
rr 0 0 0 0 0 0 0 0 0 0 0 0 0
en 0 0 0 0 0 0 0 0 0 0 0 0 0
t 0 0 0 0 0 0 0 0 0 0 0 0 0
As
se
ts
T $ $ $ $ $ $ $ $ $ $ $ $ $
O 3 3 3 3 3 3 4 5 5 6 5 4 5
T 9 8 6 4 1 9 5 1 9 8 3 8 9
A , , , , , , , , , , , , ,
L 2 3 2 4 4 3 3 3 3 3 8 4 4
C 0 2 3 7 8 7 3 3 6 9 2 3 8
U 0 1 8 0 2 4 5 2 6 0 6 9 2
R
R
E
N
T
A
S
SE
TS
Lo
ng
-
te
rm
As
se
ts
Lo $ $ $ $ $ $ $ $ $ $ $ $ $
ng 0 0 0 0 0 0 0 0 0 0 0 0 0
-
te
rm
As
se
ts
Ac $ $ $ $ $ $ $ $ $ $ $ $ $
cu 0 0 0 0 0 0 0 0 0 0 0 0 0
m
ul
at
ed
De
pr
eci
ati
on
T $ $ $ $ $ $ $ $ $ $ $ $ $
O 0 0 0 0 0 0 0 0 0 0 0 0 0
T
A
L
L
O
N
G-
TE
R
M
A
S
SE
TS
T $ $ $ $ $ $ $ $ $ $ $ $ $
O 3 3 3 3 3 3 4 5 5 6 5 4 5
T 9 8 6 4 1 9 5 1 9 8 3 8 9
A , , , , , , , , , , , , ,
L 2 3 2 4 4 3 3 3 3 3 8 4 4
A 0 2 3 7 8 7 3 3 6 9 2 3 8
S 0 1 8 0 2 4 5 2 6 0 6 9 2
SE
TS
Li M M M M M M M M M M M M
ab o o o o o o o o o o o o
ilit n n n n n n n n n n n n
ies t t t t t t t t t t t t
an h h h h h h h h h h h h
d 1 2 3 4 5 6 7 8 9 1 1 1
Ca
pit 0 1 2
al
Cu
rr
en
t
Li
ab
ilit
ies
Ac $ $ $ $ $ $ $ $ $ $ $ $ $
co 0 3 2 1 8 1 1 1 1 1 4 3 1
un , , 0 , 3 4 5 5 6 , , 2
ts 0 0 , 5 , , , , , 4 7 ,
Pa 3 0 1 0 0 6 3 7 1 2 1 7
ya 3 4 3 5 5 8 5 3 3 2 1 8
bl 0 0 0 4 3 0 3
e
Cu $ $ $ $ $ $ $ $ $ $ $ $ $
rr 1 1 1 1 1 1 1 1 1 1 1 1 1
en 9 8 8 7 7 6 5 5 4 4 3 3 2
t , , , , , , , , , , , , ,
Bo 2 6 1 5 0 4 9 3 8 3 7 2 6
rr 2 7 3 8 3 9 4 9 4 0 5 0 6
o 5 8 1 4 7 0 3 6 9 2 5 8 1
wi
ng
Ot $ $ $ $ $ $ $ $ $ $ $ $ $
he 0 0 0 0 0 0 0 0 0 0 0 0 0
r
Cu
rr
en
t
Li
ab
ilit
ies
S $ $ $ $ $ $ $ $ $ $ $ $ $
U 1 2 2 2 2 2 3 3 3 3 1 1 2
B 9 1 0 7 5 9 0 0 0 0 8 6 5
T , , , , , , , , , , , , ,
O 2 7 1 7 5 5 6 7 5 4 1 9 4
T 2 1 3 1 4 4 2 5 8 3 7 1 4
A 5 1 5 4 2 0 3 0 2 2 7 9 4
L
C
U
R
R
E
N
T
LI
A
BI
LI
TI
ES
Lo $ $ $ $ $ $ $ $ $ $ $ $ $
ng 0 0 0 0 0 0 0 0 0 0 0 0 0
-
te
rm
Li
ab
ilit
ies
T $ $ $ $ $ $ $ $ $ $ $ $ $
O 1 2 2 2 2 2 3 3 3 3 1 1 2
T 9 1 0 7 5 9 0 0 0 0 8 6 5
A , , , , , , , , , , , , ,
L 2 7 1 7 5 5 6 7 5 4 1 9 4
LI 2 1 3 1 4 4 2 5 8 3 7 1 4
A 5 1 5 4 2 0 3 0 2 2 7 9 4
BI
LI
TI
ES
Pa $ $ $ $ $ $ $ $ $ $ $ $ $
id- 2 2 2 2 2 2 2 2 2 2 2 2 2
in 3 3 3 3 3 3 3 3 3 3 3 3 3
Ca , , , , , , , , , , , , ,
pit 0 0 0 0 0 0 0 0 0 0 0 0 0
al 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
Re ( ( ( ( ( ( ( ( ( ( ( ( (
tai $ $ $ $ $ $ $ $ $ $ $ $ $
ne 3 3 3 3 3 3 3 3 3 3 3 3 3
d , , , , , , , , , , , , ,
Ea 0 0 0 0 0 0 0 0 0 0 0 0 0
rni 2 2 2 2 2 2 2 2 2 2 2 2 2
ng 5 5 5 5 5 5 5 5 5 5 5 5 5
s ) ) ) ) ) ) ) ) ) ) ) ) )
Ea $ ( ( ( ( ( ( $ $ $ $ $ $
rni 0 $ $ $ $ $ $ 6 8 1 1 1 1
ng 3 3 1 1 1 5 0 , 7 5 1 4
s , , 3 4 0 , 7 8 , , , ,
3 8 , , , 2 0 9 6 5 0
6 7 2 0 1 6 9 8 7 4 6
4 2 1 3 4 3 3 4 4 4
) ) 9 5 1 )
) ) )
T $ $ $ $ $ $ $ $ $ $ $
O 1 1 1 6 5 9 1 2 2 3 3
T 9 6 6 , , , 4 0 8 1 4
A , , , 7 9 8 , , , , ,
L 9 6 1 5 4 3 7 5 7 5 0
C 7 1 0 6 0 4 1 8 8 1 3
A 5 1 3 2 2 4 9 9
PI
T
AL
T $ $ $ $ $ $ $ $ $ $ $ $ $
O 3 3 3 3 3 3 4 5 5 6 5 4 5
T 9 8 6 4 1 9 5 1 9 8 3 8 9
A , , , , , , , , , , , , ,
L 2 3 2 4 4 3 3 3 3 3 8 4 4
LI 0 2 3 7 8 7 3 3 6 9 2 3 8
A 0 1 8 0 2 4 5 2 6 0 6 9 2
BI
LI
TI
ES
A
N
D
C
A
PI
T
AL
Ne $ $ $ $ $ $ $ $ $ $ $ $ $
t 1 1 1 6 5 9 1 2 2 3 3 3 3
W 9 6 6 , , , 4 0 8 7 5 1 4
or , , , 7 9 8 , , , , , , ,
th 9 6 1 5 4 3 7 5 7 9 6 5 0
7 1 0 6 0 4 1 8 8 5 4 1 3
5 1 3 2 2 4 8 9 9 9