Embed
Email

Business Plan for Garage Door Installation and Repair

Document Sample
Business Plan for Garage Door Installation and Repair
[Company Name] 20









[Company Name]

[Name]

[Address]

Phone: XXX-XXX-XXXX

Email: [Email Address]









© Copyright 2012 Docstoc Inc. 1

[Company Name] 20



Confidentiality Agreement



The undersigned reader acknowledges that the information provided by [Company Name] in this

business plan is confidential; therefore, reader agrees not to disclose it without the express written

permission of [Company Name]



It is acknowledged by reader that information to be furnished in this business plan is in all respects

confidential in nature, other than information which is in the public domain through other means

and that any disclosure or use of same by reader may cause serious harm or damage to [Company

Name]



Upon request, this document is to be immediately returned to [Company Name]









___________________

Signature









___________________

Name (typed or printed)









___________________

Date









This is a business plan. It does not imply an offering of securities.









© Copyright 2012 Docstoc Inc. 2

Table of Contents







1.0 Executive Summary .................................................................................................................... 1

Chart: Highlights .......................................................................................................................... 1

1.1 Objectives.................................................................................................................................... 2

1.2 Mission .......................................................................................................................................... 2

1.3 Keys to Success ........................................................................................................................ 2

2.0 Company Summary ..................................................................................................................... 2

2.1 Company Ownership ............................................................................................................... 2

2.2 Company History ...................................................................................................................... 2

Table: Past Performance ........................................................................................................... 3

Chart: Past Performance ........................................................................................................... 4

3.0 Products and Services ................................................................................................................ 4

4.0 Market Analysis Summary ........................................................................................................ 4

4.1 Market Segmentation ............................................................................................................. 5

Table: Market Analysis ............................................................................................................... 5

Chart: Market Analysis (Pie) .................................................................................................... 5

4.2 Target Market Segment Strategy ...................................................................................... 6

4.3 Service Business Analysis ..................................................................................................... 6

4.3.1 Competition and Buying Patterns .............................................................................. 6

5.0 Web Plan Summary ..................................................................................................................... 7

5.1 Website Marketing Strategy ................................................................................................. 7

5.2 Development Requirements ................................................................................................. 7

6.0 Strategy and Implementation Summary ............................................................................ 7

6.1 SWOT Analysis .......................................................................................................................... 7

6.1.1 Strengths ............................................................................................................................. 8

6.1.2 Weaknesses ........................................................................................................................ 8

6.1.3 Opportunities ..................................................................................................................... 8

6.1.4 Threats ................................................................................................................................. 8

6.2 Competitive Edge ..................................................................................................................... 8

6.3 Marketing Strategy .................................................................................................................. 8

6.4 Sales Strategy ........................................................................................................................... 9

6.4.1 Sales Forecast.................................................................................................................... 9

Table: Sales Forecast ............................................................................................................. 9

Chart: Sales Monthly ............................................................................................................ 10

Chart: Sales by Year ............................................................................................................. 10

6.5 Milestones.................................................................................................................................. 11

Table: Milestones ....................................................................................................................... 11

7.0 Management Summary ............................................................................................................ 11

7.1 Personnel Plan ......................................................................................................................... 12

Table: Personnel ......................................................................................................................... 12

8.0 Financial Plan ............................................................................................................................... 12

8.1 Important Assumptions ....................................................................................................... 12

8.2 Break-even Analysis .............................................................................................................. 13

Table: Break-even Analysis.................................................................................................... 13

Chart: Break-even Analysis ................................................................................................... 13



Page 1

Table of Contents







8.3 Projected Profit and Loss ..................................................................................................... 14

Table: Profit and Loss ............................................................................................................... 14

Chart: Profit Monthly ................................................................................................................ 15

Chart: Profit Yearly .................................................................................................................... 15

Chart: Gross Margin Monthly................................................................................................. 16

Chart: Gross Margin Yearly .................................................................................................... 16

8.4 Projected Cash Flow .............................................................................................................. 17

Table: Cash Flow ........................................................................................................................ 17

Chart: Cash .................................................................................................................................. 18

8.5 Projected Balance Sheet ...................................................................................................... 18

Table: Balance Sheet ................................................................................................................ 19

Table: Ratios ................................................................................................................................ 20

Table: Ratios (Continued) ....................................................................................................... 21

Table: Sales Forecast ......................................................................................................................... 1

Table: Personnel ................................................................................................................................... 1

Table: Profit and Loss ......................................................................................................................... 2

Table: Cash Flow .................................................................................................................................. 3

Table: Balance Sheet .......................................................................................................................... 5









Page 2

[Company Name] 2010



1.0 Executive Summary



[Company Name] of Oklahoma Inc.

Name: [Name]

Address: [Address]

Phone: XXX-XXX-XXXX

Email: [Email Address]



[Company Name]is led by its owner, [Name], who has considerable experience in running an

effective business. [Name] offers 16 years of hands-on industry experience. [Company Name]'

is a garage door installation and repair company, located in Dallas, Texas. The Company was

established in December 2000 as a Sole Proprietorship business.



The focus of this business plan is to put forth objectives to increase the staff to better serve our

customers, acquire an office to display our products and services, to purchase a new office

building and to increase company vehicles to accommodate business. [Company Name] is

ready to elevate to the next step. The Company is seeking grant funding in the amount of

$150,000. The funding will be used to purchase a building as well as a truck and equipment,

hire a secretary, do advertising/marketing, purchase office supplies, purchase inventory, do

repair/maintenance, develop a website and reduce the Company's debt.



Based on the detailed financial projections, [Company Name]' future sales for 2010, 2011

and 2012 are expected to be $197,812, $227,921 and $250,713, respectively.



Chart: Highlights









[Name] [XXX-XXX-XXXX] | 1.0 Executive Summary 1

[Company Name] 2010



1.1 Objectives



[Company Name]has three main objectives:



1. Increase staff to better serve our customers.

2. To purchase a new office building.

3. Increase company vehicles to accommodate business.



1.2 Mission



[Company Name] is dedicated to providing top quality service, sales, and installation to our

customers. We will strive to implement a long-term relationship with our customers, based on

quality and timely service for all of their garage door needs.



1.3 Keys to Success



[Company Name]' keys to success include:



1. Providing professional, quality garage installation and repair services

2. Guarantee client satisfaction

3. Having affordable rates



2.0 Company Summary



[Company Name] of Oklahoma Inc.

Name: [Name]

Address: [Address]

Phone: XXX-XXX-XXXX

Email: [Email Address]



[Company Name] is a garage door installation and repair company headquartered in Dallas,

Texas. The owner of [Company Name] is [Name], who established the Company as a sole

proprietorship business in December 2000. [Name] brings 16 years of experience to the garage

door industry. [Company Name] specializes in the installation and repair of commercial and

residential garage doors and openers.



2.1 Company Ownership



[Company Name]' is a Sole Proprietorship owned by [Name]. [Company Name]was established

in December 2000.



2.2 Company History



The following table and chart shows the past financials for [Company Name] of Oklahoma Inc.



Sales for 2007, 2008, and 2009 were $275,838, $224,834 and $193,798, respectively. The

gross margin for this period was $127,491, $108,496 and $96,843, respectively. Earnings for

this period were $8,421, $2,364 and $14,563, respectively.



Although the Company has been operating since 1994, the corporation wasn't established until

December 2000.



[Name] [XXX-XXX-XXXX] | 2.0 Company Summary 2

[Company Name] 2010







Table: Past Performance



Past Performance

2007 2008 2009

Sales $275,838 $224,834 $193,798

Gross Margin $127,491 $108,496 $96,843

Gross Margin % 46.22% 48.26% 49.97%

Operating Expenses $119,070 $106,132 $82,281



Balance Sheet

2007 2008 2009



Current Assets

Cash ($2,931) $722 ($2,623)

Other Current Assets $26,344 $35,229 $35,229

Total Current Assets $23,413 $35,951 $32,606



Long-term Assets

Long-term Assets $38,754 $43,479 $43,479

Accumulated Depreciation $9,106 $23,483 $23,483

Total Long-term Assets $29,648 $19,996 $19,996



Total Assets $53,061 $55,947 $52,602



Current Liabilities

Accounts Payable $0 $0 $0

Current Borrowing $27,033 $29,339 $22,644

Other Current Liabilities (interest free) $0 $0 ($910)

Total Current Liabilities $27,033 $29,339 $21,734



Long-term Liabilities $34,817 $49,609 $33,012

Total Liabilities $61,850 $78,948 $54,746



Paid-in Capital $1,000 $1,000 $1,000

Retained Earnings ($18,210) ($26,365) ($17,707)

Earnings $8,421 $2,364 $14,563

Total Capital ($8,789) ($23,001) ($2,144)



Total Capital and Liabilities $53,061 $55,947 $52,602



Other Inputs

Payment Days 30 30 30









[Name] [XXX-XXX-XXXX] | 2.0 Company Summary 3

[Company Name] 2010



Chart: Past Performance









3.0 Products and Services



[Company Name] provides customers with a year round, top-notch service. The company

provides services for garage doors and openers. [Company Name] purchase its doors and

openers from Overhead Door Corp, which has been in business since 1921.



As we grow, our main objection is to focus on customer satisfaction. Our pricing is very

competitive with others and we offer exceptional customer service in our area.



4.0 Market Analysis Summary



The U.S. door market is a $15 billion industry that caters to both commercial and residential

businesses. In 2009, the poor state of the housing market severely impacted the door industry;

thus, there were sharp declines in new home construction and existing home re-sales. The

impact was also felt in the builder market. However, metal door manufacturers are benefiting

from the residential market and experienced a sharp increase over the past few years.



Overall, the door industry is expected to recover in 2010. Some of the factors that affect the

demand and distribution in this industry includes: the U.S. housing demand, non-residential

construction spending and mortgage interest rates.



[Company Name]' business plan focuses solely on the commercial and residential door

markets. [Company Name] has the products and services necessary to flourish within these

markets. By supplying quality products and delivering superior customer service, [Company

Name]' potential is excellent.









[Name] [XXX-XXX-XXXX] | 3.0 Products and Services 4

[Company Name] 2010



4.1 Market Segmentation



