WK 8 REDO

profileJada8600
ORIGINAL_PlanningShop_BizPlanFin3.1BUS5991.xlsm
Home>Business & Finance homework help>Management homework help>WK 8 REDO

Warning

W A R N I N G !
IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.
Excel 2010 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 and Excel 2013 on Windows - Enabling Macros"
Excel 2013& 2016 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 & Excel 2013 on Windows - Enabling Macros"
Excel 2011 & 2016 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use.
Excel 2013 and Excel 2016 on Windows - Enabling Macros
Note: The procedure is exactly the same for Excel 2013 & 2016, even though the two versions look slightly different. 1. In the upper left corner of the Excel Ribbon, press the "File" tab.
2. Select Options, in the lower left corner.
3. Select Trust Center from the Lower Left. 4. Click the "Trust Center Settings…" button in the lower right
5. Select "Macros Settings" from the left side menu 6. Select the "Disable all macros except digitally signed macros" radio button. 7. Click "OK" twice

Your Company Name

Welcome

Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. First, a few tips to get you started: SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIG_PlanningShop_BizPlanFin(2.8)" file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy. NAVIGATING THE WORKSHEETS You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that contains controls to let you navigate between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same.
Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.
Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:
In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
HOW TO FILL IN THE WORKSHEETS Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically calculated for you.
While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
FOR MORE HELP For more in-depth help and assistance,please refer to the companion PDF entitled "Business Plan Financials Help". It contains extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365
2. Microsoft Windows 8 or later with Microsoft Excel 2013
Mac
4 Mac OS X with Microsoft Excel 2016
5. Mac OS X with Microsoft Excel for Mac 2011
Version 3.1 Copyright © 2003-2017 PlanningShop

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Dynamic Auto Glass
What month will you officially start your company? January ERROR:#VALUE!
What year will you officially start your company? 2021
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? Three
Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.
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%
Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.
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
Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)? $3,500
Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)? $2,500
Author: This number should reflect the amount you will spend on ONE PART-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
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? 15.00%
Author: If you're not sure what percentage to enter here, leave it at the default (15%).
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. $350,000
Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.
At approximately what rate do you expect to be taxed on your net income? 25.00%
Author: If you're not sure what percentage to enter here, leave it at the default (25%).

Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.		 If you will use an interest-bearing account for your banking, at what rate will you accrue interest? 1.00%
Author: If you're not sure what percentage to enter here, leave it at the default (1.00%).

Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.
Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.
Author: If you're not sure what percentage to enter here, leave it at the default (15%).
Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

Setup & Assumptions

SalesProj

Sales Projections
Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.		 2021 2022 2023 2024 2025
Assumptions January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Replacement Front Winshield
Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.
Unit Volume 2.00%
Author: MONTHLY VOLUME GROWTH RATE The Worksheets automatically increase the volume in each month on this line using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 115
Author: Enter the number of units you expect to sell during this month. If you are running a service-based company charging on an hourly basis, enter the number of billable hours you expect you and your employees to work during this month. If you will be selling your service on a per-project basis, enter the number of projects you expect to sell during this period.		 117
Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 120 122 124 127 130 132 135 137 140 275 1674 281 286 292 298 304 310 316 322 329 335 342 349 3762 1089
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 1155 1226 1301 4771 1381 1465 1555 1650 6051 7674
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.
Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $375.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $375.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $375.00 $375.00 $375.00 $375.00 $375.00 $375.00 $375.00 $375.00 $375.00 $375.00 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $384.38 $393.98 $393.98 $393.98 $393.98 $403.83 $403.83 $403.83 $403.83 $413.93
Gross Sales $43,125 $43,988 $44,867 $45,765 $46,680 $47,613 $48,566 $49,537 $50,528 $51,538 $52,569 $103,125.00 $627,901 $107,817 $109,974 $112,173 $114,416 $116,705 $119,039 $121,420 $123,848 $126,325 $128,852 $131,429 $134,057 $1,446,054 $428,936 $455,190 $483,051 $512,618 $1,879,795 $557,594 $591,723 $627,941 $666,376 $2,443,635 $3,176,598
(Commissions) 0.00%
Author: COMMISSIONED SALES What percentage of this product line's sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 0.00%
Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00%
Author: RETURNS AND ALLOWANCES A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate--but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.		 $1,293.75 $1,320 $1,346.02 $1,372.94 $1,400.40 $1,428.40 $1,456.97 $1,486.11 $1,515.83 $1,546.15 $1,577.07 $3,093.75 $18,837 $3,234.52 $3,299.21 $3,365.19 $3,432.49 $3,501.14 $3,571.17 $3,642.59 $3,715.44 $3,789.75 $3,865.55 $3,942.86 $4,021.71 $43,382 $12,868.07 $13,655.70 $14,491.54 $15,378.53 $56,394 $16,727.82 $17,751.69 $18,838.24 $19,991.29 $73,309 $95,297.93
Net Sales $41,831 $42,668 $43,521 $44,392 $45,279 $46,185 $47,109 $48,051 $49,012 $49,992 $50,992 $100,031 $609,064 $104,583 $106,674 $108,808 $110,984 $113,204 $115,468 $117,777 $120,133 $122,535 $124,986 $127,486 $130,035 $1,402,672 $416,068 $441,534 $468,560 $497,239 $1,823,401 $540,866 $573,971 $609,103 $646,385 $2,370,326 $3,081,300
(Cost of Goods Sold) 28.00%
Author: COST OF GOODS Approximately what percentage of your product's sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product's sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero.		 $12,075.00 $12,317 $12,563 $12,814 $13,070 $13,332 $13,598 $13,870 $14,148 $14,431 $14,719 $28,875 $175,812 $30,189 $30,793 $31,408 $32,037 $32,677 $33,331 $33,998 $34,677 $35,371 $36,078 $36,800 $37,536 $404,895 $120,102 $127,453 $135,254 $143,533 $526,342 $156,126 $165,682 $175,824 $186,585 $684,218 $889,447
GROSS PROFIT $29,756 $30,351 $30,958 $31,578 $32,209 $32,853 $33,510 $34,181 $34,864 $35,561 $36,273 $71,156 $433,252 $74,394 $75,882 $77,399 $78,947 $80,526 $82,137 $83,780 $85,455 $87,164 $88,908 $90,686 $92,499 $997,777 $295,966 $314,081 $333,305 $353,706 $1,297,058 $384,740 $408,289 $433,280 $459,800 $1,686,108 $2,191,852
Replacement Back Winshield
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume 5.00% 110 116 121 127 134 140 147 155 163 171 179 188 1751 198 207 218 229 240 252 265 278 292 306 322 338 3144 1118
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 1295 1499 1735 5647 2008 2325 2692 3116 10141 18211
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $400.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $400.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $410.00 $420.25 $420.25 $420.25 $420.25 $430.76 $430.76 $430.76 $430.76 $441.53
Gross Sales $44,000 $46,200 $48,510 $50,936 $53,482 $56,156 $58,964 $61,912 $65,008 $68,258 $71,671 $75,255 $700,354 $80,993 $85,043 $89,295 $93,760 $98,448 $103,370 $108,539 $113,965 $119,664 $125,647 $131,929 $138,526 $1,289,178 $470,001 $544,085 $629,846 $729,126 $2,373,057 $865,155 $1,001,526 $1,159,391 $1,342,140 $4,368,212 $8,040,798
(Commissions) 0.00% 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $1,320 $1,386 $1,455 $1,528 $1,604 $1,685 $1,769 $1,857 $1,950 $2,048 $2,150 $2,258 $21,011 $2,430 $2,551 $2,679 $2,813 $2,953 $3,101 $3,256 $3,419 $3,590 $3,769 $3,958 $4,156 $38,675 $14,100 $16,323 $18,895 $21,874 $71,192 $25,955 $30,046 $34,782 $40,264 $131,046 $241,224
Net Sales $42,680 $44,814 $47,055 $49,407 $51,878 $54,472 $57,195 $60,055 $63,058 $66,211 $69,521 $72,997 $679,343 $78,563 $82,491 $86,616 $90,947 $95,494 $100,269 $105,282 $110,546 $116,074 $121,878 $127,971 $134,370 $1,250,502 $455,901 $527,762 $610,951 $707,252 $2,301,866 $839,201 $971,480 $1,124,609 $1,301,876 $4,237,166 $7,799,574
(Cost of Goods Sold) 28.00% $12,320 $12,936 $13,583 $14,262 $14,975 $15,724 $16,510 $17,335 $18,202 $19,112 $20,068 $21,071 $196,099 $22,678 $23,812 $25,003 $26,253 $27,565 $28,944 $30,391 $31,910 $33,506 $35,181 $36,940 $38,787 $360,970 $131,600 $152,344 $176,357 $204,155 $664,456 $242,244 $280,427 $324,629 $375,799 $1,223,099 $2,251,423
GROSS PROFIT $30,360 $31,878 $33,472 $35,145 $36,903 $38,748 $40,685 $42,720 $44,856 $47,098 $49,453 $51,926 $483,244 $55,885 $58,680 $61,613 $64,694 $67,929 $71,325 $74,892 $78,636 $82,568 $86,696 $91,031 $95,583 $889,533 $324,301 $375,418 $434,594 $503,097 $1,637,410 $596,957 $691,053 $799,980 $926,077 $3,014,066 $5,548,151
Replacement Windows
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Unit Volume 2.00% 100 102 104 106 108 110 113 115 117 120 122 124 1341 127 129 132 135 137 140 143 146 149 152 155 158 1701 492
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 522 554 588 2157 624 662 703 746 2736 3470
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $275.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $275.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $275.00 $275.00 $275.00 $275.00 $275.00 $275.00 $275.00 $275.00 $275.00 $275.00 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $281.88 $288.92 $288.92 $288.92 $288.92 $296.14 $296.14 $296.14 $296.14 $303.55
Gross Sales $27,500 $28,050 $28,611 $29,183 $29,767 $30,362 $30,969 $31,589 $32,221 $32,865 $33,522 $34,193 $368,832 $35,749 $36,464 $37,193 $37,937 $38,695 $39,469 $40,259 $41,064 $41,885 $42,723 $43,577 $44,449 $479,463 $142,221 $150,926 $160,164 $169,967 $623,277 $184,879 $196,196 $208,204 $220,948 $810,227 $1,053,253
(Commissions) 0.00% 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 3.00% $825 $842 $858 $875 $893 $911 $929 $948 $967 $986 $1,006 $1,026 $11,065 $1,072 $1,094 $1,116 $1,138 $1,161 $1,184 $1,208 $1,232 $1,257 $1,282 $1,307 $1,333 $14,384 $4,267 $4,528 $4,805 $5,099 $18,698 $5,546 $5,886 $6,246 $6,628 $24,307 $31,598
Net Sales $26,675 $27,209 $27,753 $28,308 $28,874 $29,451 $30,040 $30,641 $31,254 $31,879 $32,517 $33,167 $357,767 $34,676 $35,370 $36,077 $36,799 $37,535 $38,285 $39,051 $39,832 $40,629 $41,441 $42,270 $43,115 $465,079 $137,954 $146,398 $155,359 $164,868 $604,579 $179,333 $190,310 $201,958 $214,320 $785,921 $1,021,656
(Cost of Goods Sold) 28.00% $7,700 $7,854 $8,011 $8,171 $8,335 $8,501 $8,671 $8,845 $9,022 $9,202 $9,386 $9,574 $103,273 $10,010 $10,210 $10,414 $10,622 $10,835 $11,051 $11,272 $11,498 $11,728 $11,962 $12,202 $12,446 $134,250 $39,822 $42,259 $44,846 $47,591 $174,518 $51,766 $54,935 $58,297 $61,865 $226,864 $294,911
GROSS PROFIT $18,975 $19,355 $19,742 $20,136 $20,539 $20,950 $21,369 $21,796 $22,232 $22,677 $23,130 $23,593 $254,494 $24,667 $25,160 $25,663 $26,176 $26,700 $27,234 $27,778 $28,334 $28,901 $29,479 $30,068 $30,670 $330,829 $98,132 $104,139 $110,513 $117,277 $430,061 $127,567 $135,375 $143,661 $152,454 $559,057 $726,745
Product Line 4
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 28.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
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
Product Line 5
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 30.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
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
Product Line 6
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.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
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
Product Line 7
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.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
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
Product Line 8
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.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
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
Product Line 9
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.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
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
Product Line 10
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 Unit Volume 2.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
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don't stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates). As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.		 $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate.		 $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!
Author: Note that in year three we use quarterly numbers, not monthly numbers--so make sure you enter your amounts accordingly!		 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 50.00% 15.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
(Returns and Allowances) 3.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
Net 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 50.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
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
Totals for All Product Lines
Total Unit Volume 325 335 345 355 366 378 390 402 414 428 441 587 4766 605 623 642 661 681 702 723 746 769 793 818 844 8607 2699 2972 3279 3624 12575 4013 4453 4950 5512 18928 29355
Total Gross Sales $114,625 $118,238 $121,988 $125,883 $129,929 $134,132 $138,499 $143,038 $147,756 $152,662 $157,763 $212,573 $1,697,087 $224,559 $231,480 $238,661 $246,113 $253,848 $261,878 $270,217 $278,877 $287,874 $297,221 $306,935 $317,032 $3,214,695 $1,041,157 $1,150,200 $1,273,061 $1,411,710 $4,876,129 $1,607,629 $1,789,444 $1,995,537 $2,229,464 $7,622,074 $12,270,649
(Total Commissions) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Total Returns and Allowances) $3,439 $3,547 $3,660 $3,776 $3,898 $4,024 $4,155 $4,291 $4,433 $4,580 $4,733 $6,377 $50,913 $6,737 $6,944 $7,160 $7,383 $7,615 $7,856 $8,107 $8,366 $8,636 $8,917 $9,208 $9,511 $96,441 $31,235 $34,506 $38,192 $42,351 $146,284 $48,229 $53,683 $59,866 $66,884 $228,662 $368,119
Total Net Sales $111,186 $114,690 $118,329 $122,107 $126,031 $130,108 $134,344 $138,747 $143,324 $148,082 $153,030 $206,196 $1,646,174 $217,822 $224,535 $231,501 $238,729 $246,232 $254,022 $262,110 $270,511 $279,238 $288,305 $297,727 $307,521 $3,118,254 $1,009,922 $1,115,694 $1,234,869 $1,369,359 $4,729,845 $1,559,400 $1,735,761 $1,935,671 $2,162,581 $7,393,412 $11,902,530
(Total Cost of Goods Sold) $32,095 $33,107 $34,157 $35,247 $36,380 $37,557 $38,780 $40,051 $41,372 $42,745 $44,174 $59,520 $475,184 $62,876 $64,814 $66,825 $68,912 $71,077 $73,326 $75,661 $78,086 $80,605 $83,222 $85,942 $88,769 $900,114 $291,524 $322,056 $356,457 $395,279 $1,365,316 $450,136 $501,044 $558,750 $624,250 $2,134,181 $3,435,782
TOTAL GROSS PROFIT $79,091 $81,584 $84,172 $86,859 $89,651 $92,551 $95,565 $98,696 $101,952 $105,337 $108,856 $146,675 $1,170,990 $154,946 $159,721 $164,676 $169,818 $175,155 $180,696 $186,450 $192,425 $198,633 $205,083 $211,785 $218,752 $2,218,139 $718,398 $793,638 $878,412 $974,080 $3,364,529 $1,109,264 $1,234,717 $1,376,920 $1,538,330 $5,259,231 $8,466,748

Sales Projections

Inventory

Inventory
Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.		 2021 2022 2023 2024 2025
January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Replacement Front Winshield
Cost of Goods Sold $12,075
Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.		 $12,317 $12,563 $12,814 $13,070 $13,332 $13,598 $13,870 $14,148 $14,431 $14,719 $28,875 $175,812 $30,189 $30,793 $31,408 $32,037 $32,677 $33,331 $33,998 $34,677 $35,371 $36,078 $36,800 $37,536 $404,895 $120,102 $127,453 $135,254 $143,533 $526,342 $156,126 $165,682 $175,824 $186,585 $684,218 $889,447
Windshield $9,175
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $9,359 $9,546 $9,737 $9,931 $10,130 $10,333 $10,539 $10,750 $10,965 $11,184 $21,940 $133,588 $30,793 $31,408 $32,037 $32,677 $33,331 $33,998 $34,677 $35,371 $36,078 $36,800 $37,536 $38,287 $412,993 $122,504 $130,002 $137,959 $146,404 $536,869 $159,249 $168,996 $179,340 $190,317 $697,902 $907,236
Activator $1,300 $1,326 $1,353 $1,380 $1,407 $1,435 $1,464 $1,493 $1,523 $1,554 $1,585 $3,109 $18,928 $3,250 $3,315 $3,381 $3,449 $3,518 $3,588 $3,660 $3,733 $3,808 $3,884 $3,962 $4,041 $43,591 $12,930 $13,722 $14,562 $15,453 $56,666 $16,809 $17,837 $18,929 $20,088 $73,663 $95,758
Glue $980 $1,000 $1,020 $1,040 $1,061 $1,082 $1,104 $1,126 $1,148 $1,171 $1,195 $2,343 $14,269 $2,450 $2,499 $2,549 $2,600 $2,652 $2,705 $2,759 $2,814 $2,871 $2,928 $2,987 $3,046 $32,861 $9,747 $10,344 $10,977 $11,649 $42,718 $12,671 $13,447 $14,270 $15,143 $55,531 $72,187
Primer $620 $632 $645 $658 $671 $685 $698 $712 $726 $741 $756 $1,483 $9,027 $1,550 $1,581 $1,613 $1,645 $1,678 $1,711 $1,746 $1,781 $1,816 $1,852 $1,890 $1,927 $20,790 $6,167 $6,544 $6,945 $7,370 $27,025 $8,016 $8,507 $9,028 $9,580 $35,132 $45,669
Total Inventory Expense $12,075
Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.) 		$12,317 $12,563 $12,814 $13,070 $13,332 $13,598 $13,870 $14,148 $14,431 $14,719 $28,875 $175,812 $38,043 $38,804 $39,580 $40,371 $41,179 $42,002 $42,842 $43,699 $44,573 $45,465 $46,374 $47,302 $510,235 $151,348 $160,612 $170,443 $180,875 $663,279 $196,745 $208,787 $221,567 $235,128 $862,228 $1,120,851
Replacement Back Winshield
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $12,320 $12,936 $13,583 $14,262 $14,975 $15,724 $16,510 $17,335 $18,202 $19,112 $20,068 $21,071 $196,099 $22,678 $23,812 $25,003 $26,253 $27,565 $28,944 $30,391 $31,910 $33,506 $35,181 $36,940 $38,787 $360,970 $131,600 $152,344 $176,357 $204,155 $664,456 $242,244 $280,427 $324,629 $375,799 $1,223,099 $2,251,423
Windshield $9,895
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $10,390 $10,909 $11,455 $12,027 $12,629 $13,260 $13,923 $14,619 $15,350 $16,118 $16,924 $157,500 $23,812 $25,003 $26,253 $27,565 $28,944 $30,391 $31,910 $33,506 $35,181 $36,940 $38,787 $40,727 $379,018 $138,180 $159,961 $185,175 $214,363 $697,679 $254,356 $294,449 $340,861 $394,589 $1,284,254 $2,363,995
Activator $1,115 $1,171 $1,229 $1,291 $1,355 $1,423 $1,494 $1,569 $1,647 $1,730 $1,816 $1,907 $17,748 $2,052 $2,155 $2,263 $2,376 $2,495 $2,619 $2,750 $2,888 $3,032 $3,184 $3,343 $3,510 $32,669 $11,910 $13,788 $15,961 $18,477 $60,135 $21,924 $25,380 $29,380 $34,011 $110,694 $203,761
Glue $730 $767 $805 $845 $887 $932 $978 $1,027 $1,079 $1,132 $1,189 $1,249 $11,620 $1,344 $1,411 $1,481 $1,556 $1,633 $1,715 $1,801 $1,891 $1,985 $2,085 $2,189 $2,298 $21,389 $7,798 $9,027 $10,450 $12,097 $39,371 $14,354 $16,616 $19,235 $22,267 $72,473 $133,404
Primer $580 $609 $639 $671 $705 $740 $777 $816 $857 $900 $945 $992 $9,232 $1,068 $1,121 $1,177 $1,236 $1,298 $1,363 $1,431 $1,502 $1,577 $1,656 $1,739 $1,826 $16,994 $6,195 $7,172 $8,303 $9,611 $31,281 $11,404 $13,202 $15,283 $17,692 $57,581 $105,992
Total Inventory Expense $12,320 $12,936 $13,583 $14,262 $14,975 $15,724 $16,510 $17,335 $18,202 $19,112 $20,068 $21,071 $196,099 $28,276 $29,690 $31,174 $32,733 $34,369 $36,088 $37,892 $39,787 $41,776 $43,865 $46,058 $48,361 $450,070 $164,084 $189,947 $219,888 $254,548 $828,467 $302,038 $349,646 $404,759 $468,559 $1,525,002 $2,807,152
Replacement Windows
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $7,700 $7,854 $8,011 $8,171 $8,335 $8,501 $8,671 $8,845 $9,022 $9,202 $9,386 $9,574 $103,273 $10,010 $10,210 $10,414 $10,622 $10,835 $11,051 $11,272 $11,498 $11,728 $11,962 $12,202 $12,446 $134,250 $39,822 $42,259 $44,846 $47,591 $174,518 $51,766 $54,935 $58,297 $61,865 $226,864 $294,911
Glass $7,700
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $7,854 $8,011 $8,171 $8,335 $8,501 $8,671 $8,845 $9,022 $9,202 $9,386 $9,574 $103,273 $10,210 $10,414 $10,622 $10,835 $11,051 $11,272 $11,498 $11,728 $11,962 $12,202 $12,446 $12,695 $136,935 $40,618 $43,104 $45,743 $48,543 $178,008 $52,802 $56,033 $59,463 $63,103 $231,401 $300,809
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $7,700 $7,854 $8,011 $8,171 $8,335 $8,501 $8,671 $8,845 $9,022 $9,202 $9,386 $9,574 $103,273 $10,210 $10,414 $10,622 $10,835 $11,051 $11,272 $11,498 $11,728 $11,962 $12,202 $12,446 $12,695 $136,935 $40,618 $43,104 $45,743 $48,543 $178,008 $52,802 $56,033 $59,463 $63,103 $231,401 $300,809
Product Line 4
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 5
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 6
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 7
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 8
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 9
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Product Line 10
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"

Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
GRAND TOTAL INVENTORY $32,095 $33,107 $34,157 $35,247 $36,380 $37,557 $38,780 $40,051 $41,372 $42,745 $44,174 $59,520 $475,184 $76,528 $78,907 $81,376 $83,939 $86,600 $89,363 $92,233 $95,214 $98,312 $101,531 $104,878 $108,357 $1,097,239 $356,050 $393,664 $436,073 $483,966 $1,669,753 $551,584 $614,467 $685,789 $766,791 $2,618,631 $4,228,812

CapEx

Capital Purchases
Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.		 12/31/16
Item Cost Purchase Date Years of Service Salvage Value
Reminder: All purchases must be on or after your business start date of:
Facilities
Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.		 Month Year December-2016
Item Name (change name here) $0
Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.		 Jan
Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.		 2017
Author: Enter the year you will purchase the item(s).		 1
Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.		 $0
Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Equipment
Author: Equipment includes machinery, furniture, vehicles, etc.

Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.
Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.
Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.
Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.		 Van $27,000 Jan 2021 10 $0
Van $27,000 Jan 2021 10 $0
Windshield Removal Toolkit Premium Gt.38 $ 20,240.00 Jan 2021 5 $0
Fein Super Cut Fsc 1.7 $ 7,920.00 Jan 2021 5 $0
Fein Super Cut Cscillating Tool 18v $ 6,976.00 Jan 2021 5 $0
Windshield Removal Toolkit Premium Gt.44 $ 6,600.00 Jan 2021 5 $0
Auto Glass Cutout Tool $ 4,840.00 Jan 2021 5 $0
Windshield Removal Toolkit Premium Gt.357 $ 4,800.00 Jan 2021 5 $0
Caulking Gun 20v Lithium Ion $ 3,800.00 Jan 2021 5 $0
Auto Glass Removal Tool-Winding (Assembly Only) $ 3,520.00 Jan 2021 5 $0
Kong Auto Glass Cut Out Tool $ 2,800.00 Jan 2021 5 $0
Milwaukee Sawzall M18 Cordless Saw Kit $ 2,632.00 Jan 2021 5 $0
Stripper Winding $ 1,992.00 Jan 2021 5 $0
Winshield Removal Tool Kit $ 1,312.00 Jan 2021 5 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2021 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Computer Hardware/Software
Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.		 ERROR:#VALUE!
Computers (iMac 27") $ 5,397.00 Jan 2021 5 $0
Counter $ 3,000.00 Jan 2021 10 $0
Seating Group $ 3,000.00 Jan 2021 3 $0
Television (85") $ 2,500.00 Jan 2021 5 $0
Contactless POS System (Apple) $ 2,187.00 Jan 2021 5 $0
Desk $ 1,500.00 Jan 2021 1 $0
Multifunctional Printer $ 800.00 Jan 2021 5 $0
Jan 2021 1 $0
Telecommunications
Author: Telecommunications includes phone systems, fax machines, etc.

Author: Enter the year you will purchase the item(s).
Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.
Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.
Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.		 Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Item Name (change name here) $0 Jan 2017 1 $0
Land
Author: Land purchases are not depreciable.
Item Name (change name here) $0 Jan 2017 Land is a non-depreciable asset
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017
Item Name (change name here) $0 Jan 2017

Capital Purchases

StaffBudj

Staffing Budget
Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 2021 2022 2023 2024 2025
January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL TOTAL
Management
# Salaried Employees 2.0
Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees". 		2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Avg Salary per employee $5,000
Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).		 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $60,000 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $5,175 $62,100 $16,068 $16,068 $16,068 $16,068 $64,274 $16,631 $16,631 $16,631 $16,631 $66,523 $68,851
Benefits (across all employees) $583
Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.		 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $7,000 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $11,025 $2,894 $2,894 $2,894 $2,894 $11,576 $3,039 $3,039 $3,039 $3,039 $12,155 $12,763
Payroll Taxes (across all employees) $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $2,329 $27,945 $7,231 $7,231 $7,231 $7,231 $28,923 $7,484 $7,484 $7,484 $7,484 $29,935 $30,983
Total Costs $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $12,083 $145,000 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $18,773 $225,270 $58,330 $58,330 $58,330 $58,330 $233,320 $60,415 $60,415 $60,415 $60,415 $241,660 $250,300
Administrative/Support
# Salaried Employees 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Avg Salary per employee $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $34,560 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $2,981 $35,770 $9,255 $9,255 $9,255 $9,255 $37,022 $9,579 $9,579 $9,579 $9,579 $38,317 $39,658
Benefits (across all employees) $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $7,000 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $11,025 $2,894 $2,894 $2,894 $2,894 $11,576 $3,039 $3,039 $3,039 $3,039 $12,155 $12,763
Payroll Taxes (across all employees) $864 $864 $864 $864 $864 $864 $864 $864 $864 $864 $864 $864 $10,368 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $1,341 $16,096 $4,165 $4,165 $4,165 $4,165 $16,660 $4,311 $4,311 $4,311 $4,311 $17,243 $17,846
Total Costs $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $7,207 $86,488 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $11,203 $134,430 $34,825 $34,825 $34,825 $34,825 $139,301 $36,087 $36,087 $36,087 $36,087 $144,350 $149,584
Sales/Marketing
# Salaried Employees 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0
Avg Salary per employee $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $28,800 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $2,484 $29,808 $7,713 $7,713 $7,713 $7,713 $30,851 $7,983 $7,983 $7,983 $7,983 $31,931 $33,049
Benefits (across all employees) $583 $583 $583 $583 $583 $875 $875 $875 $875 $875 $875 $875 $9,042 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $1,225 $14,700 $3,859 $3,859 $3,859 $3,859 $15,435 $4,052 $4,052 $4,052 $4,052 $16,207 $17,017
Payroll Taxes (across all employees) $720 $720 $720 $720 $720 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $11,160 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $1,490 $17,885 $4,628 $4,628 $4,628 $4,628 $18,511 $4,790 $4,790 $4,790 $4,790 $19,159 $19,829
Total Costs $6,103 $6,103 $6,103 $6,103 $6,103 $9,155 $9,155 $9,155 $9,155 $9,155 $9,155 $9,155 $94,602 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $12,651 $151,817 $39,338 $39,338 $39,338 $39,338 $157,351 $40,772 $40,772 $40,772 $40,772 $163,090 $169,041
Operations/Production
# Salaried Employees 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0
Avg Salary per employee $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $30,720 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $2,650 $31,795 $8,227 $8,227 $8,227 $8,227 $32,908 $8,515 $8,515 $8,515 $8,515 $34,060 $35,252
Benefits (across all employees) $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $21,000 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $2,450 $29,400 $7,718 $7,718 $7,718 $7,718 $30,870 $8,103 $8,103 $8,103 $8,103 $32,414 $34,034
Payroll Taxes (across all employees) $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $2,304 $27,648 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $3,180 $38,154 $9,872 $9,872 $9,872 $9,872 $39,490 $10,218 $10,218 $10,218 $10,218 $40,872 $42,302
Total Costs $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $19,414 $232,968 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $26,826 $321,916 $83,406 $83,406 $83,406 $83,406 $333,624 $86,441 $86,441 $86,441 $86,441 $345,764 $358,352
Other
# Salaried Employees 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0
Avg Salary per employee $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $2,720 $32,640 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $2,815 $33,782 $8,741 $8,741 $8,741 $8,741 $34,965 $9,047 $9,047 $9,047 $9,047 $36,189 $37,455
Benefits (across all employees) $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $7,000 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $919 $11,025 $2,894 $2,894 $2,894 $2,894 $11,576 $3,039 $3,039 $3,039 $3,039 $12,155 $12,763
Payroll Taxes (across all employees) $816 $816 $816 $816 $816 $816 $816 $816 $816 $816 $816 $816 $9,792 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $1,267 $15,202 $3,934 $3,934 $3,934 $3,934 $15,734 $4,071 $4,071 $4,071 $4,071 $16,285 $16,855
Total Costs $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $6,839 $9,792 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $10,631 $127,574 $33,051 $33,051 $33,051 $33,051 $132,205 $34,251 $34,251 $34,251 $34,251 $137,006 $141,983
Part-Time / Hourly Employees
# Part-Time Employees 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees".
Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!
Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!		 0 0 0 0 0 0 0 0
Avg. Hours per Hourly Employee 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Avg Hourly Rate $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 $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
Calculated Wages Per Hourly Employee $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Wages $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Benefits (across all employees) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes (across all employees) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
TOTAL
# Full Time Employees $14 $14 $14 $14 $14 $15 $15 $15 $15 $15 $15 $15 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21
# Part-Time Employees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Salary/Wages $41,360 $41,360 $41,360 $41,360 $41,360 $43,760 $43,760 $43,760 $43,760 $43,760 $43,760 $43,760 $513,120 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $768,550 $198,862 $198,862 $198,862 $198,862 $795,449 $205,822 $205,822 $205,822 $205,822 $823,290 $852,105
Benefits $4,083 $4,083 $4,083 $4,083 $4,083 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $51,042 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $77,175 $20,258 $20,258 $20,258 $20,258 $81,034 $21,271 $21,271 $21,271 $21,271 $85,085 $89,340
Payroll Taxes $6,204 $6,204 $6,204 $6,204 $6,204 $6,564 $6,564 $6,564 $6,564 $6,564 $6,564 $6,564 $76,968 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $115,282 $29,829 $29,829 $29,829 $29,829 $119,317 $30,873 $30,873 $30,873 $30,873 $123,493 $127,816
GRAND TOTAL COSTS $51,647 $51,647 $51,647 $51,647 $51,647 $54,699 $54,699 $54,699 $54,699 $54,699 $54,699 $54,699 $641,130 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $80,084 $961,007 $248,950 $248,950 $248,950 $248,950 $995,800 $257,967 $257,967 $257,967 $257,967 $1,031,868 $1,069,260

Staffing Budget

MktBudj

For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates from PlanningShop.
Marketing Budget
Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies		 2021 2022 2023 2024 2025
January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
Professional Assistance
Marketing/PR Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising Agencies $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Social Media Specialists $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
SEO Specialist $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Graphic/Web Design $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Brochures/Leaflets/Flyers $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Signs/Billboards $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000 $6,000 $6,000 $6,000 $6,000 $24,000 $6,000 $6,000 $6,000 $6,000 $24,000 $24,000
Merchandising Displays $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sampling/Premiums $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Media Advertising
Print (newspaper, etc.) $0 $0 $0 $0 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $9,600 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $14,400 $3,600 $3,600 $3,600 $3,600 $14,400 $3,600 $3,600 $3,600 $3,600 $14,400 $14,400
Television and Radio $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $14,256 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $1,188 $14,256 $3,564 $3,564 $3,564 $3,564 $14,256 $3,564 $3,564 $3,564 $3,564 $14,256 $14,256
Online
Author: Includes AdWords, banner ads, social media ads, etc.
Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies		 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $38,400 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $38,400 $9,600 $9,600 $9,600 $9,600 $38,400 $9,600 $9,600 $9,600 $9,600 $38,400 $38,400
Other Media $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Phone Directories $0 $0 $0 $0 $250 $250 $250 $250 $250 $250 $250 $250 $2,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000
Advertising Specialties $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Direct Mail $0 $0 $0 $0 $200 $200 $200 $200 $200 $200 $200 $200 $1,600 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400
Website
Development/Programming $6,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance and Hosting $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400
Trade Shows
Fees and Setup $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Travel/Shipping $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Exhibits/Signs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Public Relations/Materials $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Informal Marketing / Networking
Memberships/Meetings $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600
Entertainment $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $13,688 $7,188 $7,188 $7,188 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $105,956 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $106,056 $26,514 $26,514 $26,514 $26,514 $106,056 $26,514 $26,514 $26,514 $26,514 $106,056 $106,056

Marketing Budget

ProSvs

Professional Services
Author: For information about this worksheet, see Chapter 13, "Management & Organization" in Successful Business Plan: Secrets & Strategies.		 2021 2022 2023 2024 2025
General
Author: For professional services related to marketing, use the Marketing Budget spreadsheets.
Attorneys $3,500
Author: The number you enter here will be equally divided among the 12 months of the year on your Income Statement.		 $3,500 $3,500 $3,500 $3,500
Accountants $1,500 $1,500 $1,500 $1,500 $1,500
Management consultants $0 $0 $0 $0 $0
Industry specialists $0 $0 $0 $0 $0
Technology consultants $0 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0
Total Costs $5,000 $5,000 $5,000 $5,000 $5,000
GRAND TOTAL COSTS $5,000 $5,000 $5,000 $5,000 $5,000

Professional Services Budget

CapInvest

Capital Investments and Loans
Author: This worksheet will help you manage loans and investments in your business.
Item Amount Date Loan Period
Sure Product Consulting: Loan period is in NUMBER OF MONTHS 		Interest Rate
Reminder: All invesments & loans must be on or after your business start date of:
Equity Capital Investments
Author: Equity capital investments can come from a number of sources, including venture capitalists, angel investors, and family members. Generally, these investors are purchasing a percentage of (or shares in) your company. They expect to reap the rewards of your business' success through periodic dividend payments (a share of the profits) and/or when the company is sold.
Sure Product Consulting: Loan period is in NUMBER OF MONTHS 		Month Year December-2016
Investment Source Name $0
Author: Enter the amount that will be invested in your business from this source. If this investor will inject cash into your business more than one time, use separate lines for each investment.		 Jan
Author: Enter the month that you will receive the investment cash. Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.		 2017
Author: Enter the year you will receive the investment cash.		 Capital investments are not paid back on a loan schedule.
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Investment Source Name $0 Jan 2017
Total Capital Investments $0
Loans
Author: Unlike equity capital inventments, lenders are typically not interested in purchasing shares in your company--they simply want to be paid back on a fixed schedule, with interest. Lenders can include banks and family members.
Bank $500,000 Jan 2021 84
Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.		 6.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Loan Source Name $0 Jan 2017 12 0.00%
Author: Enter the loan's annual interest rate.
Total Loans $500,000
TOTAL INVESTMENTS AND LOANS $500,000

Capital Investments and Loans

IncSt

Income Statements
Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.		 2021 2022 2023 2024 2025
January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
INCOME
Gross Sales $114,625 $118,238 $121,988 $125,883 $129,929 $134,132 $138,499 $143,038 $147,756 $152,662 $157,763 $212,573 $1,697,087 $224,559 $231,479.84 $238,661 $246,113 $253,848 $261,878 $270,217 $278,877 $287,874 $297,221 $306,935 $317,032 $3,214,695 $1,041,157 $1,150,200 $1,273,061 $1,411,710 $4,876,129 $1,607,629 $1,789,444 $1,995,537 $2,229,464 $7,622,074 $12,270,649
(Commissions) $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
(Returns and allowances) $3,439 $3,547 $3,660 $3,776 $3,898 $4,024 $4,155 $4,291 $4,433 $4,580 $4,733 $6,377 $50,913 $6,737 $6,944.40 $7,160 $7,383 $7,615 $7,856 $8,107 $8,366 $8,636 $8,917 $9,208 $9,511 $96,441 $31,235 $34,506 $38,192 $42,351 $146,284 $48,229 $53,683 $59,866 $66,884 $228,662 $368,119
Net Sales $111,186 $114,690 $118,329 $122,107 $126,031 $130,108 $134,344 $138,747 $143,324 $148,082 $153,030 $206,196 $1,646,174 $217,822 $224,535.45 $231,501 $238,729 $246,232 $254,022 $262,110 $270,511 $279,238 $288,305 $297,727 $307,521 $3,118,254 $1,009,922 $1,115,694 $1,234,869 $1,369,359 $4,729,845 $1,559,400 $1,735,761 $1,935,671 $2,162,581 $7,393,412 $11,902,530
(Cost of Goods) $32,095 $33,107 $34,157 $35,247 $36,380 $37,557 $38,780 $40,051 $41,372 $42,745 $44,174 $59,520 $475,184 $62,876 $64,814.36 $66,825 $68,912 $71,077 $73,326 $75,661 $78,086 $80,605 $83,222 $85,942 $88,769 $900,114 $291,524 $322,056 $356,457 $395,279 $1,365,316 $450,136 $501,044 $558,750 $624,250 $2,134,181 $3,435,782
GROSS PROFIT $79,091 $81,584 $84,172 $86,859 $89,651 $92,551 $95,565 $98,696 $101,952 $105,337 $108,856 $146,675 $1,170,990 $154,946 $159,721.09 $164,676 $169,818 $175,155 $180,696 $186,450 $192,425 $198,633 $205,083 $211,785 $218,752 $2,218,139 $718,398 $793,638 $878,412 $974,080 $3,364,529 $1,109,264 $1,234,717 $1,376,920 $1,538,330 $5,259,231 $8,466,748
EXPENSES - General and Administrative
Salaries and wages $41,360 $41,360 $41,360 $41,360 $41,360 $43,760 $43,760 $43,760 $43,760 $43,760 $43,760 $43,760 $513,120 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $64,046 $768,550 $198,862 $198,862 $198,862 $198,862 $795,449 $205,822 $205,822 $205,822 $205,822 $823,290 $852,105
Employee benefits $4,083 $4,083 $4,083 $4,083 $4,083 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $4,375 $51,042 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $6,431 $77,175 $20,258 $20,258 $20,258 $20,258 $81,034 $21,271 $21,271 $21,271 $21,271 $85,085 $89,340
Payroll taxes $6,204 $6,204 $6,204 $6,204 $6,204 $6,564 $6,564 $6,564 $6,564 $6,564 $6,564 $6,564 $76,968 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $9,607 $115,282 $29,829 $29,829 $29,829 $29,829 $119,317 $30,873 $30,873 $30,873 $30,873 $123,493 $127,816
Professional services $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $5,000 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $5,000 $1,250 $1,250 $1,250 $1,250 $5,000 $1,250 $1,250 $1,250 $1,250 $5,000 $5,000
Marketing and advertising $13,688 $7,188 $7,188 $7,188 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $105,956 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $8,838 $106,056 $26,514 $26,514 $26,514 $26,514 $106,056 $26,514 $26,514 $26,514 $26,514 $106,056 $106,056
Rent $0 $0 $0 $0 $0 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $31,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $54,000 $13,500 $13,500 $13,500 $13,500 $54,000 $13,500 $13,500 $13,500 $13,500 $54,000 $54,000
Equipment rental $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance $0 $0 $0 $0 $0 $245 $245 $245 $245 $245 $245 $245 $1,715 $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $245 $2,940 $735 $735 $735 $735 $2,940 $735 $735 $735 $735 $2,940 $2,940
Depreciation $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $22,363 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $1,864 $22,363 $5,591 $5,591 $5,591 $5,591 $22,363 $5,341 $5,341 $5,341 $5,341 $21,363 $21,363
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $7,200 $1,800 $1,800 $1,800 $1,800 $7,200 $1,800 $1,800 $1,800 $1,800 $7,200 $7,200
Telephone service $250 $250 $250 $250 $250 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $11,750 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $18,000 $4,500 $4,500 $4,500 $4,500 $18,000 $4,500 $4,500 $4,500 $4,500 $18,000 $18,000
Utilities $0 $0 $0 $0 $0 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $23,100 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $42,000 $10,500 $10,500 $10,500 $10,500 $42,000 $10,500 $10,500 $10,500 $10,500 $42,000 $42,000
Office supplies $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $4,800 $1,200 $1,200 $1,200 $1,200 $4,800 $1,200 $1,200 $1,200 $1,200 $4,800 $4,800
Postage and shipping $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800
Travel $0 $0 $0 $0 $0 $600 $600 $600 $600 $600 $600 $600 $4,200 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $12,000
Entertainment $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600
Interest on loans $2,500 $2,476 $2,452 $2,428 $2,403 $2,379 $2,354 $2,329 $2,304 $2,279 $2,254 $2,229 $28,388 $2,204 $2,178 $2,153 $2,127 $2,101 $2,075 $2,049 $2,022 $1,996 $1,970 $1,943 $1,916 $24,733 $5,586 $5,340 $5,090 $4,836 $20,852 $4,579 $4,318 $4,052 $3,783 $16,732 $12,358
Other (change title here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other (change title here) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL EXPENSES $71,616 $65,092 $65,067 $65,043 $66,669 $79,591 $79,566 $79,542 $79,517 $79,492 $79,467 $79,441 $890,102 $105,601 $105,575 $105,550 $105,524 $105,498 $105,472 $105,446 $105,420 $105,393 $105,367 $105,340 $105,313 $1,265,499 $324,476 $324,230 $323,980 $323,726 $1,296,411 $332,236 $331,974 $331,709 $331,440 $1,327,360 $1,360,377
Net income before taxes and interest $7,476 $16,492 $19,104 $21,816 $22,982 $12,960 $15,998 $19,155 $22,435 $25,845 $29,390 $67,234 $280,888 $49,345 $54,146 $59,126 $64,294 $69,657 $75,224 $81,004 $87,006 $93,240 $99,716 $106,445 $113,439 $952,640 $393,923 $469,409 $554,432 $650,354 $2,068,118 $777,028 $902,742 $1,045,211 $1,206,890 $3,931,872 $7,106,371
Interest Income $567 $572 $580 $590 $602 $604 $609 $617 $628 $641 $657 $694 $7,362 $714 $739 $767 $800 $836 $876 $921 $970 $1,024 $1,083 $1,146 $1,215 $11,091 $4,380 $5,289 $6,389 $7,705 $23,762 $9,296 $11,177 $13,380 $15,947 $49,799 $125,098
Provision for taxes on income $2,011 $4,266 $4,921 $5,602 $5,896 $3,391 $4,152 $4,943 $5,766 $6,621 $7,512 $16,982 $70,222 $12,515 $13,721 $14,973 $16,273 $17,623 $19,025 $20,481 $21,994 $23,566 $25,200 $26,898 $28,663 $238,160 $99,576 $118,674 $140,205 $164,515 $522,970 $196,581 $228,480 $264,648 $305,709 $995,418 $1,807,867
NET PROFIT $6,032 $12,799 $14,764 $16,805 $17,688 $10,173 $12,456 $14,829 $17,297 $19,864 $22,535 $50,946 $218,029 $37,544 $41,164 $44,920 $48,820 $52,870 $57,075 $61,443 $65,982 $70,698 $75,599 $80,694 $85,990 $725,571 $298,727 $356,023 $420,616 $493,544 $1,568,910 $589,743 $685,439 $793,943 $917,128 $2,986,253 $5,423,602

Income Statements

CshFlw

Cash Flow
Author: For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 2021 2022 2023 2024 2025
January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales $85,969 $88,678 $91,491 $94,412 $97,447 $100,599 $103,875 $107,279 $110,817 $114,496 $118,322 $159,430 $1,272,815 $168,419 $173,610 $178,996 $184,585 $190,386 $196,409 $202,663 $209,158 $215,905 $222,916 $230,201 $237,774 $2,411,021 $780,868 $862,650 $954,796 $1,058,783 $3,657,097 $1,205,722 $1,342,083 $1,496,652 $1,672,098 $5,716,556 $9,202,987
Collections $0 $28,656 $29,559 $30,497 $31,471 $32,482 $33,533 $34,625 $35,760 $36,939 $38,165 $39,441 $371,129 $53,143 $56,140 $57,870 $59,665 $61,528 $63,462 $65,470 $67,554 $69,719 $71,968 $74,305 $76,734 $777,559 $252,784 $278,463 $308,027 $341,373 $1,180,648 $385,581 $432,210 $481,710 $537,872 $1,837,372 $2,997,813
Total Cash from Sales $85,969 $117,334 $121,051 $124,910 $128,918 $133,081 $137,408 $141,904 $146,577 $151,436 $156,488 $198,870 $1,643,944 $221,562 $229,750 $236,866 $244,250 $251,914 $259,871 $268,132 $276,712 $285,625 $294,884 $304,507 $314,508 $3,188,580 $1,033,652 $1,141,113 $1,262,823 $1,400,156 $4,837,744 $1,591,302 $1,774,293 $1,978,362 $2,209,970 $7,553,928 $12,200,799
Income from Financing
Interest Income $567
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. 		$572 $580 $590 $602 $604 $609 $617 $628 $641 $657 $694 $7,362 $714 $739 $767 $800 $836 $876 $921 $970 $1,024 $1,083 $1,146 $1,215 $11,091 $4,380 $5,289 $6,389 $7,705 $23,762 $9,296 $11,177 $13,380 $15,947 $49,799 $125,098
Loan Proceeds $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Equity Capital Investments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cash from Financing $500,567 $572 $580 $590 $602 $604 $609 $617 $628 $641 $657 $694 $507,362 $714 $739 $767 $800 $836 $876 $921 $970 $1,024 $1,083 $1,146 $1,215 $11,091 $4,380 $5,289 $6,389 $7,705 $23,762 $9,296 $11,177 $13,380 $15,947 $49,799 $125,098
Other Cash Receipts $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL CASH RECEIPTS $586,535 $117,907 $121,631 $125,500 $129,519 $133,686 $138,017 $142,521 $147,205 $152,076 $157,145 $199,565 $2,151,306 $222,277 $230,489 $237,633 $245,049 $252,750 $260,747 $269,053 $277,682 $286,649 $295,967 $305,653 $315,723 $3,199,670 $1,038,032 $1,146,402 $1,269,211 $1,407,861 $4,861,506 $1,600,598 $1,785,470 $1,991,742 $2,225,917 $7,603,727 $12,325,897
CASH DISBURSEMENTS
Inventory $32,095 $33,107 $34,157 $35,247 $36,380 $37,557 $38,780 $40,051 $41,372 $42,745 $44,174 $59,520 $475,184 $76,528 $78,907 $81,376 $83,939 $86,600 $89,363 $92,233 $95,214 $98,312 $101,531 $104,878 $108,357 $1,097,239 $356,050 $393,664 $436,073 $483,966 $1,669,753 $551,584 $614,467 $685,789 $766,791 $2,618,631 $4,228,812
Operating Expenses $67,252 $60,752 $60,752 $60,752 $62,402 $75,349 $75,349 $75,349 $75,349 $75,349 $75,349 $75,349 $839,351 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $101,534 $1,218,403 $313,299 $313,299 $313,299 $313,299 $1,253,196 $322,316 $322,316 $322,316 $322,316 $1,289,264 $1,326,656
Commissions/Returns & Allowances $3,439 $3,547 $3,660 $3,776 $3,898 $4,024 $4,155 $4,291 $4,433 $4,580 $4,733 $6,377 $50,913 $6,737 $6,944 $7,160 $7,383 $7,615 $7,856 $8,107 $8,366 $8,636 $8,917 $9,208 $9,511 $96,441 $31,235 $34,506 $38,192 $42,351 $146,284 $48,229 $53,683 $59,866 $66,884 $228,662 $368,119
Capital Purchases $139,816 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $139,816 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Loan Payments $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $87,651 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $87,651 $21,913 $21,913 $21,913 $21,913 $87,651 $21,913 $21,913 $21,913 $21,913 $87,651 $87,651
Income Tax Payments $6,204
Author: Note that on your Income Statements, we've generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly).
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. 		$6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $74,448 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $6,204 $74,448 $18,612 $18,612 $18,612 $18,612 $74,448 $18,612 $18,612 $18,612 $18,612 $74,448 $74,448
Investor Dividend Payments $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Owner's Draw $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL CASH DISBURSEMENTS $256,110 $110,914 $112,077 $113,284 $116,188 $130,438 $131,792 $133,199 $134,661 $136,182 $137,763 $154,754 $1,667,363 $198,307 $200,894 $203,578 $206,364 $209,257 $212,261 $215,381 $218,622 $221,990 $225,490 $229,128 $232,910 $2,574,182 $741,109 $781,994 $828,089 $880,141 $3,231,332 $962,654 $1,030,991 $1,108,496 $1,196,516 $4,298,657 $6,085,687
NET CASH FLOW $330,425 $6,993 $9,554 $12,216 $13,331 $3,248 $6,225 $9,322 $12,543 $15,894 $19,381 $44,810 $483,943 $23,970 $29,595 $34,055 $38,685 $43,493 $48,486 $53,672 $59,060 $64,659 $70,477 $76,525 $82,813 $625,488 $296,923 $364,408 $441,122 $527,720 $1,630,174 $637,944 $754,479 $883,246 $1,029,402 $3,305,070 $6,240,210
Opening Cash Balance $350,000 $680,425 $687,418 $696,972 $709,188 $722,519 $725,767 $731,992 $741,314 $753,858 $769,752 $789,133 $833,943 $857,913 $887,508 $921,563 $960,248 $1,003,741 $1,052,226 $1,105,898 $1,164,958 $1,229,617 $1,300,094 $1,376,619 $1,459,431 $1,756,354 $2,120,763 $2,561,885 $3,089,605 $3,727,549 $4,482,028 $5,365,274 $6,394,676
Cash Receipts $586,535 $117,907 $121,631 $125,500 $129,519 $133,686 $138,017 $142,521 $147,205 $152,076 $157,145 $199,565 $222,277 $230,489 $237,633 $245,049 $252,750 $260,747 $269,053 $277,682 $286,649 $295,967 $305,653 $315,723 $1,038,032 $1,146,402 $1,269,211 $1,407,861 $1,600,598 $1,785,470 $1,991,742 $2,225,917 $12,325,897
Cash Disbursements $256,110 $110,914 $112,077 $113,284 $116,188 $130,438 $131,792 $133,199 $134,661 $136,182 $137,763 $154,754 $198,307 $200,894 $203,578 $206,364 $209,257 $212,261 $215,381 $218,622 $221,990 $225,490 $229,128 $232,910 $741,109 $781,994 $828,089 $880,141 $962,654 $1,030,991 $1,108,496 $1,196,516 $6,085,687
ENDING CASH BALANCE $680,425 $687,418 $696,972 $709,188 $722,519 $725,767 $731,992 $741,314 $753,858 $769,752 $789,133 $833,943 $833,943 $857,913 $887,508 $921,563 $960,248 $1,003,741 $1,052,226 $1,105,898 $1,164,958 $1,229,617 $1,300,094 $1,376,619 $1,459,431 $1,459,431 $1,756,354 $2,120,763 $2,561,885 $3,089,605 $3,089,605 $3,727,549 $4,482,028 $5,365,274 $6,394,676 $6,394,676 $12,634,886

Cash Flow Statements

BalSht

Balance Sheet
Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.		 Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet Balance Sheet
Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass Dynamic Auto Glass
First Quarter Second Quarter Third Quarter Fourth Quarter 2022 2023 2024 2025
2021 2021 2021 2021
ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS
Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets
Cash $696,972 Cash $725,767 Cash $753,858 Cash $833,943 Cash $1,459,431 Cash $3,089,605 Cash $6,394,676 Cash $12,634,886
Accounts Receivable $30,497 Accounts Receivable $33,533 Accounts Receivable $36,939 Accounts Receivable $53,143 Accounts Receivable $79,258 Accounts Receivable $117,643 Accounts Receivable $185,789 Accounts Receivable $255,639
Inventory $0 Inventory $0 Inventory $0 Inventory $0 Inventory $197,125 Inventory $501,562 Inventory $986,012 Inventory $1,779,043
Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0 Other Current Assets $0
Total Current Assets $727,469 Total Current Assets $759,300 Total Current Assets $790,797 Total Current Assets $887,086 Total Current Assets $1,735,814 Total Current Assets $3,708,810 Total Current Assets $7,566,476 Total Current Assets $14,669,567
Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets
Land $0 Land $0 Land $0 Land $0 Land $0 Land $0 Land $0 Land $0
Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0
Equipment $121,432 Equipment $121,432 Equipment $121,432 Equipment $121,432 Equipment $121,432 Equipment $121,432 Equipment $121,432 Equipment $121,432
Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384 Computers & Telecommunications $18,384
(Less Accumlated Depreciation) $5,591 (Less Accumlated Depreciation) $11,182 (Less Accumlated Depreciation) $16,772 (Less Accumlated Depreciation) $22,363 (Less Accumlated Depreciation) $44,726 (Less Accumlated Depreciation) $67,090 (Less Accumlated Depreciation) $88,453 (Less Accumlated Depreciation) $109,816
Total Fixed Assets $134,225 Total Fixed Assets $128,634 Total Fixed Assets $123,044 Total Fixed Assets $117,453 Total Fixed Assets $95,090 Total Fixed Assets $72,726 Total Fixed Assets $51,363 Total Fixed Assets $30,000
Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0
TOTAL ASSETS $861,695 TOTAL ASSETS $887,934 TOTAL ASSETS $913,840 TOTAL ASSETS $1,004,539 TOTAL ASSETS $1,830,903 TOTAL ASSETS $3,781,536 TOTAL ASSETS $7,617,840 TOTAL ASSETS $14,699,567
LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES
Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities
Short-Term Notes Payable $60,157
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year 		Short-Term Notes Payable $61,064 Short-Term Notes Payable $61,984 Short-Term Notes Payable $62,919 Short-Term Notes Payable $66,799 Short-Term Notes Payable $70,919 Short-Term Notes Payable $75,294 Short-Term Notes Payable $79,938
Income Taxes Due -$7,414
Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements).		 Income Taxes Due -$11,137 Income Taxes Due -$14,889 Income Taxes Due -$4,226 Income Taxes Due $159,486 Income Taxes Due $608,008 Income Taxes Due $1,528,978 Income Taxes Due $3,262,397
Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0 Other Current Liabilities $0
Total Current Liabilities $52,743 Total Current Liabilities $49,926 Total Current Liabilities $47,096 Total Current Liabilities $58,693 Total Current Liabilities $226,286 Total Current Liabilities $678,928 Total Current Liabilities $1,604,271 Total Current Liabilities $3,342,335
Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities
Long-Term Notes Payable $425,358 Long-Term Notes Payable $409,748 Long-Term Notes Payable $393,902 Long-Term Notes Payable $377,818 Long-Term Notes Payable $311,018 Long-Term Notes Payable $240,099 Long-Term Notes Payable $164,805 Long-Term Notes Payable $84,868
Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0 Other Long-Term Liabilities $0
Total Long-Term Liabilities $425,358 Total Long-Term Liabilities $409,748 Total Long-Term Liabilities $393,902 Total Long-Term Liabilities $377,818 Total Long-Term Liabilities $311,018 Total Long-Term Liabilities $240,099 Total Long-Term Liabilities $164,805 Total Long-Term Liabilities $84,868
NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH
Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000 Paid-In Capital $350,000
Retained Earnings $33,594 Retained Earnings $78,260 Retained Earnings $122,842 Retained Earnings $218,029 Retained Earnings $943,599 Retained Earnings $2,512,509 Retained Earnings $5,498,763 Retained Earnings $10,922,364
Total Net Worth $383,594 Total Net Worth $428,260 Total Net Worth $472,842 Total Net Worth $568,029 Total Net Worth $1,293,599 Total Net Worth $2,862,509 Total Net Worth $5,848,763 Total Net Worth $11,272,364
TOTAL LIABILITIES AND NET WORTH $861,695 TOTAL LIABILITIES AND NET WORTH $887,934 TOTAL LIABILITIES AND NET WORTH $913,840 TOTAL LIABILITIES AND NET WORTH $1,004,539 TOTAL LIABILITIES AND NET WORTH $1,830,903 TOTAL LIABILITIES AND NET WORTH $3,781,536 TOTAL LIABILITIES AND NET WORTH $7,617,840 TOTAL LIABILITIES AND NET WORTH $14,699,567

Balance Sheet

BrkEvn

Break-even Estimates
Author: For information about this worksheet, see "Break-Even Analysis" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies. Note that this Worksheet differs from that shown in the book slightly by also factoring the costs of sales commissions and returns/allowances. This gives you a more accurate break-even estimate.
Year 1 (2021)
January $103,791
Author: This is the amount of sales you will need to make each month to break even.
February $94,336
March $94,301
April $94,265
May $96,621
June $115,349
July $115,314
August $115,278
September $115,242
October $115,205
November $115,169
December $115,132
Monthly Average $107,500
Year 2 (2022)
January $153,045
February $153,008
March $152,971
April $152,933
May $152,896
June $152,858
July $152,820
August $152,782
September $152,744
October $152,705
November $152,667
December $152,628
Monthly Average $152,838
Year 3 (2023)
1st Quarter $470,255
2nd Quarter $469,898
3rd Quarter $469,536
4th Quarter $469,168
Quarterly Average $469,714
Year 4 (2024)
1st Quarter $481,501
2nd Quarter $481,122
3rd Quarter $480,738
4th Quarter $480,348
Quarterly Average $480,927
Year 5 (2025)
Annual Average $1,971,561

Break-even Estimates

Ratios

Key Ratios
Author: This sheet provides a mathematical snapshot of your company's performance. These ratios are often used by lenders or investors in determining how well a company is managing its finances.
Year 1 (2021) Working Capital
Author: Working Capital is the amount of readily available funds the company has to cover upcoming expenses. More is better!		 Current Ratio
Author: This ratio divides your current assets by your current liabilities. In general, it should be greater than 2. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.		 Quick Ratio
Author: Similar to the Current Ratio, but we've subtracted inventory from your assets. A number greater than 1 is desirable. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.		 Cash Turnover
Author: This ratio divides your net sales for the period by your "working capital," (your current assets minus your current liabilities). In other words, it shows by what multiple your sales exceed your working capital. In general, 5 or above is good to aim for, but this can vary based on your industry, etc.		 Debt to Equity
Author: To calculate your Debt to Equity ratio, we divided your total liabilities by your net worth. A high number (greater than 1), indicates a high debt load relative to your assets. Potential funders may be wary of investing in such a case.		 Return on Investment
Author: This ratio is achieved by dividing your net worth into your net income for the period. It shows the rate of return you and your investors are receiving on your investments in the company. The higher the better!		 Return on Sales
Author: This ratio is calculated by dividing your net income for the period by your net sales for the period. The higher the number here, the more profit you are extracting from each sale. Your ideal number will depend greatly on your industry, margins, etc.		 Return on Assets
Author: Your Return on Assets indicates how much profit you are generating on all the investments you've made in the company's assets. In particular, this will help you (and your investors) determine if you are achieving a good rate-of-return on your investments. This will depend greatly on your industry.		 Net Sales
1st Quarter $674,727 13.79 13.79 0.51 1.25 11% 13% 5% $344,205.23
2nd Quarter $709,374 15.21 15.21 0.53 1.07 13% 15% 7% $378,246.12
3rd Quarter $743,701 16.79 16.79 0.56 0.93 12% 14% 6% $416,415.43
4th Quarter $828,394 15.11 15.11 0.61 0.77 22% 24% 12% $507,307.50
Year 2 (2022) $1,509,528 7.67 6.80 2.07 0.42 74% 31% 52% $3,118,253.67
Year 3 (2023) $3,029,882 5.46 4.72 1.56 0.32 72% 44% 55% $4,729,844.95
Year 4 (2024) $5,962,205 4.72 4.10 1.24 0.30 67% 53% 52% $7,393,411.97
Year 5 (2025) $11,327,232 4.39 3.86 1.05 0.30 63% 60% 48% $11,902,529.84

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2021) Gross Sales January February March April May June July August September October November December 114625 118237.5 121988.25 125883.315 129929.04630000002 134132.09547600002 138499.42904802001 143038.34387460543 147756.48331000382 152661.85416200545 157762.84449033721 212572.72523797076 Gross Profit January February March April May June July August September October November December 79091.25 81583.875 84171.892499999987 86859.487349999996 89651.041947000005 92551.145878440017 95564.606043133812 98696.457273477732 101951.97348390264 105336.67937178377 108856.36269833267 146675.18041419983 Net Profit January February March April May June July August September October November December 6031.6492017238143 12798.500879939496 14763.586561802251 16805.107956357635 17687.886431601211 10173.37160062717 12455.825273242703 14829.098437031502 17297.224697460249 19864.42921041559 22535.138057402615 50946.171745143089

NSYr1

Year 1: Net Sales (2021) Replacement Front Winshield January February March April May June July August September October November December 41831.25 42667.875 43521.232499999998 44391.657149999999 45279.490293000003 46185.080098860002 47108.781700837208 48050.957334853956 49011.976481551043 49992.216011182063 50992.060331405701 100031.25 Replacement Back Winshield January February March April May June July August September October November December 42680 44814 47054.7 49407.434999999998 51877.806750000003 54471.697087500004 57195.281941875015 60055.046038968772 63057.798340917216 66210.688257963076 69521.222670861243 72997.283804404302 Replacement Windows January February March April May June July August September October November December 26675 27208.5 27752.67 28307.723400000003 28873.877868000003 29451.355425360001 30040.3825338672 30641.190184544546 31254.013988235438 31879.094268000146 32516.676153360146 33167.009676427348 Product Line 4 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 5 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 6 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 7 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 8 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 9 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 10 0 0 0 0 0 0 0 0 0 0 0 0

1YrCshFlw

Year 1: Cash Flow (2021) Net Cash Flow January February March April May June July August September October November December 330425.27169374132 6992.8442118194798 9554.2544611626508 12215.942036630295 13330.929917012501 3247.7419108798495 6225.3144190490711 9322.0322276981315 12543.186237824732 15894.318508448021 19381.234546719352 44810.140349142486 Ending Cash Balance 680425.27169374132 687418.11590556079 696972.37036672351 709188.31240335375 722519.2423203662 725766.98423124605 731992.29865029501 741314.33087799314 753857.51711581787 769751.83562426595 789133.0701709853 833943.21052012779

