BETTY'S FAST FOOD, INC Need Quick One Page 1. General Company Description Financial Narrative Betty's Fast Food, Inc. (S Corp) is a small food service company incorporated in 2013 in Ohio that specializes in providing high-quality fast food via company-owned portable carts in high-density urban office locations The business is operated under the name O Betty's Red Hol! The owner is considering applying for a $1 million loan from one of three local banks to expand marketing and distribution of its current shy-cart operation in downtown Cincinnati and payoff all current debts. Net profit return on investment (ROI) in three years is estimated at 243 percent for the $1 million in funding, after pay back. O'Betty's Red Holl sells premium quality hot deas and other ready-to-eat luncheon products to upscale business people in high-traffic urban locations. O'Betty's Red Hot! is positioned versus other luncheon street vendors as the best place to have a quick lunch, Reasons why are that O'Betty's Red Hot have the cleanest carts the most hygienic servers, the purest, freshest, products, and the best values Prices are at a slight premium to reflect this superior vending service, O'Betty's Red Holl also is known for its fun and promotional personality. offering consumers something special every week for monetary savings and fun Each of the carts carries a sign saying "O'Betty's Red Hot!-Satisfy yourself for $2.00! You deserve it!" The message is targeted to all passing potential customers who want to indulge themselves inexpensively with a hot dog. There also may be a subliminal message for sinful or forbidden indulgence, too, since most hot dogs are high in fat and unsaturated fats. This unique selling proposition is self-targeting since only consumers who like hot dogs and feel that they deserve an inexpensive indulgence will believe this message is meaningful to them. The benefits of this message are relatively unique: "inexpensive satisfaction plus indulgence." Informal, qualitative research revealed that the target market of busy office workers are constantly in conflict with themselves about wanting a juicy, delicious hot dog and trying to watch the fats and amount of meat in their diets. Moreover, the hot dogs that O'Betty's Red Hot serves aren't high in fat. They are high quality, all natural products with no preservatives or harmful chemicals. O'Betty's Red Hot vendors make it a point to let customers know that indulging themselves is both inexpensive and healthy. Although the signs emphasize hot dogs, each of Betty's carts offers an extensive menu of healthy and reasonably priced food. II. Marketing Plan O'Betty's Red Hot was created to attain leadership of mobile, cart serving-units in large urban business centers. Betty targets upscale, urban office workers seeking fast, convenient, portable, breakfast and lunch meals. Each cart, which costs about $20,000, is capable of housing enough food to serve about 200 to 250 meals per day. Betly differentiates and positions its business from the competitive fast food and other take-out restaurants with its products (providing high-nutrition, 100 percent all-natural, no artificial ingredients, colors, additives or preservatives convenience foods and snacks), its concern for the environment (biodegradable, recyclable containers/wrappers and PR tie-ins), and its service (a no-questions-asked money-back guarantee of all products sold and the best-trained company server personnel in the category). O'Betty's Red Hot food products are priced at parity with, or at a slight premium over. competitive offerings, whether all-natural or not. Extensive promotional activity, including free samples and daily specials, help to ensure that O'Betty's customers perceive that they are receiving higher quality products and prompt, courteous service in exchange for the slight premium in price. O'Betty's Red Hot has been successful in establishing contract alliances with real estate management companies for permanent lease sites inside and outside key office buildings, and for cooperative sale of beverages and minor snack items through existing lobby shops. All existing leases permit storage of the vending cart at a secure site within the building in which it operates Customer loyalty is encouraged with development and promotion of new and revolving seasonal menu selections each quarter, daily customer sampling, and bonus specials Training includes "friendly personality recruiting, a minimum of six hours of company training mentoring, and apprentice management programs. Advertising and Promotion To support its expansion efforts, O'Betty's Red Hot considered using popular media, such as TV, radio, and newspapers to advertise, along with promotional free product samples and coupons. However, informal discussions with suppliers revealed that competitors in the downtown office area were spending little or no money to promote and advertise their cart luncheon business. It appears that the most successful hot dog cart operations spent about 5 percent of net sales revenue for promotion and advertising. Because this business plan anticipates rapid growth through the addition of new carts, Betty plans to continue to spend at least 10 percent of net sales during 2016. Based on this decision, advertising and promotional possibilities were prioritized in order of probable effectiveness, with estimated costs: Advertising TV ($500/30-second ad/station) Radio ($50-100/60-second ad/station) Newspaper ads ($500/ad) Cart signage ($100) Flyers ($100 @$0.10 each) Promotion Free samples ($25/day @$0.25 each) Coupons ($5/day @$.025 each) Frequent purchase book ($15/day) Soft drink premiums (supplied by drink companies) In performing the research into advertising and promotions, it was determined that any broadcast option involved additional production costs that were at least as much as the cost of running a single ad. In addition, at least four or five ads had to be run per station to be effective. Breakeven cost coverage would be exorbitant, with over a year's estimated sales needed just to pay for a small TV and radio campaign. And it would be difficult to advertise with available media just to the target group of office workers within a radius of six city blocks All electronic and print media expenses were also well over the 10 percent budget limit m e Can Based on this analysis. O Betty's Red Hot clever message hand out 1000 Syers ($10 drink premium program collect can Beyond that efforts would be made to get free PR c downtown TV and radio stations by sendir O Betty's Red Hot can afford to hand ou 10 percent budget mint business is bei accelerate the purchase of additional carts Promotions that will be undertaken to su Samples of prepackaged breakfast and lun meal purchase). Other marketing expen buyer card promotions decided to have each cart painted ($100) with a 1 00) Over three months to offices, and do the son free gifts provided by local soft drink distributors) PR coverage through local newspapers and out flyers and ee Samples to editorial staff before lunch. all wear long and stay within the estor wear Purchase of is better than expected the extra income Kertaken to support the business expansion the business expansion will consist of free and lunch items bonus days ( eg, free salad days with penditures will be for items such as coupons and frequent These activities will help establish O'Betty's greater Cincinnati area that gives out free provides a bonus day free side dish program in the past in growing the business and maintaining loy promotions with other we fast food restaurants leg. Moon Fried Chicken, White Hen Pantry, etc). Betty's Red Hot as the only fast food operator in the e out free samples continuously throughout the year, and o maintaining loyal customers despite lower price va In the past, this program has been instrumental restaurants (eg. McDonald's, Burger King, Kentucky Market and distribution situation The company has a unique any has a unique advantage in the food service market when compared to regular restaurants and et durants and other cart vendor operators Indaploutdoor location mobility, efficiency in cantly lower overhead, pre-packed portion control products, elimination of cooks of chets, lower cost-of-goods, elimination of cooking and accompanying equipment and elimination of wait/bus staff provide an overall savings in basic cost of goods and services estimated at 50 percent when compared to ordinary restaurants offering similar pricing per meal O Betty's Red Hot' is also protected from existing and new competitors via an aggressive space lease contract and option program in key high-traffic office buildings in Cincinnati. The company is also the only food cart operation with a company-owned mobile cold-storage vehicle to supply company carts as needed. The company is also exploring the possibility of starting its own canteen warehouse to prepare and supply food items, to further lower the cost of goods and expand new menu selections as new cart locations are achieved. III. Products O'Betty's Red Hot has the highest quality of product image for any cart vendor or fast-food operation in the Cincinnati area, evidenced by numerous media editorials, customer surveys, and the company's own competitive menu surveys of adjacent area competitive food service outlets. The company's products are 100 percent all-natural, with 30 percent of meal items and snacks qualifying as 'low fat. at less than four grams fat per serving. Nutritional product information on all products is also available on request from consumers. alle varies menu items weekly, with three specials per day at a discounted price Seasonal menu variations include more soups, chili, stews, and hot drinks during winter months, and more salads and frozen cold O'Betty's specializes in pre-packaged, soups, and snacks. Low-fat mayon meats, fresh-baked whole-grain breads, an a unique menu selection for cust wat mayonnaise fresh vegetable topp dantives, or preservatives another source of proo competition. O'Betty's Red Hot! co-ops s tobacco/candy shops in each building increasing sa don for customers. All ingredients are ems (eg, Italian ices) during summer months -natural breakfast and lunch sandwiches, salads, vegetable toppings and fruits, low-sodium and hand-made soups, stews and side dishes provide gredients are made without artificial colors product uniqueness when compared to the PS Sales of all natural beverages from existing once easing sales for both businesses IV. Management & Organization Key personnel resident, graduated from the University of Wisconsin experience as a chef and restaurant manager, in several or family owns a convenience food products company tors, and utilizes sales brokers, Betty grew up with work the family business. She has traveled the world service techniques and food nutrition as practiced by restaurants active member of the Food Industry Advisory Board for the Pan Association. In 2009, she was the recipient of the Entrepreneur-of-the- Betty Gilbreath, company founder and president, grac and has several years of food service expert of the Chicago area's top restaurants Her family owns a that sells primarily to distributors, and ut almost every phase of the family business. She has the extensively, studying food service techniq worldwide. She is an active member of the American Restaurant Association. In 2009, she Year award from the Cincinnati Restaurant Owners Association. Betty is the sole owner of the company. She tak e sole owner of the company. She takes a monthly draw that is not included in the wages & salaries expense. Employees All O'Betty's Red Holl employees and cart operators are screened for scholastic achievement (1.e., top 30 percent of students) and receive six hours of entry-level customer service training Cart managers must have a minimum of one year of experience and training with the company Wages were a little too high in 2015 as a percent of sales. O'Betty's expects it to be at the 20% level for the next three years. V. Financial Section ** This is the section you will write the narrative. The narrative is an summary of the financial worksheets explaining what happened, why, trends, etc. Appendix ** Pranare an appendix. All financial statements and worksheets must be in the appendix. It is best to have them in the order they are discussed in the narrative section VU L LETINU U U U Help = tome insert Draw Page Layout Arial 11-AA BLU- L O -A - Font - * $ 299998 Formulas Data Review View = D. 29 Wrap Text E Merge & Center - 5 Currency $ -% % Number %8-28 Condition Formatting Alignment Exp/Sales 100.00% 30.00% 70.00% Pro Forme 2017 56,000,000 $1,800,000 54,200,000 Exp/Sales 100.00% 30.00% 70.00% Pro Forme 2018 59,000,000 $2,700,000 56,300,000 Exp/Sales 100.009 30.00% 70.00% 5900.000 $27.000 59.000 10.00% 0.30% 0.10% Betty's Fast Food, Inc. Pro Forme YEAR Yr-end 2015 Exp/Sales 2016 SALES $1,800,000 100.00% $2.999,988 Cost of Goods $540,000 30.00% $899.996 GROSS MARGIN $1,260,000 70.00% 52,099.992 OPERATING EXPENSES Ads Promotion $180,000 10.00% $299,998 R&D $9,000 0.50% $15,000 Dues/Subscriptions $1,800 0.10% $3,000 Freight 57.200 0.40% $12,000 Insurance $18,000 1.00% 530,000 Maintenance $1,800 0.10% $3,000 Materials 590.000 5.00% $149,999 Miscellaneous $36.000 2.00% 560 000 Office Supplies CAM 004590.000 Outs de Services $18.000 1.00% $30.000 Accounting/legal $18.000 1.0096 $30.000 Lease Equipment $27.000 150% $45.000 Lease Facilities $27.000 1.50% $45.000 1000% 0.50% 0.10% 0.40% 100% 0.10% 5.00% 2.00% 3 0096 1.00% 1.00% 1.50% 1.50% $600,000 $18,000 $6,000 524.000 $60,000 $6.000 $300,000 $120.000 $180,000 560.000 560.000 590.000 590.000 10.00% 0.30% 0.10 0.40% 1.00% 0.10% 5.00% 2.00% 3.00% 1.00% 1.00% 150% 1.509 $90,000 $9.000 $450,000 590,000 $135.000 590.000 $72,000 $135.000 5135,000 1.00% 0.10% 5.00% 1.00% 1.50% 1.00% 0.00% 1505 Sheet to ave C H A O'Bett/s Income Statement 2015 and blank proforma (1) Sav Draw Formulas Data Review View Help Home Insert X Arial BTU- Page Layout 11 - A A - A. = Wrap Text Merge & Center Currency $ - % - -18 Conditional Forma Formatting Table Alignment Number X f 299998 $72,000 0.80% Accounting Legal Lease Equipment Lease Facilities Telephone $18,000 $27.000 $27,000 $9.000 $9.000 $9.000 $90.000 1.50% 1.50% 0 50% 0.50% 0.50% Trave Entertainment Utilities 5.00% Sales Commissions Wages and Salaries $30,000 $45,000 $45.000 $15.000 $15,000 $15.000 $149 999 $599.998 $1,607,993 $491,999 $18.798 $120,000 $323 201 1.00% 1.50% 1.50% 0.50% 0.50% 0.50% 5.00% 20.00% 53.609 16.40% 1.63% 4.00% 10.77% $60,000 $90,000 $90,000 $30,000 $30,000 $30,000 $300,000 $1.200.000 53,204.000 $996,000 $34.259 5180,000 $781.741 1.00% 150% 1.50% 0.50% 0.50% 0.50% 5.00% 20.00% 53 40% 16.60% 0.57% 3.00% 13.03% $135,000 $135,000 $45,000 $45.000 $45,000 $450.000 $1.800.000 $4,563,000 51,737.000 $12.679 $240,000 $1.483,322 1.50% 1.50% 0.50% 0.509 0.50% 5.00% 20.00% 50.70% 19.30% 0.15% 2.67% 16.48% $435 200 24.18% Total Expenses EBDIT Interest Expense Depreciation Expense Net Profit Before Tax $1,040,000 $220,000 $14,303 $10,960 $194.737 57.78% 12.22% 0.79% 0.61% 10.82% OR OS Home Insert Draw Page Layout Formulas Data Review View Help Paste Tahoma BIU - 11-AA OA == E 2 Wrap Text Merge & Center - Accounting $ - % Clipboard Font Alignment Number x .fo =246+D41+D37 D48 - 4 ALB un WN - Pro Forma Balance Sheet Betty's Fast Food, Inc. December 31, 2016 6 Assets 7 Current assets: 8 Cash 9 Investments 10 Inventories 11 Accounts receivable 12 Pre-paid expenses 13 Other 14 Total current assets 8,333.00 563,521.00 17,333.00 5.999,00 595,186.00 16 Fixed assets: 17 Property, carts,vehicles, furniture, and equipment 18 Leasehold improvements 19 New carts & equipment 20 Less accumulated depreciation 21 Net fixed assets 583.997.00 22,499.00 300,000.00 (10,000.00 896,496.00 23 other assets: 24 Goodwill 25 Total other assets Balance Sheet Oe ^ DS AutoSave File Home Insert Tahoma 8 blank balance sheet 2016 - Compatibility Mode Sav. Search Draw Page Layout Formulas Data Review View Help 11-AA == Wrap Text Accounting E- 0-A- 3 Merge & Center - $ - % 8 - LE - Paste Condi Forma Clipboard Alignment Number F G H D48 - X 046+041+037 4 A BI 29 Liabilities and owner's equity 30 Current liabilities: 31 Accounts payable 32 Employment taxes payable 33 Accrued compensation 34 Sales Taxes Payable 35 Current site leases 36 Current Maturities of Long-term debt 37 Total current liabilities 19,416.00 3,583.00 7.333.00 4.166.00 1.999.00 12,416.00 48,913.00 39 Long-term liabilities: 40 Commercial Term Loan 41 Total long-term abilities 1,096,812 1,096,812.00 43 Owner's equity: 44 Investment capital 45 Accumulated retained earnings Total owner's equity 235,957.00 235,957.00 48 1.381.682.00 Total liabilities and owner's equity $ Assets higher Difference: ($110.000.0) Balance Sheet Merge & Center - Conditional Formatas Formatting Table - Styles Styles Font Alignment MN BCDEFGT CASH FLOW ANALYSIS Year 2015 Betty's Fast Food, Inc. 8 9 10 11 12 Total 150,000 150,000 150,000 150,000 150.000 150.000 150.000 150.000 150,000 150,000 150,000 150,000 $1,800,000.00 $0.00 Sales Sales 2 Less Returns Total Sales $150,000 $150,000 $150,000 $150.000 $150.000 $150.000 $150.000 $150,000 $150.000 $150.000 $150.000 $150.000 $1.800.000,00 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 $1,800,000.00 $0.00 $0.00 $0.00 $1,800,000.00 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 7.500 7.500 7.500 7,500 7.500 7.500 7,500 7.500 7,500 Cash Receiptis 0.30 do 150,000 150,000 150,000 31-60 days 12 Over 60 days 13 Cash balance 14 Total $150,000 $150.000 $150,000 15 Disbursements: 16 Material Cost 7.500 7.500 7.500 17 Management Labor 36,367 36,367 36,267 Benefits 20 Advertising 15,000 15.000 15.000 Auto expense Contribution Chance cand Sheet1 Sheet2 Sheet3 3 6,267 36,267 36.267 36,267 36,367 16.267 36,267 18 16.161 16267 19 $90,000.00 $0.00 $415,204.00 $0.00 $100,000.00 $0.00 $0.00 $0.00 15.000 15.000 15.000 15.000 15,000 15,000 15.000 15.000 15.000 %,. Calibri 1AA == BTU - 21-AA - EEE Font 5 23 Wup Text Merge a Center - General $ -% 9 - S 29 Conditional Formatas Cell Formatting Table Shes Insert Delete Form Algsent Nuwber PES EFG IM o 1.500 1.500 1,500 1,500 4,500 1.500 1,500 1.500 1.500 1.500 1,500 4500 1.500 1,500 1,500 1.500 1,500 4,500 1.500 1,500 4.500 1.500 1,500 4,500 1.500 1.500 1.500 1,500 4.500 4,500 4.500 4.500 4,500 4.500 250 50 Contribution Charge cand Payroll Tax France Legal Acer Office supplies 28 Materials Shoppe Freight 30 Telephone Une 32 Water 33 Tax/license 34 Internet 35 Travel Entertainment 36 Loan payment 37 Office Payment 38 Fixtures 39 Equipment 40 Total 41 NET CASH FLOW 42 CUMULATIVE N $0.00 $0.00 $0.00 $18,000.00 $18,000.00 $54,000.00 $0.00 $7,200.00 $9,000.00 $9,000.00 $0.00 $0.00 $0.00 $9,000.00 $365,604.00 $27,000.00 $0.00 $27.000.00 $1.249,000.00 600 750 750 0 0 0 750 30,467 2.250 0 0 750 30,467 2.250 0 750 30,467 2.250 0 750 30,467 2.250 0 750 30,467 2.250 30.467 2.250 30,467 2.250 30,467 2.250 750 30467 2.250 750 30.467 2.250 30.467 2.250 30 457 2.250 2.250 $104,034 $45.916 $45.916 2.250 $104084 $45.916 591.832 2.250 5104,034 45.916 $137,743 2.250 $104,084 45.916 $183,664 2.250 2.250 5104081 5104034 $45.916545.916 $229,580 $275,496 2.250 $104,084 $15.916 5321,412 2350 5104,084 45.916 5367 328 2250 5104034 $45.916 5413.244 2250 $104034 545.916 5459,160 2250 2250 $104,034 $104,034 545.916545.916 505,076 5550992 Sheet1 Sheet2 Sheet3 OBH e os -111-AAEE 2 Wrap Test Arial Number BI - - -A E EE Merge & Center - $ - %88 Font Alignment Number * v f -32875 DIE Betty's Fast Food, Inc. Balance Sheet as of 12/31/2015 Assets Liabilities Current assets Current liabilities Cash . $5,000 Accounts payable $11,650 Short-term notes Accounts receivable payable entory 10,400 Long-term n Long-term notes 7.450 payable Prepaid expenses payable 1,200 Temporary investments Sales taxes payable 2500 Total current assets $19.000 Employment taxes payable 2150 Long-term assets Accrued payroll 4,400 Total current real property S185,000 liabilities $29,350 vehicles 38 000 Long-term Babilities vending carts 120.000 Vending cart loans $32.000 food preparation 24,356 equipment loan 26,750 food storage Balance Sheet 2015 3.600Current site leases Oon - Partial 2015 Balance Sheet Betty's 1. sav. Home Insert Draw Page Layout Formulas Data Review View Help E Number Arial B IU 11-AA - - A. 29 Wrap Test Merge & Center - $ - % 28 29 Font Alignment Number X x -32875 $32,000 26.750 vehicles 1 vending carts food preparation equipment food storage equipment furniture and equipment (less depreciation) Total long-term assets TOTAL ASSETS D 3 8,000 Long-term liabilities 120,000 Vending cart loans Mobile storage vehicle Joan 13,500 Mortgage 7,400 liabilities -32,875 Total liabilities $355,375 Owners equity Total long-term 144,700 $203,450 $232,800 $141,575 $374 375 TOAL LIABILITIES & DE $374 375 Fillin A,B,C,D,&E Balance Sheet 2015 Insert Draw P age Layout Formulas Data Help Review View Wrap Test Merge Center - Times New Roman - 10 -AA - BTU 1-0-A-EEEEE Number $ - % Conditional Formulas Cell Formatting Table Styles Styles Clipboard Font Alignment Number 1 X LM Year 2016 Betty's Fast Food, Inc. 11 12 Total" 1 CASH FLOW ANALYSIS 2 Month: 3 Sales: Sales 249 999 Sales 6 Less Returns 7 Total Sales $249,999 249 999 2 09999 209.999 249 999 249 999 249 999 249.999 249.999 249.999 249,999 249,999 $299, 00 $0.00 $249,999 $249 999 $249,999 $249 999 $249,999 $249,999 $249,999 $249.999 $249.999 $249,999 $249,999 $2.999,900.00 249,999 249.999 249.999 249,999 249,999 349.999 349.999 249,999 119 000 319.999 249,999 249.999 249.999 12 $2,999,988.00 $0.00 $0.00 $0.00 $2,999,988.00 $249,999 $249.999 $249.999 $249.999 $249.999 $249,999 $349,999 $249.999 $249,999 $349.999 $249,999 $249,999 1 2,500 12.500 12,500 12,500 12.500 2.500 12,500 12,500 12,500 12.500 12,500 2,500 Cash Recipes 10 0-30 d 11 31-60 days Over 60 den 13 Cash balance 14 Total 15 Disbursements: 16 Material Cost 17 Management Labor Benefits Achertising to experie Contributor Charge care Sheet1 50,000 50,000 30000 30,000 50,000 50,000 50,000 50,000 50,000 50.000 50 000 000 2,500 2,500 2,500 2,500 2,500 2.500 2.500 2.500 2.500 2.500 2,500 2,500 $149,999.04 $0.00 $599,997.96 $0.00 $29.997.96 $0.00 $0.00 $0.00 Sheet2 Sheet3 Home Insert Draw P age Layout Formulas Data Review View Help Number Times New Roman - 10 - AA BTU - - -A- Wrap Text Merge Center - $ % & 3 Insert Delete Forma Conditional Formatas Cell Formatting - Table - Styles Styles Font Alignment Number 1 X & B C D E F G H I 0 2,500 2,500 2.500 2.500 2,500 2,500 7.500 2,500 2.500 7.500 2,500 2.500 7.500 2,500 2,500 7500 2,500 2,500 2.500 2.500 2.500 2,500 2500 7,500 2.500 7.500 2.500 7,500 2.500 7,500 7.500 7.500 1.000 1.000 1.000 1,000 1.250 1.000 1,250 1,250 1.000 1,250 1,250 1.000 1,250 1.250 1.000 1,250 1.250 1,250 1.250 1.000 1,250 1.250 Charge card Payroll Tax Insurance Legal Acer Office supplies era Shoppplus Freight Telephone Utilities Water To/Ticarse Internet Travel Er men Loan payment Office Payment Faxe Equipment Total 1.000 1.250 1,250 1.000 1.250 1,250 250 1,250 1,250 1,250 $0.00 $0.00 $30,000.00 $30,000.00 $90,000.00 $0.00 $12,000.00 $15,000.00 $15,000.00 $0.00 $0.00 $0.00 $15,000.00 $0.00 $45,000.00 $0.00 $45,000.00 $1,076,994.96 1.250 12 1.250 1.250 1.250 1.250 1.250 1.250 1,250 1,250 1250 1250 3,750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3,750 $89,750 $160.249 $160,249 3.750 589,750 $160,249 $320,499 3,750 589,750 $160,249 5480,743 3,750 3.750 3.750 3.750 3.750 $89,750 $89.750 $89.750 $89.750 $89,750 $160,249 $160.3495160,240 $160,249 $160,249 5640.9985801,247 3961,497 51,121.746 51.281,995 3,750 $89,750 $160,349 $1,442,245 3,750 $89,750 5160,200 $1,602,494 3.750 3.750 $89,750 $89.750 $160,249 $160,349 $1,762,741 $1,922,993 NET CASH FLOW CUMULATIVE Cells Locked Sheet1 Sheet2 Sheet3 H57 X fx BCDEFG EXHIBITS: INPUT DATA Betty's Fast Food, Inc. Table IC4.1 Balance Sheets Actual 2015 Proforma 2016 $ Assets Cash Prepaid Expenses Inventories Total current assets Gross fixed assets Less: accumulated depreciation Net fixed assets Total assets 5,000 $ 8,333 3,600 6,000 10,400 17,333 19,000 $ 31,666 388,250 647,081 32,875 54,791 355,375 $ 592,290 374,375 $ 623,956 $ Liabilities and equity Accounts payable, site leases due, sales taxes Accruals Notes payable Total current liabilities Long-term vending cart loan, mobile storage Vehicle Mortgage Equity Total common equity Sheet1 O e BETTY'S FAST FOOD, INC Need Quick One Page 1. General Company Description Financial Narrative Betty's Fast Food, Inc. (S Corp) is a small food service company incorporated in 2013 in Ohio that specializes in providing high-quality fast food via company-owned portable carts in high-density urban office locations The business is operated under the name O Betty's Red Hol! The owner is considering applying for a $1 million loan from one of three local banks to expand marketing and distribution of its current shy-cart operation in downtown Cincinnati and payoff all current debts. Net profit return on investment (ROI) in three years is estimated at 243 percent for the $1 million in funding, after pay back. O'Betty's Red Holl sells premium quality hot deas and other ready-to-eat luncheon products to upscale business people in high-traffic urban locations. O'Betty's Red Hot! is positioned versus other luncheon street vendors as the best place to have a quick lunch, Reasons why are that O'Betty's Red Hot have the cleanest carts the most hygienic servers, the purest, freshest, products, and the best values Prices are at a slight premium to reflect this superior vending service, O'Betty's Red Holl also is known for its fun and promotional personality. offering consumers something special every week for monetary savings and fun Each of the carts carries a sign saying "O'Betty's Red Hot!-Satisfy yourself for $2.00! You deserve it!" The message is targeted to all passing potential customers who want to indulge themselves inexpensively with a hot dog. There also may be a subliminal message for sinful or forbidden indulgence, too, since most hot dogs are high in fat and unsaturated fats. This unique selling proposition is self-targeting since only consumers who like hot dogs and feel that they deserve an inexpensive indulgence will believe this message is meaningful to them. The benefits of this message are relatively unique: "inexpensive satisfaction plus indulgence." Informal, qualitative research revealed that the target market of busy office workers are constantly in conflict with themselves about wanting a juicy, delicious hot dog and trying to watch the fats and amount of meat in their diets. Moreover, the hot dogs that O'Betty's Red Hot serves aren't high in fat. They are high quality, all natural products with no preservatives or harmful chemicals. O'Betty's Red Hot vendors make it a point to let customers know that indulging themselves is both inexpensive and healthy. Although the signs emphasize hot dogs, each of Betty's carts offers an extensive menu of healthy and reasonably priced food. II. Marketing Plan O'Betty's Red Hot was created to attain leadership of mobile, cart serving-units in large urban business centers. Betty targets upscale, urban office workers seeking fast, convenient, portable, breakfast and lunch meals. Each cart, which costs about $20,000, is capable of housing enough food to serve about 200 to 250 meals per day. Betly differentiates and positions its business from the competitive fast food and other take-out restaurants with its products (providing high-nutrition, 100 percent all-natural, no artificial ingredients, colors, additives or preservatives convenience foods and snacks), its concern for the environment (biodegradable, recyclable containers/wrappers and PR tie-ins), and its service (a no-questions-asked money-back guarantee of all products sold and the best-trained company server personnel in the category). O'Betty's Red Hot food products are priced at parity with, or at a slight premium over. competitive offerings, whether all-natural or not. Extensive promotional activity, including free samples and daily specials, help to ensure that O'Betty's customers perceive that they are receiving higher quality products and prompt, courteous service in exchange for the slight premium in price. O'Betty's Red Hot has been successful in establishing contract alliances with real estate management companies for permanent lease sites inside and outside key office buildings, and for cooperative sale of beverages and minor snack items through existing lobby shops. All existing leases permit storage of the vending cart at a secure site within the building in which it operates Customer loyalty is encouraged with development and promotion of new and revolving seasonal menu selections each quarter, daily customer sampling, and bonus specials Training includes "friendly personality recruiting, a minimum of six hours of company training mentoring, and apprentice management programs. Advertising and Promotion To support its expansion efforts, O'Betty's Red Hot considered using popular media, such as TV, radio, and newspapers to advertise, along with promotional free product samples and coupons. However, informal discussions with suppliers revealed that competitors in the downtown office area were spending little or no money to promote and advertise their cart luncheon business. It appears that the most successful hot dog cart operations spent about 5 percent of net sales revenue for promotion and advertising. Because this business plan anticipates rapid growth through the addition of new carts, Betty plans to continue to spend at least 10 percent of net sales during 2016. Based on this decision, advertising and promotional possibilities were prioritized in order of probable effectiveness, with estimated costs: Advertising TV ($500/30-second ad/station) Radio ($50-100/60-second ad/station) Newspaper ads ($500/ad) Cart signage ($100) Flyers ($100 @$0.10 each) Promotion Free samples ($25/day @$0.25 each) Coupons ($5/day @$.025 each) Frequent purchase book ($15/day) Soft drink premiums (supplied by drink companies) In performing the research into advertising and promotions, it was determined that any broadcast option involved additional production costs that were at least as much as the cost of running a single ad. In addition, at least four or five ads had to be run per station to be effective. Breakeven cost coverage would be exorbitant, with over a year's estimated sales needed just to pay for a small TV and radio campaign. And it would be difficult to advertise with available media just to the target group of office workers within a radius of six city blocks All electronic and print media expenses were also well over the 10 percent budget limit m e Can Based on this analysis. O Betty's Red Hot clever message hand out 1000 Syers ($10 drink premium program collect can Beyond that efforts would be made to get free PR c downtown TV and radio stations by sendir O Betty's Red Hot can afford to hand ou 10 percent budget mint business is bei accelerate the purchase of additional carts Promotions that will be undertaken to su Samples of prepackaged breakfast and lun meal purchase). Other marketing expen buyer card promotions decided to have each cart painted ($100) with a 1 00) Over three months to offices, and do the son free gifts provided by local soft drink distributors) PR coverage through local newspapers and out flyers and ee Samples to editorial staff before lunch. all wear long and stay within the estor wear Purchase of is better than expected the extra income Kertaken to support the business expansion the business expansion will consist of free and lunch items bonus days ( eg, free salad days with penditures will be for items such as coupons and frequent These activities will help establish O'Betty's greater Cincinnati area that gives out free provides a bonus day free side dish program in the past in growing the business and maintaining loy promotions with other we fast food restaurants leg. Moon Fried Chicken, White Hen Pantry, etc). Betty's Red Hot as the only fast food operator in the e out free samples continuously throughout the year, and o maintaining loyal customers despite lower price va In the past, this program has been instrumental restaurants (eg. McDonald's, Burger King, Kentucky Market and distribution situation The company has a unique any has a unique advantage in the food service market when compared to regular restaurants and et durants and other cart vendor operators Indaploutdoor location mobility, efficiency in cantly lower overhead, pre-packed portion control products, elimination of cooks of chets, lower cost-of-goods, elimination of cooking and accompanying equipment and elimination of wait/bus staff provide an overall savings in basic cost of goods and services estimated at 50 percent when compared to ordinary restaurants offering similar pricing per meal O Betty's Red Hot' is also protected from existing and new competitors via an aggressive space lease contract and option program in key high-traffic office buildings in Cincinnati. The company is also the only food cart operation with a company-owned mobile cold-storage vehicle to supply company carts as needed. The company is also exploring the possibility of starting its own canteen warehouse to prepare and supply food items, to further lower the cost of goods and expand new menu selections as new cart locations are achieved. III. Products O'Betty's Red Hot has the highest quality of product image for any cart vendor or fast-food operation in the Cincinnati area, evidenced by numerous media editorials, customer surveys, and the company's own competitive menu surveys of adjacent area competitive food service outlets. The company's products are 100 percent all-natural, with 30 percent of meal items and snacks qualifying as 'low fat. at less than four grams fat per serving. Nutritional product information on all products is also available on request from consumers. alle varies menu items weekly, with three specials per day at a discounted price Seasonal menu variations include more soups, chili, stews, and hot drinks during winter months, and more salads and frozen cold O'Betty's specializes in pre-packaged, soups, and snacks. Low-fat mayon meats, fresh-baked whole-grain breads, an a unique menu selection for cust wat mayonnaise fresh vegetable topp dantives, or preservatives another source of proo competition. O'Betty's Red Hot! co-ops s tobacco/candy shops in each building increasing sa don for customers. All ingredients are ems (eg, Italian ices) during summer months -natural breakfast and lunch sandwiches, salads, vegetable toppings and fruits, low-sodium and hand-made soups, stews and side dishes provide gredients are made without artificial colors product uniqueness when compared to the PS Sales of all natural beverages from existing once easing sales for both businesses IV. Management & Organization Key personnel resident, graduated from the University of Wisconsin experience as a chef and restaurant manager, in several or family owns a convenience food products company tors, and utilizes sales brokers, Betty grew up with work the family business. She has traveled the world service techniques and food nutrition as practiced by restaurants active member of the Food Industry Advisory Board for the Pan Association. In 2009, she was the recipient of the Entrepreneur-of-the- Betty Gilbreath, company founder and president, grac and has several years of food service expert of the Chicago area's top restaurants Her family owns a that sells primarily to distributors, and ut almost every phase of the family business. She has the extensively, studying food service techniq worldwide. She is an active member of the American Restaurant Association. In 2009, she Year award from the Cincinnati Restaurant Owners Association. Betty is the sole owner of the company. She tak e sole owner of the company. She takes a monthly draw that is not included in the wages & salaries expense. Employees All O'Betty's Red Holl employees and cart operators are screened for scholastic achievement (1.e., top 30 percent of students) and receive six hours of entry-level customer service training Cart managers must have a minimum of one year of experience and training with the company Wages were a little too high in 2015 as a percent of sales. O'Betty's expects it to be at the 20% level for the next three years. V. Financial Section ** This is the section you will write the narrative. The narrative is an summary of the financial worksheets explaining what happened, why, trends, etc. Appendix ** Pranare an appendix. All financial statements and worksheets must be in the appendix. It is best to have them in the order they are discussed in the narrative section VU L LETINU U U U Help = tome insert Draw Page Layout Arial 11-AA BLU- L O -A - Font - * $ 299998 Formulas Data Review View = D. 29 Wrap Text E Merge & Center - 5 Currency $ -% % Number %8-28 Condition Formatting Alignment Exp/Sales 100.00% 30.00% 70.00% Pro Forme 2017 56,000,000 $1,800,000 54,200,000 Exp/Sales 100.00% 30.00% 70.00% Pro Forme 2018 59,000,000 $2,700,000 56,300,000 Exp/Sales 100.009 30.00% 70.00% 5900.000 $27.000 59.000 10.00% 0.30% 0.10% Betty's Fast Food, Inc. Pro Forme YEAR Yr-end 2015 Exp/Sales 2016 SALES $1,800,000 100.00% $2.999,988 Cost of Goods $540,000 30.00% $899.996 GROSS MARGIN $1,260,000 70.00% 52,099.992 OPERATING EXPENSES Ads Promotion $180,000 10.00% $299,998 R&D $9,000 0.50% $15,000 Dues/Subscriptions $1,800 0.10% $3,000 Freight 57.200 0.40% $12,000 Insurance $18,000 1.00% 530,000 Maintenance $1,800 0.10% $3,000 Materials 590.000 5.00% $149,999 Miscellaneous $36.000 2.00% 560 000 Office Supplies CAM 004590.000 Outs de Services $18.000 1.00% $30.000 Accounting/legal $18.000 1.0096 $30.000 Lease Equipment $27.000 150% $45.000 Lease Facilities $27.000 1.50% $45.000 1000% 0.50% 0.10% 0.40% 100% 0.10% 5.00% 2.00% 3 0096 1.00% 1.00% 1.50% 1.50% $600,000 $18,000 $6,000 524.000 $60,000 $6.000 $300,000 $120.000 $180,000 560.000 560.000 590.000 590.000 10.00% 0.30% 0.10 0.40% 1.00% 0.10% 5.00% 2.00% 3.00% 1.00% 1.00% 150% 1.509 $90,000 $9.000 $450,000 590,000 $135.000 590.000 $72,000 $135.000 5135,000 1.00% 0.10% 5.00% 1.00% 1.50% 1.00% 0.00% 1505 Sheet to ave C H A O'Bett/s Income Statement 2015 and blank proforma (1) Sav Draw Formulas Data Review View Help Home Insert X Arial BTU- Page Layout 11 - A A - A. = Wrap Text Merge & Center Currency $ - % - -18 Conditional Forma Formatting Table Alignment Number X f 299998 $72,000 0.80% Accounting Legal Lease Equipment Lease Facilities Telephone $18,000 $27.000 $27,000 $9.000 $9.000 $9.000 $90.000 1.50% 1.50% 0 50% 0.50% 0.50% Trave Entertainment Utilities 5.00% Sales Commissions Wages and Salaries $30,000 $45,000 $45.000 $15.000 $15,000 $15.000 $149 999 $599.998 $1,607,993 $491,999 $18.798 $120,000 $323 201 1.00% 1.50% 1.50% 0.50% 0.50% 0.50% 5.00% 20.00% 53.609 16.40% 1.63% 4.00% 10.77% $60,000 $90,000 $90,000 $30,000 $30,000 $30,000 $300,000 $1.200.000 53,204.000 $996,000 $34.259 5180,000 $781.741 1.00% 150% 1.50% 0.50% 0.50% 0.50% 5.00% 20.00% 53 40% 16.60% 0.57% 3.00% 13.03% $135,000 $135,000 $45,000 $45.000 $45,000 $450.000 $1.800.000 $4,563,000 51,737.000 $12.679 $240,000 $1.483,322 1.50% 1.50% 0.50% 0.509 0.50% 5.00% 20.00% 50.70% 19.30% 0.15% 2.67% 16.48% $435 200 24.18% Total Expenses EBDIT Interest Expense Depreciation Expense Net Profit Before Tax $1,040,000 $220,000 $14,303 $10,960 $194.737 57.78% 12.22% 0.79% 0.61% 10.82% OR OS Home Insert Draw Page Layout Formulas Data Review View Help Paste Tahoma BIU - 11-AA OA == E 2 Wrap Text Merge & Center - Accounting $ - % Clipboard Font Alignment Number x .fo =246+D41+D37 D48 - 4 ALB un WN - Pro Forma Balance Sheet Betty's Fast Food, Inc. December 31, 2016 6 Assets 7 Current assets: 8 Cash 9 Investments 10 Inventories 11 Accounts receivable 12 Pre-paid expenses 13 Other 14 Total current assets 8,333.00 563,521.00 17,333.00 5.999,00 595,186.00 16 Fixed assets: 17 Property, carts,vehicles, furniture, and equipment 18 Leasehold improvements 19 New carts & equipment 20 Less accumulated depreciation 21 Net fixed assets 583.997.00 22,499.00 300,000.00 (10,000.00 896,496.00 23 other assets: 24 Goodwill 25 Total other assets Balance Sheet Oe ^ DS AutoSave File Home Insert Tahoma 8 blank balance sheet 2016 - Compatibility Mode Sav. Search Draw Page Layout Formulas Data Review View Help 11-AA == Wrap Text Accounting E- 0-A- 3 Merge & Center - $ - % 8 - LE - Paste Condi Forma Clipboard Alignment Number F G H D48 - X 046+041+037 4 A BI 29 Liabilities and owner's equity 30 Current liabilities: 31 Accounts payable 32 Employment taxes payable 33 Accrued compensation 34 Sales Taxes Payable 35 Current site leases 36 Current Maturities of Long-term debt 37 Total current liabilities 19,416.00 3,583.00 7.333.00 4.166.00 1.999.00 12,416.00 48,913.00 39 Long-term liabilities: 40 Commercial Term Loan 41 Total long-term abilities 1,096,812 1,096,812.00 43 Owner's equity: 44 Investment capital 45 Accumulated retained earnings Total owner's equity 235,957.00 235,957.00 48 1.381.682.00 Total liabilities and owner's equity $ Assets higher Difference: ($110.000.0) Balance Sheet Merge & Center - Conditional Formatas Formatting Table - Styles Styles Font Alignment MN BCDEFGT CASH FLOW ANALYSIS Year 2015 Betty's Fast Food, Inc. 8 9 10 11 12 Total 150,000 150,000 150,000 150,000 150.000 150.000 150.000 150.000 150,000 150,000 150,000 150,000 $1,800,000.00 $0.00 Sales Sales 2 Less Returns Total Sales $150,000 $150,000 $150,000 $150.000 $150.000 $150.000 $150.000 $150,000 $150.000 $150.000 $150.000 $150.000 $1.800.000,00 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 $1,800,000.00 $0.00 $0.00 $0.00 $1,800,000.00 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 7.500 7.500 7.500 7,500 7.500 7.500 7,500 7.500 7,500 Cash Receiptis 0.30 do 150,000 150,000 150,000 31-60 days 12 Over 60 days 13 Cash balance 14 Total $150,000 $150.000 $150,000 15 Disbursements: 16 Material Cost 7.500 7.500 7.500 17 Management Labor 36,367 36,367 36,267 Benefits 20 Advertising 15,000 15.000 15.000 Auto expense Contribution Chance cand Sheet1 Sheet2 Sheet3 3 6,267 36,267 36.267 36,267 36,367 16.267 36,267 18 16.161 16267 19 $90,000.00 $0.00 $415,204.00 $0.00 $100,000.00 $0.00 $0.00 $0.00 15.000 15.000 15.000 15.000 15,000 15,000 15.000 15.000 15.000 %,. Calibri 1AA == BTU - 21-AA - EEE Font 5 23 Wup Text Merge a Center - General $ -% 9 - S 29 Conditional Formatas Cell Formatting Table Shes Insert Delete Form Algsent Nuwber PES EFG IM o 1.500 1.500 1,500 1,500 4,500 1.500 1,500 1.500 1.500 1.500 1,500 4500 1.500 1,500 1,500 1.500 1,500 4,500 1.500 1,500 4.500 1.500 1,500 4,500 1.500 1.500 1.500 1,500 4.500 4,500 4.500 4.500 4,500 4.500 250 50 Contribution Charge cand Payroll Tax France Legal Acer Office supplies 28 Materials Shoppe Freight 30 Telephone Une 32 Water 33 Tax/license 34 Internet 35 Travel Entertainment 36 Loan payment 37 Office Payment 38 Fixtures 39 Equipment 40 Total 41 NET CASH FLOW 42 CUMULATIVE N $0.00 $0.00 $0.00 $18,000.00 $18,000.00 $54,000.00 $0.00 $7,200.00 $9,000.00 $9,000.00 $0.00 $0.00 $0.00 $9,000.00 $365,604.00 $27,000.00 $0.00 $27.000.00 $1.249,000.00 600 750 750 0 0 0 750 30,467 2.250 0 0 750 30,467 2.250 0 750 30,467 2.250 0 750 30,467 2.250 0 750 30,467 2.250 30.467 2.250 30,467 2.250 30,467 2.250 750 30467 2.250 750 30.467 2.250 30.467 2.250 30 457 2.250 2.250 $104,034 $45.916 $45.916 2.250 $104084 $45.916 591.832 2.250 5104,034 45.916 $137,743 2.250 $104,084 45.916 $183,664 2.250 2.250 5104081 5104034 $45.916545.916 $229,580 $275,496 2.250 $104,084 $15.916 5321,412 2350 5104,084 45.916 5367 328 2250 5104034 $45.916 5413.244 2250 $104034 545.916 5459,160 2250 2250 $104,034 $104,034 545.916545.916 505,076 5550992 Sheet1 Sheet2 Sheet3 OBH e os -111-AAEE 2 Wrap Test Arial Number BI - - -A E EE Merge & Center - $ - %88 Font Alignment Number * v f -32875 DIE Betty's Fast Food, Inc. Balance Sheet as of 12/31/2015 Assets Liabilities Current assets Current liabilities Cash . $5,000 Accounts payable $11,650 Short-term notes Accounts receivable payable entory 10,400 Long-term n Long-term notes 7.450 payable Prepaid expenses payable 1,200 Temporary investments Sales taxes payable 2500 Total current assets $19.000 Employment taxes payable 2150 Long-term assets Accrued payroll 4,400 Total current real property S185,000 liabilities $29,350 vehicles 38 000 Long-term Babilities vending carts 120.000 Vending cart loans $32.000 food preparation 24,356 equipment loan 26,750 food storage Balance Sheet 2015 3.600Current site leases Oon - Partial 2015 Balance Sheet Betty's 1. sav. Home Insert Draw Page Layout Formulas Data Review View Help E Number Arial B IU 11-AA - - A. 29 Wrap Test Merge & Center - $ - % 28 29 Font Alignment Number X x -32875 $32,000 26.750 vehicles 1 vending carts food preparation equipment food storage equipment furniture and equipment (less depreciation) Total long-term assets TOTAL ASSETS D 3 8,000 Long-term liabilities 120,000 Vending cart loans Mobile storage vehicle Joan 13,500 Mortgage 7,400 liabilities -32,875 Total liabilities $355,375 Owners equity Total long-term 144,700 $203,450 $232,800 $141,575 $374 375 TOAL LIABILITIES & DE $374 375 Fillin A,B,C,D,&E Balance Sheet 2015 Insert Draw P age Layout Formulas Data Help Review View Wrap Test Merge Center - Times New Roman - 10 -AA - BTU 1-0-A-EEEEE Number $ - % Conditional Formulas Cell Formatting Table Styles Styles Clipboard Font Alignment Number 1 X LM Year 2016 Betty's Fast Food, Inc. 11 12 Total" 1 CASH FLOW ANALYSIS 2 Month: 3 Sales: Sales 249 999 Sales 6 Less Returns 7 Total Sales $249,999 249 999 2 09999 209.999 249 999 249 999 249 999 249.999 249.999 249.999 249,999 249,999 $299, 00 $0.00 $249,999 $249 999 $249,999 $249 999 $249,999 $249,999 $249,999 $249.999 $249.999 $249,999 $249,999 $2.999,900.00 249,999 249.999 249.999 249,999 249,999 349.999 349.999 249,999 119 000 319.999 249,999 249.999 249.999 12 $2,999,988.00 $0.00 $0.00 $0.00 $2,999,988.00 $249,999 $249.999 $249.999 $249.999 $249.999 $249,999 $349,999 $249.999 $249,999 $349.999 $249,999 $249,999 1 2,500 12.500 12,500 12,500 12.500 2.500 12,500 12,500 12,500 12.500 12,500 2,500 Cash Recipes 10 0-30 d 11 31-60 days Over 60 den 13 Cash balance 14 Total 15 Disbursements: 16 Material Cost 17 Management Labor Benefits Achertising to experie Contributor Charge care Sheet1 50,000 50,000 30000 30,000 50,000 50,000 50,000 50,000 50,000 50.000 50 000 000 2,500 2,500 2,500 2,500 2,500 2.500 2.500 2.500 2.500 2.500 2,500 2,500 $149,999.04 $0.00 $599,997.96 $0.00 $29.997.96 $0.00 $0.00 $0.00 Sheet2 Sheet3 Home Insert Draw P age Layout Formulas Data Review View Help Number Times New Roman - 10 - AA BTU - - -A- Wrap Text Merge Center - $ % & 3 Insert Delete Forma Conditional Formatas Cell Formatting - Table - Styles Styles Font Alignment Number 1 X & B C D E F G H I 0 2,500 2,500 2.500 2.500 2,500 2,500 7.500 2,500 2.500 7.500 2,500 2.500 7.500 2,500 2,500 7500 2,500 2,500 2.500 2.500 2.500 2,500 2500 7,500 2.500 7.500 2.500 7,500 2.500 7,500 7.500 7.500 1.000 1.000 1.000 1,000 1.250 1.000 1,250 1,250 1.000 1,250 1,250 1.000 1,250 1.250 1.000 1,250 1.250 1,250 1.250 1.000 1,250 1.250 Charge card Payroll Tax Insurance Legal Acer Office supplies era Shoppplus Freight Telephone Utilities Water To/Ticarse Internet Travel Er men Loan payment Office Payment Faxe Equipment Total 1.000 1.250 1,250 1.000 1.250 1,250 250 1,250 1,250 1,250 $0.00 $0.00 $30,000.00 $30,000.00 $90,000.00 $0.00 $12,000.00 $15,000.00 $15,000.00 $0.00 $0.00 $0.00 $15,000.00 $0.00 $45,000.00 $0.00 $45,000.00 $1,076,994.96 1.250 12 1.250 1.250 1.250 1.250 1.250 1.250 1,250 1,250 1250 1250 3,750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3.750 3,750 $89,750 $160.249 $160,249 3.750 589,750 $160,249 $320,499 3,750 589,750 $160,249 5480,743 3,750 3.750 3.750 3.750 3.750 $89,750 $89.750 $89.750 $89.750 $89,750 $160,249 $160.3495160,240 $160,249 $160,249 5640.9985801,247 3961,497 51,121.746 51.281,995 3,750 $89,750 $160,349 $1,442,245 3,750 $89,750 5160,200 $1,602,494 3.750 3.750 $89,750 $89.750 $160,249 $160,349 $1,762,741 $1,922,993 NET CASH FLOW CUMULATIVE Cells Locked Sheet1 Sheet2 Sheet3 H57 X fx BCDEFG EXHIBITS: INPUT DATA Betty's Fast Food, Inc. Table IC4.1 Balance Sheets Actual 2015 Proforma 2016 $ Assets Cash Prepaid Expenses Inventories Total current assets Gross fixed assets Less: accumulated depreciation Net fixed assets Total assets 5,000 $ 8,333 3,600 6,000 10,400 17,333 19,000 $ 31,666 388,250 647,081 32,875 54,791 355,375 $ 592,290 374,375 $ 623,956 $ Liabilities and equity Accounts payable, site leases due, sales taxes Accruals Notes payable Total current liabilities Long-term vending cart loan, mobile storage Vehicle Mortgage Equity Total common equity Sheet1 O e