Our market segmentation scheme is fairly straightforward, and focuses on our target market,

our customers within the commercial and residential business area of Dallas, Texas. These

customers prefer certain quality of work and it’s our duty to deliver on their expectations.



The information contained in our market analysis table, displays [Company Name]' main

markets, which are home owners and commercial businesses. Although the homeowners

market is bigger, [Company Name] has more customers in its commercial market.

Furthermore, all of [Company Name]' clients exist due to its professional reputation as well as

through the long-standing relationship the Company has developed in its competitive industry.



[Company Name]' customers appreciate its work ethics and exceptional service. They utilize the

Company to maximize their productivity. These customers have the option to do business with

other garage door installation companies, but they understand that working with [Company

Name] is beneficial to them because it delivers the dedication and skilled labor that they desire.



Table: Market Analysis



Market Analysis

2010 2011 2012 2013 2014

Potential Growth CAGR

Customers

Homeowners 2% 1,279,910 1,305,508 1,331,618 1,358,250 1,385,415 2.00%

Commercial 2% 135,553 138,264 141,029 143,850 146,727 2.00%

Businesses

Total 2.00% 1,415,463 1,443,772 1,472,647 1,502,100 1,532,142 2.00%







Chart: Market Analysis (Pie)









[Name] [XXX-XXX-XXXX] | 4.0 Market Analysis Summary 5

[Company Name] 2010



4.2 Target Market Segment Strategy



Currently, [Company Name] serves the door market segment. The Company’s choice of target

markets is based on comprehensive experience within the door industry coupled with an in-

depth understanding of the customer's needs. [Company Name]' skills and capabilities have

allowed it to effectively compete and establish a reputation within its area. However

strengthening its marketing strategy will improve its profitability levels and build on to its

customer base.



Because [Company Name] mainly focuses on commercial and residential businesses, the

Company knows how to meet the specific needs of its clients. Therefore, [Company Name] will

utilize the following sales literature to reach its target market:



 business cards

 newspaper ads

 list services on the website

 online ads

 yellow pages

 being listed in the phone book



4.3 Service Business Analysis



The general structure of the industry is the installation and repair of garage doors and openers

in either commercial business and/or residential neighborhoods. [Company Name] purchase its

goods from Overhead Door Corp, which is located in Nebraska. Then the Company sells the

goods and services to the public. It's [Company Name] duty to offer its customers the best

service and products at reasonable prices.



[Company Name] offers distinct services within this market. The Company provides its clients

with services such as:



 garage door installation

 garage door repairs



As simple as it may be, [Company Name]' method of executing exceptional customer service

has an important effect on the bottom line: People want to give their business to those who

appreciate it. Skillful use of advertising and strong communication will bring the business the

Company desires.



4.3.1 Competition and Buying Patterns



[Company Name] exists in a competitive market. Although other companies offer the same

products and services, they cannot compete with the Company’s impeccable customer service,

quality of work and affordable prices. In fact, [Company Name]' customers choose the

Company based on its outstanding reputation, price and longevity in the industry.



[Company Name] competes directly with these other companies by effectively meeting its

customer's needs. The Company thrives due to its longevity within this industry and its

professional credentials. Garage door companies seek to establish strong relationships with

clients to ensure that they are satisfied. [Company Name]' goal is to fulfill client’s demands





[Name] [XXX-XXX-XXXX] | 4.0 Market Analysis Summary 6

[Company Name] 2010



because it aids the Company in generating future business. If the client is happy, they will

recommend the Company to others who need the service.



5.0 Web Plan Summary



[Company Name]' website is an opportunity to offer current information on service offerings,

company background, announcements and special discounts. The website is another method to

generate steady business in our area.



5.1 Website Marketing Strategy



[Company Name]' website will be promoted on all of its marketing materials. The Company will

advertise the site on the fliers and business cards as well as on other industry related

publications and newspaper ads.



5.2 Development Requirements



[Company Name] will have an attractive, simple and informative internet focused website.

The Company we will have a user friendly site from a dependable hosting company.



6.0 Strategy and Implementation Summary



[Company Name] has clearly defined the target market and have differentiated itself by offering

a solid solution to fulfilling its customer’s needs. Reasonable sales targets have been

established with an implementation plan designed to ensure the goals set forth below are

achieved.



6.1 SWOT Analysis



The SWOT analysis aids in displaying the internal strengths and weaknesses that [Company

Name] must address. It allows us to examine the opportunities presented to [Company

Name] as well as potential threats. The Company's strength will help it to succeed. These

strengths are: having years of industry experience, a knowledgeable and friendly staff,

outstanding reputation and clear vision of the market need. Strengths are valuable, but it is

also important to realize the weaknesses [Company Name] must address. These weaknesses

include: limited staff to assist with business demands as well as a limited cash flow.



[Company Name]' strengths will help it capitalize on emerging opportunities. These

opportunities include, but are not limited to, a growing market with a significant percentage of

the target market still not knowing the Company exists, as well as strategic alliances offering

sources for referrals and joint marketing activities to extend our reach. [Company Name]' main

threats involve the Company’s lack of staff and how horrible it would be if something

unexpected happened to the owner or main installer.









[Name] [XXX-XXX-XXXX] | 5.0 Web Plan Summary 7

[Company Name] 2010





6.1.1 Strengths



[Company Name]has much notable strength. These strengths include the Companies:



1. 16 years of industry experience. [Company Name]' has achieved longevity within this

industry. The owner of the Company has an in-depth understanding of the overhead door

industry.

2. Knowledgeable and friendly staff. [Company Name] has a passion for delivering

superior customer service. The staff is well-informed about the door industry and is willing

to share their knowledge and experiences with customers.

3. Reputation. [Company Name] has a strong reputation of successfully installing

and repairing quality garage door openers with exceptional customer relations.

4. Clear vision of the market need. [Company Name] knows the business thoroughly. The

Company knows the customers' needs, and knows the ins and outs of the industry.

[Company Name] also knows how to offer the service that will bring the two together.



6.1.2 Weaknesses



[Company Name]’ weaknesses include:



 limited staff to assist with business demands

 limited cash flow



6.1.3 Opportunities



Opportunities for [Company Name] include:



 Growing market with a significant percentage of our target market still not knowing we

exist.

 Strategic alliances offering sources for referrals and joint marketing activities to extend our

reach.



6.1.4 Threats



[Company Name]' greatest threat involves its lack of staff. If something unexpected happened

to the owner or main installer, the business would suffer.



6.2 Competitive Edge



[Company Name]' competitive edge is its undeniable reliability and honesty. [Company Name]'

managed to position itself as a strategic ally with its customers. By building a business based

on long-standing relationships with satisfied clients, [Company Name] will simultaneously build

defenses against competition. The longer the relationship stands, the more the Company helps

its clients understand what the Company offers them and why they need it.



6.3 Marketing Strategy



[Company Name]' marketing strategy involves advertising and reaching all the potential

clients that it can. [Company Name]' main goal is to provide exceptional service to its

customers. The Company knows what each customer needs and aim to satisfy them.



[Name] [XXX-XXX-XXXX] | 6.0 Strategy and Implementation Summary 8

[Company Name] 2010



Currently, [Company Name] has an advantage because the owner, [Name], is a superior

business woman that has excellent work ethics and communication skills. She also offers 16

years of experience to the garage door industry.



6.4 Sales Strategy



The owner of [Company Name] has a strong sales background that stretches over a 30 year

period. Additionally, the staff members provide excellent customer relation skills and work

ethics; these are the skills which have been useful in making customers comfortable in trusting

the Company to install or repair their garage doors and openers. Keeping customers happy is

an implicit part of building a relationship that will encourage repeat business.



6.4.1 Sales Forecast



The chart and table below show [Company Name]' projected Sales Forecast. Annual projections

for three years are shown here, with first year monthly figures in the appendix.



[Company Name]' sales forecast include:



 Installations

 Service/Repairs



The Company's direct costs of sales include:



 Materials



The sales forecast for 2010, 2011 and 2012 are $197,812, $227,921 and $250,713.



Table: Sales Forecast



Sales Forecast

2010 2011 2012

Sales

Installation $189,065 $217,425 $239,167

Service/Repairs $8,747 $10,496 $11,546

Total Sales $197,812 $227,921 $250,713



Direct Cost of Sales 2010 2011 2012

Materials $96,079 $110,491 $127,064

$0 $0 $0

Subtotal Direct Cost of Sales $96,079 $110,491 $127,064









[Name] [XXX-XXX-XXXX] | 6.0 Strategy and Implementation Summary 9

[Company Name] 2010



Chart: Sales Monthly









Chart: Sales by Year









[Name] [XXX-XXX-XXXX] | 6.0 Strategy and Implementation Summary 10

[Company Name] 2010



6.5 Milestones



In order to achieve the sales and marketing goals that have been outlined in this business

plan, The Company has deadlines to meet and ideas to implement. Some of these are outlined

below:



1. Obtain grant funding to improve business

2. Purchase New Building

3. Purchase New Truck

4. Hire A Secretary

5. Purchase Equipment

6. Do Advertising/Marketing

7. Purchase Office Supplies

8. Purchase Inventory

9. Do Repair/Maintenance

10. Develop a Website

11. Reduce Debt



Table: Milestones



Milestones



Milestone Start Date End Date Budget Manager Department

Purchase Building 7/1/2010 8/10/2010 $15,000 [Name] Administrative

Purchase Truck 7/1/2010 8/10/2010 $30,000 [Name] Administrative

Hire Secretary 7/1/2010 8/10/2010 $24,000 [Name] Human

Resources

Purchase Equipment 7/1/2010 8/10/2010 $16,000 [Name] Administrative

Advertising/Marketing 7/1/2010 8/10/2010 $9,860 [Name] Marketing

Purchase Office 7/1/2010 8/10/2010 $2,100 [Name] Administrative

Equipment

Purchase Inventory 7/1/2010 8/10/2010 $16,000 [Name] Administrative

Repair/Maintenance 7/1/2010 8/10/2010 $1,000 [Name] Operations

Web Design 7/1/2010 8/10/2010 $740 [Name] Administrative

Debt Reduction 7/1/2010 8/10/2010 $35,300 [Name] Accounting

Totals $150,000







7.0 Management Summary



[Name] is the owner of [Company Name]. [Name] has 16 years of managerial experience and

35 years of sales experience. She also has extensive knowledge of the garage door industry.



[Name] manages all aspects of the business without the assistance of an office staff. A future

goal of [Company Name] is to hire personnel to assist with the clerical duties of the growing

business. The Company would benefit tremendously with an additional staff member.









[Name] [XXX-XXX-XXXX] | 7.0 Management Summary 11

[Company Name] 2010



7.1 Personnel Plan



The table below contains the details of [Company Name]’ personnel plan. The detailed monthly

personnel plan for the first year is included in the appendix.



[Name] is the owner and manager of [Company Name]. Currently, all the installations and

repairs are handled by one installer who has his own team of workers. The installer is not a

salaried employee. He is paid hourly at the rate of $45 per/hour.



[Company Name]' future goal is to hire more personnel in 2011 to assist with effectively

running the business.



Table: Personnel



Personnel Plan

2010 2011 2012

Secretary $10,000 $24,000 $24,720



Total People 1 1 1



Total Payroll $10,000 $24,000 $24,720





8.0 Financial Plan



The current financial plan for [Company Name] is to obtain grant funding in the amount of

$150,000. The grant will be used to purchase a building as well as a truck and equipment, hire

secretary, do advertising/marketing, purchase office supplies, purchase inventory, do

repair/maintenance, develop a website and reduce the Company's debt.



The following sections of this plan will serve to describe [Company Name]' financial plan in

more detail:



 General Assumptions

 Break-even Analysis

 Profit and Loss

 Cash Flow

 Balance



8.1 Important Assumptions



The table below presents the assumptions used in the financial calculations of this business

plan.



The average percent variable cost is estimated to be 49%. The estimated monthly fixed cost

is $5,424.









[Name] [XXX-XXX-XXXX] | 12

8.0 Financial Plan

[Company Name] 2010



8.2 Break-even Analysis



For our break-even analysis, the monthly revenue needed to break-even is $7,153. The break-

even analysis has been calculated on the "burn rate" of The Company. [Company Name] feels

that this gives the investor a more accurate picture of the actual risk of the venture.



Table: Break-even Analysis



Break-even Analysis



Monthly Revenue Break-even $7,153



Assumptions:

Average Percent Variable Cost 49%

Estimated Monthly Fixed Cost $3,679







Chart: Break-even Analysis









[Name] [XXX-XXX-XXXX] | 13

8.0 Financial Plan

[Company Name] 2010



8.3 Projected Profit and Loss



[Company Name]' Pro Forma Profit and Loss statement was conservatively constructed and is

based in large part on past performance.



The sales for 2010, 2011 and 2012 are $197,812, $227,921 and $250,713, respectively. The

net profit for the same period is $38,347, $36,121 and $39,913, respectively. The percentages

of the net profit sales for this period were 19.39%, 15.85% and 15.92%, respectively.



Once the Company receives grant funding to add the new assets, the depreciation of the new

fixed assets will be over a five year period and is depreciated by 20%. Since the building and

auto truck totaled $61,000, it’s then divided by 10 years and equals $6,100 a year.



The aggregated amount of miscellaneous expenses is 2% of the total sales.



Table: Profit and Loss



Pro Forma Profit and Loss

2010 2011 2012

Sales $197,812 $227,921 $250,713

Direct Cost of Sales $96,079 $110,491 $127,064

Other Costs of Sales $0 $0 $0

Total Cost of Sales $96,079 $110,491 $127,064



Gross Margin $101,733 $117,430 $123,649

Gross Margin % 51.43% 51.52% 49.32%





Expenses

Payroll $10,000 $24,000 $24,720

Marketing/Promotion $9,864 $10,160 $10,465

Depreciation $2,540 $6,100 $6,100

Rent $3,000 $3,000 $3,000

Utilities $5,124 $5,278 $5,436

Insurance $8,160 $8,405 $8,657

Payroll Taxes $1,500 $3,600 $3,708

Other $3,956 $4,075 $4,197



Total Operating Expenses $44,144 $64,617 $66,283



Profit Before Interest and Taxes $57,589 $52,813 $57,366

EBITDA $60,129 $58,913 $63,466

Interest Expense $2,807 $1,212 $347

Taxes Incurred $16,435 $15,480 $17,106



Net Profit $38,347 $36,121 $39,913

Net Profit/Sales 19.39% 15.85% 15.92%









[Name] [XXX-XXX-XXXX] | 14

8.0 Financial Plan

[Company Name] 2010



Chart: Profit Monthly









Chart: Profit Yearly









[Name] [XXX-XXX-XXXX] | 15

8.0 Financial Plan

[Company Name] 2010



Chart: Gross Margin Monthly









Chart: Gross Margin Yearly









[Name] [XXX-XXX-XXXX] | 16

8.0 Financial Plan

[Company Name] 2010



8.4 Projected Cash Flow



[Company Name] has applied for a grant of $150,000. In 2010, we forecast that we'll receive

$150,000 in the month of July. During this period, we'll use $15,000 to purchase an office

building and $30,000 to purchase a new company truck. These purchases are reflected in the

