Don't bother with copy and paste.

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

Download for free

Coffee Shop & Cafe icon Coffee Distribution Business Plan

Start your plan

The Coffee Warehouse

Executive Summary

The Coffee Warehouse is a new business providing high-quality, full service distribution of coffee, specialty beverages and beverage-related supplies to coffee houses and espresso stands throughout the Spokane and Northern Idaho market.

The principal owners are Steve and Jennifer Smith, whose combined experience brings office management, high levels of customer service, and over 20 years in distribution and sales management.  At this time we are seeking additional equity capital to compliment our own investment and are seeking to arrange a bank line for inventory and receivables financing.  We have firm commitments to distribute several high-quality new age beverage products, and have verbal commitments from independent retailers throughout the Spokane and Northern Idaho market to carry our product.  We plan to distribute our first products within 30-60 days of finalizing financial arrangements.

Sales projections for The Coffee Warehouse are estimated to begin at approximately $2,229,000 the first year, increasing to approximately $2,558,000 in Year 2 and approximately $2,936,000 in Year 3.  Our net profit is projected at approximately $283,000 the first year, increasing to $406,000 by the end of the third year of operation.

Distinguishing characteristics of our business will be the combination of management experience, sales and distribution experience, high-quality, innovative products and exceptional customer service.  In particular, what really sets up apart is that we are the ONLY full service distribution company servicing the coffee and specialty beverage industry in the Spokane/Northern Idaho market.   In addition, The Coffee Warehouse has an exclusive contract to distribute a new, groundbreaking product that would enable us to gain immediate access to a majority of the potential customer base.

Coffee distribution business plan, executive summary chart image

1.1 Objectives

  • To open and operate a successful coffee and new age beverage distributorship in the Spokane/Northern Idaho market, employing three to five employees the first year.
  • To obtain a minimum of 100 regular customers in the Spokane/North Idaho market the first year of operation.
  • Achieve first year sales of $2,000,000.
  • Maintain an average gross margin of 25 percent.
  • To produce a net profit of at least $400,000 by the end of the third year of operation.

1.2 Mission

The Coffee Warehouse intends to become a recognized distributor of specialty beverages and beverage-related supplies and services to coffee houses and espresso stands throughout Spokane and Northern Idaho.

The Coffee Warehouse plans to develop strong relationships with key customers so we will be viewed as indispensable partners, rather than just another supplier. We will work closely with each customer to recommend product assortment unique for their retail base, appropriate stocking levels, pricing and display assortments, as well as promotional ideas and material to increase sales. The Coffee Warehouse will seek out and work with the manufacturers we represent to deliver the most innovative and exciting products possible to the customers we serve. We are not only selling product, we are selling service.

1.3 Keys to Success

  • Innovative quality products.
  • Individualized customer service – providing our customers with what they want, when and how they want it.
  • Only full service distribution company in the Spokane/Northern Idaho market.
  • Fully integrated programs to help customers increase sales through menu development, creative promotions, advertising, and custom marketing material.
  • Exclusive distribution rights to ground-breaking products not currently available in our market.
  • The combined experience of the principal owners bring upper office management skills, high levels of customer service, and over 20 years in distribution and sales management.

Company Summary

The Coffee Warehouse, Inc. is a new S-corporation business located in Spokane, Washington, and will be established based on the details of the following plan.

2.1 Company Location & Facilities

The Coffee Warehouse will be located in the Spokane Valley within the Spokane Industrial Business Park.  This is a prime location to service both the Spokane and Northern Idaho market. The facilities will include approximately 5,000 square feet of warehouse space, with an additional 1,400 square feet built out for office/retail space.  We are currently negotiating lease terms on the several available properties, and plan to have a lease signed by July 31.

2.2 Company Ownership

The Coffee Warehouse is a privately held S-Corporation owned in total by its co-founders, Steve and Jennifer Smith.

UBI Number:  XXX-XXX-XXX (removed to protect confidentiality)

2.3 Start-up Summary

Start-up expenses for the Coffee Warehouse total $16,450, and include expenses such as legal, marketing, lease deposit, computer systems, etc.  Start-up assets include $9,800 in initial cash requirements, $18,750 in short term assets (office furniture, refrigeration equipment), and $75,000 in starting inventory.  These start-up costs will be financed through investments and small-business loans.  The details of the start-up summary are included in the following table.

Coffee distribution business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal Business Formation $220
Business Plan $90
Warehouse Lease Deposit $2,800
Insurance (first month) $500
Utilities (first month) $350
Research & Development $1,200
Marketing $1,200
Advertising $250
Personnel $2,060
Business/Office Supplies $1,550
Computer Systems $3,080
Phone System $650
Communication Lines $300
Trade Show/Grand Opening $2,200
Total Start-up Expenses $16,450
Start-up Assets
Cash Required $9,800
Start-up Inventory $75,000
Other Current Assets $18,750
Long-term Assets $0
Total Assets $103,550
Total Requirements $120,000
Start-up Funding
Start-up Expenses to Fund $16,450
Start-up Assets to Fund $103,550
Total Funding Required $120,000
Assets
Non-cash Assets from Start-up $93,750
Cash Requirements from Start-up $9,800
Additional Cash Raised $0
Cash Balance on Starting Date $9,800
Total Assets $103,550
Liabilities and Capital
Liabilities
Current Borrowing $95,000
Long-term Liabilities $0
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
Total Liabilities $95,000
Capital
Planned Investment
Investor 1 $25,000
Other $0
Additional Investment Requirement $0
Total Planned Investment $25,000
Loss at Start-up (Start-up Expenses) ($16,450)
Total Capital $8,550
Total Capital and Liabilities $103,550
Total Funding $120,000

Products

The Coffee Warehouse will provide a first-class delivery service of quality hot and cold beverage related supplies, including whole bean or ground coffee, flavor syrups, jet teas, fruit smoothies, bubble teas, concentrated milk, fresh baked goods and assorted paper supplies. Our services will include invaluable trade resources, effective promotional programs, custom-designed marketing material, informative monthly newsletters, training and product demonstrations, as well as information on the latest market trends in the coffee/specialty beverage industry.

3.1 Product & Service Description

PRODUCT DESCRIPTION
The Coffee Warehouse will carry a variety of quality products that will enable us to provide full service delivery to espresso stands and coffee houses. Our underlying philosophy in selecting products is to choose lines that will bring consistent quality, competitive prices, and product satisfaction to our customers. We have personally researched and sampled each of the following products that we offer to ensure the quality we guarantee.

  • Lowery’s Gourmet Whole Bean and Wired Willey’s White Coffee
  • Assorted Gourmet Syrups & Coffee Toppings
  • Chocolate, White Chocolate and Caramel Syrups/Sauces
  • Oregon Chai Concentrate
  • Jet Cafe and Jet Tea Fruit n’ Tea Freeze
  • Cappuccina line of product
  • Big Train line of product
  • Red Bull Energy Drinks
  • Good Cow Concentrated Milk with Custom Dispensing Equipment
  • Fresh Baked Goods
  • Assortment of White, Pre-printed Paper, and Clear Beverage Cups Systems – as well as an assortment of other paper supplies

At this time, the majority of these products are only available to customers through wholesale vendors such as Cash and Carry retail outlets – therefore it is the customer’s responsibility to acquire these products by their own means. The Coffee Warehouse will make these same products available through our high quality, full service delivery – bringing these products directly to their doorstep at a competitive price.

SERVICE DESCRIPTION
An important component of our business is not just our products, but our service. In addition to our full service delivery, the following are other important service elements that we will offer to our customers:

  • Ideas to help our customers increase sales through menu development, creative promotions, co-op advertising, and much more.
  • Custom designed marketing material such as printed banners, promotional posters, punch cards, pre-purchased beverage cards, reader boards, etc.
  • Distribute a monthly newsletter featuring the latest coffee trends, new industry equipment, breaking trade news, promotional ideas, new creative recipes, and upcoming events.
  • Samples of the latest product releases – with eye-catching point-of-sale to advertise new items to the end consumer.
  • Routine equipment maintenance and training.

3.2 Competitive Edge

KEY COMPETITIVE STRENGTHS
No other wholesaler in the market offers full service delivery with the variety of product we feature. We are better positioned than our main competitors to take advantage of the increasing demands of coffee and specialty beverage supplies because we focus exclusively on high-quality distribution and customer service. In addition to the variety of products we feature, The Coffee Warehouse has exclusive distribution rights to Good Cow’s concentrated milk/dispensing system. This product is not currently available in our market by any other suppliers.

KEY COMPETITIVE WEAKNESSES
Our primary weakness is that we are a new business competing largely against established suppliers. To significantly build sales, we must not just find new customers – we must take customers away from existing suppliers. However by offering a superior selection of supplies, new groundbreaking products to the market, and focusing on high-quality service and full service delivery, we feel will can quickly establish accounts and build strong relationships. Co-founder Jennifer Smith has had many discussions with owners of coffee and espresso businesses that confirm this opinion.

3.3 Sales Literature

Sales literature to be distributed to both current and potential customers will include brochures, fliers, newsletters, as well as other print media such as print advertisements.  Jennifer Smith is highly skilled in graphic design and desktop publishing, and has quality design and printing equipment to publish professional pieces at a low cost.

3.4 Sourcing

The Coffee Warehouse will purchase product directly from manufacturers, as well as master distributors. Because this eliminates the broker or “middle man,” this allows us to operate on a 25-30% profit margin, while providing our customers with competitive prices.

To further reduce costs, The Coffee Warehouse plans to share product shipments out of California with distributors operating in Portland, Oregon and Tri-Cities, Washington. Other product not being shipped directly to Spokane will be purchased and picked up in Seattle, Washington. The Coffee Warehouse plans to send a truck to Seattle on a bi-weekly basis to pick up product, thus cutting costs by an average of 5%.

3.5 Technology

To streamline the efficiency of our distribution methods, The Coffee Warehouse plans to use the latest in cutting edge technology – not only in the warehouse – but also in the trade.

All of our drivers/sales representatives will be equiped with Thinque MSP handhelds and software. Thinque MSP applications will reduce field expenses, decrease day’s sales outstanding, and increase worker efficiency. Features can be used in or out of the warehouse and include managing returns and collections; adjusting item price, profit or margin; applying promotional items to an account; streamlining orders; tracking inventory; reducing out-of-stocks; and providing sales history reports. All information recorded in the handheld is available in real time to be viewed by management in the office.

3.6 Future Products and Services

Within the first year of business, The Coffee Warehouse intends to open a retail/wholesale store and high-quality showroom.  Products will be available for purchase by both our wholesale customers who may need product between delivery days, as well as retail consumers interested in purchasing product for their home use.  We will also offer a showroom that will feature equipment, supplies, trade resources, and information on marketing services with examples of marketing and promotional material available to customers.

With the addition of the product showroom, The Coffee Warehouse will offer customers quarterly product and training demonstrations that will be presented by trained beverage experts from the industry.

The Coffee Warehouse also plans to hold semi-annual trade shows for current or potential customers. These trade shows will allow customers the opportunity to sample products, talk to manufacturers, learn about new industry trends, review marketing material, and network with other business owners in their market.

Market Analysis Summary

Coffee is the second largest commodity market next to oil, and growth is expected to continue at a strong pace for the foreseeable future. The specialty beverage industry is growing at an equally strong pace, with sales growth in some categories projected to grow at rates of 40% per year.

This growth offers excellent opportunities for new companies to enter this market, and we are excited about the possibilities of what The Coffee Warehouse can accomplish in the Spokane and Northern Idaho market.

4.1 Market Segmentation

The gourmet coffee and specialty beverage industry is divided into several segments. Consumers who enjoy these products purchase drinks at restaurants, coffee houses, sports venues, drive-thru espresso stands, and even inside other retail establishments that might feature an independent beverage stand.

As illustrated in the chart below, within the market surrounding Spokane, Rathdrum, Post Falls and Coeur d’Alene, there are currently 250 drive-thru espresso stands, 18 coffee/tea houses, 52 independent inner-retail espresso stands, and approximately 10 stands in locations such as sports venues, university campuses, and etc. These figures are not including the number of restaurants, bars and cafes that also feature these beverages.

Coffee distribution business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Drive-thru Espresso 4% 250 259 268 277 287 3.51%
Inner-Retail Espresso 4% 52 54 56 58 60 3.64%
Coffee/Tea Houses 5% 18 19 20 21 22 5.14%
Other (sports venues, universities, etc) 5% 10 11 12 13 14 8.78%
Total 3.79% 330 343 356 369 383 3.79%

4.2 Target Market Segment Strategy

While the market is already sizeable, this industry continues to grow. New espresso stands open their doors to the public on a monthly basis in our market, and it isn’t uncommon to see numerous espresso stands within a one or two mile radius. The article below, published by a national coffee retail magazine, discusses our market’s unique drive-thru espresso industry. The sales potential in this market is unlimited.

The Coffee Warehouse initially plans to target these drive-thru espresso stands, as well as all inner-retail espresso stands within our designated market. It is this segment that is most in need of the services we are planning to offer. Essential needs include: quality products at competitive prices, first class service, and strong sales support. It is most often these small owner-operated businesses that are neglected by larger suppliers and are forced to service themselves. It is also these smaller businesses who could most greatly benefit from marketing services, sales support, and full service product delivery. Providing the same high-quality service, within the first six months of operation, The Coffee Warehouse plans to expand our target into formal coffee houses and cafes, and as business grows and stabilizes, eventually evaluate the needs of potential customers in the restaurants and bar industry.

Coffee distribution business plan, market analysis summary chart image

4.3 Market Growth

Coffee has been a growing industry for the past several years.  In the gourmet/specialty coffee industry alone, the figures show an impressive rate of growth in the United States.

The new age beverage industry is growing at an equally strong pace.  Sales growth in the chai tea category alone is estimated to be 50% historically, with projected growth rates of 40% per year. Energy drinks, including brands such as Red Bull – and trends such as Jet Tea – are driving the new age beverage growth, and have increased 50-fold in the past three years.

Bubble Tea has been a rapidly growing market in Asia, though it is relatively new to the United States.   Introduced to trend setting marketings such as San Francisco and Seattle, sales have been exploding – and the craze of the “Tapioca Pearl” is expected to spread throughout America.

Coffee distribution business plan, market analysis summary chart image

4.4 Industry Analysis

The coffee and specialty beverage industry is pulverized, with hundreds of manufacturers, brokers, suppliers and retailers. Unlike the beer/soda industry, with large companies such as Anheuser Busch, Pepsi and Coca Cola controlling most of the market, the coffee and specialty beverage industry does not have large national chains with market control.

In an open industry growing at such a strong rate, The Coffee Warehouse is in position to capitalize on the customer’s need for quality product, exceptional service, and an effective partner to success.

4.5 Industry Participants

With the rate of growth in the gourmet coffee market, in addition to the recent trends in Jet Teas and other specialty beverages, the industry is comprised of many small participants, each focusing on only a few specific items or brands at a time.  As the markets evolve, we expect the industry to consolidate with larger distributors representing more of a vast selection of products in each market.

Currently in our segment of the industry, there are no large national chains with market control.  There are also few products that are offered with exclusive rights to one market.  While this is the case with many products, The Coffee Warehouse is working with manufacturers to change that practice, and not only represent a larger variety of product than others in our industry, but also acquire exclusive rights to many of the products in our portfolio.

4.6 Distribution Patterns

The following flow chart illustrates the overall industry surrounding the distribution patterns of coffee and specialty beverages.   (The Coffee Warehouse falls into the level highlighted in yellow).

Several manufacturers are represented by master distributors and/or brokers who in turn provide the product to direct distributors and other wholesale suppliers.  Other manufacturers allow distributors and suppliers to purchase product direct – depending on the quantity of product being purchased.   Product is then distributed or sold through cash and carry wholesale stores to retail businesses as illustrated below.

Coffee distribution business plan, market analysis summary chart image

4.7 Competition & Buying Patterns

While there are a handful of coffee and specialty beverage suppliers providing product in our market, there is still a great deal of room for new business. Most importantly, there is room for new business that understands the need for high-quality service and sales support – in addition to product at competitive prices.

In this industry, customers choose their suppliers based on available product, price, and service – though most often, it is the service that suffers most. While one supplier may offer the product at the right price, they do not provide the level of service that the customer demands. The next supplier may offer the right level of service, though their prices are too high. This results with the customer purchasing most of their supplies through a cash and carry style wholesale store – leaving the customer with no service or support.

By positioning ourselves in the market with in-demand, quality product at competitive prices, with a consistent high level of customer service – we are confident that we will see customers and their business continue to increase.

Sales and Marketing

The unique aspects of our business include individual product selection, quality assurance, and high-quality full service distribution. Our strategy is to focus 100% of our efforts on the market for espresso supplies in the Spokane and Northern Idaho area. By focusing all of our effort and energy on this particular area, we expect to quickly develop and maintain a leadership position. The Coffee Warehouse’s key personnel will stay in contact with our customers, and will be able to respond to changes in this market much faster than our competitors.

The Coffee Warehouse will offer the best, most highly personalized service in the marketplace. Being a small, owner-operated company, we intend to use this to our advantage to be absolutely certain that every one of our customers receive excellent service. We will go out of our way to make sure that our customers know that they truly matter to us.  Sales reps and in-house personnel who deal with customers will be carefully trained and given wide latitude for insuring that customers are always satisfied.

5.1 Marketing Strategy

Our basic marketing strategy is to work with customers on a one-to-one basis to ensure their supply needs are being met and help develop unique marketing programs for each of them. We intend to prioritize customer service and make it a key component of our marketing programs. We believe that providing our customers with what they want, when and how they want it, is the key to repeat business and positive word-of-mouth advertising. Because we want to develop close working relationships with our customers, we want to establish accounts in as personable a way as possible. It is for this reason that we will overwhelmingly emphasize in-person sales calls to build accounts.

We will closely integrate all of our marketing and sales efforts to project a consistent image of our company and a consistent positioning of our products and services. We will build this image around our name “The Coffee Warehouse, Inc.” and emphasize to customers the high-quality service that is behind this name.

To support our marketing initiatives and product knowledge, we will attend as many area conventions and trade shows as possible to ensure we are offering the most up-to-date market trend information.

5.2 Promotion Strategy

Relationships are the key to success in the distribution business. Personal selling will remain our most important means of promotion. Both Steve and Jennifer Smith will lead this effort – Steve, with his skill and experience in sales and distribution, and Jennifer in customer service and relations.  In addition to personal selling, The Coffee Warehouse has identified several other means of advertising and publicity.

The Coffee Warehouse will send news releases to local media and press, as well as trade magazines to try to get product and company feature coverage in front of the eyes of our customers – as well as the end consumer. We will also produce a few generic press releases about the products we are distributing for our customers to use toward publicity coverage for their businesses in local publications such as the Spokesman, The Inlander and Local Planet.

Third, we shall have a monthly newsletter for current of potential customers. This newsletter will highlight new and current trends in the industry, upcoming conventions and trade shows, offer promotions and special deals, as well as provide new recipes, fun tips and other information that can be used in their business. We will also highlight not just our products, but also display ideas and success stories of other business in the industry.   As a more straight forward advertising effort, The Coffee Warehouse will feature an advertisement in the Yellow Pages, frequent ads in the Spokesman Review, the Inlander, and the Local Planet, as well as participation in networking, local trade shows, and personal word-of-mouth advertising.

5.3 Distribution Strategy

To begin, The Coffee Warehouse will operate two delivery trucks with a third vehicle for special deliveries between scheduled delivery days.  Deliveries will be made Monday through Friday, and will be strategically routed to minimize travel time and fuel costs – while maximizing production.   On average, we will service 20-30 accounts per day, with deliveries to each account twice a week. As the number of accounts increase, the need for additional delivery trucks will continue to be evaluated. With each additional delivery truck, routes will be restructured to maintain maximum efficiency.

5.4 Sales Strategy

Distribution sales are dependent on repeat business, therefore the sales strategy for The Coffee Warehouse is based on personal, consistent sales contact, with a high emphasis on customer service and relations.   Because we are a new distributor, we understand that we will have to prove our worth to our customers in order to earn their respect and business. Both of the owners, Steve and Jennifer, will make personal calls on potential customers to review our product line and services, give general information on our company, and discuss how we feel we can help them succeed in their business.

The Coffee Warehouse will begin operations with two full-time delivery/sales representatives, who will be responsible for providing full service and delivery to current customers, but also make sales calls for potential new business. This delivery/sales representatives will receive a base salary, with commission on qualified sales, as well as bonuses for new acquired business.  Customers will be scheduled for a pre-arranged delivery day once or twice a week, depending on the quantity and timeline of product needed. Product orders can be placed in a number of ways to help facilitate the process:

  • Phoned Orders: Customers can easily phone orders into our office, up until 2:30 p.m. of the afternoon prior to their scheduled delivery day.
  • Faxed Orders: Customers can fax in a completed product order sheet, with the same deadline as phoned orders.
  • Tel-Sell: Customers may choose to have a representative from the office call them the day prior to their scheduled delivery to check product quantities and assist them in placing their order.

We understand the hectic schedule of a small business, so if a customer fails to call or fax their weekly order, they will receive a courtesy call from our office to verify that an order is not needed.

5.5 Sales Forecast

As indicated in the table, our sales are forecasted to increase rapidly, with an annual growth rate of approximately 30%.

Sbp, coffee distribution business plan, financial plan chart image

Sales Forecast
Year 1 Year 2 Year 3
Sales
Espresso Syrups $415,362 $477,666 $549,316
Chocolate & Caramel Sauces $275,852 $311,713 $352,235
Specialty Beverage Mixes $176,660 $203,158 $233,632
Energy Drinks $44,372 $51,028 $58,683
Concentrated Milk $113,816 $130,889 $150,523
Paper Supplies $1,185,285 $1,363,078 $1,567,540
Marketing $18,305 $21,051 $24,208
Total Sales $2,229,652 $2,558,584 $2,936,137
Direct Cost of Sales Year 1 Year 2 Year 3
Espresso Syrups $345,347 $397,149 $456,722
Chocolate & Caramel Sauces $244,798 $276,622 $312,583
Specialty Beverage Mixes $134,440 $154,606 $177,797
Energy Drinks $36,542 $42,023 $48,327
Concentrated Milk $97,919 $112,607 $129,498
Paper Supplies $888,964 $1,022,308 $1,175,655
Marketing $6,540 $7,521 $8,649
Subtotal Direct Cost of Sales $1,754,550 $2,012,837 $2,309,230

5.6 Milestones

The following table and chart are the important milestones for The Coffee Warehouse.

Sbp, coffee distribution business plan, financial plan chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Market/Trade Research 3/15/2003 5/15/2003 $150 SDS / JLS Marketing
Logo Design/Marketing 4/15/2003 5/15/2003 $1,300 JLS Marketing
Complete Business Plan 4/15/2003 5/30/2003 $90 JLS Marketing
Product/Pricing Comparison 4/15/2003 5/15/2003 $150 SDS / JLS Marketing
Finalize Potential Client List 5/1/2003 5/15/2003 $0 JLS Marketing
Licensing/Incorporation 5/15/2003 6/15/2003 $200 JLS Marketing
Secure Product Line 5/15/2003 6/15/2003 $0 JLS Marketing
Research/Secure Financing 5/15/2003 7/15/2003 $0 SDS / JLS Marketing
Warehouse Selection/Buildout 5/15/2003 6/15/2003 $0 SDS / JLS Marketing
Leasehold Improvements 7/1/2003 8/1/2003 $5,000 SDS / JLS Web
Delivery Vehicle Selection 6/1/2003 6/15/2003 $0 SDS Web
Develop Routing 6/15/2003 7/15/2003 $100 SDS Department
Hire Delivery/Sales Personnel 7/1/2003 7/15/2003 $100 SDS Department
Office Equipment/Computer/Supplies 7/1/2003 8/1/2003 $5,000 JLS Department
Order Beginning Inventory 7/10/2003 7/20/2003 $20,000 SDS / JLS Department
Press Releases/Advertising 7/1/2003 8/1/2003 $250 JLS Department
Organize Grand Opening Trade Show 8/1/2003 8/10/2003 $3,000 JLS Department
Totals $35,340

Management Summary

The Coffee Warehouse will be owned and operated by its founders, initially working with a small employee base that will cover sales and delivery. Management and personnel plans are covered in more detail in the topics to follow.

6.1 Organizational Structure

The Coffee Warehouse will be managed by the two founding partners, whose individual areas of expertise cover many of the functional aspects of the business.

The organizational structure is very simple. Steve Smith will be responsible for the routing, distribution management and delivery systems.  Jennifer Smith will be responsible for customer service, accounting, shipping and the general administration of the business.  Together they will be responsible for product selection and sales and marketing.

The support staff at the office and warehouse, as well as the delivery personnel will report to Jennifer.  Because Steve will be spending a majority of his time in the trade, Jennifer will be able to support any day-to-day needs that the personnel may have. However even when Steve is out of the office, he will be in constant contact via computer or phone.

The goal of The Coffee Warehouse is to have a team of committed associates who empower each other so that the customer’s expectations can be exceeded.  Our goal is to offer career opportunities, advancement opportunities and a level of income and benefits that is competitive within the region and job classification.   It is our long-term goal to be the preferred employer within our niche of the beverage distribution industry.

6.2 Management Team

Steven D.  Smith
Steve has a long history of experience in sales and distribution management, specifically in the beverage industry. As the sales and distribution manager for the largest beverage distributorship in the state, he currently manages ten sales representatives and twenty four merchandisers.  During this time as sales manager, he has helped increase market share from 25 to 40%.

Over the last twenty years, Steve has successfully built and maintained rapport with buyers in the city’s largest key accounts, and has strategically routed sales, merchandising and truck routes throughout the city.

Steve has many industry contacts and an in-depth knowledge of the market.

Jennifer L. Smith
Jennifer recently operated as general manager for a local business and directed a staff of thirteen, overseeing the accounting practices, human resource issues, and day-to-day operations of the company.  Prior to this position, Jennifer has held a variety of other inside business management and operations positions.

Jennifer’s strengths and skills include strong management, excellent public relations, high levels of organization, extensive computer knowledge – including desktop publishing and graphic layout – and extensive presentation and reporting skills.

6.3 Personnel Plan

PERSONNEL – GENERAL
Initially we expect to be able to handle business needs with Steve and Jennifer, one administrative assistant, and two product delivery/sales personnel. As business continues to grow, we intend to hire additional employees one at a time and pay premium, over market labor rates to attract and retain quality help.

Not only will we train our employees to deliver excellent service, we will give them the flexibility to respond creatively to client requests. In addition, we will continually monitor our clients’ level of satisfaction with our service through surveys and other convenient feedback opportunities.

To ensure our personnel are meeting our expectations, we will hold a minimum of quarterly meetings with all employees so that results can be reviewed and future plans can be discussed. At least twice a year, a refresher course will be required on product knowledge and how to exceed our customer’s expectations.

SALES AND DELIVERY
In order to deliver high quality, personalized service we will carefully select all employees – with extra attention given to sales reps and delivery personnel who will deal directly with customers. We will carefully review references not just from past employers or manufacturers, but also from retailers whom these sales reps have served. We will also make sure that each employee understands our way of delivering quality service to each customer. We will have immediate back-up support available by phone from our office for more difficult service issues. We will also give employees enough latitude so that they can respond immediately to almost any customer request or complaint – which in this industry usually means granting immediate credit for damaged merchandise, and adding additional merchandise to an order.

Personnel Plan
Year 1 Year 2 Year 3
Jennifer Smith $30,000 $35,000 $40,000
Sales/Delivery (Salary) $20,400 $21,500 $22,500
Sales/Delivery (Commission) $4,237 $4,500 $4,500
Delivery/Warehouse Personnel $20,400 $21,500 $22,500
Administration $18,720 $19,500 $21,000
Total People 4 4 4
Total Payroll $93,757 $102,000 $110,500

Financial Plan

The Coffee Warehouse projects the gross margin to be at approximately 20-25 percent. Sales projections for FY2004 are at $2,229,652 increasing to $2,558,584 in FY2005 and $2,936,137 in FY2006. Cash-flow analysis, balance sheet, business ratio, break-even analysis, and other financial details are shown in the appendix.

7.1 Important Assumptions

General assumptions for this plan are on the following table.

General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00%
Tax Rate 25.42% 25.00% 25.42%
Other 0 0 0

7.2 Break-even Analysis

The following table and chart illustrate our break-even analysis. With our fixed costs estimate of approximately $15,000 per month, operating on average at a 25% profit margin, we will need to sell 67,666 units to break-even in a month. Fixed costs include our warehouse lease, vehicle leases, utilities, insurance, payroll, and an estimation of other running costs.

Sbp, coffee distribution business plan, financial plan chart image

Break-even Analysis
Monthly Revenue Break-even $75,055
Assumptions:
Average Percent Variable Cost 79%
Estimated Monthly Fixed Cost $15,993

7.3 Projected Profit and Loss

The following table and charts show the projected profit and loss. Monthly projections are included in the appendix.

Sbp, coffee distribution business plan, financial plan chart image

Sbp, coffee distribution business plan, financial plan chart image

Gross margin monthly chart

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $2,229,652 $2,558,584 $2,936,137
Direct Cost of Sales $1,754,550 $2,012,837 $2,309,230
Hidden Row $0 $0 $0
Total Cost of Sales $1,754,550 $2,012,837 $2,309,230
Gross Margin $475,102 $545,747 $626,907
Gross Margin % 21.31% 21.33% 21.35%
Expenses
Payroll $93,757 $102,000 $110,500
Other $0 $0 $0
Depreciation $0 $0 $0
Rent $33,096 $34,260 $35,460
Utilities and Phone $7,200 $7,500 $7,800
Insurance $6,000 $6,300 $6,500
Payroll Burden $14,064 $15,300 $16,575
Leased Equipment (Delivery Vehicles) $12,000 $12,600 $13,200
Leased Equipment (Warehouse) $3,000 $3,000 $3,000
Leased Equipment (Other) $2,400 $2,400 $2,400
Fuel (delivery) $12,000 $12,500 $13,000
Advertising / Promotion $3,600 $3,600 $3,600
Professional Services $2,400 $2,200 $2,600
Miscellaneous (office supplies, etc) $2,400 $2,700 $3,000
Total Operating Expenses $191,917 $204,360 $217,635
Profit Before Interest and Taxes $283,186 $341,387 $409,272
EBITDA $283,186 $341,387 $409,272
Interest Expense $6,560 $4,720 $2,800
Taxes Incurred $69,354 $84,167 $103,312
Other Income
Interest Income $0 $0 $0
Other Income Account Name $0 $0 $0
Total Other Income $0 $0 $0
Other Expense
Account Name $0 $0 $0
Other Expense Account Name $0 $0 $0
Total Other Expense $0 $0 $0
Net Other Income $0 $0 $0
Net Profit $207,271 $252,500 $303,160
Net Profit/Sales 9.30% 9.87% 10.33%

7.4 Projected Cash Flow

The following table shows cash flow for the three years, and the chart illustrates monthly cash flow in the first year. Monthly cash flow projections are included in the appendix.

Sbp, coffee distribution business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $2,229,652 $2,558,584 $2,936,137
Subtotal Cash from Operations $2,229,652 $2,558,584 $2,936,137
Additional Cash Received
Non Operating (Other) Income $0 $0 $0
Sales Tax, VAT, HST/GST Received $0 $0 $0
New Current Borrowing $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0
New Long-term Liabilities $0 $0 $0
Sales of Other Current Assets $0 $0 $0
Sales of Long-term Assets $0 $0 $0
New Investment Received $0 $0 $0
Subtotal Cash Received $2,229,652 $2,558,584 $2,936,137
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $93,757 $102,000 $110,500
Bill Payments $1,826,094 $2,457,050 $2,556,178
Subtotal Spent on Operations $1,919,851 $2,559,050 $2,666,678
Additional Cash Spent
Non Operating (Other) Expense $0 $0 $0
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0
Principal Repayment of Current Borrowing $24,000 $24,000 $24,000
Other Liabilities Principal Repayment $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $1,943,851 $2,583,050 $2,690,678
Net Cash Flow $285,801 ($24,466) $245,459
Cash Balance $295,601 $271,134 $516,594

7.5 Projected Balance Sheet

The projected balance sheet is shown in the following table, with monthly projections in the appendix.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $295,601 $271,134 $516,594
Inventory $358,198 $410,929 $471,438
Other Current Assets $18,750 $18,750 $18,750
Total Current Assets $672,549 $700,813 $1,006,782
Long-term Assets
Long-term Assets $0 $0 $0
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $0 $0 $0
Total Assets $672,549 $700,813 $1,006,782
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $385,728 $185,492 $212,300
Current Borrowing $71,000 $47,000 $23,000
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $456,728 $232,492 $235,300
Long-term Liabilities $0 $0 $0
Total Liabilities $456,728 $232,492 $235,300
Paid-in Capital $25,000 $25,000 $25,000
Retained Earnings ($16,450) $190,821 $443,321
Earnings $207,271 $252,500 $303,160
Total Capital $215,821 $468,321 $771,482
Total Liabilities and Capital $672,549 $700,813 $1,006,782
Net Worth $215,821 $468,321 $771,482

7.6 Business Ratios

The table shows projected business ratios.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 14.75% 14.76% 0.00%
Percent of Total Assets
Inventory 53.26% 58.64% 46.83% 0.00%
Other Current Assets 2.79% 2.68% 1.86% 100.00%
Total Current Assets 100.00% 100.00% 100.00% 100.00%
Long-term Assets 0.00% 0.00% 0.00% 0.00%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 67.91% 33.17% 23.37% 0.00%
Long-term Liabilities 0.00% 0.00% 0.00% 0.00%
Total Liabilities 67.91% 33.17% 23.37% 0.00%
Net Worth 32.09% 66.83% 76.63% 100.00%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 21.31% 21.33% 21.35% 0.00%
Selling, General & Administrative Expenses 8.61% 8.17% 7.51% 0.00%
Advertising Expenses 0.00% 0.00% 0.00% 0.00%
Profit Before Interest and Taxes 12.70% 13.34% 13.94% 0.00%
Main Ratios
Current 1.47 3.01 4.28 0.00
Quick 0.69 1.25 2.28 0.00
Total Debt to Total Assets 67.91% 33.17% 23.37% 0.00%
Pre-tax Return on Net Worth 128.17% 71.89% 52.69% 0.00%
Pre-tax Return on Assets 41.13% 48.04% 40.37% 0.00%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin 9.30% 9.87% 10.33% n.a
Return on Equity 96.04% 53.92% 39.30% n.a
Activity Ratios
Inventory Turnover 10.91 5.23 5.23 n.a
Accounts Payable Turnover 5.73 12.17 12.17 n.a
Payment Days 27 46 28 n.a
Total Asset Turnover 3.32 3.65 2.92 n.a
Debt Ratios
Debt to Net Worth 2.12 0.50 0.30 n.a
Current Liab. to Liab. 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $215,821 $468,321 $771,482 n.a
Interest Coverage 43.17 72.33 146.17 n.a
Additional Ratios
Assets to Sales 0.30 0.27 0.34 n.a
Current Debt/Total Assets 68% 33% 23% n.a
Acid Test 0.69 1.25 2.28 n.a
Sales/Net Worth 10.33 5.46 3.81 n.a
Dividend Payout 0.00 0.00 0.00 n.a

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Espresso Syrups 0% $14,322 $16,470 $18,941 $21,782 $25,049 $28,807 $33,128 $38,097 $43,811 $50,383 $57,940 $66,632
Chocolate & Caramel Sauces 0% $10,465 $12,034 $13,839 $15,915 $18,303 $21,048 $21,048 $24,205 $27,836 $32,011 $36,813 $42,335
Specialty Beverage Mixes 0% $8,626 $6,363 $3,759 $4,006 $4,242 $4,732 $7,887 $10,498 $21,167 $30,347 $34,899 $40,134
Energy Drinks 0% $1,530 $1,760 $2,023 $2,327 $2,676 $3,077 $3,539 $4,070 $4,680 $5,382 $6,190 $7,118
Concentrated Milk 0% $1,530 $2,924 $3,520 $4,245 $5,128 $6,360 $7,914 $9,882 $12,379 $15,556 $19,604 $24,774
Paper Supplies 0% $51,400 $47,414 $43,114 $45,849 $51,378 $58,075 $68,506 $85,766 $123,777 $177,815 $202,120 $230,071
Marketing 0% $700 $805 $910 $1,015 $1,155 $1,295 $1,470 $1,680 $1,890 $2,170 $2,450 $2,765
Total Sales $88,573 $87,770 $86,106 $95,139 $107,931 $123,394 $143,492 $174,198 $235,540 $313,664 $360,016 $413,829
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Espresso Syrups $11,908 $13,694 $15,748 $18,110 $20,827 $23,951 $27,544 $31,675 $36,426 $41,890 $48,174 $55,400
Chocolate & Caramel Sauces $8,441 $9,707 $11,163 $12,837 $14,763 $16,977 $19,524 $22,453 $25,821 $29,694 $34,148 $39,270
Specialty Beverage Mixes $6,496 $4,866 $2,981 $3,192 $3,401 $3,802 $6,168 $8,145 $16,035 $22,852 $26,280 $30,222
Energy Drinks $1,260 $1,449 $1,666 $1,916 $2,204 $2,534 $2,914 $3,352 $3,854 $4,433 $5,097 $5,862
Concentrated Milk $1,308 $2,509 $3,022 $3,646 $4,405 $5,465 $6,804 $8,499 $10,651 $13,389 $16,880 $21,339
Paper Supplies $38,550 $35,560 $32,335 $34,387 $38,534 $43,556 $51,379 $64,325 $92,833 $133,361 $151,590 $172,554
Marketing $250 $288 $325 $363 $413 $463 $525 $600 $675 $775 $875 $988
Subtotal Direct Cost of Sales $68,213 $68,073 $67,240 $74,451 $84,546 $96,749 $114,858 $139,049 $186,297 $246,395 $283,045 $325,635
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Jennifer Smith 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
Sales/Delivery (Salary) 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Sales/Delivery (Commission) 0% $170 $192 $216 $240 $268 $300 $336 $379 $429 $493 $565 $649
Delivery/Warehouse Personnel 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Administration 0% $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $7,630 $7,652 $7,676 $7,700 $7,728 $7,760 $7,796 $7,839 $7,889 $7,953 $8,025 $8,109

General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $88,573 $87,770 $86,106 $95,139 $107,931 $123,394 $143,492 $174,198 $235,540 $313,664 $360,016 $413,829
Direct Cost of Sales $68,213 $68,073 $67,240 $74,451 $84,546 $96,749 $114,858 $139,049 $186,297 $246,395 $283,045 $325,635
Hidden Row $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $68,213 $68,073 $67,240 $74,451 $84,546 $96,749 $114,858 $139,049 $186,297 $246,395 $283,045 $325,635
Gross Margin $20,360 $19,697 $18,866 $20,688 $23,385 $26,645 $28,634 $35,149 $49,243 $67,269 $76,971 $88,194
Gross Margin % 22.99% 22.44% 21.91% 21.74% 21.67% 21.59% 19.96% 20.18% 20.91% 21.45% 21.38% 21.31%
Expenses
Payroll $7,630 $7,652 $7,676 $7,700 $7,728 $7,760 $7,796 $7,839 $7,889 $7,953 $8,025 $8,109
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758 $2,758
Utilities and Phone $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Burden 15% $1,145 $1,148 $1,151 $1,155 $1,159 $1,164 $1,169 $1,176 $1,183 $1,193 $1,204 $1,216
Leased Equipment (Delivery Vehicles) $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Leased Equipment (Warehouse) $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Leased Equipment (Other) $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Fuel (delivery) $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Advertising / Promotion $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Professional Services 15% $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Miscellaneous (office supplies, etc) $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $15,783 $15,808 $15,835 $15,863 $15,895 $15,932 $15,973 $16,023 $16,080 $16,154 $16,237 $16,333
Profit Before Interest and Taxes $4,578 $3,889 $3,030 $4,825 $7,490 $10,713 $12,661 $19,126 $33,163 $51,116 $60,735 $71,861
EBITDA $4,578 $3,889 $3,030 $4,825 $7,490 $10,713 $12,661 $19,126 $33,163 $51,116 $60,735 $71,861
Interest Expense $620 $607 $593 $580 $567 $553 $540 $527 $513 $500 $487 $473
Taxes Incurred $1,187 $821 $609 $1,061 $1,731 $2,540 $3,030 $4,650 $8,162 $12,654 $15,062 $17,847
Other Income
Interest Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Income Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Expense
Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Expense Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Other Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit $2,770 $2,462 $1,828 $3,184 $5,192 $7,620 $9,090 $13,950 $24,487 $37,962 $45,186 $53,541
Net Profit/Sales 3.13% 2.80% 2.12% 3.35% 4.81% 6.18% 6.34% 8.01% 10.40% 12.10% 12.55% 12.94%

Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $88,573 $87,770 $86,106 $95,139 $107,931 $123,394 $143,492 $174,198 $235,540 $313,664 $360,016 $413,829
Subtotal Cash from Operations $88,573 $87,770 $86,106 $95,139 $107,931 $123,394 $143,492 $174,198 $235,540 $313,664 $360,016 $413,829
Additional Cash Received
Non Operating (Other) Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $88,573 $87,770 $86,106 $95,139 $107,931 $123,394 $143,492 $174,198 $235,540 $313,664 $360,016 $413,829
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $7,630 $7,652 $7,676 $7,700 $7,728 $7,760 $7,796 $7,839 $7,889 $7,953 $8,025 $8,109
Bill Payments $2,607 $78,184 $77,442 $76,236 $92,651 $106,626 $122,274 $147,608 $181,556 $257,760 $334,299 $348,850
Subtotal Spent on Operations $10,237 $85,836 $85,118 $83,936 $100,379 $114,386 $130,070 $155,447 $189,445 $265,713 $342,324 $356,959
Additional Cash Spent
Non Operating (Other) Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $12,237 $87,836 $87,118 $85,936 $102,379 $116,386 $132,070 $157,447 $191,445 $267,713 $344,324 $358,959
Net Cash Flow $76,336 ($66) ($1,012) $9,203 $5,552 $7,008 $11,422 $16,751 $44,095 $45,951 $15,692 $54,870
Cash Balance $86,136 $86,071 $85,059 $94,262 $99,813 $106,821 $118,243 $134,994 $179,089 $225,039 $240,731 $295,601
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $9,800 $86,136 $86,071 $85,059 $94,262 $99,813 $106,821 $118,243 $134,994 $179,089 $225,039 $240,731 $295,601
Inventory $75,000 $75,034 $74,880 $73,964 $81,896 $93,001 $106,424 $126,344 $152,954 $204,926 $271,034 $311,349 $358,198
Other Current Assets $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750 $18,750
Total Current Assets $103,550 $179,920 $179,701 $177,773 $194,908 $211,564 $231,995 $263,337 $306,698 $402,765 $514,823 $570,830 $672,549
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $103,550 $179,920 $179,701 $177,773 $194,908 $211,564 $231,995 $263,337 $306,698 $402,765 $514,823 $570,830 $672,549
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $75,600 $74,919 $73,163 $89,114 $102,578 $117,390 $141,641 $173,052 $246,632 $322,728 $335,549 $385,728
Current Borrowing $95,000 $93,000 $91,000 $89,000 $87,000 $85,000 $83,000 $81,000 $79,000 $77,000 $75,000 $73,000 $71,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $95,000 $168,600 $165,919 $162,163 $176,114 $187,578 $200,390 $222,641 $252,052 $323,632 $397,728 $408,549 $456,728
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $95,000 $168,600 $165,919 $162,163 $176,114 $187,578 $200,390 $222,641 $252,052 $323,632 $397,728 $408,549 $456,728
Paid-in Capital $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Retained Earnings ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450) ($16,450)
Earnings $0 $2,770 $5,232 $7,060 $10,244 $15,436 $23,056 $32,146 $46,096 $70,583 $108,545 $153,731 $207,271
Total Capital $8,550 $11,320 $13,782 $15,610 $18,794 $23,986 $31,606 $40,696 $54,646 $79,133 $117,095 $162,281 $215,821
Total Liabilities and Capital $103,550 $179,920 $179,701 $177,773 $194,908 $211,564 $231,995 $263,337 $306,698 $402,765 $514,823 $570,830 $672,549
Net Worth $8,550 $11,320 $13,782 $15,610 $18,794 $23,986 $31,606 $40,696 $54,646 $79,133 $117,095 $162,281 $215,821