Phyllis young

Help february

order_35973_only_qualified_1.xls

Home >Business & Finance homework help >Management homework help >Phyllis young

Directions

Last revised 4/23/2014. See revision notes on last tab.

Step 1 - Enter info about your company in yellow shaded boxes below.

Preparer Name

PepsiCO

January

2013

PepsiCO

January

2013

Step 2 - Read the following instructions

January

February

March

April

May

June

July

August

September

October

November

December

&L&9&G&R&G

This Microsoft Excel Workbook is designed to provide those starting a business or already running a business with information that will allow them to make a "go /no-go" decision. It will help a potential entrepreneur project operating profit, develop a projected income statement, balance sheet and cash flow forecast. It is designed for a wide variety of users, from those who have little or no accounting or Excel experience to those who may be well versed in finance, accounting and the use of Microsoft Excel. The workbook contains a number of worksheets, each documented two ways. Extensive directions and guidance for a particular page or on a specific accounting topic are found in blue boxes (like this one) on pages that are not self-explanatory. The second way this workbook is documented is using Excel comments in a given cell. Comments are normally hidden from sight. If you see a red triangle in the upper right corner of a cell, you can hover your mouse over the triangle to see the note. As your mouse moves away from the triangle, the comment will disappear. Comments will have a beige background. Each comment may have a specific direction for that cell, may be a reminder of something the author believes important, or may have some additional information about the accounting topic. The cells and formulas in this workbook are protected. Cells with yellow or light blue backgrounds are designed for user input. All other cells are designed to generate data based on user input. The cells with formulas in this workbook are locked. If changes are needed, the unlock code is "1234." Please use caution when unlocking the spreadsheets. If you want to change a formula, we strongly recommend that you save a copy of this spreadsheet under a different name before doing so.

Color-Coding:

Enter Data Here

Adjust as Needed

Want a guide? Visit our website: score.org/startyourbusiness

Need to make the numbers bigger? Increase the magnification. This will either be located in the lower right-hand corner, or in the Functions bar at the top of the page.

Assumption: Income is expected to accrue evenly throughout the year. Some expenses, will have the same amount thrpugh the year. Inflation is expected to remain constant. The financial statement relate to 1 year period. References. Rothaermel, F. T. (2015). Strategic management. McGraw-Hill. Uechi, L., Akutsu, T., Stanley, H. E., Marcus, A. J., & Kenett, D. Y. (2015). Sector dominance ratio analysis of financial markets. Physica A: Statistical Mechanics and its Applications, 421, 488-509.

1-StartingPoint


Start-up Expenses Year 1 (Starting Balance Sheet)
Prepared By:	Company Name:
Owner	PepsiCO
Fixed Assets	Amount	Depreciation (years)	Notes
Real Estate-Land	4,000	Not Depreciated
Real Estate-Buildings	345	20
Leasehold Improvements	600	7
Equipment	200	7
Furniture and Fixtures	700	5
Vehicles	7,000	5
Other	500	5
Total Fixed Assets	$ 13,345
Operating Capital	Amount	Notes
Pre-Opening Salaries and Wages	300
Prepaid Insurance Premiums	780
Inventory	2,000
Legal and Accounting Fees	760
Rent Deposits	345
Utility Deposits	400
Supplies	500
Advertising and Promotions	150
Licenses	390
Other Initial Start-Up Costs	350
Working Capital (Cash On Hand)	2,500
Total Operating Capital	$ 8,475
Total Required Funds	$ 21,820
Sources of Funding	Percentage	Totals	Loan Rate	Term in Months	Monthly Payments	Notes
Owner's Equity	45.83%	10,000
Outside Investors	13.75%	3,000
Additional Loans or Debt
Commercial Loan	2.20%	480	9.00%	84	8
Commercial Mortgage	0.92%	200	9.00%	240	2		See Loan Amortization & Depreciation Schedule
Credit Card Debt	1.24%	270	7.00%	60	5
Vehicle Loans	13.75%	3,000	6.00%	48	70
Other Bank Debt	22.32%	4,870	5.00%	36	146
Total Sources of Funding	100.00%	$ 21,820	Cell D 42 must equal cell C31		$ 231
Total Funding Needed		$ -	You are fully funded (Balanced)
Existing Businesses ONLY -- Calculating Cash on Hand
Cash	-
+ Accounts Receivable	-
+ Prepaid Expenses	-
- Accounts Payable	-
- Accrued Expenses	-
Total Cash on Hand	$ -

&C&"Gill Sans MT,Regular"&12Start-Up Expenses Year 1 (Starting Balance Sheet)

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

Existing businesses should use the calculator at the bottom of this page to determine the Working Capital amount. Calculate the number, then enter it here.

Years of depreciation must be 3 or more for the calculations in this workbook to work correctly.

Note: For existing businesses, this should be the "bucket" of cash plus receivables that will be turned into cash, minus payables that will be paid out in cash in the near term (i.e. in the first months of the plan)

See Loan Amortization & Depreciation Schedule

2a-PayrollYear1


	Payroll Year 1
	Prepared By:	Company Name:
	Owner	PepsiCO
Employee Types	Number of Owners /Employees	Average Hourly Pay (to 2 decimal places, ex. $15.23)	Estimated Hrs./Week (per person)	Estimated Pay/Month (Total)	January	February	March	April	May	June	July	August	September	October	November	December	Annual Totals
Owner(s)	2	20.40	12	$ 2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	2,122	$ 25,459
Full-Time Employees	4	10.00	6	$ 1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	1,040	$ 12,480
Part-Time Employees	3	5.80	4	$ 302	302	302	302	302	302	302	302	302	302	302	302	302	$ 3,619
Independent Contractors	1	11.00	3	$ 143	143	143	143	143	143	143	143	143	143	143	143	143	$ 1,716
Total Salaries and Wages	10	$ 47.20	25	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 3,606	$ 43,274
Payroll Taxes and Benefits	Wage Base Limit	Percentage of Salary/Wage		Estimated Taxes & Benefits/Month (Total)	January	February	March	April	May	June	July	August	September	October	November	December	Annual Totals
Social Security	$ 110,111	6.20%		$ 215	215	215	215	215	215	215	215	215	215	215	215	215	$ 2,577
Medicare	--	1.45%		$ 50	50	50	50	50	50	50	50	50	50	50	50	50	$ 603
Federal Unemployment Tax (FUTA)	$ 7,000	0.80%		$ 47	47	47	47	47	47	47	47	47	47	47	47	47	$ 560
State Unemployment Tax (SUTA)	$ 7,000	3.45%		$ 201	201	201	201	201	201	201	201	201	201	201	201	201	$ 2,415
Employee Pension Programs	--	0.00%		$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Worker's Compensation	--	0.00%		$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Employee Health Insurance	--	0.00%		$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Other Employee Benefit Programs	--	0.00%		$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Total Payroll Taxes and Benefits		11.90%		$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 513	$ 6,154
Total Salaries and Related Expenses				$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 49,429

&C&"Gill Sans MT,Regular"&12Payroll Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

For these benefits, the formula assumes part-time employees are included. If this is not the case, change the formula accordingly.

These cells have been auto-populated, but can be overwritten if your payroll expenses increase over time. To restore the auto-population, enter this formula in the cell: =F[insert row number]. For example, the first row in this section would use: =F8.

The Wage Base limit is the maximum earned gross income on which a given tax may be imposed. If you are paying a salary above that amount, you'll need to factor that into your calculation. The amounts below are for 2012.

The Federal Unemployment tax rate was 6.2% from January 1, 2011 through June 30, 2011; and decreased to 6.0% as of July 1, 2011. It is currently still set at that rate, less a maximum credit of 5.4% for amounts paid under State unemployment insurance laws. Accordingly, the normal net FUTA tax is 0.6%. This information is as-of November 2012. Check with the IRS for current information.

2b-PayrollYrs1-3


Payroll Years 1-3
Prepared By:	Company Name:
Owner	PepsiCO
Employee Types	Year 1 Totals	Growth Rate 1 to 2	Second Year	Growth Rate 2 to 3	Third Year
Owner(s)	25,459	20.0%	30,551	30.0%	39,716
Full-Time Employees	12,480	20.0%	14,976	30.0%	19,469
Part-Time Employees	3,619	10.0%	3,981	30.0%	5,175
Independent Contractors	1,716	3.0%	1,767	3.0%	1,821
Total Salaries and Wages	$ 43,274		$ 51,276		$ 66,181
Payroll Taxes and Benefits
Social Security	2,577	20.0%	3,092	30.0%	4,020
Medicare	603	20.0%	723	30.0%	940
Federal Unemployment Tax (FUTA)	560	20.0%	672	30.0%	874
State Unemployment Tax (SUTA)	2,415	20.0%	2,898	30.0%	3,767
Employee Pension Programs	-	0.0%	-	0.0%	-
Worker's Compensation	-	3.0%	-	3.0%	-
Employee Health Insurance	-	3.0%	-	3.0%	-
Other Employee Benefit Programs	-	10.0%	-	10.0%	-
Total Payroll Taxes and Benefits	$ 6,154		$ 7,385		$ 9,601
Total Salaries and Related Expenses	$ 49,429		$ 58,661		$ 75,782

&C&"Gill Sans MT,Regular"&12Payroll Years 1-3

&L&F&C&A&R&D &T

3a-SalesForecastYear1


Sales Forecast Year 1
Prepared By:	Company Name:
Owner	PepsiCO
Complete This Chart First:
Product Lines	Units	Sales Price Per Unit	COGS Per Unit	Margin Per Unit
Pepsi	1573	$ 2.00		$ 2.00
Lays	400	$ 4.00		$ 4.00
Tropicana	570	$ 3.00		$ 3.00
Aquafina	300	$ 4.00		$ 4.00
Brisk	360	$ 3.00		$ 3.00
Ruffles	300	$ 2.50		$ 2.50
Product Lines	January	February	March	April	May	June	July	August	September	October	November	December	Annual Totals	Category Breakdown	Category / Total
Pepsi
1573 Sold	20	50	40	40	90	50	100	103	130	200	250	500	1,573		44.9%
Total Sales	40	100	80	80	180	100	200	206	260	400	500	1,000	$ 3,146	100.0%	33.2%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Total Margin	40	100	80	80	180	100	200	206	260	400	500	1,000	$ 3,146	100.0%	33.2%
Lays
400 Sold	30	30	30	30	30	30	30	40	30	30	30	60	400		11.4%
Total Sales	120	120	120	120	120	120	120	160	120	120	120	240	$ 1,600	100.0%	16.9%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	120	120	120	120	120	120	120	160	120	120	120	240	$ 1,600	100.0%	16.9%
Tropicana
570 Sold	47	47	47	47	47	47	47	47	47	47	47	53	570		16.3%
Total Sales	141	141	141	141	141	141	141	141	141	141	141	159	$ 1,710	100.0%	18.0%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	141	141	141	141	141	141	141	141	141	141	141	159	$ 1,710	100.0%	18.0%
Aquafina
300 Sold	25	25	25	25	25	25	25	25	25	25	25	25	300		8.6%
Total Sales	100	100	100	100	100	100	100	100	100	100	100	100	$ 1,200	100.0%	12.7%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	100	100	100	100	100	100	100	100	100	100	100	100	$ 1,200	100.0%	12.7%
Brisk
360 Sold	30	30	30	30	30	30	30	30	30	30	30	30	360		10.3%
Total Sales	90	90	90	90	90	90	90	90	90	90	90	90	$ 1,080	100.0%	11.4%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	90	90	90	90	90	90	90	90	90	90	90	90	$ 1,080	100.0%	11.4%
Ruffles
300 Sold	25	25	25	25	25	25	25	25	25	25	25	25	300		8.6%
Total Sales	63	63	63	63	63	63	63	63	63	63	63	63	$ 750	100.0%	7.9%
Total COGS	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	63	63	63	63	63	63	63	63	63	63	63	63	$ 750	100.0%	7.9%
Total Units Sold	177	207	197	197	247	207	257	270	287	357	407	693	3,503
Total Sales	$ 554	$ 614	$ 594	$ 594	$ 694	$ 614	$ 714	$ 760	$ 774	$ 914	$ 1,014	$ 1,652	$ 9,486
Total Cost of Goods Sold	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Total Margin	$ 554	$ 614	$ 594	$ 594	$ 694	$ 614	$ 714	$ 760	$ 774	$ 914	$ 1,014	$ 1,652	$ 9,486

&C&"Gill Sans MT,Regular"&12Sales Forecst Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

TIP: Click here to access a calculator that can help you determine your COGS per unit.

TIP: Enter these in the plural form! Ex. projects, dresses, bikes, etc.

COGS Per Unit

3b-SalesForecastYrs1-3


	Sales Forecast Year 1-3
	Prepared by:	Company Name:
	Owner	PepsiCO
	Growth Rate Year 1 to Year 2:	10.00%
	Growth Rate Year 2 to Year 3:	10.00%
Product Lines	Year 1 Totals	January	February	March	April	May	June	July	August	September	October	November	December	Year 2 Totals	Category Breakdown	Category / Total	January	February	March	April	May	June	July	August	September	October	November	December	Year 3 Totals	Category Breakdown	Category / Total
Pepsi
1573 Sold	1573	22	55	44	44	99	55	110	113	143	220	275	550	1,730		0.0%	24	61	48	48	109	61	121	125	157	242	303	605	1,903		0.0%
Total Sales	$ 3,146	44	110	88	88	198	110	220	227	286	440	550	1,100	$ 3,461	100.0%	0.0%	48	121	97	97	218	121	242	249	315	484	605	1,210	$ 3,807	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Total Margin	$ 3,146	44	110	88	88	198	110	220	227	286	440	550	1,100	$ 3,461	100.0%	0.0%	48	121	97	97	218	121	242	249	315	484	605	1,210	$ 3,807	100.0%	0.0%
Lays
400 Sold	400	33	33	33	33	33	33	33	44	33	33	33	66	440		0.0%	36	36	36	36	36	36	36	48	36	36	36	73	484		0.0%
Total Sales	$ 1,600	132	132	132	132	132	132	132	176	132	132	132	264	$ 1,760	100.0%	0.0%	145	145	145	145	145	145	145	194	145	145	145	290	$ 1,936	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	$ 1,600	132	132	132	132	132	132	132	176	132	132	132	264	$ 1,760	100.0%	0.0%	145	145	145	145	145	145	145	194	145	145	145	290	$ 1,936	100.0%	0.0%
Tropicana
570 Sold	570	52	52	52	52	52	52	52	52	52	52	52	58	627		0.0%	57	57	57	57	57	57	57	57	57	57	57	64	690		0.0%
Total Sales	$ 1,710	155	155	155	155	155	155	155	155	155	155	155	175	$ 1,881	100.0%	0.0%	171	171	171	171	171	171	171	171	171	171	171	192	$ 2,069	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	$ 1,710	155	155	155	155	155	155	155	155	155	155	155	175	$ 1,881	100.0%	0.0%	171	171	171	171	171	171	171	171	171	171	171	192	$ 2,069	100.0%	0.0%
Aquafina
300 Sold	300	28	28	28	28	28	28	28	28	28	28	28	28	330		0.0%	30	30	30	30	30	30	30	30	30	30	30	30	363		0.0%
Total Sales	1200	110	110	110	110	110	110	110	110	110	110	110	110	$ 1,320	100.0%	0.0%	121	121	121	121	121	121	121	121	121	121	121	121	$ 1,452	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	$ 1,200	110	110	110	110	110	110	110	110	110	110	110	110	$ 1,320	100.0%	0.0%	121	121	121	121	121	121	121	121	121	121	121	121	$ 1,452	100.0%	0.0%
Brisk
360 Sold	360	33	33	33	33	33	33	33	33	33	33	33	33	396		0.0%	36	36	36	36	36	36	36	36	36	36	36	36	436		0.0%
Total Sales	$ 1,080	99	99	99	99	99	99	99	99	99	99	99	99	$ 1,188	100.0%	0.0%	109	109	109	109	109	109	109	109	109	109	109	109	$ 1,307	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	$ 1,080	99	99	99	99	99	99	99	99	99	99	99	99	$ 1,188	100.0%	0.0%	109	109	109	109	109	109	109	109	109	109	109	109	$ 1,307	100.0%	0.0%
Ruffles
300 Sold	300	28	28	28	28	28	28	28	28	28	28	28	28	330		0.0%	30	30	30	30	30	30	30	30	30	30	30	30	363		0.0%
Total Sales	$ 750	69	69	69	69	69	69	69	69	69	69	69	69	$ 825	100.0%	0.0%	76	76	76	76	76	76	76	76	76	76	76	76	$ 908	100.0%	0.0%
Total COGS	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%	-	-	-	-	-	-	-	-	-	-	-	-	$ -	0.0%	0.0%
Margin	$ 750	69	69	69	69	69	69	69	69	69	69	69	69	$ 825	100.0%	0.0%	76	76	76	76	76	76	76	76	76	76	76	76	$ 908	100.0%	0.0%
Total Units Sold	3503	195	228	217	217	272	228	283	297	316	393	448	762	3,853			214	250	238	238	299	250	311	327	347	432	492	839	4,239
Total Sales	$ 9,486	$ 609	$ 675	$ 653	$ 653	$ 763	$ 675	$ 785	$ 835	$ 851	$ 1,005	$ 1,115	$ 1,817	$ 10,435			$ 670	$ 742	$ 718	$ 718	$ 839	$ 742	$ 863	$ 919	$ 936	$ 1,105	$ 1,226	$ 1,998	$ 11,478
Total Cost of Goods Sold	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -			$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Total Margin	$ 9,486	$ 609	$ 675	$ 653	$ 653	$ 763	$ 675	$ 785	$ 835	$ 851	$ 1,005	$ 1,115	$ 1,817	$ 10,435			$ 670	$ 742	$ 718	$ 718	$ 839	$ 742	$ 863	$ 919	$ 936	$ 1,105	$ 1,226	$ 1,998	$ 11,478

&C&"Gill Sans MT,Regular"&12Sales Forecast Years 1-3

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

This sheet will populate based on information in the year 1 Sales Forecast. The included growth rate is just a starting point, if you can provide a more accurate prediction for each month, unlock the sheet (see Directions) and change the value for that month. Please note that you will no longer have a formula in that cell once you change the value, so you may want to save a copy of this spreadsheet under a different name before doing so.

4-AdditionalInputs


Additional Inputs
Prepared By:	Company Name:
Owner	PepsiCO
Accounts Receivable (A/R) Days Sales Outstanding
Percent of Collections	Year 1	Year 2	Year 3
Paid within 30 days	30%	30%	30%
Paid between 30 and 60 days	30%	30%	30%
Paid in more than 60 days	40%	40%	40%
Allowance for bad debt	0%	0%	0%
This should equal 100% ---->	100%	100%	100%
Accounts Payable (A/P)
Percent of Disbursements	Year 1	Year 2	Year 3
Paid within 30 days	0%	0%	0%
Paid between 30 and 60 days	100%	100%	100%
Paid in more than 60 days	0%	0%	0%
This should equal 100% ---->	100%	100%	100%
Line of Credit Assumptions
Desired Minimum Cash Balance		0
Line of Credit Interest Rate		8.00%
Additional Fixed Assets Purchases
Fixed Assets	Depreciation (years)	January	February	March	April	May	June	July	August	September	October	November	December	Year 1 Totals	Year 2 Total	Year 3 Total
Real Estate	20	$ 345												$ 345
Leasehold Improvements	7	$ 600												$ 600
Equipment	7	$ 200												$ 200
Furniture and Fixtures	5	$ 700												$ 700
Vehicles	5	$ 7,000												$ 7,000
Other Fixed Assets	5	$ 500												$ 500	$ -	$ -
Total Additional Fixed Assets		$ 9,345	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 9,345	$ -	$ -
Income Tax Assumptions
Effective Income Tax Rate - Year 1	20.0%
Effective Income Tax Rate - Year 2	20.0%
Effective Income Tax Rate - Year 3	20.0%
Amortization of Start-Up Costs
Amortization Period in Years	3

&C&"Gill Sans MT,Regular"&12Additional Inputs

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

If you are a retail business or don't have accounts receivable put 100% for each year.

In this field put the percentage of your sales that you expect to carry as A/R. If your business sells in cash, put 0%. Otherwise, estimate the percentage that will be paid between 30 and 60 days after sale.

In this field put the percentage of your sales that you expect to carry as A/R but not paid for more than 60 days. If your business sells in cash, put 0%. Otherwise, estimate the percentage that will be paid more than 60 days after sale.

Allowance for bad debt is the percentage of total A/R you believe will not be collectable for whatever reason. It could be because your customer becomes insolvent or goes out of business. If you can find an industry average for your industry, use that percentage. If in doubt, use either 0 or 1%. Many businesses that have good collection processes may have substantially less than 1% during a strong economy. Bankers like to see a figure here because it lets them know you are realistic about discounting the total value of your A/R as collateral for a potential loan.

How low do you want to let your ending cash balance to get? The minimum should be $0, but you might want to choose $1000, $5000, etc.

Use this space to add items purchased after the date of the starting point (Tab 1a).

5a-OpExYear1


Operating Expenses Year 1
Prepared By:	Company Name:
Owner	PepsiCO
	January	February	March	April	May	June	July	August	September	October	November	December	Annual Totals
Expenses
Advertising	30	30	30	30	30	30	30	30	30	30	30	30	$ 360
Car and Truck Expenses	50	50	50	50	50	50	50	50	50	50	50	50	$ 600
Commissions and Fees	30	30	30	30	30	30	30	30	30	30	30	30	$ 360
Contract Labor (Not included in payroll)	40	40	40	40	40	40	40	40	40	40	40	40	$ 480
Insurance (other than health)	45	45	45	45	45	45	45	45	45	45	45	45	$ 540
Legal and Professional Services	67	67	67	67	67	67	67	67	67	67	67	67	$ 804
Licenses	78	78	78	78	78	78	78	78	78	78	78	78	$ 936
Office Expense	20	20	20	20	20	20	20	20	20	20	20	20	$ 240
Rent or Lease -- Vehicles, Machinery, Equipment	400	400	400	400	400	400	400	400	400	400	400	400	$ 4,800
Rent or Lease -- Other Business Property	12	12	12	12	12	12	12	12	12	12	12	12	$ 144
Repairs and Maintenance	34	34	34	34	34	34	34	34	34	34	34	34	$ 408
Supplies	45	45	45	45	45	45	45	45	45	45	45	45	$ 540
Travel, Meals and Entertainment	67	67	67	67	67	67	67	67	67	67	67	67	$ 804
Utilities	89	89	89	89	89	89	89	89	89	89	89	89	$ 1,068
Miscellaneous	80	80	80	80	80	80	80	80	80	80	80	80	$ 960
Total Expenses	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 13,044
Other Expenses
Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Interest
Commercial Loan	4	4	4	4	3	3	3	3	3	3	3	3	$ 41
Commercial Mortgage	2	1	1	1	1	1	1	1	1	1	1	1	$ 18
Credit Card Debt	2	2	2	2	1	1	1	1	1	1	1	1	$ 17
Vehicle Loans	15	15	14	14	14	14	13	13	13	12	12	12	$ 161
Other Bank Debt	20	20	19	19	18	18	17	17	16	15	15	14	$ 208
Line of Credit	-	19	53	86	119	152	185	218	252	285	318	350	$ 2,035
Bad Debt Expense	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Total Other Expenses	$ 190	$ 207	$ 241	$ 273	$ 305	$ 337	$ 369	$ 402	$ 434	$ 466	$ 499	$ 530	$ 4,253
Total Fixed Operating Expenses	$ 1,277	$ 1,294	$ 1,328	$ 1,360	$ 1,392	$ 1,424	$ 1,456	$ 1,489	$ 1,521	$ 1,553	$ 1,586	$ 1,617	$ 17,297