2ndYrCshFlw

Year 2: Cash Flow (2022) Net Cash Flow January February March April May June July August September October November December 23969.541208725568 29594.975342584949 34054.972746899119 38685.142480279232 43492.842914594075 48485.777257335867 53672.010331677448 59059.986186296708 64658.546576274093 70476.950358426548 76524.893846608815 82812.532174784254 Ending Cash Balance January February March April May June July August September October November December 857912.75172885344 887507.72707143833 921562.69981833745 960247.84229861666 1003740.6852132106 1052226.4624705466 1105898.4728022241 1164958.4589885208 1229617.0055647949 1300093.9559232213 1376618.8497698302 1459431.3819446147

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2021 2022 2023 2024 2025 1697086.8868989425 3214694.5054096775 4876128.8104213346 7622074.1993493959 12270649.318096448 Gross Profit 2021 2022 2023 2024 2025 1170989.9519602703 2218139.2087326772 3364528.8791907206 5259231.1975510828 8466748.0294865482 Net Profit 2021 2022 2023 2024 2025 218028.59841242264 725570.86276878964 1568909.958935352 2986253.2542674383 5423601.6568819303

NS5Yr

5-Year Net Sales

Replacement Front Winshield 2021 2022 2023 2024 2025 609063.82690168999 1402672.1791947917 1823400.6687680802 2370325.7597740991 3081299.8501555752 Replacement Back Winshield 2021 2022 2023 2024 202 5 679342.95989248971 1250502.4108630638 2301865.7318857182 4237165.6396670407 7799574.2363596484 Replacement Windows 2021 2022 2023 2024 2025 357767.49349779484 465079.08018953184 604578.54545489594 785920.57392777374 1021655.7520383301 Product Line 4 2021 2022 2023 2024 2025 0 0 0 0 0 Product Line 5 0 0 0 0 0 Product Line 6 0 0 0 0 0 Product Line 7 0 0 0 0 0 Product Line 8 0 0 0 0 0 Product Line 9 0 0 0 0 0 Product Line 10 0 0 0 0 0

License

License Agreement
LICENSE AGREEMENT FOR PLANNINGSHOP’S BUSINESS PLAN FINANCIALS This License Agreement is a legal agreement between you (the product purchaser/user) and PlanningShop for the Business Plan Financials product (“Software”) that accompanies this Agreement, including all associated documentation and packaging. By installing and/or using the Software, you accept the terms of this Agreement. PRODUCT LICENSE The Software is protected by intellectual property laws and treaties. It is owned by PlanningShop and licensed to you for your use (not sold). You acknowledge that PlanningShop has conferred to you NO title or ownership of the Software or any of its constituent parts. Re-distribution of the Software or any of constituent its parts, whether in an original or modified form, is strictly forbidden. 1. General License. You may install one copy of the Software on a single computing device for use by a single user. Additional users, whether using the same computing device or a separate device, must purchase additional licenses. Multi-user licenses are available from PlanningShop. A second copy of the Software may be stored on a separate device for the sole purpose of backing up the original copy. You may not copy, distribute, or resell the Software. 2. Unauthorized Use. You may not modify, disassemble, or reverse engineer the Software or its code for any form of distribution. The Software, its content, design and programming are copyrighted by PlanningShop. 3. WARRANTY. THIS SOFTWARE IS PROVIDED AS IS. PLANNINGSHOP AND ITS AFFILIATED PARTIES MAKE NO CLAIMS, PROMISES OR GUARANTEES ABOUT THE ACCURACY, COMPLETENESS, OR ADEQUACY OF THE SOFTWARE FOR ANY PURPOPSE AND EXPRESSLY DISCLAIMS LIABILITY FOR ERRORS, OMISSIONS, FAILURES, OR DEFECTS. NO WARRANTY OF ANY KIND, IMPLIED, EXPRESS OR STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF NON-INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND FREEDOM FROM COMPUTER VIRUS, IS GIVEN IN CONJUNCTION WITH THE SOFTWARE.
4. DAMAGES. IN NO EVENT WILL PLANNINGSHOP BE LIABLE FOR ANY DAMAGES, INCLUDING WITHOUT LIMITATION DIRECT OR INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, LOSSES OR EXPENSES ARISING IN CONNECTION WITH THIS SOFTWARE OR USE THEREOF OR INABILITY TO USE BY ANY PARTY, OR IN CONNECTION WITH ANY FAILURE OF PERFORMANCE, ERROR, OMISSION, DEFECT, OR COMPUTER VIRUS EVEN IF THE PLANNINGSHOP, OR AFFILIATED PARTIES, ARE ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, LOSSES OR EXPENSES. 5. Governing Law. This Agreement shall be treated as though it were executed and performed in Palo Alto, California, and shall be governed by and construed in accordance with the laws of the State of California, USA (without regard to conflict of law principles). All actions shall be subject to the limitations set forth in Section 3 and Section 4. The language in this Agreement shall be interpreted as in accordance with its fair meaning and not strictly for or against either party. All legal proceedings arising out of or in connection with this Agreement shall be brought solely in Palo Alto, California. You expressly submit to the exclusive jurisdiction of said courts and consent to extraterritorial service of process. Should any part of this Agreement be held invalid or unenforceable, that portion shall be construed consistent with applicable law and the remaining portions shall remain in full force and effect. 6. Contact. Should you have any questions concerning this agreement, or if you desire to contact PlanningShop for any reason, you may do so at: PlanningShop, 555 Bryant Street #180, Palo Alto, California, USA, 94301.