purchase of other long-term assets. The purchase of office supplies/equipment and inventory is

located in the purchase of current assets.



The Long-term liabilities are $33,012. We've allocated $6,600 to reduce principle. Upon receipt

of grant funding, the Company will use $35,300 to reduce its overall debt.



The following table displays [Company Name]' cash flow, and the chart illustrates monthly cash

flow in the first year. Monthly cash flow projections are also included in the appendix.



Table: Cash Flow



Pro Forma Cash Flow

2010 2011 2012

Cash Received



Cash from Operations

Cash Sales $197,812 $227,921 $250,713

Subtotal Cash from Operations $197,812 $227,921 $250,713



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 $150,000 $0 $0

Subtotal Cash Received $347,812 $227,921 $250,713



Expenditures 2010 2011 2012



Expenditures from Operations

Cash Spending $10,000 $24,000 $24,720

Bill Payments $131,217 $164,117 $178,478

Subtotal Spent on Operations $141,217 $188,117 $203,198



Additional Cash Spent

Sales Tax, VAT, HST/GST Paid Out $0 $0 $0

Principal Repayment of Current Borrowing $22,700 $0 $0

Other Liabilities Principal Repayment $0 $0 $0

Long-term Liabilities Principal Repayment $6,600 $18,100 $6,600

Purchase Other Current Assets $18,100 $0 $0

Purchase Long-term Assets $61,000 $0 $0

Dividends $0 $0 $0

Subtotal Cash Spent $249,617 $206,217 $209,798



Net Cash Flow $98,195 $21,704 $40,915

Cash Balance $95,572 $117,276 $158,191









[Name] [XXX-XXX-XXXX] | 17

8.0 Financial Plan

[Company Name] 2010



Chart: Cash









8.5 Projected Balance Sheet



[Company Name]' net worth is $186,203, $222,324 and $262,237 for 2010, 2011, and 2012,

respectively.









[Name] [XXX-XXX-XXXX] | 18

8.0 Financial Plan

[Company Name] 2010



Table: Balance Sheet



Pro Forma Balance Sheet

2010 2011 2012

Assets



Current Assets

Cash $95,572 $117,276 $158,191

Other Current Assets $53,329 $53,329 $53,329

Total Current Assets $148,901 $170,605 $211,520



Long-term Assets

Long-term Assets $104,479 $104,479 $104,479

Accumulated Depreciation $26,023 $32,123 $38,223

Total Long-term Assets $78,456 $72,356 $66,256

Total Assets $227,357 $242,961 $277,776



Liabilities and Capital 2010 2011 2012



Current Liabilities

Accounts Payable $15,707 $13,290 $14,793

Current Borrowing ($56) ($56) ($56)

Other Current Liabilities ($910) ($910) ($910)

Subtotal Current Liabilities $14,741 $12,324 $13,827



Long-term Liabilities $26,412 $8,312 $1,712

Total Liabilities $41,153 $20,636 $15,539



Paid-in Capital $151,000 $151,000 $151,000

Retained Earnings ($3,144) $35,203 $71,324

Earnings $38,347 $36,121 $39,913

Total Capital $186,203 $222,324 $262,237

Total Liabilities and Capital $227,357 $242,961 $277,776



Net Worth $186,203 $222,324 $262,237









[Name] [XXX-XXX-XXXX] | 19

8.0 Financial Plan

[Company Name] 2010



8.6 Business Ratios



The table below presents ratios from the home equipment maintenance and repair markets as a

reference.



Table: Ratios



Ratio Analysis

2010 2011 2012 Industry

Profile

Sales Growth 2.07% 15.22% 10.00% -1.05%



Percent of Total Assets

Other Current Assets 27.43% 26.10% 22.64% 36.14%

Total Current Assets 70.42% 77.82% 85.94% 61.83%

Long-term Assets 29.58% 22.18% 14.06% 38.17%

Total Assets 100.00% 100.00% 100.00% 100.00%



Current Liabilities -1.98% -9.76% -7.82% 30.66%

Long-term Liabilities 13.58% 9.70% 5.61% 58.05%

Total Liabilities 11.61% -0.06% -2.21% 88.70%

Net Worth 88.39% 100.06% 102.21% 11.30%



Percent of Sales

Sales 100.00% 100.00% 100.00% 100.00%

Gross Margin 51.43% 51.52% 49.32% 53.42%

Selling, General & Administrative 39.29% 37.24% 34.84% 22.29%

Expenses

Advertising Expenses 4.99% 4.46% 4.17% 1.36%

Profit Before Interest and Taxes 18.53% 20.46% 20.38% 6.01%



Main Ratios

Current -35.65 -7.98 -10.99 1.53

Quick -35.65 -7.98 -10.99 1.09

Total Debt to Total Assets 11.61% -0.06% -2.21% 88.70%

Pre-tax Return on Net Worth 19.95% 22.75% 21.54% 245.85%

Pre-tax Return on Assets 17.64% 22.77% 22.02% 27.77%









[Name] [XXX-XXX-XXXX] | 20

8.0 Financial Plan

[Company Name] 2010





Table: Ratios (Continued)



Additional Ratios 2010 2011 2012

