Don't bother with copy and paste.

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

Download for free

Technology Retail icon Electronics Retailer Business Plan

Start your plan

Safe Current

Executive Summary

Safe Current is small business unit of The Cleveland Illuminating Company (TCIC), and electric utility. Safe Current was formed and will be lead by Brian Henderson.

Safe Current has identified three key factors that will be instrumental to its sustainability:

  1. Ensure 100% customer satisfaction: Repeat customers and customer referrals are valuable.
  2. Design and sell meaningful and valuable power protection products.
  3. Design and implement strict financial controls. This is very important because although Safe Current is a small business unit of TCIC, they must be a stand alone entity financially and and yet they have financial and accounting responsibilities to the shareholders of TCIC.

Products
Safe Current will offer two main products, surge arrestors and surge protectors. These products are made by a contract manufacturer and sold under the Safe Current brand name:

  • Surge Arrestors: This is a piece of equipment that is mounted on the outside of a house or business near the meter that offers protection from external electrical surges.
  • Surge Protectors: This is a piece of equipment that protects individual or groups of appliances against internal electrical spikes. All of Safe Currents protectors are of industrial grade.

Management
Brian has an MBA from Case Western Reserve University and has experience working for the large telecom ATT as an assistant project manager, and Allegheny Power working in the value added services department. Safe Current has been forecasted to achieve impressive sales for years two and three, with correspondingly respectable net profit.

Sbp, electronics retailer business plan, executive summary chart image

1.1 Objectives

  • To develop a profitable product for TCIC that is unregulated from the core power generation business services.
  • To become profitable within one year.
  • To use this business as a successful model for future ventures.

1.2 Mission

To develop a family of surge protectors and arrestors for consumers that offer safety and value. Safe Current will leverage the strength of The Cleveland Illuminating Company to help build brand recognition. All customer’s expectations will be exceeded with their innovative, useful products and complete customer satisfaction is guaranteed.

1.3 Keys to Success

  • Offer every customer 100% satisfaction.
  • Design and sell meaningful, valuable, power protection products.
  • Design and employ strict financial controls.
LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Company Summary

Safe Current is an unregulated subsidiary of The Cleveland Illuminating Company that sells direct to businesses and consumers. It will be operated as a stand alone business leveraging the existing resources and goodwill of TCIC.

Safe Current will be located on site at TCIC, using an office within the complex and also sharing TCIC’s computer network connection and phone connections. Safe Current will operate their own customer service call department. Safe Current will use TCIC’s existing call center for sales calls and TCIC’s existing billing system as well as their order fulfillment and shipping departments. Safe Current will pay a flat rate (10%) for these services.

The Cleveland Illuminating Company has chosen to create Safe Current as a means of increasing the rate of return to shareholders outside the government regulated rates available to electric utilities.

2.1 Company Ownership

Safe Current is a wholly owned subsidiary of TCIC.

2.2 Start-up Summary

Safe Current will leverage the existing resources of TCIC and pay a set overhead fee for the resources used. Equipment that will be needed as follows:

  • Five computer stations, one laser printer; Microsoft Office, Access, and proprietary software used by TCIC; network connection to TCIC.
  • Five office furniture setups.
  • A five extension phone system.
Sbp, electronics retailer business plan, company summary chart image

Start-up Funding
Start-up Expenses to Fund $15,600
Start-up Assets to Fund $39,400
Total Funding Required $55,000
Assets
Non-cash Assets from Start-up $17,500
Cash Requirements from Start-up $21,900
Additional Cash Raised $0
Cash Balance on Starting Date $21,900
Total Assets $39,400
Liabilities and Capital
Liabilities
Current Borrowing $0
Long-term Liabilities $50,000
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
Total Liabilities $50,000
Capital
Planned Investment
TCIC $5,000
Other $0
Additional Investment Requirement $0
Total Planned Investment $5,000
Loss at Start-up (Start-up Expenses) ($15,600)
Total Capital ($10,600)
Total Capital and Liabilities $39,400
Total Funding $55,000
Start-up
Requirements
Start-up Expenses
Stationery etc. $100
Brochures $2,000
Website development $5,000
Furniture $1,500
Expensed Equipment $7,000
Total Start-up Expenses $15,600
Start-up Assets
Cash Required $21,900
Start-up Inventory $0
Other Current Assets $3,000
Long-term Assets $14,500
Total Assets $39,400
Total Requirements $55,000

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Market Analysis Summary

