Business Financial Expert Only

previous_assignments_for_reference.zip

Home >Business & Finance homework help >Business Financial Expert Only

Previous Assignments for reference/Business_plan_financials.xlsx

Sheet1

Business Plan Financials
ITEM	QUANTITY	COST
PERSONNEL	1
Full-time Project Coordinator Including on-costs.		$52,500
EDUCATION & TRAINING
GP workshops	4 @ $450	$1,800
Practice staff workshops Seminar for Marketing and Sales Person professionals	2 @ $ 600	$1,200
Practice sales & marketing workshops	1 @ $1,000	$1,000
	2 @ $550	$1,100
PROJECT RESOURCES
Referral resource	600 @ $1 per card
Design and printing of cards x 500 Production of CD Roms x 50 ‘Guide on Depression in the Elderly’ leaflet
Design and printing of leaflet x 10,000	50 @ $5 per CD	$600
Invitation to Sales and Marketing professionals Seminar Design and printing of invitation x 500		$500
Additional pamphlets. Design and printing of posters x 200		$250
Video Editing and production of video x 100	10,000 @ 35 cents per leaflet	$3,500
	500 @ 50 cents per invitation	$250
		$2,000
		$2,000
		$600
	$2,000	$5,000
	200 @ $3 per poster
	100 @ $500
PROMOTION
Advertising 10 weeks of press advertising in 3 local papers 6 weeks of radio advertising on 3 local stations Media relations	Bulk promotional rates may be available
a) Program launch – costs include venue, catering, AV, ancillary speakers costs, media packs etc. Costs estimated for 40-70 attendees.
b). On-going Social Media campaign
	$ 3, 000	$3,000
	$400
MBC AWARENESS WEEK
Displays Coordination of volunteers	10 volunteers @ $30 each	$300
Skits in Community Centers
	10 volunteers @ 55 each	550
VOLUNTEER NETWORK
Most of the costs will be incurred by sponsor.	$6,000	$6,000
EVALUATION
Formative, process, impact and outcome evaluations	Approx. 10% of total costs
ADMINISTRATION
Office space and associated overheads (lighting, power etc)	Offered by the agency
Stationery, photocopying and printing
Mailing, telephone and fax
Travel	4, 500	4500
Documentation of Program Audit costs	5,500	5,500
	400	400
	700	700
	Offered by the Agency
TOTAL		$93,250

Previous Assignments for reference/Mari_B_Company_Ass_1.docx

Mari Beverage Company 1

Running Head: MARI BEVERAGE COMPANY

Student Name Business 599

Professor Name July 19, 2015 Strayer University

Mari Beverage Company 2

Abstract

This paper will address the following:

1. Create your revised NAB company name and explain its significance.

2. Develop your revised company’s Mission Statement and provide a rationale for its components.

3. Describe the trends in the non-alcoholic beverage industry, especially the specific type of beverage category you have chosen. Justify at least three (3) reasons why you have chosen this type of non-alcoholic beverage.

4. Choose one (1) strategic position from the course text (pp. 142–143) that you believe is the best strategic position for your company. Explain the approach you will use to implement this strategic position in order to distinguish your beverage from other non-alcoholic beverages.

5. Provide an overview of your company’s distribution channels. Explain the manner in which your product will reach end users. Provide a rationale for your chosen method.

6. Outline at least three (3) types of risks (including any regulatory risks) that your business faces. Describe your company’s plan to mitigate such risk.

7. Develop a SWOT analysis for your NAB company using the SWOT matrix worksheet in the course text (p. 153 | SWOT: Strengths / Weaknesses / Opportunities / Threats)

Mari Beverage Company 3

Mari Beverage Company

MARI Beverage Company Inc. is a New York City based company providing energy-boosting, healthy, non-alcoholic beverages to all major college campuses nationwide.

Mission Statement

“To provide first-class and affordable non-alcoholic beverage products.”

The rationale for this mission statement is that there is wide-spread belief that non-alcoholic beverage industry presents substantial health risks associated with consuming these products, and that the monies collected for products like these are, in effect, a waste for consumers since they believe that there is no real benefit to consuming items such as these. The industry is constantly under attack from major competitors such as Pepsi and Coca-Cola.

Market Trends

The non-alcoholic beverage market attracts high competition from companies such as Coca-Cola and Pepsi Cola which already command a big chunk of the market. As of 2013, the market share (based on volumes) was projected as shown in the figure below.

Mari Beverage Company 4

Figure: Non-Alcoholic Beverage Market Share Based on Volumes

Source: Beverage Digestive (2015)

The market share demonstrates that competition is stiff with the big companies already commanding significant shares of the market. The mission of Mari Beverage Company is to assist the public in maintaining healthy lifestyles. MBC wants to motivate students to feel and look fit and make rights consumer decisions concerning what put into their bodies. MVB wants to start with smoothies and juices and eventually expand to teas and coffees.

Mari Beverage Company 5

Falling Demand

Falling demand is a key challenge to the industry. The trend in demand for the beverages for the last four years ending in 2013 is captured below:

Figure: Trends in the Demand for Non-Alcoholic Beverages

Source: Beverage Digestive (2015)

The chart is a clear indicator that the non-alcoholic beverage industry has been on the decline.

Mari Beverage Company 6

Strategic Position

One strategic position for Mari Beverage Company to use is to focus on negotiating with suppliers and buy in bulk. This strategy will enable it to reduce its operation costs, remain competitive, and focus more on its marketing efforts. Other companies are following this type of position, particularly the big companies, which are already enjoying economies of scale and can easily elbow the other junior players out of the market (McGuigan, 2014).

Distribution Channels

The company will purchase its own trucks; therefore eliminating trucking costs associated with the distribution of its product. It will keep everything “in house” which will save money, create jobs, and keep costs low. It will have pre-selected major cities to distribute too with warehouse location facilities it will rent to store its products. Mari Beverage Company will rent warehouses within each respective city with exclusive leases that are “Rent-to-Own.” By doing this the company will eventually own the warehouses it is storing its product in.

Mari Beverage Company 7

Potential Risks Facing the Business

There are three major risks facing the business and the industry as a whole. First, there is the risk that the local or federal government would impose heavier restrictions of non-alcoholic beverage production in response to the foregoing concerns about obesity and sugar-related health complications. To tackle this, the company will negotiate with suppliers to keep prices low, so that what is lost in taxes will be recovered or moderated in other cost-cutting avenues. Secondly, there is the risk that the junior companies can be predated on by the old established ones through price wars. This will be tackled by making our product unique so that we win consumer loyalty. Marketing will be a priority for MBC. The third risk is that the economy would experience inflation such that the costs of inputs become too expensive to bear. This will be addressed by entering into forward contracts with suppliers so that the supply prices remain stable across the forward contract period.

SWOT Analysis of Mari Beverage Company

Threats:

· Declining Industrial Sales Volume: Non-alcoholic beverages in the industry have experienced immense decline in turn-over the past few years. This is a direct result of the increased health awareness efforts by competing companies and governmental agencies concerning the side effects of consuming sugar and other the ingredients used in manufacturing of non-alcoholic beverages.

Mari Beverage Company 8

· The falling demand, according to Beverage Digest, was 3% in 2013 in the United States alone after eight consecutive declining years. Other declines include those of 2012 and 2011 at 1.2% and 1% respectively (Beverage Digestive, 2015).

· The soda tax: Mexico, one of the leading non-alcoholic beverage product destinations, has introduced a 10% tax on products that are sugary so as to reduce their consumption in the face of growing concerns of the number of people becoming obese. The probability is high that other countries will soon follow suit and this may narrow the market expansiveness.

Opportunities:

· Consumer preferences shift is an opportunity for the company to extend its scope by venturing into still beverages. The projection is that the market for the non-alcoholic, ready-to-drink beverages will grow at 5% for the period 2014-17 with a bigger proportion of this market share coming from the emerging economies (Beverage Digestive, 2015).

· Increasing consumer disposable income: the consumer expenditure growth in the United States over the years is an indicator that the consumer will be allocating an increased amount of his disposable income on non-alcoholic beverages.

Strengths:

· Strategic location: MBC is head-quartered within New York City where the demand for beverages is high given the activities in the city.

Mari Beverage Company 9

Colleges, universities, hospitals, churches, schools and conference meetings provide a plus for the company in terms of reaching out to its customers. This strategic location will enable the company to test-market its products and marketing efforts (Beverage Digestive, 2015).

· High margins: the non-alcoholic beverage industry commands one of the biggest profit margins. Currently the margin stands at an average of 23-34%. This makes breaking even easy and chances off losses are rare.

Weaknesses:

· Big Market: The company has a huge market segment to cover. What is popular in New York City may not be popular in Dallas. Market segmentation reports will have to be broken down to regions of the country. Additionally, being that the business is going nationwide, this increases over-all risks concerning failure in markets and rising costs. (Beverage Digestive, 2015).

Mari Beverage Company 10

References

Beverage Digestive. (2015). Trends in the US Beverage Industry. "Beverage Production". Manufacturingdrinks.com. 2010-06-07. Retrieved 2013-05-21. , Retrieved on: 8/17/2015 from http://marketrealist.com/2014/11/growth-sluggish-non-alcoholic-beverage-industry/. B Beverage Corproation. (2015). Investor Information. Retrieved on 8/17/2015 from http://www.manta.com/c/mmy336s/B-beverage-corporation. McGuigan, J. R. (2014). Managerial economics: Applications, Strategies and Tactics (13th Ed.). Stamford, CT: Cengage Learning.

Coca-Cola Pepsi-Cola Dr Peper Snapple Group Cott Corporation National Beverage Other 0.43000000000000038 0.28000000000000008 0.17 4.0000000000000042E-2 3.0000000000000016E-2 5.0000000000000031E-2 Eight-Ounce Servings Per person 728 713 700 675

Previous Assignments for reference/Mari_Beverage_Company_Assignment_2_Modified.docx

Mari Beverage Company Marketing Plan 1

Running Head: MARI BEVERAGE COMPANY MARKETING PLAN

Student Name Business 599

Professor Name August 06, 2015 Strayer University

Mari Beverage Company Marketing Plan 2

Abstract

This paper will define your company’s target market and analyze the types of consumers who will be drinking my beverage in demographic terms (i.e., age, education level, income, gender, ethnic group, etc.). It will support my analysis with actual data on the size of the demographic groups in your local community It will outline the demographic information for my company specified on the worksheet in the course text. Moreover, it will assess my company’s market competition. It will use the factors listed in the course text graphic to assess your company’s market competition. It will defend my strategy to successfully compete against market leaders in my segment, and it will defend my plan to differentiate myself from the competition using the information detailed on the worksheet in the text. Additionally, it will clarify my company’s message. Lastly, the paper will identify the marketing vehicles I plan to use to build my company’s brand. It will justify key reasons why they will be effective, and it will provide examples of other non-alcoholic beverage companies that use these tactics effectively.

Mari Beverage Company Marketing Plan 3

Marketing Plan

Mari Beverage Company Inc. is located in New York City. Its goal is to provide nutritious energy boosting non-alcoholic beverages to all major college campuses within the United States.

Target Market

MBC has narrowed down its target market to college students studying in major universities within the United States. MBS has decided to use the list provided by Forbes to specifically target major universities (Forbes, 2015). This population as depicted by the target areas will comprise of an equal number of female as well as male students who come from diversified geographical locations, backgrounds, and ethnic groups. Having specified the major colleges, MBC will select a target age from seventeen years to approximately thirty five years of age. According to Grube (2009), these age limits are the most appropriate ones targeted within major college universities. The gender issues are estimated to be equal; however, the number of male students may exceed their counterparts due to different studies that continuously cite the number of male students enrolled nationwide exceeds that of females. It is important to note that the drinks will be entirely differentiated to cater for each gender group’s choices as well as preferences.

Mari Beverage Company Marketing Plan 4

Demographics Chart:

The above demographics chart can be used by MBC to further breakdown its target market.

Mari Beverage Company Marketing Plan 5

Gender Chart:

The above chart clearly breaks down the gender differential that can be used by MBC to specifically target its market at major college universities.

Mari Beverage Company Marketing Plan 6

Moreover, many students tend to entirely rely on their parents for funding during the college years, second jobs, or student loans, so they may hardly experience issues of low purchasing power. Sales are expected to hike during the opening sessions and be lower at the end of each semester as the students targeted tend to run out of funding. The level of education may also influence the rate and frequency of consumption too. Students in medical fields, as well as those who are highly educated in other fields, are suspected to take lower numbers of beverages such as soft drinks and energy drinks. Students fitting this criteria tend to believe various health findings that assert the notion that non-alcoholic drinks have associated negative health effects. It will be MBC’s marketing policy to assert the positive effects of drinking beverages such as ours. MBS will assert an aggressive campaign highlighting the benefits of consuming out product to our target market.

Assessment of the MBC’s Market Competition

Ideally, each and every business venture must face competition. The non-alcoholic beverage market is indeed a particularly crowded market field characterized with stiff competition by not only the big players in the market but also the threat of new entries. MBC expects to face a number of challenges that will all amount to stiff completion.

Mari Beverage Company Marketing Plan 7

The most important step to take will be to deal with the depicted challenges effectively.

The threat of the Existing Big Players in the Market

MBC is seeking to invest in the beverage market, a market that is highly competitive and highly controlled by the stiff competition and rivalry exhibited between Coca-Cola and the Pepsi for example. Conversely, the entry of Red Bull doubled the competition and didn’t make anything easier for MBC. It is intimidating to compete against major market players such as these. Nevertheless, as the new kid on the block, Mari Beverage Company has devised some techniques that will adequately compete with these major players. The evidence would point to the fact that the campuses and tertiary levels of education present a good niche market to target. Methods such as reducing prices, improving quality, enhancing quantity, and using guerilla marketing tactics will be key to winning over this market. MBC can out-price the competition while marketing the benefits of the product verses drinking a Coke or Pepsi for example.

Mari Beverage Company will have an involving role of ensuring that it equips all its financial resources in the best strategies possible to sustain itself during the pressure exerted by the entry of new firms and existing companies.

Mari Beverage Company Marketing Plan 8

Differentiation Strategies

According to the CQI (2011), market differentiation is an imperative strategy in ensuring that a given business firm achieves its objectives as well as remaining sustainable after its market entry. Mari Beverage Company intends to imply a plethora of fundamental strategies to ensure appropriate differentiation in ensuring that the company outplays the existing beverage market economic controllers. Basically, the MBC will devise new product pricing strategies that will be slightly lower compared to the existing players such as Red Bull, Coca-Cola and Pepsi (Czinkota & Ronkainen, 2013). The company will also launch storage warehouses in every individual university to ensure that its products are readily and easily accessible. The company will use different bottles and packaging sizes to offset the effects associated with non-biodegradability nature of those companies already existing in the market place.

MBC Marketing Message

According to Paul (2013), it is important to choose the correct message that appropriately summarizes the entire objective of the marketing plan and aligns the activities with the company mission. The main message channeled to the entire public in regard to MBC will be proving first-class and affordable non-alcoholic beverage products. Despite the main target market of the beverage company being the tertiary levels of college students, MBC will aim at ensuring that the marketing message is well prevailed and disseminated to the market to increase the target audience and realize the envisioned profit potential of the company. This message will be integral and imperative in ensuring that there is effective campaign against the misconceptions that non-alcoholic beverage industry has negative health effects.

Mari Beverage Company Marketing Plan 9

The Marketing Vehicle

To effectively compensate for the disadvantages and challenges that accrue from using a single marketing promotion, Mari Beverage Company will use several methods to ascertain that the marketing process is successful and achieves its goals. These methods including advertisement, sales promotion, as well as publicity, will be carried out simultaneously through integration of various departments within MBC (Doole & Lowe, 2012). Both online methods and physical advertisement by the use of a tracking system will be used.

Alternatively, Hana, Al-Deen, and Hendricks (2013) suggest that managers can use social media as an effective product marketing tool. Mari Beverage Company will create official YouTube links, Facebook platforms and organizational emails to promote the entry of the beverage company to as many students as possible. The benefits and advantages of using social networking sites for marketing products vary from one site to another Sethi and Adhikari (2010). Nonetheless, social networking media platforms such as Facebook helps business firms to reach many customers as well as enhancing productivity by relaying information and feedback among different groups of employees as well customers. Online marketing eases the processing buying as people can easily purchase goods and pay through online services. Coca-Cola, Pepsi and Red Bull provide the best examples of beverage firms that use such strategies. Nonetheless, the promotion will go down over different media such as television and radio programs.

Mari Beverage Company Marketing Plan 10

Conclusion

Ideally, Mari Beverage Company has an integral role to play in ensuring that it enters the beverage market and succeeds to sustain the stiff competition predicted by not only the major market controllers but also the pressure exerted by the government and other legal entities. Firms coming into the market as new ventures must take their time to conduct sufficient and in-depth market research before taking such an imperative stage. Additionally, identification of a strongly founded and entirely evidence-based marketing plan is integral in ensuring that there is adequate achievement of the set goals. Lastly, MBC should always operate with a philosophy of minimizing costs and maximizing the output by realization of super-normal profits as well as revenue.

Mari Beverage Company Marketing Plan 11

References

Chattered Quality Institute (CQI). (November, 2011). Model of Sustainable Organization. Sustainable organizations are enduringly successful, yet not all successful organizations will endure or are sustainable: How sustainable is your organization? The MoSO Co-operative Retrieved from: http://www.thecqi.org/Documents/community/Special-Interest- Groups/Deming/MoSO%20brochure.pdf

Czinkota, M. R., & Ronkainen, I. A. (2013). International marketing. Mason, OH, South

Western Cengage Learning.

Doole, I. & Lowe, R. (2012). International Marketing Strategy. London: Cengage Learning. Hana, S. Noor Al-Deen, & John Allen Hendricks. (2013). Social Media and Strategic Communications. Palgrave Macmillan, Basingstoke, GB.

http://www.euromonitor.com/medialibrary/PDF/Coca-Cola-Co_SWOT_Analysis.pdf

Isdell, E. N., & Beasley, D. (2012). Inside Coca-Cola: a CEO's life story of building the world's most popular brand. New York, St. Martin’s Griffin

Sethi, A., & Adhikari, B. (2010). Business communication. New Delhi, Tata McGraw Hill.

Forbes. (2015, 07 01). Top College Rankings. Retrieved 08 05, 2015, from Forbes: http://www.forbes.com/top-colleges/list/#tab:rank

Previous Assignments for reference/Marketing budjet.xlsx

Sheet1

Mari Beverage Company Marketing Budget
The table below describes the budget estimates that will be required to ensure that the Mari Beverage Company Marketing program conducted is a success and meets its primary goal as well as the stipulated objectives.
ITEM	QUANTITY	COST
PERSONNEL	1
Full-time Project Coordinator Including on-costs.		$52,500
EDUCATION & TRAINING
GP workshops	4 @ $450	$1,800
Practice staff workshops Seminar for Marketing and Sales Person professionals	2 @ $ 600	$1,200
Practice sales & marketing workshops	1 @ $1,000	$1,000
	2 @ $550	$1,100
PROJECT RESOURCES
Referral resource	600 @ $1 per card
Design and printing of cards x 500 Production of CD Roms x 50 ‘Guide on Depression in the Elderly’ leaflet
Design and printing of leaflet x 10,000	50 @ $5 per CD	$600
Invitation to Sales and Marketing professionals Seminar Design and printing of invitation x 500		$500
Additional pamphlets. Design and printing of posters x 200		$250
Video Editing and production of video x 100	10,000 @ 35 cents per leaflet	$3,500
	500 @ 50 cents per invitation	$250
		$2,000
		$2,000
		$600
	$2,000	$5,000
	200 @ $3 per poster
	100 @ $500
PROMOTION
Advertising 10 weeks of press advertising in 3 local papers 6 weeks of radio advertising on 3 local stations Media relations	Bulk promotional rates may be available
a) Program launch – costs include venue, catering, AV, ancillary speakers costs, media packs etc. Costs estimated for 40-70 attendees.
b). On-going Social Media campaign
	$ 3, 000	$3,000
	$400
MBC AWARENESS WEEK
Displays Coordination of volunteers	10 volunteers @ $30 each	$300
Skits in Community Centers
	10 volunteers @ 55 each	550
VOLUNTEER NETWORK
Most of the costs will be incurred by sponsor.	$6,000	$6,000
EVALUATION
Formative, process, impact and outcome evaluations	Approx. 10% of total costs
ADMINISTRATION
Office space and associated overheads (lighting, power etc)	Offered by the agency
Stationery, photocopying and printing
Mailing, telephone and fax
Travel	4, 500	4500
Documentation of Program Audit costs	5,500	5,500
	400	400
	700	700
	Offered by the Agency
TOTAL		$93,250

Previous Assignments for reference/week7_DQ.xlsm

WelcomeDemo

	Welcome!
	Thank you for trying out Business Plan Financials from Planning Shop. 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, The Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. Note that this demo copy of Business Plan Financials is deliberately feature-limited. We restrict you to just one product, one capital investment, one loan and 5 capital expenditures. If you purchase the Business Plan Financials, you get access to up to 10 products, 60 capital expenditures, 15 capital investments, and 20 loans. Also, the watermark that appears and prints on each page willbe removed. To use the Business Plan Financials workbook, first go to the Planning Shop tab of the Excel Ribbon.
	Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue 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 in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the Planning Shop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
	Version 2.7 Copyright © 2003-2012 Planning Shop

Warning


	W A R N I N G !
	IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT FUNCTION WITHOUT MACROS ENABLED.
	Excel 2007 for Windows: To enable macros: 1. Click the "Options" button in the Security Warning that appears at the top of this page.
	2. A "Security Alert - Macros & Active X" window should appear. 3. Select the "Enable this content" radio button 4. Click the "OK" button. Your workbook should be ready to use now. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2007 on Windows - Enabling Macros"
	Excel 2010 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
	If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 and Excel 2013 on Windows - Enabling Macros"
	Excel 2013 for Windows: To enable macros: 1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
	If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2010 & Excel 2013 on Windows - Enabling Macros"
	Excel 2010 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use.
	Excel 2008 for Mac: Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version of Business Plan Financials from PlanningShop.
