Don't bother with copy and paste.

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

Download for free

Maintenance icon Locksmith Business Plan

Start your plan

South Kelleton Keys and Locksmith

Executive Summary

South Kelleton Keys and Locksmith (SKelleton Keys) will be a locksmith shop focusing entirely on locks and security products, founded and managed by Padraic Lawkse, an experienced, certified locksmith. The business will set up a store in South Kelleton and sell lock hardware and services to building management companies, businesses, homeowners, and renters in the community through a combination of direct selling techniques and advertising.

Net profit will rise significantly from its first year of operation to the end of its third year on a projected almost doubling of sales. The business will grow by selling products and services, as well as offering qualified referrals to security product vendors when the company cannot handle a client’s needs directly. An additional locksmith will join the business in the third year to apprentice under Pad Lawkse and expand the company’s business.

South Kelleton Keys and Locksmith seeks a three year business loan, which will fund initial operations along with Pad Lawkse’s own capital investment into the business.

Locksmith business plan, executive summary chart image

1.1 Objectives

The objectives for South Kelleton Keys and Locksmith are:

  1. Launch a store in a highly visible location in South Kelleton
  2. Establish relationships with ten apartment buildings as a preferred vendor for locks in the first year of operation
  3. Achieve a doubling of sales by its third year of operation, with gross margins better than 40% on products

1.2 Mission

South Kelleton Keys and Locksmith will increase the security of buildings, owners, and renters in its neighborhood of South Kelleton by providing the best quality locks and security products, as well as highly skilled installation and repair.

1.3 Keys to Success

To succeed as a locksmith business, SKelleton Keys must:

  1. Develop relationships with building owners
  2. Create awareness in the community of their proximity, quality, and reasonable prices
  3. Respond quickly to requests
  4. Sell “security and peace” of mind rather than “locks”

Company Summary

South Kelleton Keys and Locksmith will establish a new locksmith shop within the neighborhood of South Kelleton. This predominantly residential community, including landlords, homeowners, renters, and other businesses, require locks and security products ranging from the simplest locks to padlocks and advanced products. SKelleton Keys will provide products and installations of deadbolts, padlocks, cylinder locks, camlocks and safes. The business will refer clients to security system partners for more advanced security technologies. They will provide on-site security consultations, installations and repairs. They will copy keys and sell key rings and key chain products.

2.1 Company Ownership

South Kelleton Keys and Locksmith is an LLC owned by Padraic Lawkse, an experienced locksmith who worked as a lock installer and salesperson for ten years.

2.2 Start-up Summary

Start-up expenses include initial liability insurance premiums, covering both the store and general liability for work done on-site at customer homes and offices, rent for one month’s security deposit and two months for the build-out and set-up of the store prior to opening, legal and licensing fees, and stationery and print collateral. A $25,000 surety bond must also be secured as well for an estimated $750 per year. Pre-launch marketing expenses are detailed in the marketing plan and include the creation of a website ($1,000), brochure ($2,500), flyers and ads ($3,500), and other activities.

$40,000 in inventory of locks and key products for sale off the shelf must be purchased prior to opening. Current assets pay for shelves and display cases, a computer and necessary software systems. Long-term assets include a cash register system ($2,000), key cutting machines (3 for approximately $1,000 each), outdoor signage ($500), and fixtures and improvements to the store space ($20,000). Additional tools ($4,500) include hand tools (screwdrivers, hammers, saws, chisels), power tools (drills, hole-saws, saws, sanders), letter and number hand stamps to label and number keys, and a short ladder to reach the top of door frames. $10,000 is reserved for the purchase of a used van and its outfitting with racks and drawers to store parts, tools, and a key cutter.

Locksmith business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal & Licenses $3,000
Surety Bond $750
Stationery $2,000
Insurance $10,000
Rent $6,000
Pre-Launch Marketing $10,000
Other $1,000
Other $0
Total Start-up Expenses $32,750
Start-up Assets
Cash Required $44,250
Start-up Inventory $40,000
Other Current Assets $20,000
Long-term Assets $40,000
Total Assets $144,250
Total Requirements $177,000

Products and Services

Products will be from brand names in lock and security products, such as Schlage and Master Lock, with inexpensive options as well.

Products will include:

  • deadbolts
  • padlocks
  • cylinderlocks
  • camlocks
  • safes
  • key rings
  • key chains
  • locking display cases
  • locking file cabinets
  • tool chests

Large and customizable items like display cases will not be held in inventory, but will be ordered to client specifications from vendors. Catalogs will be available in store for customers to choose from.

Services will include:

  • cutting copies of keys
  • installing all lock products sold
  • on-site security consultations
  • product repair (when possible)
  • referrals to security system sellers who provide sales, installation and repair for more advanced security technologies (electronic and video locks, keypads, camera security systems)

Services will be executed by Padraic Lawkse, a locksmith with technical college and professional experience.

Market Analysis Summary

The locksmith industry sells to consumers and to businesses, with goals of securing residential and commercial real estate and other property. This market ranges from individuals securing a gym locker, to renters adding additional security to their rented space, to landlords, homeowners, and business owners securing entire buildings. 

4.1 Market Segmentation

The market for locksmith products and services in South Kelleton has been broken down into the segments shown in the Market Analysis. They are growing at a slow rate, as South Kelleton is built up and not undergoing much new development.

Building management companies work for landlords, providing management services for buildings ranging from single-family homes to large apartment building complexes. The managers are tasked with reducing the risks of their landlords, providing good service for their tenants in order to attract and retain the best tenants, and keeping costs of service down. They look for ongoing relationships with local vendors with whom they can receive relationship rates for the high volume of business they provide. Locks must be changed frequently for new apartments, for front doors, for mailboxes, and for other rooms in buildings, both when tenants leave and when locks malfunction or are damaged. Robberies or robbery attempts may increase security concerns in given buildings or areas and lead to a spree of lock upgrades.

Homeowners seek basic security for their home, but think of locksmiths as involved in a single transaction. They will look for the reputation and experience of a company, but will not spend a great deal of time comparing locksmiths. They will pick the first of the two or three they contact, and they will find those based on their visibility either in the community or on the internet/Yellow Pages.

Apartment renters generally add a deadbolt to their apartments for greater security, but look for the lowest prices to do so. They think of this work with a locksmith as a single transaction and will not spend too much time comparing prices.

Businesses with real estate may have great amounts of property to protect (all of their inventory and assets) and look for security systems and gates as well as locks. Business owners will seek good prices, but not with a loss of quality and security. They will generally need consultation services as well. Some have large holdings and may work to create ongoing relationships, much like building managers.

Other landlords include absent owners of homes and buildings who do not use a management company. They may not work as professionally as building management companies, and may look for and choose locksmiths through simple searches.

Locksmith business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Building Management Companies 1% 100 101 102 103 104 0.99%
Homeowners 1% 8,000 8,080 8,161 8,243 8,325 1.00%
Apartment Renters 1% 7,000 7,070 7,141 7,212 7,284 1.00%
Businesses with Real Estate 1% 1,000 1,010 1,020 1,030 1,040 0.99%
Other Landlords 1% 1,000 1,010 1,020 1,030 1,040 0.99%
Total 1.00% 17,100 17,271 17,444 17,618 17,793 1.00%

4.2 Target Market Segment Strategy

To seek the most profitable market segments in South Kelleton overall, SKelleton Keys will focus on building management companies, homeowners, and businesses with real estate. Each spend a greater dollar per transaction on locks and generally will have multiple locks or installations sold with every deal.

Furthermore, apartment renters may be referred to SKelleton Keys by their building management companies, creating future revenues from this segment if building managers are sought out first.

4.3 Service Business Analysis

The ALOA (Associated Locksmiths of America), an organization which provides accreditation for locksmiths, provides the following information:

A professionally trained locksmith/security professional may do some or all of the following: install locks, deadbolts and other mechanical or electronic locking devices to safeguard homes, businesses, vehicles and other property. Locksmiths also may modify or repair such devices, rekey locks, make duplicate keys or cards, generate or program new keys/cards for locks whose keys/cards have been lost and respond to emergency calls to unlock vehicles, homes and businesses that have been locked accidentally, or whose locks have malfunctioned.

Some locksmiths install and service electronic alarm and surveillance systems. Many locksmiths specify, design, provide, install and service a wide range of electronic access control systems and closed circuit television (CCTV) systems. Because of the integration of electronic security systems with computers and networks, some locksmiths maintain security hardware and software for computer systems.

When new or replacement locks are required, a locksmith assists the customer in determining the correct types of locks needed based on the security risk/exposure, life safety application and frequency of use. The locksmith installs locks and security devices using manufacturer’s templates and/or industry specifications, by cutting or drilling the proper opening in the selected location with small hand and power tools.

A locksmith may sell, service and install safes for home and business use. Banks have many locking devices and related hardware that require regular service by locksmiths such as; vault doors, time locks, safe deposit boxes and teller equipment.

A locksmith repairs a lock by disassembling and examining it to locate worn or malfunctioning parts, then cleans and adjusts the internal mechanisms and replaces these parts with new ones supplied by the lock’s manufacturer. On occasion, it may be necessary to custom make some repair parts using lathes, drills, grinders, and other power and hand tools. When the repairs have been completed, the locksmith will reassemble the lock and check its operation.

A locksmith makes duplicate keys using a key-duplicating machine. With the customer’s (pattern) key and key blank clamped in their respective vises, the locksmith moves the pattern key across the guide. A rotary cutter cuts the same pattern into the key blank. The locksmith carefully examines the new key to ensure its accuracy.

A locksmith may respond to emergency calls for customers who have accidentally become locked out of a home, business or vehicle. The locksmith begins by examining the lock(s) to determine the best method to circumvent the lock. These methods may include use of lock picks, bypass tools or other special instruments. Fitting a key by code or other skilled means is also a method of opening a lock. Experience, skill and knowledge dictate the method a professional selects to open a lock. There are times when the quality of the lock, concern for safety of occupants and other factors such as a malfunction of the lock may force the locksmith to use destructive techniques to gain entry. Before performing an emergency opening or certain other sensitive tasks, the locksmith may require positive ID procedures.

For security reasons or because keys are stolen or misplaced, many businesses, hotels/motels and apartment complex owners contract with locksmiths to provide new master key systems, reset combinations and rekey their door locks on a regular basis. Some cities and states require locksmiths to be licensed and bonded. The licensing process may include submitting fingerprints, undergoing a state or national background check, passing an examination, and paying a fee to the licensing agency. A self-employed locksmith must also keep business records and maintain a proper inventory of locks, parts, keys and tools.

In our state alone over 290 locksmith businesses are registered with the ALOA and South Kelleton includes 20.

4.3.1 Competition and Buying Patterns

Neighborhood locksmiths with shops depend on a steady stream of street traffic. As some are provided within hardware stores, many of these shops are not aggressive in their competition for business and are susceptible to aggressive marketing by other locksmith businesses. Because the locksmith industry sells to both consumers and businesses, a combination of “pull” marketing through advertising and “push” selling through directed sales efforts are used.

Customers will choose locksmith shops based on their location, the range of security options available, the helpfulness of sales staff, and, finally, price. Some prefer hardware stores with locksmiths which can handle more of their needs in one stop, while others look for specialists because of the greater level of service and expertise they generally provide.

Web Plan Summary

The South Kelleton Keys and Locksmith website will offer basic information about the business, with details on the product line carried, but stopping short of offering e-commerce. Customers will be referred to go to the store to purchase items and to call to schedule consultations. The website will act as an extended brochure for the business for both residential and commercial customers.

5.1 Website Marketing Strategy

The South Kelleton Keys and Locksmith website will be marketed through the following means:

  • Search engine marketing – the purchasing of keywords on Google AdWords which attract local businesses and residents to the store
  • Mention of the website URL on business cards and brochures distributed by the business
  • Mention of the website URL on all ads and flyers

5.2 Development Requirements

The South Kelleton Keys and Locksmith website should offer the following functions:

  • About Us – Description of the business, Padraic Lawkse, and its mission in the South Kelleton community
  • Store Products – Images (from manufacturers) and basic pricing on some products
  • Services – Description of the services offered by SKelleton Keys
  • Partners – Listings of other security businesses which SKelleton Keys partners with to offer electronic and advanced security systems
  • Hours and Location/Directions
  • Contact Information

Strategy and Implementation Summary

To launch South Kelleton Keys and Locksmith, Pad Lawkse must establish its credibility through a product line of quality lock hardware and expert knowledge about locks and security, as well as its visibility through direct selling to businesses and street/community visibility to homeowners in South Kelleton. Product sales will be achieved through its storefront location and services will be rendered on client sites primarily.

6.1 Competitive Edge

South Kelleton Keys and Locksmith will compete by specializing in lock and security concerns, establishing relationships with other security businesses to create a network of additional vendors to serve clients, and by maintaining its expertise through ALOA training.

By specializing in locks and security rather than carrying other types of home and building hardware, the business will focus on its core strength and expertise and develop a reputation in the neighborhood as a specialist.

To offer high-tech security systems, SKelleton Keys will develop a list of preferred security vendors to whom they are comfortable sending on business requiring more specialized security. These vendors will pay a commission to SKelleton Keys on every sale they make through these referrals.

Padraic Lawkse will develop his locksmithing expertise through additional training with the Associated Locksmiths of America. He is currently a Certified Professional Locksmith and will work towards certification as a Certified Master Locksmith, the highest category available. This will ensure that Pad Lawkse’s expertise in locks and security will make customers confident in the service of the business and allow Pad Lawkse to recommend upgrades as they become available or less expensive, when appropriate.

6.2 Marketing Strategy

South Kelleton Keys and Locksmith will focus on business sales to building management companies and businesses with real estate as well as consumer sales to homeowners. This requires a dual approach to marketing.

The following tactics are part of the business sales focus:

  • Design and produce brochures advertising the services offered by South Kelleton Keys and Locksmith
  • Develop a list of businesses in the neighborhood and import this list into salesforce.com
  • Send brochures by direct mail to this list
  • Advertise in trade publications for building management companies
  • Search engine marketing: Bid for keywords around business and building security using Google AdWords
  • Sales efforts to follow up with businesses (see sales strategy)
  • Creating a website for the business and offering additional information beyond the brochure

The following tactics are part of the consumer sales focus:

  • Create attractive signage and post outside and in windows of store to build street visibility
  • Put ad in local newsletters advertising opening of the store
  • Post flyers about the store opening on local bulletin boards in stores and public places
  • Decorate the store for its grand opening and offering free gifts of store branded key chains to early visitors while supplies last
  • Creating a website for the business with information on store products, hours, location, contact information, etc.

6.3 Sales Strategy

Padraic Lawkse will direct the sales efforts of the business which will focus on business sales. He will generate lists of building management companies and area businesses, and use both phone calls and site visits to make management aware of South Kelleton Keys and Locksmith and to qualify the potential customers for future conversations.

These lists will be kept in a salesforce.com account in order to track sales activities and to collect customer information for those who convert to customers.

6.3.1 Sales Forecast

The sales forecast shows that hardware sales and installations will drive the revenue of the business. While hardware sales are a key driver, services provide a much greater gross margin (80% versus 40%). Commissions on referrals to other security businesses will be extremely profitable as the gross margin on these referral fees nears 100%.

Significant growth is expected over the first year and then 30% annual growth in year 2 and 25% in year 3. This is based on continued saturation of the South Kelleton market as building managers begin to refer tenants to SKelleton Keys. A key assumption is that the current locksmith offerings in South Kelleton are lacking and that businesses, homeowners, and building managers will be eager to work with an experienced locksmith with a local shop.

Locksmith business plan, strategy and implementation summary chart image

Locksmith business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3
Sales
Hardware Products $222,964 $289,853 $362,317
Key Services $22,296 $28,985 $36,231
Repair Services $37,147 $48,291 $60,364
Installation Services $111,499 $144,949 $181,186
Emergency Services $29,756 $38,683 $48,354
Referral Commissions $74,329 $96,628 $120,785
Total Sales $497,991 $647,388 $809,235
Direct Cost of Sales Year 1 Year 2 Year 3
Hardware Cost $133,778 $171,013 $213,767
Services Cost $40,140 $52,181 $65,227
Subtotal Direct Cost of Sales $173,918 $223,195 $278,994

6.4 Milestones

The milestone chart shows the execution of the pre-launch marketing activities and the use of $10,000 in marketing funding. The expense for the grand opening is to order store-branded key chains as gifts for customers who visit the store while supplies last.

Locksmith business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Design Brochure 11/1/2009 11/15/2009 $500 Owner SKLK
Print Brochure 11/15/2009 12/1/2009 $2,000 Owner SKLK
Develop Business Mailing List 11/1/2009 12/1/2009 $0 Owner SKLK
Direct Mailing to Businesses 12/1/2009 12/15/2009 $2,000 Owner SKLK
Sales Call Follow ups 8/20/2010 9/19/2010 $0 Owner SKLK
Create Flyer and Ad 8/20/2010 9/19/2010 $500 Owner SKLK
Post Flyers and Run Ads 12/1/2009 12/15/2009 $3,000 Owner SKLK
Store Grand Opening 12/15/2009 12/15/2009 $1,000 Owner SKLK
Create Website 11/1/2009 12/1/2009 $1,000 Owner SKLK
Totals $10,000

Management Summary

Padraic Lawkse, CEO, will manage all store operations, direct sales and marketing, hire, train, and supervise employees, and provide services. He will hire an assistant store manager to staff the store in the first year of operation. The assistant manager will be responsible for bookkeeping, purchasing, basic cleaning, and opening or closing the store. He will run the store during normal business hours five days a week, while Pad Lawkse will run the store on weekends and be present in the store at times during the week when he is not on service calls.

Store staff will be increased in subsequent years. He will also add an additional apprentice locksmith in the third year who will take over basic services and installations, leaving Pad Lawkse to focus on on-site consultations and services requiring greater skill or experience.

7.1 Personnel Plan

As the business is an LLC and Pad Lawkse is the sole member, he will receive all profits from the business, but is not required to take a salary. However, a salary is shown to assist with his tax planning and budgeting. The assistant store manager will be paid a competitive salary with a bonus for performance. An additional store staff person will be hired halfway through the second year and will be paid hourly. This employee will assist with store sales and running the store, leaving store management to the assistant manager.

The assistant locksmith will be hired part way through the third year. He or she will be paid a salary plus bonus and be required to continue seeking additional certifications with the ALOA. This individual will be enticed to stay with the company through growing responsibilities, experience, and pay in future years.

The business will provide health insurance for full-time employees as well as paid sick leave and paid vacation.

Personnel Plan
Year 1 Year 2 Year 3
Owner $51,000 $72,000 $84,000
Assistant Store Manager $48,000 $52,000 $56,000
Store Staff $0 $15,000 $35,000
Assistant Locksmith $0 $0 $20,000
Total People 2 3 4
Total Payroll $99,000 $139,000 $195,000

Financial Plan

South Kelleton Keys and Locksmith will be able to launch based on the savings of its owner and a significant long-term loan, as described in the start-up funding description. After this point, the business will show healthy profits and cash balance to be able to grow with its own cash flow. Steady growth is expected, requiring additional staff, but still using the same basic assets (store, inventory, equipment, etc.) for the most part. As assistant locksmiths work primarily in the field at customer sites, a larger facility is not required to take them on. The owner will keep a healthy cash balance in the business for emergencies and will withdraw additional cash as dividends.

8.1 Start-up Funding

Padraic Lawkse will invest significant startup funding out of his savings and from a credit card line-of-credit to launch the business (current borrowing on the Start-up Funding table). A business loan is sought against the assets of the business to be repaid over the first three years of operation.  

Start-up Funding
Start-up Expenses to Fund $32,750
Start-up Assets to Fund $144,250
Total Funding Required $177,000
Assets
Non-cash Assets from Start-up $100,000
Cash Requirements from Start-up $44,250
Additional Cash Raised $0
Cash Balance on Starting Date $44,250
Total Assets $144,250
Liabilities and Capital
Liabilities
Current Borrowing $10,000
Long-term Liabilities $70,000
Accounts Payable (Outstanding Bills) $20,000
Other Current Liabilities (interest-free) $0
Total Liabilities $100,000
Capital
Planned Investment
Owner $77,000
Other $0
Additional Investment Requirement $0
Total Planned Investment $77,000
Loss at Start-up (Start-up Expenses) ($32,750)
Total Capital $44,250
Total Capital and Liabilities $144,250
Total Funding $177,000

8.2 Important Assumptions

This business plan assumes the availability of potential staff due to a favorable job market and the availability of storefronts to launch the business.

8.3 Break-even Analysis

With a monthly break-even shown in the table below the business is expected to reach break-even from a profit perspective in the seventh month of the first year.

Locksmith business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $25,681
Assumptions:
Average Percent Variable Cost 35%
Estimated Monthly Fixed Cost $16,713

8.4 Projected Profit and Loss

The primary operating expenses for the business will be marketing and promotion which will include advertising, producing direct mail pieces and brochures, ongoing website hosting and maintenance and attending events.

Depreciation of long-term assets includes equipment in the store and tools for services, including both the equipment and tools purchased at start-up and allowances for additional purchases (which are shown on the cash flow statement).

Rent is expected to rise and the business will seek a 5+ year lease on an appropriate storefront space of at least 1,000 square feet.

Insurance and bonding includes ongoing insurance payment for general liability for the store and work at client sites and the van, as well as renewals of the surety bond each year.

Payroll taxes includes payments for health insurance for full-time employees.

Store supplies includes all supplies (not inventory) which are expensed immediately for store cleaning, maintenance, and operation.

Van fuel, maintenance, and parking covers the cost of fuel, ongoing maintenance and upkeep of the van, and parking at customer sites when only pay parking is available.

Training and education includes subscriptions and course work for Padraic Lawkse and for the assistant locksmith to seek expertise in locksmith work.

Locksmith business plan, financial plan chart image

Locksmith business plan, financial plan chart image

Locksmith business plan, financial plan chart image

Locksmith business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $497,991 $647,388 $809,235
Direct Cost of Sales $173,918 $223,195 $278,994
Other Costs of Sales $0 $0 $0
Total Cost of Sales $173,918 $223,195 $278,994
Gross Margin $324,073 $424,193 $530,242
Gross Margin % 65.08% 65.52% 65.52%
Expenses
Payroll $99,000 $139,000 $195,000
Marketing/Promotion $36,000 $40,000 $50,000
Depreciation $18,000 $18,000 $18,000
Rent $24,000 $26,000 $28,000
Utilities $2,400 $2,500 $2,600
Insurance & Bonding $3,600 $3,800 $4,000
Payroll Taxes $0 $0 $0
Store Supplies $6,000 $10,000 $15,000
Van Fuel, Maintenance & Parking $5,550 $7,200 $7,800
Training and Education $6,000 $8,000 $15,000
Total Operating Expenses $200,550 $254,500 $335,400
Profit Before Interest and Taxes $123,523 $169,693 $194,842
EBITDA $141,523 $187,693 $212,842
Interest Expense $7,354 $5,010 $3,670
Taxes Incurred $34,851 $49,405 $57,352
Net Profit $81,318 $115,278 $133,820
Net Profit/Sales 16.33% 17.81% 16.54%

8.5 Projected Cash Flow

Cash flow will become consistently positive by month 6, removing the need for additional funding to get the store and business off the ground. The business will attempt to keep a healthy cash balance in reserve for the potential that equipment or other assets must be repaired or replaced. Steady investments in the assets of the business have been worked in to these projections to account for the gradual replacement of equipment.

The cash flow table shows a budget for the purchase of additional tools and equipment as they become worn out, broken, or lost, and for purchasing tools to install and maintain new types of security devices as they are released to the market so South Kelleton Keys and Locksmith can remain up to date.

The owner will take out dividends from the business when cash flow can support it, while keeping a cash reserve of around $50,000 at any given time in the second and third year in the business.

The borrowing on credit cards will be paid off over the first year.

Locksmith business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $373,493 $485,541 $606,927
Cash from Receivables $83,703 $149,609 $189,051
Subtotal Cash from Operations $457,196 $635,150 $795,977
Additional Cash Received
Sales Tax, VAT, HST/GST Received $0 $0 $0
New Current Borrowing $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0
New Long-term Liabilities $0 $0 $0
Sales of Other Current Assets $0 $0 $0
Sales of Long-term Assets $0 $0 $0
New Investment Received $0 $0 $0
Subtotal Cash Received $457,196 $635,150 $795,977
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $99,000 $139,000 $195,000
Bill Payments $279,896 $407,988 $465,862
Subtotal Spent on Operations $378,896 $546,988 $660,862
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $10,000 $0 $0
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $13,200 $13,400 $13,400
Purchase Other Current Assets $6,000 $8,000 $10,000
Purchase Long-term Assets $3,000 $15,000 $20,000
Dividends $0 $45,000 $65,000
Subtotal Cash Spent $411,096 $628,388 $769,262
Net Cash Flow $46,100 $6,762 $26,715
Cash Balance $90,350 $97,112 $123,828

8.6 Projected Balance Sheet

The business will pay off its current borrowing in its first year of operation and its long-term liabilities over the first three years. Aside from a contingency fund, the business will not retain a great deal of cash in the business, but will pay profits out as dividends for the most part. Net worth will grow steadily, but not radically, over the first three years of operation for this reason.  

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $90,350 $97,112 $123,828
Accounts Receivable $40,795 $53,033 $66,291
Inventory $83,869 $62,147 $75,666
Other Current Assets $26,000 $34,000 $44,000
Total Current Assets $241,014 $246,292 $309,785
Long-term Assets
Long-term Assets $43,000 $58,000 $78,000
Accumulated Depreciation $18,000 $36,000 $54,000
Total Long-term Assets $25,000 $22,000 $24,000
Total Assets $266,014 $268,292 $333,785
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $83,646 $29,046 $39,118
Current Borrowing $0 $0 $0
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $83,646 $29,046 $39,118
Long-term Liabilities $56,800 $43,400 $30,000
Total Liabilities $140,446 $72,446 $69,118
Paid-in Capital $77,000 $77,000 $77,000
Retained Earnings ($32,750) $3,568 $53,847
Earnings $81,318 $115,278 $133,820
Total Capital $125,568 $195,847 $264,667
Total Liabilities and Capital $266,014 $268,292 $333,785
Net Worth $125,568 $195,847 $264,667

8.7 Business Ratios

