Don't bother with copy and paste.

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

Download for free

Import & Export icon Coffee Export Business Plan

Start your plan

Silvera and Sons

Executive Summary

Silvera & Sons prepares green Arabica coffee beans grown in Brazil for exportation to American specialty roasters and sells to wholesalers on the Brazilian market. We will expand production capacity from 72,000/60kg bags per year to 120-160,000/60kg per year. Our coffee stands out from that of the competition. We prepare the top five percent, in terms of quality standards, of all Arabica beans on the market. Our customers seek this product as it provides them with a point of differentiation to specialty roasters. In the past six years, demand for our coffee has exceeded the amount we are able to supply and we have been forced to refuse requests for larger shipments.

We predict growth of thirty percent in the first year with sales exceeding ($BRL) expectations. In year three the plant will run at maximum capacity and based on the current price of coffee we expect excellent profits ($BRL). We have positive indicators from current importers that the additional amount of beans will be sold.

Our keys to success are:

  1. Establishing and maintaining working relationships and contractual agreements with American importers and Brazilian coffee brokers and wholesalers.
  2. Bringing the new facility to maximum production within three years of operation.
  3. Increasing our profit margin with the use of improved technology in the new facility.
  4. Effectively communicating to current and potential customers, through targeted efforts, our position as a differentiated provider of the highest quality Arabica beans in the world.

Coffee export business plan, executive summary chart image

1.1 Objectives

The objectives of Silvera & Sons:

  • Increase production and sale from 78,000/60kg bags per year to approximately 100,000/60kg bags per year in the first year of operation at the proposed facility and reach maximum capacity of 120,000/60kg bags per year by year three.
  • Increase sales substantially in the first full year of operation.
  • Establish strategic relationships with 10-15 American importers in Los Angeles, San Francisco, & Seattle.
  • Increase gross margins in the next three years.

1.2 Mission

Silvera & Sons Ltda seeks to serve coffee importers and enthusiasts by exceeding minimum acceptable quality standards and by providing the highest quality product at the lowest possible price. We value our relationships with current and future customers and hope to communicate our appreciation to them through our outstanding, guaranteed product quality, personal service, and efficient delivery. Our commitment to our customers and the country of Brazil will be reflected through honest and responsible business.

1.3 Keys to Success

The keys to success for Silvera & Sons are:

  • Establishing and maintaining working relationships and contractual agreements with American importers and Brazilian coffee brokers and wholesalers.
  • Bringing the new facility to maximum production within three years of operation.
  • Increasing our profit margin with the use of improved technology in the new facility.
  • Effectively communicating, to current and potential customers, our position as a differentiated provider of the highest quality Arabica beans in the world.

Company Summary

Silvera & Sons buys and prepares raw coffee in parchment (pergamino), or coffee in its post-harvest stage. The finished product, green Arabica coffee beans are packaged in 60kg sacks and sold on the U.S. and Brazilian market. Our customers are primarily American importers and Brazilian wholesalers who provide high-quality beans to the specialty roasting market.

2.1 Company Ownership

Silvera & Sons Ltda. is a private, family owned preparer and exporter of Brazilian-grown, green Arabica coffee beans. It is owned and operated by Marco Silvera Sr. and his sons, Marco Silvera Jr. and Antonio Silvera.

2.2 Company History

Silvera & Sons is in its sixth year of operation. The current plant has been in operation for 15 years and for 12 of those years was managed by Marco Silvera Sr. who was then an employee of the former owner, Cafe Fina. Since the plant was purchased, Silvera & Sons has maintained maximum production and sales. It is currently operating at maximum capacity.

Coffee export business plan, company summary chart image

Past Performance
1996 1997 1998
Sales $16,262,532 $17,304,066 $18,345,600
Gross Margin $2,439,380 $2,630,218 $2,814,215
Gross Margin % 15.00% 15.20% 15.34%
Operating Expenses $12,196,899 $12,631,968 $13,346,424
Inventory Turnover 12.00 12.00 12.00
Balance Sheet
1996 1997 1998
Current Assets
Cash $0 $0 $994,260
Inventory $0 $0 $355,200
Other Current Assets $0 $0 $243,936
Total Current Assets $0 $0 $1,593,396
Long-term Assets
Long-term Assets $0 $0 $521,650
Accumulated Depreciation $0 $0 $100,000
Total Long-term Assets $0 $0 $421,650
Total Assets $0 $0 $2,015,046
Current Liabilities
Accounts Payable $0 $0 $8,435
Current Borrowing $0 $0 $58,000
Other Current Liabilities (interest free) $0 $0 $0
Total Current Liabilities $0 $0 $66,435
Long-term Liabilities $0 $0 $402,000
Total Liabilities $0 $0 $468,435
Paid-in Capital $0 $0 $525,000
Retained Earnings $0 $0 $85,985
Earnings $0 $0 $935,626
Total Capital $0 $0 $1,546,611
Total Capital and Liabilities $0 $0 $2,015,046
Other Inputs
Payment Days 0 0 60

2.3 Company Locations and Facilities

The Silvera & Son’s main warehouse and office is located in Ouro Fino. The warehouse has the capacity to prepare approximately 6,000 60kg bags of exportable coffee beans. The proposed new warehouse and preparation facility site is also located in Ouro Fino. The new facility will be 3.500m2 and will have 30 selecting machines with capacity to prepare 40,000 bags for exportation and 80,000 bags for storage. The proposed facility will also handle shipping.

Products

Silvera & Sons deal exclusively in green coffee, grown in the southern states of Brazil and one-hundred percent Arabica. Beans in parchment are purchased directly from growers and are de-husked and packaged into 60kg sacks in the Silvera & Sons’ plant. The final product is suitable for sale and exportation.

3.1 Competitive Comparison