Excel 2007 on Windows - Enabling Macros
		1. From the Windows Ribbon, Select the circular "Windows" button in the upper left. 2. From the drop-down menu that appears, press the Excel Options button in the lower right.
		3. From the "Excel Options" pop-up, select Trust Center on the left side. 4. Select Trust Center Settings…. In the lower right.
		5. In the "Trust Center" pop-up, select "Macro Settings" on the left side. 6. Then, select the Disable all macros except digitally signed macros. (This works because the Planning Shop signs all its workbooks with digital certificates.) 7. Press OK twice.
Excel 2010 and Excel 2013 on Windows - Enabling Macros
		Note: The procedure is exactly the same for Excel 2010 and Excel 2013, even though the Excel 2013 has a slightly different look than these screenshots. 1. In the upper left corner of the Excel Ribbon, press the "File" tab.
		2. Select Options, in the lower left corner.
		3. Select Trust Center from the Lower Left. 4. Click the "Trust Center Settings…" button in the lower right
		5. Select "Macros Settings" from the left side menu 6. Select the "Disable all macros except digitally signed macros" radio button. 7. Click "OK" twice

Your Company Name

ERASE ME WelcomeMac

	Welcome to the Mac Version of Business Plan Financials
	Thank you for purchasing Planning Shop's Business Plan Financials. These worksheets will help you develop clear, compelling financial projections for your business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, The 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: You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIGINAL_PlanningShop_BusinessPlanFinancialsMac(2.7)" file in your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy. You installed the Mac version of the Business Plan Financials product, which does not have the Planning Shop tab available in the Excel Ribbon (unlike the Windows version). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
	Start with the "Setup" worksheet. Enter your data, and then work your way through the workbook, one worksheet at a time, by clicking the next worksheet to the right. There are 23 worksheets/charts in this workbook. The last one (furthest to the right) is "NS5Yr." Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue 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 in-depth help and assistance, refer to the Business Plan Financials Help" PDF file in your PlanningShop folder. The document contains step-by-step instructions and includes a "Frequently Asked Questions" section. To get started, find the Excel worksheet listing (each worksheet is listed on a tab) along the bottom of the Excel window. Click on the "Setup" tab to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business.
	Version 2.7 Copyright © 2003-2012 Planning Shop

Welcome

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

MacVsWindows

	About Our Support of Mac vs. Windows
	PlanningShop supports Business Plan Financials on the following platforms:
	Windows
	1. Microsoft Windows 8 with Microsoft Excel 2013
	2. Microsoft Windows 7 with Microsoft Excel 2010						.�
	3. Microsoft Windows 7 with Microsoft Excel 2007
	4. Microsoft Windows Vista with Microsoft Excel 2007
	Mac
	5. Mac OS X Lion (10.7) with Microsoft Excel 2011
	If you use Windows (#1 - #3 above), then you need to install PlanningShop_BizPlanFin(2.8).exe.
	If you use Mac (#4 above), you need to install PlanningShop_BizPlanFinMac(2.8).dmg
	Differences between Mac and Windows
	Both the Mac and Windows versions of PlanningShop's Business Plan Financials product will produce high quality, detailed financial information for your business plan. However, there are some slight differences between the functionality in Mac and Windows. These differences don't affect the data in your business plan, but they do affect the user-friendliness of the Business Plan Financials workbook. We did our very best to make the Windows and Mac versions as similar as possible. However, Microsoft does not support customization of the Excel toolbar on Mac. Therefore, while we made every effort to preserve as much functionality as possible on the Mac, there were a few things we were not able to do:
	1) There is no PlanningShop Toolbar in the Business Plan Financials for Mac. Instead, you will need to navigate between worksheets and charts using the Excel worksheet tabs (along the bottom edge of the workbook).
	2) Business Plan Financials Help is not available directly from Excel. Instead, you should open the BizPlanFin_Help(2.7).PDF file that was copied to your Mac alongside the PlanningShop_BizPlanFinMac(2.8).XLS or PlanningShop_BizPlanFinMac(2.8).XLSM file.
	We are as disappointed as you are that we can't provide the same level of functionality in Mac as we do for Windows. We very much hope that Microsoft will remedy the situation in the next release of Excel for Mac, and that we'll then be able to offer identical functionality.
	Moving your Business Plan Financials workbook between Mac and Windows
	We advise you to completely edit your Business Plan Financials workbook on either Mac or Windows, and to not switch between the two platforms. If you switch between platforms, you may find that the Planning Shop toolbar, menus, online help, and macros permanently disappear.

Setup

Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Your Company Name
What month will you officially start your company?		January

What year will you officially start your company?		2013
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major product/service lines. How many major product/service lines do you plan to have for your business?		Ten Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.
	Ten
Most businesses sell at least some of their products/services on credit (e.g., "net 30" as opposed to cash). What percentage of your sales will be made on credit?		25% Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.
For sales you make on credit, what terms will you extend? In other words, how many days will pass from the date of sale to when you expect to be paid?		30 Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter any number of days between 0 and 120.
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)?		$5,000 Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)?		$36 Author: This number should reflect the amount you will spend on ONE PART-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).
With health insurance and other benefits costing more each year, your plan should account for annual increases. How much do you estimate your benefit costs will increase each year?		5.00%
If you plan to increase wages (both salaried & hourly) on an annual basis, how much to you plan to increase them by?		3.50%
Approximately what percentage of each employee's salary or wages do you plan to set aside for payroll taxes?		15.00% Author: If you're not sure what percentage to enter here, leave it at the default (15%).
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of business? This will be the opening balance in your Cash Flow Statements.		$5,000 Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.
At approximately what rate do you expect to be taxed on your net income?		25.00% Author: If you're not sure what percentage to enter here, leave it at the default (25%).
		Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product "lines," and then base your projections on these groups of products instead of each individual product.	If you will use an interest-bearing account for your banking, at what rate will you accrue interest?			1.00% Author: If you're not sure what percentage to enter here, leave it at the default (1.00%).
		Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.	Author: If, for instance, your terms will be "Net 30," put 30 here. You may enter any number of days between 0 and 120.	Author: If you're not sure what percentage to enter here, leave it at the default (15%).	Author: This number should reflect the amount you will spend on ONE FULL-TIME employee--the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).	Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

Setup & Assumptions

SalesProj

Sales Projections Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.			2013													2014													2015						2016					2017
	Assumptions		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Product Line 1 Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.
Unit Volume		50.00% Author: MONTHLY VOLUME GROWTH RATE The Worksheets automatically increase the volume in each month on this line using the rate you enter here. You can also enter each cell's value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.	1000 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.	1500 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.	2250	3375	5063	7594	11391	17086	25629	38443	57665	86498	257493													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		0.00% 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.	$2 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.	$2 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.	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2		$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2		$2	$2	$2	$2			$2	$2	$2	$2		$2
Gross Sales			$2,000	$3,000	$4,500	$6,750	$10,125	$15,188	$22,781	$34,172	$51,258	$76,887	$115,330	$172,995	$514,985	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$24	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	30.00% Author: COMMISSIONED SALES What percentage of this product line's sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?	10.00% Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	$60	$90	$135	$203	$304	$456	$683	$1,025	$1,538	$2,307	$3,460	$5,190	$15,450	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		2.50% 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.	$50.00	$75	$112.50	$168.75	$253.13	$379.69	$569.53	$854.30	$1,281.45	$1,922.17	$2,883.25	$4,324.88	$12,875	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$0.05	$1	$0.00	$0.00	$0.00	$0.00	$0		$0.00	$0.00	$0.00	$0.00	$0	$0.00
Net Sales			$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$72,658	$108,987	$163,480	$486,661	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$23	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		28.00% Author: COST OF GOODS Approximately what percentage of your product's sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product's sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero.	$560.00	$840	$1,260	$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$144,196	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$7	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$1,330	$1,995	$2,993	$4,489	$6,733	$10,100	$15,150	$22,724	$34,086	$51,130	$76,695	$115,042	$342,465	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$16	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 2 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
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	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 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 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	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 3 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
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 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 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	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 4 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 & 2010 for Windows 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
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!	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.	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.	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.	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: COMMISSIONED SALES What percentage of this product line's sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?		Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business.	Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?	Author: RETURNS AND ALLOWANCES A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate--but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales.											0	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 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 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	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 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"
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!	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.	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"		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.	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	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 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 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	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 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"
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!	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"		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.	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.	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!	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.	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.	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!	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.	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.	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!	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 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	$0	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 7
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	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 8
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	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 9
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	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Product Line 10
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	0	0	0	0		0	0	0	0	0	0
Unit Price		2.50%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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 Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Commissions)	50.00%	15.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Returns and Allowances)		3.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Net Sales			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Cost of Goods Sold)		50.00%	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
GROSS PROFIT			$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Totals for All Product Lines
Total Unit Volume			1000	1500	2250	3375	5063	7594	11391	17086	25629	38443	57665	86498	257493	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 Gross Sales			$2,000	$3,000	$4,500	$6,750	$10,125	$15,188	$22,781	$34,172	$51,258	$76,887	$115,330	$172,995	$514,985	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$24	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Total Commissions)			$60	$90	$135	$203	$304	$456	$683	$1,025	$1,538	$2,307	$3,460	$5,190	$15,450	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Total Returns and Allowances)			$50	$75	$113	$169	$253	$380	$570	$854	$1,281	$1,922	$2,883	$4,325	$12,875	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Total Net Sales			$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$72,658	$108,987	$163,480	$486,661	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$23	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
(Total Cost of Goods Sold)			$560	$840	$1,260	$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$144,196	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$7	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
TOTAL GROSS PROFIT			$1,330	$1,995	$2,993	$4,489	$6,733	$10,100	$15,150	$22,724	$34,086	$51,130	$76,695	$115,042	$342,465	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$16	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0

Sales Projections

Inventory

Inventory Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.	2013														2014														2015						2016						2017
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Product Line 1
Cost of Goods Sold	$560 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.	$840	$1,260	$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$144,196		$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$7		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Ingredients	$600 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.	$600	$600	$600	$600	$1,200	$1,200	$1,800	$1,800	$2,700	$2,700	$3,250	$17,650		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Bottles	$3,000	$3,000	$3,000	$3,000	$3,000	$6,000	$6,000	$10,000	$10,000	$15,000	$15,000	$25,000	$102,000		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$3		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Caps	$300	$300	$300	$300	$300	$600	$600	$1,200	$1,200	$1,800	$1,800	$2,500	$11,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
Cartons	$500	$500	$500	$500	$500	$1,000	$1,000	$2,000	$2,000	$3,000	$3,000	$6,000	$20,500		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$4,400 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.)	$4,400	$4,400	$4,400	$4,400	$8,800	$8,800	$15,000	$15,000	$22,500	$22,500	$36,750	$151,350		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$5		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 2 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 3 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 4 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 5 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 6 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 7 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 8 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: This worksheet will help you manage your inventory expenditures. For each product line, enter the dollar amount you will spend each period on inventory. If yours is a service business, you can probably ignore this worksheet.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 9 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Product Line 10 Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"
	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Cost of Goods Sold	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 1	$0 Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"	Author: If you only have less than 10 product lines, you can't delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won't be included in the subtotals at the bottom of this worksheet. On Excel 2011 for Mac: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Format->Rows->Hide On Excel 2007 and 2010 for Windows: 1) Select the rows to hide by click on the row headers along left edge of Excel window 2) Right click to pop up a context menu 3) From the menu, select "Hide"		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0