&C&"Gill Sans MT,Regular"&12Operating Expenses Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

5b-OpExYrs1-3


Operating Expenses Years 1-3
Prepared By:	Company Name:
Owner	PepsiCO
Line Item	2013	Growth Rate 1 to 2	2014	Growth Rate 2 to 3	2015
Advertising	360	3.0%	371	3.0%	382
Car and Truck Expenses	600	3.0%	618	3.0%	637
Commissions and Fees	360	5.0%	378	5.0%	397
Contract Labor (Not included in payroll)	480	3.0%	494	3.0%	509
Insurance (other than health)	540	3.0%	556	3.0%	573
Legal and Professional Services	804	3.0%	828	3.0%	853
Licenses	936	5.0%	983	5.0%	1,032
Office Expense	240	3.0%	247	3.0%	255
Rent or Lease -- Vehicles, Machinery, Equipment	4,800	3.0%	4,944	3.0%	5,092
Rent or Lease -- Other Business Property	144	3.0%	148	3.0%	153
Repairs and Maintenance	408	5.0%	428	5.0%	450
Supplies	540	3.0%	556	3.0%	573
Travel, Meals and Entertainment	804	3.0%	828	3.0%	853
Utilities	1,068	3.0%	1,100	3.0%	1,133
Miscellaneous	960	3.0%	989	3.0%	1,018
Total Expenses	$ 13,044		$ 13,469		$ 13,909
Other Expenses
Depreciation	1,772		1,772		1,772
Interest
Commercial Loan	41		36		31
Commercial Mortgage	18		17		17
Credit Card Debt	17		14		10
Vehicle Loans	161		119		74
Other Bank Debt	208		129		47
Line of Credit	2,035		7,187		13,769
Bad Debt Expense	-
Total Other Expenses	$ 4,253		$ 9,274		$ 15,720
Total Operating Expenses	$ 17,297		$ 22,743		$ 29,629

&C&"Gill Sans MT,Regular"&12Operating Expenses Years 1-3

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

6a-CashFlowYear1


Cash Flow Forecast Year 1
Prepared By:	Company Name:
Owner	PepsiCO
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Beginning Balance	$ 2,500	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Cash Inflows
Cash Sales	166	184	178	178	208	184	214	228	232	274	304	495	$ 2,846
Accounts Receivable	-	166	405	423	415	445	461	459	513	536	583	669	$ 5,079
Total Cash Inflows	$ 166	$ 350	$ 584	$ 602	$ 624	$ 630	$ 676	$ 687	$ 745	$ 810	$ 888	$ 1,165	$ 7,925
Cash Outflows
Investing Activities
New Fixed Asset Purchases	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Additional Inventory	3	6	56	7	8	45	30	7	23	30	23	45	$ 283
Cost of Goods Sold	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Operating Activities
Operating Expenses	1,087	1,087	1,087	1,087	1,087	1,087	1,087	1,087	1,087	1,087	1,087	1,087	$ 13,044
Payroll	4,119	4,119	4,119	4,119	4,119	4,119	4,119	4,119	4,119	4,119	4,119	4,119	$ 49,429
Taxes	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Financing Activities
Loan Payments	231	231	231	231	231	231	231	231	231	231	231	231	$ 2,775
Owners Distribution	5	5	5	5	5	5	5	5	5	5	5	5	$ 60
Line of Credit Interest		19	53	86	119	152	185	218	252	285	318	350	$ 2,035
Line of Credit Repayments	3	3	3	3	3	3	3	3	3	3	3	3	$ 30
Dividends Paid	2	2	2	2	2	2	2	2	2	2	2	2	$ 24
Total Cash Outflows	$ 5,450	$ 5,471	$ 5,556	$ 5,540	$ 5,574	$ 5,644	$ 5,662	$ 5,672	$ 5,721	$ 5,762	$ 5,788	$ 5,842	$ 67,680
Net Cash Flows	$ (5,284)	$ (5,121)	$ (4,972)	$ (4,938)	$ (4,950)	$ (5,014)	$ (4,986)	$ (4,985)	$ (4,976)	$ (4,952)	$ (4,900)	$ (4,677)	$ (59,756)
Operating Cash Balance	$ (2,784)	$ (5,121)	$ (4,972)	$ (4,938)	$ (4,950)	$ (5,014)	$ (4,986)	$ (4,985)	$ (4,976)	$ (4,952)	$ (4,900)	$ (4,677)
Line of Credit Drawdown	$ 2,784	$ 5,121	$ 4,972	$ 4,938	$ 4,950	$ 5,014	$ 4,986	$ 4,985	$ 4,976	$ 4,952	$ 4,900	$ 4,677	$ 57,256
Ending Cash Balance	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Line of Credit Balance	$ 2,781	$ 7,900	$ 12,870	$ 17,805	$ 22,753	$ 27,764	$ 32,748	$ 37,731	$ 42,704	$ 47,653	$ 52,551	$ 57,226

&C&"Gill Sans MT,Regular"&12Cash Flow Forecast Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

This line allows you to approximate the personal income tax of the owner(s). This is the tax on the profit for the business.

Only record owner's draws above those already listed on the payroll tabs.

6b-CashFlowYrs1-3

	Cash Flow Forecast Years 1-3
	Prepared By:	Company Name:
	Owner	PepsiCO
	Year 1 Totals	January	February	March	April	May	June	July	August	September	October	November	December	Year 2 Totals	January	February	March	April	May	June	July	August	September	October	November	December	Year 3 Totals
Beginning Balance		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Cash Inflows
Cash Sales	$ 2,846	183	202	196	196	229	202	235	251	255	301	334	545	$ 3,130	201	223	215	215	252	223	259	276	281	332	368	599	$ 3,443
Accounts Receivable	$ 5,079	901	843	446	466	457	490	508	505	565	589	642	736	$ 7,148	991	928	491	512	503	539	558	556	621	648	706	810	$ 7,863
Total Cash Inflows	$ 7,925	$ 1,084	$ 1,046	$ 642	$ 662	$ 686	$ 692	$ 743	$ 756	$ 820	$ 891	$ 976	$ 1,281	$ 10,278	1,192	1,150	706	728	754	762	817	832	902	980	1,074	1,410	$ 11,306
Cash Outflows
Investing Activities
New Fixed Asset Purchases	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Additional Inventory	$ 283													$ -													$ -
Cost of Goods Sold	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Operating Activities
Operating Expenses	$ 13,044	1,122	1,122	1,122	1,122	1,122	1,122	1,122	1,122	1,122	1,122	1,122	1,122	$ 13,469	1,159	1,159	1,159	1,159	1,159	1,159	1,159	1,159	1,159	1,159	1,159	1,159	$ 13,909
Payroll	$ 49,429	4,888	4,888	4,888	4,888	4,888	4,888	4,888	4,888	4,888	4,888	4,888	4,888	$ 58,661	6,315	6,315	6,315	6,315	6,315	6,315	6,315	6,315	6,315	6,315	6,315	6,315	$ 75,782
Taxes	$ -	-	-	-	-	-	-	-	-	-	-	-	-		-	-	-	-	-	-	-	-	-	-	-	-	$ -
Financing Activities
Loan Payments	$ 2,775	231	231	231	231	231	231	231	231	231	231	230	231	$ 2,774	231	231	231	231	231	231	231	231	231	231	231	231	$ 2,775
Owners Distribution	$ 60													$ -													$ -
Line of Credit Interest	$ 2,035	382	418	456	496	537	577	618	659	700	741	781	822	$ 7,187	860	909	959	1,012	1,066	1,119	1,173	1,226	1,280	1,334	1,388	1,442	$ 13,769
Line of Credit Repayments	$ 30													$ -													$ -
Dividends Paid	$ 24													$ -													$ -
Total Cash Outflows	$ 67,680	$ 6,624	$ 6,661	$ 6,698	$ 6,738	$ 6,779	$ 6,819	$ 6,860	$ 6,901	$ 6,942	$ 6,983	$ 7,022	$ 7,064	$ 82,091	$ 8,566	$ 8,615	$ 8,665	$ 8,718	$ 8,771	$ 8,824	$ 8,878	$ 8,932	$ 8,986	$ 9,040	$ 9,094	$ 9,147	$ 106,235
Net Cash Flows	$ (59,756)	$ (5,540)	$ (5,615)	$ (6,056)	$ (6,077)	$ (6,093)	$ (6,127)	$ (6,117)	$ (6,145)	$ (6,122)	$ (6,092)	$ (6,046)	$ (5,782)	$ (71,813)	$ (7,374)	$ (7,465)	$ (7,959)	$ (7,990)	$ (8,017)	$ (8,063)	$ (8,061)	$ (8,100)	$ (8,084)	$ (8,060)	$ (8,020)	$ (7,738)	$ (94,929)
Operating Cash Balance		$ (5,540)	$ (5,615)	$ (6,056)	$ (6,077)	$ (6,093)	$ (6,127)	$ (6,117)	$ (6,145)	$ (6,122)	$ (6,092)	$ (6,046)	$ (5,782)		$ (7,374)	$ (7,465)	$ (7,959)	$ (7,990)	$ (8,017)	$ (8,063)	$ (8,061)	$ (8,100)	$ (8,084)	$ (8,060)	$ (8,020)	$ (7,738)
Line of Credit Drawdown	$ 57,256	$ 5,540	$ 5,615	$ 6,056	$ 6,077	$ 6,093	$ 6,127	$ 6,117	$ 6,145	$ 6,122	$ 6,092	$ 6,046	$ 5,782	$ 71,813	$ 7,374	$ 7,465	$ 7,959	$ 7,990	$ 8,017	$ 8,063	$ 8,061	$ 8,100	$ 8,084	$ 8,060	$ 8,020	$ 7,738	$ 94,929
Ending Cash Balance		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Line of Credit Balance		$ 62,766	$ 68,380	$ 74,437	$ 80,513	$ 86,606	$ 92,733	$ 98,851	$ 104,996	$ 111,118	$ 117,210	$ 123,256	$ 129,038		$ 136,412	$ 143,877	$ 151,836	$ 159,825	$ 167,842	$ 175,905	$ 183,966	$ 192,066	$ 200,150	$ 208,210	$ 216,230	$ 223,967

&C&"Gill Sans MT,Regular"&12Cash Flow Forecast Years 1-3

&L&F&C&A&R&D &T

Only record owner's draws above those already listed on the payroll tabs.

NOTE: To only view the annual total side-by-side, highlight columns C through N and right-click. Then select "Hide". Use the same procedure to Hide columns P through AA. To show them again, highlight columns B, O and AB, right-click and select "Unhide".

7a-IncomeStatementYear1


Income Statement Year 1
Prepared By:	Company Name:
Owner	PepsiCO
	January	February	March	April	May	June	July	August	September	October	November	December	Annual Totals
Revenue
Pepsi	40	100	80	80	180	100	200	206	260	400	500	1,000	$ 3,146
Lays	120	120	120	120	120	120	120	160	120	120	120	240	$ 1,600
Tropicana	141	141	141	141	141	141	141	141	141	141	141	159	$ 1,710
Aquafina	100	100	100	100	100	100	100	100	100	100	100	100	$ 1,200
Brisk	90	90	90	90	90	90	90	90	90	90	90	90	$ 1,080
Ruffles	63	63	63	63	63	63	63	63	63	63	63	63	$ 750
Total Revenue	$ 554	$ 614	$ 594	$ 594	$ 694	$ 614	$ 714	$ 760	$ 774	$ 914	$ 1,014	$ 1,652	$ 9,486
Cost of Goods Sold
Pepsi	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Lays	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Tropicana	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Aquafina	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Brisk	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Ruffles	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Total Cost of Goods Sold	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Gross Margin	$ 554	$ 614	$ 594	$ 594	$ 694	$ 614	$ 714	$ 760	$ 774	$ 914	$ 1,014	$ 1,652	$ 9,486
Payroll	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 4,119	$ 49,429
Operating Expenses
Advertising	30	30	30	30	30	30	30	30	30	30	30	30	$ 360
Car and Truck Expenses	50	50	50	50	50	50	50	50	50	50	50	50	$ 600
Commissions and Fees	30	30	30	30	30	30	30	30	30	30	30	30	$ 360
Contract Labor (Not included in payroll)	40	40	40	40	40	40	40	40	40	40	40	40	$ 480
Insurance (other than health)	45	45	45	45	45	45	45	45	45	45	45	45	$ 540
Legal and Professional Services	67	67	67	67	67	67	67	67	67	67	67	67	$ 804
Licenses	78	78	78	78	78	78	78	78	78	78	78	78	$ 936
Office Expense	20	20	20	20	20	20	20	20	20	20	20	20	$ 240
Rent or Lease -- Vehicles, Machinery, Equipment	400	400	400	400	400	400	400	400	400	400	400	400	$ 4,800
Rent or Lease -- Other Business Property	12	12	12	12	12	12	12	12	12	12	12	12	$ 144
Repairs and Maintenance	34	34	34	34	34	34	34	34	34	34	34	34	$ 408
Supplies	45	45	45	45	45	45	45	45	45	45	45	45	$ 540
Travel, Meals and Entertainment	67	67	67	67	67	67	67	67	67	67	67	67	$ 804
Utilities	89	89	89	89	89	89	89	89	89	89	89	89	$ 1,068
Miscellaneous	80	80	80	80	80	80	80	80	80	80	80	80	$ 960
Other Expense 1
Other Expense 2
Total Operating Expenses	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 1,087	$ 13,044
Income (Before Other Expenses)	$ (4,653)	$ (4,593)	$ (4,613)	$ (4,613)	$ (4,513)	$ (4,593)	$ (4,493)	$ (4,447)	$ (4,433)	$ (4,293)	$ (4,193)	$ (3,555)	$ (52,987)
Other Expenses
Amortized Start-up Expenses	110	110	110	110	110	110	110	110	110	110	110	110	$ 1,325
Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Interest
Commercial Loan	4	4	4	4	3	3	3	3	3	3	3	3	$ 41
Commercial Mortgage	2	1	1	1	1	1	1	1	1	1	1	1	$ 18
Credit Card Debt	2	2	2	2	1	1	1	1	1	1	1	1	$ 17
Vehicle Loans	15	15	14	14	14	14	13	13	13	12	12	12	$ 161
Other Bank Debt	20	20	19	19	18	18	17	17	16	15	15	14	$ 208
Line of Credit	-	19	53	86	119	152	185	218	252	285	318	350	$ 2,035
Bad Debt Expense	-	-	-	-	-	-	-	-	-	-	-	-	$ -
Total Other Expenses	300	318	351	383	415	447	480	512	545	577	609	641	$ 5,578
Net Income Before Income Tax	$ (4,953)	$ (4,910)	$ (4,964)	$ (4,996)	$ (4,928)	$ (5,040)	$ (4,972)	$ (4,959)	$ (4,977)	$ (4,869)	$ (4,802)	$ (4,195)	$ (58,564)
Income Tax	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Net Profit/Loss	$ (4,953)	$ (4,910)	$ (4,964)	$ (4,996)	$ (4,928)	$ (5,040)	$ (4,972)	$ (4,959)	$ (4,977)	$ (4,869)	$ (4,802)	$ (4,195)	$ (58,564)
Income Tax Calculations
Monthly Taxable Income	$ (4,805)	$ (4,764)	$ (4,818)	$ (4,851)	$ (4,784)	$ (4,897)	$ (4,830)	$ (4,817)	$ (4,837)	$ (4,730)	$ (4,663)	$ (4,057)
Cumulative Taxable Income	$ (4,805)	$ (9,569)	$ (14,387)	$ (19,238)	$ (24,022)	$ (28,919)	$ (33,749)	$ (38,566)	$ (43,403)	$ (48,132)	$ (52,795)	$ (56,852)