Net Profit Margin 12.13% 14.29% 14.48% n.a

Return on Equity 13.97% 15.93% 15.08% n.a



Activity Ratios

Accounts Payable Turnover 9.22 12.17 12.17 n.a

Payment Days 27 32 28 n.a

Total Asset Turnover 1.02 1.12 1.06 n.a



Debt Ratios

Debt to Net Worth 0.13 -0.00 -0.02 n.a

Current Liab. to Liab. -0.17 0.00 0.00 n.a



Liquidity Ratios

Net Working Capital $140,759 $178,918 $220,816 n.a

Interest Coverage 15.57 423.46 0.00 n.a



Additional Ratios

Assets to Sales 0.98 0.90 0.94 n.a

Current Debt/Total Assets -2% -10% -8% n.a

Acid Test 0.00 0.00 0.00 n.a

Sales/Net Worth 1.15 1.11 1.04 n.a

Dividend Payout 0.00 0.00 0.00 n.a









[Name] [XXX-XXX-XXXX] | 21

8.0 Financial Plan

Appendix



Table: Sales Forecast



Sales Forecast

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Sales

Installation $14,097 $14,379 $14,667 $14,960 $15,259 $15,564 $15,875 $16,192 $16,516 $16,846 $17,183 $17,527

Service/Repairs $489 $523 $560 $599 $641 $686 $734 $785 $840 $899 $962 $1,029

Total Sales $14,586 $14,902 $15,227 $15,559 $15,900 $16,250 $16,609 $16,977 $17,356 $17,745 $18,145 $18,556



Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Materials $4,231 $4,696 $5,213 $5,786 $6,422 $7,128 $7,912 $8,782 $9,748 $10,820 $12,010 $13,331



Subtotal Direct Cost of Sales $4,231 $4,696 $5,213 $5,786 $6,422 $7,128 $7,912 $8,782 $9,748 $10,820 $12,010 $13,331



Table: Personnel



Personnel Plan

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Secretary $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000



Total People 0 0 0 0 0 0 0 0 0 0 0 0



Total Payroll $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000









Page 1

Appendix



Table: Profit and Loss



Pro Forma Profit and

Loss

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Sales $14,586 $14,902 $15,227 $15,559 $15,900 $16,250 $16,609 $16,977 $17,356 $17,745 $18,145 $18,556

Direct Cost of Sales $4,231 $4,696 $5,213 $5,786 $6,422 $7,128 $7,912 $8,782 $9,748 $10,820 $12,010 $13,331

Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Total Cost of Sales $4,231 $4,696 $5,213 $5,786 $6,422 $7,128 $7,912 $8,782 $9,748 $10,820 $12,010 $13,331



Gross Margin $10,355 $10,206 $10,014 $9,773 $9,478 $9,122 $8,697 $8,195 $7,608 $6,925 $6,135 $5,225

Gross Margin % 70.99% 68.49% 65.76% 62.81% 59.61% 56.14% 52.36% 48.27% 43.83% 39.03% 33.81% 28.16%





Expenses

Payroll $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000

Marketing/Promotion $822 $822 $822 $822 $822 $822 $822 $822 $822 $822 $822 $822

Depreciation $0 $0 $0 $0 $0 $0 $0 $508 $508 $508 $508 $508

Rent $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250

Utilities $427 $427 $427 $427 $427 $427 $427 $427 $427 $427 $427 $427

Insurance $680 $680 $680 $680 $680 $680 $680 $680 $680 $680 $680 $680

Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $300 $300 $300 $300 $300

Other 2% $292 $298 $305 $311 $318 $325 $332 $340 $347 $355 $363 $371



Total Operating $2,471 $2,477 $2,484 $2,490 $2,497 $2,504 $2,511 $5,327 $5,334 $5,342 $5,350 $5,358

Expenses



Profit Before Interest $7,884 $7,729 $7,530 $7,283 $6,981 $6,618 $6,186 $2,868 $2,274 $1,583 $785 ($133)

and Taxes

EBITDA $7,884 $7,729 $7,530 $7,283 $6,981 $6,618 $6,186 $3,376 $2,782 $2,091 $1,293 $375

Interest Expense $300 $294 $289 $283 $277 $272 $266 $177 $171 $165 $159 $154

Taxes Incurred $2,275 $2,230 $2,173 $2,100 $2,011 $1,904 $1,776 $808 $631 $425 $188 ($86)



Net Profit $5,309 $5,204 $5,069 $4,900 $4,693 $4,443 $4,144 $1,884 $1,472 $993 $438 ($201)

Net Profit/Sales 36.40% 34.92% 33.29% 31.49% 29.51% 27.34% 24.95% 11.10% 8.48% 5.59% 2.41% -1.08%









Page 2

Appendix



Table: Cash Flow



Pro Forma Cash Flow

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Cash Received



Cash from Operations

Cash Sales $14,586 $14,902 $15,227 $15,559 $15,900 $16,250 $16,609 $16,977 $17,356 $17,745 $18,145 $18,556

Subtotal Cash from $14,586 $14,902 $15,227 $15,559 $15,900 $16,250 $16,609 $16,977 $17,356 $17,745 $18,145 $18,556

Operations



Additional Cash Received

