No Effect Slight Effect Moderate Effect Major Effect
Balance Sheet
Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Cash 116,509 201,173 590,972 1,510,129 3,267,927 Accounts receivable 17,160 82,506 160,248 283,026 447,720 Office Furniture & Equipment 10,000 10,000 10,000 10,000 10,000 Technology Equipment 8,000 8,000 8,000 8,000 8,000 Depreciation (2,600) (5,200) (7,800) (10,400) (13,000) Patent 800 800 800 800 800 Total Assets 149,869 297,279 762,220 1,801,555 3,721,447 Liabilities & Owners Equity 100,000 100,000 100,000 100,000 100,000 Venture Capital 250,000 250,000 250,000 250,000 250,000 Retained earnings (deficit) (200,131) (52,721) 412,220 1,451,555 3,371,447 Total liabilities and equity 149,869 297,279 762,220 1,801,555 3,721,447
Income Statement Year 1
March April May June July August September October November December January February Total
Sales (a) - - - - - - 25,740 25,740 25,740 25,740 25,740 42,900 171,600 COS - - - - - - 10,553 10,553 10,553 10,553 10,553 17,589 70,356 Gross margin - - - - - - 15,187 15,187 15,187 15,187 15,187 25,311 101,244
Expenses:
Salaries 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 210,000 Depreciation 217 217 217 217 217 217 217 217 217 217 217 217 2,600 Utilities 84 84 84 84 84 84 84 84 84 84 84 84 1,008 Internet/Phone 61 61 61 61 61 61 61 61 61 61 61 61 732 Advertising Expense 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 48,000 Rent 780 780 780 780 780 780 780 780 780 780 780 780 9,360 Legal 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 2,083 25,000 USDA/FDA 249 249 249 249 249 249 249 249 249 249 249 249 2,990 Shipping/Distribution - - - - - - 180 180 180 180 180 180 1,080 Insurance 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 20,000 Website 1 1 1 1 1 1 1 1 1 1 1 1 12 Total expenses 26,642 26,642 26,642 26,642 26,642 26,642 26,822 26,822 26,822 26,822 26,822 26,822 320,782 Pretax income (26,642) (26,642) (26,642) (26,642) (26,642) (26,642) (11,635) (11,635) (11,635) (11,635) (11,635) (1,511) (219,538) Taxes (2,355) (2,355) (2,355) (2,355) (2,355) (2,355) (1,029) (1,029) (1,029) (1,029) (1,029) (134) (19,407) Net income (loss) $ (24,287) $ (24,287) $ (24,287) $ (24,287) $ (24,287) $ (24,287) $ (10,607) $ (10,607) $ (10,607) $ (10,607) $ (10,607) $ (1,377) $ (200,131)
Income Statement Year 2-5
Q1 Q2 Q3 Q4 Yr 2 Yr 3 Yr 4 Yr 5
Sales 252,120 57,480 229,680 285,780 825,060 1,602,480 2,830,260 4,477,200 COS 103,369 23,567 94,169 117,170 338,275 657,017 1,160,407 1,835,652 Gross margin 148,751 33,913 135,511 168,610 486,785 945,463 1,669,853 2,641,548 Expenses:
Salaries 52,500 52,500 52,500 52,500 210,000 210,000 210,000 210,000 Depreciation 650 650 650 650 2,600 2,600 2,600 2,600 Utilities 252 252 252 252 1,008 1,008 1,008 1,008 Internet/Phone 183 183 183 183 732 732 732 732 Advertising Expense 15,692 15,692 15,692 15,692 62,769 171,323 262,020 264,168 Rent 2,340 2,340 2,340 2,340 9,360 9,360 9,360 9,360 Legal 3,750 3,750 3,750 3,750 15,000 15,000 15,000 15,000 USDA/FDA - - - - - - - -Shipping/Distribution 360 1,080 1,080 1,080 3,600 5,400 9,000 12,600 Insurance 5,000 5,000 5,000 5,000 20,000 20,000 20,000 20,000 Website 3 3 3 3 12 12 12 12 Total expenses 80,730 81,450 81,450 81,450 325,081 435,435 529,732 535,480
pretax income 68,020 (47,537) 54,061 87,160 161,704 510,028 1,140,122 2,106,068 Taxes 6,013 (4,202) 4,779 7,705 14,295 45,086 100,787 186,176 Net income (loss) $ 62,007 $ (43,335) $ 49,282 $ 79,455 $ 147,410 $ 464,942 $ 1,039,335 $ 1,919,892
Q1 Q2 Q3 Q4 Yr1 Yr 2 Yr 3 Yr 4 Yr 5 Net income (loss) $ (72,860) $ (72,860) $ (31,820) $ (22,591) $ (200,131) $ 147,410 $ 464,942 $ 1,039,335 $ 1,919,892 Add non-cash expense - dep'n $ 650 $ 650 $ 650 $ 650 $ 2,600 $ 2,600 $ 2,600 $ 2,600 $ 2,600 (Inc) Dec in receivables $ - $ - $ (7,722) $ (9,438) $ (17,160) $ (65,346) $ (77,742) $ (122,778) $ (164,694) Cash from (used) in operations $ (72,210) $ (72,210) $ (38,892) $ (31,379) $ (214,691) $ 84,664 $ 389,800 $ 919,157 $ 1,757,798 Financing sources:
Executive Investment $ 100,000 $ - $ - $ - $ 100,000 $ - $ - $ - $ -Capital Investment $ 250,000 $ - $ - $ - $ 250,000 $ - $ - $ - $ -Financing uses:
Office Furniture & Equipment $ (10,000) $ (10,000) $ - $ - $ - $ -Technology Equipment $ (8,000) $ (8,000) $ - $ - $ - $
-patent $ (800) $ (800)
Total source (use) of cash $ 259,790 $ (72,210) $ (38,892) $ (31,379) $ 116,509 $ 84,664 $ 389,800 $ 919,157 $ 1,757,798 Beginning cash $ - $ 259,790 $ 187,580 $ 148,688 $ - $ 116,509 $ 201,173 $ 590,972 $ 1,510,129 Ending cash $ 259,790 $ 187,580 $ 148,688 $ 117,309 $ 116,509 $ 201,173 $ 590,972 $ 1,510,129 $ 3,267,927
SAVEory Snacks Depreciation Schedule
Asset Useful life Year 1 Year 2 Year 3 Year 4 Year 5
Office Furniture & Equipment 10 1000 1000 1000 1000 1000
Technology Equipment 5 1600 1600 1600 1600 1600
Depreciation Expense 2600 2600 2600 2600 2600
Sales Forecast
Year 1 Year 2 Year 3 Year 4 year 5
# of chips to produce March - Aug - 286,000 660,000 634,700 1,025,000
# of chips to produce Sept - Feb 286,000 638,000 2,010,800 4,082,400 6,437,000 Total # of chips sold 286,000 924,000 2,670,800 4,717,100 7,462,000
SAVEory Snacks Fixed Costs
Fixed Costs
Year 1 Year 2 Year 3 Year 4 Year 5
Salaries 210,000 210,000 210,000 210,000 210,000
Depreciation 2600 2600 2600 2600 2600
Utilities 1008 1008 1008 1008 1008
Internet/Phone 732 732 732 732 732
Advertising Expense per Yr. 48000 62769.2308 46321.6783 158433.566 101370.6
Rent 9360 9360 9360 9360 9360
Legal 25000 15000 15000 15000 15000
USDA/FDA 2990 0 0 0 0
Shipping/Distribution 1800 3600 5400 9000 12600
Insurance 20000 20000 20000 20000 20000
Website 12 12 12 12 12
Total Fix Cost 321502 325081.231 310433.678 426145.566 372682.6
Assumptions:
Year 1 Year 2 Year 3 Year 4 Year 5
Net income (200,130.84) 147,409.52 464,941.64 1,039,335.05 1,919,891.74 + Depreciation expenses 2,600.00 2,600.00 2,600.00 2,600.00 2,600.00 + Taxes (19,407.16) 14,294.65 45,086.49 100,786.77 186,176.43 Total free cash flow (216,938.00) 164,304.17 512,628.12 1,142,721.82 2,108,668.17
Year 1 2 3 4 5
Discounted value of free cash flow (166,875.38) 97,221.40 233,330.96 400,098.67 567,925.65
Discount rate (risk rate) 0.3
Industry growth rate 0.025
SAVEory Snacks Valuation 1,131,701
SAVEory Snacks Assumptions:
(1) Year 1: San Diego, CA: 5 Months 30% of schools next 5 Months 50% of schools
(2) Year 2: Expand to San Diego County
(3) Year 3: Expand to Richmond, VA & Orange County, CA (4) Year 4: Expand to Memphis, TN & Nashville, TN &
Riverside County, CA
(5) Year 5: Expand to Jacksonville, FL and New Orleans, LA
& San Bernardino County, CA
(6) 8.84% tax rate
(7) 10% of sales will be on account
(8) Assuming distributors will always buy at quantity discount (9) Executive contribution: $100,000 & $250,000 Capital investment (10) Student population: 5.5% of total population ( US Census 2010) (11) No population growth rate & no industry growth rate
EDUCATION:
Syracuse University, Whitman School of Management, Syracuse, NY
Bachelor of Science in Finance, Bachelor of Arts in Economics, (May 2012) G.P.A. 3.4/4.0 Intermediate Macro and Micro Economics, Intro to Money and Banking, International Macro Economics, Econometrics, Financial Management, Investments Accounting, Marketing
· Compiled investment reports for security selection, containing technical and fundamental analysis
· Played integral role in adjusting investment strategy though back-testing of investment model
· Created client presentations, detailing investment strategy for client meetings
· Worked hand in hand with investment analyst to prepare quarterly reports for institutional clients
· Prepared and combined presentation material for $1 billion institutional consulting deal Manchester Athletic Club, Manchester, MA
Blue Sky Adventure Camp
Lead Counselor and Project Adventure Facilitator: Summers 2009-2011
· Solely responsible for orchestrating wilderness curriculum based on experiential learning model
· Motivated and created fun camp experiences with children ages 7-14 through wilderness exploration, teambuilding exercises and group challenges
· Worked to improve communication skills with peers and to develop conflict resolution strategies for group success
· Responsible for planning daily camp schedules with other counselors and camp manager
· Collaborated with camp director to improve overall camp efficiency and efficacy
· Mentored and helped camp manager select teen leaders for future counselor positions Camp counselor: Summer 2008
· Played major role in successfully launching an outdoor, wilderness based full day camp
· Assisted project adventure facilitator in organizing and directing team-building activities SKILLS
· Computer: Excel, Bloomberg, Morningstar, Linkedin, PC and Mac experienced
· Zephyr StyleAdvisor: historical charting database for financial blends, models etc.
· Proficient in Point and Figure Chart analysis
· Manage personal Roth IRA over past three years to 68% gain LEADERSHIP
· Captain and Treasurer of SU Club Tennis Team
· Syracuse University Abroad Global Ambassador Program ACADEMIC ACCOMPLISHMENTS
· Strategic Management Group Papers and Presentations: eBay and Google Business analyses
· CAPSIM Business Simulation: Individual: 94th percentile, Team Competition: 2nd Place
Works Cited
"Bulk Vegetable Oil." Diesel Earth, Vegetable Oil Alternative Fuel. N.p., 2 June 2006. Web. 26 Oct. 2011. <http://www.dieselearth.com/notebook/bulk-vegetable-oil.html>.
"California Adolescent Health." California Department of Public Health. Office of Women's Health, n.d. Web. 24 Oct. 2011.
<www.cdph.ca.gov/pubsforms/Pubs/OWH-AdolHealthReport09.pdf >.
"California Avocado Commission - Wikipedia, the free encyclopedia." Wikipedia, the free encyclopedia. N.p., 14 Oct. 2011. Web. 25 Oct. 2011.
<http://en.wikipedia.org/wiki/California_Avocado_Commission>.
"Crop Values Final Estimates 1997-2002." usda.gov. United States Department of Agriculture, n.d. Web. 25 Oct. 2011. <http://usda01.library.cornell.edu/usda/nass/SB999/sb999.pdf>.
Gearhart Jr., Randall F., Dennis M. Gruber, and David F. Vanata. "Obesity in the Lower Socio-Economic Status Segments of American Society." ForumPublicPolicy.com. Forum on Public Policy, n.d. Web. 26 Oct. 2011.
<forumonpublicpolicy.com/archivespring08/gearhart.pdf >.
"IBIS World Industry Report 31191 Snack Food Production in the US." IBISWorld.com. N.p., n.d. Web. 26 Oct. 2011. <clients.ibisworld.com/industryus/default.aspx?indid=271>.
Leiber, Nick. "Selling Healthy Snacks in Schools - BusinessWeek." BusinessWeek - Business News, Stock Market & Financial Advice. N.p., 13 Jan. 2011. Web. 26 Oct. 2011.
<http://www.businessweek.com/smallbiz/content/jan2011/sb20110112_407787.htm>.
"SB12 School Nutrition Standards." powayusd.com. Poway Unified School District Food and Nutrition Department, 15 Sept. 2005. Web. 25 Oct. 2011.
<www.powayusd.com/nutrition/Wellness/SB12BillSummary.pdf>.
"San Diego (city) Quick Facts from the US Census Bureau." State and County Quick Facts. N.p., 18 Oct. 2011. Web. 26 Oct. 2011.
<http://quickfacts.census.gov/qfd/states/06/0666000.html>.
"San Diego Schools." Great Schools. N.p., n.d. Web. 24 Oct. 2011.
<www.greatschools.org/california/san-diego/ >.
"Snack Attack: Schools Try to Get the Junk Out! | Fresh Vending." Fresh Healthy Vending
“Natural, Organic and Healthy Vending Machines. N.p., n.d. Web. 26 Oct. 2011.
<http://www.freshvending.com/snack-attack-schools-try-to-get-the-junk-out/>.
"U.S. Sweet Potato Statistics." USDA.gov. United States Department of Agriculture, n.d. Web.
25 Oct. 2011.
<usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do?documentID=1492 >.
Cindy. Eat By Date. n.d. <http://www.eatbydate.com/how-long-do-avocados-last-shelf-life-expiration-date/>.
"Frito Lay, Inc.: Local Delivery Truck Driver." Trucking Jobs, Truck Driver Jobs, Truck Driving Jobs, Diesel Mechanic Jobs. N.p., n.d. Web. 3 Nov. 2011.
<http://www.driverfinder.net/jobs/?id=6484>.
Plano-Salaries-EI_IE5789.0,9_IL.10,15_IC1140045.htm>.
"How It's Made: Potato Chips. [VIDEO]." Best Online Videos | Wimp.com. Web. 03 Nov. 2011.
<http://www.wimp.com/howchips/>.
"Kitchen Chicago: Kitchen Rental Rates." Kitchen Chicago, a Shared-Use Kitchen in Chicago, IL. N.p., n.d. Web. 2 Nov. 2011. <http://kitchenchicago.com/kitchen/rates>.
Leber, Beth. "Cost of Running a Focus Group." useit.com: Jakob Nielsen on Usability and Web
Design. N.p., n.d. Web. 2 Nov. 2011.
<http://www.useit.com/papers/focusgroupcost.html>.
Muske, Glenn, Rodney Holcomb and Suzanne L. Holcombe. Division of Agricultural Sciences and Natural Resources. Oklahoma: Oklahoma State University, n.d.
<http://osufacts.okstate.edu/docushare/dsweb/Get/Document-2489/>
"Rental A Kitchen." Rental A Kitchen. N.p., n.d. Web. 3 Nov. 2011.
<http://www.sharedkitchenrentals.com/>.
Still Tasty LLC. Still Tasty. n.d. <http://stilltasty.com/fooditems/index/18774>.