Powder Coating Manufacturer: Innovative Over Coat

views updated

Powder Coating Manufacturer

BUSINESS PLAN

INNOVATIVE OVER COAT


2800 West 13 Mile
Midland, MI 48506


This plan is the second of two powder coating manufacturer plans included in this edition. Both plan owners site that the changing government regulations have created a demand in the market for a more environmentally friendly coating process. Innovative Over Coat, like Brudder Coating Systems, presents a detailed plan, with industry information that is helpful to anyone considering the powder coating business.


  • executive summary
  • mission
  • description of business
  • market analysis
  • management
  • operations
  • sources and use of funds
  • financial information

EXECUTIVE SUMMARY

The Mission

Innovative Over Coat (IOC) will be the provider of choice in the Midwest for powder coating finishes for custom, refinish parts. IOC will provide these finishes with superior quality and superior service. IOC will retain customers by providing custom colors and superior customer service.

The Market

Powder coatings are the fastest growing sector of the paint industry; 149 million pounds sold in 1992 to 450 million pounds projected for the year 2000. Why is powder growing so quickly? There are three key reasons: it is less expensive to apply than liquid coatings, it is easier to apply than liquid coatings, and there are no solvents so it is more environmentally friendly than liquid coatings.

Many individuals who are refinishing motorcycle, automobile and snowmobile parts are impressed with the appearance and durability of powder coatings. Innovative Over Coat intends to capitalize on this market opportunity.

The Business

Innovative Over Coat (IOC) is a Michigan-based S-Corporation which will provide powder coating application services to metal parts. The initial target market will be individuals who are located in Southeast Michigan and Northwest Ohio, and are rebuilding motorcycles, custom automobiles, boats and snowmobiles.

Why will IOC initially target the refinish market? First, powder coating has a reputation for being a superior finish. Second, the individuals refinishing these "big boy toys" are committed to obtaining a superior finish. Third, powder coating has a reputation for being environmentally friendly. The greening of America is driving individuals to search out ways to reduce environmental impact. They will prefer powder coating.

IOC has already retained one customer, a Linnfield Motorcycles dealer located in Birmingham, Michigan. This dealer is building custom motorcycles, and has committed to hiring Innovative to apply the paint to frame and metal parts. As well as a high volume retail customer base, Linnfield Motorcycles is a high volume parts supplier and will provide Innovative with all of its after market powder coating business.

What kind of parts will IOC be coating? For motorcycles, frames, brackets, fenders, cylinders, and gas tanks. For custom automobiles, brackets, engine parts, and trim pieces. For snowmobiles, skis, frames and brackets.

We have identified more than 480 prospective customers in Michigan and Northwest Ohio. These customers include motorcycle dealers, motorcycle parts dealers, antique and custom automobile shops, and snowmobile dealers. These customers will buy services directly from Innovative, and refer customers to Innovative.

The Competition

There are not enough aquality applicators in the market place to support the growing demand for custom powder coating services. There are 21 powder coating companies in Michigan and Northwest Ohio, but these companies are production shops serving the automotive market. We have identified one small company located in Sandusky, Ohio that is serving this market.

The Owners

The two partners forming this business have the breadth and depth of experience needed to succeed. John Godsey, President, has 16 years total experience, with eight of those years in management. Ike Walton, Vice President of Operations, has been working with the automotive industry for 22 years, and has been installing and operating powder coating systems since 1988. These two individuals make up the core of IOC, and cover the business needs essential for success.

Financial

IOC has developed financial projections for the first three years of operations. IOC is building the business in a manner that will be profitable almost immediately. We project $9,530 profit on $36,250 sales in the first year. Profit will grow to $42,450 on $117,000 sales in the third year.

IOC must obtain financing in order to start this company. IOC is seeking $30,000 in traditional financing to support capital purchase, and a small amount of initial working capital. The owners are providing $10,000 funding: $5,000 cash and $5,000 equipment.

MISSION

Innovative Over Coat (IOC) will be the applicator of choice in the Midwest for custom powder coating finishes. IOC will accomplish this by providing powder coating application services of superior quality combined with superior service. IOC will focus its marketing efforts on parts that require a quality finish.

DESCRIPTION OF BUSINESS

Innovative Over Coat, a Michigan S-Corporation, is a start-up venture that will provide custom powder coating finishing services for metal parts. IOC will provide custom coating services to customers who demand a finish that looks great and will last. IOC will focus our initial marketing efforts on companies and individuals who are building/rebuilding motorcycles, automobiles, and snow mobiles. [This is a market where current and future demand far exceeds the supply.]

IOC will differentiate itself from the competition by:

  • focusing on custom coated parts
  • providing only powder coated finishes
  • providing superior service

Comparison of Liquid and Powder Coatings

(Liquid coating (i.e., paint) involves applying a thin layer of coating to a part. The coating must contain some form of solvent carrier that transfers the paint to the part being coated. The solvent carrier can be water or a chemical such as toluene or xylene. The solvent evaporates, leaving behind the thin film of coating. The coating must cure to form the final, hard finish. Curing can occur in one of several ways based on the formula: evaporation (air dry), baking (elevated temperature dry), use of Ultra-Violet radiation, or use of a catalyst.

By contrast, a powder coating does not involve the use of any liquid. A dry powder is electrostatically applied to the part, and then cured in a baking oven at a temperature of 350 to 425 degrees. There are no solvents to evaporate, eliminating all air emissions. There are no liquids required to clean equipment, eliminating all liquid waste generation.

Powder coatings have proven to be an efficient, economical, and ecologically sound method of industrial finishing. Generally, powders outperform liquids because of their higher molecular weight and greater insolubility; there is less film porosity with superior chemical resistance, toughness, hardness and abrasion resistance.

Some of the advantages of powder coatings include:

  • Powder is an attractive choice over liquid finishing systems because it is a 100 percent solids material that contains no solvents. Powder coatings permit compliance with volatile organic compound (VOC) air pollution standards.
  • Powder eliminates the need for storing flammable paints and solvents. And, there is no liquid paint sludge to dispose as hazardous waste.
  • Oven exhaust and air make up can be reduced because no solvent fumes are emitted during the curing cycle. This results in considerable energy savings.
  • Powder that is not deposited on the part can be reclaimed and reused, increasing material efficiency to as much as 95 to 98 percent.
  • When a coating mistake has been made, powder can be blown off with compressed air and reapplied to the part before baking, further decreasing part rejection.
  • The need for paint mixing is eliminated. Powder is introduced into the feed hopper directly from the box.
  • Powder coatings can offer excellent color consistency, color matching capabilities and color and gloss retention.
  • Clean up is easy; powder can be vacuumed off skin and clothing with a high efficiency vacuum.
  • Soap and water will accomplish the final clean up.

While this all sounds too good to be true, there has historically been one limitation to powder coatings. They could not match the visual performance of a liquid coating. This limitation was eliminated within the past few years, when powder coatings have been developed to match liquid coatings in all measures of performance.

MARKET ANALYSIS

Market Trend

IOC has selected powder coating finishes because they are the finish of the future. Powder coating is the fastest growing segment of the coating industry. Powder coating sales have nearly doubled since 1992 (149 million pounds in 1992 to 257 million pounds in 1995), and are expected to nearly double again by the year 2000. Sales are projected to be 450 million pounds by the year 2000.

Powder coating sales have grown at the expense of other types of coatings, and manufacturers are converting from liquid coating to powder coating. Liquid paint (solvent borne and water borne) will drop from 16 percent of the market in 1995 to 67 percent in 2000. Powder coating will increase from 15 percent in 1995 to 22 percent in 2000.

The conversion from liquid to powder is happening for several reasons. First, it is environmentally friendly. Powder coating causes no air emissions and produces no hazardous waste. Second, it is less expensive. Applying powder coating costs one tenth of the cost of the application of liquid coating.

IOC has further evaluated the market by interviewing numerous powder coating users, and other experts in the field. Customers, paint manufacturers, and painting equipment manufacturers agree that there are few custom powder coaters in the Midwest who can consistently, and reliably apply powder coating to meet the demanding standards of our targeted market segment.

Target Markets

IOC will initially target the custom refinishing of motorcycle, automobile, and snowmobile parts. Why? First, these individuals demand a high quality finish. Second, these individuals are willing to spend more money to get a high quality finish. Third, these individuals know that a powder coating finish is superior to a liquid coating finish in performance and look. Furthermore, IOC partners have an extensive network of contacts in the motorcycle industry.

Organization Of The Sales Effort

How will we get customers? IOC will initially work through other companies to obtain business. We have identified more than 480 companies in Michigan and Northwest Ohio: motorcycle dealers, motorcycle parts dealers, antique and custom automobile shops, and snowmobile dealers. These companies can use our services directly and refer customers to Innovative.

Sales will be accomplished only through internal resources. IOC is presently building a reputation with local Linnfield dealerships. We will use this "word of mouth" advertising in combination with advertising in trade publications, trade shows and mailings to local dealerships.

IOC has already established a relationship with Linnfield Motorcycles in Birmingham, Michigan. Linnfield is key to market entry. Linnfield is an established dealer of motorcycles and is a meeting place for the local Linnfield owner's club. They are developing a line of custom motorcycles that will sell for more than $30,000 each; this will showcase the IOC quality finish.

As stated above, Linnfield wants IOC to paint all of their custom motorcycles. They have already agreed to refer customers and other motorcycle dealers needing powder coating to IOC. IOC needs more than one customer to survive.

We will expand our customer base using the following steps:

  • Personal contact to the owners of the 12 Linnfield Motorcycle dealers located in Michigan and Southeast Ohio.
  • Develop a point-of-sale display for parts counters at these 12 dealers. This provides access to their customers, and a constant reminder to the dealers.
  • Personal contact to owners of antique automobile/auto customizing companies and snow mobile dealers in Northwest Michigan.
  • Develop a point-of-sale display for parts counters at these companies, as appropriate. This provides access to their customers, and a constant reminder to the owners and their employees.
  • Develop brochure and price list for POS display.
  • Mailing of brochure and price list to the remainder of the 482 companies on the prospect list.

Competitive Analysis

Our research shows that there are not enough quality applicators in the market place to support the growing demand for powder coating services. Our research shows that the demand will continue to grow. Innovative Coating will position itself from day one to fulfill the needs of this market segment.

Innovative Coatings will compete in a marketplace that currently lacks service providers. We compiled a list of Midwest companies who apply powder coatings. Out of the twenty-one (21) competitors we found, ten are located in Northwest Ohio. Of these ten companies, only four (4) are custom powder coaters. The other companies are production powder coaters (large production runs for the automotive industry).

IOC will differentiate themselves from these companies in three ways:

  • custom powder coating will be our only business
  • applying a quality finish will be our primary focus
  • exceptional customer service will be a key part of our product

Innovative Coating recognizes that customers demand "Service Beyond The Sale." IOC will develop a partnership with customers and suppliers. We'll make sure that every job is done right. IOC will exceed customer expectations. IOC will provide technical support when a problem arises, rapid response to customer demands, and flexible company hours. IOC has extensive application experience, and can work closely with the customer to develop cost effective techniques to insure the highest quality finishes.

Customer Profile

People who want to buy a new Linnfield motorcycle are willing to wait two to three years before taking delivery. This is the commitment to owning one of "America's premiere" motorcycles. This same commitment extends to the many individuals who are rebuilding older Linnfield motorcycles to "like new" condition. These individuals spend considerable amounts of money to rebuild the motorcycle to "like new" condition. They spend additional money to get an exceptional paint job.

We will get to these individuals through the Linnfield dealers, which is where individuals needing an exceptional paint job go for referrals. We will target the Linnfield motorcycle dealer with an established business.

Top Five After-Market Prospects

Linn field Motorcycles, Birmingham, MI - Discussions and meetings held with the owner. IOC has been asked to powder coat their new line of custom motorcycles.

Butterfly Bikes, Grand Rapids, MI - Discussions held with the owner. Very interested in IOC service and capability.

Washington Linnfield, Pontiac, MI - No discussions held to date.

Donahue's Wheels, Cadillac, MI - No discussions held to date.

Nash Jackson Linnfield Motors, Scottsdale, AZ - One meeting conducted with the owner. Very interested in IOC service and capability.

MANAGEMENT

To succeed in custom coating, every individual in the company must be a peak performer. Success will require the ability to manage the company resources effectively. Success will require a strong sales effort. Success will require the ability to deliver a product that meets the customer's expectations. The IOC management team meets these requirements.

John Godsey, President, has been involved in management, operations and sales during his 16 year career. John has spent more than half of his career in management positions, including: Office Manager fora $2.5million, 25 person office; Regional Sales and Technical Manager for an $88 million company; Regional Vice President for a start-up operation, part of a $20 million, 125 person operation; Vice President - Operations for a $4 million, 40 person company; and Corporate Manager for a Fortune 200 Company.

Ike Walton, Vice President-Operations, has the knowledge and experience that it takes to set up and run a high quality powder coating operation. Ike has more than 22 years of experience working in the automotive industry. Ike has spent the past 8 years working for the world leader in robotic powder coating application systems. Ike spent 6 years developing the programming that drives the powder coating system, and has spent the past 2 years as Project Manager installing new systems and troubleshooting existing systems. These projects involve multi-million dollar systems. Ike has seen all of the things that affect a quality operation, and knows how to develop and implement the solution. Furthermore, Ike has run a small custom powder coating operation in the past.

Roles and Responsibilities

Each member of the management team brings a different resource to the company, resulting in a whole that is greater than the sum of the parts. Innovative will start out in a fashion that will minimize overhead costs and risk, and maximize profitability. John and Ike will be the only employees initially, responsible for selling the work, applying the powder coating, and running the business. We expect that this business will grow quickly, and we will need employees within six months. At that time, our business management experience will prove invaluable, as described below.

John Godsey will be responsible for managing the company, and leading the future growth of the organization. He will be directly responsible for the financial, administrative and human resources aspects of IOC. Initially, he will also use his past experience with operations and sales to coordinate and assist with these responsibilities. He brings strong technical and management experience to IOC. John has a strong background with management and quality control systems.

Ike Walton will be responsible for leading the operations. Ike's expertise in installing and operating powder coating systems will prove invaluable to efficient facility management. Ike will install and operate the powder coating system. All operations staff will report to Ike, and it will be his responsibility for ensuring that customer orders are completed on-time, and to customer specifications.

IOC will obtain accounting/financial support on an as needed basis. IOC initially intends to maintain financial information internally, using an accountant for semi-annual or annual reviews.

IOC will also obtain legal support as an outside resource. The firm has not been selected at this time.

OPERATIONS

Operations will be responsible for delivering a product that meets customer expectations the first time. Our market analysis identified that customers need a powder coating operation that can reliably deliver a high quality finish, bundled with superior customer service. Other powder coating operations in this geographic area place little emphasis on cleanliness, quality, or on-time delivery.

IOC will succeed by differentiating ourselves from these companies in four ways:

  • powder coating will be our only business
  • applying a high quality finish will be our primary focus
  • the equipment needed to produce a high quality finish will be purchased from the start
  • exceptional customer service will be a key part of our product

Equipment

Production Equipment

The first key to applying a Class A finish is having the right equipment. IOC will purchase equipment capable of applying high quality finish. This equipment is:

Application Equipment: Symons Studio manual spray powder system: Ultimate flexibility and control manual application of powder coatings.

Baking Oven: The powder coating cures when exposed for a prescribed length of time to temperatures between 350 and 425 degrees Fahrenheit. The baking oven must hold temperature during that time, and all surfaces must be evenly exposed.

Spray booth : IOC will purchase a used spray booth that will allow for the collection of sprayed powder. As cash flow warrants IOC will refurbish this booth to become a permanent color booth.

Operating Systems

The correct equipment is only one step to delivering a high quality finish. The equipment must be operated effectively. Two key aspects to operation are "Working Environment" and "Quality Program."

Working Environment

A clean and orderly work environment is essential for the success of IOC. We will hire future employees, and consider them to be long term investments; we can only retain them if we provide a safe, sound and healthy environment.

Beyond this, a clean and orderly work environment is essential to providing a high quality finish. Airborne dirt and dust will contaminate the powder coating, and result in a finish with imperfections.

Quality Program

IOC principals know that it is critical to meet customer expectations the first time. We have all had our share of customer complaints, due to product that does not meet customer specifications. The unhappy customer is just one cost of poor quality. There is also the cost to rework the part. It costs more to redo the work than it did to do it right the first time. IOC will institute Quality Control systems that will allow us to make parts right the first time. Quality will be built into all IOC operations, and all employees will adopt the quality ethic.

Quality control will also be the responsibility of each employee. The goal is to move responsibility for quality control out onto the work floor. Each employee will also have responsibility for their own job performance. Quality and process problems, concerns or recommendations will be discussed as part of weekly and monthly company wide meetings.

Environmental Compliance

IOC will make every effort to comply with all environmental regulations. Powder coating is environmentally friendly. The environmental impact is minimal. There are no solvents used in the paint process, eliminating the need for wash solvent and eliminating VOC emissions from coating operations. Powder coating that must be disposed can be handled as ordinary trash; it is not a hazardous waste.

There are some permitting requirements for this operation. The air permitting requirements are minimal; the Michigan Department of Environmental Quality (MDEQ) does not require an air permit for powder coating operations.

Staffing

During the majority of the first year IOC will be staffed by Ike Walton and John Godsey. This will cut down on overhead and allow the owners to implement quality programs prior to hiring new employees. As the business grows, IOC will hire additional employees to ensure that customers get parts coated in a reasonable amount of time.

Facility Requirements

IOC will initially operate renting space from part of a building. The target space has natural gas and electricity available to meet our requirements. This space will have a month-to-month lease, allowing us to pay only for the space that we need, and move into larger space when needed.

IOC expects to secure our own building or portion of a building after one year. Our search will focus on the area immediately east of Toledo, Ohio. This area has a large number of light industrial buildings, equipped with the power and structural needs of a growing company.

SOURCES AND USE OF FUNDS

The total dollar amount being sought is $30,000 in conventional financing. IOC expects there to be only one funding round for full financing during the first 2 to 3 years. IOC does not want to seek financing that would require an outside equity position.

The funding will be used to purchase capital, and provide working capital for the initial 4 to 6 months. This funding is essential to allow the start of this company.

This business plan assumes that IOC will purchase a combination of new and used equipment. Used powder coating equipment is notreadily available; this will determine the amount of new equipment that must be purchased.

Use Of Funds

Capital Expenditures
Leasehold Improvements$2,000
Purchase of oven$20,000
Spray gun and hopper$2,500
Used Spray Booth$2,500
Total Capital Expenditures$27,000
Working Capital
Purchase of Inventory$1,500
Lease expenses$1,000
Staffing00
Other Activities$5,500
Total Working Capital$8,000
Total Use Of Funds$35,000

FINANCIAL INFORMATION

IOC is seeking funding that will allow equipment purchase, building leasing, equipment set-up, and will support the operation for the initial period. IOC expects that cash flow will support the operation after the initial period, and that a bank will provide a line of credit based on the Accounts Receivable (A/R's).

Financial Analysis

IOC has determined our financial requirements based on the financial analysis in the following tables. Included are the Pro forma Income Statement, Balance Sheet, and Cash Flow analysis for the first three years (1997, 1998 and 1999). The income statement shows that IOC will be profitable almost immediately. We project generating $9,500 profit on $36,250 sales in year 1, $26,840 profit on $87,000 sales in year 2, and $41,850 profit on $117,500 sales in year 3.

Ratio Analysis

Financial ratios are included for your convenience.

Financial Standards

We have included financial standards as compiled by Jackson Associates for comparable companies in this industry.

Asset Worksheet

Fixed Assets
Equipment1000.00
Automotive, trucks0.00
Buildings0.00
Fixtures0.00
Machinery24000.00
Leasehold improvements2000.00
Start Up Costs0.00
Miscellaneous #10.00
Miscellaneous #20.00
Total Fixed Assets27000.00
Intangible Assets
Goodwill0.00
Other0.00
Total Intangible Assets0.00
BALANCESHEET
Percent Change
Year lYear2Year3Yrl-Yr2Yr2-Yr3
ASSETS
Cash7262.7229372.3886478.92304.43%194.42%
Accounts Receivable0.004000.005000.00#N/A!25.00%
Notes Receivable0.000.000.00#N/A!#N/A!
Inventory391.25523.7550.0033.87%90.45%
Total Current Assets7653.9733896.1391528.92342.86%170.03%
Total Fixed Assets27000.0023142.8619285.71
Less: accum. deprec.3857.143857.143857.14
Net Fixed assets23142.8619285.7115428.5716.67%20.00%
Intangible Assets0.000.000.00#N/A!#N/A!
Total Assets30796.8353181.84106957.4972.69%101.12%
LIABILITIES
Accounts payable0.000.000.00#N/A!#N/A!
Bank notes0.000.000.00#N/A!#N/A!
Notes payable0.000.000.00#N/A!#N/A!
CPLTD5249.545915.336665.5312.68%12.68%
Total Current Liabilities5249.545915.336665.5312.68%12.68%
Long Term Debt20091.7514176.427510.8929.44%47.02%
Total Liabilities25341.2920091.7514176.4220.72%29.44%
NETWORTH
Paid in Capital35000.0035000.0035000.00
Retained Earnings9533.9726837.9941851.16181.50%55.94%
Additional Value39078.4328747.9015929.9126.44%155.41%
Total Net Worth5455.5433090.0992781.07506.54%180.39%
TOTAL LIABILITIES & NET WORTH30796.8353181.84106957.4972.69%101.12%
RATIO ANALYSIS
Percent Change
Year lYear2Year3Yrl-Yr2Yr2-Yr3
Current Ratio1.465.7313.73293.01%139.64%
Acid Ratio1.384.9712.97258.91%161.29%
Debt Ratio (Total Debt/Total Assets) TIE0.820.380.1354.09%64.92%
Inventory Turnover68.4339.101.4642.86%96.25%
Average Collection Period0.0016.6315.40#N/A!7.45%
Total Asset Turnover1.171.631.0938.98%32.85%
Gross Margin94.66%94.69%94.75%0.04%0.05%
Net Margin26.43%31.00%35.80%17.29%15.46%
Return on Assets30.96%50.46%39.13%63.01%22.46%
Return on Equity174.76%81.11%45.11%53.59%44.38%
Off.Comp./Sales1.66%1.85%5.13%11.11%177.66%
RMA
Year 1Year 2Year 3Industry
Norm
Assets
Cash & Equivalents23.655280.912.4
Trade Receivables - (net)0.07.59.4262
Inventory1.31.00.0102
All Other Current0.00.00.02.1
Total Current24.963.785.650.9
Fixed Assets (net)75.136.314.439.4
All Other Non-Current0.00.00.03.4
Total100.0100.0100.0100.0
Liabilities
Notes-Payable-Short Term0.00.00.07.1
Cur.Mat.-L/T/D17.011.1624.5
Trade Payables0.00.00.07.8
Income Taxes-Payable0.00.00.01.4
All Other Current0.00.00.07.8
Total Current17.011.16228.6
Long Term Debt65.226.77.019.4
Deferred Taxes0.00.00.01.2
All Other Non-Current65226.77.09.4
Net Worth17.762286.741.4
Total Liabilities & Net Worth100.0100.0100.0100.0
Income Data
Net Sales100.0100.0100.0100.0
Gross Profit94.794.794.747.7
Operating Expenses57.651244.541.5
Operating Profit37.143.550262
All Other Expenses (net)0.00.00.01.9
Profit Before Taxes36.743.149.74.3
Ratios
Current1.465.7313.7322
Quick1.384.9712.971.5
Sales/Receivables#N/A!21.6423.388.5
Cost of Sales/Inventory7.6511.16303.3518.3
Cost of Sales/Payables#N/A!#N/A!#N/A!19.0
Sales/Working Capital15.003.091.387.1
EBIT/Interest0.000.000.003.3
Net Profit + Depr., Dep.,
Amort./Cur. Mat. L/T/D0.000.000.003.4
Fixed/Worth4240.580.170.9
Debt/Worth4.650.610.151.3
% Profit Before Taxes/
Tangible Net Worth
242.72%112.65%62.65%23.7
% Profit Before Taxes/
Total Assets
43.00%70.09%54.35%9.4
Sales/Net Fixed Assets1.564.497.584.5
Sales/Total Assets1.171.631.091.9
% Depr., Dep., Amort/Sales0.00%0.00%0.00%42
% Officer's Comp./Sales1.66%1.85%5.13%11.1
Income Statement
Percent Change
Year lYear2Year3Yrl-Yr2Yr2-Yr3
Revenue
Gross Sales36250.0087000.00117500.00140.00%35.06%
Less returns, discounts181.25435.00587.50140.00%35.06%
Net Sales36068.7586565.00116912.50140.00%35.06%
Cost of Goods Sold
Beginning inventory75.00366.25498.75388.33%36.18%
Purchases2112.504500.005400.00113.02%20.00%
Freight105.63225.00270.00113.02%20.00%
Total goods available2293.135091.256168.75122.02%21.16%
Ending inventory366.25498.7525.0036.18%94.99%
Total Cost of Goods Sold1926.884592.506143.75138.34%33.78%
Gross Profit34141.8881972.50110768.75140.09%35.13%
Operating Expenses
Selling Expenses
Advertising575.00375.00600.0034.78%60.00%
Commissions0.000.000.00#N/A!#N/A!
Travel & Entertainment300.00600.00840.00100.00%40.00%
Total875.00975.001440.0011.43%47.69%
Administrative
Salaries600.001600.006000.00166.67%275.00%
Payroll2880.0013920.0014400.00383.33%3.45%
Withholding1044.004656.006120.00345.98%31.44%
Insurance1200.001200.001200.000.00%0.00%
Total5724.0021376.0027720.00273.45%29.68%
General
Rent5700.0012000.0012000.00110.53%0.00%
Utilities3000.004800.004800.0060.00%0.00%
Telephone900.001800.001800.00100.00%0.00%
Office Expenses300.001800.002400.00500.00%33.33%
Vehicle Expenses0.000.000.00#N/A!#N/A!
Office Supplies300.00300.00600.000.00%100.00%
Postage180.00200.00120.0011.11%40.00%
Professionals362.50870.001175.00140.00%35.06%
Research0.000.000.00#N/A!#N/A!
Misc.3425.00200.000.0094.16%100.00%
Total14167.5021970.0022895.0055.07%4.21%
Total Operating Expenses20766.5044321.0052055.00113.43%17.45%
Total Operating Income13375.3837651.5058713.75181.50%55.94%
State Taxes133.75376.52587.14181.50%55.94%
Pretax Income13241.6237274.9958126.61181.50%55.94%
Federal Taxes3707.6510437.0016275.45181.50%55.94%
Net Income9533.9726837.9941851.16181.50%55.94%
Year One Cash Flow
JanFebMarAprMayJun
Sales:
Linnfield Motors5001,0001,0001,5001,5002,000
Other Motorcycle Dealers0250500500500500
Automotive Customizing000250250250
Snowmobile Customizing00000250
Total Sales5001,2501,5002,2502,2503,000
Cash Receipts:
Month of Shipment 60%3007509001,3501,3501,800
First Month 30%0150375450675675
Second Month 10%0050125150225
Third Month 0%000000
Fourth Month 0%000000
Total Receipts3009001,3251,9252,1752,700
Cash Expenses:
Rent300300300300300300
Utilities200200200200200200
Telephone505050505050
Salaries505050505050
Payroll000000
Withholding151515151515
#1 Inventory50507575100100
FreightIn334455
#2 Inventory132525252550
FreightIn111113
#3 Inventory0013131325
FreightIn001111
#4 Inventory00001313
FreightIn000011
Office Expense000000
Vehicle Expense000000
Office Supplies252525252525
Postage0050101010
Advertising01001002525100
Professionals51315232330
Commissions000000
Insurance100100100100100100
Travel & Entertainment0030303030
Research000000
Equipment Purchase27,00000000
Miscellaneous (Startup costs; Samples)3,2250500500
State Taxes000000
Federal Taxes000000
Total Expenses31,0369311,1039461,0351,107
Net Cash From Operations30,736312229791,1401,593
Beginning Cash35,0004,2643,5633,1153,4243,894
Cash on Hand4,2644,2333,7854,0944,5645,488
Bank Loan Required000000
Loan Repayment0670670670670670
Ending Cash4,2643,5633,1153,4243,8944,818
JulAugSepOctNovDec
2,0002,0002,0002,0002,5003,000
1,0001,0001,0001,0001,0002,000
5005005005005001,000
250250250250250250
3,7503,7503,7503,7504,2506,250
2,2502,2502,2502,2502,5503,750
9001,1251,1251,1251,1251,275
225300375375375375
000000
000000
3,3753,6753,7503,7504,0505,400
3003003001,0001,0001,000
200200200400400400
505050150150150
505050505050
000960960960
151515303303303
100100100125150150
555688
50505050100100
333355
252525255050
111133
131313131325
111111
000100100100
000000
252525252525
101010501010
2525252525100
383838384363
000000
100100100100100100
303030303030
000000
000000
05000500
000000
000000
1,0391,0891,0393,4543,5743,632
2,3362,5862,7112%4761,768
4,8186,4838,39910,43910,0669,872
7,1539,06911,10910,73610,54211,640
000000
670670670670670670
6,4838,39910,43910,0669,87210,970
Year Two Cash Flow
JanFebMarAprMay
Sales
Linnfield Motorcycles3,0003,0003,0003,0003,000
Other Motorcycle Dealers2,0002,0002,0002,0002,500
Automotive Customizing1,0001,0001,0001,0001,500
Snowmobile Customizing500500500500500
Total Sales6,5006,5006,5006,5007,500
Cash Receipts
Month of Shipment3,9003,9003,9003,9004,500
First Month1,8751,9501,9501,9501,950
Second Month425625650650650
Third Month00000
Fourth Month00000
Total Receipts6,2006,4756,5006,5007,100
Cash Expenses
Rent1,0001,0001,0001,0001,000
Utilities400400400400400
Telephone150150150150150
Salaries100100100100100
Payroll9609601,2001,2001,200
Witholding318318390390390
#1 Inventory150150150150150
Freight-In88888
#2 Inventory100100100125125
Freight-In55566
#3 Inventory5050507575
Freight-In33344
#4 Inventory2525252525
Freight-In11111
Office Expense100100100100100
Vehicle Expense00000
Office Supplies2525252525
Postage1010501010
Advertising10025252525
Professionals6565656575
Commissions00000
Insurance100100100100100
Travel & Entertainment5050505050
Research00000
Equipment Purchase00000
Miscellaneous (Start-up Costs; Samples)0500050
State Taxes00000
Federal Taxes00000
Total Expenses3,7193,6943,9964,0094,069
Net Cash From Operations2,4812,7812,5042,4913,031
Beginning Cash10,97012,78114,89216,72618,547
Cash on Hand13,45115,56217,39619,21721,578
Bank Loan Required00000
Loan Repayment670670670670670
Ending Cash12,78114,89216,72618,54720,908
JunJulAugSepOctNovDec
3,0003,0003,0003,0003,0003,0003,000
2,5002,5002,5002,5002,5003,0003,000
1,5001,5001,5001,5001,5001,5001,500
500500500500500500500
7,5007,5007,5007,5007,5008,0008,000
4,5004,5004,5004,5004,5004,8004,800
2,2502,2502,2502,2502,2502,2502,400
650750750750750750750
0000000
0000000
7,4007,5007,5007,5007,5007,8007,950
1,0001,0001,0001,0001,0001,0001,000
400400400400400400400
150150150150150150150
100100100100100100500
1,2001,2001,2001,2001,2001,2001,200
390390390390390390510
150150150150150150150
8888888
125125125125150150150
6666888
757575757575100
4444445
25252525252575
1111114
100200200200200200200
0000000
25252525252525
10101010101050
25252525252525
75757575758080
0000000
100100100100100100100
50505050505050
0000000
0000000
005000500
0000000
0000000
4,0194,1194,1694,1194,1454,2004,789
3,3813,3813,3313,3813,3553,6003,161
20,90823,61926,33128,99231,70334,38837,318
24,28927,00129,66232,37335,05837,98840,479
0000000
670670670670670670670
23,61926,33128,99231,70334,38837,31839,809
Year Three Cash Flow
JanFebMarAprMay
Sales
Linnfield Motorcycles3,0003,0003,0003,0003,000
Other Motorcycle Dealers3,0003,0003,0003,0003,000
Automotive Customizing2,0002,0002,0002,0002,000
Snowmobile Customizing1,5001,5001,5001,5001,500
Total Sales9,5009,5009,5009,5009,500
Cash Receipts
Month of Shipment5,7005,7005,7005,7005,700
First Month2,4002,8502,8502,8502,850
Second Month800800950950950
Third Month00000
Fourth Month00000
Total Receipts8,9009,3509,5009,5009,500
Cash Expenses
Rent1,0001,0001,0001,0001,000
Utilities400400400400400
Telephone150150150150150
Salaries500500500500500
Payroll1,2001,2001,2001,2001,200
Witholding510510510510510
#1 Inventory150150150150150
Freight-In88888
#2 Inventory150150150150175
Freight-In88889
#3 Inventory100100100100100
Freight-In55555
#4 Inventory7575757575
Freight-In44444
Office Expense200200200200200
Vehicle Expense00000
Office Supplies5050505050
Postage1010101010
Advertising5050505050
Professionals9595959595
Commissions00000
Insurance100100100100100
Travel & Entertainment7070707070
Research00000
Equipment Purchase00000
Miscellaneous (Start-up Costs; Samples)00000
State Taxes00000
Federal Taxes00000
Total Expenses4,8344,8344,8344,8344,860
Net Cash From Operations4,0664,5164,6664,6664,640
Beginning Cash39,80943,20647,05251,04855,044
Cash on Hand43,87647,72251,71855,71459,684
Bank Loan Required00000
Loan Repayment670670670670670
Ending Cash43,20647,05251,04855,04459,014
JunJulAugSepOctNovDec
3,0003,0003,0003,0003,0003,0003,000
3,5003,5003,5003,5003,5003,5003,500
2,0002,0002,0002,0002,0002,0002,000
1,5001,5001,5001,5001,5001,5001,500
10,00010,00010,00010,00010,00010,00010,000
6,0006,0006,0006,0006,0006,0006,000
2,8503,0003,0003,0003,0003,0003,000
9509501,0001,0001,0001,0001,000
0000000
0000000
9,8009,95010,00010,00010,00010,00010,000
1,0001,0001,0001,0001,0001,0001,000
400400400400400400400
150150150150150150150
500500500500500500500
1,2001,2001,2001,2001,2001,2001,200
510510510510510510510
1501501501501501500
8888880
1751751751751751750
9999990
1001001001001001000
5555550
7575757575750
4444440
200200200200200200200
0000000
50505050505050
10101010101010
50505050505050
100100100100100100100
0000000
100100100100100100100
70707070707070
0000000
0000000
0000000
0000000
0000000
4,8654,8654,8654,8654,8654,8654,340
4,9355,0855,1355,1359,7309,7308,680
59,01463,27967,69472,15976,62485,68494,744
63,94968,36472,82977,29486,35495,414103,424
0000000
670670670670670670670
63,27967,69472,15976,62485,68494,744102,754

More From encyclopedia.com