Home Assignment 2: Marketing Plan

Assignment 2: Marketing Plan

This assignment consists of two sections: a marketing plan (Word document) and Marketing Budget (Excel document) Note: You must submit both sections as separate files for the completion of this assignment.For the first 6 months your company is in business—to give you time to perfect your product and to learn from actual customers—you will start marketing and selling in your own community, a radius of 25 miles from where you live.For most non-alcoholic beverages, marketing (as opposed to the actual product itself) is key to success. Cola drinks, for example, are fairly undifferentiated, as are many energy drinks, juices, bottled water, and the like. Companies producing these types of beverages differentiate themselves and attract market share through marketing and brand awareness—both of which are critical to success.

Section 1: Marketing Plan and Sales Strategy (MS Word or equivalent)Write the 3–5-page marketing plan and sales strategy section of your business plan in which you do the following:

1. Define your company’s target market.

a.) Analyze the types of consumers who will be drinking your beverage in demographic terms (i.e., age, education level, income, gender, ethnic group, etc.). Outline the demographic information for your company specified on the worksheet in the course text (p. 107 | Demographic Description).

b.) Support your analysis with actual data on the size of the demographic groups in your local community (nearby zip codes).

Hints: At American FactFinder (

http://factfinder.census.gov

), you will find demographic information on potential consumers in your area. If you are selling through other businesses (such as grocery stores), indicate the number of those businesses in your local area. You will find information about such businesses in your local area at County Business Patterns (

http://www.census.gov/econ/cbp/

). Check Chapter 2 of Successful Business Plan for more research sources.

2. Assess your company’s market competition.

a.) Use the factors listed in the course text graphic (p. 123 | Assess the Competition) to assess your company’s market competition.

b.) Defend your plan to differentiate yourself from the competition using the information detailed on the worksheet in the text (p. 131 | Market Share Distribution).

Hints: Every business faces competition, and the non-alcoholic beverage market is an especially crowded market.

Hints: For example, in the soft drink market, it is intimidating to try to compete against Coke and Pepsi. Newcomers in mature markets typically must pursue niche markets or even create new market categories, as Red Bull did with energy drinks.

3) Clarify your company’s message using the information provided on the worksheet in the text (p. 160 | The Five F’s). Create a marketing slogan/tagline for your product.

Hints: Before you choose your marketing vehicles, you must determine the message you want to convey through those vehicles.

4) Identify the marketing vehicles you plan to use to build your company’s brand. Justify the key reasons why they will be effective.

Hints: If you plan to use online marketing tactics, refer to the worksheet in the text (p. 171 | Online Marketing Tactics) to aid your response. Remember that even if you’re selling through grocery stores, you need to build your brand and social media is a major part of that in regard to beverages. Some of the marketing tactics that beverage companies use include sampling in grocery stores, building a following on social media, sponsoring events, and exhibiting at trade shows attended by retailers. You will use a combination of these tactics. For example, if you decide to give out samples in grocery stores, promote your sampling on your social media networks and those of the grocery store.

Hints: If you are planning to distribute through resellers, describe how you plan to reach them, for example, through industry trade shows or by establishing your own sales force. For information on trade shows, visit the Trade Show News Network (

http://www.tsnn.com

). You can exhibit or network at these shows.

5) Format your assignment according to these formatting requirements.

Cite the resources you have used to complete the exercise. Note: There is no minimum requirement for the number of resources used in the exercise.

The paper must be typed, double-spaced, using Times New Roman font (size 12), with 1-inch margins on all sides; references must follow APA format. Check with your professor for any additional instructions.

Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.

Section 2: Marketing Budget (MS Excel worksheets template)

Section 2 uses the “Business Plan Financials” MS Excel template (see: Required Course Files in Week 1). Use the Business Plan Financials Guide (see: Required Course Files in Week 1) to support your development of the marketing budget.

6) Complete the “Marketing Budget” worksheet for your company.

Note: Complete the Setup tab first based on the instructions located in the Business Plan Financials Guide (document you also downloaded from PlanningShop). Only the setup tab and marketing tab should be completed for this assignment.