About

About Business Plan Financials
PlanningShop
Business Plan Financials
Version 3.1
SUBJECT TO END-USER LICENSE AGREEMENT
Copyright 2003-2017 PlanningShop. All rights reserved.
www.planningshop.com
http://www.planningshop.com/

Config

CONFIG WORKSHEET
Sure Product Consulting: IMPORTANT: Do not remove or change anything on this worksheet! Doing so may render this product unusable!		 Startup Year
2021
Sure Product Consulting: Sure Product Consulting: How does this get set? Headings on each worksheet are driven from it, but this does not seem to be connected t the Setup worksheet "what year wll your business start" question.
Version: Startup Month
3.0 January
8/1/13 Startup Month Abbrev
Jan
Start Date:
Dec-16
CREDIT MULTIPLIER
Multiple With "Credit Sales"
A 0.00 0.00
B 1.00 0.25
Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet
Q1 $674,727
Q2 $709,374
Q3 $743,701
Q4 $828,394
Y2 $1,509,528
Y3 $3,029,882
Y4 $5,962,205
Y5 $11,327,232
Chart Titles
Year 1 String 2021 Year 1: Financials at-a-Glance (2021)
Year 2 String 2022 Year 1: Net Sales (2021)
Year 3 String 2023 Year 1: Cash Flow (2021)
Year 4 String 2024 Year 2: Cash Flow (2022)
Year 5 String 2025
DOUBLE LIST FOR Months on top of worksheets
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
May
June
July
August
September
October
November
December
Start Month
From Setup January February March April May June July August September October November December
Match Position in Doublelist 1 2 3 4 5 6 7 8 9 10 11 12
Adjust index to 1-12 1 2 3 4 5 6 7 8 9 10 11 12
Abbrev Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
To-Do List
Making a "Demo" version of this workbook, with watermark, 1 loan, 1 product line, 1 investment
Adding a Worksheet to do revolving credit calculations. See http://www.vertex42.com/Files/download/line-of-credit.html for a cool line of credit worksheet (it's complicated)
Cleaning up all the dates, lists of months, etc. on the config worksheet
Adding "Reset_XXX" subroutines for ALL the worksheets
Check PrintAreas, footers, headers for New DepnSchedule and New LoanPaymentSchedule

Your Company Name

Unlicensed Copy Unlicensed Copy Demo Use Only Demo Use Only Unlicensed Copy Unlicensed Copy Demo Use Only Demo Use Only Unlicensed Copy Unlicensed Copy Demo Use Only Demo Use Only Unlicensed Copy Unlicensed Copy Demo Use Only Demo Use Only

DepnSchedule


Sure Product Consulting: Is this depreciation schedule correct? If only one year of service, nothing is depreciated. If more than one year, we don't depreciate anything for year 1 it seems (or does that show up as an expense?) 		Depreciation Schedule from CapEx Worksheet
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21
Item# Category Item Name Purch Value Salvage Value Yrs of Service Mos of Service Month Purchased Year Purchased Purchase Month End Month End Date Depn Amt montly 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
1 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - -
Sure Product Consulting: If "today's" month is one in this asset is dep'd over, 		- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Equip Van $27,000.00 $0.00 10 120 Jan 2021 1 120 Nov-26 $ 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225
12 Equip Van $27,000.00 $0.00 10 120 Jan 2021 1 120 Nov-26 $ 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225 225
13 Equip Windshield Removal Toolkit Premium Gt.38 $20,240.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337 337
14 Equip Fein Super Cut Fsc 1.7 $7,920.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132 132
15 Equip Fein Super Cut Cscillating Tool 18v $6,976.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116
16 Equip Windshield Removal Toolkit Premium Gt.44 $6,600.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110 110
17 Equip Auto Glass Cutout Tool $4,840.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81 81
18 Equip Windshield Removal Toolkit Premium Gt.357 $4,800.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80
19 Equip Caulking Gun 20v Lithium Ion $3,800.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63 63
20 Equip Auto Glass Removal Tool-Winding (Assembly Only) $3,520.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59 59
21 Equip Kong Auto Glass Cut Out Tool $2,800.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47 47
22 Equip Milwaukee Sawzall M18 Cordless Saw Kit $2,632.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44
23 Equip Stripper Winding $1,992.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33
24 Equip Winshield Removal Tool Kit $1,312.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22
25 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
26 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
27 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
28 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
29 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
30 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
31 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
32 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
33 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
34 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
35 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
36 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
37 Comp Computer Hardware/Software $0.00 $0.00 0 - 0 0 0 1 0 Nov-16 ERROR:#DIV/0! - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
38 Comp Computers (iMac 27") $5,397.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90 90
39 Comp Counter $3,000.00 $0.00 10 120 Jan 2021 1 120 Nov-26 $ 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
40 Comp Seating Group $3,000.00 $0.00 3 36 Jan 2021 1 36 Nov-19 $ 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 83 - - - - - - - - - - - - - - - - - - - - - - - -
41 Comp Television (85") $2,500.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42
42 Comp Contactless POS System (Apple) $2,187.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36 36
43 Comp Desk $1,500.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ 125 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
44 Comp Multifunctional Printer $800.00 $0.00 5 60 Jan 2021 1 60 Nov-21 $ 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13
45 Comp $0.00 $0.00 $0.00 1 12 Jan 2021 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
46 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
47 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
48 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
49 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
50 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17 $ - 0 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
51 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
52 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
53 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
54 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
55 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
56 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
57 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
58 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
59 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
60 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-17
TOTAL $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,864 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780 $ 1,780
Land - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Facilities - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Equip 121,432 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Comp 18,384 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL
Author: This goes into Cash Flow statement.
Author: This goes into Cash Flow statement.		 139,816 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL NON-DEPRECIABLE CAPITAL ASSETS
Author: This goes into Income statement under "non-depreciable capital purchases"
Author: This goes into Income statement under "non-depreciable capital purchases"
Author: This goes into Cash Flow statement.
Author: This goes into Income statement under "non-depreciable capital purchases"		 1,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Depreciation Schedule

LoanInvestSchedules

Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21
Inv # Name of Invest Source Amount Start Month Start Year Infusion Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
1 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
2 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
3 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
4 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
5 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
6 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
7 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
8 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
9 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
10 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
11 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
12 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
13 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
14 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
15 Investment Source Name $0 Jan 2017 1 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest) Loan Payback Schedule (Principle + Interest)
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
Sure Product Consulting: Note: We calculate loan payments beyond the end date of this business plan (5 years into future), in order to populate the Balance Sheet properly. Payments due in year 6 need to appear on the Short-Term Notes Payable line of Balance Sheet for Year 5. The remainder of the not-yet-made loan payments appear on Long-Term Notes Payable line of the Year 5 balance sheet.		 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22
Loan # Name of Loan Source Amount Rate Periods Start Month Start Year Begin Pay Month End Pay Month Pmt Amt (P+I) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
1 Bank $500,000 6.00% 84 Jan 2021 1 84 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28 7,304.28
2 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
3 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
4 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
5 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
6 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
7 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
8 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
9 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
10 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
11 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
12 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
13 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
14 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
15 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
16 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
17 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
18 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
19 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
20 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
TOTAL: $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304 $7,304
Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments Loan - Interest Portion of Loan Payments
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22
Loan # Name of Loan Source Amount Rate Periods Start Month Start Year Begin Pay Month End Pay Month Pmt Amt (P+I) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
1 Bank $500,000.00 $0.06 $84.00 Jan $2,021.00 1 84 7,304.28 2,500.00 2,475.98 2,451.84 2,427.57 2,403.19 2,378.69 2,354.06 2,329.31 2,304.43 2,279.43 2,254.31 2,229.06 2,203.68 2,178.18 2,152.55 2,126.79 2,100.90 2,074.89 2,048.74 2,022.46 1,996.05 1,969.51 1,942.84 1,916.03 1,889.09 1,862.01 1,834.80 1,807.45 1,779.97 1,752.35 1,724.59 1,696.69 1,668.65 1,640.47 1,612.16 1,583.70 1,555.09 1,526.35 1,497.46 1,468.42 1,439.24 1,409.92 1,380.45 1,350.83 1,321.06 1,291.14 1,261.08 1,230.86 1,200.50 1,169.98 1,139.30 1,108.48 1,077.50 1,046.37 1,015.08 983.63 952.03 920.27 888.35 856.27 824.03 791.63 759.06 726.34 693.45 660.39 627.17 593.79 560.24 526.52 492.63 458.57
2 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 0.00% 12 Jan 2017 1 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL: $2,500 $2,476 $2,452 $2,428 $2,403 $2,379 $2,354 $2,329 $2,304 $2,279 $2,254 $2,229 $2,204 $2,178 $2,153 $2,127 $2,101 $2,075 $2,049 $2,022 $1,996 $1,970 $1,943 $1,916 $1,889 $1,862 $1,835 $1,807 $1,780 $1,752 $1,725 $1,697 $1,669 $1,640 $1,612 $1,584 $1,555 $1,526 $1,497 $1,468 $1,439 $1,410 $1,380 $1,351 $1,321 $1,291 $1,261 $1,231 $1,200 $1,170 $1,139 $1,108 $1,078 $1,046 $1,015 $984 $952 $920 $888 $856 $824 $792 $759 $726 $693 $660 $627 $594 $560 $527 $493 $459
Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21
Loan # Name of Loan Source Amount Start Month Start Year Begin Pay Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
1 Bank $500,000 Jan 2021 1 500,000.00 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
3 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
4 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
5 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
6 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
7 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
9 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
10 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
11 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
12 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
13 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
14 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
15 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
16 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
17 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
18 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
19 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
20 Loan Source Name $0 Jan 2017 1 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
TOTAL: $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet
First Quarter Second Quarter Third Quarter Fourth Quarter Year 2 Year 3 Year 4 Year 5
Loan # Name of Loan Source Amount Rate Periods Start Month Start Year Begin Pay Month Amount Principle Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long Paid Due Short Due Long
1 Bank $500,000.00 6.00% 84 Jan 2021 1 $500,000 $14,485 $60,157
Sure Product Consulting: If received proceeds this quarter, "Due Short" is all the payment of principle (not interest) due in the next 12 months from disbursement 		$425,358
Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out. 		$29,188
Sure Product Consulting: cummulative principle paid: includes previous quarter's payments		 $61,064 $409,748 $44,113 $61,984 $393,902 $59,263 $62,919 $377,818 $122,182 $66,799 $311,018 $188,982 $70,919 $240,099 $259,901 $75,294 $164,805 $335,195 $79,938 $84,868
2 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
3 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
4 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
5 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
6 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
7 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
8 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
9 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
10 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
11 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
12 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
13 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
14 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
15 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
16 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
17 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
18 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
19 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
20 Loan Source Name $0.00 0.00% 12 Jan 2017 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL: $60,157 $425,358 $61,064 $409,748 $61,984 $393,902 $62,919 $377,818 $66,799 $311,018 $70,919 $240,099 $75,294 $164,805 $79,938 $84,868
BETA - Monthly Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet
Dec-16 Jan-17 Feb-17 Dec-16 Apr-17 May-17 Dec-16 Jul-17 Aug-17 Dec-16 Oct-17 Nov-17 Dec-16 Jan-18 Feb-18 Dec-16 Apr-18 May-18 Dec-16 Jul-18 Aug-18 Dec-16 Oct-18 Nov-18 Dec-16 Jan-19 Feb-19 Dec-16 Apr-19 May-19 Dec-16 Jul-19 Aug-19 Dec-16 Oct-19 Nov-19 Dec-16 Jan-20 Feb-20 Dec-16 Apr-20 May-20 Dec-16 Jul-20 Aug-20 Dec-16 Oct-20 Nov-20 Dec-16 Jan-21 Feb-21 Dec-16 Apr-21 May-21 Dec-16 Jul-21 Aug-21 Dec-16 Oct-21 Nov-21
Loan # Name of Loan Source Amount Rate Periods Start Month Start Year Begin Pay Month Last Month Num 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60
1 Bank $500,000.00 6.000% 84 Jan $2,021.00 1 84 Principle Paid $4,804.28 $9,632.58 $14,485.02 $19,361.72 $24,262.80 $29,188.40 $34,138.61 $39,113.58 $44,113.43 $49,138.27 $54,188.24 $59,263.46 $64,364.06 $69,490.15 $74,641.88 $79,819.37 $85,022.74 $90,252.13 $95,507.67 $100,789.49 $106,097.71 $111,432.48 $116,793.92 $122,182.16 $127,597.35 $133,039.62 $138,509.09 $144,005.91 $149,530.22 $155,082.15 $160,661.84 $166,269.42 $171,905.05 $177,568.85 $183,260.97 $188,981.55 $194,730.74 $200,508.67 $206,315.49 $212,151.35 $218,016.38 $223,910.74 $229,834.57 $235,788.02 $241,771.24 $247,784.37 $253,827.57 $259,900.98 $266,004.77 $272,139.07 $278,304.04 $284,499.84 $290,726.61 $296,984.52 $303,273.72 $309,594.37 $315,946.62 $322,330.63 $328,746.56 $335,194.57
Due Short $59,559.78 $59,857.58 $60,156.87 $60,457.65 $60,759.94 $61,063.74 $61,369.06 $61,675.90 $61,984.28 $62,294.20 $62,605.67 $62,918.70 $63,233.30 $63,549.46 $63,867.21 $64,186.55 $64,507.48 $64,830.02 $65,154.17 $65,479.94 $65,807.34 $66,136.37 $66,467.05 $66,799.39 $67,133.39 $67,469.05 $67,806.40 $68,145.43 $68,486.16 $68,828.59 $69,172.73 $69,518.60 $69,866.19 $70,215.52 $70,566.60 $70,919.43 $71,274.03 $71,630.40 $71,988.55 $72,348.49 $72,710.23 $73,073.79 $73,439.15 $73,806.35 $74,175.38 $74,546.26 $74,918.99 $75,293.59 $75,670.05 $76,048.40 $76,428.65 $76,810.79 $77,194.84 $77,580.82 $77,968.72 $78,358.56 $78,750.36 $79,144.11 $79,539.83 $79,937.53
Due Long $435,635.94 $430,509.85 $425,358.12 $420,180.63 $414,977.26 $409,747.87 $404,492.33 $399,210.51 $393,902.29 $388,567.52 $383,206.08 $377,817.84 $372,402.65 $366,960.38 $361,490.91 $355,994.09 $350,469.78 $344,917.85 $339,338.16 $333,730.58 $328,094.95 $322,431.15 $316,739.03 $311,018.45 $305,269.26 $299,491.33 $293,684.51 $287,848.65 $281,983.62 $276,089.26 $270,165.43 $264,211.98 $258,228.76 $252,215.63 $246,172.43 $240,099.02 $233,995.23 $227,860.93 $221,695.96 $215,500.16 $209,273.39 $203,015.48 $196,726.28 $190,405.63 $184,053.38 $177,669.37 $171,253.44 $164,805.43 $158,325.18 $151,812.53 $145,267.31 $138,689.37 $132,078.54 $125,434.66 $118,757.55 $112,047.07 $105,303.02 $98,525.26 $91,713.61 $84,867.90
TOTAL $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000

Loan & Investment Schedules for Disbursement & Repayment