Hello,

I need assistance with the attached document (Financial Plan Template) for my class. The requirement is to make sure toinclude:

Income Statement Statement of Stock-Owner's Equity Balance Sheet Cash Flow Statement (There should be positive cash flow in the 5th year to attract investors). Additional points to be considered are:

-Adding value to the Intellectual Property in the Financial Plan

- Include the growth value

- Annual revenue, annual growth, COGS percentages, Operating Income percentages, Years 15 NI, and cash flow.

- Most importantly the investor is looking for 40-50% of ROI at the end of the 5th year

I have included another 2 Documents to assist with the product that we are pitching for which also includes some of the figures that we are trying to utilize. Feel free to make add/remove#s based upon your recommendation to fit within the budget and accomplish the ROI for the investor. You cancontact me if any more details are required.

Thank you

Welcome! Thank you for trying out Business Plan Financials from Planning Shop. These worksheets will help you develop cle your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, The Successful Bu Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop Note that this demo copy of Business Plan Financials is deliberately feature-limited. We restrict you to just one product, one capital expenditures. If you purchase the Business Plan Financials, you get access to up to 10 products, 60 capital expend loans. Also, the watermark that appears and prints on each page willbe removed. To use the Business Plan Financials workbook, first go to the Planning Shop tab of the Excel Ribbon. Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue ce calculated for you. While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate th popup when you roll over the triangle, presenting you with additional information and tips about the section you are working For more in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files cont worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the Planning Shop toolbar to reach the "Setup and Assumptions" wor information about your business. Version 2.7 Copyright 2003-2012 Planning Shop Welcome to the Mac Version of Business Plan Financials Thank you for purchasing Planning Shop's Business Plan Financials. These worksheets will help you develop clea your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Th Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www First, a few tips to get you started: 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 "ORIGINAL_PlanningShop_BusinessPlanFinancialsMac(2.7)" file in your PlanningShop directory. Make a copy of this file ( yet again), and then start editing the copy. You installed the Mac version of the Business Plan Financials product, which does not have the Planning Shop tab available version). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the E Start with the "Setup" worksheet. Enter your data, and then work your way through the workbook, one worksheet at a time, There are 23 worksheets/charts in this workbook. The last one (furthest to the right) is "NS5Yr." Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue ce calculated for you. While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate th popup when you roll over the triangle, presenting you with additional information and tips about the section you are working For more in-depth help and assistance, refer to the Business Plan Financials Help" PDF file in your PlanningShop folder. Th instructions and includes a "Frequently Asked Questions" section. To get started, find the Excel worksheet listing (each worksheet is listed on a tab) along the bottom of the Excel window. Clic and Assumptions" worksheet, where you'll enter some basic information about your business. Version 2.7 Copyright 2003-2012 Planning Shop Welcome to Business Plan Financials! Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, comp business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Busin 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 your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start ed NAVIGATING THE WORKSHEETS You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2007, Excel 2010, Excel 2013, but the func 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 wind 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 ce calculated for you. While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate th popup when you roll over the triangle, presenting you with additional information and tips about the section you are working FOR MORE HELP For more in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files cont 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" workshee 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 8 with Microsoft Excel 2013 2. Microsoft Windows 7 with Microsoft Excel 2010 3. Microsoft Windows 7 with Microsoft Excel 2007 4. Microsoft Windows Vista with Microsoft Excel 2007 Mac 5. Mac OS X Lion (10.7) with Microsoft Excel 2011 If you use Windows (#1 - #3 above), then you need to install PlanningShop_BizPlanFin(2.8).exe. If you use Mac (#4 above), you need to install PlanningShop_BizPlanFinMac(2.8).dmg 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.7).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. If you switch between platforms, you may find that the Planning Shop toolbar, menus, online help, and macros permanently disappear. 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? T e n Ten 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? 25% 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? 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. Page 23 of 146 15.00% $5,000 Setup 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 24 of 146 25.00% 1.00% 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 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% January February March April May June July 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 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $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 25 of 146 Sales Projections Sales Projections (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 Product Line 6 Unit Volume 2013 Assumptions 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% January $0 $0 $0 $0 $0 February $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 March April May June July $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $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 26 of 146 Sales Projections Sales Projections 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 2013 Assumptions 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% January $0 $0 $0 $0 $0 $0 $0 February $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 March April May June July $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 Page 27 of 146 Sales Projections Sales Projections 2013 Assumptions 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 (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% 2.00% 2.50% 50.00% 15.00% 3.00% 50.00% January February March April May June July 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Page 28 of 146 Sales Projections Sales Projections 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 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 Product Line 3 Unit Volume Unit Price Gross Sales 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Page 29 of 146 TOTAL 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 Sales Projections Sales Projections (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT August $0 $0 $0 $0 $0 September $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 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 Product Line 6 Unit Volume Page 30 of 146 October November December $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT August $0 $0 $0 $0 $0 $0 $0 September $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 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 Page 31 of 146 October November December $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections August September October November December TOTAL 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 32 of 146 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections 2014 January February March April May June July August 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 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 Product Line 3 Unit Volume Unit Price Gross Sales 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Page 33 of 146 Sales Projections Sales Projections 2014 (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT January $0 $0 $0 $0 $0 February $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 Product Line 5 Unit Volume Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT Product Line 6 Unit Volume March April May June July August $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 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 34 of 146 Sales Projections Sales Projections 2014 Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT January $0 $0 $0 $0 $0 $0 $0 February $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 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 March April May June July August $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 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 35 of 146 Sales Projections Sales Projections 2014 January February March April May June July August 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 36 of 146 Sales Projections Sales Projections 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 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 Product Line 3 Unit Volume Unit Price Gross Sales 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Page 37 of 146 TOTAL 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 Sales Projections Sales Projections (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT September $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 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 Product Line 6 Unit Volume October November December $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 38 of 146 TOTAL $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT September $0 $0 $0 $0 $0 $0 $0 October November December $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 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 Page 39 of 146 TOTAL $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 Sales Projections Sales Projections September October November December TOTAL 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 40 of 146 0 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections 2015 2016 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 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 Product Line 3 Unit Volume Unit Price Gross Sales 0 $0 $0 0 $0 $0 0 $0 $0 0 $0 $0 Page 41 of 146 TOTAL 1st Quarter 2nd Quarter 3rd Quarter 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 $0 $0 $0 0 $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 (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 2015 2016 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 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 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 Product Line 6 Unit Volume Page 42 of 146 TOTAL $0 $0 $0 $0 $0 0 1st Quarter 2nd Quarter 3rd 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 Sales Projections Sales Projections Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 2015 2016 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 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 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 Page 43 of 146 TOTAL $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 1st Quarter 2nd Quarter 3rd 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 Sales Projections Sales Projections 2015 2016 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 44 of 146 TOTAL 1st Quarter 2nd Quarter 3rd 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 $0 $0 $0 $0 $0 $0 0 Sales Projections Sales Projections 2017 4th Quarter 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 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 Product Line 3 Unit Volume Unit Price Gross Sales 0 $0 $0 Page 45 of 146 TOTAL 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 Sales Projections Sales Projections 2017 (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 4th Quarter $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 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 Product Line 6 Unit Volume Page 46 of 146 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 Sales Projections Sales Projections 2017 Unit Price Gross Sales (Commissions) (Returns and Allowances) Net Sales (Cost of Goods Sold) GROSS PROFIT 4th Quarter $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 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 Page 47 of 146 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 Sales Projections Sales Projections 2017 4th Quarter TOTAL 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 0 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Totals for All Product Lines Total Unit Volume Total Gross Sales (Total Commissions) (Total Returns and Allowances) Total Net Sales (Total Cost of Goods Sold) TOTAL GROSS PROFIT Page 48 of 146 0 $0 $0 $0 $0 $0 $0 0 0 $0 $0 $0 $0 $0 $0 $0 Inventory Inventory 2013 January February March April May June July August Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 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 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 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 $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 49 of 146 Inventory 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 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 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 Product Line 7 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 Product Line 8 Cost of Goods Sold Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 50 of 146 Inventory 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 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 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 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 GRAND TOTAL INVENTORY Page 51 of 146 Inventory Inventory September October November December TOTAL Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 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 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 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 52 of 146 Inventory Items/Parts 3 Items/Parts 4 Total Inventory Expense $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 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 Product Line 7 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 Product Line 8 Cost of Goods Sold Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 53 of 146 Inventory 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 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 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 Err:502 Err:502 Err:502 Err:502 $0 GRAND TOTAL INVENTORY Page 54 of 146 Inventory Inventory 2015 2016 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 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 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 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 $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 55 of 146 Inventory 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 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 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 Product Line 7 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 Product Line 8 Cost of Goods Sold Items/Parts 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 56 of 146 Inventory 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 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 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 GRAND TOTAL INVENTORY $0 $0 $0 $0 $0 $0 $0 $0 Page 57 of 146 Inventory Inventory 2017 4th Quarter TOTAL Product Line 1 Cost of Goods Sold Items/Parts 1 Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 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 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 Product Line 4 Cost of Goods Sold Items/Parts 1 Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 58 of 146 Inventory Items/Parts 3 Items/Parts 4 Total Inventory Expense $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 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 Product Line 7 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 Product Line 8 Cost of Goods Sold Items/Parts 1 $0 $0 $0 $0 $0 $0 Page 59 of 146 Inventory Items/Parts 2 Items/Parts 3 Items/Parts 4 Total Inventory Expense $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 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 GRAND TOTAL INVENTORY $0 $0 $0 Page 60 of 146 Capital Purchases Capital Purchases Item Purchase Date Cost Years of Service Salvage Value 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) $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 Page 61 of 146 Land is a non-depreciable asset Staffing Budget Staffing Budget 2013 January February March April May June July Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Page 62 of 146 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND 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 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $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 Page 63 of 146 Staffing Budget Staffing Budget August September October November December TOTAL Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Page 64 of 146 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND 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 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 65 of 146 Staffing Budget Staffing Budget 2014 January February March April May June July Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Page 66 of 146 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND 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 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $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 Page 67 of 146 Staffing Budget Staffing Budget August September October November December TOTAL Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 $0 $0 $0 Page 68 of 146 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND 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 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 69 of 146 Staffing Budget Staffing Budget 2015 2016 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) 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 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 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 (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 Page 70 of 146 TOTAL 1st Quarter 2nd Quarter $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 $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 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND 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 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $0 $0 $0 $0 $0 0 0.0 $0.00 $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 Page 71 of 146 $0 $0 $0 $0 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 0 0.0 $0.00 $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 Staffing Budget Staffing Budget 2017 3rd Quarter 4th Quarter Management # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 Administrative/Support # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 Sales/Marketing # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 Operations/Production # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 Page 72 of 146 TOTAL TOTAL $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 $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 Staffing Budget Other # Salaried Employees Avg Salary per employee Benefits (across all employees) Payroll Taxes (across all employees) Total Costs Part-Time / Hourly Employees # Part-Time Employees Avg. Hours per Hourly Employee Avg Hourly Rate Calculated Wages Per Hourly Employee Wages Benefits (across all employees) Payroll Taxes (across all employees) Total Costs 0.00 $0 $0 $0 $0 0.00 $0 $0 $0 $0 0 $0.00 $0.00 $0 $0 $0 $0 $0 0 $0.00 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL # Full Time Employees # Part-Time Employees Salary/Wages Benefits Payroll Taxes GRAND TOTAL COSTS Page 73 of 146 $0 $0 $0 $0 0.00 $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 Marketing Budget 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 February March April May June July August $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 74 of 146 Marketing Budget GRAND TOTAL COSTS $0 $0 $0 Page 75 of 146 $0 $0 $0 $0 $0 Marketing Budget Marketing Budget September 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 October November December TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 76 of 146 Marketing Budget GRAND TOTAL COSTS $0 Page 77 of 146 $0 $0 $0 $0 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 February March April May June July August $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 78 of 146 Marketing Budget GRAND TOTAL COSTS $0 $0 $0 Page 79 of 146 $0 $0 $0 $0 $0 Marketing Budget Marketing Budget September 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 October November December TOTAL $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Page 80 of 146 Marketing Budget GRAND TOTAL COSTS $0 Page 81 of 146 $0 $0 $0 $0 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 TOTAL 1st Quarter 2nd Quarter 3rd 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 Page 82 of 146 Marketing Budget GRAND TOTAL COSTS $0 $0 $0 Page 83 of 146 $0 $0 $0 $0 $0 Marketing Budget Marketing Budget 2017 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 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 Page 84 of 146 Marketing Budget GRAND TOTAL COSTS $0 Page 85 of 146 $0 $0 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 86 of 146 Capital Investments and Loans Capital Investments and Loans Item Amount Date Equity Capital Investments Investmen