BUS599 Strayer University Company Description and SWOT Analysis

User Generated

tvkkre1e07

Business Finance

BUS599

Strayer University

Description

In this assignment, you will create a revised company description and mission statement based on the feedback you received in the Week 1 discussion. Then, you will conduct a SWOT (strength, weakness, opportunity, and threat) analysis for the type of beverage you have selected and for your company. As you work on the assignment, consider why you have chosen one type of non-alcoholic beverage over another and the reasons for that choice. As you complete your SWOT analysis, be sure to include external factors such as industry/market trends and competition, and internal factors such as your capabilities or abilities to reach certain market segments. 

Write a 3–5-page paper in which you do the following:

  1. Create your revised Non-Alcoholic Beverage (NAB) company name and explain the name’s significance to you. Describe a NAB that you would produce and sell.
  2. Develop your revised company’s mission statement and provide a rationale for its components.
    • Hints: Use the Statement of Mission template on pages 72–73 of the course textbook, Successful Business Plan, to aid your development.
    • Extract appropriate information from the NAB Company Portfolio, where applicable. You should fill in other required items in the template using your personal preferences. 
  3. Describe the trends in the non-alcoholic beverage industry, especially the specific type of beverage category you have chosen. 
    • Hints: Research and outline beverage industry trends. Consider the size and growth rate of the industry overall and the specific beverage type you have chosen. Use the worksheet in the course text (p. 88 | Past and Future Growth of Your Industry) to help you project the future growth rate. Consider the use of industry associations and search engines to find reliable and recent data.
  4. Choose one strategic position from the course text (pp. 142–143) that you believe is the best strategic position for your company. Explain the approach you will use to implement this strategic position in order to distinguish your beverage from other non-alcoholic beverages.
  5. Provide an overview of your company’s distribution channels. Explain the manner in which your product will reach end users. Provide a rationale for your chosen method.
    • Hints: For example, will you sell your beverage in grocery stores, restaurants, or sports venues? If so, describe the types of resellers and distributors who will sell to resellers and fulfill their orders. If you are attempting to sell directly to consumers, for example, online via a monthly subscription, how will you manage warehousing/fulfillment/shipping?
  6. Outline at least three types of risks (including any regulatory risks) that your business faces. Describe your company’s plan to mitigate such risk.
    • Hints: You may refer to the types of risk listed in the course text (pp. 148–149) as well as any risks not listed in the text. Regulation weighs more heavily on beverage and food businesses than many other types of companies, so be certain to consider any regulatory risks your type of beverage faces. For example, what kind of regulation and/or risks are you likely to face if you make health claims about your beverage?
  7. Develop a SWOT analysis for your NAB company using the SWOT matrix worksheet in the course text (p. 153 | SWOT: Strengths/Weaknesses/Opportunities/Threats). 
    • Hints: What are your company’s likely strengths? Have you chosen a beverage segment that is growing and lacks an entrenched competitor? Are you in a niche market that has great potential? What are the strengths that you and other team members bring to your company? Do you or other team members have previous experience in the food and beverage industry? 
    • Hints: What are your company’s likely weaknesses? Is the competition in your industry segment entrenched? Is your own management team inexperienced? Will it be challenging to actually produce your product and maintain quality? 
    • Hints: What are your company’s opportunities? Does your segment have more demand than supply? Have larger corporations stopped serving smaller or niche markets that you could enter? Is a new market emerging because of demographics, immigration, and changing tastes? 
    • Hints: What are your company’s threats? Is there a clear market leader that will be hard and expensive to displace? Are downward-pricing pressures in the segment making profit margins slim? Are there little or no barriers to entry for new competitors? if you have a novel idea that succeeds, can the competition easily enter your market? If you have a global aspect to your company, do factors such as currency fluctuations, political instability, offshoring, or outsourcing pose threats?
  8. Format your assignment according to these formatting requirements:
    1. Cite the resources you have used to complete the exercise. Note: There is no minimum requirement for the number of resources used in the exercise. 
    2. The paper must be typed, double-spaced, using Times New Roman font (size 12), with 1-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
    3. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length. 

The specific course learning outcome associated with this assignment is:

  • Develop a company overview and SWOT analysis that include trends, strategic positioning, distribution channels, and risks.

Unformatted Attachment Preview

Running head: NON-ALCOHOLIC BEVERAGES BUSINESS OPPORTUNITIES Non-Alcoholic Beverages Business Opportunities Student’s Name: Institutional Affiliation: 1 NON-ALCOHOLIC BEVERAGES BUSINESS OPPORTUNITIES Non-Alcoholic Beverages Business Opportunities Non-alcoholic drinks business includes hot and soft beverages. Usually, the soft drinks comprise carbonated and non-carbonated water, flavors, and sweeteners, while the hot drinks broadly include tea and coffee. Generally, soft beverages dominate the global market. Although many countries have embraced the non-alcoholic beverages businesses, there are still some opportunities present. The first opportunity is diversification. Correspondingly diversification occurs when there are new products in the market. Although various hurdlers affect diversification, it influences a significant growth in the long run. Diversification opportunity in food and health will improve the offerings of non-alcoholic beverages to consumers. Diversification will introduce options and variation of commodities that capture whole the market leading to more earnings. While diversification results in a variety of products, developing countries indicates another significant opportunity. Although there is the presence of many alcoholic beverages in developed countries, there is a slow growth towards establishing health drinks. Ensuring the drinks contain the right nutrients will increase business growth. Correspondingly, developing countries are still new to the delight of soft and carbonated drinks. Countries such as India in summer season requires more cold beverages. Therefore, the high consumption of these soft drinks is an excellent opportunity to capitalize on the non-alcoholic beverage business. Lastly, marketing lesser selling commodities is a vivid opportunity. Many beverages business focus on high products. Water, for example, is a product that this beverage business 2 NON-ALCOHOLIC BEVERAGES BUSINESS OPPORTUNITIES aims to focus into as well as companies forget it. The non-alcoholic beverage business will market such products to raise more revenue to excel in this strategy. In retrospect, non-alcoholic beverage business present crucial opportunities that if well pursued, they will contribute to significant growth of the business. Many people prefer nonalcoholic drinks that are contributing to the high demand in the market. Equally, there is a massive surge in need for soft drinks in the sports and energy drink segment. All these opportunities show non-alcoholic beverage business is the best industry to invest. 3 Your Company Name WARNING! IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED. Excel 2010 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 and Excel 2013 on Windows - Enabling Macros" Excel 2013& 2016 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 & Excel 2013 on Windows - Enabling Macros" Excel 2011 & 2016 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use. Your Company Name Excel 2013 and Excel 2016 on Windows - Enabling Macros Your Company Name WARNING! XCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED. rity Warning that appears at the top of this page. ng the top of this page, scroll down for more detailed instructions, under nabling Macros" rity Warning that appears at the top of this page. ng the top of this page, scroll down for more detailed instructions, under bling Macros" Your Company Name Excel 2016 on Windows - Enabling Macros Note: The procedure is exactly the same for Excel 2013 & 2016, even though the two versions look slightly different. 1. In the upper left corner of the Excel Ribbon, press the "File" tab. 2. Select Options, in the lower left corner. 3. Select Trust Center from the Lower Left. 4. Click the "Trust Center Settings…" button in the lower right 5. Select "Macros Settings" from the left side menu 6. Select the "Disable all macros except digitally signed macros" radio button. 7. Click "OK" twice Welcome to Business Plan Financials! Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies , by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. First, a few tips to get you started: SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIG_PlanningShop_BizPlanFin(2.8)" file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy. NAVIGATING THE WORKSHEETS You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that contains controls to let you navigate between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same. Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel. Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac: In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window. HOW TO FILL IN THE WORKSHEETS Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically calculated for you. While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on. FOR MORE HELP For more in-depth help and assistance,please refer to the companion PDF entitled "Business Plan Financials Help". It contains extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business. About Our Support of Mac vs. Windows PlanningShop supports Business Plan Financials on the following platforms: Windows 1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365 2. Microsoft Windows 8 or later with Microsoft Excel 2013 Mac 4 Mac OS X with Microsoft Excel 2016 5. Mac OS X with Microsoft Excel for Mac 2011 Version 3.1 Copyright © 2003-2017 PlanningShop Setup Assumptions Setup and Assumptions COMPANY INFORMATION What is your company's name? Your Company Name What month will you officially start your company? January What year will you officially start your company? 2017 SALES ASSUMPTIONS The Worksheets can accommodate sales projections for up to 10 major product/service lines. How many major product/service lines do you plan to have for your business? Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit? For sales you make on credit, what terms will you extend? In other words, how many days will pass from the date of sale to when you expect to be paid? T e n Ten 25% 30 PERSONNEL ASSUMPTIONS Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)? $5,000 Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)? $36 With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year? 5.00% If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by? 3.50% Approximately what percentage of each employee's salary or wages do you plan to set aside for payroll taxes? FINANCIAL ASSUMPTIONS What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements. At approximately what rate do you expect to be taxed on your net income? If you will use an interest-bearing account for your banking, at what rate will you accrue interest? Page 8 of 71 15.00% $5,000 25.00% 1.00% Setup Assumptions Page 9 of 71 Sales Projections Sales Projections 2017 Assumptions Product Line 1 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 2 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 3 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 4 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 5 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 5.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% January 2018 February March April May June July August September October November December 0 $0.00 $0 $0 $0.00 $0 $0.00 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0.00 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 6 Page 10 of 71 TOTAL January 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2017 Assumptions Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 7 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 8 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 9 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 10 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Totals for All Product Lines Total Unit Volume Total Gross Sales 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2018 January February March April May June July August September October November December TOTAL January 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 Page 11 of 71 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2017 Assumptions (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT 2018 January $0 $0 $0 $0 $0 February $0 $0 $0 $0 $0 March April $0 $0 $0 $0 $0 May $0 $0 $0 $0 $0 June $0 $0 $0 $0 $0 Page 12 of 71 July $0 $0 $0 $0 $0 August $0 $0 $0 $0 $0 September $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 October $0 $0 $0 $0 $0 November $0 $0 $0 $0 $0 December $0 $0 $0 $0 $0 TOTAL January $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2019 February March April May June July August September October November December Product Line 1 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 Product Line 2 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 3 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 4 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 5 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 6 Page 13 of 71 TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2019 February March April May June July August September October November December Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 7 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 8 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 9 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 10 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 Totals for All Product Lines Total Unit Volume Total Gross Sales Page 14 of 71 TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections 2019 February (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT $0 $0 $0 $0 $0 March April $0 $0 $0 $0 $0 May $0 $0 $0 $0 $0 June $0 $0 $0 $0 $0 July $0 $0 $0 $0 $0 August $0 $0 $0 $0 $0 September $0 $0 $0 $0 $0 Page 15 of 71 $0 $0 $0 $0 $0 October $0 $0 $0 $0 $0 November $0 $0 $0 $0 $0 December $0 $0 $0 $0 $0 TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2020 TOTAL Product Line 1 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 2 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 3 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 4 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 5 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Product Line 6 Page 16 of 71 TOTAL 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0.00 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2020 TOTAL Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 7 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 8 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 9 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0 0 $0 0 $0 0 $0 0 $0 Product Line 10 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Totals for All Product Lines Total Unit Volume Total Gross Sales 0 $0 0 $0 0 TOTAL Page 17 of 71 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 0 $0.00 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections 2020 TOTAL (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 18 of 71 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Inventory Inventory 2017 2018 January February March April May June July August September October November December TOTAL January February Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 2 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 3 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 5 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 6 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 7 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 19 of 71 Inventory Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 8 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 9 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 10 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 20 of 71 Inventory Inventory 2019 March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 2 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 3 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 5 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 6 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 7 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 21 of 71 Inventory Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 8 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 9 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 10 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 22 of 71 Inventory Inventory 2020 TOTAL 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 2 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 3 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 5 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 6 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 7 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 Page 23 of 71 Inventory Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 8 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 9 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Product Line 10 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 Page 24 of 71 Capital Purchases Capital Purchases Item Facilities Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) 1/1/2017 Purchase Date Cost Years of Service Salvage Value Reminder: All purchases must be on or after your business start date of: January-2017 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 1 1 1 1 1 1 1 1 1 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Equipment Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Computer Hardware/Software Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Telecommunications Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) $0 $0 $0 $0 $0 Jan Jan Jan Jan Jan 2017 2017 2017 2017 2017 1 1 1 1 1 $0 $0 $0 $0 $0 Land Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) Item Name (change name here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 Land is a non-depreciable asset Page 25 of 71 Staffing Budget Staffing Budget 2017 January February March April May June July August September October November December Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Page 26 of 71 Staffing Budget Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 27 of 71 Staffing Budget Staffing Budget TOTAL Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) $0 $0 $0 $0 Page 28 of 71 Staffing Budget Total Costs $0 TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS Page 29 of 71 $0 $0 $0 $0 Staffing Budget Staffing Budget 2018 January February March April May June July August September October November December Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Page 30 of 71 Staffing Budget Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 31 of 71 Staffing Budget Staffing Budget 2019 TOTAL 2020 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 0.0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 0 0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Page 32 of 71 Staffing Budget Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 33 of 71 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Staffing Budget Staffing Budget 2021 TOTAL Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.0 $0 $0 $0 $0 Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Page 34 of 71 0 0 $0.00 $0 $0 $0 $0 Staffing Budget Total Costs $0 TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS Page 35 of 71 $0 $0 $0 $0 $0 $0 Marketing Budget For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates from PlanningShop. Marketing Budget 2017 January Professional Assistance Marketing/PR Consultants Advertising Agencies Social Media Specialists SEO Specialist Graphic/Web Design Brochures/Leaflets/Flyers Signs/Billboards Merchandising Displays Sampling/Premiums Media Advertising Print (newspaper, etc.) Television and Radio Online Other Media Phone Directories Advertising Specialties Direct Mail Website Development/Programming Maintenance and Hosting Trade Shows Fees and Setup Travel/Shipping Exhibits/Signs Public Relations/Materials Informal Marketing / Networking Memberships/Meetings Entertainment Other GRAND TOTAL COSTS February March April May June July August September October November December TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 36 of 71 Marketing Budget Marketing Budget 2018 January Professional Assistance Marketing/PR Consultants Advertising Agencies Social Media Specialists SEO Specialist Graphic/Web Design Brochures/Leaflets/Flyers Signs/Billboards Merchandising Displays Sampling/Premiums Media Advertising Print (newspaper, etc.) Television and Radio Online Other Media Phone Directories Advertising Specialties Direct Mail Website Development/Programming Maintenance and Hosting Trade Shows Fees and Setup Travel/Shipping Exhibits/Signs Public Relations/Materials Informal Marketing / Networking Memberships/Meetings Entertainment Other GRAND TOTAL COSTS February March April May June July August September October November December TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 37 of 71 Marketing Budget Marketing Budget 2019 2020 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Professional Assistance Marketing/PR Consultants Advertising Agencies Social Media Specialists SEO Specialist Graphic/Web Design Brochures/Leaflets/Flyers Signs/Billboards Merchandising Displays Sampling/Premiums Media Advertising Print (newspaper, etc.) Television and Radio Online Other Media Phone Directories Advertising Specialties Direct Mail Website Development/Programming Maintenance and Hosting Trade Shows Fees and Setup Travel/Shipping Exhibits/Signs Public Relations/Materials Informal Marketing / Networking Memberships/Meetings Entertainment Other GRAND TOTAL COSTS TOTAL 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 38 of 71 Professional Services Budget Professional Services 2017 2018 2019 2020 2021 General Attorneys Accountants Management consultants Industry specialists Technology consultants Other (change title here) Other (change title here) Total Costs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 GRAND TOTAL COSTS $0 $0 $0 $0 $0 Page 39 of 71 Capital Investments and Loans Capital Investments and Loans Item Amount Equity Capital Investments Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Investment Source Name Total Capital Investments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Loans Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Loan Source Name Total Loans $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL INVESTMENTS AND LOANS $0 Page 40 of 71 Date Loan Period Interest Rate Month Year Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Capital investments Jan 2017 are not paid back on a loan schedule. Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan 2017 Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan Jan 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Capital Investments and Loans Reminder: All invesments & loans must be on or after your business start date of: January-2017 Page 41 of 71 Income Statements Page 42 of 71 Income Statements Income Statements 2017 January February March April May June July August September October November December TOTAL INCOME Gross Sales (Commissions) (Returns and allowances) Net Sales (Cost of Goods) GROSS PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EXPENSES - General and Administrative Salaries and wages Employee benefits Payroll taxes Professional services Marketing and advertising Rent Equipment rental Maintenance Depreciation Insurance Telephone service Utilities Office supplies Postage and shipping Travel Entertainment Interest on loans Other (change title here) Other (change title here) TOTAL EXPENSES Net income before taxes and interest Interest Income Provision for taxes on income NET PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $50 $0 $50 Page 43 of 71 Income Statements Page 44 of 71 Income Statements Income Statements 2018 January February March April May June July August September October November December TOTAL INCOME Gross Sales (Commissions) (Returns and allowances) Net Sales (Cost of Goods) GROSS PROFIT $0 $0 $0 $0 $0 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 EXPENSES - General and Administrative Salaries and wages Employee benefits Payroll taxes Professional services Marketing and advertising Rent Equipment rental Maintenance Depreciation Insurance Telephone service Utilities Office supplies Postage and shipping Travel Entertainment Interest on loans Other (change title here) Other (change title here) TOTAL EXPENSES Net income before taxes and interest Interest Income Provision for taxes on income NET PROFIT $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $1 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $51 $0 $51 Page 45 of 71 Income Statements Page 46 of 71 Income Statements Income Statements 2019 2020 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter INCOME Gross Sales (Commissions) (Returns and allowances) Net Sales (Cost of Goods) GROSS PROFIT EXPENSES - General and Administrative Salaries and wages Employee benefits Payroll taxes Professional services Marketing and advertising Rent Equipment rental Maintenance Depreciation Insurance Telephone service Utilities Office supplies Postage and shipping Travel Entertainment Interest on loans Other (change title here) Other (change title here) TOTAL EXPENSES Net income before taxes and interest Interest Income Provision for taxes on income NET PROFIT TOTAL 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $51 $13 $38 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $3 $10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $52 $13 $39 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $52 $13 $39 Page 47 of 71 Cash Flow Statements Cash Flow 2017 January CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS February March April May June July August September October November December $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 NET CASH FLOW $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $5,000 $4 $0 $5,004 $5,004 $4 $0 $5,008 $5,008 $4 $0 $5,013 $5,013 $4 $0 $5,017 $5,017 $4 $0 $5,021 $5,021 $4 $0 $5,025 $5,025 $4 $0 $5,029 $5,029 $4 $0 $5,033 $5,033 $4 $0 $5,038 $5,038 $4 $0 $5,042 $5,042 $4 $0 $5,046 $5,046 $4 $0 $5,050 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 48 of 71 Cash Flow Statements Cash Flow TOTAL CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS NET CASH FLOW $0 $0 $0 $50 $0 $0 $50 $0 $50 $0 $0 $0 $0 $0 $0 $0 $0 $0 $50 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 49 of 71 $5,050 Cash Flow Statements Cash Flow 2018 January CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS February March April May June July August September October November December $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 $4 $0 $0 $4 $0 $4 CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 NET CASH FLOW $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $5,050 $4 $0 $5,054 $5,054 $4 $0 $5,059 $5,059 $4 $0 $5,063 $5,063 $4 $0 $5,067 $5,067 $4 $0 $5,071 $5,071 $4 $0 $5,076 $5,076 $4 $0 $5,080 $5,080 $4 $0 $5,084 $5,084 $4 $0 $5,088 $5,088 $4 $0 $5,092 $5,092 $4 $0 $5,097 $5,097 $4 $0 $5,101 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 50 of 71 Cash Flow Statements Cash Flow TOTAL CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS NET CASH FLOW $0 $0 $0 $51 $0 $0 $51 $0 $51 $0 $0 $0 $0 $0 $0 $0 $0 $0 $51 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 51 of 71 $5,101 Cash Flow Statements Cash Flow 2019 2020 1st Quarter CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS NET CASH FLOW Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE 2nd Quarter 3rd Quarter 4th Quarter TOTAL 2021 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $51 $0 $0 $51 $0 $51 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $13 $0 $0 $13 $0 $13 $52 $0 $0 $52 $0 $52 $52 $0 $0 $52 $0 $52 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $13 $13 $13 $13 $51 $13 $13 $13 $13 $52 $52 $5,101 $13 $0 $5,114 $5,114 $13 $0 $5,127 $5,127 $13 $0 $5,139 $5,139 $13 $0 $5,152 $5,152 $5,152 $13 $0 $5,165 $5,165 $13 $0 $5,178 $5,178 $13 $0 $5,191 $5,191 $13 $0 $5,204 $5,204 $5,204 $52 $0 $5,256 Page 52 of 71 Cash Flow Statements Cash Flow CASH RECEIPTS Income from Sales Cash Sales Collections Total Cash from Sales Income from Financing Interest Income Loan Proceeds Equity Capital Investments Total Cash from Financing Other Cash Receipts TOTAL CASH RECEIPTS CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS NET CASH FLOW Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 53 of 71 Balance Sheet Balance Sheet Your Company Name First Quarter 2017 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,013 $0 $0 $0 $5,013 $0 $0 $0 $0 $0 $0 $0 $5,013 $0 $3 $0 $3 $0 $0 $0 $5,000 $9 $5,009 $5,013 Page 54 of 71 Balance Sheet Balance Sheet Your Company Name Second Quarter 2017 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,025 $0 $0 $0 $5,025 $0 $0 $0 $0 $0 $0 $0 $5,025 $0 $6 $0 $6 $0 $0 $0 $5,000 $19 $5,019 $5,025 Page 55 of 71 Balance Sheet Balance Sheet Your Company Name Third Quarter 2017 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,038 $0 $0 $0 $5,038 $0 $0 $0 $0 $0 $0 $0 $5,038 $0 $9 $0 $9 $0 $0 $0 $5,000 $28 $5,028 $5,038 Page 56 of 71 Balance Sheet Balance Sheet Your Company Name Fourth Quarter 2017 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,050 $0 $0 $0 $5,050 $0 $0 $0 $0 $0 $0 $0 $5,050 $0 $0 $0 $0 $0 $0 $0 $5,000 $50 $5,050 $5,050 Page 57 of 71 Balance Sheet Balance Sheet Your Company Name 2018 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,101 $0 $0 $0 $5,101 $0 $0 $0 $0 $0 $0 $0 $5,101 $0 $0 $0 $0 $0 $0 $0 $5,000 $101 $5,101 $5,101 Page 58 of 71 Balance Sheet Balance Sheet Your Company Name 2019 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,152 $0 $0 $0 $5,152 $0 $0 $0 $0 $0 $0 $0 $5,152 $0 $13 $0 $13 $0 $0 $0 $5,000 $139 $5,139 $5,152 Page 59 of 71 Balance Sheet Balance Sheet Your Company Name 2020 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $5,204 $0 $0 $0 $5,204 $0 $0 $0 $0 $0 $0 $0 $5,204 $0 $26 $0 $26 $0 $0 $0 $5,000 $178 $5,178 $5,204 Page 60 of 71 Balance Sheet Balance Sheet Your Company Name 2021 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets $5,256 $0 $0 $0 $5,256 Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS $0 $0 $0 $0 $0 $0 $0 $5,256 LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities $0 $39 $0 $39 Long-Term Liabilities Long-Term Notes Payable Other Long-Term Liabilities Total Long-Term Liabilities NET WORTH Paid-In Capital Retained Earnings Total Net Worth TOTAL LIABILITIES AND NET WORTH $0 $0 $0 $5,000 $217 $5,217 $5,256 Page 61 of 71 Break-even Estimates Break-even Estimates Year 1 (2017) January February March April May June July August September October November December Monthly Average Year 2 (2018) January February March April May June July August September October November December Monthly Average Year 3 (2019) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Quarterly Average $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Year 4 (2020) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Quarterly Average $0 Year 5 (2021) Annual Average $0 Page 62 of 71 $0 $0 $0 $0 Key Ratios Key Ratios Year 1 (2017) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Working Capital Current Ratio $5,009 1,602.67 $5,019 802.33 $5,028 535.56 $5,050 N.A. Quick Ratio 1,602.67 802.33 535.56 N.A. Cash Turnover 0.00 0.00 0.00 0.00 Debt to Equity 0.00 0.00 0.00 0.00 Return on Investment 0% 0% 0% 0% Return on Sales N.A. N.A. N.A. N.A. Return on Assets 0% 0% 0% 0% Year 2 (2018) $5,101 N.A. N.A. 0.00 0.00 0% N.A. 0% Year 3 (2019) $5,139 402.50 402.50 0.00 0.00 0% N.A. 0% Year 4 (2020) $5,178 202.26 202.26 0.00 0.00 0% N.A. 0% Year 5 (2021) $5,217 135.68 135.68 0.00 0.01 0% N.A. 0% Page 63 of 71 Year 1: Financials at-a-Glance (2017) $4 $3 $3 $2 Gross Sales $2 Gross Profit Net Profit $1 $1 Page 64 of 71 December November October September August July June May April March February January $0 Year 1: Net Sales (2017) $1 $1 Product Line 10 $1 Product Line 9 $1 Product Line 8 $1 Product Line 7 $1 Product Line 6 $0 Product Line 5 Product Line 4 $0 Product Line 3 $0 Product Line 2 $0 Product Line 1 Page 65 of 71 December November October September August July June May April March February January $0 Year 1: Cash Flow (2017) $6,000 $5,000 $4,000 $3,000 Net Cash Flow Ending Cash Balance $2,000 $1,000 Page 66 of 71 December November October September August July June May April March February January $0 Year 2: Cash Flow (2018) $6,000 $5,000 $4,000 $3,000 Net Cash Flow Ending Cash Balance $2,000 $1,000 Page 67 of 71 December November October September August July June May April March February January $0 5-Year Financials at-a-Glance $60 $50 $40 Gross Sales $30 Gross Profit Net Profit $20 $10 $0 2017 2018 2019 Page 68 of 71 2020 2021 5-Year Net Sales $1 $1 $1 $1 Product Line 1 Product Line 2 Axis Title $1 Product Line 3 Product Line 4 Product Line 5 $1 Product Line 6 Product Line 7 $0 Product Line 8 Product Line 9 $0 Product Line 10 $0 $0 $0 2017 2018 2019 Page 69 of 71 2020 2021 License Agreement LICENSE AGREEMENT FOR PLANNINGSHOP’S BUSINESS PLAN FINANCIALS This License Agreement is a legal agreement between you (the product purchaser/user) and PlanningShop for the Business Plan Financials product (“Software”) that accompanies this Agreement, including all associated documentation and packaging. By installing and/or using the Software, you accept the terms of this Agreement. PRODUCT LICENSE The Software is protected by intellectual property laws and treaties. It is owned by PlanningShop and licensed to you for your use (not sold). You acknowledge that PlanningShop has conferred to you NO title or ownership of the Software or any of its constituent parts. Re-distribution of the Software or any of constituent its parts, whether in an original or modified form, is strictly forbidden. 1. General License. You may install one copy of the Software on a single computing device for use by a single user. Additional users, whether using the same computing device or a separate device, must purchase additional licenses. Multi-user licenses are available from PlanningShop. A second copy of the Software may be stored on a separate device for the sole purpose of backing up the original copy. You may not copy, distribute, or resell the Software. 2. Unauthorized Use. You may not modify, disassemble, or reverse engineer the Software or its code for any form of distribution. The Software, its content, design and programming are copyrighted by PlanningShop. 3. WARRANTY. THIS SOFTWARE IS PROVIDED AS IS. PLANNINGSHOP AND ITS AFFILIATED PARTIES MAKE NO CLAIMS, PROMISES OR GUARANTEES ABOUT THE ACCURACY, COMPLETENESS, OR ADEQUACY OF THE SOFTWARE FOR ANY PURPOPSE AND EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS, OMISSIONS, FAILURES, OR DEFECTS. NO WARRANTY OF ANY KIND, IMPLIED, EXPRESS OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND FREEDOM FROM COMPUTER VIRUS, IS GIVEN IN CONJUNCTION WITH THE SOFTWARE. 4. DAMAGES. IN NO EVENT WILL PLANNINGSHOP BE LIABLE FOR ANY DAMAGES, INCLUDING WITHOUT LIMITATION DIRECT OR INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, LOSSES OR EXPENSES ARISING IN CONNECTION WITH THIS SOFTWARE OR USE THEREOF OR INABILITY TO USE BY ANY PARTY, OR IN CONNECTION WITH ANY FAILURE OF PERFORMANCE, ERROR, OMISSION, DEFECT, OR COMPUTER VIRUS EVEN IF THE PLANNINGSHOP, OR AFFILIATED PARTIES, ARE ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, LOSSES OR EXPENSES. 5. Governing Law. This Agreement shall be treated as though it were executed and performed in Palo Alto, California, and shall be governed by and construed in accordance with the laws of the State of California, USA (without regard to conflict of law principles). All actions shall be subject to the limitations set forth in Section 3 and Section 4. The language in this Agreement shall be interpreted as in accordance with its fair meaning and not strictly for or against either party. All legal proceedings arising out of or in connection with this Agreement shall be brought solely in Palo Alto, California. You expressly submit to the exclusive jurisdiction of said courts and consent to extraterritorial service of process. Should any part of this Agreement be held invalid or unenforceable, that portion shall be construed consistent with applicable law and the remaining portions shall remain in full force and effect. 6. Contact. Should you have any questions concerning this agreement, or if you desire to contact PlanningShop for any reason, you may do so at: PlanningShop, 555 Bryant Street #180, Palo Alto, California, USA, 94301. About Business Plan Financials PlanningShop Business Plan Financials Version 3.1 SUBJECT TO END-USER LICENSE AGREEMENT Copyright 2003-2017 PlanningShop. All rights reserved. www.planningshop.com NON-ALCOHOLOIC BEVERAGE COMPANY PORTFOLIO Table of Contents Note #1 (Company Parameters) ................................................................................................................................ 4 Note #2 (Equipment & Inventory).............................................................................................................................. 5 Note #3 (Personnel, Business Expenses, & Financial Matters) .................................................................................. 7 Note # 4 (Websites - Data & Statistics) ...................................................................................................................... 9 Note # 5 (Market Research) ..................................................................................................................................... 10 A guide to the non-alcoholic beverage industry .............................................................................................. 10 Industry overview .............................................................................................................................................. 10 Dominant carbonates category ......................................................................................................................... 10 Major companies ................................................................................................................................................ 10 Understanding consumer craving for soft drinks ........................................................................................... 11 What’s a soft drink made of? ............................................................................................................................ 11 Stimulants in soft drinks.................................................................................................................................... 11 Ingredient facts................................................................................................................................................... 12 Understanding the value chain of the soft drink industry .............................................................................. 12 Industry Partners ............................................................................................................................................... 12 Bottling and distribution network .................................................................................................................... 13 Distribution: Third-party products .................................................................................................................. 13 Pricing power...................................................................................................................................................... 13 Key indicators of the non-alcoholic beverage industry................................................................................... 14 Factors influencing sector growth .................................................................................................................... 14 Consumption expenditure ................................................................................................................................. 14 Disposable income and consumer confidence .................................................................................................. 14 Understanding the soft drink industry’s key markets .................................................................................... 15 Income bracket ................................................................................................................................................... 15 Hispanics ............................................................................................................................................................. 16 Millennials........................................................................................................................................................... 16 Teens.................................................................................................................................................................... 16 Updated 2/26/2016 1 NON-ALCOHOLOIC BEVERAGE COMPANY PORTFOLIO The role of branding and advertising in the soft drink industry ................................................................... 17 The importance of advertising .......................................................................................................................... 17 Global brands ..................................................................................................................................................... 17 Strong individual brand portfolios ................................................................................................................... 17 Investing in brands............................................................................................................................................. 18 Why the soft drink industry is dominated by Coke and Pepsi....................................................................... 18 A rivalry for the ages ......................................................................................................................................... 19 Threat from new entrants ................................................................................................................................. 19 Significant investments ...................................................................................................................................... 19 Why growth is sluggish in the non-alcoholic beverage industry .................................................................... 20 Falling demand ................................................................................................................................................... 20 Key indicator—per capita consumption .......................................................................................................... 20 Health concerns .................................................................................................................................................. 21 The soda tax ........................................................................................................................................................ 21 In challenging times, soft drinks makers optimize and thrive ....................................................................... 21 Productivity measures ....................................................................................................................................... 21 Cost-cutting initiatives ....................................................................................................................................... 22 Soft drink industry now looking to still beverages to boost sales .................................................................. 22 Social pressures forcing change ........................................................................................................................ 23 Ready-to-drink beverages ................................................................................................................................. 23 International growth opportunities for the soft drink industry..................................................................... 24 Beyond borders .................................................................................................................................................. 24 Growth prospects ............................................................................................................................................... 25 Positive trends .................................................................................................................................................... 25 Competition outside the domestic market ....................................................................................................... 25 Strategic deals in the soft drink industry ......................................................................................................... 26 Industry alliances ............................................................................................................................................... 26 Recent Pepsi and Coca-Cola deals .................................................................................................................... 26 Other deal-making in the sector ....................................................................................................................... 27 Investing in soft drink companies with ETFs .................................................................................................. 27 Packaged investing ............................................................................................................................................. 27 Consumer staple ETFs....................................................................................................................................... 28 Updated 2/26/2016 2 NON-ALCOHOLOIC BEVERAGE COMPANY PORTFOLIO Note # 6 (History & Industry Data/Forecasting & Technology) ............................................................................... 29 Cognitive health appeals to all demographics ................................................................................................. 29 Omega-3s popular ingredient for brain health................................................................................................ 29 Mental energy ..................................................................................................................................................... 30 Focus on claims................................................................................................................................................... 32 2016 New Product Development Outlook for beverages ................................................................................ 32 Organic named top trend for new beverages in new year .............................................................................. 32 Buzzing about flavors .................................................................................................................................... 33 Creating success ............................................................................................................................................. 35 Natural influence ............................................................................................................................................ 35 Sharing the work ............................................................................................................................................ 36 2016 expectations................................................................................................................................................ 38 Beverage Industry launches new app ............................................................................................................... 39 Introductory video shows how to use Bev Industry Mobile ....................................................................... 39 (The NAB Company Portfolio will have lists of things that the BUS599 students would be able to sort through to conduct a SWOT Analysis and to apply to appropriate sections of the NAB Business Plan.) Updated 2/26/2016 3 NON-ALCOHOLOIC BEVERAGE COMPANY PORTFOLIO Note #1 (Company Parameters) This is the compilation of Data, Notes, and Information that have been put together to create a Business Plan, along with Pro-forma Financial Statements, for a start-up company in the non-alcoholic beverage industry. The goal of my business plan is twofold: 1 2 To help identify and outline all the issues I will need to address in starting this company. To present to funders to help raise money to finance this company. NAB Background: Melinda Cates has been selling her NAB at County Fairs for the past 7 years for $2 a bottle. She sells an average of 10 Cardboard cartons each weekend a County Fair is open. From her calculations, it takes $.56 to make a bottle of NAB when she calculates all the NAB ingredients and the cost of the bottle and cap. Her rich uncle, Bill, just died and left her a small monetary inheritance. However, since he so enjoyed her homemade NAB, he also left her equipment to start a small NAB business. Additionally, her uncle left her a facility that will allow growth to start the business. It has the potential for expansion in order to meet larger sales goals for the future. Melinda and I have been close, trusted friends for years. She knew I attended Strayer University and earned my MBA; so I agreed to assist her get the business up and running. I have agreed to put together a NAB Business Plan, and I have agreed to be the CEO/President of the company for at least the next five years. NAB Today: Parameters for New Company Here are the parameters in which I must work. The business is a start-up: We are not yet in operation. We already have a “recipe” for a beverage, but we are not yet making sales at any significant level. Product: the only barrier is that it must be a non-alcoholic beverage (NAB). It is up to me to decide upon what type of non-alcoholic beverage I intend to make and market. It can be sold in individual sizes or wholesale. Market size. I will start marketing and selling the NAB in my geographical area within a 100-mile radius from my home address. Business size. I can grow the NAB business to any size in excess of one million dollars in revenue by year two. In other words, this cannot be intended to be a one- or two-person micro-business. I intend to raise money. I will be looking for funding, and I have already started with friends and family money. However, at some point, I will need funds from outside investors, either angels or venture capitalists, depending on how much I project, I need to raise or receive from a group of individual investors on Kickstarter. I intend to have employees and develop my own organizational hierarchy. I do not need to raise money for my personal financial support for the first six months. In other words, I do not need to draw a salary for myself for the first six months of projections. Annual salary will be $55,002 1st year; adjusted to $110,004 2nd year; finally adjusted to $165,008 for all remaining years in position. Updated 2/26/2016 4 NON-ALCOHOLOIC BEVERAGE COMPANY PORTFOLIO Note #2 (Equipment & Inventory) The NAB Financial Worksheets will need to have the value of this equipment and inventory included. Some of the items we currently own: Owned Equipment: Two (2) NAB Mixer Beverage Filling Machines (mixes up to 200 gallons each) – $28,500 each (value in current $) The Mixer Beverage Filling machine is a rinsing, filling, and capping (3-in-1) Monobloc machine, imported from Italy. Because it is equipped with constant temperature controlling system, it can be applied to fill hot or cold fruit juice, tea and other beverage into 16 oz. bottles. It is suitable for normal temperature filling or hot filling 16 oz. bottles. It is one of the most advanced filling machine at present. Two (2) Accutek AccuSnap Capper Bottling machines (for capping bottles) - $9,600 each (value in current $) See Auto AccuSnap Capper, below. Four (4) Vehicles (used panel vans) – $10,000 each (value in current $) Three (3) Computers...
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

