Assignment 3: Operation, Technology, and Management Plan (with Financials)

This assignment consists of two sections: the Word document and your business plan financials. Note: You must submit both sections as separate files for the completion of this assignment.

Don't use plagiarized sources. Get Your Custom Essay on

Just from $13/Page

Order Essay

Use the NAB Company Portfolio (see Required Course Files in Week 1).

Write a 4-8-page paper in which you provide the following information below.

Operations Plan (1–2 pages)

Note: Remember to assign a dollar amount to each operational cost you find, as you will need these figures for your income statement and cash flow in Week 8.

1.Create an operations plan for your NAB company using the template in the text as a guide (p. 214 | Operations Plan Preparation Form). Extract appropriate information from the NAB Company Portfolio, where applicable. Other required items in the template should be filled in using your personal preferences. ◦Note: Most of the research pertaining to the hints provided here can be found in the NAB company portfolio.

◦Hints: Consider whether you will rent or buy your facilities or outsource production to an existing company.

◦Hints: One of your biggest expenses as a startup non-alcoholic beverage company will be transitioning from a small-batch prototype of your beverage to production on a large scale. Research the equipment you will need (vats, refrigerators, burners, ovens, bottling equipment, and so on), whether you will rent or buy, how you will maintain and clean the equipment, and so forth. Consider how you will ensure quality control. What capacity do you intend to reach?

◦Hints: Deliberate your inventory control. Where do your supplies come from and what is your turnaround time to produce your beverage once you have received an order?

◦Hints: Consider your distribution method. Refer back to your notes for the SWOT analysis assignment in Week 2 of the class.

◦Hints: How will you stay abreast of new developments in your industry? What new products do you have in development now, in addition to your flagship product?

2.Describe your research and development activities and explain how they will contribute to the company.

Technology Plan (1–2 pages)

3. Create a technology plan for your NAB company using the template in the text as a guide (p. 227 | Technology Plan Preparation Form). Extract appropriate information from the NAB Company Portfolio, where applicable. Other required items in the template should be filled in using your personal preferences.

◾Hints: Consider the type of technology your company will use to conduct the following activities: managing personnel; taking, fulfilling, and tracking orders; managing inventory; communicating with customers and providing customer service; and producing your beverage.

Management and Organization (1–2 pages)

4.Create a management plan for your NAB company using the template in the text as a guide (p. 248 | Management Plan Preparation Form). Extract appropriate information from the NAB Company Portfolio, where applicable. Other required items in the template should be filled in using your personal preferences.

5.Using the flow charts on page 242 as a guide, outline your company’s management hierarchy. Note: Charts or diagrams must be imported/included in the MS Word document.

Create an ethics and social responsibility plan (1-2 pages)

1.Describe the ways in which your company is committed to being a good corporate citizen.

◦Hints: Consider the following areas:

◦Creating jobs

◦Following the laws of every jurisdiction in which your company operates

◦Fair and honest treatment of employees

◦Non-discrimination of employees and increasing diversity of your work force

•Hints: If your company is designed as a social venture—in which you have a primary purpose of achieving a social or environmental goal—describe what that goal is and what aspects of your company are designed to reach that goal.

Provide a rationale for why you have or have not chosen this to be a social venture.

2. Discuss how your company’s activities will affect the environment and identify the steps you will take to mitigate any negative impacts.

◾Hints: As a beverage company, consider such issues as your choice of packaging, disposal of bottles/packages by consumers, and your use of resources, such as water in areas where water may be scarce.

3. Determine any health issues/claims related to the product you are making, whether negative or positive. Suggest the strategy your company will use to mitigate any negative issues and to ensure any positive claims are true.

Section 2: Business Plan Financials (MS Excel worksheets bundled with course textbook)

For year one, submit the entire completed “Business Plan Financials” Excel document based on feedback from week 7 discussion and information from your business plan.

Format your assignment according to these formatting requirements:

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

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

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

Running Head: MARKETING PLAN 1

MARKETING PLAN 4

Marketing Plan

Shaquinna Wilson

Andrea Banto

BUS599

February 9, 2020

Introduction

Marketing and sales are very important for every business else they fail. Building a brand is more important such that consumers are guaranteed of quality when they purchase products or service from specific companies. Marketing techniques and strategies are always different for products get to as many clients as possible. A marketing plan is therefore crucial since it summarizes the marketing strategies for the near future. It outlines the goals the company has for marketing and promotion. It shows the recent marketing position and a detailed timeline of when the tasks are expected to be completed (Westwood, 2013). It shows the performance indicators that will be tracked, its target market and needs of its consumers. This drink “Nice” is a healthy non-alcoholic drink that can be used as a snack and also boost energy. This paper will specifically investigate the marketing plan and the sale strategy of this business plan.

Target Market

The target consumers are aged between 16 and 25, they will include those in high school, university or colleges. The income of the consumer does not really matter since the packaging is expected to be affordable within this target market. According to the American Fact Finder, in Texas that is Colorado county, those aged above sixteen and whose occupation range between education, community service, arts and media form about 1076 people where 200 are male and the rest female. This drink aims to be consumed by anybody despite their lifestyle and occupation but this specific target market has people in schools, those participating in community service among others who would appreciate the packaging, portability and uniqueness of the drink (Kotler, 2016). The businesses that Nice hopes to target to boost our sales and promotion will include school canteens, healthcare facilities and the restaurants in universities or colleges. This way they all get to enjoy an affordable healthy drink that can be taken at work, shared among friends and family and at school.

Market competition

Mocktails are pretty popular non-alcoholic drinks in Texas. An example of this would include the Vanilla rosemary cocktail that is loved by ladies. Sol-ti beverages is a company in Texas that manufactures healthy drinks in different flavors and is well packaged in glasses for eco friendliness. Nice drink on the other hand is a drink that is well packaged in small reusable bottles that can be used as a snack and as an energy drink. It is made of healthy fruits, no preservatives and is in good amounts to drink at any time of the day.

Nice will be differentiated by its unique reusable bottles that will be available in different colors and that can easily be carried by any gender. It will have a taste that is healthy but fun, it will be slightly thick because of the well ground fruits. During the period of promotion, all consumers will get free nice glasses for those who will not prefer to consume the drink from the bottle. It will also be available in schools and healthcare facilities especially those that run all day and night. There will be contacts on the bottles incase consumers want to give their feedback, the social media handles will also be available and the main marketers for Nice will be influencers who must be people within that age group. They will also be prioritized when it comes to job positions in marketing and promotion.

Tagline

As mentioned earlier, Nice aims to provide a drink that can be used as a snack and that boosts energy at the same time. It slogan being “dare to be healthy” means that with all the fast food in the United States, it will encourage the youth to lead a healthy lifestyle.

Media Vehicle

A media vehicle refers to specific media that allow companies to advertise. Nice will primarily focus on Social Media and our app that will help people purchase the drink with a free delivery service if they reside within North Carolina. First, the company will have a period where the drink is given for free in the locations stated such that we collect as much feedback as we can before the product is released. Building the brand will require intense marketing through social media and by social media influencers (Ashley, 2015). The social media pages will be handles by experts such that consumers are made aware if a new product is releases to the market and when there are discounts on purchase. Distribution of nice will be done in schools and healthcare facilities and will sponsor some events in these establishments.

Social media would be the most appropriate today because most youth spend a lot of time on their phones. The influencers they look up to also need to lead healthy lifestyles and through them their marketing will help grow the brand and even expand the niche. When consumers in these occupation think about a drink they should want to purchase Nice first because of its quality. There will be a website that provides information about the drink including images, there will be an app that allows consumers to purchase and the more they purchase the more they get points on their loyalty cards and are given priority when purchasing the drinks or having a change to request for a customized drink (Kotler, 2017).

In conclusion, the target market for this marketing plan will include the youth between the age of 16 and 25. This age group was chosen since in North Carolina, a high percentage of them are working as others are in school. This brand will be build using social media and will have an app that allows they to purchase it, the loyal consumers will get discounts and can have customized drink. It is also packaged in reusable bottles to protect our environment.

References

Ashley, C., & Tuten, T. (2015). Creative strategies in social media marketing: An exploratory study of branded social content and consumer engagement. Psychology & Marketing, 32(1), 15-27.

Kotler, P., Bowen, J. T., Makens, J., & Baloglu, S. (2017). Marketing for hospitality and tourism.

Kotler, M. A., Miller, A. N., Elizee, J., Dighe, S., & Elbel, B. D. (2016). Popular music celebrity endorsements in food and nonalcoholic beverage marketing. Pediatrics, 138(1), e20153977.

Westwood, J. (2013). How to write a marketing plan. Kogan Page Publishers.

Running Head: REVISED COMPANY DESCRIPTION 2

REVISED COMPANY DESCRIPTION 2

Company Description and SWOT Analysis

Student’s Name

Professor’s Name

Course Title

University Affiliation

Date

Revised Non-Alcoholic Beverage Company name and an explanation of its significance

The name of my non-alcoholic beverage company is Fresh Fruit Juice. Besides, the name is significantly established to demonstrate the value and quality attached to the brand, including its beverage. Moreover, Fresh Fruit Juice is focused on promoting healthful drinking amidst citizens as well as family setting (Cornelsen et. al.,2017)). Furthermore, it is intended to ensure that customers who consume the product are capable of executing their daily tasks without encountering adverse effects related to alcoholic drinks. Also, the name Fresh Fruit Juice is an ideal of quality that is delivered to the customers who consume the product.

Also, the company is looking forward to manufacturing non-alcoholic tropical fizz. Furthermore, the ingredients associated with my company’s fresh juice will include strawberries, kiwi, mango, as well as pineapples.

Revised company’s mission statement and rationale for its components

The mission statement for the Fresh Fruit Juice company is to promote quality life for healthy and happier consumers every day. Besides, the fresh fruit juice purposefully exists to enhance quality life by encouraging lifestyles of healthy drinking as well as sober minds (David et. al.,2016). Also, this will be achieved from an individual level, which will transit to families, friends, societies as well as nations.

Trends in the Non-Alcoholic Beverage Industry

There are key market trends in the non-alcoholic beverage industry as presented below;

Online sales promoting the market growth

Based on the increasing number of consumers experiencing hectic schedules as well as lifestyles, online shopping is prevalently becoming a convenient shopping medium associated with non-alcoholic beverages (Hagemann et. al.,2016). Furthermore, this online shopping is gaining momentum since it is suitable for customers to purchase non-alcoholic beverages online while saving travel time. Besides, the platform of online stores has established itself as a convenient marketplace, providing a broad range related to non-alcoholic drinks.

Flourishing opportunities within Asia-Pacific

The food and the beverage industry associated with Asia-Pacific, are growing at a higher rate as compared to those of developed regions such as North America and Western Europe. Moreover, the area is inhabited by a large and rapidly growing society of middle-class consumers. Consequently, this indicates potential growth presence, specifically for the segment of iced coffee drinks (Vercammen et. al.,2019). Also, carbonated beverages are poised because of the largest portion of non-alcoholic beverages. However, the use of these soft drinks as well as carbonated drinks, is expected to decrease based on the content of sugar, including healthier alternatives preferences.

Besides, the market size of the non-alcoholic beverage was estimated to be $ 1,548 billion in 2015, and it is projected to grow at 4.4% CAGR, representing $ 2090 billion by 2022. Besides, this attributed to the increasing demand associated with functional beverages, which promote good health while maintaining the drinks’ taste (Walia,2019). Also, demand for juices (non-carbonated beverages) displayed the fastest growth rate during the prediction, and this is as a result of the health awareness rise amidst customers.

Best Strategic Position for The Fresh Fruit Juice Company

The best strategic position which will enable my company to achieve superior performance in the industry is differentiation (Putra,2018). Moreover, I will employ this strategic position by ensuring that my company produces a premium-priced product while delivering distinctive value to the customers.

Overview of the Company’s Distribution Channel

In reference to the company’s distribution channel, I will ensure that my company is focused on using the online distribution channel to avail the company’s products to the end-users effectively. Furthermore, the online distribution channel associated with non-alcoholic beverages, the most convenient platform, and has a wide variety of options (Melacini et. al.,2018). Moreover, I will ensure that my company contracts the companies offering order fulfillment services to effectively manage and enhance the viability of the online distribution channel.

Three Types of Risks That My Business Faces and Mitigation Measures.

Regulatory Risks

One of the risks that affect the performance of my company is regulatory risk, such as subject to an enforced quality standard. Besides, the Fresh Fruit Juice Company has to ensure that the end product quality is enhanced per the established regulations of consumer protection (Shafqat et. al.,2019). Furthermore, failure to comply with the established rules regarding consumer protection may adversely affect the performance of the company. As a result, Fresh Fruit Juice Company has established strategies to ensure strict observance of the existing regulations regarding consumer protection. For instance, the company has implemented a communication process amidst its employees regarding the awareness of the consumer protection law in the company’s operations.

Risks Associated with Information System

About the information system, the information system may fail to operate effectively, thus minimize the company’s business performance associated with the non-alcoholic beverage (Tom,2018). Therefore, Fresh Fruit Juice Company is aiming to establish ICT solutions as well as platforms to increase the quality of the business while minimizing the risks related to the company’s information system.

Risks Related to Environmental Issues

Based on the increased interest regarding marine pollution, which is influenced by plastics, as well as changes in waste plastic distribution, the challenge related to plastic bottles, is prevalently receiving considerable attention (Smith et. al.,2017). Besides, if the Fresh Fruit Juice Company is unable to react to these issues relevantly, the company’s performance concerning the non-alcoholic beverages may be adversely affected. As a result, the company is heavily investing in manufacturing recyclable plastic containers to minimize marine pollution effectively.

Non-Alcoholic Beverage Company SWOT Analysis

Fresh Fruit Juice SWOT Analysis Matrix

Strengths

Weaknesses

The steady growth of the company’s beverage segment: There is a steady growth of the company’s beverage segment
The more significant potential of the company’s niche market: There is more considerable potential of the company’s niche market due to the increasing demand for juices based on health awareness amidst customers

High competition of the company’s industry segment: There is a high competition of the company’s industry segment since a more significant number of companies are focused on producing functional beverages.
High product quality maintenance costs: It will be very challenging for the company to produce and effectively maintain the quality of its product since it is a start-up business.

Opportunities

Threats

Increased demand for the non-carbonated juice drink: There is increased demand for the non-carbonated juice drink, which grants the Fresh Fruit Juice Company a viable chance to embrace
Availability of the niche markets associated with the company’s beverage segment: There is the availability of niche markets, which gives the company a viable business opportunity to invest.

High costs of displacing Pepsico, Limited, which is a market leader: The company is exposed to a threat of incurring high costs in replacing the market leader.
Vast exposure to external forces in the global market: The company is significantly exposed to external forces such as political instability and currency fluctuations, which are encountered in the worldwide market.

References

Cornelsen, L., Mytton, O. T., Adams, J., Gasparrini, A., Iskander, D., Knai, C., … & White, M. (2017). Change in non-alcoholic beverage sales following a 10-pence levy on sugar-sweetened beverages within a national chain of restaurants in the UK: interrupted time series analysis of a natural experiment. J Epidemiol Community Health, 71(11), 1107-1112.

David, F. R., David, F. R., & David, M. E. (2016). BENEFITS, CHARACTERISTICS, COMPONENTS, AND EXAMPLES OF CUSTOMER-ORIENTED MISSION STATEMENTS. International Journal of Business, Marketing, & Decision Science, 9(1).

Hagemann, M. N., Bogner, K., Marchioni, E., & Braun, S. (2016). Chances for dry-hopped non-alcoholic beverages? Part 1: Concept and market prospects. Brewing Science, 69, 50-55.

Melacini, M., Perotti, S., Rasini, M., & Tappia, E. (2018). E-fulfilment and distribution in omni-channel retailing: a systematic literature review. International Journal of Physical Distribution & Logistics Management.

Putra, E. N. W. (2018). Innovation strategy for startup business: a case study using business model canvas. STRATEGIC COMMUNICATION IN CONCEPTUAL AGE, 28.

Sarathe, A., Gupta, R., Basediya, A. L., & Kuchi, V. S. (2018). Recent Trends and SWOT Analysis of Food-Processing Industry Infrastructure in India: A Review. Bull. Env. Pharmacol. Life Sci, 7, 107-116.

Shafqat, A., Welo, T., Oehmen, J., Willumsen, P., & Wied, M. (2019). Resilience in Product Design and Development Processes: A Risk Management Viewpoint. Procedia CIRP, 84, 412-418.

Smith, A. D., Fildes, A., Forwood, S., Cooke, L., & Llewellyn, C. (2017). The individual environment, not the family is the most important influence on preferences for common non-alcoholic beverages in adolescence. Scientific reports, 7(1), 1-10.

Tom, M. (2018). Risk Mitigation Strategies in Information Systems Continuity Plans for Public Institutions: The case if Industrial Development Zones (IDZs) (Doctoral dissertation, University of Cape Town).

Vercammen, K. A., Koma, J. W., & Bleich, S. N. (2019). Trends in energy drink consumption among US adolescents and adults, 2003–2016. American journal of preventive medicine, 56(6), 827-833.

Walia, K. (2019). Global Malt Beverage Market Size, Share, Trends| Industry Report, 2026.

>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

uary

” 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

,500
Author: This number should reflect the amount you will spend on ONE FULL-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

,500

Author: This number should reflect the amount you will spend on ONE PART-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

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

Flow Statements.

,500
Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

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

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

2020

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

088

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

014

891

147

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

$6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00

$6.15 $6.15 $6.15 $6.15 $6.15 $6.15 $6.15 $6.15 $6.15 $6.15 $6.15

$6.30 $6.30 $6.30

$6.46 $6.46 $6.46

,000

,080

,182

,305

,451

,813

,029

,270

,535

,826

,142.21

24,253

,197

,601

,033

,494

,503

0,6

,247

,892

,281

41,491

6,363

4,503

3,753

3,036

5,257

8,838

3,862

,207

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?

,227

,031

,792

,540

9,324

5,115

,012.59

,265.13

,015.85

,730

,330

,297

,283

,288

,314

,360

,672

,366

,117

,917

4,805

of Goods Sold

)

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.

,126

,099

,247

,527

,124

,785

,745

8,182

1,945

1,518

2,628

,103

,889

,063

,832

,399

1,375

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

$5.50 $5.50 $5.50 $5.50 $5.50 $5.50 $5.50 $5.50 $5.50 $5.50

$5.64 $5.64 $5.64 $5.64 $5.64 $5.64 $5.64 $5.64 $5.64 $5.64 $5.64

$5.78 $5.78 $5.78

$5.92 $5.92 $5.92

Gross Sales

,569

,797

,142

,449

,971

,720

,115

,467

(Commissions) 50.00% 15.00%

,961

,732

(Returns and Allowances) 3.00%

Net Sales

,952

(Cost of Goods Sold) 50.00%

GROSS PROFIT

,715

Unit Volume 2.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.

$5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00

$5.13 $5.13 $5.13 $5.13 $5.13 $5.13 $5.13 $5.13 $5.13 $5.13 $5.13

$5.25 $5.25 $5.25

$5.38 $5.38 $5.38

Gross Sales

,363

,051

,418

,032

,132

,034

,004

(Commissions) 50.00% 15.00%

(Returns and Allowances) 3.00%

$1,014 $1,034

$4,939

Net Sales

,130

,949

,545

,510

,077

(Cost of Goods Sold) 50.00%

,843

GROSS PROFIT

,933

Unit Volume 2.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.

$4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00

$4.10 $4.10 $4.10 $4.10 $4.10 $4.10 $4.10 $4.10 $4.10 $4.10 $4.10

$4.20 $4.20 $4.20

$4.31 $4.31 $4.31

Gross Sales

,251

,279

(Commissions) 50.00% 15.00%

(Returns and Allowances) 3.00%

$551

$608

$791

Net Sales

,435

(Cost of Goods Sold) 50.00%

GROSS PROFIT

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

,567

,391

,748

,410

,978

,190

,933

,336

,732

,422

,147

,020

Sales Projections Author: For information about this worksheet, see the chapter “	Mar									20							21									20							22									20							23									20										24
													January																		Feb																	March																		Apr																																																						May										Jun											Jul										Aug																Sep																Oct										Nov						Dec										TOTAL				1st Quarter			2nd Quarter	3rd Quarter	4th Quarter
Tropical Fizz Straberries
									Unit Volume									2.00%	9000 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.	9											18	93		64	95							51	97							42	99							37	101							35	10																																							33	105					45	107				56	109	71	11						19	120	70	1				14	11642	11875	12113	123						55	1					26	1				28							54	1					31	13374	136							41	1					39	14192	1			53	4			43				47		49	5			29	194153	5		61	59	62	63	27	67	2	46		32	312282
									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.																									$6	$6.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.												$6.15				$6.30				$6.46	$6.62
										Gross Sales			$54					$55					$56		$							57				$							58	$59,620																														$60			$62					$63			$64			$		65							$67														$7					$70				$71			$73	$74	$75,984			$77	$79,053						$8						34		$82			$83	$85,570	$87							$9	$279,270			$29							$31																				$33	$1,223,889			$36		$			38		$4			$43	$1,590,992	$2,0		68
										(Commissions)																			5																																																																																																							0.0	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.	15.00% Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	$4,050	$4,131	$4,214	$4,298	$4,384	$4,4	72	$4,561	$4,6					52	$4,745	$4,8		40	$4,937	$5,036	$54,319	$5,265	$5,370	$5,477	$5,587	$5,		69	$5,813	$5,929	$6,0					48	$6,169	$6,292	$6,418	$6,546	$70,612	$20,945		$22	$23,588		$25		$91	$27,228	$28,894		$30		66					$32	$11	$15
									(Returns and Allowances)	3.00% Author: RETURNS AND ALLOWANCES A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate–but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.	$1,62			0.00	$1,652	$1,685.45	$1,719.16	$1,753.54	$1,788.61	$1,824.38	$1,860.87	$1,898.09	$1,936.05	$1,974.77	$2,014.27	$21,728	$2,105.92	$2,148.03	$2,190.99	$2,234.81	$2,279.51	$2,325.10	$2,371.60	$2,419.03	$2,467.42	$2,516.76	$2,567.10	$2,618.							44	$28,245	$8,378.09	$8,890.90	$9,435.09							$10	$36,717	$10,891.08	$11,557.70			$12			$13							$47	$62,046.20
											Net Sales									$48				$49																																	$50				$51				$52					$53	$54,427	$55,516	$56,626	$57,759	$58,914	$60,092	$648,206	$62,826	$64,083	$65,365			$66	$68,005			$69	$70,753	$72,168	$73,611	$75,083	$76,585		$78	$842,634	$249,946	$265,245	$281,480	$298,709	$1,095,381	$324			$34	$365,910	$388,306	$1,423,938	$1,851,045
									(											Cost	5																																																									0.00%	$27,000.00		$27,540	$28,091		$28,653		$29,226		$29,810		$30,406		$31,015		$31,635		$32,267		$32,913		$33,571		$362							$35			$35,801			$36,517						$37		$37,992		$38,752					$39	$40,317					$41				$41,946					$42			$43,641								$470		$139,635				$14		$157,252		$166,877			$61					$18			$19	$204,419		$216,931	$795,496		$1,034
										GROSS PROFIT	$21,330	$21,757	$22,192	$22,636	$23,088								$	23,550	$24,021	$24,501	$24,991	$25,491	$26,001	$26,521	$286,080	$27,728	$28,282	$28,848	$29,425	$30,014	$30,614	$31,226	$31,851	$32,488	$33,137	$33,800	$34,476		$371	$110,312		$117	$124,229													$131	$483,436					$143	$152,176	$161,491		$17	$628,442	$816,942
Tropical Fizz Kiwi 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”
7000	7350	7718	8103	8509	8934	9381	9850	10342	10859	11402	11972	111420	12571	13200	13860	14552	15280	16044	16846	17689	18573	19502	20477	21501	200094	7117						0 Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!	82388	95374	110408	359340	127811	147957	171279	198277	645323	1158908
										$5.50	$5.50 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.												$5.64				$5.78				$5.92	$6.07
$38,500	$40,425	$42,446				$44																			$46	$49,137	$51,594	$54,173	$56,882	$59,726	$62,712	$65,848	$612,809	$70,869	$74,412	$78,133	$82,040			$86		$90		$94		$99	$104,706	$109,941	$115,438	$121,210	$1,128,031	$411,251	$476,074		$551	$637,985	$2,076,425	$757,011	$876,335		$1,014	$1,174,373	$3,822,185	$7,035,698
$2,888	$3,032	$3,183	$3,343		$3,510	$3,685	$3,870	$4,063	$4,266	$4,479	$4,703		$4,939																						$45	$5,315	$5,581	$5,860	$6,153	$6,461	$6,784	$7,123	$7,479	$7,853	$8,246	$8,658	$9,091	$84,602	$30,844	$35,706	$41,334	$47,849			$155	$56,776	$65,725	$76,085	$88,078	$286,664	$527,677
$1,155	$1,213	$1,273	$1,337	$1,404	$1,474									$1,548	$1,625	$1,706	$1,792	$1,881	$1,975	$18,384	$2,126	$2,232	$2,344	$2,461	$2,584	$2,713	$2,849	$2,992	$3,141	$3,298	$3,463	$3,636	$33,841	$12,338	$14,282	$16,533	$19,140	$62,293	$22,710	$26,290		$30,434	$35,231	$114,666	$211,071
$34,458	$36,180	$37,989	$39,889	$41,883	$43,977	$46,176	$48,485	$50,909	$53,455	$56,128	$58,934	$548,464	$63,428	$66,599	$69,929	$73,426	$77,097					$80	$84,999	$89,249	$93,712	$98,397	$103,317	$108,483	$1,009,587	$368,069	$426,086	$493,248	$570,997	$1,858,401	$677,525	$784,320	$907,948	$1,051,063	$3,420,856	$6,296,950
	$19,250		$20,213			$21,223			$22,284			$23,398			$24,568			$25,797			$27,087			$28,441			$29,863			$31,356			$32,924		$306,405			$35,434			$37,206			$39,067			$41,020			$43,071			$45,224			$47,486			$49,860			$52,353			$54,971			$57,719			$60,605		$564,015		$205,625		$238,037		$275,558		$318,992	$1,038,213		$378,505		$438,167		$507,234		$587,186		$1,911,093		$3,517,849
$15,208	$15,968	$16,766	$17,605	$18,485	$19,409	$20,380	$21,398	$22,468	$23,592	$24,771	$26,010	$242,060	$27,993	$29,393	$30,863	$32,406	$34,026	$35,727	$37,514	$39,389	$41,359	$43,427	$45,598	$47,878	$445,572	$162,444	$188,049	$217,691	$252,004	$820,188	$299,019	$346,152			$400	$463,877	$1,509,763	$2,779,101
Tropical Fizz Mango 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”
6000	6120	6242	6367	6495	6624	6757	6892	7030	7171	7314	7460	80473	7609	7762	7917	8075	8237	8401	8569	8741	8916	9094	9276	9461	102059	29535 Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!	31343	33261	35297	129435	37457	39750	42183	44765	164155	208188
										$5.00	$5.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.												$5.13				$5.25				$5.38	$5.52
$30,000	$30,600	$31,212	$31,836	$32,473	$33,122	$33,785	$34,461	$35,150	$35,853	$36,570	$37,301			$402	$38,998	$39,778	$40,574	$41,385	$42,213	$43,057	$43,919	$44,797	$45,693	$46,607	$47,539	$48,490			$523	$155,150	$164,646	$174,724			$185	$679,938	$201,687			$214			$227			$241	$883,884			$1,149
								$2,250		$2,295	$2,341	$2,388	$2,435	$2,484	$2,534	$2,585	$2,636	$2,689	$2,743	$2,798	$30,177	$2,925	$2,983	$3,043	$3,104	$3,166	$3,229	$3,294	$3,360	$3,427	$3,496	$3,565	$3,637	$39,229	$11,636	$12,348	$13,104	$13,906	$50,995	$15,127	$16,052	$17,035	$18,078	$66,291	$86,175
								$900	$918	$936									$955	$974	$994	$1,054	$1,076	$1,097	$1,119	$12,071	$1,170	$1,193	$1,217	$1,242	$1,266																									$1,292		$1,318	$1,344	$1,371	$1,398	$1,426	$1,455	$15,692	$4,654	$5,242	$5,563	$20,398	$6,051	$6,421	$6,814	$7,231	$26,517	$34,470
$26,850	$27,387	$27,935	$28,493	$29,063	$29,645	$30,237	$30,842	$31,459	$32,088	$32,730	$33,385	$360,115	$34,904	$35,602	$36,314	$37,040	$37,781	$38,536	$39,307	$40,093	$40,895	$41,713	$42,547	$43,398																									$468	$138,859	$147,358	$156,378			$165			$608									$180	$191,558	$203,283	$215,726		$791	$1,028,358
	$15,000		$15,300			$15,606			$15,918			$16,236			$16,561			$16,892			$17,230			$17,575			$17,926			$18,285			$18,651		$201,181			$19,499			$19,889			$20,287			$20,693			$21,107			$21,529			$21,959			$22,398			$22,846			$23,303			$23,769			$24,245		$261,525		$77,575		$82,323		$87,362		$92,709	$339,969							$100		$107,016		$113,566		$120,517		$441,942		$574,502
$11,850	$12,087	$12,329	$12,575	$12,827	$13,083	$13,345	$13,612	$13,884	$14,162	$14,445	$14,734		$158	$15,404	$15,712	$16,027	$16,347	$16,674	$17,008	$17,348	$17,695	$18,049	$18,410	$18,778	$19,153	$206,605	$61,284	$65,035	$69,016	$73,	240	$268,576	$79,666	$84,542	$89,717	$95,209	$349,134	$453,856
Tropical Fizz Pineapple 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!	4500	4590	4682	4775	4871	4968	5068	5169	5272	5378	5485	5595	60354	5707	5821	5938	6056	6178	6301	6427	6556	6687	6820	6957	7096	76544	22151 Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly!	23507	24946	26473	97076	28093	29812	31637	33574	123116	156141
										$4.00	$4.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.												$4.10				$4.20				$4.31	$4.42
$18,000	$18,360	$18,727	$19,102	$19,484	$19,873	$20,271	$20,676	$21,090	$21,512	$21,942	$22,381	$241,418	$23,399	$23,867	$24,344	$24,831	$25,328	$25,834	$26,351	$26,878	$27,416		$27,964	$28,523	$29,094	$313,830	$93,090	$98,788	$104,834		$111	$407,963	$121,012	$128,419			$136	$144,621	$530,331	$689,402
$1,350	$1,377	$1,405	$1,433	$1,461	$1,491	$1,520	$1,551	$1,582	$1,613	$1,646	$1,679	$18,106	$1,755	$1,790	$1,826	$1,862	$1,900	$1,938	$1,976	$2,016	$2,056	$2,097	$2,139	$2,182	$23,537	$6,982	$7,409	$7,863	$8,344	$30,597	$9,076	$9,631	$10,221	$10,847	$39,775	$51,705
	$540	$562			$573	$585		$596	$620	$633	$645	$658	$671	$7,243	$702		$716	$730	$745	$760	$775	$806	$822	$839	$856	$873	$9,415	$2,793	$2,964	$3,145	$3,338	$12,239	$3,630	$3,853				$4,088	$4,339	$15,910	$20,682
$16,110	$16,432	$16,761	$17,096	$17,438	$17,787	$18,142	$18,505	$18,875	$19,253	$19,638	$20,031	$216,069	$20,942	$21,361	$21,788	$22,224	$22,668	$23,122	$23,584	$24,056	$24,537	$25,028	$25,528	$26,039	$280,878	$83,315	$88,415	$93,827	$99,570	$365,127	$108,306	$114,935	$121,970		$129	$474,646	$617,015
						$9,000			$9,180		$9,364		$9,551		$9,742			$9,937		$10,135		$10,338		$10,545		$10,756		$10,971		$11,190		$120,709		$11,700		$11,934		$12,172		$12,416		$12,664		$12,917		$13,176		$13,439		$13,708		$13,982		$14,262		$14,547		$156,915		$46,545		$49,394		$52,417		$55,626		$203,982		$60,506		$64,209		$68,140		$72,310		$265,165		$344,701
$7,110	$7,252	$7,397	$7,545	$7,696	$7,850	$8,007	$8,167	$8,330	$8,497	$8,667	$8,840	$95,360	$9,243	$9,427	$9,616	$9,808	$10,005	$10,205	$10,409	$10,617	$10,829	$11,046	$11,267	$11,492	$123,963	$36,771	$39,021	$41,410	$43,944	$161,145	$47,800	$50,725	$53,830	$57,125	$209,481	$272,314
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”
																																																																																																																																																																																																																											$0	$0.00
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”
				$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 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	26500	27240	28005	28797	29616	30464	31341	32249	33190	34164	35173	36218	372956	37302	38425	39589	40797	42049	43349	44697	46096	47549	49057	50623	52250	531785	167158	184251	203473	225122	780004	249547	277144	308373	343762	1178827	1835520
Total Gross Sales		$140,500		$144,465					$148		$152,812		$157,205		$161,753		$166,462		$171,339		$176		$181,626		$187,050		$192,672		$1,980,843		$203,464	$209,659		$216,085		$222,750		$229,666		$236,844		$244,294		$252,029		$260,062		$268,404		$277,070		$286,075		$2,906,402		$938,760		$1,035,871		$1,145,177		$1,268,408		$4,388,216		$1,442,746		$1,604,042		$1,786,716		$1,993,889		$6,827,393		$10,942,311
(Total Commissions)		$10,538		$10,835		$11,143		$11,461		$11,790		$12,131		$12,485		$12,850		$13,229		$13,622		$14,029		$14,450		$148,563		$15,260	$15,724		$16,206		$16,706		$17,225		$17,763		$18,322		$18,902		$19,505		$20,130		$20,780		$21,456		$217,980		$70,407		$77,690		$85,888		$95,131		$329,116		$108,206		$120,303		$134,004		$149,542		$512,054		$820,673
(Total Returns and Allowances)		$4,215		$4,334			$4,457		$4,584		$4,716		$4,853		$4,994		$5,140		$5,292		$5,449		$5,611		$5,780		$59,425		$6,104	$6,290			$6,483		$6,683		$6,890		$7,105		$7,329		$7,561		$7,802		$8,052		$8,312		$8,582		$87,192		$28,163		$31,076		$34,355		$38,052		$131,646		$43,282		$48,121		$53,601		$59,817		$204,822		$328,269
Total Net Sales													$125		$129,296		$132,968		$136,767		$140,699		$144,769		$148,984		$153,349		$157,870		$162,555			$167		$172,442		$1,772,854		$182,100	$187,645		$193,396		$199,361		$205,551		$211,975		$218,643		$225,566		$232,755		$240,222			$247		$256,037		$2,601,230			$840		$927,105		$1,024		$1,135,225		$3,927,453		$1,291,257		$1,435,618		$1,599,111	$1,784,531		$6,110,516		$9,793,368
(Total Cost of Goods Sold)							$70,250				$72,233					$74,284				$76,406				$78,603					$80,877				$83,231				$85,670					$88,196				$90,813				$93,525			$96			$990,421		$101			$104,830				$108,042				$111,375				$114,833		$118		$122				$126,015			$130,031				$134,202				$138,535				$143,037			$1,453,201		$469,380		$517,936		$572,588			$634,204		$2,194,108		$721,373		$802,021		$893,358		$996,944		$3,413,696		$5,471,155
TOTAL GROSS PROFIT		$55,498		$57,064		$58,684		$60,361		$62,096		$63,892		$65,753		$67,679		$69,675		$71,742		$73,885		$76,106		$782,433		$80,368	$82,815		$85,353		$87,986		$90,718		$93,553		$96,496		$99,552		$102,724		$106		$109,443		$113,000		$1,148,029		$370,810		$409,169		$452,345		$501,021		$1,733,345		$569,885		$633,597		$705,753		$787,586		$2,696,820		$4,322,213

Sales Projections

Inventory

2020 2021 2022 2023 2024

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

Tropical Fizz Straberries

Cost of Goods Sold

$27,540 $28,091 $28,653 $29,226 $29,810 $30,406 $31,015 $31,635 $32,267 $32,913 $33,571 $362,126 $35,099 $35,801 $36,517 $37,247 $37,992 $38,752 $39,527 $40,317 $41,124 $41,946 $42,785 $43,641 $470,745 $139,635 $148,182 $157,252 $166,877 $611,945 $181,518 $192,628 $204,419 $216,931 $795,496

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $35,099

$35,801 $36,517 $37,247 $37,992 $38,752 $39,527 $40,317 $41,124 $41,946 $42,785 $43,641

,428

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

$30 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $30 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $35,099

$35,801 $36,517 $37,247 $37,992 $38,752 $39,527 $40,317 $41,124 $41,946 $42,785 $43,641 $44,514 $480,160 $142,428 $151,145 $160,397 $170,214 $624,183 $185,148 $196,481 $208,507 $221,269 $811,406 $1,054,785

Cost of Goods Sold $19,250 $20,213 $21,223 $22,284 $23,398 $24,568 $25,797 $27,087 $28,441 $29,863 $31,356 $32,924 $306,405 $35,434 $37,206 $39,067 $41,020 $43,071 $45,224 $47,486 $49,860 $52,353 $54,971 $57,719 $60,605 $564,015 $205,625 $238,037 $275,558 $318,992 $1,038,213 $378,505 $438,167 $507,234 $587,186 $1,911,093 $3,517,849
Ingredients

$21,223 $22,284 $23,398 $24,568 $25,797 $27,087 $28,441 $29,863 $31,356 $32,924 $35,434

,839

$37,206 $39,067 $41,020 $43,071 $45,224 $47,486 $49,860 $52,353 $54,971 $57,719 $60,605

$45 $47 $50 $52 $55 $57 $60 $63 $66 $70 $73 $77 $716 $83 $87 $91 $96 $101 $106 $111 $117 $122 $129

$142 $1,318

$1,024

Labels $6 $6 $7 $7 $7 $8 $8 $8 $9 $9 $10 $10 $96 $11 $12 $12 $13 $13 $14 $15 $16 $16 $17 $18 $19 $176 $64 $74 $86 $99 $324 $118

$158

$596

Cartons $30 $32 $33 $35 $36 $38 $40 $42 $44 $47 $49 $51

$55 $58 $61 $64 $67 $70 $74 $78 $82 $86 $90 $94

$371

Total Inventory Expense

,941

,544

Cost of Goods Sold $15,000 $15,300 $15,606 $15,918 $16,236 $16,561 $16,892 $17,230 $17,575 $17,926 $18,285 $18,651 $201,181 $19,499 $19,889 $20,287 $20,693 $21,107 $21,529 $21,959 $22,398 $22,846 $23,303 $23,769 $24,245 $261,525 $77,575 $82,323 $87,362 $92,709 $339,969 $100,843 $107,016 $113,566 $120,517 $441,942 $574,502
Ingredients

$15,606 $15,918 $16,236 $16,561 $16,892 $17,230 $17,575 $17,926 $18,285 $18,651 $19,499

$19,889 $20,287 $20,693 $21,107 $21,529 $21,959 $22,398 $22,846 $23,303 $23,769 $24,245

,781

$45 $46 $47 $48 $49 $50 $51 $52 $53 $54 $55 $56

$58 $60 $61 $62 $63 $65 $66 $67 $69 $70 $71 $73

$247

$341 $362

Labels $6 $6 $6 $6 $6 $7 $7 $7 $7 $7 $7 $7 $80 $8 $8 $8 $8 $8 $9 $9 $9 $9 $9 $10 $10

$31 $33 $35 $37 $136 $40 $43 $45 $48

Cartons $30 $31 $31 $32 $32 $33 $34 $34 $35 $36 $37 $37 $402 $39 $40 $41 $41 $42 $43 $44 $45 $46 $47 $48 $48 $523 $155 $165

$185

$214 $227 $241

$1,149

Total Inventory Expense

Cost of Goods Sold $9,000 $9,180 $9,364 $9,551 $9,742 $9,937 $10,135 $10,338 $10,545 $10,756 $10,971 $11,190 $120,709 $11,700 $11,934 $12,172 $12,416 $12,664 $12,917 $13,176 $13,439 $13,708 $13,982 $14,262 $14,547 $156,915 $46,545 $49,394 $52,417 $55,626 $203,982 $60,506 $64,209 $68,140 $72,310 $265,165 $344,701
Ingredients

Bottle/Caps $45 $46 $47 $48 $49 $50 $51 $52 $53 $54 $55 $56 $604 $58 $60 $61 $62 $63 $65 $66 $67 $69 $70 $71 $73 $785 $233 $247 $262 $278 $1,020 $303 $321 $341 $362 $1,326 $1,724
Labels $6 $6 $6 $6 $6 $7 $7 $7 $7 $7 $7 $7 $80 $8 $8 $8 $8 $8 $9 $9 $9 $9 $9 $10 $10 $105 $31 $33 $35 $37 $136 $40 $43 $45 $48 $177 $230
Cartons $30 $31 $31 $32 $32 $33 $34 $34 $35 $36 $37 $37 $402 $39 $40 $41 $41 $42 $43 $44 $45 $46 $47 $48 $48 $523 $155 $165 $175 $185 $680 $202 $214 $227 $241 $884 $1,149

Total Inventory Expense

$30,434

,482

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

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

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

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

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

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

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.
$27,000 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.	$1,034,103
			Ingredients	$54,540 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.	$89,639		$44,514		$480,160			$142		$151,145		$160,397		$170,214		$624,183		$185,148		$196,481		$208,507		$221,269		$811,406		$1,054,785
Bottles/Caps
					Labels
			Cartons
									Total Inventory Expense	$54,621 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.)	$89,720
Tropical Fizz Kiwi 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”
$39,463 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.			$341	$63,635	$592,216	$215,907	$249,939	$289,336	$334,942	$1,090,123	$397,431	$460,076	$532,595	$616,546	$2,006,647	$3,693,742
Bottle/ Caps	$135	$481		$556	$644	$746	$2,427	$885	$1,186	$1,373	$4,467	$8,224
$137	$183	$1,096
$478	$879	$320	$429	$497	$1,618		$590	$683	$790	$915	$2,978	$5,482
$39,544	$21,308	$22,374	$23,492	$24,667	$25,900	$27,195	$28,555	$29,983	$31,482	$33,056	$35,573	$343,128	$37,355	$39,223	$41,184	$43,243	$45,406	$47,676	$50,060	$52,563	$55,191	$57,950	$60,848	$63,890	$594,589	$216,772																															$250	$290,495	$336,284	$1,094,492	$399,023	$461,920	$534,730	$619,016	$2,014,689	$3,708
Tropical Fizz Mango 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”
$30,300 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.	$220,681	$24,730	$266,756	$79,126	$83,970	$89,109	$94,563	$346,769	$102,860	$109,156	$115,837	$122,927																	$450	$585,992
	Bottle/Caps		$604		$785		$233		$262		$278		$1,020		$303														$321		$1,326		$1,724
	$105		$177		$230
	$175		$680		$202		$884
$30,381	$15,689	$16,002	$16,322	$16,649	$16,982	$17,322	$17,668	$18,021	$18,382	$18,749	$19,600	$221,767	$19,994	$20,394	$20,802	$21,218	$21,643	$22,076	$22,517	$22,967	$23,427	$23,895	$24,373	$24,861	$268,168	$79,545	$84,414	$89,581	$95,064	$348,604	$103,405	$109,734	$116,451	$123,578	$453,168	$589,094
Tropical Fizz Pineapple 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”
$20,300 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.	$20,706	$21,120	$21,543	$21,973	$22,413	$22,861	$23,318	$23,785	$24,260	$24,746	$25,240	$272,265	$26,389	$26,917	$27,455	$28,004	$28,564	$29,136	$29,718	$30,313	$30,919	$31,537	$32,168	$32,811	$353,931	$104,985	$111,411	$118,230	$125,466	$460,092	$136,475	$144,828	$153,693	$163,100	$598,095	$777,492
$20,381	$20,789	$21,204	$21,628	$22,061	$22,502	$22,952	$23,411	$23,880	$24,357	$24,844	$25,341	$273,352	$26,494	$27,024	$27,565	$28,116	$28,678	$29,252	$29,837	$31,042	$31,663	$32,296	$32,942	$355,343	$105,404	$111,855	$118,702	$125,967	$461,927	$137,019	$145,406	$154,306	$163,751														$600	$780,595
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”
					$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.
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”
						Item
				Items/Parts 2
				Items/Parts 3
				Items/Parts 4
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.							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 9 Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select “Hide”
Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It’s here simply to aid you in determining how much inventory you need to purchase.						Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
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		$144,927		$57,785		$59,580		$61,443		$63,377		$65,384		$67,469		$69,634		$71,884		$74,221		$76,650		$115,613		$927,967		$119,645		$123,158		$126,798		$130,570		$134,478	$138,530	$142,731	$147,087	$151,606	$156,294	$161,158	$166,207	$1,698,261	$544,148	$598,355		$659,174	$727,530	$2,529,207	$824,596	$913,540	$1,013,993	$1,127,615	$3,879,744	$6,133,018

CapEx

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

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)

May

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.

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

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

ment

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

May 2020 1 $0

Mixer Beverage Filling Machine $28,500 May 2020 1 $0

May 2020 1 $0

Accutek AccuSnap Capper Bottling Machine $9,600 May 2020 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

May 2020 3 $0

Apple Macintosh $1,200 May 2020 1 $0

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

Author: Land purchases are not depreciable.

Item Name (change name here) $0 Jan 2017

$9,600 May 2020

Accutek Accusnap Capper Bottling machine $9,600 May 2020

Apple Macintosh $1,200 May 2020

Apple Macintosh $1,200 May 2020
Apple Macintosh $1,200 May 2020

Graphic Software $750 May 2020

Item Name (change name here) $0 Jan 2017

Capital Purchases

12/31/15

Purchase

Date

Year

Salvage
Value

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

Facilities

Month

December-2015

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.

2020
Author: Enter the year you will purchase the item(s).

1
Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it.
This number will be used to calculate depreciation in your financial statements using the Straight Line method.
NOTE: If you’d rather “expense” the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements.
For information about the tax implications/requirements of depreciation, please consult a competent accountant.

$0
Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it.
For example, a $1000 desk might be worth

$300

Item Name (change name here)

2017

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.

Mixer Beverage Filling Machine

$28,500

Accutek AccuSnap Capper Bottling Machine

$9,600

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

Apple Macintosh

$1,200

Graphic Software

$750

Telecommunications
Author: Telecommunications includes phone systems, fax machines, etc.

Author: Enter the year you will purchase the item(s).

Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it.
This number will be used to calculate depreciation in your financial statements using the Straight Line method.
NOTE: If you’d rather “expense” the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements.
For information about the tax implications/requirements of depreciation, please consult a competent accountant.

Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it.
For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell.
If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.

Land

Land is a
non-depreciable
asset

Accutek Accusnap Capper Bottling machine

Capital Purchases

StaffBudj

2020 2021 2022 2023 2024

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

# Salaried Employees

1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1

1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1

Avg Salary per employee

$40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000

$41,200 $41,200 $41,200 $41,200 $41,200 $41,200 $41,200 $41,200 $41,200 $41,200 $41,200

$127,308 $127,308 $127,308

$131,127 $131,127 $131,127

Benefits (across all employees) $321 $321 $321 $321 $321 $321 $321 $321 $321 $321 $321 $321

$337 $337 $337 $337 $337 $337 $337 $337 $337 $337 $337

$1,061 $1,061 $1,061

$1,114 $1,114 $1,114 $4,457

Payroll Taxes (across all employees)

$6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600 $6,600

$6,798 $6,798 $6,798 $6,798 $6,798 $6,798 $6,798 $6,798 $6,798 $6,798 $6,798

$21,006 $21,006 $21,006

$21,636 $21,636 $21,636

Total Costs

$50,921 $50,921 $50,921 $50,921 $50,921 $50,921 $50,921 $50,921 $50,921 $50,921 $50,921

$52,455 $52,455 $52,455 $52,455 $52,455 $52,455 $52,455 $52,455 $52,455 $52,455 $52,455

$162,106 $162,106 $162,106

$166,990 $166,990 $166,990

,961

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

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

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

20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 60 60 60 60 60 60 60 60 240

$15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00

$15.45 $15.45 $15.45 $15.45 $15.45 $15.45 $15.45 $15.45 $15.45 $15.45 $15.45

$15.91 $15.91 $15.91

$16.39 $16.39 $16.39

Per Hourly Employee

$300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300

$309 $309 $309 $309 $309 $309 $309 $309 $309 $309 $309 $3,708 $955 $955 $955 $955

$983 $983 $983

Wages $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $309 $309 $309 $309 $309 $309 $309 $309 $309 $309 $309 $309 $3,708 $955 $955 $955 $955 $3,819 $983 $983 $983 $983 $3,934 $4,052
Benefits (across all employees) $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125

$131 $131 $131 $131 $131 $131 $131 $131 $131 $131 $131 $131

$413 $413 $413

$434 $434 $434

Payroll Taxes (across all employees) $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $540 $46 $46 $46 $46 $46 $46 $46 $46 $46 $46 $46 $46 $556 $143 $143 $143 $143 $573 $148 $148 $148 $148 $590 $608
Total Costs $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470

$487 $487 $487 $487 $487 $487 $487 $487 $487 $487 $487

$1,511 $1,511 $1,511

$1,565 $1,565 $1,565

$6,483

TOTAL

$1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1

# Part-Time Employees $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1

$44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300

$45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629

$140,994 $140,994 $140,994

$145,223 $145,223 $145,223

Benefits

$446 $446 $446 $446 $446 $446 $446 $446 $446 $446 $446

$468 $468 $468 $468 $468 $468 $468 $468 $468 $468 $468 $468

$1,475 $1,475 $1,475

$1,548 $1,548 $1,548 $1,548

Payroll Taxes

$6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645

$6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844

$21,149 $21,149 $21,149

$21,784 $21,784 $21,784

$51,391 $51,391 $51,391 $51,391 $51,391 $51,391 $51,391 $51,391 $51,391 $51,391 $51,391

$52,941 $52,941 $52,941 $52,941 $52,941 $52,941 $52,941 $52,941 $52,941 $52,941 $52,941

$163,617 $163,617 $163,617

$168,555 $168,555 $168,555

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
																												1.1	1.	1 Author: Note that in year two we use quarterly numbers, not monthly numbers–so make sure you enter your numbers accordingly!
												$40,000	$480,000									$41,200	$494,400				$127,308	$509,232				$131,127	$524,509	$540,244
$3,850												$337	$4,043				$1,061	$4,245	$1,114	$4,680
											$6,600	$79,200									$6,798	$81,576				$21,006	$84,023				$21,636	$86,544	$89,140
											$50,921	$611,050									$52,455	$629,459				$162,106	$648,423				$166,990		$667	$688,089
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												$15.00									$15.45				$15.91				$16.39	$16.88
Calculated	Wages							$3,600																					$309		$3,819							$983	$3,934	$4,052
				$1,500	$1,575				$413	$1,654				$434	$1,736	$1,823
$5,640												$487	$5,839				$1,511	$6,046	$1,565	$6,260
# Full Time Employees
Salary/Wages																					$44,300		$531,600																			$45,629		$547,548		$140,994		$563,974		$145,223		$580,894		$598,320
																				$446		$5,350		$5,618								$1,475		$5,898		$6,193	$6,503
																				$6,645		$79,740																			$6,844		$82,132		$21,149		$84,596		$21,784		$87,134		$89,748
		GRAND TOTAL COSTS												$51,391	$616,690									$52,941	$635,298				$163,617	$654,469				$168,555	$674,221	$694,572

Staffing Budget

MktBudj

2020 2021 2022 2023 2024

$10,000 $10,000 $10,000 $10,000 $10,000 $0 $0 $0 $0 $0 $0

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

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

$2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000

$2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $24,000

$6,000 $6,000 $6,000 $24,000 $6,000 $6,000 $6,000 $6,000 $24,000 $24,000

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

$750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $9,000 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $9,000 $2,250 $2,250 $2,250 $2,250 $9,000 $2,250 $2,250 $2,250 $2,250 $9,000 $9,000

$300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $3,600 $900 $900 $900 $900 $3,600 $900 $900 $900 $900 $3,600 $3,600

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

$200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200

$200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400

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

$150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150

$150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800

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

$150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $1,800 $450 $450 $450 $450 $1,800 $450 $450 $450 $450 $1,800 $1,800

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

$350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350

$350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $4,200

$1,050 $1,050 $1,050 $4,200 $1,050 $1,050 $1,050 $1,050 $4,200 $4,200

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

$250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250

$250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000

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

$14,150 $14,150 $14,150 $14,150 $14,150

$4,150 $4,150 $4,150 $4,150 $4,150

$4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150

$12,450 $12,450 $12,450 $49,800 $12,450 $12,450 $12,450 $12,450 $49,800 $49,800

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

$10,000

$60,000

Advertising Agencies

Social Media Specialists

$2,000

$24,000

$6,000

SEO Specialist

Graphic/Web Design

Brochures/Leaflets/Flyers

Signs/Billboards

Merchandising Displays

Sampling/Premiums

Media Advertising

Print (newspaper, etc.)

$200

$2,400

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

$150

$1,800

Advertising Specialties

Direct Mail

Website

Development/Programming

Maintenance

Trade Shows

Fees and Setup

Travel

Exhibits/Signs

$350

$4,200

$1,050

Public Relations/Materials

Informal Marketing / Networking

Memberships/Meetings

$3,000

Entertainment

$14,150

$4,150

$109,800

$49,800

$12,450

Marketing Budget

ProSvs

2020 2021 2022 2023 2024

$2,000 $2,000 $2,000 $2,000

$1,500 $1,500 $1,500 $1,500 $1,500

$0 $0 $0 $0 $0

$2,000 $2,000 $2,000 $2,000 $2,000

$0 $0 $0 $0 $0

$10,000 $10,000 $10,000 $10,000 $10,000

$0 $0 $0 $0 $0

Total Costs

$15,500 $15,500 $15,500 $15,500

GRAND TOTAL COSTS $15,500 $15,500 $15,500 $15,500 $15,500

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

$2,000
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

Mary Cates

Other (change title here)

$15,500

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

$3,000 May 2020

$300 May 2020

May 2020

$600 May 2020

Labels $840 May 2020

$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

May 2020

Loan Source Name $0 Jan 2017 12

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.

$20,000

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

Melinda Cates

$40,000
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.

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

2020
Author: Enter the year you will receive the investment cash.

Capital investments are not paid back on a loan schedule.

Glass Bottles

Metal Caps

Cardboard Cartons

$500

NAB Ingredients

Investment Source Name

Total Capital Investments

$45,240

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

$20,000

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

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

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

Total Loans

TOTAL INVESTMENTS AND LOANS

$65,240

Capital Investments and Loans

IncSt

2020 2021 2022 2023 2024

Gross Sales $140,500 $144,465

$152,812 $157,205 $161,753 $166,462 $171,339

$181,626 $187,050 $192,672 $1,980,843 $203,464

$216,085 $222,750 $229,666 $236,844 $244,294 $252,029 $260,062 $268,404 $277,070 $286,075 $2,906,402 $938,760 $1,035,871 $1,145,177 $1,268,408 $4,388,216 $1,442,746 $1,604,042 $1,786,716 $1,993,889 $6,827,393 $10,942,311

(Commissions) $10,538 $10,835 $11,143 $11,461 $11,790 $12,131 $12,485 $12,850 $13,229 $13,622 $14,029 $14,450 $148,563 $15,260

$16,206 $16,706 $17,225 $17,763 $18,322 $18,902 $19,505 $20,130 $20,780 $21,456 $217,980 $70,407 $77,690 $85,888 $95,131 $329,116 $108,206 $120,303 $134,004 $149,542 $512,054 $820,673

$4,215 $4,334 $4,457 $4,584 $4,716 $4,853 $4,994 $5,140 $5,292 $5,449 $5,611 $5,780 $59,425 $6,104

$6,483 $6,683 $6,890 $7,105 $7,329 $7,561 $7,802 $8,052 $8,312 $8,582 $87,192 $28,163 $31,076 $34,355 $38,052 $131,646 $43,282 $48,121 $53,601 $59,817 $204,822 $328,269

Net Sales

$129,296 $132,968 $136,767 $140,699 $144,769 $148,984 $153,349 $157,870 $162,555 $167,410 $172,442 $1,772,854 $182,100

$193,396 $199,361 $205,551 $211,975 $218,643 $225,566 $232,755 $240,222

$256,037 $2,601,230

$927,105

$1,135,225 $3,927,453 $1,291,257 $1,435,618 $1,599,111 $1,784,531 $6,110,516 $9,793,368

$70,250 $72,233 $74,284 $76,406 $78,603 $80,877 $83,231 $85,670 $88,196 $90,813 $93,525

$990,421

$108,042 $111,375 $114,833

$126,015 $130,031 $134,202 $138,535 $143,037 $1,453,201 $469,380 $517,936 $572,588 $634,204 $2,194,108 $721,373 $802,021 $893,358 $996,944 $3,413,696 $5,471,155

GROSS PROFIT $55,498 $57,064 $58,684 $60,361 $62,096 $63,892 $65,753 $67,679 $69,675 $71,742 $73,885 $76,106 $782,433 $80,368

$85,353 $87,986 $90,718 $93,553 $96,496 $99,552 $102,724

$109,443 $113,000 $1,148,029 $370,810 $409,169 $452,345 $501,021 $1,733,345 $569,885 $633,597 $705,753 $787,586 $2,696,820 $4,322,213

$44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $44,300 $531,600 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $45,629 $547,548 $140,994 $140,994 $140,994 $140,994 $563,974 $145,223 $145,223 $145,223 $145,223 $580,894 $598,320

$446 $446 $446 $446 $446 $446 $446 $446 $446 $446 $446 $446 $5,350 $468 $468 $468 $468 $468 $468 $468 $468 $468 $468 $468 $468 $5,618 $1,475 $1,475 $1,475 $1,475 $5,898 $1,548 $1,548 $1,548 $1,548 $6,193 $6,503

$6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $6,645 $79,740 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $6,844 $82,132 $21,149 $21,149 $21,149 $21,149 $84,596 $21,784 $21,784 $21,784 $21,784 $87,134 $89,748

$1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $15,500 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $1,292 $15,500

$3,875 $3,875 $3,875 $15,500 $3,875 $3,875 $3,875 $3,875 $15,500 $15,500

$14,150 $14,150 $14,150 $14,150 $14,150 $14,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $109,800 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $4,150 $49,800 $12,450 $12,450 $12,450 $12,450 $49,800 $12,450 $12,450 $12,450 $12,450 $49,800 $49,800

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

$1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000

$1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $3,000 $3,000 $3,000 $3,000 $12,000 $12,000

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

$33 $33 $33 $33 $33 $33 $33 $33 $33 $33 $33 $33 $400 $100 $100 $100 $100 $400 $100 $33 $0 $0

$250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $3,000 $750 $750 $750 $750 $3,000 $750 $750 $750 $750 $3,000 $3,000

$60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60

$60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $720 $180 $180 $180 $180 $720 $180 $180 $180 $180 $720 $720

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

$200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400 $600 $600 $600 $600 $2,400 $600 $600 $600 $600 $2,400 $2,400

$50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600 $150 $150 $150 $150 $600 $150 $150 $150 $150 $600 $600

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 $83 $80 $77 $73 $70 $67 $63 $60 $573 $56 $53 $50 $46 $43 $39 $36 $32 $29 $25 $22 $18

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

$68,393 $68,393 $68,393

$184,722

$189,560

$9,180

$27,964

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3 $16 $32 $50 $71

$4,088

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

$2,295

-$12,895 -$11,329 -$9,709 -$8,032 -$6,413 -$4,613

$8,384 $9,937

Income Statements Author: For information about this worksheet, see “Income Statements” in Successful Business Plan: Secrets & Strategies.
INCOME
$148,567	$176,391	$209,659.00
$15,724.43
(Returns and allowances)	$6,289.77
$125,748	$187,644.81	$247,978	$840,190	$1,024,933
(Cost of Goods)				$96,336			$101,732	$104,829.50			$118,422			$122,147
$82,815.31	$106,020
EXPENSES – General and Administrative
Salaries and wages
Employee benefits
Payroll taxes
Professional services								$3,875
Marketing and advertising
Rent
Equipment rental																								$1,000					$12,000
Depreciation		$267	$133
Insurance
Telephone service					$720
Utilities
Office supplies
Postage and shipping
Interest on loans	$449
TOTAL EXPENSES										$68,393	$68,509	$68,506	$58,503	$58,499	$58,496	$58,492	$58,489	$58,486	$761,550	$60,033	$60,030	$60,026	$60,023	$60,019	$60,016	$60,012	$60,009	$60,005	$60,002	$59,998	$59,995	$720,166	$184,755	$184,726		$184,722	$738,925	$189,660	$189,594			$189,560	$758,374	$778,592
Net income before taxes and interest		-$12,895		-$11,329		-$9,709		-$8,032		-$6,413		-$4,613	$7,250	$11,179	$13,250	$15,396	$17,620	$20,883	$20,335	$22,786	$25,327	$30,699	$33,538	$36,484	$39,543	$42,719	$46,018	$49,445	$53,005	$427,862	$186,055	$224,443	$267,623	$316,299	$994,420	$380,224	$444,003	$516,192	$598,026	$1,938,446	$3,543,621
	Interest Income			$173			$451			$770			$1,179			$1,688			$2,313			$3,083			$4,003			$5,095			$14,493			$48,013
Provision for taxes on income	$1,813	$2,795	$3,312	$3,849	$4,405		$5,221	$5,084	$5,696	$6,332	$6,991	$7,675		$8,384	$9,121	$9,886	$10,684	$11,513	$12,374	$13,269	$106,966	$46,627	$56,303	$67,200	$79,497	$249,627	$95,634	$111,771	$130,049	$150,780	$488,235	$897,909
NET PROFIT	$5,438	$6,885	$11,547	$13,215		$15,662	$15,251	$17,089	$18,995	$20,973	$23,024	$25,153	$27,363	$29,659	$32,052	$34,538	$37,121	$39,807	$321,070	$139,880	$168,910	$201,601	$238,490	$748,881	$286,903	$335,314	$390,147	$452,341	$1,464,704	$2,693,726

Income Statements

CshFlw

2020 2021 2022 2023 2024

$70,250 $72,233 $74,284 $76,406 $78,603 $80,877 $83,231 $85,670 $88,196 $90,813 $93,525 $96,336 $990,421 $101,732 $104,830 $108,042 $111,375 $114,833 $118,422 $122,147 $126,015 $130,031 $134,202 $138,535 $143,037 $1,453,201 $469,380 $517,936 $572,588 $634,204 $2,194,108 $721,373 $802,021 $893,358 $996,944 $3,413,696 $5,471,155

$0 $70,250 $72,233 $74,284 $76,406 $78,603 $80,877 $83,231 $85,670 $88,196 $90,813 $93,525

$96,336 $101,732 $104,830 $108,042 $111,375 $114,833 $118,422 $122,147 $126,015 $130,031 $134,202 $138,535

$70,250

Interest Income

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3 $16 $32 $50 $71 $173 $451 $770 $1,179 $1,688 $4,088 $2,313 $3,083 $4,003 $5,095 $14,493 $48,013

$0 $0 $0 $0 $20,000 $0 $0 $0 $0 $0 $0 $0 $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Equity Capital Investments $0 $0 $0 $0 $45,240 $0 $0 $0 $0 $0 $0 $0 $45,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $65,240 $0 $0 $0 $0 $0 $0 $0 $65,240 $0 $0 $0 $0 $0 $0 $0 $3 $16 $32 $50 $71 $173 $451 $770 $1,179 $1,688 $4,088 $2,313 $3,083 $4,003 $5,095 $14,493 $48,013

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

$70,250 $142,483 $146,516 $150,689

$159,479 $164,108 $168,901 $173,865 $179,008 $184,338 $189,861

$198,068 $206,561 $212,872 $219,417 $226,208 $233,255 $240,569

Inventory $144,927 $57,785 $59,580 $61,443 $63,377 $65,384 $67,469 $69,634 $71,884 $74,221 $76,650 $115,613 $927,967 $119,645 $123,158 $126,798 $130,570 $134,478 $138,530 $142,731 $147,087 $151,606 $156,294 $161,158 $166,207 $1,698,261 $544,148 $598,355 $659,174 $727,530 $2,529,207 $824,596 $913,540 $1,013,993 $1,127,615 $3,879,744 $6,133,018

$68,393 $68,393 $68,393 $68,393 $68,393 $68,393

$58,393 $58,393 $58,393 $58,393 $58,393

$59,943 $59,943 $59,943 $59,943 $59,943 $59,943 $59,943 $59,943 $59,943 $59,943 $59,943

$184,622 $184,622 $184,622

$189,560 $189,560 $189,560 $189,560

$778,592

Capital Purchases $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $104,100 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0

$877 $877 $877 $877 $877 $877 $877

$877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877

$877 $0 $0 $3,510 $0 $0 $0 $0 $0 $0

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

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

Cash Receipts $70,250 $142,483 $146,516 $150,689 $220,248 $159,479 $164,108 $168,901 $173,865 $179,008 $184,338 $189,861 $198,068 $206,561 $212,872 $219,417 $226,208 $233,255 $240,569 $248,165 $256,062 $264,265 $272,787 $281,643 $925,789 $1,020,456 $1,128,138 $1,249,557 $1,416,002 $1,580,242 $1,760,273 $1,964,455 $10,866,709

$228,072 $141,347 $143,572 $145,881 $253,253 $151,638 $144,218 $146,895 $149,675 $152,561 $155,560 $195,113 $201,829 $205,993 $210,307 $214,779 $219,414 $224,219 $229,202 $234,371 $239,733 $245,297 $251,071 $257,065 $829,973 $892,621 $964,040 $1,045,335 $1,165,644 $1,271,525 $1,391,159 $1,526,533 $8,060,553

-$141,322 -$140,186 -$137,242 -$132,434 -$165,438 -$157,598 -$137,708 -$115,702 -$91,511 -$65,064 -$36,286 -$41,538 -$41,538 -$45,299 -$44,731 -$42,166 -$37,528 -$30,733 -$21,697 -$10,330 $3,464 $19,793 $38,761 $60,477 $85,056 $85,056 $180,872 $308,706 $472,805 $677,027 $677,027 $927,385 $1,236,102 $1,605,217 $2,043,139 $2,043,139

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	$894,085	$1,406,500	$455,957	$501,750	$554,371	$613,665	$2,125,744	$692,316	$775,138	$862,912	$962,416	$3,292,783	$5,347,541
Total Cash from Sales			$142,483			$146,516			$150,689	$155,008			$159,479			$164,108			$168,901			$173,865			$179,008			$184,338			$189,861	$1,884,506			$198,068			$206,561		$212,872		$219,417			$226,208			$233,255			$240,569	$248,162	$256,045	$264,233	$272,737	$281,573	$2,859,701	$925,338	$1,019,686	$1,126,959	$1,247,869	$4,319,852	$1,413,689	$1,577,159	$1,756,270	$1,959,360	$6,706,479	$10,818,696
Income from Financing
$0 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		$220,248	$1,949,746		$248,165		$256,062		$264,265		$272,787		$281,643	$2,859,874		$925,789		$1,020,456		$1,128,138		$1,249,557	$4,323,940		$1,416,002		$1,580,242		$1,760,273		$1,964,455	$6,720,972		$10,866,709
CASH DISBURSEMENTS
Operating Expenses						$58,393	$760,710												$59,943	$719,318				$184,622	$738,489	$758,241
Commissions/Returns & Allowances	$14,753	$15,169	$15,600	$16,045	$16,507	$16,984	$17,479	$17,991	$18,521	$19,071	$19,640	$20,231	$207,988	$21,364	$22,014	$22,689	$23,389	$24,115	$24,869	$25,651	$26,463	$27,306	$28,182	$29,092	$30,038	$305,172	$98,570	$108,766	$120,244	$133,183	$460,763	$151,488	$168,424	$187,605	$209,358	$716,876	$1,148,943
	$	104,100
Loan Payments																																											$877	$7,019	$10,529	$2,632
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		$228,072		$141,347		$143,572		$145,881		$253,253		$151,638		$144,218		$146,895		$149,675		$152,561		$155,560		$195,113	$2,007,785		$201,829		$205,993		$210,307		$214,779		$219,414		$224,219		$229,202	$234,371	$239,733		$245,297		$251,071		$257,065	$2,733,280		$829,973		$892,621		$964,040		$1,045,335	$3,731,969		$1,165,644		$1,271,525		$1,391,159		$1,526,533	$5,354,861		$8,060,553
NET CASH FLOW	-$157,822	$1,136	$2,944	$4,808	-$33,005	$7,841	$19,890	$22,006	$24,191	$26,447	$28,778	-$5,252	-$58,038	-$3,761	$568	$2,564	$4,639	$6,795	$9,036	$11,367	$13,794	$16,329	$18,968	$21,716	$24,578	$126,594	$95,816	$127,835	$164,098	$204,223	$591,972	$250,358	$308,717	$369,115	$437,922	$1,366,111	$2,806,156
Opening Cash Balance		$16,500		-$141,322		-$140,186			-$137,242		-$132,434		-$165,438			-$157,598		-$137,708		-$115,702			-$91,511		-$65,064		-$36,286				-$41,538		-$45,299		-$44,731		-$42,166		-$37,528	-$30,733	-$21,697		-$10,330		$3,464		$19,793		$38,761		$60,477				$85,056		$180,872		$308,706		$472,805				$677,027		$927,385		$1,236,102	$1,605,217	$2,043,139
Cash Disbursements
ENDING CASH BALANCE		$4,849,295

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

Fresh N Fruity Fresh N Fruity Fresh N Fruity Fresh N Fruity Fresh N Fruity Fresh N Fruity Fresh N Fruity Fresh N Fruity

2021 2022 2023 2024

2020 2020 2020 2020

ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS ASSETS

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

Cash -$137,242 Cash -$157,598 Cash -$91,511 Cash -$41,538 Cash $85,056 Cash $677,027 Cash $2,043,139 Cash $4,849,295

$74,284 Accounts Receivable $80,877 Accounts Receivable $88,196 Accounts Receivable $96,336 Accounts Receivable $143,037 Accounts Receivable

Accounts Receivable

Inventory

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

Total Current Assets

Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets Fixed Assets

Land $0 Land $23,550 Land $23,550 Land $23,550 Land $23,550 Land $23,550 Land $23,550 Land $23,550
Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0 Facilities $0
Equipment $0 Equipment

Equipment $76,200 Equipment $76,200 Equipment $76,200 Equipment $76,200 Equipment $76,200 Equipment $76,200

$0 Computers & Telecommunications

Computers & Telecommunications $4,350 Computers & Telecommunications $4,350 Computers & Telecommunications $4,350 Computers & Telecommunications $4,350 Computers & Telecommunications $4,350 Computers & Telecommunications $4,350

$0 (Less Accumlated Depreciation) $67 (Less Accumlated Depreciation) $167 (Less Accumlated Depreciation) $267 (Less Accumlated Depreciation) $667 (Less Accumlated Depreciation)

(Less Accumlated Depreciation) $1,200 (Less Accumlated Depreciation) $1,200

$0 Total Fixed Assets

Total Fixed Assets

Total Fixed Assets $102,900

$10,000 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0 Other Assets $0

TOTAL ASSETS

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

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

Income Taxes Due $0 Income Taxes Due

Income Taxes Due $5,221 Income Taxes Due

Income Taxes Due

$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

$0 Total Current Liabilities $9,832 Total Current Liabilities

Total Current Liabilities

Total Current Liabilities $361,813 Total Current Liabilities $850,048 Total Current Liabilities $1,747,957

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

Long-Term Notes Payable

Long-Term Notes Payable $3,473 Long-Term Notes Payable

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 $8,577 Total Long-Term Liabilities $6,041 Total Long-Term Liabilities $3,473 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

$16,500 Paid-In Capital

Paid-In Capital $61,740 Paid-In Capital $61,740 Paid-In Capital $61,740 Paid-In Capital $61,740 Paid-In Capital $61,740 Paid-In Capital $61,740

Retained Earnings

Retained Earnings $15,662 Retained Earnings

Retained Earnings

-$7,432 Total Net Worth

Total Net Worth

-$7,432 TOTAL LIABILITIES AND NET WORTH $27,158 TOTAL LIABILITIES AND NET WORTH $52,354 TOTAL LIABILITIES AND NET WORTH $96,177 TOTAL LIABILITIES AND NET WORTH $514,132 TOTAL LIABILITIES AND NET WORTH $1,509,166 TOTAL LIABILITIES AND NET WORTH $3,462,106 TOTAL LIABILITIES AND NET WORTH $7,053,740

							Balance Sheet
	First Quarter		Second Quarter		Third Quarter		Fourth Quarter
							ASSETS
							Current Assets
							Accounts Receivable	$211,401	$332,315	$455,930
$45,526	-$154	-$48,264	-$62,454	$182,605	$517,704	$983,752	$1,645,615
							Other Current Assets
							Total Current Assets			-$17,432	-$76,876	-$51,579	-$7,657	$410,698	$1,406,133	$3,359,206	$6,950,840
							Fixed Assets
						$	76,200
							Computers & Telecommunications							$	4,350
							(Less Accumlated Depreciation)	$1,067
							Total Fixed Assets	$104,033	$103,933	$103,833	$103,433	$103,033		$	102,900
							Other Assets
							TOTAL ASSETS			-$7,432		$27,158		$52,354		$96,177		$514,132	$1,509,166		$3,462,106	$7,053,740
							LIABILITIES
							Current Liabilities
							Short-Term Notes Payable	$0 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year				$9,832			$9,955			$10,080					$3,473
							Income Taxes Due	$0 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).	$6,902	$112,186		$361,813		$850,048		$1,747,957
							Other Current Liabilities
							Total Current Liabilities	$16,858	$15,301	$115,660
							Long-Term Liabilities
							Long-Term Notes Payable				$8,577				$6,041									-$0
							Other Long-Term Liabilities
							Total Long-Term Liabilities
							NET WORTH
														Paid						$61,740
							Retained Earnings	-$23,932	-$52,991	-$32,284	$336,732	$1,085,613	$2,550,317	$5,244,043
							Total Net Worth	$8,749	$29,456	$77,402	$398,472	$1,147,353	$2,612,057	$5,305,783
							TOTAL LIABILITIES AND NET WORTH

Balance Sheet

BrkEvn

January

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

February $173,146
March $173,146
April $173,146
May

June

July

August

September

October

November

December

(2021)

January

February

March

April

May

June

July

August

September

October

November

December

Monthly Average

(2022)

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter $467,651

(2023)

1st Quarter

2nd Quarter

3rd Quarter

4th Quarter $479,899
Quarterly Average $479,984

(2024)

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 (2020)
			$173,146
$173,441
$173,433
$148,108
$148,099
$148,091
$148,082
$148,074
$148,065
	Monthly Average	$160,665
		Year 2
$151,982
$151,973
$151,965
$151,956
$151,947
$151,938
$151,930
$151,921
$151,912
$151,903
$151,894
$151,885
$151,934
		Year 3
$467,734
$467,660
	$467,651
	Quarterly Average	$467,674
		Year 4
$480,153
	$479,984
	$479,899
		Year 5
Annual Average	$1,971,118

Break-even Estimates

Ratios

Year 1 (2020)

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

Net Sales

1st Quarter -$17,432 N.A. N.A.

0.00

457%

2nd Quarter

3rd Quarter

4th Quarter

Year 2 (2021)

Year 3 (2022)

25%

Year 4 (2023)

Year 5 (2024)

1.88 0.33

50%

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.
-22.26		457%	–	9%	$388,011.18
	-$86,708	-7.82	-7.80	-4.87	2.10	-218%	-5%	-70%	$422,234.09
	-$68,437	-3.06	-0.20	-6.72	0.78	94%	6%	53%	$460,202.60
	-$22,958	–	0.50	3.58	-2	1.88	0.24	60%	48%	$502,406.19
	$295,038	3.55	1.97	8.82	0.29	107%	16%	83%	$2,601,230.03
	$1,044,320	3.89	2.46	3.76	0.32	87%	66%	$3,927,453.12
	$2,509,157	3.95	2.79	2.44		0.33	74%	32%	56%	$6,110,516.35
	$5,202,883	3.98	3.04	67%	36%	$9,793,368.21

Key Ratios

1YrAtGl

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

Gross Sales January February March April May June July August September October November December 140500 144465 148567.05000000002 152811.77850000001 157205.07094500004 161753.08208265001 166462.24892899051 171339.30437249222 176391.29144811005 181625.57831464859 187049.87397039676 192672.24474373265 Gross Profit January February March April May June July August September October November December 55497.5 57063.675000000003 58683.984750000018 60360.652507499995 62096.003023275029 63892.467422646776 65752.588326951256 67679.025227134422 69674.560122003473 71742.103434286168 73884.700218306709 76105.536673774404 Net Profit January February March April May June July August September October November December -12895 -11328.824999999997 -9708.5152499999822 -8031.8474925000046 -6413.1636433916283 -4613.3905170976 068 5437.5396753685 6884.8696183232296 8384.0334834082842 9937.2141311116247 11546.695395799561 13214.866971059002

NSYr1

Year 1: Net Sales (2020)

Tropical Fizz Straberries January February March April May June July August September October November December 48330 49296.6 50282.532000000007 51288.182640000006 52313.946292800007 53360.225218656 54427.429723029119 55515.978317489709 56626.297883839507 57758.823841516292 58914.000318346618 60092.280324713553 Tropical Fizz Kiwi January February March April May June July August September October November December 34457.5 36180.375 37989.393750000003 39888.863437499997 41883.306609375002 43977.471939843759 46176.34553683595 48485.162813677744 50909.420954361638 53454.89200207973 56127.636602183717 58934.018432292891 Tropical Fizz Mango January February March April May June July August September October November December 26850 27387 27934.74 28493.434799999999 29063.303496000004 29644.569565920003 30237.460957238403 30842.210176383171 31459.054379910838 32088.235467509057 32730.00017685923 33384.600180396417 Tropical Fizz Pineapple January February March April May June July August September October November December 16110 16432.2 16760.844000000001 17096.060880000005 17437.98 2097600005 17786.741739551999 18142.47657434304 18505.326105829903 18875.432627946502 19252.941280505431 19638.000106115542 20030.760108237853 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 (2020)

Net Cash Flow January February March April May June July August September October November December -157821.5 1135.7599999999802 2943.6162000000186 4808.4940740000457 -33004.850511701312 7840.7175278332725 19890.150252852269 22005.932623300119 24190.659681631834 26447.041773628735 28777.910024589102 -5252.2161108290893 Ending Cash Balance -141321.5 -140185.74000000002 -137242.1238 -132433.62972599996 -165438.48023770127 -157597.76270986799 -137707.61245701573 -115701.67983371561 -91511.020152083773 -65063.978378455038 -36286.068353865936 -41538.284464695025

2ndYrCshFlw

Year 2: Cash Flow (2021)

Net Cash Flow January February March April May June July August September October November December -3760.9151763690752 568.40098142795614 2564.3099394791352 4638.5435541510815 6794.588642449351 9036.0977739128866 11366.897386475088 13793.880167132651 16329.074774884561 18968.367282271705 21716.459704458306 24578.279058401589 Ending Cash Balance January February March April May June July August September October November December -45299.1996410641 -44730.798659636144 -42166.488720157009 -37527.945166005928 -30733.356523556577 -21697.25874964369 -10330.361363168602 3463.5188039640489 19792.593578848609 38760.960861120344 60477.420565578621 85055.69962398021

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2020 2021 2022 2023 2024 1980842.523306021 2906402.2658191081 4388215.7754414044 6827392.5677646119 10942310.844247932 Gross Profit 2020 2021 2022 2023 2024 782432.79670587834 1148028.8949985476 1733345.2312993547 2696820.0642670216 4322212.7834779331 Net Profit 2020 2021 2022 2023 2024 15662.162847828353 321069.63788553199 748881.22315751598 1464704.3140864177 2693725.5679288069

NS5Yr

5-Year Net Sales

Tropical Fizz Straberries 2020 2021 2022 2023 2024 648206.29656039097 842634.37471640366 1095380.7348391793 1423937.8196037218 1851044.8920716948 Tropical Fizz Kiwi 2020 2021 2022 2023 2024 548464.38707815041 1009587.3201104503 1858400.6198793845 3420856.0222311858 6296950.0761331413 Tropical Fizz Mango 2020 2021 2022 2023 2024 360114.60920021712 468130.20817578002 608544.85268843314 791076.56644651236 1028358.273373164 Tropical Fizz Pineapple 2020 2021 2022 2023 2024 216068.76552013028 280878.12490546791 365126.91161305981 474645.93986790738 617014.96402389824 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 2020
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-15 CREDIT MULTIPLIER Multiple With “Credit Sales” A 0.00 0.00
B 1.00 0.50
Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet Q1

-$17,432
Q2

-$86,708
Q3

-$68,437
Q4

-$22,958
Y2

$295,038
Y3