&C&"Gill Sans MT,Regular"&12Income Statement Year 1

&L&F&C&A&R&D &T

Also known as EBITDA (Earnings Before Interest, Taxes, Depreciation and Amortization). This metric allows for a comparison across different businesses, which might have different levels of taxes, depreciation, or interest. This number should be used in conjunction with other metrics, as it does not give a full picture of the health of the business.

7b-IncomeStatementYrs1-3


Income Statement Years 1-3
Prepared By:	Company Name:
Owner	PepsiCO
Revenue	2013		2014		2015
Pepsi	3,146		3,461		3,807
Lays	1,600		1,760		1,936
Tropicana	1,710		1,881		2,069
Aquafina	1,200		1,320		1,452
Brisk	1,080		1,188		1,307
Ruffles	750		825		908
Total Revenue	$ 9,486	100%	$ 10,435	100%	$ 11,478	100%
Cost of Goods Sold
Pepsi	-		-		-
Lays	-		-		-
Tropicana	-		-		-
Aquafina	-		-		-
Brisk	-		-		-
Ruffles	-		-		-
Total Cost of Goods Sold	-	0%	-	0%	-	0%
Gross Margin	9,486	100%	10,435	100%	11,478	100%
Payroll	49,429		58,661		75,782
Operating Expenses
Advertising	360		371		382
Car and Truck Expenses	600		618		637
Commissions and Fees	360		378		397
Contract Labor (Not included in payroll)	480		494		509
Insurance (other than health)	540		556		573
Legal and Professional Services	804		828		853
Licenses	936		983		1,032
Office Expense	240		247		255
Rent or Lease -- Vehicles, Machinery, Equipment	4,800		4,944		5,092
Rent or Lease -- Other Business Property	144		148		153
Repairs and Maintenance	408		428		450
Supplies	540		556		573
Travel, Meals and Entertainment	804		828		853
Utilities	1,068		1,100		1,133
Miscellaneous	960		989		1,018
Other Expense 1
Other Expense 2
Total Operating Expenses	$ 13,044	138%	$ 13,469	129%	$ 13,909	121%
Income (Before Other Expenses)	$ (52,987)	-559%	$ (61,696)	-591%	$ (78,213)	-681%
Other Expenses
Amortized Start-up Expenses	1,325		1,325		1,325
Depreciation	1,772		1,772		1,772
Interest
Commercial Loan	41		36		31
Commercial Mortgage	18		17		17
Credit Card Debt	17		14		10
Vehicle Loans	161		119		74
Other Bank Debt	208		129		47
Line of Credit	2,035		7,187		13,769
Bad Debt Expense	-		-		-
Total Other Expenses	$ 5,578	59%	$ 10,599	102%	$ 17,045	149%
Net Income Before Income Tax	$ (58,564)		$ (72,294)		$ (95,258)
Income Tax	$ -		$ -		$ -
Net Income/Loss	$ (58,564)	-617%	$ (72,294)	-693%	$ (95,258)	-830%
Income Tax Calculations	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Total
Taxable Amount Year 2	$ (5,936)	$ (5,907)	$ (5,966)	$ (6,006)	$ (5,937)	$ (6,065)	$ (5,996)	$ (5,986)	$ (6,012)	$ (5,899)	$ (5,829)	$ (5,168)	$ (70,707)
Total	$ (5,936)	$ (11,843)	$ (17,809)	$ (23,815)	$ (29,752)	$ (35,817)	$ (41,814)	$ (47,800)	$ (53,812)	$ (59,711)	$ (65,540)	$ (70,707)	$ (464,356)
Income Taxes	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Taxable Amount Year 3	$ (7,817)	$ (7,793)	$ (7,867)	$ (7,920)	$ (7,852)	$ (8,003)	$ (7,935)	$ (7,933)	$ (7,970)	$ (7,855)	$ (7,787)	$ (7,069)	$ (93,802)
Total	$ (7,817)	$ (15,610)	$ (23,477)	$ (31,397)	$ (39,249)	$ (47,252)	$ (55,187)	$ (63,120)	$ (71,091)	$ (78,945)	$ (86,733)	$ (93,802)	$ (613,678)
Income Taxes	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -

&C&"Gill Sans MT,Regular"&12Income Statement Years 1-3

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

8-BalanceSheet


Balance Sheet Years 1-3
Prepared By:	Company Name:
Owner	PepsiCO
ASSETS	2013	2014	2015
Current Assets
Cash	-	-	-
Accounts Receivable	1,561	1,718	1,889
Inventory	2,283	2,283	2,283
Prepaid Expenses	2,417	1,208	-
Other Initial Costs	233	117	-
Total Current Assets	$ 6,494	$ 5,326	$ 4,172
Fixed Assets
Real Estate -- Land	4,000	4,000	4,000
Real Estate -- Buildings	345	345	345
Leasehold Improvements	600	600	600
Equipment	200	200	200
Furniture and Fixtures	700	700	700
Vehicles	7,000	7,000	7,000
Other	500	500	500
Total Fixed Assets	$ 13,345	$ 13,345	$ 13,345
(Less Accumulated Depreciation)	$ 1,772	$ 3,543	$ 5,315
Total Assets	$ 18,067	$ 15,127	$ 12,202
LIABILITIES & EQUITY
Liabilities
Accounts Payable	-	-	-
Commercial Loan Balance	428	372	310
Commercial Mortgage Balance	196	192	188
Credit Card Debt Balance	223	173	119
Vehicle Loans Balance	2,316	1,590	819
Other Bank Debt Balance	3,327	1,705	(0)
Line of Credit Balance	57,226	129,038	223,967
Total Liabilities	$ 63,716	$ 133,070	$ 225,403
Equity
Common Stock	13,000	13,000	13,000
Retained Earnings	(58,564)	(130,859)	(226,117)
Dividends Dispersed/Owners Draw	84	84	84
Total Equity	$ (45,648)	$ (117,943)	$ (213,201)
Total Liabilities and Equity	$ 18,067	$ 15,127	$ 12,202
Balance sheet in or out of balance?	$ -	$ -	$ -
	Balanced!	Balanced!	Balanced!

&C&"Gill Sans MT,Regular"&12Balance Sheet Years 1-3

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

BreakevenAnalysis


	Breakeven Analysis Year 1
	Prepared By:	Company Name:
	Owner	PepsiCO
	Gross Margin % of Sales
	Gross Margin	$ 9,486
	Total Sales	$ 9,486
	Gross Margin/Total Sales	100.0%
	Total Fixed Expenses
	Payroll	$ 49,428.62
	Operating Expenses	$ 17,296.82
	Operating + Payroll	$ 66,725
	Breakeven Sales in Dollars (Annual)
	Gross Margin % of Sales	100.0%
	Total Fixed Expenses	$ 66,725
	Yearly Breakeven Amount	$ 66,725
	Monthly Breakeven Amount	$ 5,560

&C&"Gill Sans MT,Regular"&12Breakeven Analysis

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

