Don't bother with copy and paste.

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

Download for free

Machinery & Hardware icon Machine Tooling Business Plan

Start your plan

Machine Tooling

Executive Summary

Machine Tooling is a Kansas City, Kansas based company, whose mission is to be successful by effectively utilizing the philosophies of high quality, advanced techniques, and customer service.

Over the past two years, Machine Tooling has worked very hard to build its infrastructure and the systems to handle a significant amount of business. We have worked aggressively to construct walls, make electrical advancements, and other leasehold improvements to establish the business. Additionally, the company has configured a staff who is equipped to handle many tasks. These individuals are highly qualified and experienced.

The company has designed and built machines and automated systems that are ready for market. To compliment this, we have developed strong working relationships with our customers and plan to further this area by continuing to offer customers value-added improvements and vertically-integrate the business to support these improvements.

Machine Tooling has a management team with direct knowledge of the industry, extensive research experience, and unique administrative skills. The company’s management team consists of people with broad backgrounds in manufacturing, automation, and finance. The management staff consists of Mr. Peter Newton, CEO, Mr. John Abbot, president, and Mr. Chris Manuel, vice president of Marketing.

Projected revenues for Year 1 to Year 3 are $1.9 million, $4.1 million, and $5.3 million, respectively. To continue in a steady pattern of growth, Machine Tooling plans to attract a larger customer base and be in a more attractive negotiating position. To provide the financial strength needed for the company to achieve its goals, Machine Tooling has decided to go public.

The company is seeking $500,000 for expansion purposes. These include:

  • Marketing of new product lines.
  • Growth into new markets.
  • Purchasing additional equipment.

Going public will have a positive effect on Machine Tooling’s sales ability. Replacing the company’s debt will afford the opportunity to reduce the overall burden rate. This will give Machine Tooling a competitive advantage when compared to similar-sized companies because they are carrying debt. With this expansion and improved burden rate, Machine Tooling will be a stronger force in the manufacturing industry marketplace. The financial strength that will be achieved with this type of expansion will give Machine Tooling the capacity to establish a larger, more diversified customer base which will generate increased sales revenue. This is an exponential growth opportunity for the company.

1.1 Mission

The company’s mission is to be successful by effectively utilizing the philosophies of high quality, advanced techniques, and customer service.

1.2 Keys to Success

It is important that the company continues to provide superb customer service and fast delivery. At the same time, the company’s further success will depend on securing new customers in the served market niches.

Machine tooling business plan, executive summary chart image

Company Summary

Business Description
Machine Tooling has been operating in Kansas City since May, 1989. We are a Kansas Limited Liability Company (LLC). The company occupies 10,000 square feet of manufacturing area, including offices for administration, engineering, and a quality assurance area.

Overview of Technology and Products
Machine Tooling was formed to provide full-service, close-tolerance contract machining of machine and tooling components, production machining, and automation of production lines. The diverse manufacturing equipment at our facility accommodates versatility and allows the plant to operate self sufficiently.

Managerial expertise and industry experience have helped the company to show profits every year since its inception. During the last three years, the company further entrenched its position in its market niche, which resulted in healthy financials that can be seen in Table 2.1.

2.1 Company History

Machine Tooling was founded in Kansas City in 1989 on the basis of providing quality machine tools for selected industries. The owners had worked in this field for several years and had established multiple business contacts who helped the company pick up major business accounts. By 1999, the company’s revenues reached $1.5 million, and the management realized that further company growth would be difficult without securing additional working capital. To be less debt-dependent, the management has decided to go public. However, before the company issues the initial public offering (IPO), Machine Tooling currently seeks $500,000 for expansion purposes. Such expansion will improve the company’s sales ability and positively affect its IPO prospects.

Machine tooling business plan, company summary chart image

Past Performance
1997 1998 1999
Sales $1,000,000 $1,300,000 $1,500,000
Gross Margin $600,000 $800,000 $1,000,000
Gross Margin % 60.00% 61.54% 66.67%
Operating Expenses $400,000 $550,000 $700,000
Collection Period (days) 19 22 34
Inventory Turnover 3.00 3.00 3.00
Balance Sheet
1997 1998 1999
Current Assets
Cash $20,000 $40,000 $60,000
Accounts Receivable $40,000 $80,000 $130,000
Inventory $30,000 $60,000 $90,000
Other Current Assets $5,000 $10,000 $15,000
Total Current Assets $95,000 $190,000 $295,000
Long-term Assets
Long-term Assets $100,000 $100,000 $100,000
Accumulated Depreciation $10,000 $20,000 $30,000
Total Long-term Assets $90,000 $80,000 $70,000
Total Assets $185,000 $270,000 $365,000
Current Liabilities
Accounts Payable $25,000 $50,000 $75,000
Current Borrowing $15,000 $35,000 $50,000
Other Current Liabilities (interest free) $5,000 $5,000 $10,000
Total Current Liabilities $45,000 $90,000 $135,000
Long-term Liabilities $50,000 $50,000 $50,000
Total Liabilities $95,000 $140,000 $185,000
Paid-in Capital $50,000 $50,000 $50,000
Retained Earnings $40,000 $80,000 $130,000
Earnings $0 $0 $0
Total Capital $90,000 $130,000 $180,000
Total Capital and Liabilities $185,000 $270,000 $365,000
Other Inputs
Payment Days 30 30 30
Sales on Credit $750,000 $1,000,000 $1,125,000
Receivables Turnover 18.75 12.50 8.65

Products

Background on Products and Technology
Machine Tooling is planning to assemble the first level of the armature assembly. Laminates will be assembled to rotors and shipped daily to supplement customer production. This will take place in the second quarter of 2000. An elite team of professionals experienced in this industry and this type of product has been put together to drive this project.

The Machine Tooling Engineering group will continue to support internal and external automation contributing to production type sales and value engineering. They will co-engineer the next generation of food processing equipment, and will also pursue the building and assembly of the food processing machinery product line that the company now manufactures the components of:

  • Rotor shafts.
  • Specialized manufacturing service.
  • Food processing equipment.
  • Engineering service.
  • Assembly machinery.

Market Analysis Summary

Overview U.S. machine tool industry (Provided by Standard & Poor’s)
The U.S. machine tool industry is in a period of relative stability, although industry size, employment, and revenues typically fluctuate in response to swings in the business cycle. The number of industry establishments stands at approximately 600, according to U.S. Census Bureau data. These producers are concentrated in several midwestern and northeastern states: Ohio, Michigan, and Illinois have the greatest concentration of industry establishments.

The composition of the industry has changed since the beginning of the 1990s as a result of consolidation and foreign investment. A spate of buyouts and acquisitions occurred in the early to middle 1990s, and a number of privately-held companies became publicly owned. A wave of investment by the European automotive industry spurred similar investments by continental machine-tool producers, which established U.S. production facilities to supply their primary customer group. Japanese investment also picked up in the first half of the decade, driven by the strong yen. The newcomers joined a contingent of Japanese machine-tool manufacturers that had established U.S. production facilities in the 1980s in response to U.S. import restrictions that have since been lifted.

A strong commitment to exporting and the sustained expansion of the U.S. economy are key elements in the machine tool industry’s newfound stability. Changes in the automotive sector are also important. The automotive industry is far less cyclical than it was in the past. Auto makers are undertaking more frequent and less extensive design changes and are becoming globalized, tailoring their products to individual markets. This has led to ongoing investment programs rather than concentrated purchasing cycles. The increasing globalization of the automotive sector is encouraging a similar trend among machine tool suppliers. U.S. machine tool companies are increasing their worldwide presence, often through joint ventures, cooperative agreements, and strategic alliances. The countries that have attracted the largest industry investment to date are Mexico, Brazil, India, and China.

4.1 Market Segmentation

The company’s target customers:

  1. Automobile seating manufacturers. These customers require customized machine tools to better serve their clients.
  2. Fine blanking and stamping manufacturers. These customers have a strong need for specialized manufacturing services.
  3. Manufacturers of complete product lines. Value adding assembly is most required by this customer segment.

The table and chart below outline the total market potential and estimated growth rates for the type of products manufactured by Machine Tooling.

Machine tooling business plan, market analysis summary chart image

Market Analysis
2000 2001 2002 2003 2004
Potential Customers Growth CAGR
Automobile Seating 2% 300 306 312 318 324 1.94%
Fine Blanking & Stamping 1% 150 152 154 156 158 1.31%
Complete Product Lines 1% 200 202 204 206 208 0.99%
Other 0% 100 100 100 100 100 0.00%
Total 1.31% 750 760 770 780 790 1.31%

4.2 Target Market Segment Strategy

Machine Tooling will focus our market offerings on three major customer groups:

  1. Automobile seating manufacturers.
  2. Fine blanking and stamping manufacturers.
  3. Manufactures of complete product lines.

Our market research shows that these customer segments are the most demanding in terms of the engineering, technical service support, and automated design. Machine Tooling is particularly strong in these areas and will utilize our capacities to serve these clients. The company will seek customers who require production of components used in upper-end product lines. This will provide a further possibility for Machine Tooling to offer our value-added engineering services.

4.2.1 Market Needs

Each of the served segment’s market needs are shaped by the desire to procure quality products at reasonable prices. Machine Tooling is in the position to offer just that to our clientele, and we understand that our products must help our clients to better add value to their own end customers.

4.2.2 Market Growth

Annual U.S. machine tool product shipments have grown for the last four years, topping $46.5 billion in 1997. This trend was expected to hold with 1998 shipments on track to exceed $7.1 billion, an increase of nine percent in current dollars (seven percent in constant dollars). Industry exports reflect a similar pattern of growth. U.S. machine tool exports reflect a similar pattern of growth. U.S. machine tool exports climbed to over $2.8 billion in 1997 and were expected to rise four percent in 1998 to more than $3 billion. With continued growth projected for the U.S. economy, U.S. machine tool producers have reason to be optimistic. Machine tools purchases historically are driven by economic prosperity. The industry’s upward trend is expected to continue for several more years, in parallel with the domestic economy’s projected sustained growth. Product shipments of machine tools, expressed in constant dollars, are forecast to increase two percent in 1999.

U.S. machine tool manufacturers can expect moderate growth in shipments during the period of 1999-2003. Projections call for annual increases of approximately four percent. The rising demand for capital equipment will be driven by manufacturers’ need to improve productivity, increase capacity, and cut labor costs. Price increases will be virtually nonexistent as manufacturers continue to place strong price pressure on machine tool suppliers. The metal cutting sector is expected to be somewhat stronger than the metal forming sector.

The most active customer markets for U.S. machine tool builders in the near future will be the aerospace, appliance, automotive, farm machinery, and job shop industries. Demand will be particularly robust among job shops. The nation’s tool and die businesses are in a retooling mode, investing in a range of new, high-technology equipment to improve quality and precision. Job shops are increasing and widening their machining capabilities, particularly in areas such as high-speed cutting and laser, waterjet, and rapid prototyping technologies. The trend toward outsourcing by a range of producers, most notably the automotive industry, will further increase this sector’s demand.

Prospects for export markets are less secure. Key markets that are expected to be soft in the near future include the weakened Pacific Rim region and the European Union, where the introduction of a common European currency in select countries is creating uncertainty. As a result, slower growth in exports is likely, as well as an increase in the U.S. machine tool trade deficit. Machine tool exports are expected to grow by three percent annually in the period 1999-2003. The strongest markets for U.S. machine tool exporters will be Canada, Mexico, Chile, Argentina, and Brazil.

4.3 Industry Analysis

Market 1 – Metal cutting tools
In 1997, shipments from production machinery industries totaled nearly $82 billion. The largest subsectors, in constant-dollar terms, were air conditioning, refrigeration and heating (31.8%), construction machinery (27.2%), and farm machinery (17.1%).

Industry: Metalworking machinery, nec.

Establishments that are primarily engaged in manufacturing metalworking machinery, not elsewhere classified.

Market Size Statistics

Estimated number of U.S. establishments 674
Number of people employed in this industry 15,596
Total annual sales in this industry $2,044.4 million
Average employees per establishment 25
Average sales per establishment $3.6 million

Market 2 – Construction machinery
Construction machinery (SIC 3531) consists of earthmoving equipment (bulldozers, shovel loaders, and excavators), off-highway trucks, power cranes, crawlers, draglines, and trenchers. However, if the industry can capitalize on new technologies and expand into developing markets, growth is expected to average nearly three percent from 1999 to 2002. An important factor in the future growth of this subsector could be the National Ambient Air Quality Standards, issued by the EPA in July, 1997. Firms are in the process of assessing the impact of the change in ozone standards on their production processes.

Establishments that are primarily engaged in manufacturing heavy machinery and equipment, such as bulldozers, concrete mixers, and cranes.

Market Size Statistics

Estimated number of U.S. establishments 2,266
Number of people employed in this industry 125,081
Total annual sales in this industry $58,196.9 million
Average employees per establishment 57
Average sales per establishment $34.3 million

Market 3 – Food products machinery
U.S. manufacturers of food products machinery benefit from the huge domestic market. According to the U.S. Department of Agriculture, the processed food industry is the largest manufacturing and distribution sector in the U.S. economy, accounting for more than one-sixth of the nation’s industrial activity. In addition, the United States is a major player in the global food industry, manufacturing approximately one-fourth of the world’s processed foods. In 1997 U.S. shipments of processed foods and beverages were estimated at approximately $471 billion. Six of the 10 largest, and 21 of the top 50 food processing companies in the world are headquartered in the United States. In addition to providing a large and viable home market for domestic machinery manufacturers and process technologists, the United States is a magnet market for advanced foreign high-technology machinery suppliers and for direct investment in the food industry.

Market 4 – Electrical equipment
Between 1992 and 1996, electrical equipment industry shipments boomed, increasing five percent in real terms. This growth ended a negative period in 1990 and 1991, during which shipments declined more than nine percent. The most important factor underlying those boom years was significant investment by firms in terms of both expansion and upgrading of their capital base. Low interest rates, technological improvements, and a healthy export climate stimulated this capital spending. The relays and industrial controls subsector, and the motors and generators subsector, historically have had the largest shipment values; during the period 1992-1996, both subsectors experienced the most vigorous growth, with average annual increases in shipments approximating seven percent each.

