Running head: COMPANY NAME - MARKETING PLAN
Marketing Plan and Sales Strategy
Carla Randle
Strayer University
BUS 599
Prof. Andrea Banto
October 11, 2018
1
COMPANY NAME - MARKETING PLAN
Target Market
Defining the target market is crucial for a young company as it builds the brand and
allows the company to develop in a certain direction of growth. The target market for POD is
much related to the target market of other non-alcoholic health drinks in the world. There is
general growth in the industry of non-alcoholic drinks due to the increased flavors and changing
consumer preferences. Young consumers are one of the new entrants in the market for healthy
drinks, as they try to embrace healthy living while staying at the top of the social ladder. For
young people, the use of healthy drinks replaces the existing energy drinks and alcoholic
beverages. This new trend calls for the organic drinks such as those made available by the
Palmer Organic Drink Company (POD).
Target market can be classified in terms of:
✓ Demographic segmentation
✓ Behavioral segmentation
✓ Psychographic segmentation
✓ Geographical segmentation.
2
COMPANY NAME - MARKETING PLAN
3
Trends in non-alcoholic drinks. ("Non-Alcoholic Drinks Market by Product Type (Soft Drinks,
Bottled Water, Tea & Coffee, Juice, Dairy Drinks) - Global Opportunity Analysis and Industry
Forecast, 2014 - 2022", 2018)
Demographic segmentation
The expected target of the POD are mostly young people of below age 26 , both genders,
women who are young mothers trying to keep in shape, middle aged men who have been warned
by their doctors to discontinue the use of alcohol beverages, and family people. POD drinks
are also considered healthy alternatives for children above the age of 5.being healthy is
advocated to be used by children from the age of 5 and above. “Young adult males who in the
sports industry are some of the target markets of the company” (Marketing: understand your
customer”, 2017).
COMPANY NAME - MARKETING PLAN
4
Psychographic segmentation
Obese people who want to change their diet and living style are some of the target market of
the POD. The drink is meant for people of middle- and low-class incomes as it is an affordable,
yet classy drink. The bottle design is classy, hence can also attract high income consumers.
Geographical segmentation
Initially, the target market of the product is limited to a 200 miles radius.
Behavioral segmentation
Non-alcoholic drinks are one of the most advantageous drinks to market as they are
consumed by both members of the alcoholic population and the non-alcoholic population. It is
worth noting that the main aim of coming up with the Palmer Organic Drink and starting the
business is to reach out to people who want to start or continue living a healthy life style by
avoiding chemically induced drinks that are filled with both sugar and caffeine. Persons seeking
to change their choice of beverages can start using our healthy drink which is prepared from real
farm produce. This does not prevent the company from expanding its target market to those
people simply “desire the drink either by choice or find themselves in desire of the drink
unknowingly” (Marketing. Understand your customer, 2017).
Reformed alcoholics or persons who have tasted beer or any alcoholic drink .and due to
health reasons have to quit, are considered part of the target market for POD. The flavor in the
drinks and the endless recipes keep providing these particular customers with throat reviving
taste that follow doctor’s prescriptions for healthy drink rather than alcoholic drinks. In this
COMPANY NAME - MARKETING PLAN
5
group, there are some people actually still use alcoholic drinks, but find themselves in situations
where they cannot use them for one reason or another. Such a situation during long drive, or
while attending a Christian family gathering. These types of situations would call for the
customer to use a Palmer organic drink which should be kept on the top shelf of the family
refrigerator. Successfully adding more target markets for POD can come from those persons
who want energy drinks in order to remain alert. In the future, the company will revisit the
possibility of adding a recipe which includes an additive that gives the customer added alertness.
The challenge will be creating such a product that allows the customer to remain alert without
the addition of caffeine.
Non-alcoholics and people in restrictive environment.
There is a population of people who are non-alcoholics and others who live in a restrictive
environment. Many of these people abstain from alcohol due to personal, religious or social
reasons, yet they feel a need to quench their previous thirst with a healthy, flavored drink. This
makes them the main target for POD’s non-alcoholic health drink. Some people, such as youth
might find themselves in restrictive environment and feel the desire for an alcoholic drink. POD
is an alternative to this desire. For example, in places like Saudi Arabia, women are not allowed
to drink alcohol. In this country, there are certain Christian religions that frown upon the use of
alcoholic beverages. Building POD in such environment as that, would offer an alternative drink
to alcohol, ultimately increasing product sales, and raising the company standard in the
marketplace. The Palmer Organic Drink Company would do well to expand delivery of products
to those areas where persons might be restricted from drinking alcoholic beverages.
COMPANY NAME - MARKETING PLAN
6
There are always those people who want to remain healthy such as regular gym members
and muscle builders, who are part of the target market for this product. This also includes people
who consider themselves to be obese and desire to start living healthy. POD offers a wide range
of “healthy drinks that contain zero chemicals and are produced by using farm products”
(Nonalcoholic beverages market intelligence, beverages industry market assessment | Infiniti",
2018).
Market Competition
POD faces competition from established and upcoming companies that offer the nonalcoholic drink services and products. Some of these companies are Coca-Cola, Pepsi, Arizona
Beverage Company ltd, Monster Beverage Company ltd, and California Concentrate Company.
ltd. Pepsi and Coca-Cola are the market leaders holding over 70% of the market share.
To compete with these companies, POD is aimed at ensuring the health of its customers through
the use of real farm products such as kiwi, cherries and tropical fruits. Through customer
awareness, marketing and advertising, the company will inform its customers of the ingredients
in each of its products. This will set POD aside as “a leader in enhancing the health of its
customers” (Non-Alcoholic Drinks Market- Global Industry Analysis, Size, Share and Forecast
2014 - 2020, 2018).
Company Message
The 5’S are
✓
Sort
COMPANY NAME - MARKETING PLAN
✓
Set in Order
✓
Shine
✓
Standardize
✓
Sustain
7
In the 5’S, which is equated to the lean manufacturing system, the company is expected to
reap benefits such as:
✓
Reduced costs
✓
Higher quality
✓
Increased productivity
✓
Greater employee satisfaction
✓
A safer work environment
The marketing message for the company will be placed on social media and will also be on a
local billboard. This will convey a message of a healthy, sweet, thirst quenching drink at an
affordable price. It will have a picture of farm fruits for each of the specific brands of the drink
and also a picture of a person displaying their satisfaction with the drink as revealed by their
facial expression. The message will be “Quench your natural thirst with a natural drink”.
\
COMPANY NAME - MARKETING PLAN
8
Marketing Vehicles
For the company to be able to market itself and ensure it has advertised itself fully for brand
awareness and grabbing its market share, the following marketing vehicles will be used:
Social media content will emphasize the value content of the POD products, which will be easily
shareable in a digital platform. Coca-Cola has done this in their recent marketing of “share a
coke” and it has worked well even in the marginalized areas. This strategy ensures that the
company website has traffic and the customers get to share the content themselves. The
company website has to be full of content about the product. Bloggers will also be used in
advertising for the company through “pop up advertisements and dissemination of information
through blogging” (Non Alcoholic beverage industry Trends, Analysis, Statistics (2018-23),
2018). A company recommendation system will be used which will allow clients to recommend
a second client in order for both clients to receive
The company will also use an incentive recommendation system. This is a project in which if a
client recommends another client through the social media, both clients are offered free coupons.
This is different from a traditional coupon system where only the first client benefits. This
means that instead of just one customer receiving a coupon, both clients will benefit from the
coupon system.
COMPANY NAME - MARKETING PLAN
9
References
Marketing. Understand your customer. (2017). Chemistry & Industry, 81(7), 33-35. doi:
10.1002/cind.817_9.x
Non-Alcoholic beverage industry Trends, Analysis, Statistics (2018-23). (2018). Retrieved from
https://www.mordorintelligence.com/industry-reports/non-alcoholic-beveragemarket?gclid=CjwKCAiA_ZTfBRBjEiwAN6YG4VG3Thm5XwI5WOY_7QQOPOOSutRjZM8wfA3z6JgV0OW8vfHklbssRoC4UQQAvD_BwE
Non-Alcoholic Beverages Market Intelligence, Beverages Industry Market Assessment | Infiniti.
(2018). Retrieved from https://www.infinitiresearch.com/casestudy/non-alcoholicbeverages-market-intelligence
Non-Alcoholic Drinks Market by Product Type (Soft Drinks, Bottled Water, Tea & Coffee,
Juice, Dairy Drinks) - Global Opportunity Analysis and Industry Forecast, 2014 - 2022.
(2018). Retrieved from https://www.alliedmarketresearch.com/non-alcoholic-drinksmarket
Non-Alcoholic Drinks Market- Global Industry Analysis, Size, Share and Forecast 2014 - 2020.
(2018). Retrieved from https://www.transparencymarketresearch.com/non-alcoholicdrinks-market.html
COMPANY NAME - MARKETING PLAN
10
The Palmer Organic Drink (POD) Company is named after my grandmother, Cora Palmer. She
was very interested in healthy foods, which she prepared daily. She showed that interest long
before "eating healthy" became a popular fad. I remember very well how she prepared most
meals from scratch, using very few processed foods. Regularly, she traveled to the local
farmers market to purchase the products needed for her meals. She would pickle beets and
cucumbers, make her own apple sauce, and was found canning f ruits and vegetables. She
prepared these items and many more in preparation for the winter months. I don't actually
remember how she did this, but she made her own soda, especially a root beer soda, and her
own ice cream.
POD is a company that \will focus their products on healthy organic drinks of different
varieties. Drink flavors will include strawberry, raspberry, blueberry, and peach. While the
business will begin with these flavors, other flavors will be added in the future. These organic
drinks will provide both a delicious taste, as well as good nutritional value. The drinks will be
produced without caffeine or any other additives that might cause unhealthy reactions in
consumers. The use of natural fruits will give the drinks more of a fruity taste than many of the
organic drinks currently on the market.
"The Palmer Organic Drink (POD) Company is designed to provide a healthy fruit drink
alternative for consumers. The company is committed to using natural products with an
absence of caffeine in its contents." By providing such a product, POD hopes to acquire a
leading position in the organic drink marketplace
Your Company Name
WARNING!
IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
Excel 2010 for Windows:
To enable macros:
1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under
"Excel 2010 and Excel 2013 on Windows - Enabling Macros"
Excel 2013& 2016 for Windows:
To enable macros:
1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under
"Excel 2010 & Excel 2013 on Windows - Enabling Macros"
Excel 2011 & 2016 for Mac:
1. A pop-up window appears. Select "Enable Macros".
2. Your workbook should now be ready to use.
Your Company Name
Excel 2013 and Excel 2016 on Windows - Enabling Macros
Your Company Name
WARNING!
XCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
nabling Macros"
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
bling Macros"
Your Company Name
Excel 2016 on Windows - Enabling Macros
Note: The procedure is exactly the same for Excel 2013 & 2016,
even though the two versions look slightly different.
1. In the upper left corner of the Excel Ribbon, press the "File" tab.
2. Select Options, in the lower left
corner.
3. Select Trust Center from
the Lower Left.
4. Click the "Trust Center
Settings…" button in the
lower right
5. Select "Macros Settings"
from the left side menu
6. Select the "Disable all
macros except digitally
signed macros" radio button.
7. Click "OK" twice
Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your
business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies , by
Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com.
First, a few tips to get you started:
SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES
You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIG_PlanningShop_BizPlanFin(2.8)" file in
your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy.
NAVIGATING THE WORKSHEETS
You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that contains controls to let you navigate
between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same.
Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.
Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:
In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it).
Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
HOW TO FILL IN THE WORKSHEETS
Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically
calculated for you.
While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will
popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
FOR MORE HELP
For more in-depth help and assistance,please refer to the companion PDF entitled "Business Plan Financials Help". It contains extensive information about each
worksheet, along with a "Frequently Asked Questions" (FAQ).
To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic
information about your business.
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365
2. Microsoft Windows 8 or later with Microsoft Excel 2013
Mac
4 Mac OS X with Microsoft Excel 2016
5. Mac OS X with Microsoft Excel for Mac 2011
Version 3.1
Copyright © 2003-2017 PlanningShop
Setup Assumptions
Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Palmer Organic Drink Company
What month will you officially start your company?
November
What year will you officially start your company?
2018
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major
product/service lines. How many major product/service lines do you plan
to have for your business?
Most businesses sell at least some of their products/services on credit
(e.g., "net 30" as opposed to cash). What percentage of your sales will
be made on credit?
For sales you make on credit, what terms will you extend? In other
words, how many days will pass from the date of sale to when you
expect to be paid?
T
e
n
Three
10%
60
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits
for each SALARIED/FULL TIME employee (medical insurance, etc.)?
$5,000
Approximately how much do you expect to spend per year on benefits
for each HOURLY/PART-TIME employee (medical insurance, etc.)?
$1,000
With health insurance and other benefits costing more each year, your
plan should account for annual increases. How much do you estimate
your benefit costs will increase each year?
7.50%
If you plan to increase wages (both salaried & hourly) on an annual
basis, how much to you plan to increase them by?
5.00%
Approximately what percentage of each employee's salary or wages do
you plan to set aside for payroll taxes?
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of
business? This will be the opening balance in your Cash Flow
Statements.
At approximately what rate do you expect to be taxed on your net
income?
If you will use an interest-bearing account for your banking, at what rate
will you accrue interest?
Page 8 of 62
15.30%
$25,000
19.80%
1.00%
Setup Assumptions
Page 9 of 62
Sales Projections
Sales Projections
2018-2019
Assumptions
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
5.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
November
2019-2020
December
January
February
March
April
May
June
July
August
September
October
TOTAL
November
0
$0.00
$0
$0
$0.00
$0
$0.00
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0.00
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
Page 10 of 62
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
Sales Projections
Sales Projections
2019-2020
2020-2021
December
January
February
March
April
May
June
July
August
September
October
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
Page 11 of 62
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
Sales Projections
Sales Projections
2021-2022
TOTAL
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
2022-2023
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
$0
$0
$0
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
TOTAL
Page 12 of 62
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0.00
$0
$0
$0
0
$0.00
$0
$0
$0
$0
$0
$0
Inventory
Inventory
2018-2019
November
2019-2020
December
January
February
March
April
May
June
July
August
September
October
TOTAL
November
December
Product Line 1
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 2
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 3
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
GRAND TOTAL INVENTORY
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 13 of 62
Inventory
Inventory
2020-2021
January
February
March
April
May
June
July
August
September
October
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Product Line 1
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 2
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 3
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
GRAND TOTAL INVENTORY
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 14 of 62
Inventory
Inventory
2021-2022
TOTAL
2022-2023
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
Product Line 1
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 2
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 3
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
GRAND TOTAL INVENTORY
$0
$0
$0
$0
$0
$0
$0
Page 15 of 62
Capital Purchases
Capital Purchases
Item
Facilities
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
11/1/2018
Purchase
Date
Cost
Years of
Service
Salvage
Value
Reminder: All purchases must be on or after your business start date of:
November-2018
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Month
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Year
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
1
1
1
1
1
1
1
1
1
1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Equipment
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Computer Hardware/Software
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
3
1
1
1
1
1
1
1
1
1
1
1
1
1
1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Telecommunications
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
Nov
Nov
Nov
Nov
Nov
2018
2018
2018
2018
2018
1
1
1
1
1
$0
$0
$0
$0
$0
Land
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
Land is a
non-depreciable
asset
Page 16 of 62
Staffing Budget
Staffing Budget
2018-2019
November
December
January
February
March
April
May
June
July
August
September
October
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
Page 17 of 62
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 18 of 62
Staffing Budget
Staffing Budget
TOTAL
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
$0
$0
$0
$0
Page 19 of 62
Staffing Budget
Total Costs
$0
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
Page 20 of 62
$0
$0
$0
$0
Staffing Budget
Staffing Budget
2019-2020
November
December
January
February
March
April
May
June
July
August
September
October
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
Page 21 of 62
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 22 of 62
Staffing Budget
Staffing Budget
2020-2021
TOTAL
2021-2022
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
0
0
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
Page 23 of 62
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Page 24 of 62
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Staffing Budget
Staffing Budget
2022-2023
TOTAL
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
Page 25 of 62
0
0
$0.00
$0
$0
$0
$0
Staffing Budget
Total Costs
$0
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
Page 26 of 62
$0
$0
$0
$0
$0
$0
Marketing Budget
For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates
from PlanningShop.
Marketing Budget
2018-2019
November
Professional Assistance
Marketing/PR Consultants
Advertising Agencies
Social Media Specialists
SEO Specialist
Graphic/Web Design
Brochures/Leaflets/Flyers
Signs/Billboards
Merchandising Displays
Sampling/Premiums
Media Advertising
Print (newspaper, etc.)
Television and Radio
Online
Other Media
Phone Directories
Advertising Specialties
Direct Mail
Website
Development/Programming
Maintenance and Hosting
Trade Shows
Fees and Setup
Travel/Shipping
Exhibits/Signs
Public Relations/Materials
Informal Marketing / Networking
Memberships/Meetings
Entertainment
Other
GRAND TOTAL COSTS
December
January
February
March
April
May
June
July
August
September
October
TOTAL
$0
$0
$0
$0
$0
$200
$0
$300
$200
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$200
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$200
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$2,400
$0
$3,600
$600
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$60,000
$0
$0
$0
$0
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$780
$300
$0
$0
$0
$150
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$150
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$150
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$450
$0
$0
$100
$6,040
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,840
$0
$0
$100
$5,890
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,840
$0
$0
$100
$5,890
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$1,200
$69,330
Page 27 of 62
Marketing Budget
Marketing Budget
2019-2020
November
Professional Assistance
Marketing/PR Consultants
Advertising Agencies
Social Media Specialists
SEO Specialist
Graphic/Web Design
Brochures/Leaflets/Flyers
Signs/Billboards
Merchandising Displays
Sampling/Premiums
Media Advertising
Print (newspaper, etc.)
Television and Radio
Online
Other Media
Phone Directories
Advertising Specialties
Direct Mail
Website
Development/Programming
Maintenance and Hosting
Trade Shows
Fees and Setup
Travel/Shipping
Exhibits/Signs
Public Relations/Materials
Informal Marketing / Networking
Memberships/Meetings
Entertainment
Other
GRAND TOTAL COSTS
December
January
February
March
April
May
June
July
August
September
October
TOTAL
$0
$0
$0
$0
$0
$200
$0
$300
$200
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$200
$0
$300
$0
$0
$0
$0
$0
$0
$2,400
$0
$3,600
$200
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$5,000
$0
$0
$0
$0
$0
$0
$60,000
$0
$0
$0
$0
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$65
$25
$780
$300
$0
$0
$0
$150
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$150
$0
$0
$100
$6,040
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$100
$5,690
$0
$0
$1,200
$68,630
Page 28 of 62
Marketing Budget
Marketing Budget
2020-2021
2021-2022
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Professional Assistance
Marketing/PR Consultants
Advertising Agencies
Social Media Specialists
SEO Specialist
Graphic/Web Design
Brochures/Leaflets/Flyers
Signs/Billboards
Merchandising Displays
Sampling/Premiums
Media Advertising
Print (newspaper, etc.)
Television and Radio
Online
Other Media
Phone Directories
Advertising Specialties
Direct Mail
Website
Development/Programming
Maintenance and Hosting
Trade Shows
Fees and Setup
Travel/Shipping
Exhibits/Signs
Public Relations/Materials
Informal Marketing / Networking
Memberships/Meetings
Entertainment
Other
GRAND TOTAL COSTS
TOTAL
2022-2023
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$2,400
$0
$3,600
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$600
$0
$900
$0
$0
$0
$0
$0
$0
$2,400
$0
$3,600
$0
$0
$0
$0
$0
$0
$2,400
$0
$3,600
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$60,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$15,000
$0
$0
$0
$0
$0
$0
$60,000
$0
$0
$0
$0
$0
$0
$60,000
$0
$0
$0
$0
$195
$75
$195
$75
$195
$75
$195
$75
$780
$300
$195
$75
$195
$75
$195
$75
$195
$75
$780
$300
$780
$300
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$1,200
$68,280
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$300
$17,070
$0
$0
$1,200
$68,280
$0
$0
$1,200
$68,280
Page 29 of 62
Professional Services Budget
Professional Services
2018-2019
2019-2020
2020-2021
2021-2022
2022-2023
General
Attorneys
Accountants
Management consultants
Industry specialists
Technology consultants
Other (change title here)
Other (change title here)
Total Costs
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
GRAND TOTAL COSTS
$0
$0
$0
$0
$0
Page 30 of 62
Capital Investments and Loans
Capital Investments and Loans
Item
Amount
Equity Capital Investments
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Total Capital Investments
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Loans
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Total Loans
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
TOTAL INVESTMENTS AND LOANS
$0
Page 31 of 62
Date
Loan
Period
Interest
Rate
Month Year
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018 Capital investments
Nov
2018 are not paid back on a
loan schedule.
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
2018
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
Nov
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Capital Investments and Loans
Reminder: All invesments & loans must be on or after your business start date of:
November-2018
Page 32 of 62
Income Statements
Page 33 of 62
Income Statements
Income Statements
2018-2019
November
INCOME
Gross Sales
(Commissions)
(Returns and allowances)
Net Sales
(Cost of Goods)
GROSS PROFIT
EXPENSES - General and Administrative
Salaries and wages
Employee benefits
Payroll taxes
Professional services
Marketing and advertising
Rent
Equipment rental
Maintenance
Depreciation
Insurance
Telephone service
Utilities
Office supplies
Postage and shipping
Travel
Entertainment
Interest on loans
Other (change title here)
Other (change title here)
TOTAL EXPENSES
Net income before taxes and interest
Interest Income
Provision for taxes on income
NET PROFIT
December
January
February
March
April
May
June
July
August
September
October
TOTAL
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
-$6,040
$16
$0
-$6,024
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$11
$0
-$5,679
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$6
$0
-$5,684
$0
$0
$0
$0
$5,840
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,840
-$5,840
$1
$0
-$5,839
$0
$0
$0
$0
$5,890
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,890
-$5,890
$0
$0
-$5,890
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,840
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,840
-$5,840
$0
$0
-$5,840
$0
$0
$0
$0
$5,890
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,890
-$5,890
$0
$0
-$5,890
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$69,330
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$69,330
-$69,330
$35
$0
-$69,295
Page 34 of 62
Income Statements
Page 35 of 62
Income Statements
Income Statements
2019-2020
November
INCOME
Gross Sales
(Commissions)
(Returns and allowances)
Net Sales
(Cost of Goods)
GROSS PROFIT
EXPENSES - General and Administrative
Salaries and wages
Employee benefits
Payroll taxes
Professional services
Marketing and advertising
Rent
Equipment rental
Maintenance
Depreciation
Insurance
Telephone service
Utilities
Office supplies
Postage and shipping
Travel
Entertainment
Interest on loans
Other (change title here)
Other (change title here)
TOTAL EXPENSES
Net income before taxes and interest
Interest Income
Provision for taxes on income
NET PROFIT
December
January
February
March
April
May
June
July
August
September
October
TOTAL
$0
$0
$0
$0
$0
$0
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
-$6,040
$0
$0
-$6,040
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$5,690
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$5,690
-$5,690
$0
$0
-$5,690
$0
$0
$0
$0
$68,630
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$68,630
-$68,630
$0
$0
-$68,630
Page 36 of 62
Income Statements
Page 37 of 62
Income Statements
Income Statements
2020-2021
2021-2022
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
INCOME
Gross Sales
(Commissions)
(Returns and allowances)
Net Sales
(Cost of Goods)
GROSS PROFIT
EXPENSES - General and Administrative
Salaries and wages
Employee benefits
Payroll taxes
Professional services
Marketing and advertising
Rent
Equipment rental
Maintenance
Depreciation
Insurance
Telephone service
Utilities
Office supplies
Postage and shipping
Travel
Entertainment
Interest on loans
Other (change title here)
Other (change title here)
TOTAL EXPENSES
Net income before taxes and interest
Interest Income
Provision for taxes on income
NET PROFIT
TOTAL
2022-2023
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$68,280
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$68,280
-$68,280
$0
$0
-$68,280
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
-$17,070
$0
$0
-$17,070
$0
$0
$0
$0
$68,280
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$68,280
-$68,280
$0
$0
-$68,280
$0
$0
$0
$0
$68,280
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$68,280
-$68,280
$0
$0
-$68,280
Page 38 of 62
Cash Flow Statements
Cash Flow
2018-2019
November
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
December
January
February
March
April
May
June
July
August
September
October
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$16
$0
$0
$16
$0
$16
$11
$0
$0
$11
$0
$11
$6
$0
$0
$6
$0
$6
$1
$0
$0
$1
$0
$1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
$0
$0
$0
$0
$0
$0
$6,040
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,840
$0
$0
$0
$0
$0
$0
$5,840
$0
$5,890
$0
$0
$0
$0
$0
$0
$5,890
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,840
$0
$0
$0
$0
$0
$0
$5,840
$0
$5,890
$0
$0
$0
$0
$0
$0
$5,890
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
NET CASH FLOW
-$6,024
-$5,679
-$5,684
-$5,839
-$5,890
-$5,690
-$5,690
-$5,840
-$5,890
-$5,690
-$5,690
-$5,690
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
$25,000
$16
$6,040
$18,976
$18,976
$11
$5,690
$13,297
$13,297
$6
$5,690
$7,613
$7,613
$1
$5,840
$1,775
$1,775
$0
$5,890
-$4,115
-$4,115
$0
$5,690
-$9,805
-$9,805
$0
$5,690
-$15,495
-$15,495
$0
$5,840
-$21,335
-$21,335
$0
$5,890
-$27,225
-$27,225
$0
$5,690
-$32,915
-$32,915
$0
$5,690
-$38,605
-$38,605
$0
$5,690
-$44,295
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
Page 39 of 62
Cash Flow Statements
Cash Flow
TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
$0
$0
$0
$35
$0
$0
$35
$0
$35
$0
$69,330
$0
$0
$0
$0
$0
$0
$69,330
NET CASH FLOW
-$69,295
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
-$44,295
Page 40 of 62
Cash Flow Statements
Cash Flow
2019-2020
November
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
December
January
February
March
April
May
June
July
August
September
October
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,040
$0
$0
$0
$0
$0
$0
$6,040
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
$0
$5,690
$0
$0
$0
$0
$0
$0
$5,690
-$6,040
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$5,690
-$44,295
$0
$6,040
-$50,335
-$50,335
$0
$5,690
-$56,025
-$56,025
$0
$5,690
-$61,715
-$61,715
$0
$5,690
-$67,405
-$67,405
$0
$5,690
-$73,095
-$73,095
$0
$5,690
-$78,785
-$78,785
$0
$5,690
-$84,475
-$84,475
$0
$5,690
-$90,165
-$90,165
$0
$5,690
-$95,855
-$95,855
$0
$5,690
-$101,545
-$101,545
$0
$5,690
-$107,235
-$107,235
$0
$5,690
-$112,925
Page 41 of 62
Cash Flow Statements
Cash Flow
TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$68,630
$0
$0
$0
$0
$0
$0
$68,630
-$68,630
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
Page 42 of 62
-$112,925
Cash Flow Statements
Cash Flow
2020-2021
1st Quarter
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
2021-2022
2nd Quarter
3rd Quarter
4th Quarter
TOTAL
1st Quarter
2022-2023
2nd Quarter
3rd Quarter
4th Quarter
TOTAL
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$68,280
$0
$0
$0
$0
$0
$0
$68,280
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$17,070
$0
$0
$0
$0
$0
$0
$17,070
$0
$68,280
$0
$0
$0
$0
$0
$0
$68,280
$0
$68,280
$0
$0
$0
$0
$0
$0
$68,280
-$17,070
-$17,070
-$17,070
-$17,070
-$68,280
-$17,070
-$17,070
-$17,070
-$17,070
-$68,280
-$68,280
-$112,925
$0
$17,070
-$129,995
-$129,995
$0
$17,070
-$147,065
-$147,065
$0
$17,070
-$164,135
-$164,135
$0
$17,070
-$181,205
-$181,205
-$181,205
$0
$17,070
-$198,275
-$198,275
$0
$17,070
-$215,345
-$215,345
$0
$17,070
-$232,415
-$232,415
$0
$17,070
-$249,485
-$249,485
-$249,485
$0
$68,280
-$317,765
Page 43 of 62
Cash Flow Statements
Cash Flow
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner's Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
Page 44 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
First Quarter
2018-2019
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
$7,613
$0
$0
$0
$7,613
$0
$0
$0
$0
$0
$0
$0
$7,613
$0
$0
$0
$0
$0
$0
$0
$25,000
-$17,387
$7,613
$7,613
Page 45 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
Second Quarter
2018-2019
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$9,805
$0
$0
$0
-$9,805
$0
$0
$0
$0
$0
$0
$0
-$9,805
$0
$0
$0
$0
$0
$0
$0
$25,000
-$34,805
-$9,805
-$9,805
Page 46 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
Third Quarter
2018-2019
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$27,225
$0
$0
$0
-$27,225
$0
$0
$0
$0
$0
$0
$0
-$27,225
$0
$0
$0
$0
$0
$0
$0
$25,000
-$52,225
-$27,225
-$27,225
Page 47 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
Fourth Quarter
2018-2019
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$44,295
$0
$0
$0
-$44,295
$0
$0
$0
$0
$0
$0
$0
-$44,295
$0
$0
$0
$0
$0
$0
$0
$25,000
-$69,295
-$44,295
-$44,295
Page 48 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
2019-2020
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$112,925
$0
$0
$0
-$112,925
$0
$0
$0
$0
$0
$0
$0
-$112,925
$0
$0
$0
$0
$0
$0
$0
$25,000
-$137,925
-$112,925
-$112,925
Page 49 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
2020-2021
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$181,205
$0
$0
$0
-$181,205
$0
$0
$0
$0
$0
$0
$0
-$181,205
$0
$0
$0
$0
$0
$0
$0
$25,000
-$206,205
-$181,205
-$181,205
Page 50 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
2021-2022
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
-$249,485
$0
$0
$0
-$249,485
$0
$0
$0
$0
$0
$0
$0
-$249,485
$0
$0
$0
$0
$0
$0
$0
$25,000
-$274,485
-$249,485
-$249,485
Page 51 of 62
Balance Sheet
Balance Sheet
Palmer Organic Drink Company
2022-2023
ASSETS
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
-$317,765
$0
$0
$0
-$317,765
Fixed Assets
Land
Facilities
Equipment
Computers & Telecommunications
(Less Accumlated Depreciation)
Total Fixed Assets
Other Assets
TOTAL ASSETS
$0
$0
$0
$0
$0
$0
$0
-$317,765
LIABILITIES
Current Liabilities
Short-Term Notes Payable
Income Taxes Due
Other Current Liabilities
Total Current Liabilities
$0
$0
$0
$0
Long-Term Liabilities
Long-Term Notes Payable
Other Long-Term Liabilities
Total Long-Term Liabilities
NET WORTH
Paid-In Capital
Retained Earnings
Total Net Worth
TOTAL LIABILITIES AND NET WORTH
$0
$0
$0
$25,000
-$342,765
-$317,765
-$317,765
Page 52 of 62
Break-even Estimates
Break-even Estimates
Year 1 (2018-2019)
November
December
January
February
March
April
May
June
July
August
September
October
Monthly Average
Year 2 (2019-2020)
November
December
January
February
March
April
May
June
July
August
September
October
Monthly Average
Year 3 (2020-2021)
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Quarterly Average
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Year 4 (2021-2022)
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Quarterly Average
$0
Year 5 (2022-2023)
Annual Average
$0
Page 53 of 62
$0
$0
$0
$0
Key Ratios
Key Ratios
Year 1 (2018-2019)
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Working
Capital
Current Ratio
$7,613
N.A.
-$9,805
N.A.
-$27,225
N.A.
-$44,295
N.A.
Quick Ratio
N.A.
N.A.
N.A.
N.A.
Cash
Turnover
0.00
0.00
0.00
0.00
Debt to
Equity
0.00
0.00
0.00
0.00
Return on
Investment
-229%
178%
64%
39%
Return on
Sales
N.A.
N.A.
N.A.
N.A.
Return on
Assets
-229%
178%
64%
39%
Year 2 (2019-2020)
-$112,925
N.A.
N.A.
0.00
0.00
61%
N.A.
61%
Year 3 (2020-2021)
-$181,205
N.A.
N.A.
0.00
0.00
38%
N.A.
38%
Year 4 (2021-2022)
-$249,485
N.A.
N.A.
0.00
0.00
27%
N.A.
27%
Year 5 (2022-2023)
-$317,765
N.A.
N.A.
0.00
0.00
21%
N.A.
21%
Page 54 of 62
Year 1: Financials at-a-Glance (2018-2019)
$0
-$1,000
-$2,000
-$3,000
Gross Sales
-$4,000
Gross Profit
Net Profit
-$5,000
-$6,000
Page 55 of 62
October
September
August
July
June
May
April
March
February
January
December
November
-$7,000
Year 1: Net Sales (2018-2019)
$1
$1
$1
Product Line 3
$1
$1
$1
Product Line 2
$0
$0
$0
Product Line 1
$0
Page 56 of 62
October
September
August
July
June
May
April
March
February
January
December
November
$0
Year 1: Cash Flow (2018-2019)
$20,000
$10,000
$0
-$10,000
Net Cash Flow
-$20,000
Ending Cash Balance
-$30,000
-$40,000
Page 57 of 62
October
September
August
July
June
May
April
March
February
January
December
November
-$50,000
Year 2: Cash Flow (2019-2020)
$0
-$20,000
-$40,000
-$60,000
Net Cash Flow
Ending Cash Balance
-$80,000
-$100,000
Page 58 of 62
October
September
August
July
June
May
April
March
February
January
December
November
-$120,000
5-Year Financials at-a-Glance
$0
-$10,000
-$20,000
-$30,000
Gross Sales
Gross Profit
Net Profit
-$40,000
-$50,000
-$60,000
-$70,000
2018-2019
2019-2020
2020-2021
Page 59 of 62
2021-2022
2022-2023
5-Year Net Sales
$1
$1
$1
$1
Axis Title
$1
Product Line 1
$1
Product Line 2
Product Line 3
$0
$0
$0
$0
$0
2018-2019
2019-2020
2020-2021
Page 60 of 62
2021-2022
2022-2023
License Agreement
LICENSE AGREEMENT FOR PLANNINGSHOP’S BUSINESS PLAN FINANCIALS
This License Agreement is a legal agreement between you (the product purchaser/user) and PlanningShop for the Business
Plan Financials product (“Software”) that accompanies this Agreement, including all associated documentation and packaging.
By installing and/or using the Software, you accept the terms of this Agreement.
PRODUCT LICENSE
The Software is protected by intellectual property laws and treaties. It is owned by PlanningShop and licensed to you for your
use (not sold). You acknowledge that PlanningShop has conferred to you NO title or ownership of the Software or any of its
constituent parts. Re-distribution of the Software or any of constituent its parts, whether in an original or modified form, is
strictly forbidden.
1. General License. You may install one copy of the Software on a single computing device for use by a single user. Additional
users, whether using the same computing device or a separate device, must purchase additional licenses. Multi-user licenses
are available from PlanningShop. A second copy of the Software may be stored on a separate device for the sole purpose of
backing up the original copy. You may not copy, distribute, or resell the Software.
2. Unauthorized Use. You may not modify, disassemble, or reverse engineer the Software or its code for any form of
distribution. The Software, its content, design and programming are copyrighted by PlanningShop.
3. WARRANTY. THIS SOFTWARE IS PROVIDED AS IS. PLANNINGSHOP AND ITS AFFILIATED PARTIES MAKE NO
CLAIMS, PROMISES OR GUARANTEES ABOUT THE ACCURACY, COMPLETENESS, OR ADEQUACY OF THE
SOFTWARE FOR ANY PURPOPSE AND EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS, OMISSIONS, FAILURES, OR
DEFECTS. NO WARRANTY OF ANY KIND, IMPLIED, EXPRESS OR STATUTORY, INCLUDING BUT NOT LIMITED TO
THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A
PARTICULAR PURPOSE AND FREEDOM FROM COMPUTER VIRUS, IS GIVEN IN CONJUNCTION WITH THE
SOFTWARE.
4. DAMAGES. IN NO EVENT WILL PLANNINGSHOP BE LIABLE FOR ANY DAMAGES, INCLUDING WITHOUT
LIMITATION DIRECT OR INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, LOSSES OR EXPENSES
ARISING IN CONNECTION WITH THIS SOFTWARE OR USE THEREOF OR INABILITY TO USE BY ANY PARTY, OR IN
CONNECTION WITH ANY FAILURE OF PERFORMANCE, ERROR, OMISSION, DEFECT, OR COMPUTER VIRUS EVEN IF
THE PLANNINGSHOP, OR AFFILIATED PARTIES, ARE ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, LOSSES
OR EXPENSES.
5. Governing Law. This Agreement shall be treated as though it were executed and performed in Palo Alto, California, and
shall be governed by and construed in accordance with the laws of the State of California, USA (without regard to conflict of
law principles). All actions shall be subject to the limitations set forth in Section 3 and Section 4. The language in this
Agreement shall be interpreted as in accordance with its fair meaning and not strictly for or against either party. All legal
proceedings arising out of or in connection with this Agreement shall be brought solely in Palo Alto, California. You expressly
submit to the exclusive jurisdiction of said courts and consent to extraterritorial service of process. Should any part of this
Agreement be held invalid or unenforceable, that portion shall be construed consistent with applicable law and the remaining
portions shall remain in full force and effect.
6. Contact. Should you have any questions concerning this agreement, or if you desire to contact PlanningShop for any
reason, you may do so at: PlanningShop, 555 Bryant Street #180, Palo Alto, California, USA, 94301.
About Business Plan Financials
PlanningShop
Business Plan Financials
Version 3.1
SUBJECT TO END-USER LICENSE AGREEMENT
Copyright 2003-2017 PlanningShop. All rights reserved.
www.planningshop.com
This Assignment has two sections:
Section I: The Business Plan financials (Excel document)- complete this first
Using your NAB Company Portfolio and the first year of your business plan for the company, you will
complete all the worksheets in the entire Excel document in order, so that you can complete the Income
Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials
spreadsheet.
Notes:
•
•
•
The setup and marketing worksheet should already be completed from assignment 2.
Use the instructions provided in the Business Plan Financials Guide to help you complete this
document, as well as the NAB Portfolio (pages 4-8).
VIDEO GUIDE TO COMPLETING THE EXCEL DOCUMENT
To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content
button under the Post button to access the attachment option when you are ready to submit, attach your
document and then click submit)
Section II: Financial section of the business plan (type in a Word document and paste in the discussion
window). You will have 3 headings as outlined below:
1.Sources and use of funds
•
•
Outline the funds you have currently (see portfolio pages 4 and 8) and the ones you intend to
raise (you need to raise funds per the portfolio page 4)
Explain how do you plan to use the funds (a clear plan on how you will use the money)
Notes: Before addressing this section please review:
-Sources and Use of Funds section on page 312 of your textbook
-Sample plan on page 325 for an idea on how to address this section.
-The Cap Invest (Capital Investments and loans worksheet) in the Excel document
2.Plan assumptions
The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic.
In this section you will outline your plan assumptions.
Notes: Before addressing this section please review:
•
•
•
Article about the 5 key assumptions of your business plan.
https://www.thebalancesmb.com/question-key-assumptions-in-your-business-plan-1200853
Sample plan in your textbook page 326
Assumption sheet in your textbook page 313.
3.Break-even analysis
The break-even point is where you make enough money in revenue to pay your expenses but you do not
make money nor you do not lose money. In this section, you need to determine what this break -even
point is.
NON-ALCOHOLOIC BEVERAGE COMPANY
Business Plan Financials Worksheet Guidance
Below is guidance for data entry into cells of each of the separate Excel worksheets of the overall
Business Plan Financials. This is the base pro-forma financial statements for your business. Please
note: Many of the cells in the Business Plan Financials (BPF) are already prepopulated with
suggested/default values. Use the default numbers unless otherwise indicated.
Only cells with BLUE text can be changed. The cells in black will be filled in automatically, based
on your setup assumptions, or will be carried over from numbers you entered earlier on other
worksheets. Work in order – as every cell you complete will carry over to all other applicable Excel
worksheets (for example, if you enter a figure in the Staff Budget, that figure will carry over to your
Income Statement and Cash Flow Statement).
You are encouraged to work through the guide as early as possible. (Review the Course
Guide for specific due dates on specified worksheets; as assignments are due throughout the
course.)
Worksheet #1 - Set Up and Assumptions
Line 9: the month the academic quarter starts
Line 12: enter the year the academic quarter starts
Line 15: Two (students can choose the number of product lines to include up to 10 lines)
Line 18: they will sell 55% on credit
Line 21: 30 days (standard default; however, can be adjusted as needed)
Line 43: $16,500 (estimate of net sales after six month of weekend sales)
Line 49: 1.00% (Dodd-Frank Act of 2011 allows businesses to receive interests on business
accounts, per the agreement of the financial institution [range 0 to 1.50%])
Worksheet #2 - Sales Projections
Each student must determine this for their business—speculate on how your company will
grow and how much you will sell. Reflect this in/from your Operations Plan
Worksheet #3 – Inventory
Line 7: Ingredients
Line 8: Bottles/caps
Line 9: Labels
Line 10: Cartons
Repeat these four lines for each product line.
Worksheet #4 - Capital Expenditures
(Note: This applies to purchased equipment, not leased equipment.)
Facilities section: Students are not purchasing facilities (facility is already provided)
Equipment section: Capital Purchases should be additional expenses that each student might
decide to purchase. (Note – after the first year of business)
Current vans and other equipment should be captured in Line 23 as part of “Other Assets” on the
Balance Sheet, Worksheet 11.
Updated 2/26/2016
1
NON-ALCOHOLOIC BEVERAGE COMPANY
Business Plan Financials Worksheet Guidance
Computer Hardware/Software Section: Capital Purchases should be additional expenses that
each student might decide to purchase.
Current computer hardware/software should be captured as part of “Other Assets” on the balance
sheet, along with equipment mentioned above.
Worksheet #5 - Staffing Budget
Account for every paid employee using the appropriate Lines for the six categories of employees
(Management, Administrative/Support, Sales/Marketing, Operations/Production, Other, PartTime/Hourly) and when their employment will commence in accordance with the Operations Plan
and Management Plan.
(See Note # 1 and Note #3 of the NAB Company Portfolio for additional details)
Worksheet #6 - Marketing Budget
This is submitted with Assignment 2: Marketing Plan
Worksheet #7: Professional Services
Line 6: $2,000
Line 7: $1,500
Line 9: $2,000
Line 11: Mary Cates, JD $10,000 (first year only)
Worksheet #8 - Cap Investment
Equity Capital Investments:
Line 6: Melinda Cates $40,000
Line 7: Glass Bottles $3,000
Line 8: Metal Caps $300
Line 9: Cardboard Cartons $500
Line 10: NAB Ingredients $600
Line 11: Labels $840
Loans:
Line 24: Friends and Family $20,000; the loan period is 24; the interest rate is 5% [immediate
decision is needed, before proceeding to other sections]
(Note: Early pay off within 12 months @ 0% interest could apply; however if early payoff is not
chosen 5% interest at 24 months will automatically apply.) (See Note #3)
Add projections of other funds they intend to raise
Worksheet #9 - Income Statement
Line 20: $1,000
*Note the Leased equipment in the NAB Company Portfolio. (See Note #2)
The Income Statement is submitted with Assignment 3 Part 2: Business Plan – Draft
Worksheet #11 - Balance Sheet
This will automatically populate from other completed worksheets. (See Worksheet # 4 above)
Updated 2/26/2016
2
Purchase answer to see full
attachment