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