Market 5 – Turbines
The bulk of electricity production in the United States comes from steam turbines because of their efficiency and large capacity. However, gas turbines, which are also call combustion turbines, are accounting for the bulk of new manufacturing capacity in the turbine-producing subsector, particularly for peak load times and emergency and reserve power. Of the increase in generating capacity at U.S. electric utilities between 1992 and 1996, the Energy Information Administration estimates that over 60 percent can be attributed to newly-installed gas turbines. More than three-quarters of the planned capacity additions at these utilities, from 1997 to 2006, are expected to use gas as the primary energy source.

Market 6 – Motors and Generators
This subsector includes the production of electric motors (other than engine starting motors) and power generators, motor generator sets, railway motors and control equipment, and motors, generators, and control equipment for gasoline, electric, and oil-electric buses and trucks.

Other Markets
Industry: Power transmission equipment, nec.
Establishments that are primarily engaged in manufacturing mechanical power transmission equipment and parts, for industrial machinery.

Market Size Statistics

Estimated number of U.S. establishments

18,984
Number of people employed in this industry 427
Total annual sales in this industry $3,338 million
Average employees per establishment 47
Average sales per establishment $10.9 million

4.3.1 Industry Participants

Competitive threats come from machine shops who perform similar types of machining, as well as design firms that have established relationships with a large customer base. Their machinery, tooling, fixturing, and inspection equipment is tailored to accommodate specific customer products. Their weaknesses, however, are lack of engineering ability, process control, expertise to develop and combine processes, to synchronously combine operations, and an inability to design and build automatic load and unload systems for internal use.

4.3.2 Competition and Buying Patterns

Machine Tooling believes that our customers choose our products based on the following criteria:

  • Price.
  • Performance.
  • Customer service and support.

Strategy and Implementation Summary

The market strategy is to capitalize on our expertise by positioning the company to acquire strategic companies within the industry. We plan to leverage our expertise to acquire companies with product lines that compliment our manufacturing operations. The company’s goal in the next year is to secure more contract manufacturing positions. The company’s goal in the next five years is to continue with our “value added” scheme and embark on an acquisition program that will see the company take over key industry players.

5.1 Value Proposition

Machine Tooling’s products and services offer the following advantages to customers.

  1. Delivery. We provide on-time delivery, thereby reducing customer inventory and providing them with overall cost reduction.
  2. Quality. The products we supply are of high quality and have attributes that enable customers to carry out their business functions.
  3. Price. Our products competitively priced, thus helping customers control their own bottom line.

5.2 Competitive Edge

Machine Tooling has several highly significant competitive advantages:

  • Engineering and technical support service.
  • Automated system design and build.
  • Customer service and support.
  • Engineering and technical skills.
  • Cross-functional teams encourage creativity.
  • Quality systems are in place.

5.3 Marketing Strategy

The company’s marketing strategy will be to continue to promote sales of our product lines, systems, presses, automation projects, and machining capacity. In machining, focus will continue to be on components used in semi-sophisticated equipment where a possibility exists to pursue the next level of integration by assembling components or prepare part kits for assisted assembly. Focusing on this product-component relationship will facilitate the company’s ability to pursue the vertical integration of the business and pass on the value-added savings to our customers.

5.3.1 Marketing Programs

The overall marketing plan for Machine Tooling’s service is based on the following fundamentals:

  • The segment of the markets planned to reach.
  • Distribution channels planned to be used to reach market segments: television, radio, sales associates, and mail order.
  • Share of the market expected to capture over a fixed period of time.

Market Responsibilities. In order to capitalize on sales opportunities, Machine Tooling will require an effective promotional campaign. This will be accomplished through television, radio, and magazine advertisements, as well as posters on billboards throughout the state. To help our customers with name recognition, we will offer a variety of promotional items with the company logo on them; the initial giveaways will be t-shirts, stickers, mugs, and pens.

Investment in Advertising and Promotion. A fixed amount of sales revenues will go toward the statewide advertisement campaign. On an ongoing basis, we feel that we can budget advertising expenses at less than five percent of revenues to the company.

5.3.2 Pricing Strategy

Pricing for machined components is developed usually by conducting a thorough time study analysis. This involves tool and cutter selection based on the operations to be performed and the material being processed. Machining, traverse, and material handling times are calculated based on known feeds, speeds, and rapid traverse rates. This total is then factored by the company’s burden rate and profit margin, and then factored again based on market value.

5.4 Sales Strategy

Machine Tooling’s sales plan is to seek businesses that will advance the company’s quest to vertically integrate and become a stronger force in the manufacturing industry. The company will continue to strive towards procuring sales of our product lines and machining capacity. The focus in machining is securing contracts to produce components used in upper-end product lines, yielding opportunities for “value added” engineering.

To accomplish Machine Tooling’s endeavors, the company will utilize internal and external sales tactics. By aggressively seeking new accounts and taking full advantage of the existing relationships the company has with current customers and broadening its customer base, the company will expand and be able to compete with the leading companies in the industry. Machine Tooling plans to use a direct sales force, relationship selling, and subcontractors to reach our markets. These channels are most appropriate because time to market, reduced capital requirements, and fast access to established distribution channels.

5.4.1 Sales Forecast

The chart and table below outline Machine Tooling’s sales forecasts. The company will gradually increase the share of the high-value assembly services in its sales mix over the next two years, which will add to the company’s bottom line.

Machine tooling business plan, strategy and implementation summary chart image

Sales Forecast
2000 2001 2002
Sales
Automation $220,000 $330,000 $420,000
Production Machining $270,000 $360,000 $440,000
Specialized Manufacturing $710,000 $970,000 $1,600,000
Value Added Assembly $760,000 $2,400,000 $2,800,000
Total Sales $1,960,000 $4,060,000 $5,260,000
Direct Cost of Sales 2000 2001 2002
Automation $45,200 $67,000 $85,000
Production Machining $54,700 $73,000 $89,000
Specialized Manufacturing $144,400 $197,000 $325,000
Value Added Assembly $155,700 $490,000 $570,000
Subtotal Direct Cost of Sales $400,000 $827,000 $1,069,000

Management Summary

The company’s management philosophy is based on responsibility and mutual respect. Machine Tooling will maintain an environment and structure that will encourage productivity and respect for customers and fellow employees.

Machine Tooling’s management is highly experienced and qualified. The key management team includes: Mr. Peter Newton CEO, Mr. John Abbot, president, and Mr. Chris Manuel, vice president of Marketing. As the table below outlines, the company will strive to maintain lean overhead. Besides the senior management team and an administrative assistant, Machine Tooling currently employs a production manager who oversees all the production facilities and the staff of ten.

10 Production workers are tracked as Cost of Goods in the Profit and Loss table. To accommodate the growing sales projections, an additional five productions workers will be hired in 2001.

Personnel Plan
2000 2001 2002
Peter Newton, CEO $75,000 $80,000 $90,000
John Abbot, President $75,000 $80,000 $90,000
Chris Manuel, VP Marketing $60,000 $65,000 $75,000
Production Manager $45,000 $50,000 $55,000
Administrative Assistant $30,000 $35,000 $40,000
Total People 15 20 20
Total Payroll $285,000 $310,000 $350,000

Financial Plan

The company is seeking $500,000 for expansion purposes. The use of funds will be broken down as follows:

Marketing of new product lines $30,000
Growth into new markets $50,000
Purchasing additional equipment $270,000
Working Capital $100,000
Other (Debt Management) $50,000

7.1 Important Assumptions

Important assumptions for this plan are found in the following table.

General Assumptions
2000 2001 2002
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 25.42% 25.00% 25.42%
Other 0 0 0

7.2 Break-even Analysis

Machine Tooling is operating well above the break-even point.

Machine tooling business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $90,953
Assumptions:
Average Percent Variable Cost 20%
Estimated Monthly Fixed Cost $72,391

7.3 Projected Profit and Loss

The table below provides Machine Tooling’s projected income statements for 2000-2002.

Machine tooling business plan, financial plan chart image

Machine tooling business plan, financial plan chart image

Machine tooling business plan, financial plan chart image

Pro Forma Profit and Loss
2000 2001 2002
Sales $1,960,000 $4,060,000 $5,260,000
Direct Cost of Sales $400,000 $827,000 $1,069,000
Production Personnel $350,040 $600,000 $650,000
Total Cost of Sales $750,040 $1,427,000 $1,719,000
Gross Margin $1,209,960 $2,633,000 $3,541,000
Gross Margin % 61.73% 64.85% 67.32%
Expenses
Payroll $285,000 $310,000 $350,000
Marketing/Promotion $167,900 $220,000 $265,000
Depreciation $9,996 $30,000 $40,000
Quality Assurance $93,800 $104,000 $125,000
General & Administrative $96,000 $124,000 $174,000
Manufacturing & Engineering $129,600 $130,000 $175,000
Machining & Systems Building $86,400 $100,000 $110,000
Payroll Taxes $0 $0 $0
Other $0 $0 $0
Total Operating Expenses $868,696 $1,018,000 $1,239,000
Profit Before Interest and Taxes $341,264 $1,615,000 $2,302,000
EBITDA $351,260 $1,645,000 $2,342,000
Interest Expense $47,705 $29,150 $12,470
Taxes Incurred $74,621 $396,463 $581,922
Net Profit $218,938 $1,189,388 $1,707,608
Net Profit/Sales 11.17% 29.30% 32.46%

7.4 Projected Cash Flow

The company’s projected cash flow statements are presented below.

  • The existing short-term liabilities ($50,000 in total) are paid out in ten monthly payments of $5,000 each starting in March, 2000.
  • The $500,000 long-term loan is expected to be secured in January, 2000 (two payments of $250,000 each are expected in January and February). This loan will be repaid quarterly over three years.
  • In April, $50,000 from the expected loan will be used to completely repay the existing long-term obligations.
  • After that, in May and July, 2000, the company will purchase additional equipment and buildings in the total amount of $270,000.
  • In years 2001 and 2002, further capital expenditures in the amount of $200,000 and $300,000, respectively, are planned to accommodate for increased sales. In both cases, “ten year, straight-line” depreciation is assumed.
Machine tooling business plan, financial plan chart image

Pro Forma Cash Flow
2000 2001 2002
Cash Received
Cash from Operations
Cash Sales $490,000 $1,015,000 $1,315,000
Cash from Receivables $1,352,925 $2,780,277 $3,793,730
Subtotal Cash from Operations $1,842,925 $3,795,277 $5,108,730
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 $500,000 $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 $2,342,925 $3,795,277 $5,108,730
Expenditures 2000 2001 2002
Expenditures from Operations
Cash Spending $285,000 $310,000 $350,000
Bill Payments $1,350,401 $2,477,107 $3,134,443
Subtotal Spent on Operations $1,635,401 $2,787,107 $3,484,443
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $50,000 $0 $0
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $175,100 $166,800 $166,800
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $270,000 $200,000 $300,000
Dividends $0 $0 $0
Subtotal Cash Spent $2,130,501 $3,153,907 $3,951,243
Net Cash Flow $212,424 $641,370 $1,157,487
Cash Balance $272,424 $913,793 $2,071,280

7.5 Balance Sheet

The company’s projected balance sheets for 2000-2002 are presented below.

Pro Forma Balance Sheet
2000 2001 2002
Assets
Current Assets
Cash $272,424 $913,793 $2,071,280
Accounts Receivable $247,075 $511,798 $663,069
Inventory $37,290 $77,097 $99,658
Other Current Assets $15,000 $15,000 $15,000
Total Current Assets $571,789 $1,517,689 $2,849,006
Long-term Assets
Long-term Assets $370,000 $570,000 $870,000
Accumulated Depreciation $39,996 $69,996 $109,996
Total Long-term Assets $330,004 $500,004 $760,004
Total Assets $901,793 $2,017,693 $3,609,010
Liabilities and Capital 2000 2001 2002
Current Liabilities
Accounts Payable $117,955 $211,267 $261,777
Current Borrowing $0 $0 $0
Other Current Liabilities $10,000 $10,000 $10,000
Subtotal Current Liabilities $127,955 $221,267 $271,777
Long-term Liabilities $374,900 $208,100 $41,300
Total Liabilities $502,855 $429,367 $313,077
Paid-in Capital $50,000 $50,000 $50,000
Retained Earnings $130,000 $348,938 $1,538,325
Earnings $218,938 $1,189,388 $1,707,608
Total Capital $398,938 $1,588,325 $3,295,933
Total Liabilities and Capital $901,793 $2,017,693 $3,609,010
Net Worth $398,938 $1,588,325 $3,295,933

7.6 Business Ratios

The following table gives a detailed ratio analysis for Machine Tooling. The last column, Industry Profiles, is derived from the general machine industry, as described by the Standard Industry Classification (SIC) Index code 3569, General Industrial Machinery, NEC.

Ratio Analysis
2000 2001 2002 Industry Profile
Sales Growth 30.67% 107.14% 29.56% -0.50%
Percent of Total Assets
Accounts Receivable 27.40% 25.37% 18.37% 24.80%
Inventory 4.14% 3.82% 2.76% 26.10%
Other Current Assets 1.66% 0.74% 0.42% 24.20%
Total Current Assets 63.41% 75.22% 78.94% 75.10%
Long-term Assets 36.59% 24.78% 21.06% 24.90%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 14.19% 10.97% 7.53% 35.70%
Long-term Liabilities 41.57% 10.31% 1.14% 18.50%
Total Liabilities 55.76% 21.28% 8.67% 54.20%
Net Worth 44.24% 78.72% 91.33% 45.80%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 61.73% 64.85% 67.32% 35.80%
Selling, General & Administrative Expenses 72.00% 52.86% 49.17% 20.80%
Advertising Expenses 2.27% 1.60% 1.33% 0.70%
Profit Before Interest and Taxes 17.41% 39.78% 43.76% 4.00%
Main Ratios
Current 4.47 6.86 10.48 2.20
Quick 4.18 6.51 10.12 1.15
Total Debt to Total Assets 55.76% 21.28% 8.67% 54.20%
Pre-tax Return on Net Worth 73.59% 99.84% 69.47% 7.30%
Pre-tax Return on Assets 32.55% 78.60% 63.44% 16.00%
Additional Ratios 2000 2001 2002
Net Profit Margin 11.17% 29.30% 32.46% n.a
Return on Equity 54.88% 74.88% 51.81% n.a
Activity Ratios
Accounts Receivable Turnover 5.95 5.95 5.95 n.a
Collection Days 59 45 54 n.a
Inventory Turnover 10.42 14.46 12.10 n.a
Accounts Payable Turnover 11.81 12.17 12.17 n.a
Payment Days 29 23 27 n.a
Total Asset Turnover 2.17 2.01 1.46 n.a
Debt Ratios
Debt to Net Worth 1.26 0.27 0.09 n.a
Current Liab. to Liab. 0.25 0.52 0.87 n.a
Liquidity Ratios
Net Working Capital $443,834 $1,296,421 $2,577,229 n.a
Interest Coverage 7.15 55.40 184.60 n.a
Additional Ratios
Assets to Sales 0.46 0.50 0.69 n.a
Current Debt/Total Assets 14% 11% 8% n.a
Acid Test 2.25 4.20 7.68 n.a
Sales/Net Worth 4.91 2.56 1.60 n.a
Dividend Payout 0.00 0.00 0.00 n.a

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Automation 0% $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $19,000 $19,000 $19,000 $19,000
Production Machining 0% $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $23,000 $24,000 $25,000
Specialized Manufacturing 0% $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $59,000 $60,000 $60,000
Value Added Assembly 0% $63,000 $63,000 $63,000 $63,000 $63,000 $63,000 $63,000 $63,000 $64,000 $64,000 $64,000 $64,000
Total Sales $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $164,000 $165,000 $167,000 $168,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Automation $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,900 $3,900 $3,900 $3,900
Production Machining $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,700 $4,700 $4,800
Specialized Manufacturing $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,200 $12,200
Value Added Assembly $12,900 $12,900 $12,900 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Subtotal Direct Cost of Sales $33,100 $33,100 $33,100 $33,200 $33,200 $33,200 $33,200 $33,200 $33,400 $33,600 $33,800 $33,900
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Peter Newton, CEO 0% $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
John Abbot, President 0% $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Chris Manuel, VP Marketing 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Production Manager 0% $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750
Administrative Assistant 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750

General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0

Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $164,000 $165,000 $167,000 $168,000
Direct Cost of Sales $33,100 $33,100 $33,100 $33,200 $33,200 $33,200 $33,200 $33,200 $33,400 $33,600 $33,800 $33,900
Production Personnel $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170 $29,170
Total Cost of Sales $62,270 $62,270 $62,270 $62,370 $62,370 $62,370 $62,370 $62,370 $62,570 $62,770 $62,970 $63,070
Gross Margin $99,730 $99,730 $99,730 $99,630 $99,630 $99,630 $99,630 $99,630 $101,430 $102,230 $104,030 $104,930
Gross Margin % 61.56% 61.56% 61.56% 61.50% 61.50% 61.50% 61.50% 61.50% 61.85% 61.96% 62.29% 62.46%
Expenses
Payroll $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750
Marketing/Promotion $13,900 $13,900 $14,000 $13,900 $13,900 $14,000 $13,900 $13,900 $14,050 $14,000 $14,100 $14,350
Depreciation $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Quality Assurance $7,700 $7,700 $7,700 $7,700 $7,700 $7,700 $7,700 $7,700 $7,900 $8,000 $8,100 $8,200
General & Administrative $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Manufacturing & Engineering $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800
Machining & Systems Building $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $72,183 $72,183 $72,283 $72,183 $72,183 $72,283 $72,183 $72,183 $72,533 $72,583 $72,783 $73,133
Profit Before Interest and Taxes $27,547 $27,547 $27,447 $27,447 $27,447 $27,347 $27,447 $27,447 $28,897 $29,647 $31,247 $31,797
EBITDA $28,380 $28,380 $28,280 $28,280 $28,280 $28,180 $28,280 $28,280 $29,730 $30,480 $32,080 $32,630
Interest Expense $2,917 $5,000 $4,958 $4,500 $4,458 $4,069 $4,028 $3,986 $3,597 $3,555 $3,513 $3,124
Taxes Incurred $7,389 $5,637 $5,622 $5,737 $5,747 $5,819 $5,855 $5,865 $6,325 $6,523 $6,933 $7,168
Net Profit $17,241 $16,910 $16,867 $17,210 $17,242 $17,458 $17,565 $17,596 $18,975 $19,569 $20,800 $21,505
Net Profit/Sales 10.64% 10.44% 10.41% 10.62% 10.64% 10.78% 10.84% 10.86% 11.57% 11.86% 12.46% 12.80%

Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $40,500 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500 $41,000 $41,250 $41,750 $42,000
Cash from Receivables $65,000 $69,050 $121,500 $121,500 $121,500 $121,500 $121,500 $121,500 $121,500 $121,550 $123,025 $123,800
Subtotal Cash from Operations $105,500 $109,550 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,500 $162,800 $164,775 $165,800
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 $250,000 $250,000 $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 $355,500 $359,550 $162,000 $162,000 $162,000 $162,000 $162,000 $162,000 $162,500 $162,800 $164,775 $165,800
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750 $23,750
Bill Payments $77,903 $87,507 $100,701 $120,543 $120,312 $120,168 $119,955 $119,851 $119,849 $120,675 $121,094 $121,843
Subtotal Spent on Operations $101,653 $111,257 $124,451 $144,293 $144,062 $143,918 $143,705 $143,601 $143,599 $144,425 $144,844 $145,593
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 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $50,000 $0 $41,700 $0 $0 $41,700 $0 $0 $41,700
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $120,000 $0 $150,000 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $101,653 $111,257 $129,451 $199,293 $269,062 $190,618 $298,705 $148,601 $190,299 $149,425 $149,844 $192,293
Net Cash Flow $253,847 $248,293 $32,549 ($37,293) ($107,062) ($28,618) ($136,705) $13,399 ($27,799) $13,375 $14,931 ($26,493)
Cash Balance $313,847 $562,140 $594,689 $557,396 $450,334 $421,716 $285,011 $298,410 $270,611 $283,985 $298,917 $272,424
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $60,000 $313,847 $562,140 $594,689 $557,396 $450,334 $421,716 $285,011 $298,410 $270,611 $283,985 $298,917 $272,424
Accounts Receivable $130,000 $186,500 $238,950 $238,950 $238,950 $238,950 $238,950 $238,950 $238,950 $240,450 $242,650 $244,875 $247,075
Inventory $90,000 $56,900 $36,410 $36,410 $36,520 $36,520 $36,520 $36,520 $36,520 $36,740 $36,960 $37,180 $37,290
Other Current Assets $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Total Current Assets $295,000 $572,247 $852,500 $885,049 $847,866 $740,804 $712,186 $575,481 $588,880 $562,801 $578,595 $595,972 $571,789
Long-term Assets
Long-term Assets $100,000 $100,000 $100,000 $100,000 $100,000 $220,000 $220,000 $370,000 $370,000 $370,000 $370,000 $370,000 $370,000
Accumulated Depreciation $30,000 $30,833 $31,666 $32,499 $33,332 $34,165 $34,998 $35,831 $36,664 $37,497 $38,330 $39,163 $39,996
Total Long-term Assets $70,000 $69,167 $68,334 $67,501 $66,668 $185,835 $185,002 $334,169 $333,336 $332,503 $331,670 $330,837 $330,004
Total Assets $365,000 $641,414 $920,834 $952,550 $914,534 $926,639 $897,188 $909,650 $922,216 $895,304 $910,265 $926,809 $901,793
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $75,000 $84,173 $96,683 $116,532 $116,306 $116,170 $115,960 $115,857 $115,827 $116,640 $117,032 $117,776 $117,955
Current Borrowing $50,000 $50,000 $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0
Other Current Liabilities $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Subtotal Current Liabilities $135,000 $144,173 $156,683 $171,532 $166,306 $161,170 $155,960 $150,857 $145,827 $141,640 $137,032 $132,776 $127,955
Long-term Liabilities $50,000 $300,000 $550,000 $550,000 $500,000 $500,000 $458,300 $458,300 $458,300 $416,600 $416,600 $416,600 $374,900
Total Liabilities $185,000 $444,173 $706,683 $721,532 $666,306 $661,170 $614,260 $609,157 $604,127 $558,240 $553,632 $549,376 $502,855
Paid-in Capital $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Retained Earnings $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000
Earnings $0 $17,241 $34,151 $51,018 $68,228 $85,470 $102,928 $120,493 $138,089 $157,064 $176,633 $197,433 $218,938
Total Capital $180,000 $197,241 $214,151 $231,018 $248,228 $265,470 $282,928 $300,493 $318,089 $337,064 $356,633 $377,433 $398,938
Total Liabilities and Capital $365,000 $641,414 $920,834 $952,550 $914,534 $926,639 $897,188 $909,650 $922,216 $895,304 $910,265 $926,809 $901,793
Net Worth $180,000 $197,241 $214,151 $231,018 $248,228 $265,470 $282,928 $300,493 $318,089 $337,064 $356,633 $377,433 $398,938