$1,044,320
Y4

$2,509,157
Y5

$5,202,883
Chart Titles Year 1 String

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

2021 Year 1: Net Sales (2020)
Year 3 String

2022 Year 1: Cash Flow (2020)
Year 4 String

2023 Year 2: Cash Flow (2021)
Year 5 String

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

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 May 2020 1 12 Nov-16

–

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

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

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

3 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
4 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
5 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
6 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
7 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
8 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
9 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
10 Facilities Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
11 Equip Mixer Beverage Filling Machine

$0.00 1 12 May 2020 5 16 Mar-17

12 Equip Mixer Beverage Filling Machine $28,500.00 $0.00 1 12 May 2020 5 16 Mar-17 $ 2,375 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
13 Equip Accutek AccuSnap Capper Bottling Machine

$0.00 1 12 May 2020 5 16 Mar-17

14 Equip Accutek AccuSnap Capper Bottling Machine $9,600.00 $0.00 1 12 May 2020 5 16 Mar-17 $ 800 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
15 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
16 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
17 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
18 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
19 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
20 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
21 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
22 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
23 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
24 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
25 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
26 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
27 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
28 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
29 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
30 Equip Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
31 Comp Apple Macintosh

$0.00 3 36 May 2020 5 40 Mar-19

– – – – 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 33 – – – – – – – – – – – – – – – – – – – –

32 Comp Apple Macintosh $1,200.00 $0.00 1 12 May 2020 5 16 Mar-17

33 Comp Apple Macintosh $1,200.00 $0.00 1 12 May 2020 5 16 Mar-17 $ 100 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
34 Comp Graphic Software

$0.00 1 12 May 2020 5 16 Mar-17

35 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
36 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
37 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
38 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
39 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
40 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
41 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
42 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
43 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
44 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
45 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
46 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
47 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
48 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
49 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
50 Comp Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16 $ – 0 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
51 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16
52 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16
53 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16
54 Land Accutek Accusnap Capper Bottling machine $9,600.00 $0.00 1 12 May 2020 5 16 Mar-17
55 Land Accutek Accusnap Capper Bottling machine $9,600.00 $0.00 1 12 May 2020 5 16 Mar-17
56 Land Apple Macintosh $1,200.00 $0.00 1 12 May 2020 5 16 Mar-17
57 Land Apple Macintosh $1,200.00 $0.00 1 12 May 2020 5 16 Mar-17
58 Land Apple Macintosh $1,200.00 $0.00 1 12 May 2020 5 16 Mar-17
59 Land Graphic Software $750.00 $0.00 1 12 May 2020 5 16 Mar-17
60 Land Item Name (change name here) $0.00 $0.00 1 12 Jan 2017 1 12 Nov-16
TOTAL $ – $ – $ – $ – $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ 33 $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ – $ –
Land – – – – 23,550 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Facilities – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Equip – – – – 76,200 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
Comp – – – – 4,350 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

– – – – 104,100 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –

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

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

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Sep-18

Oct-18

Nov-18

Dec-18

Jan-19

Feb-19

Mar-19

Apr-19

May-19

Jun-19

Jul-19

Aug-19

Sep-19

Oct-19

Nov-19

Dec-19

Jan-20

Feb-20

Mar-20

Apr-20

May-20

Jun-20

Jul-20

Aug-20

Sep-20

Oct-20

Nov-20

Item#

LoanInvestSchedules

Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds Investment Proceeds

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 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20

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 Melinda Cates $40,000 May 2020 5 – 0 – 0 – 0 – 0

– 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 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 Glass Bottles $3,000 May 2020 5 – 0 – 0 – 0 – 0

3 Metal Caps $300 May 2020 5 – 0 – 0 – 0 – 0

4 Cardboard Cartons $500 May 2020 5 – 0 – 0 – 0 – 0 500.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
5 NAB Ingredients $600 May 2020 5 – 0 – 0 – 0 – 0 600.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
6 Labels $840 May 2020 5 – 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 $45,240 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 $20,000 5.00% 24 May 2020 5 28

– 0 – 0 – 0 – 0 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 877.43 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 0 – 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 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $877 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $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

May

5 28 877.43 – – – –

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

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 $83 $80 $77 $73 $70 $67 $63 $60 $56 $53 $50 $46 $43 $39 $36 $32 $29 $25 $22 $18 $14 $11 $7 $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 $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 $20,000 May 2020 5 – – – – 20,000.00 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
2 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
3 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
4 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
5 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
6 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
7 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
8 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
9 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
10 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
11 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
12 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
13 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
14 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
15 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
16 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
17 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
18 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
19 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
20 Loan Source Name $0 Jan 2017 1 – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
TOTAL: $0 $0 $0 $0 $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

5.00% 24 May 2020 5 $20,000 $0

$9,832 $8,577

$9,955 $6,041

$10,080 $3,473

$3,473 -$0 $20,000 $0 -$0 $20,000 $0 -$0 $20,000 $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 $9,832 $8,577 $9,955 $6,041 $10,080 $3,473 $3,473 -$0 $0 -$0 $0 -$0 $0 -$0

Loan Calculations for Balance Sheet Loan Calculations for Balance Sheet

Dec-15 Jan-16 Feb-16 Dec-15 Apr-16 May-16 Dec-15 Jul-16 Aug-16 Dec-15 Oct-16 Nov-16 Dec-15 Jan-17 Feb-17 Dec-15 Apr-17 May-17 Dec-15 Jul-17 Aug-17 Dec-15 Oct-17 Nov-17 Dec-15 Jan-18 Feb-18 Dec-15 Apr-18 May-18 Dec-15 Jul-18 Aug-18 Dec-15 Oct-18 Nov-18 Dec-15 Jan-19 Feb-19 Dec-15 Apr-19 May-19 Dec-15 Jul-19 Aug-19 Dec-15 Oct-19 Nov-19 Dec-15 Jan-20 Feb-20 Dec-15 Apr-20 May-20 Dec-15 Jul-20 Aug-20 Dec-15 Oct-20 Nov-20
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 $20,000.00

24 May $2,020.00 5 28 Principle Paid $0.00 $0.00 $0.00 $0.00

$20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.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

Due Long $0.00 $0.00 $0.00 $0.00 $9,414.71 $8,576.51 $7,734.81 $6,889.62 $6,040.89 $5,188.64 $4,332.83 $3,473.45 $2,610.50 $1,743.95 $873.79

-$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$0.00 -$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 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000

					Investment Proceeds
Inv #	Name of Invest Source						Start Year	Infusion Month
40,000.00
3,000.00
300.00
840.00
				TOTAL:
						Loan Payback Schedule (Principle + Interest)
	Dec-20		Jan-21		Feb-21		Mar-21		Apr-21		May-21		Jun-21		Jul-21		Aug-21		Sep-21		Oct-21		Nov-21
				Loan #					Name of Loan Source				Periods					Begin Pay Month		End Pay Month		Pmt Amt (P+I)
																									877.43
						Loan – Interest Portion of Loan Payments
$	20,000.00	$0.05	$24.00		$2,020.00	83.33	80.02	76.70	73.37	70.02	66.65	63.27	59.88	56.47	53.05	49.62	46.17	42.71	39.23	35.74	32.23	28.71	25.17	21.62	18.05	14.47	10.88	7.27	3.64
				Loan Calculations for Balance Sheet
	Principle Paid									Due Short									Due Long
																																$20,000.00	$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.	$1,591 Sure Product Consulting: cummulative principle paid: includes previous quarter’s payments	$4,004	$6,446	$16,527
BETA – Monthly Loan Calculations for Balance Sheet
Last Month Num
5.000%	$794.09	$1,591.50	$2,392.22	$3,196.29	$4,003.70	$4,814.47	$5,628.63	$6,446.18	$7,267.13	$8,091.50	$8,919.31	$9,750.57	$10,585.29	$11,423.49	$12,265.19	$13,110.38	$13,959.11	$14,811.36	$15,667.17	$16,526.55	$17,389.50	$18,256.05	$19,126.21
$9,791.20	$9,832.00	$9,872.96	$9,914.10	$9,955.41	$9,996.89	$10,038.54	$10,080.37	$10,122.37	$10,164.55	$10,206.90	$10,249.43		$9,414.71		$8,576.51		$7,734.81		$6,889.62		$6,040.89		$5,188.64		$4,332.83		$3,473.45		$2,610.50	$1,743.95	$873.79
																																							-$0.00

Loan & Investment Schedules for Disbursement & Repayment

Professor Andrea Banto

Unfortunately, your Assignment is 84% similar to another student’s paper or sources and cannot be accepted for grading. Please see the attached Safe Assign Report. The sections in caps and bold represent content from other sources. If you scroll at the bottom, you will see your information to the left and the original source and text to the right.

Shaquinna Wilson

The academic integrity department evaluates and records these high similarity cases.

You will be allowed to resubmit the paper with a 20% penalty as a one-time exception.

You can adjust your paper and submit original content (paraphrase and cite any sources used) as soon as you can but by Saturday, March 7, at midnight. This is a one-time exception and other resubmissions will not be allowed.

You should not use other students’ papers as a source. This may not be flagged by Grammarly but Safe Assign has a database of all student papers submitted at Strayer

Be sure to submit only original work for the remainder of the class and program. Check your work in Grammarly before submitting it to the class and ensure you have 100% original content, paraphrased correctly and that you cited all your sources appropriately (in-text citation and references at the end). Safe Assign is a strong plagiarism checker and they store all Strayer submissions in their database in addition to web sources.

If you submit another discussion or assignment in this class with high similarity, additional consequences may apply, including suspension.

What Will You Get?

We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.

Premium Quality

Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.

Experienced Writers

Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.

On-Time Delivery

Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.

24/7 Customer Support

Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.

Complete Confidentiality

Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.

Authentic Sources

We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.

Moneyback Guarantee

Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.

Order Tracking

You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.

Order Now Talk to Us

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Areas of Expertise

Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.

Essay

Thesis

Presentation

Dissertation

Term Paper

Research Paper

Book Review

Assignment

Report

Case Study

Letter

Article

Coursework

Speech

Q & A

Critical Thinking

Trusted Partner of 9650+ Students for Writing

From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.

Preferred Writer

Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.

Grammar Check Report

Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.

One Page Summary

You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.

Plagiarism Report

You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.

Free Features $66FREE

Most Qualified Writer $10FREE
Plagiarism Scan Report $10FREE
Unlimited Revisions $08FREE
Paper Formatting $05FREE
Cover Page $05FREE
Referencing & Bibliography $10FREE
Dedicated User Area $08FREE
24/7 Order Tracking $05FREE
Periodic Email Alerts $05FREE

Our Services

Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.

On-time Delivery
24/7 Order Tracking
Access to Authentic Sources

Academic Writing

We create perfect papers according to the guidelines.

Professional Editing

We seamlessly edit out errors from your papers.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Thorough Proofreading

We thoroughly read your final draft to identify errors.

Delegate Your Challenging Writing Tasks to Experienced Professionals

Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!

Check Out Our Sample Work

Dedication. Quality. Commitment. Punctuality

It May Not Be Much, but It’s Honest Work!

Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.

0+

Happy Clients

0+

Words Written This Week

0+

Ongoing Orders

0%

Customer Satisfaction Rate

Process as Fine as Brewed Coffee

We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.

Call Us +1 (877) 657-8180 Discuss Order Details Now

See How We Helped 9000+ Students Achieve Success

We Analyze Your Problem and Offer Customized Writing

We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.

Clear elicitation of your requirements.
Customized writing as per your needs.

We Mirror Your Guidelines to Deliver Quality Services

We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.

Proactive analysis of your writing.
Active communication to understand requirements.

We Handle Your Writing Tasks to Ensure Excellent Grades

We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.

Thorough research and analysis for every order.
Deliverance of reliable writing service to improve your grades.

Place an Order Start Chat Now