Out of the Box

Page 1


The Team

Ashley Himpel FASM

Pauline Sheets Fibers

Nicole Cummings FASM

Gillian Ware FASM

Nina Monlia FASM


Our Solution Overview Out of the Box Austin, Texas We are an on demand meal kit service. This means no subscriptions, no waiting and no commitments. We also offer customizable solutions where you can pick the number of servings to most accurately meet the needs of your family. Stop by or drive-thru today

Non-Subscription Based

Customizable Portions

Locally Sourced by Farmers


Design Challenge


Physical Fights Back At the start of this quarter we were given a business design challenge. This challenge was based on looking into different industries and trends. For the past five years, design services have been dictated and limited by the touch-points that were available to us via PC, mobile and analog. The future of service design is about blending physical and digital and various design specialists are responding. Our design challenge was to find an oer or experience that is currently delivered primarily via digital, and develop a competing product or service that enhances the digital with the physical in order to augment the value for consumers. After receiving this challenge we closely examined different industries in search of potential business opportunities and came up with three possible industries to focus on.


Initial Opportunity Considered

Fitness Industry Rise in consumers focusing on health and wellness. Consumers wanting to incorporate fitness in their everyday lives. Example of current trend: FabFit

Social Networking Industry

Food & Beverages Industry

Businesses are already experimenting with service centers to help connect people together.

Always room for new businesses

People are always looking for jobs and looking to network.

Shift of focus on food and health

Example of current trend: Linkdin

Growing Market

Example of current trend: Meal Kits


INSIGHTS: The only room we saw within the fitness industry was in the retail industry such as a FabFit brick and mortar. One stipulation of this challenge was no retail so that got vetoed. Although social networking in real life would be interesting, we did not see how any solution we developed would be different from working with coops or job placement centers and these already exist. Within the food and beverage industry, there are many digital solutions currently such as meal kits, online grocery shopping, and UberEats. Many of these services have remained either very digital or physical. Not many companies apart from Amazon and Whole Foods have started to integrate both the digital and the physical. With that being said, our team thought it would be a perfect opportunity to explore the food and beverage industry further.


Industry Chosen Our group was very focused as soon as we settled on the food and beverages industry on the idea of online meal kit services such as HelloFresh and Blue Apron. People order kits online through a subscription based program and ingredients are sent to their home. We quickly noticed these companies were trying to get customers through signing up for discounts. This led us to believe that customers did not see enough value in this solution alone. We saw this as window and begun to deeper explore the industry to see how this solution was not meeting customer needs.


INSIGHTS: We decided to focus on the food and beverage industry. Meal kits are a trending matter, and we noticed there were a lot of problems that needed a solution. This raised questions as to why people are turning away from meal kits only after a few months. Rise of the grocery industry and delivery meal services


Industry Focus


INSIGHTS: There is a gap here because services are making money. Customers are finding some value but not enough to stay. Uber Eats is a trusted brand that people recognize and the service is very convenient. It is close to pizza delivery with more options where you can decide on the time you want dinner.


INSIGHTS: After having our point proven that the customer retention rates of meal kits was low, we took a look to see how sustainable the two trends were that made meal kits appealing. This includes health and wellness, on-the-go lifestyles, as well as the food and beverage industry.


INSIGHTS: Consumers are invested in health and wellness. The global nutrition market takes up almost half of the population. These trends indicate that consumers are already interested in changing their behaviors and looking for solutions.


Major Forces


Regulatory Trends:

Macro-Economic Forces:

Governments are implementing more regulations on consumer goods. Some countries have begun to raise taxes on unhealthy foods and drinks.

• Unemployment rate is 4.1% • GDP has expanded 2.7% in 2018 • 1.5 million employees in the food and beverages industry • Demand for natural resources is likely to pick up with economic recovery.

Key Trends:

Social & Cultural- Changing customer preferences.

Technology- Amazon droids are delivering packages directly to their doorstep.

On-the-go.

Whole Foods and Amazon partnered up and they now serve kiosks to store your food, while you order your meals for online pick-up.

Customers emphasizing sustainability and gravitating towards brands they share the same value with. Convenient packaging.

Health and wellness.


Need/Problem After researching the issues and trends within the food and beverage industry that the population has identified with, our team discovered that people are currently looking for convenient, healthy, in-home meal options. However, this is not the true core of the problem. The true problem is that the solutions that exist in the market are not meeting customer needs. Only 12% of meal kit subscribers stay with that specific company, and 66% of meal kit users are overall very satisfied with the solution.


Customer Reviews

INSIGHTS: The major insights customer Reviews gave us was that people liked meal kits but the issues they had with the existing form of the solution was too much packaging, especially from kits having to be transported via mail and kept fresh. There is not enough variety of meals and they didn’t like being locked into a subscription program. The major issues are that people are very cautious of waste, not only of the food they didn’t finish, but the abundance of ice packs which have no direction as to properly dispose.


Potential Problems/Buying Obstacles


Cost per serving

$9.99

$9.99

$11.95

$25+

Nut-free options? Vegan options? Dairy-free options? Average calories per meal

687 cal

780 cal

704 cal

608 cal

Average prep+ cook time

35 min

40 min

40 min

55 min

INSIGHTS: To compare competition side by side, we created this chart. The insights gained from this were these current options don’t offer a lot of room for people who have special eating needs. Most meal kit services are recognizing that people find value in speedy solutions.


Competitive Analysis DIRECT COMPETITION Hello Fresh Blue Apron Plated Peach Dish Amazon x Whole INDIRECT COMPETITION UberEats Whole Foods hot line Frozen Dinners Local Restaurants


INSIGHTS: • When people say something is too expensive, what they are really saying is they aren’t getting enough value for the price. Clearly the issues aren’t that people do not like the food, or the amount of time it takes to cook, nor is it the amount of food. • People are more likely to pay for solutions that are instantly gratifying such as pizza for example. • The question we had to address was, ‘Can we make a meal kit option that is just as convenient? Will this add enough value to make our solution more desired?’


Potential Customer Segments

Dual Income Families

Young Professionals

Both parents workThey divide responsibilities

On-the-go

Run out of dinner ideas for their kids and themselves

Not educated or motivated to cook

Wants to instill good health practices in their children

Prefers take-out

College Students Recently moved from home Limited time or experience Interested in healthy eating but not a major priority


INSIGHTS: Dual families are the most financially liquid Family options for meal kits don’t serve more than three to four people

Single Parent Difficult juggling kids, work, and cooking Aim to find healthier options for the kids and themselves, but kids are picky Not a lot of spare time or extra income

Retirees Not as mobilephysically Potential widowed spouse Needs easy meals to prepare that take limited time

College students don’t have enough money to spend on meal kits Young professionals like meal kits because they are easy to use with their busy schedules Retirees have a harder time accessing meal kits


Target Market

Dual Income Families +35

INSIGHTS:

Single Parents +35

• Half of consumers are willing to spend from 30 minutes to an hour on cooking. • 53% are 35 years old and above, which is within our target market. • 26% of them cook because it’s a healthier option versus eating out. • Dual income families have more time to spend on cooking.


INSIGHTS: • Millennial and Generation X make up the majority of the digital meal order and delivery services at 46% and 42%. • These two segments are who we are trying to reach. • Targeting newer and younger families with small children. • These consumers are more likely to purchase a meal kit and use meal delivery services.


Elements of a Solution

Located near grocery store

Customizable Portions

Sustainable and Ethical Practices

Stable Retention Rate

Set Menu & Variety of Foods

30 min-1 hour cook time


Value Proposition

Create a unique experience that significantly raises the customer retention rate. We plan to do this by eliminating subscription services which allows customers to get a meal kit at the last minute. We plan on implementing technology by creating a mobile app and having a website that makes it easy to order meal kits and connect with customers and creating a cost effective solution to the pricing of meal kits.


MODEL #1

• Chef ’s • Nutritionists/ Health Experts • Vendors

• Workshops where parents can learn cooking skills • Operation of store front • Partnering with vendors for produce

• Money • App

• Costs associated with operations, the physical location, employees and equipment

• Personalized family cooking classes taught by chef ’s and health experts • Offering the ability to pick up that day of and not have to wait for it to be delivered

• Develop a personal relationship with on site nutritionists and

• Social Media: Facebook • Blogs • Advertisements • App

• Cooking classes • Meal kits available on site • Ordering meal kit via app

• • • •

20-40 Families Single Parents Cooking to bond with their children • Practice good healthy eating habits


INSIGHTS/ANALYSIS: • Started with wanting to provide meal kits along with offering cooking classes, and onsite nutritionists. • Instead of delivery services like our competitors, we wanted to offer same-day pick up. • Targeting an age between 20-40 • We wanted our customers to have a personal relationship with the trainers and nutritionists so they feel their healthiest.


MODEL #2

• Meal Kit Companies • Grocery Stores

• Connecting meal kit company with customers

• Relationships with meal kit companies • Relationships with grocery stores

• Buying Kiosks

• Ability to pick and choose meals that work for you • • Convenience of grocery store

• B to C relationship

• Dual-Income Families • Single Parent • Young Professionals • Married couples-no kids

• Web Presence • Physical Kiosk • Mail Distribution

• Cut of profit from transaction • Kiosk rental (grocery store) • Training for grocery store employees


INSIGHTS/ANALYSIS: • We wanted to break away from partnering with meal kits, and focus on being our own, independent company. • We wanted to partner with a grocery store and offer our own service. • The thought process behind this idea was to put a kiosk in the grocery store, where customers can pick it up at their convenience.


Final Business Model

• Local Farmers • Eco-Friendly and sustainable company for packaging • Investors • Transportation service

• • • •

Sourcing Recipes Package Design Platform Sourcing ingredients • Interactions with the customers

• Renting a physical space • Employees • Financial resources • Brand resources

• • • •

Rent Utilities Purchasing bags Buying food

• • • •

Building platforms Employees/Training Appliances/Equipment Marketing

• Not subscription based • Customized meal kits • Sustainable and ethically sourced products • On demand meal kits

• Business to consumer • Co-Creation with consumers • Reliable and convenient services

• Physical store • App • Online web channel

• Meal-Kit Sales • In store • Online • Re-usable grocery bags and box

• Families-persons between 3 or 5 • Single Parents


INSIGHTS/ANALYSIS: • Partnering with a local grocery store in Austin, Texas. • Making sure that we aren’t going to be a subscription based company • It is easier for people to pick up their food, and it gives them the option to even go in. • We want to make sure the meal are customizable that gives bigger and smaller families more options. • We are giving our customers options to either order online or through our app, and to come in our physical location.


Customer Profiles


Adam 40 Single Contractor/Flips Houses $100,000 income Resides in Texas Enjoys outdoor activities Baseball fan 2 picky daughters, Megan, 6 and Sarah, 9. Struggles to find time to meal prep.

Michelle, 38 Nurse $60,000 income

Tony, 42 Tech Entrepreneur $75,000 income

Michelle and Tony work 40+ hours per week. They each take turns cooking/preparing dinner. Kids have extra-curricular activities. Healthy eating is important to the family.


Customer Empathy Map Dual Family THINK/FEEL:

SEE

• Worried that their kids aren’t getting enough healthy options. • Overwhelmed with busy work schedules.

• Their friends are able to provide for their kids. • They need to start teaching their kids how to eat healthy. • They see their kids not getting the nutrition that they need.

SAY AND DO

HEAR

• They say they’re going to start making an effort to meal prep more. • They say they’re going to provide healthier meals. • They start a meal kit service, but don’t still with it due to pricing and time consumption.

• They hear their friends and influencer’s talk about meal kits. • They hear their friends talk about meal prepping and planning ever Sunday. • They hear their kids complain about meals being boring and repetitive.


PAINS:

GAINS:

Stressed that they don’t have enough time to meal plan throughout the week, and are tired of the same go to recipes.

Able to teach kids how to cook healthy and easy meals.

Kids are picky, and always complaining about the repetition. Other families are able to find time To cook.

They get to have fun together picking out what to eat for the week. They get to have leftovers, and new recipe ideas.

INSIGHTS: • After breaking down the dual income family even more, we feel that they are the right segment for us. • We can see that they’re struggling to find time to provide healthy and nutritional meals for their family due to a busy work schedule. • They’re in need of a quick and easy healthy meal for the week that works well for everyone.


Single Dad THINK/FEEL

SEE

• Limited time • Workaholic but wants more time with kids • Feels pressure to provide healthy foods • Overwhelmed and stressed • Wants to teach kids healthy eating practices

• Sees friends occasionally • Dad is busy working long hours • Other parents are more health conscious • Daughters are growing up fast and need nutritional value

SAY AND DO

HEAR

• Doesn’t like grocery shopping • Not the best cook • Dad is active and likes to take his daughters to do outdoor activities

• Friends are pressuring him about being more health conscious • “But we just had that for dinner last night” -daughters


PAINS:

GAINS:

Stressed about being single parent.

Learns how to prepare meals that are healthy and tasty.

Frustrated because there is a lack Of knowledge when cooking. Running out of dinner ideas.

Leftovers Able to give daughters a healthy lifestyle.

INSIGHTS: • A single dad is certainly in need of an easier way to provide his children healthy and nutritional meals. • He doesn’t have time to plan each meal, and go out to find something. Ordering and picking up the meals kits for the week would be most beneficial. • He’s wanting more time with kids, and the meal kits can be an exciting way to have those 30 minutes together cooking.


Percentage of U.S. Households Purchasing Organic Products 89% 88%

92% 85%

86% 79%

91% 88%

83% 78%

71%

75% 90%

80% 89%

82%

78%

69% 90%

85%

78% 79%

90%

79%

76%

78%

75% 83%

72%

83%

71%

75% 85%

82%

National Average:

73% 82%

Data not available for AK + HI

82%

74%

73% 70%

87%

85% 88% 87%

77%

78% 90%

80%

82%

Source: Nielsen UPC Scan Data of 100,000 households, 2016 Learn More: OTA.com


AUSTIN, TEXAS

• • • • • •

Strongest metropolitan economy in the nation Diversified economy One of the leading exports of agricultural commodities Known for sustainable living advocates High-tech, consumer driven environment 87% of the state purchases organic products


Travis

Age 0--9 Population Concentrations Austin, Texas

Census 2010 Data

Percentage of Total Population Age 0 to 9 Less than 2.5% 2.5% to 5% 5% to 10% 10% to 15% 15% Plus

1 V U

35 § ¨ ¦

183 £ ¤

Williamson County

Lake Travis 360 U V 1 V U

Georgetown 35 § ¨ ¦

290 £ ¤

U V 360

Leander 1 V U

Taylor

183 £ ¤

Travis County 35 § ¨ ¦

U V

Round Rock

Decker Lake

130 U V

360

Cedar Park 290 £ ¤

Map produced by Ryan Robinson, City Demographer, Department of Planning, City of Austin. July 2011.

183 £ ¤

71 V U 1 V U

Pflugerville Lake Travis

71 V U

V U 45

Manor

Lakeway

Travis

35 § ¨ ¦

Inset: central metropolitan Austin West Lake Hills

Del Valle

Hays County

Bastrop County

Dripping Springs

Age 10--17 Population Concentrations

130 U V

Median Family Income, by tract

Austin, Texas

Census 2010 Data

No Households Less than $20,000

Bastrop

$20,000 to $30,000 Smithville

Percentage of Total Population Age 10 to 17

$30,000 to $40,000 $40,000 to $50,000

San Marcos

Lockhart

Caldwell County

Rosanky

Austin--

Round Rock MSA, 2015

Data source: American Community Survey, 2011--15 5-year composite dataset, Table B19113, census tracts. US Census Bureau. Map produced by Ryan Robinson, City Demographer, Department of Planning, City of Austin. August 2017.

Less than 2.5% 2.5% to 5% 5% to 10% 10% to 15% 15% Plus

$50,000 to $60,000 $60,000 to $75,000 $75,000 to $100,000 $100,000 to $125,000 $125,000 to $150,000 $150,000 Plus Map produced by Ryan Robinson, City Demographer, Department of Planning, City of Austin. July 2011.


Age 25--34 Population Concentrations Austin, Texas

Census 2010 Data

Percentage of Total Population Age 25 to 34 Less than 2.5% 2.5% to 5% 5% to 10% 10% to 15% 15% Plus

Map produced by Ryan Robinson, City Demographer, Department of Planning, City of Austin. July 2011.

Age 35--44 Population Concentrations Austin, Texas

Census 2010 Data

Percentage of Total Population Age 35 to 44 Less than 2.5% 2.5% to 5% 5% to 10% 10% to 15% 15% Plus

Map produced by Ryan Robinson, City Demographer, Department of Planning, City of Austin. July 2011.

INSIGHTS: After settling on Austin, Texas, we understood that we wanted to have a physical location. We had to decide what neighborhood would be best to start out in. In doing so, we looked at demographic population distributions based on age and income in Northern Texas. On the next page you can see where we applied statistics about how many people would purchase meal kits in six months and how many have already purchased meal kits in order to better understand the sizing of those areas. We also expect to get traffic from other neighborhoods as they drive home from work.


Preliminary Sizing Northern Austin 5,323 Families Georgian Acres: 1,141 North Austin: 3,371 North Lamer: 880 Heritage Hills: 811 479 purchased meal kit 1330 would within 6 months Families Averaging 16 servings per week



Customer Segments Key Resources • Our resources will be through our physical space. We are relying on our space to work, and bring in revenue. • We are counting on our employees to execute our solution well. We made sure they were trained and educated highly.

• After primary research into our target market, we narrowed it down into two segments. • We found that families of 3 or 5 would be ideal for our service, along with single parents who struggle even more to find time to cook.

Customer Relationships • We want to make sure build a relationship with our customer that gives them trust. • We want to make sure were the easy reliable source to go in need of a quick meal for the family.


Value Propositions • After doing primary research, and conducting surveys, we realized their was a low retention rate due to being locked into subscriptions. We want to be a non subscription based company. • We also saw complaints of meal kits not being customizable, because these families can vary from larger to smaller appetites. • We want to make sure our services are on demand, an easily accessible.

Channels • After doing primary research we figured that along with our physical store, customers can easily access our service digitally. • Customers can order ahead online or through our app and pick it up in store, or through our drive thru services. • Create mobile app that allows customers to order their meal kits ahead of time, put their customizable order in and have access to be more connected with our company.


Key Partners Suppliers & Vendors Farm to Table Local vendor that allows consumers to get the foods when they’re at it’s freshest. Fruits, vegetables, cage-free eggs, herbs, cheese, and pork all raised without hormones or antibiotics. Distributes locally grown farm products to restaurants, commercial kitchens, cafeterias, and independent grocery stores. Farm to Table practices sustainability and the farmers have various means to use non-renewable resources. Paper Mart Sustainable company Internet based out of the United States Recyclable

Distributes over 26,000 products


Cost Structure

• We took a good look at our costs, and what we will be needing to pay frequently. • We know that we will need to pay for rent and utilities, along with having to pay our employees, along with making sure their getting the best training. • We want to make sure we have the right marketing tactics, along with the correct appliances and equipments. • We need to make sure our food is bought in time to be at its freshest for our consumers.

Revenue Streams • We will be collecting our revenue through our services in-store, and online. • We will be selling re-usable grocery bags to reduce waste, and to give our customers their own shopping bag.


Financial

In the beginning we started with a slow growth. In our “conservative scenario we grew to 5% of our target market buying one meal kit a week by September of the first year. By the next September, 9% are expected to buy one meal kit a week and by September year three, we are selling one meal kit a week to 20% of households. In our “aggressive” scenario, we had reached 9% of families in our area by September year one, 24% by September of year two and 33% by year three. All of our numbers are based on each family in these present ages buying on meal kit a week to account for some of them buying more frequently. We expect September to be a spike for us each year due to school starting and families getting busier.


Out of the Box

Twelve Month

PROFIT & LOSS PROJECTION

FISCAL YEAR BEGINS:

JAN-18

FEB-18

MEAL KIT SALES

$ 12,000

$ 18,000

$

TOTAL SALES

$ 12,000

$ 18,000

$

REVENUES (SALES)

MAR-18

SEP-18

OCT-18

NOV-18

DEC-18

YEARLY

IND %

JAN % FEB % MAR % APR % MAY % JUN % JUL % AUG %

SEP %

OCT %

NOV %

APR-18

MAY-18

JUN-18

JUL-18

AUG-18

24,000

$ 30,000

$ 42,000

$ 51,840

$ 51,840

$ 54,000

$

72,000

$

66,000

$ 66,000

$

66,000

$

553,680

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

24,000

$ 30,000

$ 42,000

$ 51,840

$ 51,840

$ 54,000

$

72,000

$

66,000

$ 66,000

$

66,000

$

553,680

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

YEAR %

Out of the Box

PROFIT & LOSS PROJECTION JAN-18

FISCAL YEAR :

FEB-18

MAR-18

APR-18

MAY-18

JUN-18

JUL-18

AUG-18

SEP-18

OCT-18

NOV-18

DEC-18

YEARLY

IND %

JAN

JAN % FEB % MAR % APR % MAY % JUN % JUL % AUG % SEP % OCT % NOV % DEC %

2018 YEAR %

TREND

Meal Kits Supplies (not in COGS)

$

7,560

$

116

TOTAL COST OF SALES

$

7,676

Gross Profit

$

4,324

$ 11,340

$ 15,120

$

18,900

$

26,460

$

$

-

$

-

$

116

$ 11,340

$ 15,120

$

18,900

$

$ 6,660

$ 8,880

$

11,100

$

-

$ 32,400

$

32,400

$

34,020

$

-

$

-

$

-

26,576

$ 32,400

$

32,400

$

34,020

15,424

$ 19,440

$

19,440

$

19,980

$ 45,360

$ 41,580

$

41,580

$

$

-

$

-

$ 45,476

$ 41,580

$

$ 26,524

$ 24,420

$

116

$ 41,580

$

348,300

50%

98%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

$

-

$

348

50%

2%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

41,580

$ 41,580

$

348,648

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

100%

24,420

$ 24,420

$

205,032

2%

3%

4%

5%

8%

9%

9%

10%

13%

12%

12%

12%

Out of the Box

Twelve Month

PROFIT & LOSS PROJECTION JAN-18

EXPENSES

DEC %

2018

TREND

Twelve Month

COST OF SALES

JAN

FISCAL YEAR : FEB-18

MAR-18

APR-18

MAY-18

JUN-18

JUL-18

AUG-18

SEP-18

OCT-18

NOV-18

DEC-18

YEARLY

IND %

JAN

JAN % FEB % MAR % APR % MAY % JUN % JUL % AUG % SEP % OCT % NOV % DEC %

2018 YEAR %

TREND

Column2

Advertising

$

1,000

$

1,000

$

Contract labor Insurance (other than health)

$

7,500

$

30

Office expense

$

Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance

$

-

$

30

880

$

-

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

3,375

$

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

1,700

$

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

100

$

Taxes and licenses

$

1,010

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

Utilities Wages (less emp. credits)

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

3,125

$

37,500

2%

12%

19%

19%

19%

19%

19%

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

6,886

$

82,632

15%

26%

42%

42%

42%

42%

42%

Website

$

1,152

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

1,152

7%

4%

0%

0%

0%

0%

0%

TOTAL EXPENSES

$

26,758

$

16,216

$ 16,476

$

16,216

$

16,476

$

16,216

$

16,476

$

16,216

$

16,476

$

16,216

$

16,476

$

16,216

$

206,434

100%

100%

100%

100%

100%

100%

100%

Net Profit

$

(1,052) $

3,224

$

2,964

$

3,764

$

10,048

$

8,204

$

7,944

$

8,204

$

(22,434) $

1,000

$

$

-

$

30

$

260

(9,556) $

1,000

$

$

-

$

-

$

-

$

30

$

30

$

30

$

-

$

260

$

-

$

(7,596) $

(5,116) $

1,000

$

1,000

$

1,000

$

1,000

$

1,000

$

1,000

$

1,000

$

1,000

$

12,000

14%

4%

$

-

$

-

$

-

$

-

$

-

$

$

30

$

30

$

30

$

30

$

30

$

260

$

-

$

260

$

-

$

260

$

-

-

$

7,500

11%

28%

0%

0%

0%

30

$

360

4%

0%

0%

0%

0%

$

2,180

4%

3%

0%

2%

0%

2%

40,500

17%

13%

21%

20%

21%

20%

21%

20%

21%

20%

21%

20,400

14%

6%

10%

10%

10%

10%

10%

10%

10%

10%

10%

1,200

10%

0%

1%

1%

1%

1%

1%

1%

1%

1%

1%

1%

1%

1%

1,010

2%

4%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

19%

19%

19%

19%

19%

19%

18%

42%

42%

42%

42%

42%

42%

40%

0%

0%

0%

0%

0%

0%

1%

100%

100%

100%

100%

100%

100%

100%

(1,402)

#####

6%

682%

6%

542%

6%

365%

6%

6%

6%

6%

6%

6%

6%

6%

6%

0%

0%

0%

0%

0%

0%

0%

0%

4%

0%

0%

0%

0%

0%

0%

0%

0%

0%

0%

2%

0%

2%

0%

2%

0%

1%

20%

21%

20%

10%

10%

10%

75%

-230%

-211%

-268%

-717%

-585%

-567%

-585%

100%

100%

100%


Small Business Cash Flow Projection Out of the Box: FIRST YEAR

Starting date Cash balance alert minimum Cash on hand (beginning of month) CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

Jan-18

Beginning

$50,000

50,000

50,000

Jan-18

$50,000

Feb-18

$27,566

Mar-18

$18,010

Apr-18

$10,414

May-18

$5,298

Jun-18

$4,246

Jul-18

$7,470

Aug-18

$10,434

Sep-18

$14,198

Oct-18

$24,246

Nov-18

$32,450

Dec-18

$40,394

12,000

18,000

24,000

30,000

42,000

51,840

51,840

54,000

72,000

66,000

66,000

66,000

12,000 62,000

18,000 45,566

24,000 42,010

30,000 40,414

42,000 47,298

51,840 56,086

51,840 59,310

54,000 64,434

72,000 86,198

66,000 90,246

66,000 98,450

66,000 106,394

1,000 7,500 30 7,560 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 34,434

1,000 0 30 11,340 0 3,375 1,700 100

1,000 0 30 15,120 260 3,375 1,700 100

1,000 0 30 18,900 0 3,375 1,700 100

1,000 0 30 32,400 0 3,375 1,700 100

1,000 0 30 32,400 260 3,375 1,700 100

1,000 0 30 34,020 0 3,375 1,700 100

1,000 0 30 41,580 260 3,375 1,700 100

1,000 0 30 41,580 0 3,375 1,700 100

0 3,125.00 6,886 0 31,596

0 3,125.00 6,886 0 35,116

0 3,125.00 6,886 0 48,616

0 3,125.00 6,886 0 48,876

0 3,125.00 6,886 0 50,236

1,000 0 30 45,360 260 3,375 1,700 100 116 0 3,125.00 6,886 0 61,952

1,000 0 30 41,580 0 3,375 1,700 100

0 3,125.00 6,886 0 27,556

1,000 0 30 26,460 260 3,375 1,700 100 116 0 3,125.00 6,886 0 43,052

0 3,125.00 6,886 0 57,796

0 3,125.00 6,886 0 58,056

0 3,125.00 6,886 0 57,796

0 27,566

0 18,010

0 10,414

0 5,298

0 4,246

0 7,470

0 10,434

0 14,198

0 24,246

0 32,450

0 40,394

0 48,598

Total

294,726

553,680 0 0 0 0 0 553,680

12,000 7,500 360 348,300 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 555,082 0 0 0 0 555,082


Small Business Cash Flow Projection Out of the Box: FIRST YEAR Base-Line

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$50,000

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

50,000

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

50,000

kits price to build customer cost build per month sales per month

Jan-18

$50,000

Feb-18

$28,454

Mar-18

$19,342

Apr-18

$11,746

May-18

$6,186

Jun-18

$2,026

Jul-18

$18

Aug-18

$26

Sep-18

$2,707

Oct-18

$7,427

Nov-18

$12,523

Dec-18

$15,583

14,400

19,200

24,000

28,800

33,600

38,400

43,200

51,072

57,600

57,600

52,800

52,800

14,400 64,400

19,200 47,654

24,000 43,342

28,800 40,546

33,600 39,786

38,400 40,426

500 43,700 43,718

51,072 51,098

57,600 60,307

57,600 65,027

52,800 65,323

52,800 68,383

1,000 7,500 30 9,072 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 35,946

1,000 0 30 12,096 0 3,375 1,700 100

1,000 0 30 15,120 260 3,375 1,700 100

1,000 0 30 18,144 0 3,375 1,700 100

1,000 0 30 24,192 0 3,375 1,700 100

1,000 0 30 27,216 260 3,375 1,700 100

1,000 0 30 32,175 0 3,375 1,700 100

1,000 0 30 33,264 260 3,375 1,700 100

1,000 0 30 33,264 0 3,375 1,700 100

0 3,125.00 6,886 0 31,596

0 3,125.00 6,886 0 34,360

0 3,125.00 6,886 0 40,408

0 3,125.00 6,886 0 43,692

0 3,125.00 6,886 0 48,391

1,000 0 30 36,288 260 3,375 1,700 100 116 0 3,125.00 6,886 0 52,880

1,000 0 30 36,288 0 3,375 1,700 100

0 3,125.00 6,886 0 28,312

1,000 0 30 21,168 260 3,375 1,700 100 116 0 3,125.00 6,886 0 37,760

0 3,125.00 6,886 0 52,504

0 3,125.00 6,886 0 49,740

0 3,125.00 6,886 0 49,480

0 28,454

0 19,342

0 11,746

0 6,186

0 2,026

0 18

0 26

0 2,707

0 7,427

0 12,523

0 15,583

0 18,903

300 30.24 48 9072 14400

400 30.24 48 12096 19200

500 30.24 48 15120 24000

600 30.24 48 18144 28800

700 30.24 48 21168 33600

800 30.24 48 24192 38400

900 30.24 48 27216 43200

1064 30.24 48 32175.36 51072

1200 30.24 48 36288 57600

1200 30.24 48 36288 57600

1100 30.24 48 33264 52800

1100 30.24 48 33264 52800

#NAME?

Total

206,037

473,472 0 0 0 0 500 473,972

12,000 7,500 360 298,287 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 505,069 0 0 0 0 505,069


Small Business Cash Flow Projection Out of the Box: FIRST YEAR CONSERVATIVE

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$50,000

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

50,000

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

50,000

kits price to build customer cost build per month sales per month

Jan-18

$50,000

Feb-18

$28,454

Mar-18

$19,342

Apr-18

$11,746

May-18

$6,186

Jun-18

$2,026

Jul-18

$18

Aug-18

$26

Sep-18

$2,707

Oct-18

$7,427

Nov-18

$12,523

Dec-18

$15,583

14,400

19,200

24,000

28,800

33,600

38,400

43,200

51,072

57,600

57,600

52,800

52,800

14,400 64,400

19,200 47,654

24,000 43,342

28,800 40,546

33,600 39,786

38,400 40,426

500 43,700 43,718

51,072 51,098

57,600 60,307

57,600 65,027

52,800 65,323

52,800 68,383

1,000 7,500 30 9,072 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 35,946

1,000 0 30 12,096 0 3,375 1,700 100

1,000 0 30 15,120 260 3,375 1,700 100

1,000 0 30 18,144 0 3,375 1,700 100

1,000 0 30 24,192 0 3,375 1,700 100

1,000 0 30 27,216 260 3,375 1,700 100

1,000 0 30 32,175 0 3,375 1,700 100

1,000 0 30 33,264 260 3,375 1,700 100

1,000 0 30 33,264 0 3,375 1,700 100

0 3,125.00 6,886 0 31,596

0 3,125.00 6,886 0 34,360

0 3,125.00 6,886 0 40,408

0 3,125.00 6,886 0 43,692

0 3,125.00 6,886 0 48,391

1,000 0 30 36,288 260 3,375 1,700 100 116 0 3,125.00 6,886 0 52,880

1,000 0 30 36,288 0 3,375 1,700 100

0 3,125.00 6,886 0 28,312

1,000 0 30 21,168 260 3,375 1,700 100 116 0 3,125.00 6,886 0 37,760

0 3,125.00 6,886 0 52,504

0 3,125.00 6,886 0 49,740

0 3,125.00 6,886 0 49,480

0 28,454

0 19,342

0 11,746

0 6,186

0 2,026

0 18

0 26

0 2,707

0 7,427

0 12,523

0 15,583

0 18,903

300 30.24 48 9072 14400

400 30.24 48 12096 19200

500 30.24 48 15120 24000

600 30.24 48 18144 28800

700 30.24 48 21168 33600

800 30.24 48 24192 38400

900 30.24 48 27216 43200

1064 30.24 48 32175.36 51072

1200 30.24 48 36288 57600

1200 30.24 48 36288 57600

1100 30.24 48 33264 52800

1100 30.24 48 33264 52800

#NAME?

Total

206,037

473,472 0 0 0 0 500 473,972

12,000 7,500 360 298,287 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 505,069 0 0 0 0 505,069


Small Business Cash Flow Projection Out of the Box: FIRST YEAR AGGRESSIVE

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$50,000

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

50,000

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

50,000

kits price to build customer cost build per month sales per month

Jan-18

$50,000

Feb-18

$28,738

Mar-18

$21,686

Apr-18

$17,926

May-18

$17,979

Jun-18

$21,207

Jul-18

$28,363

Aug-18

$38,811

Sep-18

$53,071

Oct-18

$70,507

Nov-18

$84,768

Dec-18

$96,992

15,168

24,768

34,368

43,968

53,568

63,168

72,768

82,368

91,968

82,368

77,568

77,568

15,168 65,168

24,768 53,506

34,368 56,054

43,968 61,894

53,568 71,547

63,168 84,375

72,768 101,131

82,368 121,179

91,968 145,039

82,368 152,875

77,568 162,336

77,568 174,560

1,000 7,500 30 9,556 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 36,430

1,000 0 30 15,604 0 3,375 1,700 100

1,000 0 30 21,652 260 3,375 1,700 100

1,000 0 30 27,700 0 3,375 1,700 100

1,000 0 30 39,796 0 3,375 1,700 100

1,000 0 30 45,844 260 3,375 1,700 100

1,000 0 30 51,892 0 3,375 1,700 100

1,000 0 30 48,868 260 3,375 1,700 100

1,000 0 30 48,868 0 3,375 1,700 100

0 3,125.00 6,886 0 38,128

0 3,125.00 6,886 0 43,916

0 3,125.00 6,886 0 56,012

0 3,125.00 6,886 0 62,320

0 3,125.00 6,886 0 68,108

1,000 0 30 57,940 260 3,375 1,700 100 116 0 3,125.00 6,886 0 74,532

1,000 0 30 51,892 0 3,375 1,700 100

0 3,125.00 6,886 0 31,820

1,000 0 30 33,748 260 3,375 1,700 100 116 0 3,125.00 6,886 0 50,340

0 3,125.00 6,886 0 68,108

0 3,125.00 6,886 0 65,344

0 3,125.00 6,886 0 65,084

0 28,738

0 21,686

0 17,926

0 17,979

0 21,207

0 28,363

0 38,811

0 53,071

0 70,507

0 84,768

0 96,992

0 109,476

316 30.24 48 9555.84 15168

516 30.24 48 15603.84 24768

716 30.24 48 21651.84 34368

916 30.24 48 27699.84 43968

1116 30.24 48 33747.84 53568

1316 30.24 48 39795.84 63168

1516 30.24 48 45843.84 72768

1716 30.24 48 51891.84 82368

1916 30.24 48 57939.84 91968

1716 30.24 48 51891.84 82368

1616 30.24 48 48867.84 77568

1616 30.24 48 48867.84 77568

#NAME?


Starting date Cash balance alert minimum Cash on hand (beginning of month) CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) App and Website Createscape (monthly fee) SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

Small Business Cash Flow Projection Out of the Box: SECOND YEAR BASELINE Jan-19

Beginning

40,394

40,394

Jan-19

40,394

42,918

Mar-19

44,922

Apr-19

46,666

May-19

48,554

Jun-19

50,182

Jul-19

52,186

Aug-19

54,190

Sep-19

65,142

Oct-19

76,470

Nov-19

84,430

Dec-19

92,650

92,400

84,000

84,000

84,000

84,000

84,000

84,000

109,200

109,200

100,800

100,800

100,800

92,400 132,794

84,000 126,918

84,000 128,922

84,000 130,666

84,000 132,554

84,000 134,182

84,000 136,186

109,200 163,390

109,200 174,342

100,800 177,270

100,800 185,230

100,800 193,450

Jan-19

1,000 0 30 58,212 260 3,375 0 100 116 1,060 3,125.00 21,286 1,152 160 89,876

40,394

Feb-19

89,876 42,918

Feb-19

1,000 0 30 52,920 0 3,375 0 100 0 0 3,125.00 21,286 0 160 81,996

81,996 44,922

Mar-19

1,000 0 30 52,920 260 3,375 0 100 0 0 3,125.00 21,286 0 160 82,256

82,256 46,666

Apr-19

1,000 0 30 52,920 0 3,375 0 100 116 0 3,125.00 21,286 0 160 82,112

82,112 48,554

May-19

1,000 0 30 52,920 260 3,375 0 100 116 0 3,125.00 21,286 0 160 82,372

82,372 50,182

Jun-19

1,000 0 30 52,920 0 3,375 0 100 0 0 3,125.00 21,286 0 160 81,996

81,996 52,186

Jul-19

1,000 0 30 52,920 0 3,375 0 100 0 0 3,125.00 21,286 0 160 81,996

81,996 54,190

Aug-19

1,000 0 30 68,796 260 3,375 0 100 116 0 3,125.00 21,286 0 160 98,248

98,248 65,142

Sep-19

1,000 0 30 68,796 0 3,375 0 100 0 0 3,125.00 21,286 0 160 97,872

97,872 76,470

Oct-19

1,000 0 30 63,504 260 3,375 0 100 0 0 3,125.00 21,286 0 160 92,840

92,840 84,430

Nov-19

1,000 0 30 63,504 0 3,375 0 100 0 0 3,125.00 21,286 0 160 92,580

92,580 92,650

Dec-19

1,000 0 30 63,504 0 3,375 0 100 0 0 3,125.00 21,286 0 160 92,580

92,580 100,870

Total

1,117,200 0 0 0 0 0 1,117,200

12,000 0 360 703,836 1,300 40,500 0 1,200 464 1,060 37,500 255,432 1,152 1,920 1,056,724 0 0 0 0 0 1,056,724


Small Business Cash Flow Projection Out of the Box: SECOND YEAR CONSERVATIVE

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$15,583

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

15,583

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

15,583

kits price to build customer cost build per month sales per month

Jan-18

$15,583

Feb-18

$19,297

Mar-18

$26,169

Apr-18

$34,557

May-18

$44,981

Jun-18

$56,805

Jul-18

$70,781

Aug-18

$86,773

Sep-18

$104,585

Oct-18

$128,841

Nov-18

$151,697

Dec-18

$176,069

62,400

62,400

67,200

72,000

76,800

81,600

86,400

91,968

110,400

105,600

110,400

105,600

62,400 77,983

62,400 81,697

67,200 93,369

72,000 106,557

76,800 121,781

81,600 138,405

500 86,900 157,681

91,968 178,741

110,400 214,985

105,600 234,441

110,400 262,097

105,600 281,669

1,000 30 39,312 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 58,686

1,000 0 30 39,312 0 3,375 1,700 100

1,000 0 30 42,336 260 3,375 1,700 100

1,000 0 30 45,360 0 3,375 1,700 100

1,000 0 30 51,408 0 3,375 1,700 100

1,000 0 30 54,432 260 3,375 1,700 100

1,000 0 30 57,940 0 3,375 1,700 100

1,000 0 30 69,552 260 3,375 1,700 100

1,000 0 30 66,528 0 3,375 1,700 100

0 3,125.00 6,886 0 58,812

0 3,125.00 6,886 0 61,576

0 3,125.00 6,886 0 67,624

0 3,125.00 6,886 0 70,908

0 3,125.00 6,886 0 74,156

1,000 0 30 69,552 260 3,375 1,700 100 116 0 3,125.00 6,886 0 86,144

1,000 0 30 66,528 0 3,375 1,700 100

0 3,125.00 6,886 0 55,528

1,000 0 30 48,384 260 3,375 1,700 100 116 0 3,125.00 6,886 0 64,976

0 3,125.00 6,886 0 82,744

0 3,125.00 6,886 0 86,028

0 3,125.00 6,886 0 82,744

0 19,297

0 26,169

0 34,557

0 44,981

0 56,805

0 70,781

0 86,773

0 104,585

0 128,841

0 151,697

0 176,069

0 198,925

1300 30.24 48 39312 62400

1300 30.24 48 39312 62400

1400 30.24 48 42336 67200

1500 30.24 48 45360 72000

1600 30.24 48 48384 76800

1700 30.24 48 51408 81600

1800 30.24 48 54432 86400

1916 30.24 48 57939.84 91968

2300 30.24 48 69552 110400

2200 30.24 48 66528 105600

2300 30.24 48 69552 110400

2200 30.24 48 66528 105600

#NAME?


Small Business Cash Flow Projection Out of the Box: SECOND YEAR AGGRESSIVE

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$50,000

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

50,000

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

50,000

kits price to build customer cost build per month sales per month

Jan-18

$50,000

Feb-18

$58,646

Mar-18

$79,726

Apr-18

$107,650

May-18

$144,714

Jun-18

$190,282

Jul-18

$245,106

Aug-18

$308,550

Sep-18

$381,134

Oct-18

$459,025

Nov-18

$531,609

Dec-18

$602,157

96,000

100,800

120,000

144,000

168,000

192,000

216,000

240,000

255,360

240,000

235,200

235,200

96,000 146,000

100,800 159,446

120,000 199,726

144,000 251,650

168,000 312,714

192,000 382,282

216,000 461,106

240,000 548,550

255,360 636,494

240,000 699,025

235,200 766,809

235,200 837,357

1,000 7,500 30 60,480 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 87,354

1,000 0 30 63,504 0 3,375 1,700 100

1,000 0 30 75,600 260 3,375 1,700 100

1,000 0 30 90,720 0 3,375 1,700 100

1,000 0 30 120,960 0 3,375 1,700 100

1,000 0 30 136,080 260 3,375 1,700 100

1,000 0 30 151,200 0 3,375 1,700 100

1,000 0 30 148,176 260 3,375 1,700 100

1,000 0 30 148,176 0 3,375 1,700 100

0 3,125.00 6,886 0 92,076

0 3,125.00 6,886 0 106,936

0 3,125.00 6,886 0 137,176

0 3,125.00 6,886 0 152,556

0 3,125.00 6,886 0 167,416

1,000 0 30 160,877 260 3,375 1,700 100 116 0 3,125.00 6,886 0 177,469

1,000 0 30 151,200 0 3,375 1,700 100

0 3,125.00 6,886 0 79,720

1,000 0 30 105,840 260 3,375 1,700 100 116 0 3,125.00 6,886 0 122,432

0 3,125.00 6,886 0 167,416

0 3,125.00 6,886 0 164,652

0 3,125.00 6,886 0 164,392

0 58,646

0 79,726

0 107,650

0 144,714

0 190,282

0 245,106

0 308,550

0 381,134

0 459,025

0 531,609

0 602,157

0 672,965

2000 30.24 48 60480 96000

2100 30.24 48 63504 100800

2500 30.24 48 75600 120000

3000 30.24 48 90720 144000

3500 30.24 48 105840 168000

4000 30.24 48 120960 192000

4500 30.24 48 136080 216000

5000 30.24 48 151200 240000

5320 30.24 48 160876.8 255360

5000 30.24 48 151200 240000

4900 30.24 48 148176 235200

4900 30.24 48 148176 235200

#NAME?

Total

3,208,600

2,242,560 0 0 0 0 0 2,242,560 kits price to build customer cost build per month 12,000 sales per month 7,500 360 1,412,813 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 1,619,595 0 0 0 0 1,619,595


Small Business Cash Flow Projection Out of the Box: YEAR 3 BASE LINE

Starting date Cash balance alert minimum Cash on hand (beginning of month) CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

Jan-18

Beginning

92,650

92,650

92,650

Jan-18

$92,650

Feb-18

$113,658

Mar-18

$134,320

Apr-18

$154,582

May-18

$175,244

Jun-18

$200,638

Jul-18

$218,192

Aug-18

$235,386

Sep-18

$259,156

Oct-18

$282,366

Nov-18

$303,492

Dec-18

$316,690

142,800

134,400

134,400

134,400

134,400

126,000

126,000

142,800

142,800

134,864

115,200

115,200

142,800 235,450

134,400 248,058

134,400 268,720

134,400 288,982

134,400 309,644

126,000 326,638

126,000 344,192

142,800 378,186

142,800 401,956

134,864 417,230

115,200 418,692

115,200 431,890

1,250 0 30 89,964 300 3,375

1,250 0 30 84,672 0 3,375

1,250 0 30 84,672 300 3,375

1,250 0 30 84,672 0 3,375

1,250 0 30 79,380 260 3,375

1,250 0 30 79,380 0 3,375

1,250 0 30 79,380 260 3,375

1,250 0 30 89,964 0 3,375

1,250 0 30 89,964 260 3,375

1,250 0 30 84,672 0 3,375

1,250 0 30 72,576 260 3,375

1,250 0 30 72,576 0 3,375

0 3,125.00 21,286 0 108,446

