The Business Plan Financials

User Generated

ivpgbenagubal

Business Finance

Description

This assignment is in two sections: In section one, you will complete the excel worksheet. Section two has three parts: 1. show the current funds for the company and the funds that need to be raised. 2. outline the plan assumptions. 3. show the break-even analysis. The assignment specifics is attached below along with the excel worksheet, the company description, and the business plan financials guide.

Unformatted Attachment Preview

Running head: COMPANY NAME - MARKETING PLAN Marketing Plan and Sales Strategy Carla Randle Strayer University BUS 599 Prof. Andrea Banto October 11, 2018 1 COMPANY NAME - MARKETING PLAN Target Market Defining the target market is crucial for a young company as it builds the brand and allows the company to develop in a certain direction of growth. The target market for POD is much related to the target market of other non-alcoholic health drinks in the world. There is general growth in the industry of non-alcoholic drinks due to the increased flavors and changing consumer preferences. Young consumers are one of the new entrants in the market for healthy drinks, as they try to embrace healthy living while staying at the top of the social ladder. For young people, the use of healthy drinks replaces the existing energy drinks and alcoholic beverages. This new trend calls for the organic drinks such as those made available by the Palmer Organic Drink Company (POD). Target market can be classified in terms of: ✓ Demographic segmentation ✓ Behavioral segmentation ✓ Psychographic segmentation ✓ Geographical segmentation. 2 COMPANY NAME - MARKETING PLAN 3 Trends in non-alcoholic drinks. ("Non-Alcoholic Drinks Market by Product Type (Soft Drinks, Bottled Water, Tea & Coffee, Juice, Dairy Drinks) - Global Opportunity Analysis and Industry Forecast, 2014 - 2022", 2018) Demographic segmentation The expected target of the POD are mostly young people of below age 26 , both genders, women who are young mothers trying to keep in shape, middle aged men who have been warned by their doctors to discontinue the use of alcohol beverages, and family people. POD drinks are also considered healthy alternatives for children above the age of 5.being healthy is advocated to be used by children from the age of 5 and above. “Young adult males who in the sports industry are some of the target markets of the company” (Marketing: understand your customer”, 2017). COMPANY NAME - MARKETING PLAN 4 Psychographic segmentation Obese people who want to change their diet and living style are some of the target market of the POD. The drink is meant for people of middle- and low-class incomes as it is an affordable, yet classy drink. The bottle design is classy, hence can also attract high income consumers. Geographical segmentation Initially, the target market of the product is limited to a 200 miles radius. Behavioral segmentation Non-alcoholic drinks are one of the most advantageous drinks to market as they are consumed by both members of the alcoholic population and the non-alcoholic population. It is worth noting that the main aim of coming up with the Palmer Organic Drink and starting the business is to reach out to people who want to start or continue living a healthy life style by avoiding chemically induced drinks that are filled with both sugar and caffeine. Persons seeking to change their choice of beverages can start using our healthy drink which is prepared from real farm produce. This does not prevent the company from expanding its target market to those people simply “desire the drink either by choice or find themselves in desire of the drink unknowingly” (Marketing. Understand your customer, 2017). Reformed alcoholics or persons who have tasted beer or any alcoholic drink .and due to health reasons have to quit, are considered part of the target market for POD. The flavor in the drinks and the endless recipes keep providing these particular customers with throat reviving taste that follow doctor’s prescriptions for healthy drink rather than alcoholic drinks. In this COMPANY NAME - MARKETING PLAN 5 group, there are some people actually still use alcoholic drinks, but find themselves in situations where they cannot use them for one reason or another. Such a situation during long drive, or while attending a Christian family gathering. These types of situations would call for the customer to use a Palmer organic drink which should be kept on the top shelf of the family refrigerator. Successfully adding more target markets for POD can come from those persons who want energy drinks in order to remain alert. In the future, the company will revisit the possibility of adding a recipe which includes an additive that gives the customer added alertness. The challenge will be creating such a product that allows the customer to remain alert without the addition of caffeine. Non-alcoholics and people in restrictive environment. There is a population of people who are non-alcoholics and others who live in a restrictive environment. Many of these people abstain from alcohol due to personal, religious or social reasons, yet they feel a need to quench their previous thirst with a healthy, flavored drink. This makes them the main target for POD’s non-alcoholic health drink. Some people, such as youth might find themselves in restrictive environment and feel the desire for an alcoholic drink. POD is an alternative to this desire. For example, in places like Saudi Arabia, women are not allowed to drink alcohol. In this country, there are certain Christian religions that frown upon the use of alcoholic beverages. Building POD in such environment as that, would offer an alternative drink to alcohol, ultimately increasing product sales, and raising the company standard in the marketplace. The Palmer Organic Drink Company would do well to expand delivery of products to those areas where persons might be restricted from drinking alcoholic beverages. COMPANY NAME - MARKETING PLAN 6 There are always those people who want to remain healthy such as regular gym members and muscle builders, who are part of the target market for this product. This also includes people who consider themselves to be obese and desire to start living healthy. POD offers a wide range of “healthy drinks that contain zero chemicals and are produced by using farm products” (Nonalcoholic beverages market intelligence, beverages industry market assessment | Infiniti", 2018). Market Competition POD faces competition from established and upcoming companies that offer the nonalcoholic drink services and products. Some of these companies are Coca-Cola, Pepsi, Arizona Beverage Company ltd, Monster Beverage Company ltd, and California Concentrate Company. ltd. Pepsi and Coca-Cola are the market leaders holding over 70% of the market share. To compete with these companies, POD is aimed at ensuring the health of its customers through the use of real farm products such as kiwi, cherries and tropical fruits. Through customer awareness, marketing and advertising, the company will inform its customers of the ingredients in each of its products. This will set POD aside as “a leader in enhancing the health of its customers” (Non-Alcoholic Drinks Market- Global Industry Analysis, Size, Share and Forecast 2014 - 2020, 2018). Company Message The 5’S are ✓ Sort COMPANY NAME - MARKETING PLAN ✓ Set in Order ✓ Shine ✓ Standardize ✓ Sustain 7 In the 5’S, which is equated to the lean manufacturing system, the company is expected to reap benefits such as: ✓ Reduced costs ✓ Higher quality ✓ Increased productivity ✓ Greater employee satisfaction ✓ A safer work environment The marketing message for the company will be placed on social media and will also be on a local billboard. This will convey a message of a healthy, sweet, thirst quenching drink at an affordable price. It will have a picture of farm fruits for each of the specific brands of the drink and also a picture of a person displaying their satisfaction with the drink as revealed by their facial expression. The message will be “Quench your natural thirst with a natural drink”. \ COMPANY NAME - MARKETING PLAN 8 Marketing Vehicles For the company to be able to market itself and ensure it has advertised itself fully for brand awareness and grabbing its market share, the following marketing vehicles will be used: Social media content will emphasize the value content of the POD products, which will be easily shareable in a digital platform. Coca-Cola has done this in their recent marketing of “share a coke” and it has worked well even in the marginalized areas. This strategy ensures that the company website has traffic and the customers get to share the content themselves. The company website has to be full of content about the product. Bloggers will also be used in advertising for the company through “pop up advertisements and dissemination of information through blogging” (Non Alcoholic beverage industry Trends, Analysis, Statistics (2018-23), 2018). A company recommendation system will be used which will allow clients to recommend a second client in order for both clients to receive The company will also use an incentive recommendation system. This is a project in which if a client recommends another client through the social media, both clients are offered free coupons. This is different from a traditional coupon system where only the first client benefits. This means that instead of just one customer receiving a coupon, both clients will benefit from the coupon system. COMPANY NAME - MARKETING PLAN 9 References Marketing. Understand your customer. (2017). Chemistry & Industry, 81(7), 33-35. doi: 10.1002/cind.817_9.x Non-Alcoholic beverage industry Trends, Analysis, Statistics (2018-23). (2018). Retrieved from https://www.mordorintelligence.com/industry-reports/non-alcoholic-beveragemarket?gclid=CjwKCAiA_ZTfBRBjEiwAN6YG4VG3Thm5XwI5WOY_7QQOPOOSutRjZM8wfA3z6JgV0OW8vfHklbssRoC4UQQAvD_BwE Non-Alcoholic Beverages Market Intelligence, Beverages Industry Market Assessment | Infiniti. (2018). Retrieved from https://www.infinitiresearch.com/casestudy/non-alcoholicbeverages-market-intelligence Non-Alcoholic Drinks Market by Product Type (Soft Drinks, Bottled Water, Tea & Coffee, Juice, Dairy Drinks) - Global Opportunity Analysis and Industry Forecast, 2014 - 2022. (2018). Retrieved from https://www.alliedmarketresearch.com/non-alcoholic-drinksmarket Non-Alcoholic Drinks Market- Global Industry Analysis, Size, Share and Forecast 2014 - 2020. (2018). Retrieved from https://www.transparencymarketresearch.com/non-alcoholicdrinks-market.html COMPANY NAME - MARKETING PLAN 10 The Palmer Organic Drink (POD) Company is named after my grandmother, Cora Palmer. She was very interested in healthy foods, which she prepared daily. She showed that interest long before "eating healthy" became a popular fad. I remember very well how she prepared most meals from scratch, using very few processed foods. Regularly, she traveled to the local farmers market to purchase the products needed for her meals. She would pickle beets and cucumbers, make her own apple sauce, and was found canning f ruits and vegetables. She prepared these items and many more in preparation for the winter months. I don't actually remember how she did this, but she made her own soda, especially a root beer soda, and her own ice cream. POD is a company that \will focus their products on healthy organic drinks of different varieties. Drink flavors will include strawberry, raspberry, blueberry, and peach. While the business will begin with these flavors, other flavors will be added in the future. These organic drinks will provide both a delicious taste, as well as good nutritional value. The drinks will be produced without caffeine or any other additives that might cause unhealthy reactions in consumers. The use of natural fruits will give the drinks more of a fruity taste than many of the organic drinks currently on the market. "The Palmer Organic Drink (POD) Company is designed to provide a healthy fruit drink alternative for consumers. The company is committed to using natural products with an absence of caffeine in its contents." By providing such a product, POD hopes to acquire a leading position in the organic drink marketplace 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? Palmer Organic Drink Company What month will you officially start your company? November What year will you officially start your company? 2018 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 Three 10% 60 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.)? $1,000 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? 7.50% If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by? 5.00% 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 62 15.30% $25,000 19.80% 1.00% Setup Assumptions Page 9 of 62 Sales Projections Sales Projections 2018-2019 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 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL 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% November 2019-2020 December January February March April May June July August September October TOTAL November 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 $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 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $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 10 of 62 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 Sales Projections Sales Projections 2019-2020 2020-2021 December January February March April May June July August September October 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 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $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 (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 11 of 62 TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 $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 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections 2021-2022 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 2022-2023 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 $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 Product Line 3 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 (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 TOTAL Page 12 of 62 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 Inventory Inventory 2018-2019 November 2019-2020 December January February March April May June July August September October TOTAL November December 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 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 13 of 62 Inventory Inventory 2020-2021 January February March April May June July August September October 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 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 14 of 62 Inventory Inventory 2021-2022 TOTAL 2022-2023 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 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 Page 15 of 62 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) 11/1/2018 Purchase Date Cost Years of Service Salvage Value Reminder: All purchases must be on or after your business start date of: November-2018 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Year 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 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 Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 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 Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 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 Nov Nov Nov Nov Nov 2018 2018 2018 2018 2018 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 Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Land is a non-depreciable asset Page 16 of 62 Staffing Budget Staffing Budget 2018-2019 November December January February March April May June July August September October 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 17 of 62 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 18 of 62 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 19 of 62 Staffing Budget Total Costs $0 TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS Page 20 of 62 $0 $0 $0 $0 Staffing Budget Staffing Budget 2019-2020 November December January February March April May June July August September October 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 21 of 62 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 22 of 62 Staffing Budget Staffing Budget 2020-2021 TOTAL 2021-2022 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 23 of 62 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 24 of 62 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 2022-2023 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 25 of 62 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 26 of 62 $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 2018-2019 November 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 December January February March April May June July August September October TOTAL $0 $0 $0 $0 $0 $200 $0 $300 $200 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $200 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $200 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $2,400 $0 $3,600 $600 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $60,000 $0 $0 $0 $0 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $780 $300 $0 $0 $0 $150 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $150 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $150 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $450 $0 $0 $100 $6,040 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,840 $0 $0 $100 $5,890 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,840 $0 $0 $100 $5,890 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $1,200 $69,330 Page 27 of 62 Marketing Budget Marketing Budget 2019-2020 November 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 December January February March April May June July August September October TOTAL $0 $0 $0 $0 $0 $200 $0 $300 $200 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $200 $0 $300 $0 $0 $0 $0 $0 $0 $2,400 $0 $3,600 $200 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $5,000 $0 $0 $0 $0 $0 $0 $60,000 $0 $0 $0 $0 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $65 $25 $780 $300 $0 $0 $0 $150 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $150 $0 $0 $100 $6,040 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $100 $5,690 $0 $0 $1,200 $68,630 Page 28 of 62 Marketing Budget Marketing Budget 2020-2021 2021-2022 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 2022-2023 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $2,400 $0 $3,600 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $600 $0 $900 $0 $0 $0 $0 $0 $0 $2,400 $0 $3,600 $0 $0 $0 $0 $0 $0 $2,400 $0 $3,600 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $60,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $60,000 $0 $0 $0 $0 $0 $0 $60,000 $0 $0 $0 $0 $195 $75 $195 $75 $195 $75 $195 $75 $780 $300 $195 $75 $195 $75 $195 $75 $195 $75 $780 $300 $780 $300 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $1,200 $68,280 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $300 $17,070 $0 $0 $1,200 $68,280 $0 $0 $1,200 $68,280 Page 29 of 62 Professional Services Budget Professional Services 2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 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 30 of 62 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 31 of 62 Date Loan Period Interest Rate Month Year Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Capital investments Nov 2018 are not paid back on a loan schedule. Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov 2018 Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov Nov 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 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: November-2018 Page 32 of 62 Income Statements Page 33 of 62 Income Statements Income Statements 2018-2019 November 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 December January February March April May June July August September October 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 $6,040 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,040 -$6,040 $16 $0 -$6,024 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $11 $0 -$5,679 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $6 $0 -$5,684 $0 $0 $0 $0 $5,840 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,840 -$5,840 $1 $0 -$5,839 $0 $0 $0 $0 $5,890 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,890 -$5,890 $0 $0 -$5,890 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,840 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,840 -$5,840 $0 $0 -$5,840 $0 $0 $0 $0 $5,890 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,890 -$5,890 $0 $0 -$5,890 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $69,330 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $69,330 -$69,330 $35 $0 -$69,295 Page 34 of 62 Income Statements Page 35 of 62 Income Statements Income Statements 2019-2020 November 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 December January February March April May June July August September October TOTAL $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 $0 $0 $0 $0 $6,040 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,040 -$6,040 $0 $0 -$6,040 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $5,690 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,690 -$5,690 $0 $0 -$5,690 $0 $0 $0 $0 $68,630 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $68,630 -$68,630 $0 $0 -$68,630 Page 36 of 62 Income Statements Page 37 of 62 Income Statements Income Statements 2020-2021 2021-2022 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 2022-2023 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 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $68,280 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $68,280 -$68,280 $0 $0 -$68,280 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $17,070 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $17,070 -$17,070 $0 $0 -$17,070 $0 $0 $0 $0 $68,280 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $68,280 -$68,280 $0 $0 -$68,280 $0 $0 $0 $0 $68,280 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $68,280 -$68,280 $0 $0 -$68,280 Page 38 of 62 Cash Flow Statements Cash Flow 2018-2019 November 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 December January February March April May June July August September October $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $16 $0 $0 $16 $0 $16 $11 $0 $0 $11 $0 $11 $6 $0 $0 $6 $0 $6 $1 $0 $0 $1 $0 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,040 $0 $0 $0 $0 $0 $0 $6,040 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,840 $0 $0 $0 $0 $0 $0 $5,840 $0 $5,890 $0 $0 $0 $0 $0 $0 $5,890 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,840 $0 $0 $0 $0 $0 $0 $5,840 $0 $5,890 $0 $0 $0 $0 $0 $0 $5,890 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 NET CASH FLOW -$6,024 -$5,679 -$5,684 -$5,839 -$5,890 -$5,690 -$5,690 -$5,840 -$5,890 -$5,690 -$5,690 -$5,690 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE $25,000 $16 $6,040 $18,976 $18,976 $11 $5,690 $13,297 $13,297 $6 $5,690 $7,613 $7,613 $1 $5,840 $1,775 $1,775 $0 $5,890 -$4,115 -$4,115 $0 $5,690 -$9,805 -$9,805 $0 $5,690 -$15,495 -$15,495 $0 $5,840 -$21,335 -$21,335 $0 $5,890 -$27,225 -$27,225 $0 $5,690 -$32,915 -$32,915 $0 $5,690 -$38,605 -$38,605 $0 $5,690 -$44,295 CASH DISBURSEMENTS Inventory Operating Expenses Commissions/Returns & Allowances Capital Purchases Loan Payments Income Tax Payments Investor Dividend Payments Owner's Draw TOTAL CASH DISBURSEMENTS Page 39 of 62 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 $0 $0 $0 $35 $0 $0 $35 $0 $35 $0 $69,330 $0 $0 $0 $0 $0 $0 $69,330 NET CASH FLOW -$69,295 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE -$44,295 Page 40 of 62 Cash Flow Statements Cash Flow 2019-2020 November 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 December January February March April May June July August September October $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,040 $0 $0 $0 $0 $0 $0 $6,040 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 $0 $5,690 $0 $0 $0 $0 $0 $0 $5,690 -$6,040 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$5,690 -$44,295 $0 $6,040 -$50,335 -$50,335 $0 $5,690 -$56,025 -$56,025 $0 $5,690 -$61,715 -$61,715 $0 $5,690 -$67,405 -$67,405 $0 $5,690 -$73,095 -$73,095 $0 $5,690 -$78,785 -$78,785 $0 $5,690 -$84,475 -$84,475 $0 $5,690 -$90,165 -$90,165 $0 $5,690 -$95,855 -$95,855 $0 $5,690 -$101,545 -$101,545 $0 $5,690 -$107,235 -$107,235 $0 $5,690 -$112,925 Page 41 of 62 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 $0 $0 $0 $0 $0 $0 $0 $68,630 $0 $0 $0 $0 $0 $0 $68,630 -$68,630 Opening Cash Balance Cash Receipts Cash Disbursements ENDING CASH BALANCE Page 42 of 62 -$112,925 Cash Flow Statements Cash Flow 2020-2021 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 2021-2022 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2022-2023 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 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $68,280 $0 $0 $0 $0 $0 $0 $68,280 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $17,070 $0 $0 $0 $0 $0 $0 $17,070 $0 $68,280 $0 $0 $0 $0 $0 $0 $68,280 $0 $68,280 $0 $0 $0 $0 $0 $0 $68,280 -$17,070 -$17,070 -$17,070 -$17,070 -$68,280 -$17,070 -$17,070 -$17,070 -$17,070 -$68,280 -$68,280 -$112,925 $0 $17,070 -$129,995 -$129,995 $0 $17,070 -$147,065 -$147,065 $0 $17,070 -$164,135 -$164,135 $0 $17,070 -$181,205 -$181,205 -$181,205 $0 $17,070 -$198,275 -$198,275 $0 $17,070 -$215,345 -$215,345 $0 $17,070 -$232,415 -$232,415 $0 $17,070 -$249,485 -$249,485 -$249,485 $0 $68,280 -$317,765 Page 43 of 62 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 44 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company First Quarter 2018-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 $7,613 $0 $0 $0 $7,613 $0 $0 $0 $0 $0 $0 $0 $7,613 $0 $0 $0 $0 $0 $0 $0 $25,000 -$17,387 $7,613 $7,613 Page 45 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company Second Quarter 2018-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 -$9,805 $0 $0 $0 -$9,805 $0 $0 $0 $0 $0 $0 $0 -$9,805 $0 $0 $0 $0 $0 $0 $0 $25,000 -$34,805 -$9,805 -$9,805 Page 46 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company Third Quarter 2018-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 -$27,225 $0 $0 $0 -$27,225 $0 $0 $0 $0 $0 $0 $0 -$27,225 $0 $0 $0 $0 $0 $0 $0 $25,000 -$52,225 -$27,225 -$27,225 Page 47 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company Fourth Quarter 2018-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 -$44,295 $0 $0 $0 -$44,295 $0 $0 $0 $0 $0 $0 $0 -$44,295 $0 $0 $0 $0 $0 $0 $0 $25,000 -$69,295 -$44,295 -$44,295 Page 48 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company 2019-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 -$112,925 $0 $0 $0 -$112,925 $0 $0 $0 $0 $0 $0 $0 -$112,925 $0 $0 $0 $0 $0 $0 $0 $25,000 -$137,925 -$112,925 -$112,925 Page 49 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company 2020-2021 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 -$181,205 $0 $0 $0 -$181,205 $0 $0 $0 $0 $0 $0 $0 -$181,205 $0 $0 $0 $0 $0 $0 $0 $25,000 -$206,205 -$181,205 -$181,205 Page 50 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company 2021-2022 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 -$249,485 $0 $0 $0 -$249,485 $0 $0 $0 $0 $0 $0 $0 -$249,485 $0 $0 $0 $0 $0 $0 $0 $25,000 -$274,485 -$249,485 -$249,485 Page 51 of 62 Balance Sheet Balance Sheet Palmer Organic Drink Company 2022-2023 ASSETS Current Assets Cash Accounts Receivable Inventory Other Current Assets Total Current Assets -$317,765 $0 $0 $0 -$317,765 Fixed Assets Land Facilities Equipment Computers & Telecommunications (Less Accumlated Depreciation) Total Fixed Assets Other Assets TOTAL ASSETS $0 $0 $0 $0 $0 $0 $0 -$317,765 LIABILITIES Current Liabilities Short-Term Notes Payable Income Taxes Due Other Current Liabilities Total Current Liabilities $0 $0 $0 $0 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 $25,000 -$342,765 -$317,765 -$317,765 Page 52 of 62 Break-even Estimates Break-even Estimates Year 1 (2018-2019) November December January February March April May June July August September October Monthly Average Year 2 (2019-2020) November December January February March April May June July August September October Monthly Average Year 3 (2020-2021) 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 (2021-2022) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Quarterly Average $0 Year 5 (2022-2023) Annual Average $0 Page 53 of 62 $0 $0 $0 $0 Key Ratios Key Ratios Year 1 (2018-2019) 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Working Capital Current Ratio $7,613 N.A. -$9,805 N.A. -$27,225 N.A. -$44,295 N.A. Quick Ratio N.A. N.A. N.A. 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 -229% 178% 64% 39% Return on Sales N.A. N.A. N.A. N.A. Return on Assets -229% 178% 64% 39% Year 2 (2019-2020) -$112,925 N.A. N.A. 0.00 0.00 61% N.A. 61% Year 3 (2020-2021) -$181,205 N.A. N.A. 0.00 0.00 38% N.A. 38% Year 4 (2021-2022) -$249,485 N.A. N.A. 0.00 0.00 27% N.A. 27% Year 5 (2022-2023) -$317,765 N.A. N.A. 0.00 0.00 21% N.A. 21% Page 54 of 62 Year 1: Financials at-a-Glance (2018-2019) $0 -$1,000 -$2,000 -$3,000 Gross Sales -$4,000 Gross Profit Net Profit -$5,000 -$6,000 Page 55 of 62 October September August July June May April March February January December November -$7,000 Year 1: Net Sales (2018-2019) $1 $1 $1 Product Line 3 $1 $1 $1 Product Line 2 $0 $0 $0 Product Line 1 $0 Page 56 of 62 October September August July June May April March February January December November $0 Year 1: Cash Flow (2018-2019) $20,000 $10,000 $0 -$10,000 Net Cash Flow -$20,000 Ending Cash Balance -$30,000 -$40,000 Page 57 of 62 October September August July June May April March February January December November -$50,000 Year 2: Cash Flow (2019-2020) $0 -$20,000 -$40,000 -$60,000 Net Cash Flow Ending Cash Balance -$80,000 -$100,000 Page 58 of 62 October September August July June May April March February January December November -$120,000 5-Year Financials at-a-Glance $0 -$10,000 -$20,000 -$30,000 Gross Sales Gross Profit Net Profit -$40,000 -$50,000 -$60,000 -$70,000 2018-2019 2019-2020 2020-2021 Page 59 of 62 2021-2022 2022-2023 5-Year Net Sales $1 $1 $1 $1 Axis Title $1 Product Line 1 $1 Product Line 2 Product Line 3 $0 $0 $0 $0 $0 2018-2019 2019-2020 2020-2021 Page 60 of 62 2021-2022 2022-2023 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 This Assignment has two sections: Section I: The Business Plan financials (Excel document)- complete this first Using your NAB Company Portfolio and the first year of your business plan for the company, you will complete all the worksheets in the entire Excel document in order, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet. Notes: • • • The setup and marketing worksheet should already be completed from assignment 2. Use the instructions provided in the Business Plan Financials Guide to help you complete this document, as well as the NAB Portfolio (pages 4-8). VIDEO GUIDE TO COMPLETING THE EXCEL DOCUMENT To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content button under the Post button to access the attachment option when you are ready to submit, attach your document and then click submit) Section II: Financial section of the business plan (type in a Word document and paste in the discussion window). You will have 3 headings as outlined below: 1.Sources and use of funds • • Outline the funds you have currently (see portfolio pages 4 and 8) and the ones you intend to raise (you need to raise funds per the portfolio page 4) Explain how do you plan to use the funds (a clear plan on how you will use the money) Notes: Before addressing this section please review: -Sources and Use of Funds section on page 312 of your textbook -Sample plan on page 325 for an idea on how to address this section. -The Cap Invest (Capital Investments and loans worksheet) in the Excel document 2.Plan assumptions The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic. In this section you will outline your plan assumptions. Notes: Before addressing this section please review: • • • Article about the 5 key assumptions of your business plan. https://www.thebalancesmb.com/question-key-assumptions-in-your-business-plan-1200853 Sample plan in your textbook page 326 Assumption sheet in your textbook page 313. 3.Break-even analysis The break-even point is where you make enough money in revenue to pay your expenses but you do not make money nor you do not lose money. In this section, you need to determine what this break -even point is. NON-ALCOHOLOIC BEVERAGE COMPANY Business Plan Financials Worksheet Guidance Below is guidance for data entry into cells of each of the separate Excel worksheets of the overall Business Plan Financials. This is the base pro-forma financial statements for your business. Please note: Many of the cells in the Business Plan Financials (BPF) are already prepopulated with suggested/default values. Use the default numbers unless otherwise indicated. Only cells with BLUE text can be changed. The cells in black will be filled in automatically, based on your setup assumptions, or will be carried over from numbers you entered earlier on other worksheets. Work in order – as every cell you complete will carry over to all other applicable Excel worksheets (for example, if you enter a figure in the Staff Budget, that figure will carry over to your Income Statement and Cash Flow Statement). You are encouraged to work through the guide as early as possible. (Review the Course Guide for specific due dates on specified worksheets; as assignments are due throughout the course.) Worksheet #1 - Set Up and Assumptions Line 9: the month the academic quarter starts Line 12: enter the year the academic quarter starts Line 15: Two (students can choose the number of product lines to include up to 10 lines) Line 18: they will sell 55% on credit Line 21: 30 days (standard default; however, can be adjusted as needed) Line 43: $16,500 (estimate of net sales after six month of weekend sales) Line 49: 1.00% (Dodd-Frank Act of 2011 allows businesses to receive interests on business accounts, per the agreement of the financial institution [range 0 to 1.50%]) Worksheet #2 - Sales Projections Each student must determine this for their business—speculate on how your company will grow and how much you will sell. Reflect this in/from your Operations Plan Worksheet #3 – Inventory Line 7: Ingredients Line 8: Bottles/caps Line 9: Labels Line 10: Cartons Repeat these four lines for each product line. Worksheet #4 - Capital Expenditures (Note: This applies to purchased equipment, not leased equipment.) Facilities section: Students are not purchasing facilities (facility is already provided) Equipment section: Capital Purchases should be additional expenses that each student might decide to purchase. (Note – after the first year of business) Current vans and other equipment should be captured in Line 23 as part of “Other Assets” on the Balance Sheet, Worksheet 11. Updated 2/26/2016 1 NON-ALCOHOLOIC BEVERAGE COMPANY Business Plan Financials Worksheet Guidance Computer Hardware/Software Section: Capital Purchases should be additional expenses that each student might decide to purchase. Current computer hardware/software should be captured as part of “Other Assets” on the balance sheet, along with equipment mentioned above. Worksheet #5 - Staffing Budget Account for every paid employee using the appropriate Lines for the six categories of employees (Management, Administrative/Support, Sales/Marketing, Operations/Production, Other, PartTime/Hourly) and when their employment will commence in accordance with the Operations Plan and Management Plan. (See Note # 1 and Note #3 of the NAB Company Portfolio for additional details) Worksheet #6 - Marketing Budget This is submitted with Assignment 2: Marketing Plan Worksheet #7: Professional Services Line 6: $2,000 Line 7: $1,500 Line 9: $2,000 Line 11: Mary Cates, JD $10,000 (first year only) Worksheet #8 - Cap Investment Equity Capital Investments: Line 6: Melinda Cates $40,000 Line 7: Glass Bottles $3,000 Line 8: Metal Caps $300 Line 9: Cardboard Cartons $500 Line 10: NAB Ingredients $600 Line 11: Labels $840 Loans: Line 24: Friends and Family $20,000; the loan period is 24; the interest rate is 5% [immediate decision is needed, before proceeding to other sections] (Note: Early pay off within 12 months @ 0% interest could apply; however if early payoff is not chosen 5% interest at 24 months will automatically apply.) (See Note #3) Add projections of other funds they intend to raise Worksheet #9 - Income Statement Line 20: $1,000 *Note the Leased equipment in the NAB Company Portfolio. (See Note #2) The Income Statement is submitted with Assignment 3 Part 2: Business Plan – Draft Worksheet #11 - Balance Sheet This will automatically populate from other completed worksheets. (See Worksheet # 4 above) Updated 2/26/2016 2
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

Use this

Cash Flow

2016
July

August

September

October

November

December

January

February

March

April

May

June

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

$0
$0
$0

$0
$8,940
$8,940

$0
$13,410
$13,410

$0
$20,115
$20,115

$0
$30,173
$30,173

$0
$45,259
$45,259

$0
$67,888
$67,888

$0
$101,832
$101,832

$0
$152,748
$152,748

$0
$229,122
$229,122

$0
$343,684
$343,684

$0
$515,525
$515,525

$0
$1,528,696
$1,528,696

$0
$100,000
$40,000
$140,000
$0
$140,000

$0
$0
$0
$0
$0
$8,940

$0
$0
$0
$0
$0
$13,410

$0
$0
$0
$0
$0
$20,115

$0
$0
$0
$0
$0
$30,173

$0
$0
$0
$0
$0
$45,259

$0
$0
$100,000
$100,000
$0
$167,888

$0
$0
$0
$0
$0
$101,832

$0
$0
$0
$0
$0
$152,748

$0
$0
$0
$0
$0
$229,122

$0
$0
$0
$0
$0
$343,684

$0
$0
$100,000
$100,000
$0
$615,525

$0
$100,000
$240,000
$340,000
$0
$1,868,696

CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payment...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags