BUS599- Business Plan and financials, business & finance homework help
User Generated
threyra0217
Business Finance
Description
I will attach all previous assignments completed during the previous 10 weeks in order to put this assignment together. Most of the work has already been done.
Assignment 5: Business Plan – Final
This assignment consists of two (2) sections: your final business plan and your business plan financials. Note: You must submit both sections as separate files for the completion of this assignment.
You have completed all of the necessary sections of your business plan and will now create a final draft. Use any / all feedback you have received to polish your plan to the point that you could confidently show it to investors and potential partners or customers.
Refer to the Outline of a Business Plan, beginning on p. 399 of the course text. (Click here for help accessing a specific page number in your eBook.) Not all businesses will include all of these components in this order, but use the outline as a guide. Specifically your plan will not require the Development, Milestones, and Exit Plan section of the business plan.
Section 1: Business Plan (MS Word or equivalent)
Construct a ten to thirty (10-30) page business plan. Note: Twenty (20) pages are sufficient for most businesses.
- Write a one to three (1–3) page executive summary for your business plan, in which you justify:
- A clear and concise business concept.
- A thoroughly planned business concept.
- A capable management structure.
- A clear-cut market need.
- Significant competitive advantages for your business.
- Realistic financial projections.
- That investors have an excellent chance to make money.
- A realistic and developed exit plan.Note: Read Chapters 4 and 18 of the course text: Successful Business Plan . Use the plan preparation worksheets on pp. 58–61 and the sample executive summaries on pp. 62–66 to help guide you, choose to write either a synopsis summary or a narrative summary, and include highlights from the each section of your business plan.
- Combine all of the sections stated below and revise your initial business plan draft, which you submitted in Week 8, based on feedback you have received.
- Executive Summary
- Company Description (Assignment 1)
- Industry Analysis and Trends ( Assignment 1 )
- Target Market ( Assignment 2 )
- Competition ( Assignment 2 )
- Strategic Position & Risk Assessment ( Assignment 1 )
- Marketing Plan & Sales Strategy ( Assignment 2 )
- Operations Plan ( Assignment 3 Part 1 )
- Technology Plan ( Assignment 3 Part 1 )
- Management & Organization ( Assignment 3 Part 1 )
- Ethics & Social Responsibility ( Assignment 3 Part 2)
- The Financials ( Week 7 Discussion )
- The Financials and the Management description—must spark enough interest to convince a reader to continue. Enhance the two (2) mentioned sections to appropriately engage the reader.
- Hints: The financial section of your business plan will be derived from the previously completed financial worksheets.
- Format your assignment according to these formatting requirements:
- Cite the resources you have used to complete the exercise. Note: There is no minimum requirement for the number of resources used in the exercise.
- Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
- Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.
Section 2: Business Plan Financials (MS Excel worksheets bundled with course textbook)
- For year one, submit a revised Income Statement, Cash Flow Projection, and Balance Sheet from the “Business Plan Financials” Excel template based on your feedback from Project Deliverable 4: Business Plan – Draft .The specific course learning outcomes associated with this assignment are:
- Describe strategic planning techniques used to formulate alternative strategies designed to achieve stated business goals.
- Create a plan to implement a firm’s strategy and manage the change from current operations.
- Analyze strategies for exerting the internal leadership needed to drive the implementation of strategic initiatives and improve operating excellence.
- Use technology and information resources to research issues in strategic management.
- Write clearly and concisely about strategic management using proper writing mechanics.
Unformatted Attachment Preview
Tropi-Boost Juices Description and SWOT Analysis
Tropi-Boost Juices Description and SWOT Analysis.
Guerlen M. Goenaga
April 23, 2017
Dr. Henry Kerich
BUS599 - Strategic Management
Strayer University
1
Tropi-Boost Juices Description and SWOT Analysis
NAB Company Name and Significance.
Tropi-Boost Juices is a NAB company operating out of Tampa in the state of Florida.
Tropi-Boost Juices offers high end quality products that distinguish itself for the freshness,
tropical taste, nutritional value and energy booster properties that each juice bottle provides. The
company name indicates a taste that will make you feel like you are in a tropical beach giving
consumers a pleasurable break in their busy lives, and that the product has the energy boost
consumers need to accomplish their daily activities. The drink has the perfect mixture of
vegetables and fruits to provide the daily required vitamins and minerals. In the 5 year plan the
company has planned different flavors as a result of different mixture of tropical fruits and
vegetables. The current beverage is called Exotic Tropic (energy booster natural juice). When
coming from Cuba took me several years to drink juice, even orange juice since I was used to
drinking natural juices without preservatives, artificial sugars and/or flavoring. The idea of
creating this product came from wanting to provide this healthy experience to people that have
not been able to drink natural energy booster drinks at any time they desire.
The company will be located in Tampa, FL because is my home town and it has a very
positive aspect that it is rich in diverse culture. This was a crucial factor in making the decision
to start up the business because a natural and healthy juice is appealing to many different cultures
(Race and Hispanic origin, 2015). Being Tampa a diverse culture town opens up the market for
the product even more. The marketing and selling operations will start in Tampa which is 170
square miles. Tampa also has adjacent towns that are in a growing sprout. Young people are
aiming for better and healthier drink and food choices. A high number of the population are
Hispanics and/or descendants that miss their country, the freshness and taste of the tropical fruits.
2
Tropi-Boost Juices Description and SWOT Analysis
The price of Exotic Tropic will range from $2.79 to 2.99 for 8oz bottle depending on the sale
location.
Mission Statement
We are committed to offer a fresh and revitalizing product that replenishes your body from
inside out. A healthy drink with the daily requirements of vitamins and minerals that will
energize you in a natural way. The company strives for a high quality product to provide a
healthier and enhanced drink option. To Tropi-Boost Juices the consumers’ well-being is
imperative and that’s why we make sure we use high quality ingredients. We want to inspire
people to make better and healthier dietary choices and to enjoy their days to the fullest. Our aim
is to provide a wonderful experience in a bottle. The flavor of the exotic fruits of the tropical
regions will transport consumers to the Caribbean.
The company’s niche is: “To nurture you from inside, one flavorful drink will do wonders.”
Trends in the Non-alcoholic Beverage Industry
The trend for convenience keeps growing without at end goal in mind. Years ago it was
Millennials who wanted the convenience of buying online, eating out, ordering food, buying
microwavable meals, etc. When looking at convenience trends today, it can be said that is not
about the Millennial generation anymore. Technology has made the need for convenience even
higher making different generations have more choices at their fingertips. This trend can be
experienced in any market or field. Technology has provided resources to make people aware of
what they eat/drink and motivate them to make healthier choices by providing information at any
time. For instance, organic ingredients, less sugar in the drinks, reduced calories drinks, etc . It is
because of the fast pace life we are experiencing that making bad food and/or drink choices can
be common.
3
Tropi-Boost Juices Description and SWOT Analysis
The market is changing and an example of that is Coca-Cola. The Coca-Cola Company released
the first quarter results on April 25, 2017 announcing net revenue declined 11 percent to $9.1
billion. The company changed its focus from driving volume growth to driving revenue growth
and that’s why they gained value share in dairy, sparkling soft drinks, plant-based beverages and
juice. The beverage industry have been shifting its focus as the trend for healthier drink choices
increases (Coca-Cola releases first quarter results, April 25, 2017).
In 2016 Evergreen Packaging worked with EcoFocus Worldwide to conduct an
independent survey to examine the trends impacting the food and beverage industry with a study
base of 4,000 U.S. consumers from 18 to 65 years old. The survey concluded that the consumers
demand for beverages that offer benefits and are multifunctional will increase. In addition,
industry leaders should expect an increase in the demand for beverages that offer immunity and
energy booster, manage blood sugar, sleep aid, satiate the need for refreshment, etc. (Four Key
Beverage Industry Trends for 2017 are Changing What Consumers Buy, January, 2 2017).
Consumers lately are in the search for drinks that are multifunctional. For instance drinks
that fueled their body with nutrients, energy and with meal replacement capabilities. BevNet
informs that carbonated soft drinks category is expected to have a continuous decline in the next
five years while the natural and organics drinks demand will increase. Consumers keep
purchasing healthier drinks options and its accounting for 40% of the NAB beverage industry.
More than 50% of the consumers that go grocery shopping looking for a healthier beverage are
seeking for a good source of calcium, fiber, antioxidants, Omega-3, proteins and contain low
sugar levels (Evergreen Survey, 2017), Other aspects that are changing the NAB beverage
industry is the artificial sweeteners concerns that have been rising and that energy drinks are
becoming more popular.
4
Tropi-Boost Juices Description and SWOT Analysis
This type of non-alcoholic beverage was chosen because it is a healthier drink choice and
the number of consumers looking for healthier drink choices keep climbing. Also, because
provides the vitamins and minerals needed on a daily basis and fuels the body with what needs to
provide a natural energy boost. The market for energy drinks keeps growing even though is not
the healthiest option. Last but not least, this non-alcoholic beverage is good when is ice old or
room temperature which makes it a convenient option to substitute a meal and/or snack because
it fits the demanding life style that is trending. Nowadays, making healthier and better drink and
food choices is a lot more complex than we think. It is challenging to achieve a balanced diet
throughout the day with the rush and different schedules in a household.
Strategic Position
Tropi-Boost Juices goal is to become a leading natural and healthy beverage company in
Tampa. The company strategic position will emphasize the competitive advantage/differentiation
strategy it has because of the quality, convenience and price that offers. The convenience for the
strategic position was decided after looking at the target market and the beverage industry trends
(Abrahams, 2014). The target market are the Hispanic consumers in the area that miss the taste
of a good natural tropical flavor drink, the consumers that live a high paced lifestyle and are
always missing meals or snacks because they don’t have access to healthy options and the
consumers in general that are looking for healthy drink options. Most vending machines are full
of sodas and snacks full of sugars. There are several competitors in the area but are a lot more
expensive because they are individually own stores. Prices range from $4.95 to $7.00 for one
bottle/glass of 10oz but with a regular and well established clientele. Since there is already
competition it is expected that they will exert pressure and the business will have a slow
5
Tropi-Boost Juices Description and SWOT Analysis
beginning. The company will have to work hard to gain and maintain customer loyalty. This is
done by providing value and quality to the consumers.
Distribution Channels
At the beginning we will go directly to the main supermarkets chains in the area since
they reach a larger market. Next steps is to build a website where consumers can order the
product and depending on the amount ordered we would offer discounted shipping options for
the local distribution. The website will be closely managed and at the beginning it will be
managed by the founders or executives. Since one of our goals is to make the product available
at any time the following stage is to take our products to drugstores like Walgreens and CVS, gas
stations and privately owned supermarkets, college campuses, gyms, etc. At the beginning to
reduce cost, the company will take care of the distribution. Starting with one cargo van and a box
truck. As the business grow the company market and distribution strategies will grow as well.
The five year plan will be implemented as the business grow. New ventures can grow faster or
slower than projected.
Risk Management
There are risks in any business and that’s why risk management is such an important
function to make the businesses successful. Most of the time changes in a company come
accompanied and/or are the result of a project. In order for the company to be successful these
projects need to be successfully executed by effectively managing the many risks that could
emerge. The most important part in managing risks is not only to determine all risks but to be
able to differentiate the impact of each risk to create strategies in order to prevent them from
arising and to battle them in case they surface. The top four risks identified were competition,
6
Tropi-Boost Juices Description and SWOT Analysis
unknown product/afraid to try it, regulations and target market. The table below stated the
actions to take to prevent these risks from arising.
Risk Management Matrix
No.
1
Risk
Competition
Risk Level
High
Actions
Products need to be have a competitive pricing
and have them in convenient locations.
2
Unknown product /
Provide samples at stores and at the city’s
High
afraid to try it.
3
Regulations
markets and events.
High
Safeguard that all licenses, clearances and
approvals are received in a timely manner. For
instance, ingredients and nutrition label
approved by the FDA. Ensure ingredients are
continuously inspected.
4
Target Market
Moderate
Provide samples at stores and at the city’s
markets and events. Visit sales locations to offer
samples and educate consumers on the product.
SWOT Analysis
Strengths
•
Management staff offers great
Weaknesses
•
leadership skills.
•
Natural energy boost drink
•
Employees are properly trained.
Not having a strong and specific
marketing strategy
•
Local and national competitors may
limit the entrance in the market and
Internal
getting shelf space in some retailers.
7
Tropi-Boost Juices Description and SWOT Analysis
•
•
Received very good feedback from
•
Similar products in the market.
the people that have tried the drink
•
No brand recognition
recipe.
•
Consumers lack knowledge of the
Tropi-Boost Juices is in charge of
the product distribution.
•
•
•
Price advantage over the
competition in the area.
•
product and everything it offers.
Scheduling challenges for demos to
promote the product.
•
Tropi-Boost Juices doss not have a
Strong and adaptive business
different distributor that can carry on
strategy
the deliveries in case of unexpected
Low overhead.
events.
•
The company needs a temperature
controlled warehouse to storage drinks
in case the production is slowed down.
Opportunities
•
Potential for new markets.
•
Market segment is posed for rapid
growth.
External •
•
•
Improved similar products emerging
the market.
•
Political and economic changes that
Develop website page.
affect the consumers buying power
Get the product in all planned
decreasing the demand of the product.
locations.
•
Threats
•
Major companies in the beverage
industry investing on similar products
Maintain quality and cost balance
and becoming part of the competition.
even when supplies costs increase.
8
Tropi-Boost Juices Description and SWOT Analysis
•
Invest money in advertising and
•
Having only one place where the
social networking ads.
production is done. If for any reason
•
Emerging markets.
the production has to be stopped it has
•
New products
to be back up as soon as possible or
•
Consumers’ healthy trends.
there will be no product to distribute.
•
Not having a marketing and Public
relations team to establish a high end
customer relations.
•
City and government regulations.
•
Changes in the consumers trends.
9
Tropi-Boost Juices Description and SWOT Analysis
References
Abrahams, R. (2014). Successful business plan: Secrets & strategies. Palo Alto, CA, USA:
PlanningShop.Retrieved on April 25, 2017 from
https://strayer.vitalsource.com/#/books/9781933895475/cfi/6/2!/4/2/4/2@0:0
Race and Hispanic origin (2015). Retrieved on April 22, 2017 from
https://www.census.gov/quickfacts/table/RHI125215/1271000
Coca-Cola releases first quarter results (2017, April 25). Rutgers University libraries, online
industry news Retrieved On April 26, 2017 from
http://www.bevindustry.com/articles/90173-coca-cola-releases-first-quarter-results
Four key beverage industry trends for 2017 are changing what consumers buy (2017, January 2).
PR Newswire. Retrieved on April 24, 2017 from http://www.prnewswire.com/newsreleases/four-key-beverage-industry-trends-for-2017Evergreen survey (2017, January 2). Retrieved on April 24, 2017 from
http://evergreenpackaging.com/fresh-news/four-key-beverage-industry-trends-for-2017are-changing-what-consumers-buy).e-changing-what-consumers-buy-300384417.html
10
Running head: TROPI-BOOST JUICES MARJKETING PLAN
Tropi-Boost Juices Marketing Plan and Sales Strategy.
Guerlen M. Goenaga
May 12, 2017
Dr. Henry Kerich
BUS599 - Strategic Management
Strayer University
1
TROPI-BOOST JUICES MARKETING PLAN AND SALES STRATEGY
Company’s Target Market
Tropi-Boost Juices is a NAB company operating out of Tampa in the state of Florida.
Tropi-Boost Juices offers high-end quality products that distinguish itself for the freshness,
tropical taste, nutritional value, and energy booster properties that each juice bottle provides.
Tampa city is a rich market for the business, with a total population of 335,709. This is because
of its diverse culture. Many different cultures live in the city; including the Hispanics, Whites,
African American, Asians and many others. (Hispanics 77,472, Whites 211,217, Asians 11,560,
African American 87,872) these are cultures that appreciate quality and healthy drinks and foods
(Tampa census, 2010). The fact that the company will be able to produce drinks that are free of
preservatives and sugars will make it appreciated by many since these inclusions are of ill health
to the consumers (Grant, 2016). The town is full of educated individuals who understand the
meaning of a healthy living and would much appreciate drinks of this kind.
The youth age is also a major target for the market since they know the meaning of better
and healthier drinks and food choices. They make up a better portion of the total population of
the town about 78.2 % of the total population. This is the age bracket of (10-54) years. They are
the future leaders of the town’s economy and are therefore able to influence the food choice of
the general population. Since the drinks have also energizing content, it can be used for fitness
purposes. Therefore individuals who go for fitness exercise will be a major target market. These
will include almost all age group of the town’s population ranging from the old to the youths.
Fitness companies will, therefore, be able to buy the drinks in bulk to make access easier for
their customers in the places they will be working out. The drinks will also be able to provide
healthy experience to people that have not been able to drink natural energy booster drinks at any
time they desire (Baker, 2014).
TROPI-BOOST JUICES MARKETING PLAN AND SALES STRATEGY
Table 1: Tampa, FL population breakdown.
Company’s Market Competition
The company has several competitors in the market. This is one of the biggest risks it will
encounter since drinks have been produced by major companies and many other companies will
be emerging from time to time due to the high demand in the market. The competitors of the
company can be divided into major two groups. These are already established competitors and
new entry competitors. The already established competitors include Coke and Pepsi which have
3
TROPI-BOOST JUICES MARKETING PLAN AND SALES STRATEGY
been in the limelight in producing nonalcoholic drinks globally with a share market of 35% and
26% respectively in the town. Another established competitor is also the Red Bull which is wellknown for its production of energy drinks. These companies have grown their roots to capture
their customers globally. To rise to their level, the business will have to major on its production
of good quality drinks and also use well-established marketing techniques which can aid in
popularizing the products with the intended customers. Emerging competitors will as well be
handled by sticking to the plan of quality produce. To attract more customers, we will also
reduce our price. People tend to opt for a cheaper product, and this will be an added advantage to
us. The relative price for drinks ranges from $4.95 to $7.00 (Berger, 2014) while our price will
be ranging from $2.79 to 2.99 for 8oz bottle depending on the sale location.
Company’s Message
The company business name is Tropi-Boost Juices. This is due to its production of its
high quality energizing tropical drinks. The business has its slogan which is ‘We are committed
to offering a fresh and revitalizing product that replenishes your body from inside out.’ In its
marketing tactics, the business uses a key word to mobilize its customers. The key word in
marketing material is: ‘healthier and enhanced drink option.’ The drinks will be packaged in
plastic bottles for easier use and avoid the risk of breakage as in the case of glass bottles. The
business will have a website where it will be able to communicate with its customers and dealers
the will be www.tropi-boostjuices.co.org (Berger, 2014). The logo of the business will be simple
to portray the information about the high-quality drinks it produces. It will have a design of a
beach with tropical coconut trees to show its originality.
4
TROPI-BOOST JUICES MARKETING PLAN AND SALES STRATEGY
Marketing Vehicles
To popularize the business to its intended customers, the business will use various
marketing vehicles to catch them. These will include both online techniques such as social media
as well as getting into physical contact with the customers through the following methods;
sponsoring events, exhibiting at trade shows attended by retailers, and so on. Since the world is
also advancing technologically, the business will major mostly on the social media part (Boso,
Cadogan & Story, 2015). Most of the people have access to social media be it Facebook or
Twitter, Instagram or even Youtube. We will have accounts on these sites where we will be
marketing our products. We will also create pages where customers will like them to get our
daily feeds. Ads will also be used to these sites so that when one enters these sites, they find our
ads will advertise about our products. Therefore, skilled personnel will be employed to manage
these online accounts.
5
TROPI-BOOST JUICES MARKETING PLAN AND SALES STRATEGY
References
Boso, N., Cadogan, J. W., & Story, V. M. (2015). Do Coordination Flexibility and Market
Orientation Leverage Entrepreneurial Strategy to Predict Export Sales Performance?
In The Sustainable Global Marketplace (pp. 125-125). Springer International Publishing.
Berger, R. (2014). Sales excellence opens up new revenue and profit potential and wards off
commoditization| Operations Strategy| Functional know-how| Expertise| Roland Berger.
Baker, M. J. (2014). Marketing strategy and management. Palgrave Macmillan.
Baker, M. J. (2014). Marketing strategy and management. Palgrave Macmillan.
Grant, R. M. (2016). Contemporary strategy analysis: Text and cases edition. John Wiley &
Sons.
Tampa census (2010). Retrieved on May 12, 2017 from
https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?src=CF
6
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.7)" 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 2007 and Excel 2010, but the functionality is the same.
Excel 2007 for Windows
Excel 2010 & 2013 for Windows
Excel 2008 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, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain 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.
Version 2.8
Copyright © 2003-2014 PlanningShop
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows 7 with Microsoft Excel 2010
2. Microsoft Windows 7 with Microsoft Excel 2007
3. Microsoft Windows Vista with Microsoft Excel 2007
4. Microsoft Windows 8 with Microsoft Excel 2013
Mac
5. Mac OS X Lion (10.7) with Microsoft Excel 2011
If you use Windows (#1 - #4 above), then you need to install PlanningShop_BizPlanFin(2.8).exe.
If you use Mac (#5 above), you need to install PlanningShop_BizPlanFinMac(2.8).zip
Differences between Mac and Windows
Moving your Business Plan Financials workbook between Mac and Windows
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows 7 with Microsoft Excel 2010
2. Microsoft Windows 7 with Microsoft Excel 2007
3. Microsoft Windows Vista with Microsoft Excel 2007
4. Microsoft Windows 8 with Microsoft Excel 2013
Mac
5. Mac OS X Lion (10.7) with Microsoft Excel 2011
If you use Windows (#1 - #4 above), then you need to install PlanningShop_BizPlanFin(2.8).exe.
If you use Mac (#5 above), you need to install PlanningShop_BizPlanFinMac(2.8).zip
Differences between Mac and Windows
Both the Mac and Windows versions of PlanningShop's Business Plan Financials product will produce high quality,
detailed financial information for your business plan. However, there are some slight differences between the
functionality in Mac and Windows. These differences don't affect the data in your business plan, but they do affect
the user-friendliness of the Business Plan Financials workbook.
We did our very best to make the Windows and Mac versions as similar as possible. However, Microsoft does not
support customization of the Excel toolbar on Mac. Therefore, while we made every effort to preserve as much
functionality as possible on the Mac, there were a few things we were not able to do:
1) There is no PlanningShop Toolbar in the Business Plan Financials for Mac. Instead, you will need to navigate
between worksheets and charts using the Excel worksheet tabs (along the bottom edge of the workbook).
2) Business Plan Financials Help is not available directly from Excel. Instead, you should open the
BizPlanFin_Help(2.8).PDF file that was copied to your Mac alongside the PlanningShop_BizPlanFinMac(2.8).XLS
or PlanningShop_BizPlanFinMac(2.8).XLSM file.
We are as disappointed as you are that we can't provide the same level of functionality in Mac as we do for
Windows. We very much hope that Microsoft will remedy the situation in the next release of Excel for Mac, and that
we'll then be able to offer identical functionality.
Moving your Business Plan Financials workbook between Mac and Windows
We advise you to completely edit your Business Plan Financials workbook on either Mac or Windows, and to not
switch between the two platforms. However, if you must:
1. If you use Business Plan Financials for Mac on Excel 2008, and later open the workbook on Windows, the
PlanningShop Ribbon Tab and the Help for Business Plan Financials will no longer be available.
.
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?
2013
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 9 of 69
15.00%
$5,000
25.00%
1.00%
Setup Assumptions
Page 10 of 69
Sales Projections
Sales Projections
2013
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%
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%
2014
January
February
March
April
May
June
July
August
September
October
November
December
0
$0
$0
$0
$0.00
$0
$0.00
$0
0
$100
$0
$0
$0
$0
$0
$0
300
$100
$30,000
$2,250
$900.00
$26,850
$15,000
$11,850
306
5000
5100
5202
5306
5412
5520
5631
5743
$100
$100
$100
$100
$100
$100
$100
$100
$100
$30,600
$500,000
$510,000
$520,200
$530,604
$541,216
$552,040
$563,081
$574,343
$2,295
$37,500
$38,250
$39,015
$39,795
$40,591
$41,403
$42,231
$43,076
$918.00 $15,000.00 $15,300.00 $15,606.00 $15,918.12 $16,236.48 $16,561.21 $16,892.44 $17,230.29
$27,387
$447,500
$456,450
$465,579
$474,891
$484,388
$494,076
$503,958
$514,037
$15,300
$250,000
$255,000
$260,100
$265,302
$270,608
$276,020
$281,541
$287,171
$12,087
$197,500
$201,450
$205,479
$209,589
$213,780
$218,056
$222,417
$226,865
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
Page 11 of 69
TOTAL
January
43521
$4,352,085
$326,406
$130,563
$3,895,116
$2,176,042
$1,719,073
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
5858
$103
$600,475
$45,036
$18,014.26
$537,426
$300,238
$237,188
0.0
$0
$0
$0
$0
$0
$0
$0
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
2013
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%
2014
January
February
March
April
May
June
July
August
September
October
November
December
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
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$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
$30,000
306
$30,600
5000
$500,000
5100
$510,000
5202
$520,200
5306
$530,604
5412
$541,216
5520
$552,040
5631
$563,081
5743
$574,343
43521
$4,352,085
5858
$600,475
Page 12 of 69
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0
$0
$0
$0
$0
$0
$0
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
2013
Assumptions
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
2014
January
$0
$0
$0
$0
$0
February
$0
$0
$0
$0
$0
March
$2,250
$900
$26,850
$15,000
$11,850
April
$2,295
$918
$27,387
$15,300
$12,087
May
$37,500
$15,000
$447,500
$250,000
$197,500
June
$38,250
$15,300
$456,450
$255,000
$201,450
Page 13 of 69
July
$39,015
$15,606
$465,579
$260,100
$205,479
August
$39,795
$15,918
$474,891
$265,302
$209,589
September
$40,591
$16,236
$484,388
$270,608
$213,780
October
$41,403
$16,561
$494,076
$276,020
$218,056
November
$42,231
$16,892
$503,958
$281,541
$222,417
December
$43,076
$17,230
$514,037
$287,171
$226,865
TOTAL
January
$326,406
$130,563
$3,895,116
$2,176,042
$1,719,073
$45,036
$18,014
$537,426
$300,238
$237,188
Sales Projections
Sales Projections
2015
February
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
March
April
May
June
July
August
September
October
November
December
5975
6095
6217
6341
6468
6597
6729
6864
7001
7141
7284
$103
$103
$103
$103
$103
$103
$103
$103
$103
$103
$103
$612,485
$624,735
$637,229
$649,974
$662,973
$676,233
$689,758
$703,553
$717,624
$731,976
$746,616
$45,936
$46,855
$47,792
$48,748
$49,723
$50,717
$51,732
$52,766
$53,822
$54,898
$55,996
$18,374.55 $18,742.04 $19,116.88 $19,499.22 $19,889.20 $20,286.99 $20,692.73 $21,106.58 $21,528.71 $21,959.29 $22,398.47
$548,174
$559,138
$570,320
$581,727
$593,361
$605,228
$617,333
$629,680
$642,273
$655,119
$668,221
$306,242
$312,367
$318,615
$324,987
$331,487
$338,116
$344,879
$351,776
$358,812
$365,988
$373,308
$241,932
$246,770
$251,706
$256,740
$261,874
$267,112
$272,454
$277,903
$283,461
$289,131
$294,913
Product Line 2
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
Page 14 of 69
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
78572
$8,053,630
$604,022
$241,609
$7,207,999
$4,026,815
$3,181,184
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
22738
$105
$2,388,908
$179,168
$71,667.23
$2,138,072
$1,194,454
$943,619
24130
$105
$2,535,128
$190,135
$76,053.84
$2,268,939
$1,267,564
$1,001,376
25607
$105
$2,690,298
$201,772
$80,708.94
$2,407,817
$1,345,149
$1,062,668
27174
$105
$2,854,966
$214,122
$85,648.97
$2,555,194
$1,427,483
$1,127,711
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
2015
February
March
April
May
June
July
August
September
October
November
December
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
5975
$612,485
6095
$624,735
6217
$637,229
6341
$649,974
6468
$662,973
6597
$676,233
6729
$689,758
6864
$703,553
7001
$717,624
7141
$731,976
7284
$746,616
78572
$8,053,630
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
Page 15 of 69
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
22738
24130
25607
27174
$2,388,908 $2,535,128 $2,690,298 $2,854,966
Sales Projections
Sales Projections
2015
February
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
$45,936
$18,375
$548,174
$306,242
$241,932
March
$46,855
$18,742
$559,138
$312,367
$246,770
April
$47,792
$19,117
$570,320
$318,615
$251,706
May
$48,748
$19,499
$581,727
$324,987
$256,740
June
$49,723
$19,889
$593,361
$331,487
$261,874
July
$50,717
$20,287
$605,228
$338,116
$267,112
August
September
$51,732
$20,693
$617,333
$344,879
$272,454
Page 16 of 69
$52,766
$21,107
$629,680
$351,776
$277,903
October
$53,822
$21,529
$642,273
$358,812
$283,461
November
$54,898
$21,959
$655,119
$365,988
$289,131
December
$55,996
$22,398
$668,221
$373,308
$294,913
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
$604,022
$241,609
$7,207,999
$4,026,815
$3,181,184
$179,168
$190,135
$201,772
$214,122
$71,667
$76,054
$80,709
$85,649
$2,138,072 $2,268,939 $2,407,817 $2,555,194
$1,194,454 $1,267,564 $1,345,149 $1,427,483
$943,619 $1,001,376 $1,062,668 $1,127,711
Sales Projections
Sales Projections
2016
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
2017
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
99648
$10,469,299
$785,197
$314,079
$9,370,023
$5,234,650
$4,135,373
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
28837
$108
$3,105,455
$232,909
$93,163.66
$2,779,383
$1,552,728
$1,226,655
30602
$108
$3,295,534
$247,165
$98,866.02
$2,949,503
$1,647,767
$1,301,736
32475
$108
$3,497,247
$262,294
$104,917.41
$3,130,036
$1,748,624
$1,381,413
34463
$108
$3,711,307
$278,348
$111,339.20
$3,321,619
$1,855,653
$1,465,966
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
Page 17 of 69
TOTAL
126378
$13,609,543
$1,020,716
$408,286
$12,180,541
$6,804,772
$5,375,770
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
160278
$110
$17,691,696
$1,326,877
$530,750.89
$15,834,068
$8,845,848
$6,988,220
0
$0
$0
$0
$0
$0
$0
$0
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
2016
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
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
2017
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
99648
$10,469,299
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
28837
30602
32475
34463
$3,105,455 $3,295,534 $3,497,247 $3,711,307
126378
$13,609,543
160278
$17,691,696
Page 18 of 69
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0
$0
$0
$0
$0
$0
$0
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
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
2016
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
$785,197
$314,079
$9,370,023
$5,234,650
$4,135,373
$232,909
$247,165
$262,294
$278,348
$93,164
$98,866
$104,917
$111,339
$2,779,383 $2,949,503 $3,130,036 $3,321,619
$1,552,728 $1,647,767 $1,748,624 $1,855,653
$1,226,655 $1,301,736 $1,381,413 $1,465,966
Page 19 of 69
2017
TOTAL
$1,020,716
$408,286
$12,180,541
$6,804,772
$5,375,770
$1,326,877
$530,751
$15,834,068
$8,845,848
$6,988,220
Inventory
Inventory
2013
2014
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
$15,000
$0
$0
$0
$0
$0
$15,300
$0
$0
$0
$0
$0
$250,000
$0
$0
$0
$0
$0
$255,000
$0
$0
$0
$0
$0
$260,100
$0
$0
$0
$0
$0
$265,302
$0
$0
$0
$0
$0
$270,608
$0
$0
$0
$0
$0
$276,020
$0
$0
$0
$0
$0
$281,541
$0
$0
$0
$0
$0
$287,171
$0
$0
$0
$0
$0
$2,176,042
$0
$0
$0
$0
$0
$300,238
$0
$0
$0
$0
$0
$306,242
$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 20 of 69
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 21 of 69
Inventory
Inventory
2015
March
April
May
June
July
August
September
October
November
December
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
$1,194,454 $1,267,564 $1,345,149 $1,427,483
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Product Line 1
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$312,367
$0
$0
$0
$0
$0
$318,615
$0
$0
$0
$0
$0
$324,987
$0
$0
$0
$0
$0
$331,487
$0
$0
$0
$0
$0
$338,116
$0
$0
$0
$0
$0
$344,879
$0
$0
$0
$0
$0
$351,776
$0
$0
$0
$0
$0
$358,812
$0
$0
$0
$0
$0
$365,988
$0
$0
$0
$0
$0
$373,308
$0
$0
$0
$0
$0
$4,026,815
$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 22 of 69
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 23 of 69
Inventory
Inventory
2016
2017
TOTAL
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
$5,234,650
$0
$0
$0
$0
$0
$1,552,728 $1,647,767 $1,748,624 $1,855,653
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$6,804,772
$0
$0
$0
$0
$0
$8,845,848
$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 24 of 69
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 25 of 69
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)
Purchase
Date
Cost
Years of
Service
Salvage
Value
Reminder: All purchases must be on or after your business start date of:
January-2013
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Month
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Year
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
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
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
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
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
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
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
2013
2013
2013
2013
2013
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
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
Land is a
non-depreciable
asset
Page 26 of 69
Staffing Budget
Staffing Budget
2013
January
February
March
April
May
June
July
August
September
October
November
December
Management
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
2.00
$30,000
$833
$9,000
$69,833
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
1.00
$30,000
$417
$4,500
$34,917
Operations/Production
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
1000
10.0
$4.00
$40
$40,000
$3,000
$6,000
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits
Payroll Taxes
Page 27 of 69
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Hourly Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
$49,000
2.00
1000.00
$100,000
$3,833
$15,000
$118,833
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
1.00
1000.00
$70,000
$3,417
$10,500
$83,917
Page 28 of 69
Staffing Budget
Staffing Budget
TOTAL
Management
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$390,000
$5,417
$58,500
$453,917
Operations/Production
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
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
Payroll Taxes
Page 29 of 69
$480
$480,000
$36,000
$72,000
Staffing Budget
Total Costs
$588,000
TOTAL
# Full Time Employees
# Hourly Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
Page 30 of 69
$870,000
$41,417
$130,500
$1,041,917
Staffing Budget
Staffing Budget
2014
January
February
March
April
May
June
July
August
September
October
November
December
Management
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
1.00
$31,050
$438
$4,658
$36,145
1.00
$31,050
$438
$4,658
$36,145
1.00
$31,050
$438
$4,658
$36,145
1.00
$31,050
$438
$4,658
$36,145
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
1000
10.0
$4.14
$41
$41,400
$3,150
$6,210
1000
10.0
$4.14
$41
$41,400
$3,150
$6,210
1000
10.0
$4.14
$41
$41,400
$3,150
$6,210
1000
10.0
$4.14
$41
$41,400
$3,150
$6,210
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$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
Payroll Taxes
Page 31 of 69
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Hourly Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$50,760
$50,760
$50,760
$50,760
$0
$0
$0
$0
$0
$0
$0
$0
1.00
1000.00
$72,450
$3,588
$10,868
$86,905
1.00
1000.00
$72,450
$3,588
$10,868
$86,905
1.00
1000.00
$72,450
$3,588
$10,868
$86,905
1.00
1000.00
$72,450
$3,588
$10,868
$86,905
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
Page 32 of 69
Staffing Budget
Staffing Budget
2015
TOTAL
2016
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
Payroll Taxes
Total Costs
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$124,200
$1,750
$18,630
$144,580
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
0.00
$0
$0
$0
$0
$0
$0
$0
$0
$166
$165,600
$12,600
$24,840
0
0.0
$0.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$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.00
$0
$0
$0
$0
0
0.0
$0.00
$0
$0
$0
$0
0
$0.00
$0.00
$0
$0
$0
$0
0
$0.00
$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
Payroll Taxes
Page 33 of 69
Staffing Budget
Total Costs
TOTAL
# Full Time Employees
# Hourly Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
$203,040
$0
$0
$0
$0
$289,800
$14,350
$43,470
$347,620
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
Page 34 of 69
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
0.00
0.00
$0
$0
$0
$0
$0
$0
$0
$0
Staffing Budget
Staffing Budget
2017
TOTAL
Management
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
Administrative/Support
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
0.00
$0
$0
$0
$0
Other
# Salaried Employees
Avg Salary per Employee
Benefits
Payroll Taxes
Total Costs
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
Payroll Taxes
Page 35 of 69
0
0.0
$0
$0
$0
$0
$0
Staffing Budget
Total Costs
$0
TOTAL
# Full Time Employees
# Hourly Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
Page 36 of 69
0.00
0.00
$0.00
$0
$0
$0
Marketing Budget
For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates
from PlanningShop.
Marketing Budget
2013
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
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$1,800
$9,000
$6,000
$7,200
$5,400
$6,000
$9,000
$6,240
$5,040
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$11,400
$12,000
$7,200
$9,600
$6,000
$6,000
$1,800
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$9,600
$14,400
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$11,760
$16,800
$4,800
$18,000
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$14,400
$9,000
$0
$208,440
Page 37 of 69
Marketing Budget
Marketing Budget
2014
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
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$150
$750
$500
$600
$450
$500
$750
$520
$420
$1,800
$9,000
$6,000
$7,200
$5,400
$6,000
$9,000
$6,240
$5,040
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$950
$1,000
$600
$800
$500
$500
$150
$11,400
$12,000
$7,200
$9,600
$6,000
$6,000
$1,800
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$800
$1,200
$9,600
$14,400
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$980
$1,400
$400
$1,500
$11,760
$16,800
$4,800
$18,000
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$1,200
$750
$0
$17,370
$14,400
$9,000
$0
$208,440
Page 38 of 69
Marketing Budget
Marketing Budget
2015
2016
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
2017
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$1,800
$9,000
$6,000
$7,200
$5,400
$6,000
$9,000
$6,240
$5,040
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$450
$2,250
$1,500
$1,800
$1,350
$1,500
$2,250
$1,560
$1,260
$1,800
$9,000
$6,000
$7,200
$5,400
$6,000
$9,000
$6,240
$5,040
$1,800
$9,000
$6,000
$7,200
$5,400
$6,000
$9,000
$6,240
$5,040
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$11,400
$12,000
$7,200
$9,600
$6,000
$6,000
$1,800
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$2,850
$3,000
$1,800
$2,400
$1,500
$1,500
$450
$11,400
$12,000
$7,200
$9,600
$6,000
$6,000
$1,800
$11,400
$12,000
$7,200
$9,600
$6,000
$6,000
$1,800
$2,400
$3,600
$2,400
$3,600
$2,400
$3,600
$2,400
$3,600
$9,600
$14,400
$2,400
$3,600
$2,400
$3,600
$2,400
$3,600
$2,400
$3,600
$9,600
$14,400
$9,600
$14,400
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$11,760
$16,800
$4,800
$18,000
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$2,940
$4,200
$1,200
$4,500
$11,760
$16,800
$4,800
$18,000
$11,760
$16,800
$4,800
$18,000
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$14,400
$9,000
$0
$208,440
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$3,600
$2,250
$0
$52,110
$14,400
$9,000
$0
$208,440
$14,400
$9,000
$0
$208,440
Page 39 of 69
Professional Services Budget
Professional Services
2013
2014
2015
2016
2017
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 40 of 69
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 41 of 69
Date
Loan
Period
Interest
Rate
Month Year
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013 Capital investments
Jan
2013 are not paid back on a
loan schedule.
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
2013
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
2013
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-2013
Page 42 of 69
Income Statements
Page 43 of 69
Income Statements
Income Statements
2013
January
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
Provision for taxes on income
NET PROFIT
February
March
April
May
June
July
August
September
October
November
December
TOTAL
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$30,000
$2,250
$900
$26,850
$15,000
$11,850
$30,600
$2,295
$918
$27,387
$15,300
$12,087
$500,000
$37,500
$15,000
$447,500
$250,000
$197,500
$510,000
$38,250
$15,300
$456,450
$255,000
$201,450
$520,200
$39,015
$15,606
$465,579
$260,100
$205,479
$530,604
$39,795
$15,918
$474,891
$265,302
$209,589
$541,216
$40,591
$16,236
$484,388
$270,608
$213,780
$552,040
$41,403
$16,561
$494,076
$276,020
$218,056
$563,081
$42,231
$16,892
$503,958
$281,541
$222,417
$574,343
$43,076
$17,230
$514,037
$287,171
$226,865
$4,352,085
$326,406
$130,563
$3,895,116
$2,176,042
$1,719,073
$100,000
$3,833
$15,000
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$136,203
-$136,203
$0
-$136,203
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
-$101,287
$0
-$101,287
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
-$89,437
$0
-$89,437
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
-$89,200
$0
-$89,200
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$96,213
$24,053
$72,160
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$100,163
$25,041
$75,123
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$104,192
$26,048
$78,144
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$108,302
$27,075
$81,226
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$112,494
$28,123
$84,370
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$116,769
$29,192
$87,577
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$121,130
$30,283
$90,848
$70,000
$3,417
$10,500
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,287
$125,579
$31,395
$94,184
$870,000
$41,417
$130,500
$0
$208,440
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,250,357
$468,717
$117,179
$351,538
Page 44 of 69
Income Statements
Page 45 of 69
Income Statements
Income Statements
2014
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
$600,475
$45,036
$18,014
$537,426
$300,238
$237,188
#########
$45,936.37
$18,374.55
#########
#########
#########
$624,735
$46,855
$18,742
$559,138
$312,367
$246,770
$637,229
$47,792
$19,117
$570,320
$318,615
$251,706
$649,974
$48,748
$19,499
$581,727
$324,987
$256,740
$662,973
$49,723
$19,889
$593,361
$331,487
$261,874
$676,233
$50,717
$20,287
$605,228
$338,116
$267,112
$689,758
$51,732
$20,693
$617,333
$344,879
$272,454
$703,553
$52,766
$21,107
$629,680
$351,776
$277,903
$717,624
$53,822
$21,529
$642,273
$358,812
$283,461
$731,976
$54,898
$21,959
$655,119
$365,988
$289,131
$746,616
$55,996
$22,398
$668,221
$373,308
$294,913
$8,053,630
$604,022
$241,609
$7,207,999
$4,026,815
$3,181,184
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
Provision for taxes on income
NET PROFIT
$72,450
$3,588
$10,868
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$104,275
$132,913
$33,228
$99,685
$72,450
$3,588
$10,868
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$104,275
$137,657
$34,414
$103,242
$72,450
$3,588
$10,868
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$104,275
$142,495
$35,624
$106,871
$72,450
$3,588
$10,868
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$104,275
$147,431
$36,858
$110,573
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$239,370
$59,842
$179,527
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$244,504
$61,126
$183,378
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$249,742
$62,435
$187,306
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$255,084
$63,771
$191,313
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$260,533
$65,133
$195,400
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$266,091
$66,523
$199,569
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$271,761
$67,940
$203,820
$0
$0
$0
$0
$17,370
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$17,370
$277,543
$69,386
$208,157
$289,800
$14,350
$43,470
$0
$208,440
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$556,060
$2,625,124
$656,281
$1,968,843
Page 46 of 69
Income Statements
Page 47 of 69
Income Statements
Income Statements
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
Provision for taxes on income
NET PROFIT
2015
2016
2017
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$2,388,908
$179,168
$71,667
$2,138,072
$1,194,454
$943,619
$2,854,966
$214,122
$85,649
$2,555,194
$1,427,483
$1,127,711
$10,469,299
$785,197
$314,079
$9,370,023
$5,234,650
$4,135,373
$3,105,455
$232,909
$93,164
$2,779,383
$1,552,728
$1,226,655
$3,711,307
$278,348
$111,339
$3,321,619
$1,855,653
$1,465,966
$13,609,543
$1,020,716
$408,286
$12,180,541
$6,804,772
$5,375,770
$17,691,696
$1,326,877
$530,751
$15,834,068
$8,845,848
$6,988,220
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$52,110
$52,110
$52,110
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$52,110
$52,110
$52,110
$949,266 $1,010,558 $1,075,601
$237,316
$252,639
$268,900
$711,949
$757,918
$806,701
$0
$0
$0
$0
$208,440
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$208,440
$3,926,933
$981,733
$2,945,200
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$52,110
$52,110
$52,110
$52,110
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$52,110
$52,110
$52,110
$52,110
$1,174,545 $1,249,626 $1,329,303 $1,413,856
$293,636
$312,406
$332,326
$353,464
$880,909
$937,219
$996,977 $1,060,392
$0
$0
$0
$0
$208,440
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$208,440
$5,167,330
$1,291,832
$3,875,497
$0
$0
$0
$0
$208,440
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$208,440
$6,779,780
$1,694,945
$5,084,835
$0
$0
$0
$0
$52,110
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$52,110
$891,509
$222,877
$668,631
$2,535,128
$190,135
$76,054
$2,268,939
$1,267,564
$1,001,376
$2,690,298
$201,772
$80,709
$2,407,817
$1,345,149
$1,062,668
Page 48 of 69
$3,295,534
$247,165
$98,866
$2,949,503
$1,647,767
$1,301,736
$3,497,247
$262,294
$104,917
$3,130,036
$1,748,624
$1,381,413
Cash Flow Statements
Cash Flow
2013
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
TOTAL
$0
$0
$0
$0
$0
$0
$22,500
$0
$22,500
$22,950
$7,500
$30,450
$375,000
$7,650
$382,650
$382,500
$125,000
$507,500
$390,150
$127,500
$517,650
$397,953
$130,050
$528,003
$405,912
$132,651
$538,563
$414,030
$135,304
$549,334
$422,311
$138,010
$560,321
$430,757
$140,770
$571,527
$3,264,063
$944,435
$4,208,499
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$22,500
$0
$0
$0
$0
$0
$30,450
$0
$0
$0
$0
$0
$382,650
$161
$0
$0
$161
$0
$507,661
$462
$0
$0
$462
$0
$518,112
$772
$0
$0
$772
$0
$528,775
$1,090
$0
$0
$1,090
$0
$539,653
$1,416
$0
$0
$1,416
$0
$550,750
$1,750
$0
$0
$1,750
$0
$562,071
$2,093
$0
$0
$2,093
$0
$573,621
$7,744
$0
$0
$7,744
$0
$4,216,243
$0
$136,203
$0
$0
$0
$0
$0
$0
$136,203
$0
$101,287
$0
$0
$0
$0
$0
$0
$101,287
$0
$101,287
$3,150
$0
$0
$0
$0
$0
$104,437
$0
$101,287
$3,213
$0
$0
$0
$0
$0
$104,500
$0
$101,287
$52,500
$0
$0
$0
$0
$0
$153,787
$0
$101,287
$53,550
$0
$0
$0
$0
$0
$154,837
$0
$101,287
$54,621
$0
$0
$0
$0
$0
$155,908
$0
$101,287
$55,713
$0
$0
$0
$0
$0
$157,000
$0
$101,287
$56,828
$0
$0
$0
$0
$0
$158,114
$0
$101,287
$57,964
$0
$0
$0
$0
$0
$159,251
$0
$101,287
$59,124
$0
$0
$0
$0
$0
$160,410
$0
$101,287
$60,306
$0
$0
$0
$0
$0
$161,593
$0
$1,250,357
$456,969
$0
$0
$0
$0
$0
$1,707,326
NET CASH FLOW
-$136,203
-$101,287
-$81,937
-$74,050
$228,863
$352,824
$362,205
$371,775
$381,538
$391,499
$401,661
$412,028
$2,508,917
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
$5,000
$0
$136,203
-$131,203
-$131,203
$0
$101,287
-$232,490
-$232,490
$22,500
$104,437
-$314,427
-$314,427
$30,450
$104,500
-$388,476
-$388,476
$382,650
$153,787
-$159,613
-$159,613
$507,661
$154,837
$193,211
$193,211
$518,112
$155,908
$555,416
$555,416
$927,191 $1,308,729 $1,700,228 $2,101,889
$528,775
$539,653
$550,750
$562,071
$573,621
$157,000
$158,114
$159,251
$160,410
$161,593
$927,191 $1,308,729 $1,700,228 $2,101,889 $2,513,917
$2,513,917
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 49 of 69
Cash Flow Statements
Cash Flow
2014
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
TOTAL
$450,357
$143,586
$593,942
$459,364
$150,119
$609,483
$468,551
$153,121
$621,672
$477,922
$156,184
$634,106
$487,480
$159,307
$646,788
$497,230
$162,493
$659,724
$507,175
$165,743
$672,918
$517,318
$169,058
$686,376
$527,665
$172,439
$700,104
$538,218
$175,888
$714,106
$548,982
$179,406
$728,388
$559,962
$182,994
$742,956
$6,040,223
$1,970,339
$8,010,562
$2,450
$0
$0
$2,450
$0
$596,393
$2,820
$0
$0
$2,820
$0
$612,302
$3,199
$0
$0
$3,199
$0
$624,871
$3,587
$0
$0
$3,587
$0
$637,693
$4,058
$0
$0
$4,058
$0
$650,846
$4,538
$0
$0
$4,538
$0
$664,262
$5,029
$0
$0
$5,029
$0
$677,947
$5,531
$0
$0
$5,531
$0
$691,907
$6,043
$0
$0
$6,043
$0
$706,147
$6,566
$0
$0
$6,566
$0
$720,672
$7,100
$0
$0
$7,100
$0
$735,488
$7,645
$0
$0
$7,645
$0
$750,601
$58,565
$0
$0
$58,565
$0
$8,069,127
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
$104,275
$63,050
$0
$0
$0
$0
$0
$167,325
$0
$104,275
$64,311
$0
$0
$0
$0
$0
$168,586
$0
$104,275
$65,597
$0
$0
$0
$0
$0
$169,872
$0
$104,275
$66,909
$0
$0
$0
$0
$0
$171,184
$0
$17,370
$68,247
$0
$0
$0
$0
$0
$85,617
$0
$17,370
$69,612
$0
$0
$0
$0
$0
$86,982
$0
$17,370
$71,004
$0
$0
$0
$0
$0
$88,374
$0
$17,370
$72,425
$0
$0
$0
$0
$0
$89,795
$0
$17,370
$73,873
$0
$0
$0
$0
$0
$91,243
$0
$17,370
$75,350
$0
$0
$0
$0
$0
$92,720
$0
$17,370
$76,858
$0
$0
$0
$0
$0
$94,228
$0
$17,370
$78,395
$0
$0
$0
$0
$0
$95,765
$0
$556,060
$845,631
$0
$0
$0
$0
$0
$1,401,691
NET CASH FLOW
$429,068
$443,717
$454,999
$466,509
$565,228
$577,280
$589,573
$602,113
$614,904
$627,951
$641,260
$654,836
$6,667,436
$2,513,917 $2,942,985 $3,386,702 $3,841,700 $4,308,209 $4,873,438 $5,450,717 $6,040,290 $6,642,403 $7,257,306 $7,885,257 $8,526,518
$596,393
$612,302
$624,871
$637,693
$650,846
$664,262
$677,947
$691,907
$706,147
$720,672
$735,488
$750,601
$167,325
$168,586
$169,872
$171,184
$85,617
$86,982
$88,374
$89,795
$91,243
$92,720
$94,228
$95,765
$2,942,985 $3,386,702 $3,841,700 $4,308,209 $4,873,438 $5,450,717 $6,040,290 $6,642,403 $7,257,306 $7,885,257 $8,526,518 $9,181,354
$9,181,354
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
Page 50 of 69
Cash Flow Statements
Cash Flow
2015
2016
1st Quarter 2nd Quarter 3rd Quarter 4th 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
TOTAL
2017
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$1,791,681 $1,901,346 $2,017,724 $2,141,224
$584,805
$621,597
$659,644
$700,019
$2,376,486 $2,522,943 $2,677,367 $2,841,243
$7,851,975
$2,566,065
$10,418,040
$2,329,092 $2,471,651 $2,622,935 $2,783,480
$755,490
$808,044
$857,502
$909,988
$3,084,581 $3,279,694 $3,480,438 $3,693,468
$10,207,157
$3,331,024
$13,538,181
$13,268,772
$4,363,623
$17,632,395
$28,137
$33,719
$39,660
$45,983
$0
$0
$0
$0
$0
$0
$0
$0
$28,137
$33,719
$39,660
$45,983
$0
$0
$0
$0
$2,404,623 $2,556,662 $2,717,028 $2,887,226
$147,500
$0
$0
$147,500
$0
$10,565,539
$52,864
$60,200
$68,003
$76,302
$0
$0
$0
$0
$0
$0
$0
$0
$52,864
$60,200
$68,003
$76,302
$0
$0
$0
$0
$3,137,445 $3,339,894 $3,548,441 $3,769,771
$257,370
$0
$0
$257,370
$0
$13,795,551
$461,636
$0
$0
$461,636
$0
$18,094,031
$0
$52,110
$389,687
$0
$0
$0
$0
$0
$441,797
$0
$208,440
$1,429,002
$0
$0
$0
$0
$0
$1,637,442
$0
$208,440
$1,857,628
$0
$0
$0
$0
$0
$2,066,068
$12,158,109
$16,027,963
$30,597,286
$30,597,286
$18,094,031
$2,066,068
$46,625,248
$0
$52,110
$250,835
$0
$0
$0
$0
$0
$302,945
$0
$52,110
$266,188
$0
$0
$0
$0
$0
$318,298
$0
$52,110
$282,481
$0
$0
$0
$0
$0
$334,591
$0
$52,110
$299,771
$0
$0
$0
$0
$0
$351,881
$0
$208,440
$1,099,276
$0
$0
$0
$0
$0
$1,307,716
NET CASH FLOW
$2,101,678 $2,238,364 $2,382,436 $2,535,345
$9,257,823
$2,759,262 $2,941,753 $3,129,120 $3,327,974
Opening Cash Balance
Cash Receipts
Cash Disbursements
ENDING CASH BALANCE
$9,181,354 ######### ######### #########
$2,404,623 $2,556,662 $2,717,028 $2,887,226
$302,945
$318,298
$334,591
$351,881
######### ######### ######### #########
$18,439,176
######### ######### ######### #########
$3,137,445 $3,339,894 $3,548,441 $3,769,771
$378,183
$398,141
$419,321
$441,797
######### ######### ######### #########
Page 51 of 69
$0
$52,110
$326,073
$0
$0
$0
$0
$0
$378,183
$0
$52,110
$346,031
$0
$0
$0
$0
$0
$398,141
$0
$52,110
$367,211
$0
$0
$0
$0
$0
$419,321
Balance Sheet
Balance Sheet
Your Company Name
First Quarter
2013
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
-$314,427
$7,500
-$15,000
$0
-$321,927
$0
$0
$0
$0
$0
$0
$0
-$321,927
$0
$0
$0
$0
$0
$0
$0
$5,000
-$326,927
-$321,927
-$321,927
Page 52 of 69
Balance Sheet
Balance Sheet...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
This question has not been answered.
Create a free account to get help with this and any other question!
Similar Content
Nonaka's model of knowledge
"Organizations impart certain types of knowledge to employees through formal training, whereas some forms of information c...
CSUFresno Is Climate Change A Hoax Memo and PPT
1) 380 word memoAfter working a few years, you would like to extend your college education on a part-time basis.
You know...
UCLA Modes of Communication Questionnaire
1 - Siemering outlines what National Public Radio should do in what he calls "cultural mode," and "journalistic mode." Exp...
Group Dynamics
Answers must be in APA format, with in text citations. Have a total of 3 scholarly sources, with a total of 1000 words. I ...
Fair Labor Standards Act, law homework help
Assignment 3: The Fair Labor Standards ActThe Fair Labor Standards Act (FLSA) is one of the complex laws governing employm...
Need accounting help with aspects in planning
What are the important aspects to consider in planning?...
Conflict Management
Conflict management is essential, considering that it helps in maintaining peace and unity among people. Conflicts are par...
acc_210_week_1_dq_2.doc
acc_210_week_1_dq_2.doc...
Diversity marketing class lectures_86263405-Animal-Diversity-Intro
uploads/services/161584/Diversity marketing class lectures_86263405-Animal-Diversity-Intro.pdf...