In order to differentiate our product, coffee, which is a commodity, from the product offering of competitors, all beans are guaranteed fresh and are shipped within seven days of preparation. In addition all beans are sorted at ninety-five percent screen 18 and above compared to the industry standard ninety percent screen of 17 and above. The beans shipped by Silvera & Sons are therefore larger than most and are guaranteed fresh. In addition, all of the farms from which Silvera & Sons purchases coffee adhere to environmentally sound farming practices and avoid the use of pesticides and chemicals in crop production.

There are approximately ten competitors who offer a product similar to ours. Our research indicates that with the additional capacity we would become one of the top four, in terms of quantity, providers. We have the advantage of established distribution channels and reputation. In addition, improvements to our marketing efforts will further separate us from the larger market and from our close competitors.

3.2 Sales Literature

Silvera & Sons currently works with two importers in the United States who handle all of our shipments. Likewise, we have dealt with the same Brazilian wholesalers, for internal sales, each year. Sales to this point have been handled through personal selling. Additional sales literature will include a website, direct mail to specialty roasters and importers, and print advertising in several trade publications including Coffee Times, a monthly publication which targets American business dealing with issues relevant to the coffee industry.

3.3 Sourcing

Both the existing and the proposed facilities are ideally located in Ouro Fino, in the state of Minas Gerais. Minas Gerais is the largest coffee producing state in Brazil and beans produced in the region are of the highest quality. With additional financing, we would be able to buy larger volumes at lower prices. We now buy from one or more of six private growers or grower cooperatives. Contracts are secured six months in advance of harvest.

3.4 Technology

Improvements in technology will include the use of partially automated selecting machines which will allow for increased production capacity with a lower machine-to-operator ratio than we currently employ. Additional storage capabilities will decrease shipping charges and will reduce the need for permanent shipping employees by thirty-five percent. High-technology information system upgrades will improve all aspects of business, especially inventory control, tracking of shipments, and communication with clients in import countries.

3.5 Future Products

Alternative to the Arabica bean, Coffea Robusta, though it shares some similarities with the Arabica bean, is very different. Coffea Robusta is grown at lower elevations and has a higher yield per plant as well as being more resistant to disease. It also has up to twice the caffeine level as it’s cousin the Arabica Bean. Due to the lower cost and larger market amount of Robusta coffee, it is found primarily on supermarket shelves. The Arabica species grows at much higher elevations, better soil rich areas, and is the source of the worlds finest coffees.

By providing the finest species of coffee, Silvera & Sons has taken the first step towards a differentiated product. To further distinguish our coffee, we adhere to higher quality standards than approximately ninety-five percent of the market. In addition, all of our beans are of the Bourbon Santos variety. The “Bourbon” strain is considered one of the finest Brazil has to offer. It is grown in the mountains surrounding Sao Paulo and is highly sought after by specialty roasters from around the world. We have assumed the position of a specialized provider of this exceptional coffee. Our customers, American and Brazilian specialty roasters, recognize Silvera & Sons for our ability to provide the type of beans they require to produce award winning coffee.

Market Analysis Summary

Coffee is the second largest commodity market next to oil and Brazil has remained the largest producer of coffee in the world for two centuries. Imports of Arabica coffee in the United States have increased ninety-four percent in the past five years and consumption of coffee within Brazil has seen similar increases. In addition, demand for green coffee is above the market clearing level, and market price and crop yield estimates are at an all time high.

The increase in the number of independent specialty roasters in the United States and Brazil has contributed to and is an indicator of the increased demand for coffee. Within the larger coffee market is our target market is the specialty roaster. These discerning customers want the highest quality coffee beans. They serve the growing “gourmet” coffee market and are represented by large American companies like Starbucks and thousands of smaller specialty roasters. The Arabica bean is considered to be the best in the world and as such, the demand for Arabica beans is high on the specialty roaster market. Specialty roasters are willing to pay more for Arabica beans and attempt to distinguish themselves via the characteristics of the bean they use i.e. the location in which it was grown, farming methods, bean size, etc. The final consumer is relatively price insensitive if the coffee is good, has won awards, or is compatible with a popular trend. We estimate that specialty roasting in the U.S. alone is a ($USD) one-billion market.

4.1 Market Segmentation

The potential customer groups for Silvera & Sons are:

  • American importers of green Arabica beans: Market research suggests that there are approximately 200 importers of green Arabica coffee on the West and East Coasts of the United States that would be able to handle the quantities of our shipments and are in our target market . Combined, they import a total of four to five million/60kg bags of Brazilian coffee per year.
  • Brazilian green coffee wholesalers: This market serves as a safety valve for our export business. By maintaining relationships with Brazilian wholesalers we have an alternative market with established distribution channels.
  • Brazilian specialty roasters: As we move towards maximum capacity we will plan to more aggressively target this audience. We hope to eventually reduce transactions with wholesalers and capture their value-added costs as profit. We anticipate that this effort will begin approximately four years into operation of the new facility.
Coffee export business plan, market analysis summary chart image

Market Analysis
1999 2000 2001 2002 2003
Potential Customers Growth CAGR
U.S. Importers (60kg bags) 26% 70,140 88,376 111,354 140,306 176,786 26.00%
Brazilian Wholesalers (60kg bags) 26% 30,060 37,876 47,724 60,132 75,766 26.00%
Total 26.00% 100,200 126,252 159,078 200,438 252,552 26.00%

4.2 Industry Analysis

Coffee has been a growing industry for the past five years. The most notable growth has been in the American market where imports have increased almost one-hundred percent and the market price has nearly doubled. The number of specialty roasters has increased from a handful of well known companies to thousands of independent entities. There is a constant struggle within this market to produce the best coffee and serve one or more niches within the larger market. Brazilian coffee producers and exporters have made great efforts to improve agricultural techniques, processing methods, and distribution in order to better serve this growing market. Demand for Brazilian coffee is currently greater than supply.

4.2.1 Competition and Buying Patterns

The purchase decision for our customer is based on trust in our process and bean selection. We have established relationships with our customers which extend beyond that of the buyer/seller. The Silvera & Sons label means that the product has been chosen and prepared with the highest quality standards in mind. Our beans are priced up to nine percent higher than similar products. Our customers are willing to pay more for our product because they are familiar with us and trust in the quality of our beans. This is the result of their success in the marketplace with our product.

4.2.2 Main Competitors

There are approximately 150 exporters of green Arabica beans in Brazil. According to the Brazilian Coffee Exporters Association, ABECAFE, fifty percent (50%) of all green coffee exports come from their 45 members. Approximately eighty percent (80%) of these exports come from 20 ABECAFE members. Market contributions of individual exporters are held in strict confidence and are not available to the public. However, based on this information and given the large number of remaining exporters not affiliated with ABECAFE who account for the remaining sixty percent (60%) of all exports, we assume that many of the largest competitors are amongst the ABECAFE members. They are:

Agro Food Cooxupe Mitsui Alimentos
Allcoffee Cotia Trading Nicchio Cafe
Bramazonia Custudio Forzza Nova America
Cafe do Ponto Esteve N.S. da Guia
Cafeeira Carolina Eurobrasil Ottoni & Filhos
Cargill Agricola Fazenda da Serra  Porto de Santos
Casas Sendas Guaxupe Ref. Oleos Brasil
Cocam Inter-Continental R & G 
Comexim JR Exportadora Rio Doce
Comercial Ben. MC Coffee Tres Coracoes
Compel Melitta Volcafe

4.2.3 Industry Participants

Silvera & Sons deals exclusively in the exportation and sale of green Arabica beans. There are approximately 150 Brazilian businesses in this market. However, approximately 30 companies account for approximately eighty percent of the total amount of green Arabica exports. In addition many of these companies prepare, export and sell, to the Brazilian market, other coffee products. Additional products include:

  • Green Robusta (Conillon) beans: The Robusta bean is produced in far less quantity, in Brazil, than the Arabica and is considered an inferior species. The Robusta market represents less than ten percent of all coffee produced in Brazil.
  • Soluble coffee products: These are instant (water soluble) coffees and are either decaffeinated or not. Sales of soluble coffee products account for approximately twelve percent of the total market.
  • Roasted & Ground coffee: Approximately eighty-five percent of all roasted and ground coffee (decaffeinated and non-decaffeinated) goes to internal consumption and represents approximately twenty-seven percent of the total coffee market.
  • Primary competitors include: Golden Brazil, Bramazonia, Comexim, and Nicchio Cafe.

4.2.4 Distribution Patterns

All of the coffee produced for exportation by Silvera & Sons and approximately eighty-five percent of all coffee produced for exportation in Brazil is shipped from Porto de Santos. Prepared coffee is shipped via rail and/or truck from the Silvera & Sons plant in Ouro Fino to Porto de Santos. From the port it is then shipped, in 40 foot containers to the port of Miami via cargo ship. Distribution charges are assumed by Silvera & Sons up to the arrival of the shipments in Miami whereupon importers assume responsibility, as detailed in contract, of the shipment and additional distribution charges.

Strategy and Implementation Summary

Silvera & Sons strategy is to expand production capabilities in order to fulfill the requests of importers with whom we currently deal for larger orders which we are unable to currently fulfill. In addition Silvera & Sons seeks to establish additional contracts with importers on the West Coast of the United States and increase the volume of green coffee sold on the Brazilian market. We intend to first maximize quantity of coffee sold within existing channels and second, establish additional accounts through targeted marketing efforts.

5.1 Competitive Edge

Silvera & Sons competitive edge comes from the advantage of having established relationships with American importers, and Brazilian coffee growers, green coffee brokers and wholesalers. Silvera & Sons has received affirmation of the demand for their product in the form of requests from importers for larger product shipments. Ours is a superior product offering because of the larger average size of the bean and because we purchase from growers who rely on the use of chemicals and pesticides less than two percent of the time. In addition, prompt preparation and shipment provides importers with a product that is up to one month fresher than beans sold by many exporters.

5.2 Strategy Pyramid

Our main strategy is to communicate the unique and desired attributes of our coffee to larger segments of the American and Brazilian markets. We sell a superior product, yet one that can be considered a commodity. It is therefore important that we effectively communicate the unique aspects which make it ideally suited for a niche market.

The unique aspects of our products include superior product selection and preparation, quality assurance, and efficient distribution. These are things we have done since we started doing business. The tactics we will use to communicate these strengths include, personal selling, targeted print advertising, and improved communication capabilities via information system improvements and a sophisticated website.

As tactics below the pyramid, we have identified three specialty publication in the United States and two in Brazil in which we will run print ads. We also plan to increase personal selling efforts to additional American importers. Part of the personal selling will include invitations to importers to visit our facilities, at our expense.

5.3 Marketing Strategy

Silvera & Sons marketing strategy will include the use of targeted print media advertising and direct selling to importers in the United States who provide green coffee to specialty roasters. We will capitalize on existing relationships with importers who have stated their willingness to contact West Coast affiliates and recommend Silvera & Sons coffee. We have positioned ourselves as a differentiated provider of the highest quality Arabica beans. The primary goal of all marketing efforts will be to communicate this to existing and potential customers.

5.3.1 Promotion Strategy

Relationships are key to success in the export business. Importers in Florida have on several occasions visited the Silvera & Sons facility, family home, and farms from which coffee is purchased. Additional accounts and contacts with West Coast importers have all been established and maintained through personal contact. Personal selling will remain our most important means of promotion. Marco Silvera Jr. will continue to lead this effort. In addition to personal selling Silvera & Sons has identified several specialty publications within which print advertisements will run. Direct mail, in the form of personal letters will also be used to communicate with existing and potential clients. Our budget for promotion activities is as follows:

  • Personal Selling which includes phone expenses, travel for Silvera & Sons employees and for importers who we invite to Brazil: ($BRL) 35,000 annually.
  • Print Advertising in three specialty publications and direct mail: ($BRL) 12,000 monthly.
  • World Wide Web presence: ($BRL) 125,000 to produce a new site and $2,500 annually to maintain the site.

5.3.2 Distribution Strategy

Distribution is one of the greatest challenges faced by Silvera & Sons. The distribution system of Brazil is largely outdated and inefficient. Moreover, taxes, specifically excise taxes are high. Distribution costs for internal sales are absorbed by the customer but distribution costs for exports are absorbed by us. Increasing the volume of our exports makes us eligible to receive reduced fees and helps ensure that trucks and rail cars are running at maximum capacity.

5.3.3 Marketing Programs

Our most important marketing program is an increase in personal selling combined with targeted direct mail and print advertising. Marco Silvera Jr. will be responsible, with a budget of ($BRL) 35,000 and a milestone date of May 30, 1999. The program is intended to establish contractual agreements with 10 additional importers, increase brand awareness of our product in the United States, and communicate our position as a provider of the highest quality green Arabica beans on the market.

Another key marketing program is the development of a sophisticated Website. The goal of this program is to increase our presence on the world wide web and provide additional means of communication and customer data collection. The website will cost ($BRL) 125,000.

5.3.4 Positioning Statement

For American importers of Brazilian coffee who use our coffee to supply specialty roasters, Silvera & Sons coffee beans are the highest quality and largest beans available. Unlike many exporters, our beans exceed the minimum acceptable quality standards and are shipped within one week of preparation to ensure the largest and freshest beans on the market. Our products are perfectly suited for the specialty roasting market which constantly strives to offer award winning coffee.

5.3.5 Pricing Strategy

Because Silvera & Sons adheres to higher quality standards, the price of our coffee is slightly higher (four to nine percent) than the market average. The import market largely determines the price of imported coffee in the United States. Beans that do not meet Silvera & Sons quality standards are resold on the Brazilian market at the current market price. Green coffee, on the import market, now sells for US$ 213.56/60kg bag. According to Silvera & Sons pricing strategy, Silvera & Sons coffee would sell for approximately US$ 224/60kg bag. Importers have to this point been willing to pay the additional cost.

5.4 Sales Strategy

Silvera & Sons strategy focuses first on meeting the increased demand from importers with whom we have established relationships for larger orders. These importers are critical to our ability to acquire additional accounts on both the East and West coasts of the United States without having to spend a great deal on sales efforts. Secondly we will focus on increasing the volume, while maintaining the percentage of sales, of beans sold to the internal Brazilian market. When we have reached maximum sales to existing channels we can then shift the majority of our focus to securing additional import accounts.

5.4.1 Sales Forecast

The following chart and table show our present sales forecast. We project healthy growth in sales in 1999, a slightly smaller increase again  in 2000, and reach maximum for production capacity in 2001 representing a large growth over the previous year.

Coffee export business plan, strategy and implementation summary chart image

Coffee export business plan, strategy and implementation summary chart image

Sales Forecast
1999 2000 2001
Unit Sales
Import and Export 100,200 120,000 160,000
Other 0 0 0
Total Unit Sales 100,200 120,000 160,000
Unit Prices 1999 2000 2001
Import and Export $262.08 $275.18 $288.29
Other $0.00 $0.00 $0.00
Sales
Import and Export $26,260,416 $33,021,600 $46,126,400
Other $0 $0 $0
Total Sales $26,260,416 $33,021,600 $46,126,400
Direct Unit Costs 1999 2000 2001
Import and Export $212.00 $222.60 $233.20
Other $0.00 $0.00 $0.00
Direct Cost of Sales
Import and Export $21,242,400 $26,712,000 $37,312,000
Other $0 $0 $0
Subtotal Direct Cost of Sales $21,242,400 $26,712,000 $37,312,000

5.4.2 Sales Programs

Personal selling: Through personal contact we need to confirm in writing orders for larger quantities of our product from American importers and Brazilian wholesalers. In addition we need to establish sales agreements with at least six, possibly ten, additional American importers. Marco Silvera Jr. is responsible and the due date is May 30, with a budget of ($BRL) 24,000.

5.5 Strategic Alliances

Our most valued alliances are those we have developed with American importers. They have the ability and willingness to purchase larger quantities of our products and recommend us to other importers. Additional alliances with trucking contractors and the Porto de Santos Cafe Commission are currently established.

5.6 Milestones

The accompanying table shows specific milestones, with responsibilities assigned, dates, and budgets. The milestones represented in this plan are those which we have determined to be the most important.

Coffee export business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Secure Financing 1/1/1999 2/1/1999 $12,000 M. Silvera Sr. Finance
Establish Import Accounts 1/1/1999 5/1/1999 $18,000 M. Silvera Jr. Sales & Marketing
Increase Production 1/1/1999 9/1/1999 $18,000 A Silvera Production & Shipping
Hire Intl. Legal & Finance Specialist 1/1/2000 3/1/2000 $35,000 TBA Administration
Totals $83,000

Management Summary

Silvera & Sons management consists of four full-time employees. Additional assistance is acquired on a part-time basis and/or through the use of consultants, specifically in legal matters. Detailed descriptions are found in the following section.

6.1 Management Team

Silvera & Sons is organized into three functional areas: product sourcing, sales, and marketing; production and shipping; and finance and administration.

Marco Silvera Sr: CEO/President in charge of finance and administration. Marco Silvera Sr., 57 has worked in the coffee export business for 30 years. Before starting Silvera & Sons he was the Chief Financial Officer and general manager of the Cafe Fino coffee company. He began working for Cafe Fino after he finished an accounting degree at the University of Southern California. The current Silvera & Sons plant was formerly owned by Cafe Fino and was sold to Mr. Silvera who had decided to “retire” and wanted to run a small business. Cafe Fino had purchased larger facilities and no longer needed the plant.

Marco Silvera Jr: Vice president in charge of product sourcing, sales, and marketing. Marco Silvera Jr., 32 completed his MBA at Syracuse University and worked for several years on the Brazilian stock and commodities market as a broker. He later took a position as an International Sales and Marketing Representative for a major agricultural brokerage and supply firm in Sao Paulo. He is expected to succeed his father as CEO of Silvera & Sons Ltda.

Antonio Silvera: Vice president in charge of production and shipping. Antonio Silvera, 29 worked as a civil engineer for two years for the Brazilian government after completing an engineering degree at the University of Brazil, Sao Paulo. He is responsible for the supervision of all plant employees.

Additional Management:
Ralph Henzo, CFO:
Gracie, Renoldo, & Fertado Attorneys at Law, Sao Paulo.

6.2 Management Team Gaps

We currently lack a full-time professional who can deal with the changing legal and financial aspects of international business. We have relied on legal consultants but are now analyzing the possibility of adding an additional position to deal exclusively with international issues. In addition, as we continue to grow and hire more personnel, we may hire a controller.

6.3 Personnel Plan

The personnel plan requires an increase in plant employees from 11 to 17-20 within the next three years. Additional employees will also be added to increase administrative and accounting support. One additional employee will be added to the sales and marketing division. We will retain all current employees as they will not have to relocate.

Personnel Plan
1999 2000 2001
Production Personnel
Antonio Silvera, VP Production $38,400 $41,088 $43,964
Plant Employees $219,996 $228,796 $237,948
Other $42,000 $47,000 $50,000
Subtotal $300,396 $316,884 $331,912
Sales and Marketing Personnel
Marco Silvera Jr, VP Sales/Mktg. $45,000 $48,150 $51,521
Other $180,492 $80,000 $85,000
Subtotal $225,492 $128,150 $136,521
General and Administrative Personnel
Marco Slivera Sr, CEO $50,400 $53,928 $57,703
Ralph Henzo, CFO $42,000 $44,940 $44,940
Admin/Acctg. Staff $9,000 $9,360 $44,734
Other $18,000 $22,000 $26,000
Subtotal $119,400 $130,228 $173,377
Other Personnel
Name or Title or Group $0 $0 $0
Name or Title or Group $0 $0 $0
Name or Title or Group $0 $0 $0
Subtotal $0 $0 $0
Total People 15 16 17
Total Payroll $645,288 $575,262 $641,810

Financial Plan

We want to finance growth through a combination of long-term debt and cash flow. Purchase of the larger facility and equipment will require approximately eighty percent debt financing. Additional technology will be primarily financed with cash-flow. Inventory turnover must remain at or above four or we run the risk of backing up orders and jeopardizing our freshness guarantees. We have had no problems with accounts receivable and we expect to maintain our collection days at 30 with thirty percent of sales on credit.

In addition, we must achieve gross margins of thirty-five percent and hold operating costs no more than sixty-five percent of sales.

7.1 Break-even Analysis

The break-even analysis shows that Silvera & Sons has sufficient sales strength to remain viable. Our per month break-even point projections are detailed in the following table and chart.

Coffee export business plan, financial plan chart image

Break-even Analysis
Monthly Units Break-even 2,049
Monthly Revenue Break-even $537,078
Assumptions:
Average Per-Unit Revenue $262.08
Average Per-Unit Variable Cost $212.00
Estimated Monthly Fixed Cost $102,629

7.2 Important Assumptions

Important assumptions for this plan are found in the following table. These assumptions largely determine the financial plan and require that we secure additional financing.

General Assumptions
1999 2000 2001
Plan Month 1 2 3
Current Interest Rate 14.00% 14.00% 14.00%
Long-term Interest Rate 9.00% 9.00% 9.00%
Tax Rate 47.00% 47.00% 47.00%
Other 0 0 0

7.3 Key Financial Indicators

The most important factor to Silvera & Sons anticipated growth is the procurement of necessary financing. The size of the orders currently requested by importers are larger than what can be produced given our present plant capacity.

The following chart shows changes in key financial indicators: sales, gross margin, operating expenses, collection days, and inventory turnover. The growth in sales goes above thirty percent in the first year, twenty percent in second, and back to thirty percent in year three after which it will settle. We expect to increase gross margin but our projections show a decline in the first two years following the purchase of the new facility. This is due to the facilities not being run at maximum capacity. The projections for collection days and inventory turnover show that we expect a decline in these indicators.

Coffee export business plan, financial plan chart image

7.4 Projected Profit and Loss

We expect to close the first year of production in the new facility with quite exempary ($BRL) sales and to increase our sales in the second and third years. Net earnings will be above industry average ($BRL).

Coffee export business plan, financial plan chart image

Coffee export business plan, financial plan chart image

Coffee export business plan, financial plan chart image

Coffee export business plan, financial plan chart image