Hints: The goal of the marketing budget is to help you determine how much it will cost you to reach your market and achieve your sales goals.

Hints: When filling out the “Marketing Budget” worksheet in the Excel spreadsheet, do the following:

Begin in the current year and complete a marketing budget for the first year of your business. The information you enter in the marketing budget spreadsheet will flow through to your “Income Statement” in the “Business Plan Financials.”

Leave the number at zero (0) for any marketing vehicles you do not intend to use.

Remember that all marketing activities involve costs. If social media represents a significant portion of your marketing, assume you will incur costs of advertising and these should be reflected on your budget. Even if a social media site charges nothing to use it, you will need to use company resources to manage the site, pay someone to execute your social media marketing campaigns, and most likely pay for ads on that site.

Do not leave the “Marketing Budget” blank assuming you will not have any marketing costs.

Do not complete all the rows; only fill in the costs for the marketing vehicles you will actually use. These must match the content you describe in Question 4 Word portion of this assignment.

>Warning

R N I N G !

ILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.

0 for

:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.

and Excel 201

on Windows

Enabling

ros”

& 201

for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.

& 20

for Mac:
1. A pop-up window appears. Select “Enable Macros”.
2. Your workbook should now be ready to use.

. Click the “Trust Center Settings…” button in the lower right

. Select “Macros Settings” from the left side menu
6. Select the “Disable all macros except digitally signed macros” radio button.

. Click “OK” twice


W	A
IT APPEARS THAT YOU DO NOT HAVE EXCEL’S MACRO CAPA	B
Excel 2									0	1	Windows
If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instructions, under “Excel		20			10			3				–	Mac
Excel 20			13			6
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 20				11	16
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
				5			7

Your

Comp

any 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.

)” 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

5 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

PlanningShop

Setup

Your Company Name

uary

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

” as opposed to cash). What percentage of your sales will be made on credit?

%
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.

, Net 30, Net

, Net

0, or Net

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).

6
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).

Author: If you’re not sure what percentage to enter here, leave it at the default (15%).

Flow Statements.

%
Author: If you’re not sure what percentage to enter here, leave it at the default (1.00%).

Setup and Assumptions

SalesProj

keting Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies.

2017

Assumptions

ruary

ust

tember

ober

ember

January February March April May June July August September October November December TOTAL

TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL

Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.

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.

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0

.00

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.

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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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?

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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: 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.

$0.00 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $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 $0.00 $0.00 $0.00 $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0 $0.00

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

of Goods Sold

)

$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Unit Volume 5.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 $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

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

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

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

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

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Sales Projections
Author: For information about this worksheet, see the chapter “

Mar

2020

January

Feb

March

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

TOTAL

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter

Product Line 1

Unit Volume

2.00%

0
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.

0
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.

0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!

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.

0.0

0.00

$0.00

Gross Sales

(Commissions)

0.00%

15.00%
Author: SALES COMMISSION RATE
What will be the commission rate paid to your salesperson for each sale?

(Returns and Allowances)

3.0

Net Sales

(

Cost

50.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.

GROSS PROFIT

Product Line 2
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”

$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.

Product Line 3
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”

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!

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”

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”

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”

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”

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”

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”

Totals for All Product Lines

Total Unit Volume

Total Gross Sales

(Total Commissions)

(Total Returns and Allowances)

Total Net Sales

(Total Cost of Goods Sold)

TOTAL GROSS PROFIT

Sales Projections

Inventory

2017 2018 2019 2020 2021

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

Product Line 1

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

s/Parts 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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

, etc.)

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

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

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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

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

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

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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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.

$0
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.

Item

$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.

Items/Parts 2

Items/Parts 3

Items/Parts 4

Total Inventory Expense

$0
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, D

Product Line 2
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”

Product Line 3
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”

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”

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”

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”

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”

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”

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.

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.

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.)

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”

GRAND TOTAL INVENTORY

CapEx

Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.

/12

Item Cost

s of
Service

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.

Year

(change name here)

000 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.

$0 Jan 2017 1 $0

ment

Author: Equipment includes machinery, furniture, vehicles, etc.

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
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
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 3 $0

00 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

Author: Land purchases are not depreciable.

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

12/

Purchase

Date

Year

Salvage
Value

Reminder: All purchases must be on or after your business start date of:

Facilities

Month

December-2012

Item Name

$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

Item Name (change name here)

Equip

Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.

Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.

Computer Hardware/Software
Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.

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.

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

$10

Land

Land is a
non-depreciable
asset

Capital Purchases

StaffBudj

2017 2018 2019 2020 2021

TOTAL

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(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

(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

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Avg Salary per 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
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

# Salaried 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.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! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Avg Salary per 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
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

0 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: 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!
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

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

$0.00 $0.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

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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

# 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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Staffing Budget Author: For information about this worksheet, see “Staffing Budget” section and worksheet in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.
Management
				# Salaried Employees	0.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”.			0.	0 Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!
				Avg Salary per employee	$0 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).
						Benefits	$0 Author: This value is calculated using the number you entered on the “Setup and Assumptions” worksheet and the number of employees you entered above.
						Payroll Taxes
						Total Costs
Administrative/Support
Sales/Marketing
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!
Operations/Production
	Other
Part-Time / Hourly Employees
	# Part-Time Employees	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: This value is calculated using the number you entered on the “Setup and Assumptions” worksheet and the number of employees you entered above.
Avg. Hours per Hourly Employee
Avg Hourly				Rate
Calculated	Wages
# Full Time Employees
Salary/Wages
		GRAND TOTAL COSTS

Staffing Budget

MktBudj

2017 2018 2019 2020 2021

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

and Hosting

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

/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

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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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
Professional Assistance
Marketing/PR Consultants
Advertising Agencies
Social Media Specialists
SEO Specialist
Graphic/Web Design
Brochures/Leaflets/Flyers
Signs/Billboards
Merchandising Displays
Sampling/Premiums
Media Advertising
Print (newspaper, etc.)
Television and Radio
Online 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
Other Media
Phone Directories
Advertising Specialties
Direct Mail
Website
Development/Programming
	Maintenance
Trade Shows
Fees and Setup
	Travel
Exhibits/Signs
Public Relations/Materials
Informal Marketing / Networking
Memberships/Meetings
	Entertainment

Marketing Budget

ProSvs

2017 2018 2019 2020 2021

$0 $0 $0 $0

$0 $0 $0 $0 $0

Other (change title here) $0 $0 $0 $0 $0

Total Costs $0 $0 $0 $0 $0
GRAND TOTAL COSTS $0 $0 $0 $0 $0

Professional Services Author: For information about this worksheet, see Chapter 13, “Management & Organization” in Successful Business Plan: Secrets & Strategies.
General Author: For professional services related to marketing, use the Marketing Budget spreadsheets.
Attorneys	$0 Author: The number you enter here will be equally divided among the 12 months of the year on your Income Statement.
Accountants
Management consultants
Industry specialists
Technology consultants
		Other (change title here)

Professional Services Budget

CapInvest

Item

Date

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.

Month Year December-2012

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

$0 Jan 2017

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.

Capital Investments and Loans
Author: This worksheet will help you manage loans and investments in your business.

Amount

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

Sure Product Consulting: Loan period is in NUMBER OF MONTHS

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.

Total Capital Investments

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.

Loan Source Name

12
Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.

0.00%
Author: Enter the loan’s annual interest rate.

Total Loans

TOTAL INVESTMENTS AND LOANS

Capital Investments and Loans

IncSt

2017 2018 2019 2020 2021

Gross Sales $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
(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

$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

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 $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.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Entertainment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4

$4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4

$13 $13 $13 $51 $13 $13 $13 $13

$52

$1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $0 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $0 $3 $3 $3 $3 $13 $3 $3 $3 $3 $13 $13

$3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $50 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $3 $51 $10 $10 $10 $10

$10 $10 $10 $10

$39

Income Statements
Author: For information about this worksheet, see “Income Statements” in Successful Business Plan: Secrets & Strategies.

INCOME

(Returns and allowances)

(Cost of Goods)

EXPENSES – General and Administrative

Salaries and wages

Employee benefits

Payroll taxes

Professional services

Marketing and advertising

Rent

Equipment rental

Depreciation

Insurance

Telephone service

Utilities

Office supplies

Postage and shipping

Interest on loans

TOTAL EXPENSES

Net income before taxes and interest

Interest Income

$50

$13

Provision for taxes on income

NET PROFIT

Income Statements

CshFlw

2017 2018 2019 2020 2021

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Interest Income

$4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $50 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $51 $13 $13 $13 $13 $51 $13 $13 $13 $13 $52 $52

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

$4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $50 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $51 $13 $13 $13 $13 $51 $13 $13 $13 $13 $52 $52

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $50 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $51 $13 $13 $13 $13 $51 $13 $13 $13 $13 $52 $52

Inventory $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Capital Purchases $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $50 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $51 $13 $13 $13 $13 $51 $13 $13 $13 $13 $52 $52

$5,000

Cash Receipts $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $4 $13 $13 $13 $13 $13 $13 $13 $13 $52

$0 $0 $0 $0 $0 $0 $0 $0 $0 $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,004 $5,008 $5,013 $5,017 $5,021 $5,025 $5,029 $5,033 $5,038 $5,042 $5,046 $5,050 $5,050 $5,054 $5,059 $5,063 $5,067 $5,071 $5,076 $5,080 $5,084 $5,088 $5,092 $5,097 $5,101 $5,101 $5,114 $5,127 $5,139 $5,152 $5,152 $5,165 $5,178 $5,191 $5,204 $5,204

Cash Flow Author: For information about this worksheet, see “Cash-Flow Projections” in “The Financials” chapter of Successful Business Plan: Secrets & Strategies.
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
$4 Author: This line item is automatically calculated for you based on the interest rate you entered on the “Setup and Assumptions” sheet.
					Loan Proceeds
Total Cash from Financing
Other	Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Operating Expenses
Commissions/Returns & Allowances
Loan Payments
Income Tax Payments	$0 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.
Investor Dividend Payments
Owner’s Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
Opening Cash Balance		$5,004	$5,008			$5,013	$5,017	$5,021	$5,025	$5,0	29	$5,0	33	$5,038	$5,0	42	$5,0	46	$5,050	$5,0	54	$5,0	59	$5,0	63	$5,0	67	$5,0	71	$5,076	$5,080	$5,084	$5,088	$5,092	$5,097	$5,101	$5,1	14	$5,1	27	$5,139	$5,152	$5,1	65	$5,178	$5,191	$5,204
Cash Disbursements
ENDING CASH BALANCE				$5,2			56

Cash Flow Statements

BalSht

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

Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name Your Company Name

2018 2019 2020 2021

2017 2017 2017 2017

ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS

Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets Current Assets

Cash $5,013 Cash $5,025 Cash $5,038 Cash $5,050 Cash $5,101 Cash $5,152 Cash $5,204 Cash $5,256

$0 Accounts Receivable $0 Accounts Receivable $0 Accounts Receivable $0 Accounts Receivable $0 Accounts Receivable $0 Accounts Receivable $0 Accounts Receivable $0

Inventory $0 Inventory $0 Inventory $0 Inventory $0 Inventory $0 Inventory $0 Inventory $0 Inventory $0

$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

$5,013 Total Current Assets $5,025 Total Current Assets $5,038 Total Current Assets $5,050 Total Current Assets $5,101 Total Current Assets $5,152 Total Current Assets $5,204 Total Current Assets $5,256

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 $0 Equipment $0 Equipment $0 Equipment $0 Equipment $0 Equipment $0 Equipment $0 Equipment $0

$0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0 Computers & Telecommunications $0

$0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0 (Less Accumlated Depreciation) $0

$0 Total Fixed Assets $0 Total Fixed Assets $0 Total Fixed Assets $0 Total Fixed Assets $0 Total Fixed Assets $0 Total Fixed Assets $0 Total Fixed Assets $0

$0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0

$5,013 TOTAL ASSETS $5,025 TOTAL ASSETS $5,038 TOTAL ASSETS $5,050 TOTAL ASSETS $5,101 TOTAL ASSETS $5,152 TOTAL ASSETS $5,204 TOTAL ASSETS $5,256

LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES LIABILITIES

Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities Current Liabilities

Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0 Short-Term Notes Payable $0

Income Taxes Due

Income Taxes Due $0 Income Taxes Due $0 Income Taxes Due $13 Income Taxes Due

Income Taxes Due $39

$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

$3 Total Current Liabilities $6 Total Current Liabilities $9 Total Current Liabilities $0 Total Current Liabilities $0 Total Current Liabilities $13 Total Current Liabilities $26 Total Current Liabilities $39

Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities Long-Term Liabilities

$0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0 Long-Term Notes Payable $0

$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

$0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0 Total Long-Term Liabilities $0

NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH NET WORTH

-In Capital

$5,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $5,000 Paid-In Capital $5,000

$9 Retained Earnings

Retained Earnings

Retained Earnings $50 Retained Earnings

Retained Earnings

Total Net Worth

Total Net Worth $5,050 Total Net Worth $5,101 Total Net Worth $5,139 Total Net Worth $5,178 Total Net Worth

$5,013 TOTAL LIABILITIES AND NET WORTH $5,025 TOTAL LIABILITIES AND NET WORTH $5,038 TOTAL LIABILITIES AND NET WORTH $5,050 TOTAL LIABILITIES AND NET WORTH $5,101 TOTAL LIABILITIES AND NET WORTH $5,152 TOTAL LIABILITIES AND NET WORTH $5,204 TOTAL LIABILITIES AND NET WORTH $5,256

Balance Sheet

First Quarter

Second Quarter

Third Quarter

Fourth Quarter

ASSETS

Current Assets

Accounts Receivable

Other Current Assets

Total Current Assets

Fixed Assets

Computers & Telecommunications

(Less Accumlated Depreciation)

Total Fixed Assets

Other Assets

TOTAL ASSETS

LIABILITIES

Current Liabilities

Short-Term Notes Payable

$0
Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year

Income Taxes Due

$3
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).

Other Current Liabilities

Total Current Liabilities

Long-Term Liabilities

Long-Term Notes Payable

Other Long-Term Liabilities

Total Long-Term Liabilities

NET WORTH

Paid

Retained Earnings

$19

$101

$139

$178

$217

Total Net Worth

$5,009

$5,019

$5,028

$5,217

TOTAL LIABILITIES AND NET WORTH

Balance Sheet

BrkEvn

January $0

Author: This is the amount of sales you will need to make each month to break even.

February $0
March $0
April $0
May $0
June $0
July $0
August $0
September $0
October $0
November $0
December $0

(2018)

January $0
February $0
March $0
April $0
May $0
June $0
July $0
August $0
September $0
October $0
November $0
December $0
Monthly Average $0

(2019)

1st Quarter $0
2nd Quarter $0
3rd Quarter $0
4th Quarter $0

(2020)

1st Quarter $0
2nd Quarter $0
3rd Quarter $0
4th Quarter $0
Quarterly Average $0

(2021)

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 (2017)
	Monthly Average
		Year 2
		Year 3
	Quarterly Average
		Year 4
		Year 5
Annual Average

Break-even Estimates

Ratios

Year 1 (2017)

” appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.

Net Sales

1st Quarter $5,009

1,602.67 0.00 0.00 0% N.A. 0% $0.00

2nd Quarter $5,019

802.33 0.00 0.00 0% N.A. 0% $0.00

3rd Quarter $5,028

.56

5.56 0.00 0.00 0% N.A. 0% $0.00

4th Quarter $5,050 N.A. N.A. 0.00 0.00 0% N.A. 0% $0.00
Year 2 (2018) $5,101 N.A. N.A. 0.00 0.00 0% N.A. 0% $0.00
Year 3 (2019) $5,139

2.50

402.50 0.00 0.00 0% N.A. 0% $0.00

Year 4 (2020) $5,178

202.26 0.00 0.00 0% N.A. 0% $0.00

Year 5 (2021) $5,217

135.68 0.00

0% N.A. 0% $0.00

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.
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.	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.
	1,602.67
	802.33
	5			35			53
				40
	202.26
	135.	68	0.01

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2017)

Gross Sales January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Gross Profit January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Net Profit January February March April May June July August September October November December 3.125 3.12760

41 66

666667 3.13021050

34 72

2221 3.1

8190122251165 3.135429

69 47

353033 3.138042

2814

9 3.1406

57 58

827

275 3.1

029318

2 3.1

8941986009332 3.14851577

997674 3.1511395402473505 3.15

654898

2233

NSYr1

Year 1: Net Sales (2017)

Product Line 1 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 2 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 3 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 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 (2017)

Net Cash Flow January February March April May June July August September October November December 4.166666666666667 4.1701388888888893 4.173

4004

96297 4.177092016300155 4.1805729263137374 4.1840567370856654 4.1875434510332363 4.1910330705757639 4.1945255981345779 4.1980210361330235 4.2015193869964671 4.2050206531522978 Ending Cash Balance 5004.166666666667 5008.3368055555557 5012.5104195601853 5016.6875115764851 5020.8680845027984 5025.0521412398839 5029.2396846909169 5033.4307177614928 5037.6252433596273 5041.8232643957608 5046.0247837827574 5050.22980

359095

2ndYrCshFlw

Year 2: Cash Flow (2018)

Net Cash Flow January February March April May June July August September October November December 4.2085248370299242 4.2120319410607827 4.215541967678333 4.2190549193180651 4.2225707984174967 4.2260896074161778 4.2296113487556912 4.2331360248796539 4.2366636382337211 4.2401941912655827 4.2437276864249709 4.2472641261636577 Ending Cash Balance January February March April May June July August September October November December 5054.438329272939 5058.6503612139995 5062.8659031816778 5067.0849581009961 5071.3075288994132 5075.533618506829 5079.7632298555845 5083.9963658804645 5088.2330295186985 5092.4732237099643 5096.716951396389 5100.9642155225529

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2017 2018 2019 2020 2021 0 0 0 0 0 Gross Profit 2017 2018 2019 2020 2021 0 0 0 0 0 Net Profit 2017 2018 2019 2020 2021 50.22 9804435910104 50.734411086644052 38.400935492120638 38.7863872836813 39.029104844177169

NS5Yr

5-Year Net Sales

Product Line 1 2017 2018 2019 2020 2021 0 0 0 0 0 Product Line 2 2017 2018 2019 2020 2021 0 0 0 0 0 Product Line 3 2017 2018 2019 2020 2021 0 0 0 0 0 Product Line 4 2017 2018 2019 2020 2021 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

PlanningShop
Business Plan Financials

Version 3.1

About Business Plan Financials

SUBJECT TO END-USER LICENSE AGREEMENT

www.planningshop.com

PlanningShop — Plan. Start. Grow.

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 2017
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-12 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

$5,009
Q2

$5,019
Q3

$5,028
Q4

$5,050
Y2

$5,101
Y3

$5,139
Y4

$5,178
Y5

$5,217
Chart Titles Year 1 String

2017 Year 1: Financials at-a-Glance (2017)
Year 2 String

2018 Year 1: Net Sales (2017)
Year 3 String

2019 Year 1: Cash Flow (2017)
Year 4 String

2020 Year 2: Cash Flow (2018)
Year 5 String

2021
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

Dec-12

Item Name

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-13

–

– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

2 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $

– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

3 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
4 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
5 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
6 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
7 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
8 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
9 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
10 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
11 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
12 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
13 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
14 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
15 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
16 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
17 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
18 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
19 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
20 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
21 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
22 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
23 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
24 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
25 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
26 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
27 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
28 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
29 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
30 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
31 Comp Item Name (change name here) $0.00 $0.00 3 36 Jan 2017 1 36 Nov-15 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
32 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
33 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
34 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
35 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
36 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
37 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
38 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
39 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
40 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
41 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
42 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
43 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
44 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
45 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
46 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
47 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
48 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
49 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
50 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
51 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
52 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
53 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
54 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
55 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
56 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
57 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
58 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
59 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
60 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-13
TOTAL $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ –
Land – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Facilities – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Equip – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Comp – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

Author: This goes into Cash Flow statement.
Author: This goes into Income statement under “non-depreciable capital purchases” – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

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

Jan-13

Feb-13

Mar-13

Apr-13

May-13

Jun-13

Jul-13

Aug-13

Sep-13

Oct-13

Nov-13

Dec-13

Jan-14

Feb-14

Mar-14

Apr-14

May-14

Jun-14

Jul-14

Aug-14

Sep-14

Oct-14

Nov-14

Dec-14

Jan-15

Feb-15

Mar-15

Apr-15

May-15

Jun-15

Jul-15

Aug-15

Sep-15

Oct-15

Nov-15

Dec-15

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Aug-16

Sep-16

Oct-16

Nov-16

Dec-16

Jan-17

Feb-17

Mar-17

Apr-17

May-17

Jun-17

Jul-17

Aug-17

Sep-17

Oct-17

Nov-17

Item#

LoanInvestSchedules

Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds

Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17

Amount Start 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

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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)

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.

Amount Rate

Start Month Start Year

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 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
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: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 – 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 # 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 Loan Source Name $0.00 $0.00

Jan

1 12 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

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: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds Loan Proceeds

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 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
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: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

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

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 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

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: $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

Dec-12 Jan-13 Feb-13 Dec-12 Apr-13 May-13 Dec-12 Jul-13 Aug-13 Dec-12 Oct-13 Nov-13 Dec-12 Jan-14 Feb-14 Dec-12 Apr-14 May-14 Dec-12 Jul-14 Aug-14 Dec-12 Oct-14 Nov-14 Dec-12 Jan-15 Feb-15 Dec-12 Apr-15 May-15 Dec-12 Jul-15 Aug-15 Dec-12 Oct-15 Nov-15 Dec-12 Jan-16 Feb-16 Dec-12 Apr-16 May-16 Dec-12 Jul-16 Aug-16 Dec-12 Oct-16 Nov-16 Dec-12 Jan-17 Feb-17 Dec-12 Apr-17 May-17 Dec-12 Jul-17 Aug-17 Dec-12 Oct-17 Nov-17
Loan # Name of Loan Source Amount Rate Periods 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 Loan Source Name $0.00