Safe Current has identified three distinct market segments that they will target. The first segment is family home owners, typically with children, and the second is single home owners.

These two segments have been chosen because families with children typically have a large number of electronic devices and the upper income single home owners often adopt technology using lots of gadgets in their home.

The third segment is commercial businesses that have equipment they want protected. Competition is very limited for surge arrestors as they require electric utility installation. There is some competition with the surge protectors, however the competitive products are of a consumer level of quality and protection, different from Safe Current’s products which offer industrial levels of protection.

3.1 Market Segmentation

Safe Current has segmented the market into three distinct groups.

Family home owners
This segment generally has electronic equipment and lives in middle- to high-end homes.

  • 69% have at least one child.
  • The median household income is $77,000.
  • Eat out 2.3 times a week.
  • 58% of the families have two incomes.
  • 63% have cable TV.
  • 49% have a broadband Internet connection.

Single home owners
This segment is a single person who owns their own home. They are generally professionals who often use a lot of electronic technology.

  • Ages 25-40.
  • 71% are professionals.
  • The median household income is $62,000.
  • Eat out 2.7 times a week.
  • 72% have cable TV.
  • 71% have a broadband Internet connection.

Commercial sales
This segment is small to mid-size businesses that have expensive electronic equipment that they need protected. Commercial sales are not industry specific. All businesses, regardless of type, have pieces of equipment that can be protected.

Sbp, electronics retailer business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Family homeowners 8% 143,545 154,311 165,884 178,325 191,699 7.50%
Single home owners 8% 165,987 179,266 193,607 209,096 225,824 8.00%
Commercial sales 6% 11,254 11,929 12,645 13,404 14,208 6.00%
Total 7.71% 320,786 345,506 372,136 400,825 431,731 7.71%

3.2 Target Market Segment Strategy

Safe Current is targeting these groups since all tend to have many pieces of electronic equipment all of which are vulnerable to power surges.

While most home owners insurance offers some level of compensation for damage, deductibles are typically high enough that most people do not make claims. Both segments are already customers and aware of TCIC’s reputation for safety, reliability and operational excellence, making it easy to solicit their business.

3.3 Industry Analysis

Safe Current operates selling two similar service devices, surge arrestors and surge protectors. While these products are similar, they have serve different purposes.

The surge arrestors are a product that can only be offered by a utility so it is typically only sold and installed as a package by the utility.

The surge protectors operate within the more general consumer product segment as evidenced by the fact that surge protectors can be found by a wide range of retailers such as hardware stores, do-it-yourself type stores, and computer and electronic retailers.

It should be noted that Safe Current’s parent company, The Cleveland Illuminating Company is an electric utility and is therefore operating within a regulated industry. Current regulation by the public utility commission (PUC) dictates that the rate of return is capped at 10.5% for utility activities.

Safe Current however provides a product that operates within the unregulated area of the utility and therefore does not have rate of return caps. This is quite advantageous to Safe Current because it allows them to leverage the assets of the utility without being held to the same restrictions as the rest of the utility.

3.3.1 Competition and Buying Patterns

Surge arrestors
Safe Current does not face any real competition for the arrestors due to the installation requirement of the electric utility.

While there are four current vendors that sell the actual arrestor equipment, it is far more expensive to buy the equipment and then pay the utility for installation than buying the package (product and installation) directly from the utility.

Surge protectors
Safe Current faces general competition from several sources. This is qualified as general competition since the products typically sold (90% of the time) are of consumer quality versus the industrial quality that Safe Current offers.

Due to TCIC’s direct contacts with electrical component manufacturers and their sheer buying scale/power, Safe Current is able to offer high-quality industrial grade products for prices that are similar to the consumer units. Competitors in this segment include:

  • Hardware stores
  • Mass merchants
  • Do-it-yourself stores
  • Computer retailers
  • Electronic retailers

3.4 Products

Safe Current will offer a family of surge arrestors and surge protectors for consumers. A surge protector protects appliances plugged into it against spikes in voltage.

A surge arrestor or “whole house surge protector” protects all circuits of a house from a surge in current emanating from outside the building. These products will protect consumers and their sensitive electric and electronic appliances from power surges or transient voltage.

A power surge is an increase in voltage significantly above the designated level of flow of electricity. If a surge or spike is high enough it will inflict serious damage, just like applying to much water pressure through a hose. Too much will case the hose to burst. The same thing happens when there is too much electrical pressure through a wire, the wire “bursts.”

Surge protectors work by diverting the extra electricity into the outlet’s grounding wire. A surge arrestor offers the same protection, however, the protection occurs before the current comes into the home. There are several sources of surges.

The most familiar source is lightning. When lightning strikes near a power line, the electrical energy creates a boost of electrical pressure. A surge arrestor is the best form of protection against lightning as a lightning surge will overpower most surge protectors.

A more common source is the operation of high power electrical devices such as refrigerators and air conditioning units. These appliances cause spikes when their compressors or motors are turned on and off, creating sudden, brief demands for power and upsetting the flow of the electrical voltage.

These types of surges can be protected only by surge protectors because the spike occurs within the home and not from the electrical grid.

The last main source of surges come from the utility company’s equipment. The complex system of equipment that brings electrical power from the grid into the home may have points of failure that can cause uneven power transmissions.

A combination of a surge arrestor and surge protectors on major or expensive electric/electronic components can significantly decrease the possibility of surge/spike damage.

Safe Current will offer two main products, surge arrestors and surge protectors. These products are made by a contract manufacturer and sold under the Safe Current brand name:

  • Surge Arrestors (whole house surge arrestors): This is a piece of equipment that is mounted on the outside of a house or business near the meter that offers protection from surges eminating from outside of the house. This product costs $235 including installation.

    Only the electrical utility can install a surge arrestor because the unit is connected directly to the outside meter and the electrical grid. A surge arrestor is the ONLY protection against spikes that come in through the outside electrical lines.

  • Surge Protectors: This is a piece of equipment that protects individual or groups of appliances against internal sources of spikes. A protector offers a bit of protection against outside surges, however, most outside sources of spikes are of high enough voltage to overpower most protectors.

    While most hardware stores, electronic stores, and mass merchants sell some sort of surge protector, the products offered by Safe Current are differentiated by their industrial grade offer and, a far higher level of protection than most other surge protectors. These units are $50 each and offer the best protection when used in conjunction with a surge arrestor. Any type of electric or electronic appliance of value should be protected such as furnaces, refrigerators, stoves, TVs, stereos, computers, modems, phones, etc.

Safe Current has chosen to outsource production because 1) it has numerous relationships with contract manufacturers that can make the products for far less than they can, 2) production would create significant capital costs which are truly unnecessary. The beauty of this business model is the usage of contract manufacturers and the leveraging of TCIC resources.

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Strategy and Implementation Summary

Safe Current has developed a targeted strategy that allows them to leverage their competitive edge and quickly gain market penetration. Safe Current’s competitive edge is its ability to use The Cleveland Illuminating Company’s utility status for the sale of house surge arrestors and protectors.

The marketing strategy will concentrate on the ability to offer supreme, inexpensive protection for an entire family’s stable of electric and electronic appliances. This campaign will be communicated through various methods and will focus on the product offerings coming from the safe, established TCIC, an icon of Cleveland for over 50 years. Please review the following sections for a more detailed analysis.

4.1 Competitive Edge

Safe Current’s competitive edge is their ability to leverage the huge advantage of being aligned with The Cleveland Illuminating Company, an electric utility serving the Cleveland market for over 50 years. TCIC has spent a long time developing brand equity and Safe Current will be able to tap into this equity immediately.

Safe Current will also be able to use TCIC’s extensive vendor connections and buying power. The last component of their competitive edge is Safe Current’s exclusive ability to install house arrestors. This last edge is a sustainable edge since no other company will ever be able to make arrestor installations, a function of the regulated power industry.

4.2 Marketing Strategy

Safe Current’s marketing strategy will seek to communicate the idea that the products that they offer are in effect cheap insurance against large electric and electronic appliance damage or losses.

By proactively purchasing Safe Current’s products, customers are able to protect against loss and damage of all of their expensive appliances. While many homeowners probably have some sort of insurance, deductibles are often prohibitively high, making a claim for damage to one or a couple appliances not worth the money. Safe Current will use several forms of communication for this marketing campaign:

  • Inserts in Bills: Colorful inserts will be added into the bills of TCIC customers. Currently, the customers are receiving a monthly bill from TCIC and inserts are an inexpensive, yet powerful way of reaching the customers.
  • Website: Safe Current will have a website which will be comprehensive in describing the different product offerings as well as allowing the customer to order directly from the site.
  • Direct Mail: Another advantage of the relationship Safe Current has with TCIC is the ability to use their customer database. This allows Safe Current to generate a targeted list of customers that they can send product information to.

4.3 Sales Strategy

Safe Current’s sales campaign will emphasize the fact that Safe Current is a subsidiary of TCIC. This will be effective because TCIC is a well known, stable electric utility known for its safe and reliable operation.

This idea is evidenced by the fact that almost every time that a consumer reaches for a light switch the light goes on. Sure there are interruptions, often weather related, that interrupt the electrical service, but those interruptions are reconnected quite fast.

The utility is stable and safe and is always working to serve the customer. These electricity related products will clearly leverage the brand equity developed by TCIC over the last five decades.

4.3.1 Sales Forecast

The sales forecast has been developed as a forecast and tracking tool to provide the company with realistic sales goals as well as a way to verify progress. The forecast has been developed as a conservative estimate, not an aggressive sales promise.

By adopting a conservative forecast, Safe Current increases the likelihood of reaching sustainable sales growth. The following table and charts provide more detailed information about the sales cycle, both from a temporal viewpoint and a product perspective.

Sbp, electronics retailer business plan, strategy and implementation summary chart image

Sbp, electronics retailer business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3
Sales
Surge Arrestors $56,841 $83,434 $95,454
Surge Protectors $37,515 $55,066 $63,000
Commercial sales $37,515 $55,066 $63,000
Total Sales $131,871 $193,567 $221,453
Direct Cost of Sales Year 1 Year 2 Year 3
Surge Arrestors $15,915 $23,362 $26,727
Surge Protectors $14,256 $20,925 $23,940
Commercial sales $12,380 $18,172 $20,790
Subtotal Direct Cost of Sales $42,551 $62,459 $71,457

4.4 Milestones

Safe Current has identified several quantifiable, reachable milestones that will serve as goals that the entire organization will work toward in order to make Safe Current a sustainable business.

The following table details the specific milestones as well provides a temporal timetable for expected completion dates. Following the table is a chart for a graphical representation of the information.

Sbp, electronics retailer business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Business plan completion 1/1/2003 1/15/2003 $0 Brian Startegic development
First products shipped 1/1/2003 2/15/2003 $0 Brian Operations
$50K in sales 1/1/2003 8/15/2003 $0 Brian Sales
12 months of strong sales, proving concept 1/1/2003 8/30/2004 $0 Brian Operations
Totals $0

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Web Plan Summary

Safe Current’s website will be used as both a marketing and sales tool. It will take on marketing responsibilities as one of the communication methods used to raise awareness regarding Safe Current’s product families. Extensive product information will be included on the site in an easy to use format.

The site will also be used as a sales tool, allowing customers to purchase the products as well as set up installation appointments for the surge arrestors. Allowing the website to offer sales support will provide consumers with a convenient way to purchase the products as well as provide Safe Current with a low-cost sales program that does not require a live sales support agent. The site will periodically be updated to encourage customers to make repeat visits.

5.1 Website Marketing Strategy

Safe Current will market their website in two primary ways:

  • Search engine submission: As search engines become more and more powerful, a large number of Internet users use them to find relevant information on the Internet. Safe Current will submit their site to many popular engines ensuring that their site comes up high on the list of hits.
  • URL reference in all printer material: The Web address, www.safecurrent.com, will be printed on all material that Safe Current uses encouraging consumers to check out the site.

5.2 Development Requirements

The website will be developed by TCIC’s internal Web development team for the price of $5,000.

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Management Summary

Brian Henderson received a Bachelors of Science in business and marketing from the University of Pittsburgh and an MBA from Case Western Reserve University. Upon graduation from the MBA program, Brian went to work for ATT for three years. At ATT Brian was an assistant project manager, selling telephone accessories using direct marketing techniques. After his ATT experience, Brian worked for Allegheny Power, a Pennsylvania-based electric utility. At Allegheny Power Brian was again an assistant project manager in charge of selling commercial businesses value added services. Brian spent three years at Allegheny before joining The Cleveland Illuminating Company as a Project Manager.

6.1 Personnel Plan

As a side business unit of TCIC, Safe Current will have only a few employees. Billing, sales, and order fulfillment will be accomplished using TCIC’s existing organization, paying a 10% fee for these services. The employees/positions that Safe Current will use include:

  • Project Manager: Brian will take on a wide range of functions including business development, product procurement, management, and sales.
  • Customer Service Agents (4): These positions will assist customers calling about Safe Current’s products. Additionally, at times the employees may help Brian with other activities.
Personnel Plan
Year 1 Year 2 Year 3
Project Manager $50,400 $51,000 $53,000
Customer service agent $9,400 $10,800 $10,800
Customer service agent $9,400 $10,800 $900
Customer service agent $9,000 $900 $900
Customer service agent $7,200 $900 $900
Total People 5 5 5
Total Payroll $85,400 $74,400 $66,500

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

Financial Plan

The following sections outline important financial information.

7.1 Important Assumptions

The following table details important financial assumptions.

General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00%
Other 0 0 0

7.2 Break-even Analysis

The Break-even Analysis indicates what will be needed in monthly revenue to reach the break even point.

Sbp, electronics retailer business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $13,732
Assumptions:
Average Percent Variable Cost 32%
Estimated Monthly Fixed Cost $9,301

7.3 Projected Cash Flow

The following chart and table displays projected cash flow.

Sbp, electronics retailer business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $131,871 $193,567 $221,453
Subtotal Cash from Operations $131,871 $193,567 $221,453
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 $15,000 $0 $0
Subtotal Cash Received $146,871 $193,567 $221,453
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $85,400 $74,400 $66,500
Bill Payments $69,962 $101,544 $116,462
Subtotal Spent on Operations $155,362 $175,944 $182,962
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $7,200 $7,813 $7,878
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $162,562 $183,757 $190,840
Net Cash Flow ($15,691) $9,810 $30,614
Cash Balance $6,209 $16,019 $46,633

7.4 Projected Profit and Loss

The following table presents projected profit and loss.

Sbp, electronics retailer business plan, financial plan chart image

Sbp, electronics retailer business plan, financial plan chart image

Sbp, electronics retailer business plan, financial plan chart image

Sbp, electronics retailer business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $131,871 $193,567 $221,453
Direct Cost of Sales $42,551 $62,459 $71,457
Other Costs of Goods $0 $0 $0
Total Cost of Sales $42,551 $62,459 $71,457
Gross Margin $89,320 $131,108 $149,996
Gross Margin % 67.73% 67.73% 67.73%
Expenses
Payroll $85,400 $74,400 $66,500
Sales and Marketing and Other Expenses $6,000 $8,000 $10,000
Depreciation $1,404 $1,404 $1,404
Rent $6,000 $6,000 $6,000
Utilities $0 $0 $0
Insurance $0 $0 $0
Payroll Taxes $12,810 $9,675 $9,975
Other $0 $0 $0
Total Operating Expenses $111,614 $99,479 $93,879
Profit Before Interest and Taxes ($22,294) $31,629 $56,117
EBITDA ($20,890) $33,033 $57,521
Interest Expense $4,610 $3,889 $3,105
Taxes Incurred $0 $8,322 $15,904
Net Profit ($26,904) $19,418 $37,109
Net Profit/Sales -20.40% 10.03% 16.76%

7.5 Business Ratios

The following business ratios detail both ratios specific to Safe Current as well as ratios specific to the general industry. Variances in Safe Current’s ratios relative to the industry’s can be explained by the fact that Safe Current is able to leverage the valuable assets of TCIC, an electric utility, to achieve above market margins. As a small business unit of an electrical utility it is normal for business ratios to be different from the competition.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 46.78% 14.41% 8.79%
Percent of Total Assets
Inventory 22.53% 23.67% 15.38% 17.86%
Other Current Assets 10.42% 7.46% 4.24% 43.53%
Total Current Assets 54.52% 70.94% 85.47% 77.93%
Long-term Assets 45.48% 29.06% 14.53% 22.07%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 29.51% 20.71% 13.67% 31.98%
Long-term Liabilities 148.65% 86.96% 38.28% 20.70%
Total Liabilities 178.16% 107.67% 51.96% 52.68%
Net Worth -78.16% -7.67% 48.04% 47.32%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 67.73% 67.73% 67.73% 20.85%
Selling, General & Administrative Expenses 88.10% 54.09% 50.95% 6.60%
Advertising Expenses 0.00% 0.00% 0.00% 0.49%
Profit Before Interest and Taxes -16.91% 16.34% 25.34% 1.44%
Main Ratios
Current 1.85 3.43 6.25 1.96
Quick 1.08 2.28 5.13 1.15
Total Debt to Total Assets 178.16% 107.67% 51.96% 57.62%
Pre-tax Return on Net Worth 119.55% -898.84% 155.82% 3.71%
Pre-tax Return on Assets -93.44% 68.95% 74.86% 8.76%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin -20.40% 10.03% 16.76% n.a
Return on Equity 0.00% 0.00% 109.07% n.a
Activity Ratios
Inventory Turnover 10.91 7.80 7.00 n.a
Accounts Payable Turnover 9.23 12.17 12.17 n.a
Payment Days 27 30 28 n.a
Total Asset Turnover 4.58 4.81 3.13 n.a
Debt Ratios
Debt to Net Worth 0.00 0.00 1.08 n.a
Current Liab. to Liab. 0.17 0.19 0.26 n.a
Liquidity Ratios
Net Working Capital $7,200 $20,209 $50,844 n.a
Interest Coverage -4.84 8.13 18.07 n.a
Additional Ratios
Assets to Sales 0.22 0.21 0.32 n.a
Current Debt/Total Assets 30% 21% 14% n.a
Acid Test 1.08 2.28 5.13 n.a
Sales/Net Worth 0.00 0.00 6.51 n.a
Dividend Payout 0.00 0.00 0.00 n.a

7.6 Projected Balance Sheet

The following table details the projected balance sheet.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $6,209 $16,019 $46,633
Inventory $6,487 $9,522 $10,894
Other Current Assets $3,000 $3,000 $3,000
Total Current Assets $15,697 $28,542 $60,527
Long-term Assets
Long-term Assets $14,500 $14,500 $14,500
Accumulated Depreciation $1,404 $2,808 $4,212
Total Long-term Assets $13,096 $11,692 $10,288
Total Assets $28,793 $40,234 $70,815
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $8,497 $8,333 $9,683
Current Borrowing $0 $0 $0
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $8,497 $8,333 $9,683
Long-term Liabilities $42,800 $34,987 $27,109
Total Liabilities $51,297 $43,320 $36,793
Paid-in Capital $20,000 $20,000 $20,000
Retained Earnings ($15,600) ($42,504) ($23,086)
Earnings ($26,904) $19,418 $37,109
Total Capital ($22,504) ($3,086) $34,023
Total Liabilities and Capital $28,793 $40,234 $70,815
Net Worth ($22,504) ($3,086) $34,023

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan

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
Surge Arrestors 0% $0 $2,000 $2,435 $3,232 $4,090 $4,645 $5,232 $6,121 $6,653 $7,121 $7,434 $7,878
Surge Protectors 0% $0 $1,320 $1,607 $2,133 $2,699 $3,066 $3,453 $4,040 $4,391 $4,700 $4,906 $5,199
Commercial sales 0% $0 $1,320 $1,607 $2,133 $2,699 $3,066 $3,453 $4,040 $4,391 $4,700 $4,906 $5,199
Total Sales $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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
Surge Arrestors $0 $560 $682 $905 $1,145 $1,301 $1,465 $1,714 $1,863 $1,994 $2,082 $2,206
Surge Protectors $0 $502 $611 $811 $1,026 $1,165 $1,312 $1,535 $1,669 $1,786 $1,864 $1,976
Commercial sales $0 $436 $530 $704 $891 $1,012 $1,140 $1,333 $1,449 $1,551 $1,619 $1,716
Subtotal Direct Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
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
Project Manager 0% $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Customer service agent 0% $0 $400 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $400 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $0 $0 $0 $900 $900 $900 $900 $900 $900 $900 $900
Total People 1 3 4 4 5 5 5 5 5 5 5 5
Total Payroll $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800