South Kelleton Keys and Locksmith’s business ratios are compared here to SIC code 7699 for locksmith businesses with annual sales of $500,000 to $1 million. Due to its ownership of a store, SKelleton Keys’ ratios will differ from the average locksmith of a similar volume of sales, as many locksmiths work only from a van. It will carry more inventory and will hold more accounts receivables due to its higher level of business sales. The gross margin is driven higher due to the revenue stream of referral commissions which is almost entirely gross profit.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth n.a. 30.00% 25.00% -1.05%
Percent of Total Assets
Accounts Receivable 15.34% 19.77% 19.86% 12.28%
Inventory 31.53% 23.16% 22.67% 13.40%
Other Current Assets 9.77% 12.67% 13.18% 36.14%
Total Current Assets 90.60% 91.80% 92.81% 61.83%
Long-term Assets 9.40% 8.20% 7.19% 38.17%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 31.44% 10.83% 11.72% 30.66%
Long-term Liabilities 21.35% 16.18% 8.99% 58.05%
Total Liabilities 52.80% 27.00% 20.71% 88.70%
Net Worth 47.20% 73.00% 79.29% 11.30%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 65.08% 65.52% 65.52% 53.42%
Selling, General & Administrative Expenses 48.75% 47.72% 48.99% 22.29%
Advertising Expenses 7.23% 6.18% 6.18% 1.36%
Profit Before Interest and Taxes 24.80% 26.21% 24.08% 6.01%
Main Ratios
Current 2.88 8.48 7.92 1.53
Quick 1.88 6.34 5.98 1.09
Total Debt to Total Assets 52.80% 27.00% 20.71% 88.70%
Pre-tax Return on Net Worth 92.51% 84.09% 72.23% 245.85%
Pre-tax Return on Assets 43.67% 61.38% 57.27% 27.77%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin 16.33% 17.81% 16.54% n.a
Return on Equity 64.76% 58.86% 50.56% n.a
Activity Ratios
Accounts Receivable Turnover 3.05 3.05 3.05 n.a
Collection Days 41 106 108 n.a
Inventory Turnover 4.61 3.06 4.05 n.a
Accounts Payable Turnover 4.11 12.17 12.17 n.a
Payment Days 29 58 26 n.a
Total Asset Turnover 1.87 2.41 2.42 n.a
Debt Ratios
Debt to Net Worth 1.12 0.37 0.26 n.a
Current Liab. to Liab. 0.60 0.40 0.57 n.a
Liquidity Ratios
Net Working Capital $157,368 $217,247 $270,667 n.a
Interest Coverage 16.80 33.87 53.09 n.a
Additional Ratios
Assets to Sales 0.53 0.41 0.41 n.a
Current Debt/Total Assets 31% 11% 12% n.a
Acid Test 1.39 4.51 4.29 n.a
Sales/Net Worth 3.97 3.31 3.06 n.a
Dividend Payout 0.00 0.39 0.49 n.a

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Hardware Products $3,000 $3,900 $5,070 $6,591 $8,568 $11,138 $14,479 $18,823 $24,470 $31,811 $41,354 $53,760
Key Services $300 $390 $507 $659 $857 $1,114 $1,448 $1,882 $2,447 $3,181 $4,135 $5,376
Repair Services $500 $650 $845 $1,098 $1,427 $1,855 $2,412 $3,136 $4,077 $5,300 $6,890 $8,957
Installation Services $1,500 $1,950 $2,535 $3,296 $4,285 $5,570 $7,241 $9,413 $12,237 $15,908 $20,680 $26,884
Emergency Services $400 $520 $676 $879 $1,143 $1,486 $1,932 $2,512 $3,266 $4,246 $5,520 $7,176
Referral Commissions $1,000 $1,300 $1,690 $2,197 $2,856 $3,713 $4,827 $6,275 $8,158 $10,605 $13,786 $17,922
Total Sales $6,700 $8,710 $11,323 $14,720 $19,136 $24,876 $32,339 $42,041 $54,655 $71,051 $92,365 $120,075
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Hardware Cost $1,800 $2,340 $3,042 $3,955 $5,141 $6,683 $8,687 $11,294 $14,682 $19,087 $24,812 $32,256
Services Cost $540 $702 $913 $1,186 $1,542 $2,005 $2,607 $3,389 $4,405 $5,727 $7,445 $9,679
Subtotal Direct Cost of Sales $2,340 $3,042 $3,955 $5,141 $6,683 $8,688 $11,294 $14,682 $19,087 $24,814 $32,257 $41,935
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Owner $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $5,000 $6,000
Assistant Store Manager $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Store Staff $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Assistant Locksmith $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $9,000 $10,000

Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $6,700 $8,710 $11,323 $14,720 $19,136 $24,876 $32,339 $42,041 $54,655 $71,051 $92,365 $120,075
Direct Cost of Sales $2,340 $3,042 $3,955 $5,141 $6,683 $8,688 $11,294 $14,682 $19,087 $24,814 $32,257 $41,935
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,340 $3,042 $3,955 $5,141 $6,683 $8,688 $11,294 $14,682 $19,087 $24,814 $32,257 $41,935
Gross Margin $4,360 $5,668 $7,368 $9,579 $12,453 $16,188 $21,045 $27,359 $35,568 $46,237 $60,108 $78,140
Gross Margin % 65.07% 65.07% 65.07% 65.07% 65.08% 65.08% 65.08% 65.08% 65.08% 65.08% 65.08% 65.08%
Expenses
Payroll $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $9,000 $10,000
Marketing/Promotion $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Depreciation $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance & Bonding $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Payroll Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Store Supplies $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Van Fuel, Maintenance & Parking 15.00% $300 $350 $400 $450 $475 $500 $500 $500 $500 $525 $525 $525
Training and Education $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $16,300 $16,350 $16,400 $16,450 $16,475 $16,500 $16,500 $16,500 $16,500 $16,525 $17,525 $18,525
Profit Before Interest and Taxes ($11,940) ($10,682) ($9,032) ($6,871) ($4,022) ($312) $4,545 $10,859 $19,068 $29,712 $42,583 $59,615
EBITDA ($10,440) ($9,182) ($7,532) ($5,371) ($2,522) $1,188 $6,045 $12,359 $20,568 $31,212 $44,083 $61,115
Interest Expense $699 $690 $681 $672 $656 $641 $619 $598 $576 $542 $508 $473
Taxes Incurred ($3,792) ($3,412) ($2,914) ($2,263) ($1,404) ($286) $1,178 $3,078 $5,548 $8,751 $12,623 $17,743
Net Profit ($8,847) ($7,960) ($6,799) ($5,280) ($3,275) ($667) $2,748 $7,183 $12,944 $20,420 $29,453 $41,399
Net Profit/Sales -132.05% -91.39% -60.04% -35.87% -17.11% -2.68% 8.50% 17.09% 23.68% 28.74% 31.89% 34.48%

Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $5,025 $6,533 $8,492 $11,040 $14,352 $18,657 $24,254 $31,531 $40,991 $53,288 $69,274 $90,056
Cash from Receivables $0 $893 $1,943 $2,526 $3,284 $4,269 $5,549 $7,214 $9,378 $12,192 $15,850 $20,605
Subtotal Cash from Operations $5,025 $7,426 $10,435 $13,566 $17,636 $22,926 $29,804 $38,745 $50,370 $65,480 $85,124 $110,661
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $5,025 $7,426 $10,435 $13,566 $17,636 $22,926 $29,804 $38,745 $50,370 $65,480 $85,124 $110,661
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $9,000 $10,000
Bill Payments $20,124 $3,721 $4,146 $4,690 $5,388 $6,506 $14,937 $25,531 $32,431 $41,406 $53,074 $67,941
Subtotal Spent on Operations $28,124 $11,721 $12,146 $12,690 $13,388 $14,506 $22,937 $33,531 $40,431 $49,406 $62,074 $77,941
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $500 $500 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Purchase Other Current Assets $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $29,724 $13,321 $13,746 $14,290 $15,488 $16,606 $26,037 $36,631 $43,531 $53,506 $66,174 $82,041
Net Cash Flow ($24,699) ($5,896) ($3,311) ($724) $2,148 $6,320 $3,767 $2,114 $6,838 $11,974 $18,949 $28,620
Cash Balance $19,551 $13,656 $10,345 $9,620 $11,768 $18,088 $21,855 $23,969 $30,807 $42,781 $61,730 $90,350

Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $44,250 $19,551 $13,656 $10,345 $9,620 $11,768 $18,088 $21,855 $23,969 $30,807 $42,781 $61,730 $90,350
Accounts Receivable $0 $1,675 $2,959 $3,847 $5,001 $6,501 $8,452 $10,987 $14,283 $18,569 $24,139 $31,381 $40,795
Inventory $40,000 $37,660 $34,618 $30,663 $25,522 $18,839 $17,376 $22,588 $29,365 $38,175 $49,627 $64,515 $83,869
Other Current Assets $20,000 $20,500 $21,000 $21,500 $22,000 $22,500 $23,000 $23,500 $24,000 $24,500 $25,000 $25,500 $26,000
Total Current Assets $104,250 $79,386 $72,233 $66,355 $62,144 $59,609 $66,915 $78,930 $91,617 $112,050 $141,548 $183,126 $241,014
Long-term Assets
Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,500 $41,000 $41,500 $42,000 $42,500 $43,000
Accumulated Depreciation $0 $1,500 $3,000 $4,500 $6,000 $7,500 $9,000 $10,500 $12,000 $13,500 $15,000 $16,500 $18,000
Total Long-term Assets $40,000 $38,500 $37,000 $35,500 $34,000 $32,500 $31,000 $30,000 $29,000 $28,000 $27,000 $26,000 $25,000
Total Assets $144,250 $117,886 $109,233 $101,855 $96,144 $92,109 $97,915 $108,930 $120,617 $140,050 $168,548 $209,126 $266,014
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $20,000 $3,584 $3,991 $4,512 $5,180 $6,020 $14,093 $24,460 $31,064 $39,653 $50,831 $65,057 $83,646
Current Borrowing $10,000 $10,000 $10,000 $10,000 $10,000 $9,500 $9,000 $8,000 $7,000 $6,000 $4,000 $2,000 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $30,000 $13,584 $13,991 $14,512 $15,180 $15,520 $23,093 $32,460 $38,064 $45,653 $54,831 $67,057 $83,646
Long-term Liabilities $70,000 $68,900 $67,800 $66,700 $65,600 $64,500 $63,400 $62,300 $61,200 $60,100 $59,000 $57,900 $56,800
Total Liabilities $100,000 $82,484 $81,791 $81,212 $80,780 $80,020 $86,493 $94,760 $99,264 $105,753 $113,831 $124,957 $140,446
Paid-in Capital $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000 $77,000
Retained Earnings ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750) ($32,750)
Earnings $0 ($8,847) ($16,808) ($23,607) ($28,886) ($32,161) ($32,828) ($30,080) ($22,897) ($9,953) $10,466 $39,919 $81,318
Total Capital $44,250 $35,403 $27,442 $20,643 $15,364 $12,089 $11,422 $14,170 $21,353 $34,297 $54,716 $84,169 $125,568
Total Liabilities and Capital $144,250 $117,886 $109,233 $101,855 $96,144 $92,109 $97,915 $108,930 $120,617 $140,050 $168,548 $209,126 $266,014
Net Worth $44,250 $35,403 $27,442 $20,643 $15,364 $12,089 $11,422 $14,170 $21,353 $34,297 $54,716 $84,169 $125,568