Sales Tax, VAT, HST/GST 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Received

New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

New Other Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(interest-free)

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 $150,000 $0 $0 $0 $0 $0

Subtotal Cash Received $14,586 $14,902 $15,227 $15,559 $15,900 $16,250 $166,609 $16,977 $17,356 $17,745 $18,145 $18,556









Page 3

Appendix



Table: Cash Flow (Continued)



Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec



Expenditures from

Operations

Cash Spending $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000

Bill Payments $309 $9,291 $9,713 $10,174 $10,677 $11,227 $11,829 $12,469 $12,611 $13,405 $14,276 $15,234

Subtotal Spent on Operations $309 $9,291 $9,713 $10,174 $10,677 $11,227 $11,829 $14,469 $14,611 $15,405 $16,276 $17,234



Additional Cash Spent

Sales Tax, VAT, HST/GST $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Paid Out

Principal Repayment of $500 $500 $500 $500 $500 $500 $500 $17,200 $500 $500 $500 $500

Current Borrowing

Other Liabilities Principal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Repayment

Long-term Liabilities $550 $550 $550 $550 $550 $550 $550 $550 $550 $550 $550 $550

Principal Repayment

Purchase Other Current $0 $0 $0 $0 $0 $0 $18,100 $0 $0 $0 $0 $0

Assets

Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $61,000 $0 $0 $0 $0

Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Subtotal Cash Spent $1,359 $10,341 $10,763 $11,224 $11,727 $12,277 $91,979 $32,219 $15,661 $16,455 $17,326 $18,284



Net Cash Flow $13,227 $4,561 $4,464 $4,335 $4,173 $3,973 $74,630 ($15,242) $1,695 $1,290 $819 $272

Cash Balance $10,604 $15,165 $19,629 $23,963 $28,136 $32,108 $106,738 $91,496 $93,191 $94,481 $95,300 $95,572









Page 4

Appendix



Table: Balance Sheet



Pro Forma Balance Sheet

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Assets Starting

Balances



Current Assets

Cash ($2,623) $10,604 $15,165 $19,629 $23,963 $28,136 $32,108 $106,738 $91,496 $93,191 $94,481 $95,300 $95,572

Other Current Assets $35,229 $35,229 $35,229 $35,229 $35,229 $35,229 $35,229 $53,329 $53,329 $53,329 $53,329 $53,329 $53,329

Total Current Assets $32,606 $45,833 $50,394 $54,858 $59,192 $63,365 $67,337 $160,067 $144,825 $146,520 $147,810 $148,629 $148,901



Long-term Assets

Long-term Assets $43,479 $43,479 $43,479 $43,479 $43,479 $43,479 $43,479 $104,479 $104,479 $104,479 $104,479 $104,479 $104,479

Accumulated $23,483 $23,483 $23,483 $23,483 $23,483 $23,483 $23,483 $23,483 $23,991 $24,499 $25,007 $25,515 $26,023

Depreciation

Total Long-term Assets $19,996 $19,996 $19,996 $19,996 $19,996 $19,996 $19,996 $80,996 $80,488 $79,980 $79,472 $78,964 $78,456

Total Assets $52,602 $65,829 $70,390 $74,854 $79,188 $83,361 $87,333 $241,063 $225,313 $226,500 $227,282 $227,593 $227,357



Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec



Current Liabilities

Accounts Payable $0 $8,968 $9,375 $9,819 $10,304 $10,834 $11,414 $12,050 $12,165 $12,930 $13,770 $14,692 $15,707

Current Borrowing $22,644 $22,144 $21,644 $21,144 $20,644 $20,144 $19,644 $19,144 $1,944 $1,444 $944 $444 ($56)

Other Current Liabilities ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910) ($910)

Subtotal Current $21,734 $30,202 $30,109 $30,053 $30,038 $30,068 $30,148 $30,284 $13,199 $13,464 $13,804 $14,226 $14,741

Liabilities



Long-term Liabilities $33,012 $32,462 $31,912 $31,362 $30,812 $30,262 $29,712 $29,162 $28,612 $28,062 $27,512 $26,962 $26,412

Total Liabilities $54,746 $62,664 $62,021 $61,415 $60,850 $60,330 $59,860 $59,446 $41,811 $41,526 $41,316 $41,188 $41,153



Paid-in Capital $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $151,000 $151,000 $151,000 $151,000 $151,000 $151,000

Retained Earnings ($17,707) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144) ($3,144)

Earnings $14,563 $5,309 $10,513 $15,582 $20,482 $25,175 $29,617 $33,761 $35,646 $37,118 $38,110 $38,548 $38,347

Total Capital ($2,144) $3,165 $8,369 $13,438 $18,338 $23,031 $27,473 $181,617 $183,502 $184,974 $185,966 $186,404 $186,203

Total Liabilities and $52,602 $65,829 $70,390 $74,854 $79,188 $83,361 $87,333 $241,063 $225,313 $226,500 $227,282 $227,593 $227,357

Capital



Net Worth ($2,144) $3,165 $8,369 $13,438 $18,338 $23,031 $27,473 $181,617 $183,502 $184,974 $185,966 $186,404 $186,203







Page 5


By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!