Expert answer:Discuss the Financials of your business

Solved by verified expert:This exercise is considered an academic writing exercise. Quality of response, grammar, and punctuation are considered in your overall grade.This exercise does not require the use of APA format or a cover page.This exercise uses the “Business Plan Financials” MS Excel template. Use the “Business Plan Financials Guide” to assist you in completing the required worksheets. (Both documents are also available in the Course Required Files in Week 1.)It is recommended that students construct their deliverable(s) using MS Word / MS Excel and then attach the document(s) to the discussion thread submission area in Blackboard.Use the “NAB Company Portfolio” (see: Course Required Files in Week 1) for reference. Provide the following information below.For year one of your NAB company’s Business Plan, complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the “Business Plan Financials” MS Excel template (see: Course Required Files in Week 1). Note: Attach the MS Excel worksheet to the discussion thread. Hints: Your marketing costs should already be included as you created your Marketing Budget in Week 4 and those will be filled in automatically.Hints: Use the figures you arrived at in the operations and technology sections of your plan to help fill out your financial forms.Hints: Work through the worksheets in order. The excel worksheets will automatically enter the numbers into your Income Statement.Develop the following financial sections of your NAB company’s Business Plan. Note: Attach the MS Word document to the discussion thread.Sources and use of fundsPlan assumptionsBreak-even analysis
business_plan_financials__1_.xlsm

nab_business_plan_guide.pdf

Unformatted Attachment Preview

Your Company Name
WARNING!
IT APPEARS THAT YOU DO NOT HAVE EXCEL’S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
Excel 2007 for Windows:
To enable macros:
1. Click the “Options” button in the Security Warning that appears at the top of this page.
2. A “Security Alert – Macros & Active X” window should appear.
3. Select the “Enable this content” radio button
4. Click the “OK” button.
Your workbook should be ready to use now.
If you do not see the “Security Warning” along the top of
this page, scroll down for more detailed instructions, under
“Excel 2007 on Windows – Enabling Macros”
Excel 2010 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.
If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instructions, under
“Excel 2010 and Excel 2013 on Windows – Enabling Macros”
Excel 2013 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.
If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instructions, under
“Excel 2010 & Excel 2013 on Windows – Enabling Macros”
Excel 2010 for Mac:
1. A pop-up window appears. Select “Enable Macros”.
2. Your workbook should now be ready to use.
Excel 2008 for Mac:
Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version
of Business Plan Financials from PlanningShop.
Your Company Name
Excel 2007 on Windows – Enabling Macros
Your Company Name
Excel 2010 and Excel 2013 on Windows – Enabling Macros
Your Company Name
WARNING!
XCEL’S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
ning that appears at the top of this page.
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
nabling Macros”
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
bling Macros”
Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version
Your Company Name
07 on Windows – Enabling Macros
1. From the Windows Ribbon, Select the circular “Windows” button in the
upper left.
2. From the drop-down menu that appears, press the Excel Options
button in the lower right.
3. From the “Excel Options” pop-up, select
Trust Center on the left side.
4. Select Trust Center Settings…. In the lower
right.
5. In the “Trust Center” popup, select “Macro Settings”
on the left side.
6. Then, select the Disable all
macros except digitally
signed macros. (This works
because the Planning Shop
signs all its workbooks with
digital certificates.)
7. Press OK twice.
Your Company Name
Excel 2013 on Windows – Enabling Macros
Note: The procedure is exactly the same for Excel 2010 and
Excel 2013, even though the Excel 2013 has a slightly different
look than these screenshots.
1. In the upper left corner of the Excel Ribbon, press the “File” tab.
2. Select Options, in the lower left
corner.
3. Select Trust Center from
the Lower Left.
4. Click the “Trust Center
Settings…” button in the
lower right
5. Select “Macros Settings”
from the left side menu
6. Select the “Disable all
macros except digitally
signed macros” radio button.
7. Click “OK” twice
Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your
business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies , by
Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com.
First, a few tips to get you started:
SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES
You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank “ORIG_PlanningShop_BizPlanFin(2.8)” file in
your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy.
NAVIGATING THE WORKSHEETS
You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a “PlanningShop” tab, that contains controls to let you navigate
between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2007, Excel 2010, Excel 2013, but the functionality is the same.
Excel 2007 for Windows:
Excel 2010 for Windows:
Excel 2013 for Windows:
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
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 10 of 69
15.00%
$5,000
25.00%
1.00%
Setup Assumptions
Page 11 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
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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 12 of 69
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.00
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
Page 13 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
April
$0
$0
$0
$0
$0
May
$0
$0
$0
$0
$0
June
$0
$0
$0
$0
$0
Page 14 of 69
July
$0
$0
$0
$0
$0
August
$0
$0
$0
$0
$0
September
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
October
$0
$0
$0
$0
$0
November
$0
$0
$0
$0
$0
December
$0
$0
$0
$0
$0
TOTAL
January
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Sales Projections
Sales Projections
2015
February
March
April
May
June
July
August
September
October
November
December
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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 15 of 69
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0.00
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
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
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
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
Page 16 of 69
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
0
$0
0
$0
0
$0
0
$0
$0
$0
$0
$0
$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
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
$0
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades