FINANCIAL INFORMATION Available Funds
• Balance in the bank • Gif t from grandmother • Loan f rom relatives and friends
o This is to be paid by the end of the second year of operation with 5% interest.
Future Funds You will need to raise funds from investors. You will determine this based on how much you plan to grow the business. Reminder:
• You will need to pay taxes. • You will determine sales projections.
Capital Investments Worksheet
Cash Flow Statement Worksheet Sales Projections Worksheet
Guide to Complete the Business Plan Financials Excel Template The Business Plan Financials Excel Template is the base pro-forma financial statement for your business. Complete the worksheets in order.
Worksheet Data Entry Worksheet #1: Set Up and Assumptions Line 9–Enter the month the academic quarter starts.
Line 12—Enter the year the academic quarter starts. Line 15–Enter 2; you choose the number of product lines you will have up to 10 lines. Line 21—Standard default is 30 days; you may adjust this for your business. Line 43—Enter $15,000; this is the money you currently have in the bank.
Worksheet #2: Sales Projections Speculate how much your company will grow and how much you will sell. Ref lect this information in the Operations Section of your Business Plan (Week 5 Discussion and Week 8 Assignment). You need to reach sales of over $1 million by the end of the second year.
Worksheet #3: Inventory (Adjust These Figures Line 7– Enter the cost of ingredients. As Needed) Line 8—Enter the cost of bags.
Line 9—Enter the cost of cartons to package the products. Repeat these three lines for each product line.
Worksheet #4: Capital Expenditures (applies to purchased NOT leased equipment)
Insert the cost of the equipment, vehicles, computers, et cetera, you decide to purchase.
Worksheet #5: Staffing Budget Account for every paid employee using the appropriate lines for the six categories of employees
1. Management 2. Administrative/Support 3. Sales/Marketing 4. Operations/Production 5. Other 6. Part-Time/Hourly
Indicate when their employment will start according to the Operations and Management and Organization sections of your business plan.
Worksheet #6: Marketing Budget Enter the cost for the marketing vehicles you plan to use. (Discussion 4 and Assignments 2 and 3).
Worksheet #7: Professional Services Line 6—Enter $3,000.00. Line 7–Enter $2,500.00. Line 9—Enter $2,000.00 Line 11—Enter $10,000.00 (f irst year only)
Worksheet Data Entry Worksheet #8 Capital Investments Worksheet Equity Capital Investments
Line 6—Gif t—Enter $50,000.00. Loans (Friends and Family) Line 24–$30,000 Note: The loan period = 24 months; interest rate = 5%
Worksheet #9: Income Statement Enter the cost of your expenses; see Business Expenses in the table that appears under the Specific Business Details section of these guidelines.
Worksheet #10: Cash Flow Statement Pay off taxes. Worksheet #11: Balance Sheet This will automatically populate from the other completed worksheets.
Resources on the Snack Food Industry
These resources are a good starting point for you as being researching the snack food industry.
C. Barnes. 2020. 2020 U.S. industry & market report–NAICS 31191: Snack food manufacturing, 1–196.
Jan Conway. 2018. U.S. Snack Foods Industry—Statistics & Facts. Statista. https://www.statista.com/topics/1496/snack- foods/
Patrick Limdico. 2019. 47 Snack Food Industry Trends and Consumption Statistics. Foodtruck Empire. https://foodtruckempire.com/news/snack-food-industry/
Douglas J. Peckenpaugh. 2019. State of the Industry 2019: Defining the Future of Snacking. SF&WB. https://www.snackandbakery.com/articles/93232-state-of-the-industry-2019-defining-the-future-of-snacking
L. Petrak. 2019. Mindful Munching: The Evolution of Mealtime Is Fueling the Trend Toward New Kinds of Nibbles. Progressive Grocer, 98(5), 50–54.
Statisa. No date. Consumer Market Outlook: Snack Food; United States. https://www.statista.com/outlook/40110000/109/snack-food/united-states
Mordor Intelligence. No date. Snack Food Market—Growth, Trends, and Forecasts (2020–2025). https://www.mordorintelligence.com/industry-reports/snack-food-market
- SNACK FOOD COMPANY GUIDELINES
- Key Business Plan Parameters
- Specific Business Details
- Guide to Complete the Business Plan Financials Excel Template
- Resources on the Snack Food Industry