Breakeven Sales Level The breakeven sales level represents the number of units that must be sold in order to break even. This means that revenues are equal to expenses. Any units sold beyond this quantity will allow the company to generate net income. One of the best uses of breakeven analysis is to play with various scenarios. For instance, if you add another person to the payroll, how many extra sales dollars will be needed to recover the extra salary expense? If you borrow, how much will be needed to cover the increased principal and interest payments? Many owners, especially retailers, like to calculate a daily breakdown. This gives everyone a target to shoot at for the day. Equation: Breakeven Point = Total Fixed Costs/ (Gross Margin/Total Sales)

FinancialRatios


Financial Ratios - Year 1
Prepared By:	Company Name:
Owner	PepsiCO
Ratios	Year One	Year Two	Year Three	Industry Norms	Notes
Liquidity
Current Ratio	0.1	0.0	0.0
Quick Ratio	0.0	0.0	0.0
Safety
Debt to Equity Ratio	-1.4	-1.1	-1.1
Debt-Service Coverage Ratio - DSCR	-0.9	-0.5	-0.4
Profitability
Sales Growth	0.0%	10.0%	10.0%
COGS to Sales	0.0%	0.0%	0.0%
Gross Profit Margin	100.0%	100.0%	100.0%
SG&A to Sales	658.6%	691.3%	781.4%
Net Profit Margin	-617.4%	-692.8%	-829.9%
Return on Equity (ROE)	128.3%	61.3%	44.7%
Return on Assets	-324.2%	-477.9%	-780.7%
Owner's Compensation to Sales	268.4%	292.8%	346.0%
Efficiency
Days in Receivables	59.3	59.3	59.3
Accounts Receivable Turnover	6.1	6.1	6.1
Days in Inventory	0.0	0.0	0.0
Inventory Turnover	0.0	0.0	0.0
Sales to Total Assets	0.5	0.7	0.9

&C&"Gill Sans MT,Regular"&12Financial Ratios - Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

An indication of a company's ability to meet short-term debt obligations.

The ratio between all assets quickly convertible into cash and current liabilities. Measures a company's liquidity. Also called acid-test ratio.

This ratio expresses the relationship between capital contributed by creditors and that contributed by owners.

This ratio indicates how well your cash flow covers debt and the capability of the business to take on additional debt.

This ratio calculates the percentage of increase (or decrease) in sales between the current year and the previous year.

The percentage of sales used to pay for the COGS (expenses which directly vary with sales) is expressed in this ratio.

This ratio indicates how much profit is earned on your products without consideration of indirect costs, selling and administration costs.

This ratio measures the percentage of selling, general and administrative costs to your amount of sales.

Net profit margin shows how much profit comes from every dollar of sales.

Return on equity determines the rate of return on your investment in the business. As an owner or shareholder this is one of the most important ratios as it shows the hard fact about the business - are you making enough of a profit to compensate you for the risk of being in business?

This ratio measures how effectively assets are used to generate a return.

This ratio measures the owner's compensation as a percentage of sales.

Days in receivable calculates the average number of days it takes to collect your account receivable (number of days of sales in receivables).

This ratio tells you the number of times accounts receivable turnover during the year.

This ratio shows the average number of days it will take to sell your inventory.

This ratio calculates the number of times inventory is turned over (or sold) during the year.

This ratio indicates how efficiently your business generates sales on every dollar of assets.

With some research, you can find industry norms for each ratio. The Risk Management Association provides Annual Statement Studies with this information, for a fee. Visit your local library to see if they have a free copy you can use. You can also refer to trade magazines or other sources of industry data, such as www.bizstats.com or http://biz.yahoo.com/p/industries.html. You may need to use a mix of sources, as one source may not provide all of the data. Speak with your mentor to ensure that the industry norms you are using are relevant to your business. Leave this column blank if you do not have the industry information.

This sheet shows some common financial ratios. There is a column where you can enter industry norms. To get these, contact your local library or bank to see if they have copies of the Risk Management Association (RMA) Annual Statement or refer to industry publications and trade magazines. Speak with your mentor to ensure you are using the appropriate resources.

DiagnosticTools


Diagnostic Tools - Year 1
Prepared By:	Company Name:
Owner	PepsiCO
General Financing Assumptions	Value	Findings
Owner's Cash Injection into the Business	45.8%	Owner's injection is reasonable
Cash Request as percent of Total Required Funds	11.5%	Cash request seems reasonable with respect to total request
Loan Assumptions	Value	Findings
Commercial Loan Interest rate	9.0%	Interest rate seems reasonable
Commercial Loan Term in Months	84	Loan term seems within range for this type of loan
Commercial Mortgage Interest rate	9.0%	Interest rate seems reasonable
Commercial Mortgage Term in Months	240	Loan term seems within range for this type of loan
Debt-Service Coverage	-89.1%	Calculated loan payments relative to operating profit seem reasonable
Income Statement	Value	Findings
Gross Margin as a Percent of Sales	100.0%	Gross margin percentage seems reasonable
Owner's Compensation Lower Limit Check	$ 25,459	An owner's compensation amount has been established
Owner's Compensation Upper Limit Check	-43.5%	Owner's compensation seems reasonable
Advertising Expense Levels as a Percent of Sales	3.8%	Advertising as a percent of sales seems reasonable
Profitability Levels	$ (58,564)	The business is not showing a profit
Profitability as a Percent of Sales	-617.4%	The projection does not seem highly unreasonable
Cash Flow Statement	Value	Findings
Desired Operating cash Flow Levels	$ 57,256	The financial projection provides the desired level of cash flow
Line of Credit Drawdowns	$ 57,256	The business will need at least this level of a line of credit
Accounts Receivable Ratio to Sales	16.5%	Accounts receivable amount as a percent of sales seems reasonable
Balance Sheet	Value	Findings
Does the Year 1 Balance Sheet Balance?	$ -	The balance sheet does balance
Debt to Equity Ratio	-139.6%	Very comfortable
Breakeven Analysis	Value	Findings
Do Sales Exceed the Breakeven Level?	$ (57,239)	The sales projection is less than the break-even amount

&C&"Gill Sans MT,Regular"&12Diagnostic Tools - Year 1

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12&D &T

This sheet performs a few tests on your numbers to see if they seem within certain reasonable ranges. Remember, no computer can tell whether your projections are truly well-constructed, only a human can do that. But these tests can at least look for values that are critically out of range.

COGS Calculator


	COGS Calculator
	Prepared By:	Company Name:
	Owner	PepsiCO
	Variable Costs of Products
	Timeframe:	Month
	Product Line:	Widget
	Raw materials
	Labor used to produce product
	Costs associated with shipping and storing raw materials
	Production facility expenses (use fraction of total if facility is used for other items)
	Total Product Expenses	$ -
	Number Units Sold in timeframe used
	Cost of Goods Sold Per Unit	Please enter all information.
	Variable Costs of Services
	Timeframe:	Month
	Product Line:	Project
	Amount spent on labor during timeframe
	Amount spent on materials during this timeframe
	List any other variable costs associated with the delivery of your service during this timeframe.
	Total Service Expenses	$ -
	Number Units Sold During Timeframe
	Cost of Goods Sold Per Unit	Please enter all information.
		Return to Sales Forecast Year 1

&C&"Gill Sans MT,Regular"&12COGS Calculator

&L&"Gill Sans MT,Regular"&12&F&C&"Gill Sans MT,Regular"&12&A&R&"Gill Sans MT,Regular"&12 &D &T

Return to Sales Forecast Year 1

Amortization&Depreciation


Amortization & Depreciation Schedule
Prepared By:	Company Name:		Return to Starting Point
Owner	PepsiCO
Commercial Loan
Principal Amount	$ 480
Interest Rate	9.00%
Loan Term in Months	84.00
Monthly Payment Amount	$7.72
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Interest	4	4	4	4	3	3	3	3	3	3	3	3	$ 41
Principal	4	4	4	4	4	4	4	4	4	4	4	4	$ 52
Loan Balance	476	472	468	463	459	455	450	446	442	437	433	428
Year Two
Interest	3	3	3	3	3	3	3	3	3	3	3	3	$ 36
Principal	5	5	5	5	5	5	5	5	5	5	5	5	$ 56
Loan Balance	424	419	415	410	406	401	396	391	387	382	377	372
Year Three
Interest	3	3	3	3	3	3	3	3	2	2	2	2	$ 31
Principal	5	5	5	5	5	5	5	5	5	5	5	5	$ 62
Loan Balance	367	362	357	352	347	342	337	332	326	321	316	310
Commercial Mortgage
Principal Amount	$ 200.00
Interest Rate	9.00%
Loan Term in Months	240.00
Monthly Payment Amount	$1.80
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Interest	2	1	1	1	1	1	1	1	1	1	1	1	$ 18
Principal	0	0	0	0	0	0	0	0	0	0	0	0	$ 4
Loan Balance	200	199	199	199	198	198	198	198	197	197	197	196
Year Two
Interest	1	1	1	1	1	1	1	1	1	1	1	1	$ 17
Principal	0	0	0	0	0	0	0	0	0	0	0	0	$ 4
Loan Balance	196	196	195	195	195	194	194	194	193	193	193	192
Year Three
Interest	1	1	1	1	1	1	1	1	1	1	1	1	$ 17
Principal	0	0	0	0	0	0	0	0	0	0	0	0	$ 4
Loan Balance	192	191	191	191	190	190	190	189	189	188	188	188
Credit Card Debt
Principal Amount	$ 270.00
Interest Rate	7.00%
Loan Term in Months	60.00
Monthly Payment Amount	$5.35
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Interest	2	2	2	2	1	1	1	1	1	1	1	1	$ 17
Principal	4	4	4	4	4	4	4	4	4	4	4	4	$ 47
Loan Balance	266	262	259	255	251	247	243	239	235	231	227	223
Year Two
Interest	1	1	1	1	1	1	1	1	1	1	1	1	$ 14
Principal	4	4	4	4	4	4	4	4	4	4	4	4	$ 50
Loan Balance	219	215	211	207	203	199	194	190	186	182	177	173
Year Three
Interest	1	1	1	1	1	1	1	1	1	1	1	1	$ 10
Principal	4	4	4	4	4	4	4	5	5	5	5	5	$ 54
Loan Balance	169	164	160	156	151	147	142	138	133	129	124	119
Vehicle Loans
Principal Amount	$ 3,000.00
Interest Rate	6.00%
Loan Term in Months	48.00
Monthly Payment Amount	$70.46
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Interest	15	15	14	14	14	14	13	13	13	12	12	12	$ 161
Principal	55	56	56	56	57	57	57	57	58	58	58	59	$ 684
Loan Balance	2,945	2,889	2,833	2,777	2,720	2,663	2,606	2,549	2,491	2,433	2,375	2,316
Year Two
Interest	12	11	11	11	10	10	10	9	9	9	9	8	$ 119
Principal	59	59	59	60	60	60	61	61	61	62	62	62	$ 726
Loan Balance	2,257	2,198	2,138	2,079	2,019	1,958	1,898	1,837	1,775	1,714	1,652	1,590
Year Three
Interest	8	8	7	7	7	6	6	6	5	5	5	4	$ 74
Principal	63	63	63	63	64	64	64	65	65	65	66	66	$ 771
Loan Balance	1,527	1,464	1,401	1,338	1,274	1,210	1,146	1,081	1,016	950	885	819
Other Bank Debt
Principal Amount	$4,870.00
Interest Rate	5.00%
Loan Term in Months	36.00
Monthly Payment Amount	$145.96
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Interest	20	20	19	19	18	18	17	17	16	15	15	14	$ 208
Principal	126	126	127	127	128	128	129	129	130	130	131	132	$ 1,543
Loan Balance	4,744	4,618	4,491	4,364	4,236	4,108	3,979	3,850	3,720	3,590	3,459	3,327
Year Two
Interest	14	13	13	12	12	11	11	10	9	9	8	8	$ 129
Principal	132	133	133	134	134	135	135	136	137	137	138	138	$ 1,622
Loan Balance	3,195	3,062	2,929	2,795	2,661	2,526	2,391	2,255	2,118	1,981	1,843	1,705
Year Three
Interest	7	7	6	5	5	4	4	3	2	2	1	1	$ 47
Principal	139	139	140	141	141	142	142	143	144	144	145	145	$ 1,705
Loan Balance	1,566	1,427	1,287	1,146	1,005	863	721	578	434	290	145	(0)
Depreciation
Real Estate-Buildings	20
Leasehold Improvements	7
Equipment	7
Furniture and Fixtures	5
Vehicles	5
Other	5
	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Starting Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Additional Depreciation	-	-	-	-	-	-	-	-	-	-	-	-
Ending Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Year Two
Starting Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Additional Depreciation	-	-	-	-	-	-	-	-	-	-	-	-
Ending Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Year Three
Starting Depreciation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Additional Depreciation	-	-	-	-	-	-	-	-	-	-	-	-
Ending Deprecation	148	148	148	148	148	148	148	148	148	148	148	148	$ 1,772
Amortization of Start-Up Costs		Monthly
Prepaid Expenses	$ 3,625
Total Expensed each Year	$ 1,208	101
Other Initial Costs	$ 350
Total Expensed each Year	$ 117	10
Prepaid Expenses	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Amount Amortized	101	101	101	101	101	101	101	101	101	101	101	101	$ 1,208
Total Amortized	101	201	302	403	503	604	705	806	906	1,007	1,108	1,208
Year Two
Amount Amortized	101	101	101	101	101	101	101	101	101	101	101	101	$ 1,208
Total Amortized	1,309	1,410	1,510	1,611	1,712	1,812	1,913	2,014	2,115	2,215	2,316	2,417
Year Three
Amount Amortized	101	101	101	101	101	101	101	101	101	101	101	101	$ 1,208
Total Amortized	2,517	2,618	2,719	2,819	2,920	3,021	3,122	3,222	3,323	3,424	3,524	3,625
Other Initial Costs	January	February	March	April	May	June	July	August	September	October	November	December	Totals
Year One
Amount Amortized	10	10	10	10	10	10	10	10	10	10	10	10	$ 117
Total Amortized	10	19	29	39	49	58	68	78	88	97	107	117
Year Two
Starting Depreciation	10	10	10	10	10	10	10	10	10	10	10	10	$ 117
Ending Depreciation	126	136	146	156	165	175	185	194	204	214	224	233
Year Three
Starting Depreciation	10	10	10	10	10	10	10	10	10	10	10	10	$ 117
Ending Deprecation	243	253	263	272	282	292	301	311	321	331	340	350

&C&"Gill Sans MT,Regular"&12Amortization and Depreciation Schedule

Return to Starting Point

Revision Notes

Date Last Revised	Revised By	Notes
6/21/13	Heather Hendy	Tab 3a, cell O55: added margin from 6th product. Tab 3b, cells O49 and AD49: added margins from 6th product. Tab 7b: added % sales for lines 23 and 59 for all three years.
7/14/13	Heather Hendy	Updated Tabs 5a, 5b, 7a, and 7b to automatically carry over debt categories from Tab 1 in case they are edited. Updated Tabs 5b, 7a and 7b to carry over expense categories from tab 5a in case they are edited.
4/23/14	Heather Hendy	Tab 8 Balance Sheet Cell F41 comes from E41 + tab 6b cell AB24 + tab 6b cell AB27. However tab 6b cell AB27 did not have a sum total in the cell. So when paying Dividends in Year 3 the total for the year is not calculated and carried over to the Balance Sheet. This has now been updated.