General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0

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 $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
Direct Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
Gross Margin $0 $3,143 $3,826 $5,079 $6,427 $7,299 $8,222 $9,619 $10,455 $11,190 $11,682 $12,379
Gross Margin % 0.00% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73%
Expenses
Payroll $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $630 $750 $1,035 $1,035 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,947 $6,867 $9,052 $9,052 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087
Profit Before Interest and Taxes ($5,947) ($3,724) ($5,226) ($3,973) ($3,660) ($2,788) ($1,865) ($468) $368 $1,103 $1,595 $2,292
EBITDA ($5,830) ($3,607) ($5,109) ($3,856) ($3,543) ($2,671) ($1,748) ($351) $485 $1,220 $1,712 $2,409
Interest Expense $412 $407 $402 $397 $392 $387 $382 $377 $372 $367 $362 $357
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,359) ($4,131) ($5,627) ($4,370) ($4,052) ($3,175) ($2,247) ($845) ($4) $736 $1,233 $1,936
Net Profit/Sales 0.00% -89.03% -99.61% -58.28% -42.70% -29.46% -18.51% -5.95% -0.03% 4.46% 7.15% 10.59%

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 $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
Subtotal Cash from Operations $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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 $15,000 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $4,640 $5,649 $22,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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 $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Bill Payments $68 $2,150 $5,278 $4,647 $5,535 $6,335 $6,506 $6,982 $7,864 $7,970 $8,256 $8,369
Subtotal Spent on Operations $4,268 $7,150 $12,178 $11,547 $13,335 $14,135 $14,306 $14,782 $15,664 $15,770 $16,056 $16,169
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 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $4,868 $7,750 $12,778 $12,147 $13,935 $14,735 $14,906 $15,382 $16,264 $16,370 $16,656 $16,769
Net Cash Flow ($4,868) ($3,110) ($7,129) $10,351 ($4,446) ($3,959) ($2,768) ($1,181) ($829) $151 $591 $1,508
Cash Balance $17,032 $13,922 $6,793 $17,144 $12,698 $8,739 $5,971 $4,789 $3,960 $4,111 $4,702 $6,209
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 $21,900 $17,032 $13,922 $6,793 $17,144 $12,698 $8,739 $5,971 $4,789 $3,960 $4,111 $4,702 $6,209
Inventory $0 $0 $1,647 $2,005 $2,661 $3,368 $3,825 $4,308 $5,040 $5,478 $5,864 $6,122 $6,487
Other Current Assets $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Current Assets $24,900 $20,032 $18,569 $11,798 $22,805 $19,066 $15,564 $13,279 $12,830 $12,439 $12,975 $13,823 $15,697
Long-term Assets
Long-term Assets $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500
Accumulated Depreciation $0 $117 $234 $351 $468 $585 $702 $819 $936 $1,053 $1,170 $1,287 $1,404
Total Long-term Assets $14,500 $14,383 $14,266 $14,149 $14,032 $13,915 $13,798 $13,681 $13,564 $13,447 $13,330 $13,213 $13,096
Total Assets $39,400 $34,415 $32,835 $25,947 $36,837 $32,981 $29,362 $26,960 $26,394 $25,886 $26,305 $27,036 $28,793
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 $0 $1,974 $5,124 $4,464 $5,324 $6,119 $6,275 $6,720 $7,599 $7,695 $7,978 $8,076 $8,497
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $1,974 $5,124 $4,464 $5,324 $6,119 $6,275 $6,720 $7,599 $7,695 $7,978 $8,076 $8,497
Long-term Liabilities $50,000 $49,400 $48,800 $48,200 $47,600 $47,000 $46,400 $45,800 $45,200 $44,600 $44,000 $43,400 $42,800
Total Liabilities $50,000 $51,374 $53,924 $52,664 $52,924 $53,119 $52,675 $52,520 $52,799 $52,295 $51,978 $51,476 $51,297
Paid-in Capital $5,000 $5,000 $5,000 $5,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Retained Earnings ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600)
Earnings $0 ($6,359) ($10,490) ($16,117) ($20,487) ($24,538) ($27,713) ($29,960) ($30,805) ($30,809) ($30,073) ($28,840) ($26,904)
Total Capital ($10,600) ($16,959) ($21,090) ($26,717) ($16,087) ($20,138) ($23,313) ($25,560) ($26,405) ($26,409) ($25,673) ($24,440) ($22,504)
Total Liabilities and Capital $39,400 $34,415 $32,835 $25,947 $36,837 $32,981 $29,362 $26,960 $26,394 $25,886 $26,305 $27,036 $28,793
Net Worth ($10,600) ($16,959) ($21,090) ($26,717) ($16,087) ($20,138) ($23,313) ($25,560) ($26,405) ($26,409) ($25,673) ($24,440) ($22,504)

LivePlan Logo

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Create Your Plan