12 Jan $2,017.00 1 12 Principle Paid $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 $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

Due Short $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 $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
Due Long $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 $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
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

Investment Proceeds

Inv #

Name of Invest Source

Start Year

Infusion Month

TOTAL:

Loan Payback Schedule (Principle + Interest)

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Sep-18

Oct-18

Nov-18

Loan #

Name of Loan Source

Periods

Begin Pay Month

End Pay Month

Pmt Amt (P+I)

Loan – Interest Portion of Loan Payments

$12.00

$2,017.00

Loan Calculations for Balance Sheet

Principle Paid

Due Short

Due Long

$0
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

$0
Sure Product Consulting: “Due Long” is whatever priciple is left: origloan – pricpaid so far – due short. Whatever is due more than 12 months out.

$0
Sure Product Consulting: cummulative principle paid: includes previous quarter’s payments

BETA – Monthly Loan Calculations for Balance Sheet

Last Month Num

0.000%

Loan & Investment Schedules for Disbursement & Repayment

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Assignment 2: Marketing Plan ”

Get high-quality paper

NEW! AI matching with writer

Hire a Writer

Client Reviews

4.9

Sitejabber

4.6

Trustpilot

4.8

Our Guarantees

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Money Back

If you're confident that a writer didn't follow your order details, ask for a refund.

New to Your Trusted Assignment Help Service? Sign up & Save

Calculate the price of your order

Type of paper needed:

Pages:

You will get a personal manager and a discount.

Academic level:

We'll send you the first draft for approval by at

Total price:

$0.00

Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.

Power up Your Study Success with Experts We’ve Got Your Back.

Order Now Order Now