Pro Forma Profit and Loss
1999 2000 2001
Sales $26,260,416 $33,021,600 $46,126,400
Direct Cost of Sales $21,242,400 $26,712,000 $37,312,000
Production Payroll $300,396 $316,884 $331,912
Other Costs of Sales $300,000 $345,000 $410,000
Total Cost of Sales $21,842,796 $27,373,884 $38,053,912
Gross Margin $4,417,620 $5,647,716 $8,072,488
Gross Margin % 16.82% 17.10% 17.50%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $225,492 $128,150 $136,521
Advertising/Promotion $144,000 $165,000 $165,000
Travel $21,000 $22,500 $24,000
Other Sales and Marketing Expenses $24,000 $26,500 $28,500
Total Sales and Marketing Expenses $414,492 $342,150 $354,021
Sales and Marketing % 1.58% 1.04% 0.77%
General and Administrative Expenses
General and Administrative Payroll $119,400 $130,228 $173,377
Marketing/Promotion $0 $0 $0
Depreciation $216,000 $216,000 $216,000
Leased Equipment $50,400 $50,400 $50,400
Utilities $36,000 $36,000 $36,000
Insurance $72,000 $75,000 $78,000
Rent $305,250 $300,000 $300,000
Payroll Taxes $0 $0 $0
Other General and Administrative Expenses $0 $0 $0
Total General and Administrative Expenses $799,050 $807,628 $853,777
General and Administrative % 3.04% 2.45% 1.85%
Other Expenses:
Other Payroll $0 $0 $0
Consultants $18,000 $24,000 $30,000
Other Expenses $0 $0 $0
Total Other Expenses $18,000 $24,000 $30,000
Other % 0.07% 0.07% 0.07%
Total Operating Expenses $1,231,542 $1,173,778 $1,237,798
Profit Before Interest and Taxes $3,186,078 $4,473,938 $6,834,690
EBITDA $3,402,078 $4,689,938 $7,050,690
Interest Expense $269,166 $238,449 $225,191
Taxes Incurred $1,370,949 $1,990,680 $3,106,465
Net Profit $1,545,964 $2,244,809 $3,503,035
Net Profit/Sales 5.89% 6.80% 7.59%

7.5 Projected Cash Flow

Silvera & Sons expects to manage cash flow over the next three years with the assistance of a loan supported by the Central Bank of Brazil. This financing assistance is required to provide the working capital to meet the current needs for the construction of the new production facility and additional personnel, distribution costs, and other related expenses.

Coffee export business plan, financial plan chart image

Pro Forma Cash Flow
1999 2000 2001
Cash Received
Cash from Operations
Cash Sales $26,260,416 $33,021,600 $46,126,400
Subtotal Cash from Operations $26,260,416 $33,021,600 $46,126,400
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 $2,700,000 $0 $0
Sales of Other Current Assets $0 $0 $0
Sales of Long-term Assets $0 $0 $0
New Investment Received $0 $650,000 $650,000
Subtotal Cash Received $28,960,416 $33,671,600 $46,776,400
Expenditures 1999 2000 2001
Expenditures from Operations
Cash Spending $645,288 $575,262 $641,810
Bill Payments $23,678,478 $29,770,693 $41,735,934
Subtotal Spent on Operations $24,323,766 $30,345,955 $42,377,744
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $57,996 $0 $0
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $305,250 $294,636 $0
Purchase Other Current Assets $60,000 $75,000 $85,000
Purchase Long-term Assets $2,700,000 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $27,447,012 $30,715,591 $42,462,744
Net Cash Flow $1,513,404 $2,956,009 $4,313,656
Cash Balance $2,507,664 $5,463,673 $9,777,329

7.6 Projected Balance Sheet

As shown in the balance sheet in the following table, our net will grow quickly by the end of 1999 and to continue steadily through the end of the plan period. The monthly projections are in the appendix.

Pro Forma Balance Sheet
1999 2000 2001
Assets
Current Assets
Cash $2,507,664 $5,463,673 $9,777,329
Inventory $1,958,880 $2,463,262 $3,440,747
Other Current Assets $303,936 $378,936 $463,936
Total Current Assets $4,770,480 $8,305,872 $13,682,013
Long-term Assets
Long-term Assets $3,221,650 $3,221,650 $3,221,650
Accumulated Depreciation $316,000 $532,000 $748,000
Total Long-term Assets $2,905,650 $2,689,650 $2,473,650
Total Assets $7,676,130 $10,995,522 $16,155,663
Liabilities and Capital 1999 2000 2001
Current Liabilities
Accounts Payable $1,786,801 $2,506,020 $3,513,127
Current Borrowing $4 $4 $4
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $1,786,805 $2,506,024 $3,513,131
Long-term Liabilities $2,796,750 $2,502,114 $2,502,114
Total Liabilities $4,583,555 $5,008,138 $6,015,245
Paid-in Capital $525,000 $1,175,000 $1,825,000
Retained Earnings $1,021,611 $2,567,575 $4,812,383
Earnings $1,545,964 $2,244,809 $3,503,035
Total Capital $3,092,575 $5,987,383 $10,140,418
Total Liabilities and Capital $7,676,130 $10,995,522 $16,155,663
Net Worth $3,092,575 $5,987,383 $10,140,418

7.7 Business Ratios

Standard business ratios are included in the following table. The ratios show an aggressive plan for growth in order to reach maximum production within three years. Return on investment increases each year as we bring the new facility to maximum capacity and production. Return on sales and assets remain strong and cost of goods decreases based upon efficiency projections. Projections are based on the 1997/98 selling price. Industry Profile is based on NAICS code 311920, Coffee and Tea Manufacturing.

Ratio Analysis
1999 2000 2001 Industry Profile
Sales Growth 43.14% 25.75% 39.69% 5.50%
Percent of Total Assets
Inventory 25.52% 22.40% 21.30% 12.43%
Other Current Assets 3.96% 3.45% 2.87% 27.50%
Total Current Assets 62.15% 75.54% 84.69% 60.13%
Long-term Assets 37.85% 24.46% 15.31% 39.87%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 23.28% 22.79% 21.75% 8.46%
Long-term Liabilities 36.43% 22.76% 15.49% 16.54%
Total Liabilities 59.71% 45.55% 37.23% 25.00%
Net Worth 40.29% 54.45% 62.77% 75.00%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 16.82% 17.10% 17.50% 23.32%
Selling, General & Administrative Expenses 10.94% 10.31% 9.91% 9.39%
Advertising Expenses 0.55% 0.50% 0.36% 2.06%
Profit Before Interest and Taxes 12.13% 13.55% 14.82% 4.36%
Main Ratios
Current 2.67 3.31 3.89 5.32
Quick 1.57 2.33 2.92 3.45
Total Debt to Total Assets 59.71% 45.55% 37.23% 27.13%
Pre-tax Return on Net Worth 94.32% 70.74% 65.18% 12.79%
Pre-tax Return on Assets 38.00% 38.52% 40.91% 17.55%
Additional Ratios 1999 2000 2001
Net Profit Margin 5.89% 6.80% 7.59% n.a
Return on Equity 49.99% 37.49% 34.55% n.a
Activity Ratios
Inventory Turnover 10.91 12.08 12.64 n.a
Accounts Payable Turnover 14.25 12.17 12.17 n.a
Payment Days 27 26 26 n.a
Total Asset Turnover 3.42 3.00 2.86 n.a
Debt Ratios
Debt to Net Worth 1.48 0.84 0.59 n.a
Current Liab. to Liab. 0.39 0.50 0.58 n.a
Liquidity Ratios
Net Working Capital $2,983,675 $5,799,847 $10,168,882 n.a
Interest Coverage 11.84 18.76 30.35 n.a
Additional Ratios
Assets to Sales 0.29 0.33 0.35 n.a
Current Debt/Total Assets 23% 23% 22% n.a
Acid Test 1.57 2.33 2.92 n.a
Sales/Net Worth 8.49 5.52 4.55 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
Unit Sales
Import and Export 0% 8,700 8,200 8,800 8,300 8,450 8,050 8,000 8,200 8,050 8,000 9,050 8,400
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 8,700 8,200 8,800 8,300 8,450 8,050 8,000 8,200 8,050 8,000 9,050 8,400
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Import and Export $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08 $262.08
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Import and Export $2,280,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $2,280,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Import and Export 0.00% $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00 $212.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Import and Export $1,844,400 $1,738,400 $1,865,600 $1,759,600 $1,791,400 $1,706,600 $1,696,000 $1,738,400 $1,706,600 $1,696,000 $1,918,600 $1,780,800
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,844,400 $1,738,400 $1,865,600 $1,759,600 $1,791,400 $1,706,600 $1,696,000 $1,738,400 $1,706,600 $1,696,000 $1,918,600 $1,780,800
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
Antonio Silvera, VP Production $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Plant Employees $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333 $18,333
Other $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Subtotal $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033
Sales and Marketing Personnel
Marco Silvera Jr, VP Sales/Mktg. $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750 $3,750
Other $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041 $15,041
Subtotal $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791
General and Administrative Personnel
Marco Slivera Sr, CEO $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Ralph Henzo, CFO $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Admin/Acctg. Staff $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Other $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Subtotal $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950
Other Personnel
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774

Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $2,280,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
Direct Cost of Sales $1,844,400 $1,738,400 $1,865,600 $1,759,600 $1,791,400 $1,706,600 $1,696,000 $1,738,400 $1,706,600 $1,696,000 $1,918,600 $1,780,800
Production Payroll $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033 $25,033
Other Costs of Sales $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Total Cost of Sales $1,894,433 $1,788,433 $1,915,633 $1,809,633 $1,841,433 $1,756,633 $1,746,033 $1,788,433 $1,756,633 $1,746,033 $1,968,633 $1,830,833
Gross Margin $385,663 $360,623 $390,671 $365,631 $373,143 $353,111 $350,607 $360,623 $353,111 $350,607 $403,191 $370,639
Gross Margin % 16.91% 16.78% 16.94% 16.81% 16.85% 16.74% 16.72% 16.78% 16.74% 16.72% 17.00% 16.84%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791 $18,791
Advertising/Promotion $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Travel $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750
Other Sales and Marketing Expenses $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Sales and Marketing Expenses $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541 $34,541
Sales and Marketing % 1.51% 1.61% 1.50% 1.59% 1.56% 1.64% 1.65% 1.61% 1.64% 1.65% 1.46% 1.57%
General and Administrative Expenses
General and Administrative Payroll $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950 $9,950
Marketing/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Leased Equipment $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Utilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Insurance $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Rent $0 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750
Payroll Taxes 9% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $41,150 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900 $68,900
General and Administrative % 1.80% 3.21% 2.99% 3.17% 3.11% 3.27% 3.29% 3.21% 3.27% 3.29% 2.90% 3.13%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Other % 0.07% 0.07% 0.07% 0.07% 0.07% 0.07% 0.07% 0.07% 0.07% 0.07% 0.06% 0.07%
Total Operating Expenses $77,191 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941 $104,941
Profit Before Interest and Taxes $308,472 $255,682 $285,730 $260,690 $268,202 $248,170 $245,666 $255,682 $248,170 $245,666 $298,250 $265,698
EBITDA $326,472 $273,682 $303,730 $278,690 $286,202 $266,170 $263,666 $273,682 $266,170 $263,666 $316,250 $283,698
Interest Expense $23,885 $23,621 $23,356 $23,092 $22,827 $22,563 $22,298 $22,034 $21,769 $21,505 $21,240 $20,976
Taxes Incurred $133,756 $109,069 $123,316 $111,671 $115,326 $106,035 $104,983 $109,815 $106,408 $105,356 $130,195 $115,019
Net Profit $150,831 $122,992 $139,058 $125,927 $130,049 $119,572 $118,385 $123,834 $119,992 $118,805 $146,815 $129,703
Net Profit/Sales 6.62% 5.72% 6.03% 5.79% 5.87% 5.67% 5.65% 5.76% 5.69% 5.67% 6.19% 5.89%

Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $2,280,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
Subtotal Cash from Operations $2,280,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
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 $2,700,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $4,980,096 $2,149,056 $2,306,304 $2,175,264 $2,214,576 $2,109,744 $2,096,640 $2,149,056 $2,109,744 $2,096,640 $2,371,824 $2,201,472
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774 $53,774
Bill Payments $132,806 $3,668,016 $1,850,946 $2,222,911 $1,867,189 $2,040,313 $1,827,442 $1,898,330 $1,996,185 $1,883,378 $1,911,190 $2,379,772
Subtotal Spent on Operations $186,580 $3,721,790 $1,904,720 $2,276,685 $1,920,963 $2,094,087 $1,881,216 $1,952,104 $2,049,959 $1,937,152 $1,964,964 $2,433,546
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 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833 $4,833
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750 $27,750
Purchase Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Purchase Long-term Assets $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $421,413 $3,984,373 $2,167,303 $2,539,268 $2,183,546 $2,356,670 $2,143,799 $2,214,687 $2,312,542 $2,199,735 $2,227,547 $2,696,129
Net Cash Flow $4,558,683 ($1,835,317) $139,001 ($364,004) $31,030 ($246,926) ($47,159) ($65,631) ($202,798) ($103,095) $144,277 ($494,657)
Cash Balance $5,552,943 $3,717,626 $3,856,626 $3,492,622 $3,523,653 $3,276,727 $3,229,568 $3,163,937 $2,961,139 $2,858,044 $3,002,321 $2,507,664

Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $994,260 $5,552,943 $3,717,626 $3,856,626 $3,492,622 $3,523,653 $3,276,727 $3,229,568 $3,163,937 $2,961,139 $2,858,044 $3,002,321 $2,507,664
Inventory $355,200 $2,028,840 $1,912,240 $2,052,160 $1,935,560 $1,970,540 $1,877,260 $1,865,600 $1,912,240 $1,877,260 $1,865,600 $2,110,460 $1,958,880
Other Current Assets $243,936 $248,936 $253,936 $258,936 $263,936 $268,936 $273,936 $278,936 $283,936 $288,936 $293,936 $298,936 $303,936
Total Current Assets $1,593,396 $7,830,719 $5,883,802 $6,167,722 $5,692,118 $5,763,129 $5,427,923 $5,374,104 $5,360,113 $5,127,335 $5,017,580 $5,411,717 $4,770,480
Long-term Assets
Long-term Assets $521,650 $746,650 $971,650 $1,196,650 $1,421,650 $1,646,650 $1,871,650 $2,096,650 $2,321,650 $2,546,650 $2,771,650 $2,996,650 $3,221,650
Accumulated Depreciation $100,000 $118,000 $136,000 $154,000 $172,000 $190,000 $208,000 $226,000 $244,000 $262,000 $280,000 $298,000 $316,000
Total Long-term Assets $421,650 $628,650 $835,650 $1,042,650 $1,249,650 $1,456,650 $1,663,650 $1,870,650 $2,077,650 $2,284,650 $2,491,650 $2,698,650 $2,905,650
Total Assets $2,015,046 $8,459,369 $6,719,452 $7,210,372 $6,941,768 $7,219,779 $7,091,573 $7,244,754 $7,437,763 $7,411,985 $7,509,230 $8,110,367 $7,676,130
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $8,435 $3,606,760 $1,776,433 $2,160,879 $1,798,931 $1,979,476 $1,764,281 $1,831,660 $1,933,419 $1,820,231 $1,831,254 $2,318,158 $1,786,801
Current Borrowing $58,000 $53,167 $48,334 $43,501 $38,668 $33,835 $29,002 $24,169 $19,336 $14,503 $9,670 $4,837 $4
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $66,435 $3,659,927 $1,824,767 $2,204,380 $1,837,599 $2,013,311 $1,793,283 $1,855,829 $1,952,755 $1,834,734 $1,840,924 $2,322,995 $1,786,805
Long-term Liabilities $402,000 $3,102,000 $3,074,250 $3,046,500 $3,018,750 $2,991,000 $2,963,250 $2,935,500 $2,907,750 $2,880,000 $2,852,250 $2,824,500 $2,796,750
Total Liabilities $468,435 $6,761,927 $4,899,017 $5,250,880 $4,856,349 $5,004,311 $4,756,533 $4,791,329 $4,860,505 $4,714,734 $4,693,174 $5,147,495 $4,583,555
Paid-in Capital $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000
Retained Earnings $85,985 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611 $1,021,611
Earnings $935,626 $150,831 $273,823 $412,881 $538,809 $668,857 $788,429 $906,814 $1,030,648 $1,150,640 $1,269,445 $1,416,261 $1,545,964
Total Capital $1,546,611 $1,697,442 $1,820,434 $1,959,492 $2,085,420 $2,215,468 $2,335,040 $2,453,425 $2,577,259 $2,697,251 $2,816,056 $2,962,872 $3,092,575
Total Liabilities and Capital $2,015,046 $8,459,369 $6,719,452 $7,210,372 $6,941,768 $7,219,779 $7,091,573 $7,244,754 $7,437,763 $7,411,985 $7,509,230 $8,110,367 $7,676,130
Net Worth $1,546,611 $1,697,442 $1,820,434 $1,959,492 $2,085,420 $2,215,468 $2,335,040 $2,453,425 $2,577,259 $2,697,251 $2,816,056 $2,962,872 $3,092,575
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 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Tax Rate 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00% 47.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0