Items/Parts 2	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 3	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Items/Parts 4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Total Inventory Expense	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
GRAND TOTAL INVENTORY	$4,400	$4,400	$4,400	$4,400	$4,400	$8,800	$8,800	$15,000	$15,000	$22,500	$22,500	$36,750	$151,350		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$5		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0

CapEx

Capital Purchases Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.
Item	Cost	Purchase Date		Years of Service	Salvage Value
							Reminder: All purchases must be on or after your business start date of:
Facilities Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.		Month	Year				December-2008
Item Name (change name here)	$0 Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.	Jan Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	2013 Author: Enter the year you will purchase the item(s).	1 Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	$0 Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Equipment Author: Equipment includes machinery, furniture, vehicles, etc.
Author: This worksheet allows you to track capital expenditures and manage depreciation for those expenditures.	Author: Facilities include, land, buildings, building upgrades, fixtures, etc. NOTE: If you will need more than 10 items in each category on this worksheet, combine items into groups and enter data for the entire group on a single line.	Author: Enter the cost of the item(s) here. This will be used to calculate depreciation, and will be added to your financial statements.	NAB Mixers	$28,500	Jan	2013	5	$5,000
NAB Mixers	$28,500	Jan	2013	5	$5,000
Bottling Machinery	$9,600	Jan	2013	6	$1,500
Bottling Machinery	$9,600	Jan	2013	6	$1,500
Panel Vans	$10,000	Jan	2013	4	$2,000
Panel Vans	$10,000	Jan	2013	4	$2,000
Panel Vans	$10,000	Jan	2013	4	$2,000
Panel Vans	$10,000	Jan	2013	4	$2,000
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Computer Hardware/Software Author: Includes PCs, servers, monitors, printers, scanners, other peripherals, and software applications.
		Author: Enter the month you will purchase the item(s). Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	Apple Macintosh 1	$1,200	Jan	2013	4	$100
Apple Macintosh 2	$1,200	Jan	2013	4	$100
Apple Macintosh 3	$1,200	Jan	2013	4	$100
Graphics Software	$750	Jan	2013	4	$100
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Telecommunications Author: Telecommunications includes phone systems, fax machines, etc.
			Author: Enter the year you will purchase the item(s).	Author: Enter the number of years you will use the item(s) before it wears out, you retire it, or sell it. This number will be used to calculate depreciation in your financial statements using the Straight Line method. NOTE: If you'd rather "expense" the item(s) in the year it is purchased, regardless of how many years you will use it, leave the number set to 1 year, and it will not be depreciated on your financial statements. For information about the tax implications/requirements of depreciation, please consult a competent accountant.	Author: This is the value of the item at the time you stop using it, or the price you might receive for it if you sell it. For example, a $1000 desk might be worth $300 when you sell it after five years of use. You would enter $300 in this cell. If you will not be depreciating the item (the Years of Service column is set to 1 year), you can ignore this.	Mobile 1	$250	Jan	2013	3	$0
Mobile 2	$250	Jan	2013	3	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Item Name (change name here)	$0	Jan	2013	1	$0
Land Author: Land purchases are not depreciable.
Item Name (change name here)	$0	Jan	2013	Land is a non-depreciable asset
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013
Item Name (change name here)	$0	Jan	2013

Capital Purchases

StaffBudj

Staffing Budget Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.	2013													2014													2015					2016					2017
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	TOTAL
Management
# Salaried Employees	3.00 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".	3.00	3.00	3.00	3.00	3.00	3.00	3.00	3.00	3.00	3.00	3.00		3.00	3.00	3.00	3.00	3.00	3.00	3.00	3.00	0.00	0.00	0.00	0.00		0.00 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.00	0.00	0.00		0.00	0.00	0.00	0.00		0.00
Avg Salary per employee	$2,000 Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$2,000	$24,000	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$0	$0	$0	$0	$16,560	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$1,250 Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$1,250	$15,000	$1,313	$1,313	$1,313	$1,313	$1,313	$1,313	$1,313	$1,313	$0	$0	$0	$0	$10,500	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$900	$10,800	$932	$932	$932	$932	$932	$932	$932	$932	$0	$0	$0	$0	$7,452	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$8,150	$97,800	$8,454	$8,454	$8,454	$8,454	$8,454	$8,454	$8,454	$8,454	$0	$0	$0	$0	$67,632	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Administrative/Support
# Salaried Employees	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00		2.00	2.00	2.00	2.00	2.00	2.00	2.00	2.00	0.00	0.00	0.00	0.00		0.00 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.00	0.00	0.00		0.00	0.00	0.00	0.00		0.00
Avg Salary per employee	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$18,000	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$0	$0	$0	$0	$12,420	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$833	$10,000	$875	$875	$875	$875	$875	$875	$875	$875	$0	$0	$0	$0	$7,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400	$466	$466	$466	$466	$466	$466	$466	$466	$0	$0	$0	$0	$3,726	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$4,283	$51,400	$4,446	$4,446	$4,446	$4,446	$4,446	$4,446	$4,446	$4,446	$0	$0	$0	$0	$35,566	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Sales/Marketing
# Salaried Employees	2.00	2.00	2.00	2.00	2.00	2.00	5.00	5.00	5.00	5.00	5.00	5.00		5.00	5.00	5.00	5.00	5.00	5.00	5.00	5.00	0.00	0.00	0.00	0.00		0.00 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: For information about this worksheet, see "Staffing Budget" section and worksheet in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.										Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Avg Salary per employee	$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	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$1,035	$0	$0	$0	$0	$8,280	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$833	$833	$833	$833	$833	$833	$2,083	$2,083	$2,083	$2,083	$2,083	$2,083	$17,500	$2,188	$2,188	$2,188	$2,188	$2,188	$2,188	$2,188	$2,188	$0	$0	$0	$0	$17,500	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$300	$300	$300	$300	$300	$300	$750	$750	$750	$750	$750	$750	$6,300	$776	$776	$776	$776	$776	$776	$776	$776	$0	$0	$0	$0	$6,210	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$3,133	$3,133	$3,133	$3,133	$3,133	$3,133	$7,833	$7,833	$7,833	$7,833	$7,833	$7,833	$65,800	$8,139	$8,139	$8,139	$8,139	$8,139	$8,139	$8,139	$8,139	$0	$0	$0	$0	$65,110	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Operations/Production
# Salaried Employees	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00		1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	0.00	0.00	0.00	0.00		0.00 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.00	0.00	0.00		0.00	0.00	0.00	0.00		0.00
Avg Salary per employee	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$1,500	$18,000	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$1,553	$0	$0	$0	$0	$12,420	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$417	$5,000	$438	$438	$438	$438	$438	$438	$438	$438	$0	$0	$0	$0	$3,500	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$225	$225	$225	$225	$225	$225	$225	$225	$225	$225	$225	$225	$2,700	$233	$233	$233	$233	$233	$233	$233	$233	$0	$0	$0	$0	$1,863	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$2,142	$25,700	$2,223	$2,223	$2,223	$2,223	$2,223	$2,223	$2,223	$2,223	$0	$0	$0	$0	$17,783	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other
# Salaried Employees	1.00	1.00	1.00	1.00	1.00	1.00	4.00	4.00	4.00	4.00	4.00	4.00		4.00	4.00	4.00	4.00	4.00	4.00	4.00	4.00	0.00	0.00	0.00	0.00		0.00 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0.00	0.00	0.00		0.00	0.00	0.00	0.00		0.00
Avg Salary per employee	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$6,000	$518	$518	$518	$518	$518	$518	$518	$518	$0	$0	$0	$0	$4,140	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$417	$417	$417	$417	$417	$417	$1,667	$1,667	$1,667	$1,667	$1,667	$1,667	$12,500	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$1,750	$0	$0	$0	$0	$14,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$75	$75	$75	$75	$75	$75	$300	$300	$300	$300	$300	$300	$2,250	$311	$311	$311	$311	$311	$311	$311	$311	$0	$0	$0	$0	$2,484	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$992	$992	$992	$992	$992	$992	$3,967	$3,967	$3,967	$3,967	$3,967	$3,967	$2,250	$4,131	$4,131	$4,131	$4,131	$4,131	$4,131	$4,131	$4,131	$0	$0	$0	$0	$33,044	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Part-Time / Hourly Employees
# Part-Time Employees	1	1	1	1	1	1	1	1	1	1	1	1		1	1	1	1	1	1	1	1	0	0	0	0		0 Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Enter the number of full-time employees you expect to have working for you in this category during this month. For part-time employees, enter their information below under "Part-time / Hourly Employees".	Author: Enter the amount you expect to pay each employee in this category this month. The Worksheets will multiply the number of employees (from the line above) with this number to generate your total cost (less benefits and taxes, below).									Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: This value is calculated using the number you entered on the "Setup and Assumptions" worksheet and the number of employees you entered above.								Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	Author: Note that in year two we use quarterly numbers, not monthly numbers--so make sure you enter your numbers accordingly!	0	0	0	0	0	0	0	0
Avg. Hours per Hourly Employee	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0		80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.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.0
Avg Hourly Rate	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00		$10.35	$10.35	$10.35	$10.35	$10.35	$10.35	$10.35	$10.35	$0.00	$0.00	$0.00	$0.00		$0.00	$0.00	$0.00	$0.00		$0.00	$0.00	$0.00	$0.00		$0.00
Calculated Wages Per Hourly Employee	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$9,600	$828	$828	$828	$828	$828	$828	$828	$828	$0	$0	$0	$0	$6,624	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Wages	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$800	$9,600	$828	$828	$828	$828	$828	$828	$828	$828	$0	$0	$0	$0	$6,624	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits (across all employees)	$3	$3	$3	$3	$3	$3	$3	$3	$3	$3	$3	$3	$36	$3	$3	$3	$3	$3	$3	$3	$3	$0	$0	$0	$0	$25	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes (across all employees)	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$120	$1,440	$124	$124	$124	$124	$124	$124	$124	$124	$0	$0	$0	$0	$994	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Costs	$923	$923	$923	$923	$923	$923	$923	$923	$923	$923	$923	$923	$11,076	$955	$955	$955	$955	$955	$955	$955	$955	$0	$0	$0	$0	$7,643	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
TOTAL
# Full Time Employees	9	9	9	9	9	9	15	15	15	15	15	15		15	15	15	15	15	15	15	15	- 0	- 0	- 0	- 0		- 0	- 0	- 0	- 0		- 0	- 0	- 0	- 0		- 0
# Part-Time Employees	1	1	1	1	1	1	1	1	1	1	1	1		1	1	1	1	1	1	1	1	- 0	- 0	- 0	- 0		- 0	- 0	- 0	- 0		- 0	- 0	- 0	- 0		- 0
Salary/Wages	$13,800	$13,800	$13,800	$13,800	$13,800	$13,800	$18,300	$18,300	$18,300	$18,300	$18,300	$18,300	$192,600	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$0	$0	$0	$0	$151,524	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Benefits	$3,753	$3,753	$3,753	$3,753	$3,753	$3,753	$6,253	$6,253	$6,253	$6,253	$6,253	$6,253	$60,036	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$0	$0	$0	$0	$52,525	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll Taxes	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,745	$2,745	$2,745	$2,745	$2,745	$2,745	$28,890	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$0	$0	$0	$0	$22,729	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GRAND TOTAL COSTS	$19,623	$19,623	$19,623	$19,623	$19,623	$19,623	$27,298	$27,298	$27,298	$27,298	$27,298	$27,298	$281,526	$28,347	$28,347	$28,347	$28,347	$28,347	$28,347	$28,347	$28,347	$0	$0	$0	$0	$226,778	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0

Staffing Budget

MktBudj

	For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budget Templates from PlanningShop.
Marketing Budget Author: For information about this worksheet, see Chapter 10, "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies	2013														2014														2015						2016						2017
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
Professional Assistance
Marketing/PR Consultants	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Advertising Agencies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Social Media Specialists	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
SEO Specialist	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Graphic/Web Design	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Brochures/Leaflets/Flyers	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Signs/Billboards	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Merchandising Displays	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Sampling/Premiums	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Media Advertising
Print (newspaper, etc.)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Television and Radio	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
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	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$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 Media	$1,500	$1,425	$1,354	$1,286	$1,222	$1,161	$1,103	$1,048	$995	$945	$898	$853	$13,789		$853	$853	$853	$853	$853	$853	$853	$853	$853	$853	$853	$853	$10,238		$2,560	$2,560	$2,560	$2,560	$10,238		$2,560	$2,560	$2,560	$2,560	$10,238		$10,238
Phone Directories	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Advertising Specialties	$700	$735	$772	$810	$851	$893	$938	$985	$1,034	$1,086	$1,140	$1,197	$11,142		$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$1,197	$14,367		$3,592	$3,592	$3,592	$3,592	$14,367		$3,592	$3,592	$3,592	$3,592	$14,367		$14,367
Direct Mail	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Website
Development/Programming	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Maintenance and Hosting	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Trade Shows
Fees and Setup	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Travel/Shipping	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Exhibits/Signs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Public Relations/Materials	$1,000	$920	$846	$779	$716	$659	$606	$558	$513	$472	$434	$400	$7,904		$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$400	$4,796		$1,199	$1,199	$1,199	$1,199	$4,796		$1,199	$1,199	$1,199	$1,199	$4,796		$4,796
Informal Marketing / Networking
Memberships/Meetings	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$6,000		$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$500	$6,000		$1,500	$1,500	$1,500	$1,500	$6,000		$1,500	$1,500	$1,500	$1,500	$6,000		$6,000
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
Other	$4,000	$1,600	$640	$256	$102	$0	$0	$0	$0	$0	$0	$0	$6,598		$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	$7,700	$5,180	$4,112	$3,631	$3,391	$3,213	$3,147	$3,090	$3,043	$3,003	$2,973	$2,950	$45,434		$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$35,401		$8,850	$8,850	$8,850	$8,850	$35,401		$8,850	$8,850	$8,850	$8,850	$35,401		$35,401

Marketing Budget

ProSvs

Professional Services Author: For information about this worksheet, see Chapter 13, "Management & Organization" in Successful Business Plan: Secrets & Strategies.	2013	2014	2015	2016	2017
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.	$2,000	$2,000	$2,000	$2,000
Accountants	$1,500	$1,500	$1,500	$1,500	$1,500
Management consultants	$0	$0	$0	$0	$0
Industry specialists	$2,000	$2,000	$2,000	$2,000	$2,000
Technology consultants	$0	$0	$0	$0	$0
Other (change title here)	$0	$0	$0	$0	$0
Other (change title here)	$0	$0	$0	$0	$0
Total Costs	$5,500	$5,500	$5,500	$5,500	$5,500
GRAND TOTAL COSTS	$5,500	$5,500	$5,500	$5,500	$5,500

Professional Services Budget

CapInvest

Capital Investments and Loans Author: This worksheet will help you manage loans and investments in your business.
Item	Amount	Date		Loan Period Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Interest Rate
							Reminder: All invesments & loans must be on or after your business start date of:
Equity Capital Investments Author: Equity capital investments can come from a number of sources, including venture capitalists, angel investors, and family members. Generally, these investors are purchasing a percentage of (or shares in) your company. They expect to reap the rewards of your business' success through periodic dividend payments (a share of the profits) and/or when the company is sold.				Sure Product Consulting: Loan period is in NUMBER OF MONTHS	Month	Year		December-2008
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.	Jan Author: Enter the month that you will receive the investment cash. Note: When entering dates on this worksheet, make sure that they don't fall prior to your current startup date (as entered on the Setup worksheet). Doing so will cause "#NUM!" calculation errors on later worksheets. However, you need not change the dates on lines you are not using.	2013 Author: Enter the year you will receive the investment cash.	Capital investments are not paid back on a loan schedule.
Seed Funding from Friends	$20,000	Jan	2013
Myself	$50,000	Jan	2013
Series A PE Funding	$120,000	Apr	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Investment Source Name	$0	Jan	2013
Total Capital Investments	$230,000
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.
Local Bank Loan	$100,000	Jan	2013	60 Author: Enter the term (length) of the loan in MONTHS. For example, if this will be a three year loan, enter 36 here.	3.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Loan Source Name	$0	Jan	2013	12	0.00% Author: Enter the loan's annual interest rate.
Total Loans	$100,000
TOTAL INVESTMENTS AND LOANS	$330,000

Capital Investments and Loans

IncSt

Income Statements Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.	2013													2014													2015					2016					2017
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
INCOME
Gross Sales	$2,000	$3,000	$4,500	$6,750	$10,125	$15,188	$22,781	$34,172	$51,258	$76,887	$115,330	$172,995	$514,985	$2	$2.00	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$24	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Commissions)	$60	$90	$135	$203	$304	$456	$683	$1,025	$1,538	$2,307	$3,460	$5,190	$15,450	$0	$0.06	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Returns and allowances)	$50	$75	$113	$169	$253	$380	$570	$854	$1,281	$1,922	$2,883	$4,325	$12,875	$0	$0.05	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net Sales	$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$72,658	$108,987	$163,480	$486,661	$2	$1.89	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$23	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
(Cost of Goods)	$560	$840	$1,260	$1,890	$2,835	$4,253	$6,379	$9,568	$14,352	$21,528	$32,292	$48,439	$144,196	$1	$0.56	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$7	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GROSS PROFIT	$1,330	$1,995	$2,993	$4,489	$6,733	$10,100	$15,150	$22,724	$34,086	$51,130	$76,695	$115,042	$342,465	$1	$1.33	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$16	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
EXPENSES - General and Administrative
Salaries and wages	$13,800	$13,800	$13,800	$13,800	$13,800	$13,800	$18,300	$18,300	$18,300	$18,300	$18,300	$18,300	$192,600	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$18,941	$0	$0	$0	$0	$151,524	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Employee benefits	$3,753	$3,753	$3,753	$3,753	$3,753	$3,753	$6,253	$6,253	$6,253	$6,253	$6,253	$6,253	$60,036	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$6,566	$0	$0	$0	$0	$52,525	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Payroll taxes	$2,070	$2,070	$2,070	$2,070	$2,070	$2,070	$2,745	$2,745	$2,745	$2,745	$2,745	$2,745	$28,890	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$2,841	$0	$0	$0	$0	$22,729	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Professional services	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$5,500	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$458	$5,500	$1,375	$1,375	$1,375	$1,375	$5,500	$1,375	$1,375	$1,375	$1,375	$5,500	$5,500
Marketing and advertising	$7,700	$5,180	$4,112	$3,631	$3,391	$3,213	$3,147	$3,090	$3,043	$3,003	$2,973	$2,950	$45,434	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$2,950	$35,401	$8,850	$8,850	$8,850	$8,850	$35,401	$8,850	$8,850	$8,850	$8,850	$35,401	$35,401
Rent	$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
Equipment rental	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Maintenance	$75	$75	$75	$75	$75	$75	$100	$100	$100	$100	$100	$100	$1,050	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200	$300	$300	$300	$300	$1,200	$300	$300	$300	$300	$1,200	$1,200
Depreciation	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$21,254	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$1,771	$21,254	$5,314	$5,314	$5,314	$5,314	$21,254	$5,272	$5,272	$5,272	$5,272	$21,088	$12,100
Insurance	$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
Telephone service	$50	$50	$50	$50	$50	$50	$100	$100	$100	$100	$100	$100	$900	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200	$300	$300	$300	$300	$1,200	$300	$300	$300	$300	$1,200	$1,200
Utilities	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$900	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$75	$900	$225	$225	$225	$225	$900	$225	$225	$225	$225	$900	$900
Office supplies	$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
Postage and shipping	$75	$75	$75	$75	$75	$75	$100	$100	$100	$100	$100	$100	$1,050	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200	$300	$300	$300	$300	$1,200	$300	$300	$300	$300	$1,200	$1,200
Travel	$75	$75	$75	$75	$75	$75	$100	$100	$100	$100	$100	$100	$1,050	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$100	$1,200	$300	$300	$300	$300	$1,200	$300	$300	$300	$300	$1,200	$1,200
Entertainment	$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
Interest on loans	$250	$246	$242	$238	$234	$231	$227	$223	$219	$215	$211	$207	$2,743	$203	$199	$195	$191	$187	$183	$179	$175	$171	$167	$163	$159	$2,170	$451	$414	$377	$339	$1,580	$301	$263	$224	$185	$973	$346
Labeling Machinery Lease	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$450	$5,400	$1,350	$1,350	$1,350	$1,350	$5,400	$1,350	$1,350	$1,350	$1,350	$5,400	$5,400
Printers Lease	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$6,600	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$550	$6,600	$1,650	$1,650	$1,650	$1,650	$6,600	$1,650	$1,650	$1,650	$1,650	$6,600	$6,600
TOTAL EXPENSES	$31,453	$28,929	$27,857	$27,372	$27,128	$26,946	$34,676	$34,616	$34,564	$34,521	$34,486	$34,460	$377,007	$35,505	$35,501	$35,497	$35,493	$35,489	$35,485	$35,481	$35,477	$7,125	$7,121	$7,117	$7,113	$312,403	$21,315	$21,278	$21,240	$21,203	$85,035	$21,123	$21,085	$21,046	$21,007	$84,261	$74,647
Net income before taxes	-$30,123	-$26,934	-$24,864	-$22,883	-$20,395	-$16,847	-$19,527	-$11,891	-$477	$16,609	$42,208	$80,582	-$34,541	-$35,503	-$35,499	-$35,495	-$35,491	-$35,487	-$35,483	-$35,479	-$35,475	-$7,124	-$7,120	-$7,116	-$7,112	-$312,387	-$21,315	-$21,278	-$21,240	-$21,203	-$85,035	-$21,123	-$21,085	-$21,046	-$21,007	-$84,261	-$74,647
Provision for taxes on income	$0	$0	$0	$0	$0	$0	$0	$0	$0	$4,152	$10,552	$20,146	$0	$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 PROFIT	-$30,123	-$26,934	-$24,864	-$22,883	-$20,395	-$16,847	-$19,527	-$11,891	-$477	$12,457	$31,656	$60,437	-$34,541	-$35,503	-$35,499	-$35,495	-$35,491	-$35,487	-$35,483	-$35,479	-$35,475	-$7,124	-$7,120	-$7,116	-$7,112	-$312,387	-$21,315	-$21,278	-$21,240	-$21,203	-$85,035	-$21,123	-$21,085	-$21,046	-$21,007	-$84,261	-$74,647

Income Statements

CshFlw

Cash Flow Author: For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.	2013														2014														2015						2016						2017
	January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		January	February	March	April	May	June	July	August	September	October	November	December	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL		1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	TOTAL
CASH RECEIPTS
Income from Sales
Cash Sales	$1,500	$2,250	$3,375	$5,063	$7,594	$11,391	$17,086	$25,629	$38,443	$57,665	$86,498	$129,746	$386,239		$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$18		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Collections	$0	$500	$750	$1,125	$1,688	$2,531	$3,797	$5,695	$8,543	$12,814	$19,222	$28,833	$85,498		$43,249	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$1	$43,254		$1	$0	$0	$0	$1		$0	$0	$0	$0	$0		$0
Total Cash from Sales	$1,500	$2,750	$4,125	$6,188	$9,281	$13,922	$20,883	$31,324	$46,986	$70,479	$105,719	$158,579	$471,737		$43,250	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$43,272		$1	$0	$0	$0	$1		$0	$0	$0	$0	$0		$0
Income from Financing
Interest Income	$0 Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.	$24	$1	$0	$61	$42	$22	$6	$1	$9	$45	$93	$304		$83	$37	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$120		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Loan Proceeds	$100,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$100,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	$110,000	$0	$0	$120,000	$0	$0	$0	$0	$0	$0	$0	$0	$230,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
Total Cash from Financing	$210,000	$24	$1	$120,000	$61	$42	$22	$6	$1	$9	$45	$93	$330,304		$83	$37	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$120		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Other Cash Receipts	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
TOTAL CASH RECEIPTS	$211,500	$2,774	$4,126	$126,188	$9,342	$13,964	$20,905	$31,330	$46,988	$70,489	$105,764	$158,672	$802,040		$43,333	$39	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2	$43,392		$1	$0	$0	$0	$1		$0	$0	$0	$0	$0		$0
CASH DISBURSEMENTS
Inventory	$4,400	$4,400	$4,400	$4,400	$4,400	$8,800	$8,800	$15,000	$15,000	$22,500	$22,500	$36,750	$151,350		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$5		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Operating Expenses	$29,431	$26,911	$25,843	$25,362	$25,123	$24,944	$32,678	$32,622	$32,574	$32,535	$32,504	$32,481	$353,010		$33,531	$33,531	$33,531	$33,531	$33,531	$33,531	$33,531	$33,531	$5,183	$5,183	$5,183	$5,183	$288,979		$15,550	$15,550	$15,550	$15,550	$62,201		$15,550	$15,550	$15,550	$15,550	$62,201		$62,201
Commissions/Returns & Allowances	$110	$165	$248	$371	$557	$835	$1,253	$1,879	$2,819	$4,229	$6,343	$9,515	$28,324		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$1		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Capital Purchases	$121,050	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$121,050		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Loan Payments	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$21,562		$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$21,562		$5,391	$5,391	$5,391	$5,391	$21,562		$5,391	$5,391	$5,391	$5,391	$21,562		$21,562
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.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Investor Dividend Payments	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0	$0	$0	$0	$0		$0
Owner's Draw	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$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	$240,000		$60,000	$60,000	$60,000	$60,000	$240,000		$60,000	$60,000	$60,000	$60,000	$240,000		$240,000
TOTAL CASH DISBURSEMENTS	$156,788	$33,273	$32,288	$31,931	$31,876	$36,377	$44,528	$51,298	$52,190	$61,060	$63,144	$100,543	$695,296		$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$26,981	$26,981	$26,981	$26,981	$550,548		$80,941	$80,941	$80,941	$80,941	$323,763		$80,941	$80,941	$80,941	$80,941	$323,763		$323,763
NET CASH FLOW	$54,712	-$30,499	-$28,162	$94,257	-$22,535	-$22,413	-$23,623	-$19,968	-$5,202	$9,428	$42,620	$58,129	$106,744		-$11,995	-$55,289	-$55,326	-$55,326	-$55,326	-$55,326	-$55,326	-$55,326	-$26,979	-$26,979	-$26,979	-$26,979	-$507,155		-$80,940	-$80,941	-$80,941	-$80,941	-$323,763		-$80,941	-$80,941	-$80,941	-$80,941	-$323,763		-$323,763
Opening Cash Balance	$5,000	$59,712	$29,213	$1,051	$95,308	$72,774	$50,361	$26,737	$6,769	$1,567	$10,995	$53,615			$111,744	$99,749	$44,460	-$10,866	-$66,192	-$121,518	-$176,844	-$232,170	-$287,496	-$314,475	-$341,454	-$368,432			-$395,411	-$476,352	-$557,292	-$638,233			-$719,174	-$800,115	-$881,056	-$961,997			-$1,042,937
Cash Receipts	$211,500	$2,774	$4,126	$126,188	$9,342	$13,964	$20,905	$31,330	$46,988	$70,489	$105,764	$158,672			$43,333	$39	$2	$2	$2	$2	$2	$2	$2	$2	$2	$2			$1	$0	$0	$0			$0	$0	$0	$0			$0
Cash Disbursements	$156,788	$33,273	$32,288	$31,931	$31,876	$36,377	$44,528	$51,298	$52,190	$61,060	$63,144	$100,543			$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$55,328	$26,981	$26,981	$26,981	$26,981			$80,941	$80,941	$80,941	$80,941			$80,941	$80,941	$80,941	$80,941			$323,763
ENDING CASH BALANCE	$59,712	$29,213	$1,051	$95,308	$72,774	$50,361	$26,737	$6,769	$1,567	$10,995	$53,615	$111,744	$111,744		$99,749	$44,460	-$10,866	-$66,192	-$121,518	-$176,844	-$232,170	-$287,496	-$314,475	-$341,454	-$368,432	-$395,411	-$395,411		-$476,352	-$557,292	-$638,233	-$719,174	-$719,174		-$800,115	-$881,056	-$961,997	-$1,042,937	-$1,042,937		-$1,366,701

Cash Flow Statements

BalSht

Balance Sheet Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet				Balance Sheet
Your Company Name				Your Company Name				Your Company Name				Your Company Name				Your Company Name				Your Company Name				Your Company Name				Your Company Name
First Quarter				Second Quarter				Third Quarter				Fourth Quarter				2014				2015				2016				2017
2013				2013				2013				2013
ASSETS				ASSETS				ASSETS				ASSETS				ASSETS				ASSETS				ASSETS				ASSETS
Current Assets				Current Assets				Current Assets				Current Assets				Current Assets				Current Assets				Current Assets				Current Assets
Cash	$1,051			Cash	$50,361			Cash	$1,567			Cash	$111,744			Cash	-$395,411			Cash	-$719,174			Cash	-$1,042,937			Cash	-$1,366,701
Accounts Receivable	$1,125			Accounts Receivable	$3,797			Accounts Receivable	$12,814			Accounts Receivable	$43,249			Accounts Receivable	$1			Accounts Receivable	$0			Accounts Receivable	$0			Accounts Receivable	$0
Inventory	$10,540			Inventory	$19,163			Inventory	$27,663			Inventory	$7,154			Inventory	$7,152			Inventory	$7,152			Inventory	$7,152			Inventory	$7,152
Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0			Other Current Assets	$0
Total Current Assets		$12,716		Total Current Assets		$73,320		Total Current Assets		$42,045		Total Current Assets		$162,147		Total Current Assets		-$388,258		Total Current Assets		-$712,022		Total Current Assets		-$1,035,785		Total Current Assets		-$1,359,548
Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets				Fixed Assets
Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0			Land	$0
Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0			Facilities	$0
Equipment	$116,200			Equipment	$116,200			Equipment	$116,200			Equipment	$116,200			Equipment	$116,200			Equipment	$116,200			Equipment	$116,200			Equipment	$116,200
Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850			Computers & Telecommunications	$4,850
(Less Accumlated Depreciation)	$5,314			(Less Accumlated Depreciation)	$10,627			(Less Accumlated Depreciation)	$15,941			(Less Accumlated Depreciation)	$21,254			(Less Accumlated Depreciation)	$42,508			(Less Accumlated Depreciation)	$63,763			(Less Accumlated Depreciation)	$84,850			(Less Accumlated Depreciation)	$96,950
Total Fixed Assets		$115,736		Total Fixed Assets		$110,423		Total Fixed Assets		$105,109		Total Fixed Assets		$99,796		Total Fixed Assets		$78,542		Total Fixed Assets		$57,288		Total Fixed Assets		$36,200		Total Fixed Assets		$24,100
Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0		Other Assets		$0
TOTAL ASSETS			$128,453	TOTAL ASSETS			$183,743	TOTAL ASSETS			$147,154	TOTAL ASSETS			$261,943	TOTAL ASSETS			-$309,717	TOTAL ASSETS			-$654,734	TOTAL ASSETS			-$999,585	TOTAL ASSETS			-$1,335,448
LIABILITIES				LIABILITIES				LIABILITIES				LIABILITIES				LIABILITIES				LIABILITIES				LIABILITIES				LIABILITIES
Current Liabilities				Current Liabilities				Current Liabilities				Current Liabilities				Current Liabilities				Current Liabilities				Current Liabilities				Current Liabilities
Short-Term Notes Payable	$18,961 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year			Short-Term Notes Payable	$19,104			Short-Term Notes Payable	$19,248			Short-Term Notes Payable	$19,392			Short-Term Notes Payable	$19,982			Short-Term Notes Payable	$20,590			Short-Term Notes Payable	$21,216			Short-Term Notes Payable	$0
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).			Income Taxes Due	$0			Income Taxes Due	$0			Income Taxes Due	$0			Income Taxes Due	$0			Income Taxes Due	$0			Income Taxes Due	$0			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			Other Current Liabilities	$0
Total Current Liabilities		$18,961		Total Current Liabilities		$19,104		Total Current Liabilities		$19,248		Total Current Liabilities		$19,392		Total Current Liabilities		$19,982		Total Current Liabilities		$20,590		Total Current Liabilities		$21,216		Total Current Liabilities		$0
Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities				Long-Term Liabilities
Long-Term Notes Payable	$76,386			Long-Term Notes Payable	$71,557			Long-Term Notes Payable	$66,691			Long-Term Notes Payable	$61,788			Long-Term Notes Payable	$41,806			Long-Term Notes Payable	$21,216			Long-Term Notes Payable	-$0			Long-Term Notes Payable	-$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			Other Long-Term Liabilities	$0
Total Long-Term Liabilities		$76,386		Total Long-Term Liabilities		$71,557		Total Long-Term Liabilities		$66,691		Total Long-Term Liabilities		$61,788		Total Long-Term Liabilities		$41,806		Total Long-Term Liabilities		$21,216		Total Long-Term Liabilities		-$0		Total Long-Term Liabilities		-$0
NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH				NET WORTH
Paid-In Capital	$115,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000			Paid-In Capital	$235,000
Retained Earnings	-$81,895			Retained Earnings	-$141,918			Retained Earnings	-$173,784			Retained Earnings	-$54,238			Retained Earnings	-$606,505			Retained Earnings	-$931,540			Retained Earnings	-$1,255,801			Retained Earnings	-$1,570,448
Total Net Worth		$33,105		Total Net Worth		$93,082		Total Net Worth		$61,216		Total Net Worth		$180,762		Total Net Worth		-$371,505		Total Net Worth		-$696,540		Total Net Worth		-$1,020,801		Total Net Worth		-$1,335,448
TOTAL LIABILITIES AND NET WORTH			$128,453	TOTAL LIABILITIES AND NET WORTH			$183,743	TOTAL LIABILITIES AND NET WORTH			$147,154	TOTAL LIABILITIES AND NET WORTH			$261,943	TOTAL LIABILITIES AND NET WORTH			-$309,717	TOTAL LIABILITIES AND NET WORTH			-$654,734	TOTAL LIABILITIES AND NET WORTH			-$999,585	TOTAL LIABILITIES AND NET WORTH			-$1,335,448

Balance Sheet

BrkEvn

	Break-even Estimates Author: For information about this worksheet, see "Break-Even Analysis" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies. Note that this Worksheet differs from that shown in the book slightly by also factoring the costs of sales commissions and returns/allowances. This gives you a more accurate break-even estimate.
	Year 1 (2013-2014)
	January	$47,297 Author: This is the amount of sales you will need to make each month to break even.
	February	$43,502
	March	$41,890
	April	$41,161
	May	$40,795
	June	$40,521
	July	$52,145
	August	$52,053
	September	$51,976
	October	$51,911
	November	$51,859
	December	$51,819
	Monthly Average	$47,244
	Year 2 (2014-2015)
	January	$53,391
	February	$53,385
	March	$53,379
	April	$53,373
	May	$53,367
	June	$53,361
	July	$53,354
	August	$53,348
	September	$10,715
	October	$10,709
	November	$10,703
	December	$10,696
	Monthly Average	$39,148
	Year 3 (2015-2016)
	1st Quarter	$0
	2nd Quarter	$0
	3rd Quarter	$0
	4th Quarter	$0
	Quarterly Average	$0
	Year 4 (2016-2017)
	1st Quarter	$0
	2nd Quarter	$0
	3rd Quarter	$0
	4th Quarter	$0
	Quarterly Average	$0
	Year 5 (2017-2018)
	Annual Average	$0

Break-even Estimates

Ratios

Key Ratios Author: This sheet provides a mathematical snapshot of your company's performance. These ratios are often used by lenders or investors in determining how well a company is managing its finances.
Year 1 (2013-2014)	Working Capital Author: Working Capital is the amount of readily available funds the company has to cover upcoming expenses. More is better!	Current Ratio Author: This ratio divides your current assets by your current liabilities. In general, it should be greater than 2. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.	Quick Ratio Author: Similar to the Current Ratio, but we've subtracted inventory from your assets. A number greater than 1 is desirable. If an "N.A." appears in the cell, it indicates that you had no liabilities with which to calculate the ratio.	Cash Turnover Author: This ratio divides your net sales for the period by your "working capital," (your current assets minus your current liabilities). In other words, it shows by what multiple your sales exceed your working capital. In general, 5 or above is good to aim for, but this can vary based on your industry, etc.	Debt to Equity Author: To calculate your Debt to Equity ratio, we divided your total liabilities by your net worth. A high number (greater than 1), indicates a high debt load relative to your assets. Potential funders may be wary of investing in such a case.	Return on Investment Author: This ratio is achieved by dividing your net worth into your net income for the period. It shows the rate of return you and your investors are receiving on your investments in the company. The higher the better!	Return on Sales Author: This ratio is calculated by dividing your net income for the period by your net sales for the period. The higher the number here, the more profit you are extracting from each sale. Your ideal number will depend greatly on your industry, margins, etc.	Return on Assets Author: Your Return on Assets indicates how much profit you are generating on all the investments you've made in the company's assets. In particular, this will help you (and your investors) determine if you are achieving a good rate-of-return on your investments. This will depend greatly on your industry.	Net Sales
1st Quarter	-$6,245	0.67	0.11	-1.44	2.88	-247%	-913%	-64%	$8,977.50
2nd Quarter	$54,216	3.84	2.83	0.56	0.97	-65%	-198%	-33%	$30,299.06
3rd Quarter	$22,797	2.18	0.75	4.49	1.40	-52%	-31%	-22%	$102,259.34
4th Quarter	$142,755	8.36	7.99	2.42	0.45	77%	40%	53%	$345,125.26
Year 2 (2014-2015)	-$408,240	-19.43	-19.79	-0.00	-0.17	84%	-1377368%	101%	$22.68
Year 3 (2015-2016)	-$732,611	-34.58	-34.93	0.00	-0.06	12%	N.A.	13%	$0.00
Year 4 (2016-2017)	-$1,057,001	-48.82	-49.16	0.00	-0.02	8%	N.A.	8%	$0.00
Year 5 (2017-2018)	-$1,359,548	N.A.	N.A.	0.00	0.00	6%	N.A.	6%	$0.00

Key Ratios

1YrAtGl

Year 1: Financials at-a-Glance (2013-2014) Gross Sales January February March April May June July August September October November December 2000 3000 4500 6750 10125 15187.5 22781.25 34171.875 51257.8125 76886.71875 115330.078125 172995.1171875 Gross Profit January February March April May June July August September October November December 1330 1995 2992.5 4488.75 6733.125 10099.6875 15149.53125 22724.296875 34086.4453125 51129.66796875 76694.501953125 115041.7529296875 Net Profit January February March April May June July August September October November December -30122.513888888887 -26933.646716222873 -24864.16987562519 -22883.221342926015 -20395.268803895091 -16846.543627441592 -19526.693885332963 -11891.265771836239 -477.42746594901109 12456.632616176232 31656.283244326947 60436.678963062288

NSYr1

Year 1: Net Sales (2013-2014) Product Line 1 January February March April May June July August September October November December 1890 2835 4252.5 6378.75 9568.125 14352.1875 21528.28125 32292.421875 48438.6328125 72657.94921875 108986.923828125 163480.3857421875 Product Line 2 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 3 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 4 January February March April May June July August September October November December 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 5 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 6 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 7 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 8 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 9 0 0 0 0 0 0 0 0 0 0 0 0 Product Line 10 0 0 0 0 0 0 0 0 0 0 0 0

1YrCshFlw

Year 1: Cash Flow (2013-2014) Net Cash Flow January February March April May June July August September October November December 54711.797600260354 -30498.878570405908 -28161.727135881243 94256.959600260321 -22534.640011919262 -22412.857654973533 -23623.155739298782 -19968.12316724944 -5202.3174991066553 9428.2101211595 42619.803506997952 58128.890942807368 Ending Cash Balance 59711.797600260354 29212.919029854442 1051.191893973195 95308.15149423352 72773.511482314265 50360.653827340728 26737.498088041953 6769.3749207925139 1567.0574216858586 10995.267542845366 53615.071049843318 111743.9619926507

2ndYrCshFlw

Year 2: Cash Flow (2014-2015) Net Cash Flow January February March April May June July August September October November December -11994.702867366701 -55289.017982711906 -55326.03733420447 -55326.03733420447 -55326.03733420447 -55326.03733420447 -55326.03733420447 -55326.03733420447 -26978.812334204467 -26978.812334204467 -26978.812334204467 -26978.812334204467 Ending Cash Balance January February March April May June July August September October November December 99749.259125283977 44460.241142572071 -10865.796191632398 -66191.833525836875 -121517.87086004135 -176843.90819424583 -232169.94552845031 -287495.98286265478 -314474.79519685922 -341453.60753106367 -368432.41986526811 -395411.23219947255

5YrAtGl

5-Year Financials at-a-Glance

Gross Sales 2013 2014 2015 2016 2017 514985.3515625 24 0 0 0 Gross Profit 2013 2014 2015 2016 2017 342465.2587890625 15.959999999999997 0 0 0 Net Profit 2013 2014 2015 2016 2017 -34541.291613363952 -312387.112856569 -85035.439824850371 -84260.999790386137 -74647.24041402046

NS5Yr

5-Year Net Sales

Product Line 1 2013 2014 2015 2016 2017 486661.1572265625 22.680000000000003 0 0 0 Product Line 2 2013 2014 2015 2016 2017 0 0 0 0 0 Product Line 3 2013 2014 2015 2016 2017 0 0 0 0 0 Product Line 4 2013 2014 2015 2016 2017 0 0 0 0 0 Product Line 5 0 0 0 0 0 Product Line 6 0 0 0 0 0 Product Line 7 0 0 0 0 0 Product Line 8 0 0 0 0 0 Product Line 9 0 0 0 0 0 Product Line 10 0 0 0 0 0

About

	About Business Plan Financials
	PlanningShop
	Business Plan Financials
	Version 2.8
	SUBJECT TO END-USER LICENSE AGREEMENT
	Copyright 2003-2014 PlanningShop. All rights reserved.
	www.planningshop.com

http://www.planningshop.com/

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.

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

Jan

Plan Years:
Sure Product Consulting: Plan Years is used in drop-downs for purchase and loan dates on CapInvest and CapEx worksheets.

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

Feb

2013

Version:

Startup Month

Mar

2014

2.8

January

Apr

2015

7/21/09

Startup Month Abbrev

May

2016

Jan

Jun

2017

Start Date:

Jul

2018

O/S Type

Dec-08

Aug

Windows

Sep

Oct

Nov

Dec

CREDIT MULTIPLIER

Number of Products

Multiple

With "Credit Sales"

One

0.00

Two

1.00

0.25

Three

Four

Five

Six

Working Capital Calc
Sure Product Consulting: Used by Ratios worksheet

Sure Product Consulting: Plan Years is used in drop-downs for purchase and loan dates on CapInvest and CapEx worksheets.

Seven

-$6,245

Eight

$54,216

Nine

$22,797

Ten

$142,755

-$408,240

-$732,611

-$1,057,001

-$1,359,548

Chart Titles

Year 1 String

2013-2014

Year 1: Financials at-a-Glance (2013-2014)

Year 2 String

2014-2015

Year 1: Net Sales (2013-2014)

Year 3 String

2015-2016

Year 1: Cash Flow (2013-2014)

Year 4 String

2016-2017

Year 2: Cash Flow (2014-2015)

Year 5 String

2017-2018

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

Adjust index to 1-12

Abbrev

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

To-Do List

Changing this changes ALL months on CapEX and CapInvest to new value, even ieach row's purchase date istill remains in the future. This is the same behavior as in 2.5, but might want to correct it.

Changing the Year Titles on SaleProj and all other worksheets, for fiscal years that straddle two calendar years (example: Year 1: 2012-2013

Making a "Demo" version of this workbook, with watermark, 1 loan, 1 product line, 1 investment

Adding a Worksheet to do revolving credit calculations. See http://www.vertex42.com/Files/download/line-of-credit.html for a cool line of credit worksheet (it's complicated)

Cleaning up all the dates, lists of months, etc. on the config worksheet

Adding "Reset_XXX" subroutines for ALL the worksheets

Check PrintAreas, footers, headers for New DepnSchedule and New LoanPaymentSchedule

Your Company Name

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

DepnSchedule

Sure Product Consulting: Is this depreciation schedule correct? If only one year of service, nothing is depreciated. If more than one year, we don't depreciate anything for year 1 it seems (or does that show up as an expense?)	Depreciation Schedule from CapEx Worksheet
														Dec-08	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	Jan-10	Feb-10	Mar-10	Apr-10	May-10	Jun-10	Jul-10	Aug-10	Sep-10	Oct-10	Nov-10	Dec-10	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13
Item#	Category	Item Name	Purch Value	Salvage Value	Yrs of Service	Mos of Service	Month Purchased	Year Purchased	Purchase Month	End Month	End Date	Depn Amt montly		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	- Sure Product Consulting: If "today's" month is one in this asset is dep'd over,	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Facilities	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Equip	NAB Mixers	$28,500.00	$5,000.00	5	60	Jan	2013	1	60	Nov-13	$ 392		392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392
12	Equip	NAB Mixers	$28,500.00	$5,000.00	5	60	Jan	2013	1	60	Nov-13	$ 392		392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392	392
13	Equip	Bottling Machinery	$9,600.00	$1,500.00	6	72	Jan	2013	1	72	Nov-14	$ 113		113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113
14	Equip	Bottling Machinery	$9,600.00	$1,500.00	6	72	Jan	2013	1	72	Nov-14	$ 113		113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113	113
15	Equip	Panel Vans	$10,000.00	$2,000.00	4	48	Jan	2013	1	48	Nov-12	$ 167		167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	-	-	-	-	-	-	-	-	-	-	-	-
16	Equip	Panel Vans	$10,000.00	$2,000.00	4	48	Jan	2013	1	48	Nov-12	$ 167		167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	-	-	-	-	-	-	-	-	-	-	-	-
17	Equip	Panel Vans	$10,000.00	$2,000.00	4	48	Jan	2013	1	48	Nov-12	$ 167		167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	-	-	-	-	-	-	-	-	-	-	-	-
18	Equip	Panel Vans	$10,000.00	$2,000.00	4	48	Jan	2013	1	48	Nov-12	$ 167		167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	167	-	-	-	-	-	-	-	-	-	-	-	-
19	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
21	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
24	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
26	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
28	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
29	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
30	Equip	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
31	Comp	Apple Macintosh 1	$1,200.00	$100.00	4	48	Jan	2013	1	48	Nov-12	$ 23		23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	-	-	-	-	-	-	-	-	-	-	-	-
32	Comp	Apple Macintosh 2	$1,200.00	$100.00	4	48	Jan	2013	1	48	Nov-12	$ 23		23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	-	-	-	-	-	-	-	-	-	-	-	-
33	Comp	Apple Macintosh 3	$1,200.00	$100.00	4	48	Jan	2013	1	48	Nov-12	$ 23		23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	23	-	-	-	-	-	-	-	-	-	-	-	-
34	Comp	Graphics Software	$750.00	$100.00	4	48	Jan	2013	1	48	Nov-12	$ 14		14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	-	-	-	-	-	-	-	-	-	-	-	-
35	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
36	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
37	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
40	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
41	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
42	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
43	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
45	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
46	Comp	Mobile 1	$250.00	$0.00	3	36	Jan	2013	1	36	Nov-11	$ 7		7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
47	Comp	Mobile 2	$250.00	$0.00	3	36	Jan	2013	1	36	Nov-11	$ 7		7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	7	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
50	Comp	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09	$ - 0		-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
51	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
52	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
53	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
54	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
55	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
56	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
57	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
58	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
59	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
60	Land	Item Name (change name here)	$0.00	$0.00	1	12	Jan	2013	1	12	Nov-09
		TOTAL												$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,771	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,757	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008	$ 1,008
		Land												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Facilities												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Equip												116,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		Comp												4,850	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL Author: This goes into Cash Flow statement.											Author: This goes into Cash Flow statement.	121,050	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
		TOTAL NON-DEPRECIABLE CAPITAL ASSETS Author: This goes into Income statement under "non-depreciable capital purchases"											Author: This goes into Income statement under "non-depreciable capital purchases"	Author: This goes into Cash Flow statement.	Author: This goes into Income statement under "non-depreciable capital purchases"												-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-

Depreciation Schedule

LoanInvestSchedules

	Investment Proceeds									Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds												Investment Proceeds
										Dec-08	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	Jan-10	Feb-10	Mar-10	Apr-10	May-10	Jun-10	Jul-10	Aug-10	Sep-10	Oct-10	Nov-10	Dec-10	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13
Inv #	Name of Invest Source	Amount			Start Month	Start Year	Infusion Month			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60
1	Melinda Cates	$40,000			Jan	2013	1			40,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
2	Seed Funding from Friends	$20,000			Jan	2013	1			20,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
3	Myself	$50,000			Jan	2013	1			50,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
4	Series A PE Funding	$120,000			Apr	2013	4			- 0	- 0	- 0	120,000.00	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
5	Investment Source Name	$0			Jan	2013	1			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
6	Investment Source Name	$0			Jan	2013	1			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
7	Investment Source Name	$0			Jan	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	1			- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
									TOTAL:	$110,000	$0	$0	$120,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
	Loan Payback Schedule (Principle + Interest)									Loan Payback Schedule (Principle + Interest)												Loan Payback Schedule (Principle + Interest)												Loan Payback Schedule (Principle + Interest)												Loan Payback Schedule (Principle + Interest)												Loan Payback Schedule (Principle + Interest)												Loan Payback Schedule (Principle + Interest)
										Dec-08	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	Jan-10	Feb-10	Mar-10	Apr-10	May-10	Jun-10	Jul-10	Aug-10	Sep-10	Oct-10	Nov-10	Dec-10	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13 Sure Product Consulting: Note: We calculate loan payments beyond the end date of this business plan (5 years into future), in order to populate the Balance Sheet properly. Payments due in year 6 need to appear on the Short-Term Notes Payable line of Balance Sheet for Year 5. The remainder of the not-yet-made loan payments appear on Long-Term Notes Payable line of the Year 5 balance sheet.	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14
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	Local Bank Loan	$100,000	3.00%	60	Jan	2013	1	60	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	1,796.87	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
2	Loan Source Name	$0	0.00%	12	Jan	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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:	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$1,797	$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 - Interest Portion of Loan Payments
										Dec-08	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	Jan-10	Feb-10	Mar-10	Apr-10	May-10	Jun-10	Jul-10	Aug-10	Sep-10	Oct-10	Nov-10	Dec-10	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14
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	Local Bank Loan	$100,000.00	$0.03	$60.00	Jan	$2,013.00	$1.00	$60.00	1,796.87	250.00	246.13	242.26	238.37	234.47	230.57	226.65	222.73	218.79	214.85	210.89	206.93	202.95	198.97	194.97	190.97	186.95	182.93	178.89	174.85	170.79	166.73	162.65	158.57	154.47	150.36	146.25	142.12	137.98	133.84	129.68	125.51	121.33	117.14	112.94	108.74	104.51	100.28	96.04	91.79	87.53	83.25	78.97	74.68	70.37	66.05	61.73	57.39	53.04	48.68	44.31	39.93	35.54	31.13	26.72	22.29	17.86	13.41	8.95	4.48	-	-	-	-	-	-	-	-	-	-	-	-
2	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0	0.00%	12	Jan	2013	1	12	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:	$250	$246	$242	$238	$234	$231	$227	$223	$219	$215	$211	$207	$203	$199	$195	$191	$187	$183	$179	$175	$171	$167	$163	$159	$154	$150	$146	$142	$138	$134	$130	$126	$121	$117	$113	$109	$105	$100	$96	$92	$88	$83	$79	$75	$70	$66	$62	$57	$53	$49	$44	$40	$36	$31	$27	$22	$18	$13	$9	$4	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	Loan Proceeds									Loan Proceeds												Loan Proceeds												Loan Proceeds												Loan Proceeds												Loan Proceeds
										Dec-08	Jan-09	Feb-09	Mar-09	Apr-09	May-09	Jun-09	Jul-09	Aug-09	Sep-09	Oct-09	Nov-09	Dec-09	Jan-10	Feb-10	Mar-10	Apr-10	May-10	Jun-10	Jul-10	Aug-10	Sep-10	Oct-10	Nov-10	Dec-10	Jan-11	Feb-11	Mar-11	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12	Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13
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	Local Bank Loan	$100,000			Jan	2013	1			100,000.00	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
2	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
3	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
4	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
5	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
6	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
7	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
8	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
9	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
10	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
11	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
12	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
13	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
14	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
15	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
16	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
17	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
18	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
19	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
20	Loan Source Name	$0			Jan	2013	1			-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
									TOTAL:	$100,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
	Loan Calculations for Balance Sheet									Loan Calculations for Balance Sheet												Loan Calculations for Balance Sheet
										First Quarter			Second Quarter			Third Quarter			Fourth Quarter			Year 2			Year 3			Year 4			Year 5
Loan #	Name of Loan Source	Amount	Rate	Periods	Start Month	Start Year	Begin Pay Month	Amount		Principle Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long	Paid	Due Short	Due Long
1	Local Bank Loan	$100,000.00	3.00%	60	Jan	2013	1	$100,000		$4,652	$18,961 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	$76,386 Sure Product Consulting: "Due Long" is whatever priciple is left: origloan - pricpaid so far - due short. Whatever is due more than 12 months out.	$9,339 Sure Product Consulting: cummulative principle paid: includes previous quarter's payments	$19,104	$71,557	$14,062	$19,248	$66,691	$18,820	$19,392	$61,788	$38,212	$19,982	$41,806	$58,194	$20,590	$21,216	$78,784	$21,216	-$0	$100,000	$0	-$0
2	Loan Source Name	$0.00	0.00%	12	Jan	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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	2013	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:		$18,961	$76,386		$19,104	$71,557		$19,248	$66,691		$19,392	$61,788		$19,982	$41,806		$20,590	$21,216		$21,216	-$0		$0	-$0

Loan & Investment Schedules for Disbursement & Repayment