0 3,125.00 21,286 0 108,806

0 3,125.00 21,286 0 119,030

100 200 0 3,125.00 21,286 0 119,590

0 3,125.00 21,286 0 113,738

0 3,125.00 21,286 0 102,002

0 3,125.00 21,286 0 101,642

0 218,192

0 235,386

0 259,156

0 282,366

0 303,492

0 316,690

0 330,248

100 200 1,010 3,125.00 21,286 1,152 121,792

100 0 3,125.00 21,286 0 113,738

0 3,125.00 21,286 0 114,138

0 3,125.00 21,286 0 113,738

100 200 0 3,125.00 21,286 0 109,006

0 113,658

0 134,320

0 154,582

0 175,244

0 200,638

100

100

Total

1,583,264 0 0 0 0 0 1,583,264

15,000 0 360 991,872 1,640 40,500 0 600 600 1,010 37,500 255,432 1,152 1,345,666 0 0 0 0 1,345,666


Small Business Cash Flow Projection THIRD YEAR CONSERVATIVE

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$168,569

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

168,569

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

168,569

kits price to build customer cost build per month sales per month

Jan-18

$168,569

Feb-18

$189,647

Mar-18

$226,711

Apr-18

$267,067

May-18

$309,459

Jun-18

$353,251

Jul-18

$399,195

Aug-18

$447,155

Sep-18

$506,526

Oct-18

$569,854

Nov-18

$635,334

Dec-18

4,931,233 2,095,488 0 0 0 0 500 2,095,988

129,600

144,000

153,600

158,400

163,200

168,000

172,800

204,288

216,000

220,800

192,000

172,800

129,600 298,169

144,000 333,647

153,600 380,311

158,400 425,467

163,200 472,659

168,000 521,251

500 173,300 572,495

204,288 651,443

216,000 722,526

220,800 790,654

192,000 827,334

172,800 862,698

1,000 7,500 30 81,648 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 108,522

1,000 0 30 90,720 0 3,375 1,700 100

1,000 0 30 96,768 260 3,375 1,700 100

1,000 0 30 99,792 0 3,375 1,700 100

1,000 0 30 105,840 0 3,375 1,700 100

1,000 0 30 108,864 260 3,375 1,700 100

1,000 0 30 128,701 0 3,375 1,700 100

1,000 0 30 120,960 260 3,375 1,700 100

1,000 0 30 108,864 0 3,375 1,700 100

0 3,125.00 6,886 0 113,244

0 3,125.00 6,886 0 116,008

0 3,125.00 6,886 0 122,056

0 3,125.00 6,886 0 125,340

0 3,125.00 6,886 0 144,917

1,000 0 30 136,080 260 3,375 1,700 100 116 0 3,125.00 6,886 0 152,672

1,000 0 30 139,104 0 3,375 1,700 100

0 3,125.00 6,886 0 106,936

1,000 0 30 102,816 260 3,375 1,700 100 116 0 3,125.00 6,886 0 119,408

0 3,125.00 6,886 0 155,320

0 3,125.00 6,886 0 137,436

0 3,125.00 6,886 0 125,080

0 189,647

0 226,711

0 267,067

0 309,459

0 353,251

0 399,195

0 447,155

0 506,526

0 569,854

0 635,334

0 689,898

0 737,618

2700 30.24 48 81648 129600

3000 30.24 48 90720 144000

3200 30.24 48 96768 153600

3300 30.24 48 99792 158400

3400 30.24 48 102816 163200

3500 30.24 48 105840 168000

3600 4256 30.24 30.24 48 48 108864 128701.44 172800 204288

4500 30.24 48 136080 216000

4600 30.24 48 139104 220800

4000 30.24 48 120960 192000

3600 30.24 48 108864 172800

#NAME?

Total

$689,898

12,000 7,500 360 1,320,157 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 1,526,939 0 0 0 0 1,526,939


Small Business Cash Flow Projection Out of the Box: THIRD YEAR aggressive

Starting date Cash balance alert minimum Cash on hand (beginning of month)

Jan-18

Beginning

$168,569

CASH RECEIPTS Cash sales Returns and allowances Collections on accounts receivable Interest, other income Loan proceeds Owner contributions TOTAL CASH RECEIPTS Total cash available

168,569

CASH PAID OUT Advertising Contract labor Insurance (other than health) Meals Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Supplies (not in COGS) Taxes and licenses Utilities Wages (less emp. credits) Website SUBTOTAL Loan principal payment Capital purchases Other startup costs To reserve and/or escrow Owners' withdrawal TOTAL CASH PAID OUT Cash on hand (end of month)

168,569

kits price to build customer cost build per month sales per month

Jan-18

$168,569

Feb-18

$189,647

Mar-18

$226,711

Apr-18

$267,067

May-18

$309,459

Jun-18

$353,251

Jul-18

$399,195

Aug-18

$447,155

Sep-18

$506,526

Oct-18

$569,854

Nov-18

$635,334

Dec-18

4,931,233 2,095,488 0 0 0 0 500 2,095,988

129,600

144,000

153,600

158,400

163,200

168,000

172,800

204,288

216,000

220,800

192,000

172,800

129,600 298,169

144,000 333,647

153,600 380,311

158,400 425,467

163,200 472,659

168,000 521,251

500 173,300 572,495

204,288 651,443

216,000 722,526

220,800 790,654

192,000 827,334

172,800 862,698

1,000 7,500 30 81,648 880 3,375 1,700 100 116 1,010 3,125.00 6,886 1,152 108,522

1,000 0 30 90,720 0 3,375 1,700 100

1,000 0 30 96,768 260 3,375 1,700 100

1,000 0 30 99,792 0 3,375 1,700 100

1,000 0 30 105,840 0 3,375 1,700 100

1,000 0 30 108,864 260 3,375 1,700 100

1,000 0 30 128,701 0 3,375 1,700 100

1,000 0 30 120,960 260 3,375 1,700 100

1,000 0 30 108,864 0 3,375 1,700 100

0 3,125.00 6,886 0 113,244

0 3,125.00 6,886 0 116,008

0 3,125.00 6,886 0 122,056

0 3,125.00 6,886 0 125,340

0 3,125.00 6,886 0 144,917

1,000 0 30 136,080 260 3,375 1,700 100 116 0 3,125.00 6,886 0 152,672

1,000 0 30 139,104 0 3,375 1,700 100

0 3,125.00 6,886 0 106,936

1,000 0 30 102,816 260 3,375 1,700 100 116 0 3,125.00 6,886 0 119,408

0 3,125.00 6,886 0 155,320

0 3,125.00 6,886 0 137,436

0 3,125.00 6,886 0 125,080

0 189,647

0 226,711

0 267,067

0 309,459

0 353,251

0 399,195

0 447,155

0 506,526

0 569,854

0 635,334

0 689,898

0 737,618

2700 30.24 48 81648 129600

3000 30.24 48 90720 144000

3200 30.24 48 96768 153600

3300 30.24 48 99792 158400

3400 30.24 48 102816 163200

3500 30.24 48 105840 168000

3600 4256 30.24 30.24 48 48 108864 128701.44 172800 204288

4500 30.24 48 136080 216000

4600 30.24 48 139104 220800

4000 30.24 48 120960 192000

3600 30.24 48 108864 172800

#NAME?

Total

$689,898

12,000 7,500 360 1,320,157 2,180 40,500 20,400 1,200 348 1,010 37,500 82,632 1,152 1,526,939 0 0 0 0 1,526,939


Out of the Box 2018

Income Statement Year 1

Financial Statements in U.S. Dollars

Revenue

Gross Sales Less: Sales Returns and Allowances Net Sales

553680) 553680)

Cost of Goods Sold

Beginning Inventory Add: Purchases Freight-in Direct Labor Indirect Expenses Inventory Available Less: Ending Inventory Cost of Goods Sold

0) 0) 553680)

Gross Profit (Loss)

Expenses

Advertising Amortization Bad Debts Bank Charges Charitable Contributions Commissions Contract Labor Depreciation Dues and Subscriptions Employee Benefit Programs Insurance Interest Legal and Professional Fees Licenses and Fees Miscellaneous Office Expense Payroll Taxes Postage Rent Repairs and Maintenance Supplies Telephone Travel Utilities Vehicle Expenses Wages Total Expenses Net Operating Income

1000)

7500)

360)

2180)

40500) 1200) 348)

37500) 20400) 82632)

193620) 360060)

Other Income

Gain (Loss) on Sale of Assets Interest Income Total Other Income Net Income (Loss)

0) 360060)


Out of The Box [Second Year]

Income Statement

Financial Statements in U.S. Dollars

Revenue

Gross Sales Less: Sales Returns and Allowances Net Sales

Cost of Goods Sold

Beginning Inventory Add: Purchases Freight-in Direct Labor Indirect Expenses Inventory Available Less: Ending Inventory Cost of Goods Sold

1,117,200 $1,117,200

0 703,836 0 255,432 464 959,732 $959,732 $157,468

Gross Profit (Loss)

Expenses Advertising Contract labor Insurance (other than health) Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Taxes and licenses Utilities App and Website Createscape (monthly fee)

12,000 0 360 1,300 40,500 0 1,200 1,060 37,500 1,152 1920)

$62,396

Net Operating Income

Other Income

Gain (Loss) on Sale of Assets Interest Income Total Other Income Net Income (Loss)

$95,072

40,394 $40,394 $102,790


Out of The Box [Third Year]

Income Statement

Financial Statements in U.S. Dollars

Revenue

Gross Sales Less: Sales Returns and Allowances Net Sales

Cost of Goods Sold

Beginning Inventory Add: Purchases Freight-in Direct Labor Indirect Expenses Inventory Available Less: Ending Inventory Cost of Goods Sold

1,583,264 $1,583,264

0 991,872 0 255,432 600 1,247,904 $1,247,904 $335,360

Gross Profit (Loss)

Expenses Advertising Contract labor Insurance (other than health) Office expense Rent or lease Rent or lease: vehicles, equipment Repairs and maintenance Taxes and licenses Utilities Website Total Expenses

15,000 0 360 1,640 40,500 0 600 1,010 37,500 1,152

$237,598

Net Operating Income

Other Income

Gain (Loss) on Sale of Assets Interest Income Total Other Income Net Income (Loss)

$97,762

$92,650 $92,650 $330,248


https://www.blueapron.com/?cvosrc=search-paid.google.GLF-exact-google&gclid=CjwKCAjwrqnYBRB-EiwAthnBFk4RROlvHFGZydHnM-ijSO NrqffSjcGRHR7fVSHevTtqQJS0Jy2RlRoCfYQQAvD_BwE&utm_campaign=GLF-exact-google&utm_medium=search-paid&utm_source=google https://www.hellofresh.com/landing/getcooking2017-sem30-getstarted/?c=NU5P53KTB4PSBGWG4AQZ29ZG&gclid=CjwKCAjwrqnYBRB-Eiw AthnBFnamFN91MGhkkRIBAMcRo1GrsqT6YvkKCvEfoeqsMpONdvHQCmoqmBoCoxEQAvD_BwE http://time.com/money/4856342/best-meal-kits-value/ https://www.buzzfeed.com/hannahloewentheil/meal-kit-subcription-boxes-review http://www.farmtotabletx.com/ https://www.sec.gov/reportspubs/investor-publications/investorpubsbegfinstmtguidehtm.html https://www.amazon.com/b?ie=UTF8&node=17235386011 Austin,Texas City Information: Maps: Maps produced by: Ryan Robinson, City Demographer, City of Austin, May 2017.Housing Activity within the City of Austin. City Information: Cofield,Aubrey. An Introduction To Urban Farming In Austin, Texas.Culture Trip.August 04, 2016 Elaine Pofeldt.The top start-up mecca in the US is far from Silicon.11 Aug 2016. U.S. Census Bureau, 2010 Census of Population.U.S. Census Bureau QuickFacts: Texas. U.S. Census Bureau, Population Estimates Program (PEP).U.S. Census Bureau QuickFacts: Texas. The Economic Impact of Austin’s Food Sector, Client Assistance Memo 244, Urban Agriculture, November 17, 2010. Banks, Karen (2011). Central Texas Foodshed Assessment. USDA, Agricultural Market Service, Farmers’ Market Survey. Competition Meal Kit Information: Hirsch,Lauren. Albertsons to roll out Plated meal kits to hundreds of its stores by end of year. CNBC. April 05, 2018. Hirsch,Lauren. Walmart pushes its meal-kit business with plans to roll out to 2,000 stores this year. CNBC. March 05, 2018.


Dorfman,Jeffrey. Amazon And Whole Foods Merger To Introduce Cross-Platform Selling And Lower Prices. Forbes Magazine. August 25, 2017. Stern,Neil. Kroger Buys Home Chef As The Meal Kit Industry Rapidly Consolidates. Forbes Magazine. May 23, 2018. Noyes,Jesse. 6 Meal Kit Delivery Industry Trends. Restaurant Insider. February 16, 2018. Judkis,Maura. The meal-kit industry is at a crossroads. Will it ever figure out what we really want?. Time.com. October 17, 2017. Scherr,Suzy. Our Favorite Family-Friendly Meal Kits. Parents.October 18, 2017. Top 10 Meal Delivery. www.top10bestmealdelivery.com. Saenz,Samantha. 5 Meal Delivery Companies in Austin to Simplify Your Life. The Austinot. May 08, 2018. Subscription Information: Leonhardt,Megan.Meal Kits: Who Are the Biggest Customers?.Time. July 20, 2017. Wells,Nick. Everyone's into meal kits like Blue Apron...until they're not: Sobering numbers underlie food subscription services. CNBC. May 27, 2017. Food Vendor Information: Farm to Table. http://www.farmtotabletx.com/. May 20, 2018. Market Opportunity Analysis Information: Meal Kit Delivery Services. Meal Kits Delivery Services in the U.S., 2nd Edition. July 7, 2017. Nichols, Laura. Price Is an Obstacle to Meal Kit Popularity. Morning Consult. July 17, 2017. Choi,Jueun. Parents struggle to keep the junk food out of little mouths. USA Today. Gannett Satellite Information Network. March 06, 2017. Fisher,Marla Jo. Two incomes, no time: The struggle is real for many working parents, surveys find. Orange County Register. November 07, 2015. The Hartman Group. Consumer Trends in Health and Wellness. Forbes. Forbes Magazine. November 19, 2015. Wellness Creative Co. Fitness Industry Statistics. January 18, 2018.


Statista. Health and wellness: U.S. market value 2013-2018. United States; Euromonitor; 2013 to 2018. April 5, 2018. Giammona,Craig. HelloFresh Buys Organic Rival in Bid to Overtake Blue Apron. Bloomberg Quint. March 20, 2018. 4 Major Forces: US Department of Commerce, BEA,. U.S. Bureau of Economic Analysis. April 25, 2018. USDA Agricultural Projections to 2027. Office of the Chief Economist. Long-term Projections Report OCE-2018-1. February 2018. Regulatory Trends in the consumer goods industry. Deloitte United States. March 04, 2015. Cirera,Xavier. Masset,Edoardo. Advances in pediatrics. U.S. National Library of Medicine.September 27, 2010. Swanson,Amy. How Much Are Users Really Willing To Pay For Subscription. AW360. May 01, 2018. Pozin,Ilya. Inc.com. What Customers Really Want: It Might Surprise You. Inc. April 29, 2018.




Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.