OUTLINE
1. Company Description
2. Safe Drink Company Mission
3. Market trends in the Beverage industry and Safe Drink Company
4. SWOT Analysis
5. Conclusion
6. Reference


Running head: NON-ALCOHOLIC BEVERAGE INDUSTRY

Non-Alcoholic Beverage Industry
Name
Institutional Affiliation
Instructor

1

NON-ALCOHOLIC BEVERAGE INDUSTRY

2

Non-Alcoholic Beverage Industry
Company description
Safe Drink Company is a non-alcoholic beverage firm which produces mineral water as a
product to satisfy the customers’ demand as well as maintaining their wellbeing. From the name
Safe Drink, the company aims at delivering quality, safe and purified mineral water, which is
free from any biological, physical or environmental contamination. The company focuses on
achieving the new market entry with consideration to both local and national business operations.
The mineral water production undergoes different steps of purification, including physical
filtration and reversed filtration method to ensure quality is achieved (Miglietta, Battisti, &
Campanella, 2017). The company has partnered with different bottling firms to provide the best
package for the product at the market platform. Furthermore, the Safe Drink organization ensures
complete business certification to enable it to adhere to the water quality requirements for human
consumption. And to meet competitive advantage from other firms like Coco-cola and Pepsis as
well.
Safe Drink Company mission
Safe Drink Company mission regards the creation of valued mineral water which aims at
making a difference towards the people’s health. The company also aims at involving it...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags