Financial Spread Sheet Revised (Did not take all the attachments need for assignment)

NON-ALCOHOLIC BEVERAGE COMPANY PORTFOLIO

(The NAB Company Portfolio will have lists of things that the BUS599 students would be able to sort

through to conduct a SWOT Analysis and to apply to appropriate sections of the NAB Business Plan. )

Note #1:

This is the compilation of Data, Notes, and Information that have been put together to create a

Business Plan for a start-up company in the non-alcoholic beverage industry.

The goal of my business plan is twofold:

1. To help identify and outline all the issues I will need to address in starting this company.

2. To present to funders to help raise money to finance this company.

NAB Background:

Melinda Cates has been selling her NAB at County Fairs for the past 7 years for $2 a bottle. She

sells an average of 10 Cardboard cartons each weekend a County Fair is open. From her

calculations, it takes $.56 to make a bottle of NAB when she calculates all the NAB ingredients

and the cost of the bottle and cap. Her rich uncle, Bill, just died and left her a small monetary

inheritance. However, since he so enjoyed her home-made NAB, he also left her equipment to

start a small NAB business.

Melinda and I have been close, trusted friends for years. She found out that I just earned my

MBA from Strayer University, and she asked me to help her get her NAB business up and

running.

I have agreed to put together a NAB Business Plan, and I have agreed to be the CEO/President of

the company for at least the next five years.

NAB Today:

Parameters for New Company

Here are the parameters in which I must work.

 The business is a start-up: We are not yet in operation. We already have a “recipe” for a

beverage, but we are not yet making sales at any significant level.

 Product: the only barrier is that it must be a non-alcoholic beverage (NAB). It is up to me

to decide upon what type of non-alcoholic beverage I intend to make and market. It can

be sold in individual sizes or wholesale.

 Market size. I will start marketing and selling the NAB in my geographical area within a

100 mile radius from my home address.

 Business size. I can grow the NAB business to any size in excess of one million dollars in

revenue by year two. In other words, this cannot be intended to be a one- or two-person

micro-business.

 I intend to raise money. I will be looking for funding, and I have already started with

friends and family money. But at some point I will need funds from outside investors,

either angels or venture capitalists, depending on how much I project I need to raise or

receive from a group of individual investors on kickstarter.

 I intend to have employees and develop my own organizational hierarchy.

NON-ALCOHOLIC BEVERAGE COMPANY PORTFOLIO

 I do not need to raise money for my personal financial support for the first six months. In

other words, I do not need to take a salary/draw for myself for six months of projections.

I am assuming I can live off my personal savings.

NON-ALCOHOLIC BEVERAGE COMPANY PORTFOLIO

Note #3

Personnel:

Myself: I have collected $20,000 from friends and relatives who would like to either have their

seed money returned by the end of this calendar year at no interest or by the end of the second

year of operation with 5% interest.

Stephen Job: Part Time (20 hrs/week) Computer Expert/Assistant: $10/hr

Melinda Cates: NAB Creator & Master Mixer (owns the patent on the NAB): has $40,000

inheritance

Other colleagues with specific skills and talents:

Ian Glass: retired PepsiCo plant production line foreman. Ian recently retired with 35 years of

loyal PepsiCo service in every position from janitor to production line foreman, and he and his

wife moved into your neighborhood. He is tickled that you have asked him to help develop a

plan to get the NAB Company’s production line going. He said he can help organize and sit on

the planning committee as a non-paid member until the NAB company can hire its own

Production Line Foreman. He hinted that he retired from PepsiCo with an annual salary of

$55,000, but he says that’s just the starting salary that large companies pay their foremen who

are in an apprenticeship program. He doesn’t think the NAB Company will have to pay top

dollar for someone who has the willingness to join the NAB company as a start up!

Mary Cates, JD: Melinda’s sister who was a senior executive with the Federal Trade

Commission from 2001-2012. She left the FTC after a significant 30 year career with the federal

government in which she lead the research and support of numerous federal court findings

against companies that violated consumer deception and unfair practices laws. She would enjoy

serving on the initial company planning group to make sure her sister’s recipe is successfully

shared within the state!