ACCT

NO NAME COMPANY
PROFORMA
PARAMETERS			NOV	DEC	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEPT	OCT	NOV	DEC	JAN	FEB
		WIDGET			700	770	847	931.7	1024.87	1127.357	1240.093	1364.102	1500.512	1650.563	1815.62	1997.182	2196.9	2416.59
		SUPERWIDGET			200	230	264.5	304.175	349.8013	402.2714	462.6122	532.004	611.8046	703.5753	809.1115	930.4783	1070.05	1230.558
		PRICE – WIDGET			300	300	300	300	300	300	300	300	300	300	300	300	300	300
		PRICE – SUPERWIDGET			600	600	600	600	600	600	600	600	600	600	600	600	600	600
INCOME STATEMENT
	REVENUE
		WIDGET			210000	231000	254100	279510	307461	338207.1	372027.8	409230.6	450153.7	495169	544685.9	599154.5	659070	724977
		SUPERWIDGET			120000	138000	158700	182505	209880.8	241362.9	277567.3	319202.4	367082.7	422145.2	485466.9	558287	642030	738334.5
		TOT REVENUES	280000	290000	330000	369000	412800	462015	517341.8	579570	649595.1	728433	817236.4	917314.2	1030153	1157441	1301100	1463311
	COST OF GOODS SOLD
		WIDGET			126000	138600	152460	167706	184476.6	202924.3	223216.7	245538.4	270092.2	297101.4	326811.5	359492.7	395442	434986.2
		SUPERWIDGET			60000	69000	79350	91252.5	104940.4	120681.4	138783.6	159601.2	183541.4	211072.6	242733.5	279143.5	321015	369167.3
		COST OF GOODS SOLD		173000	186000	207600	231810	258958.5	289417	323605.7	362000.3	405139.5	453633.6	508174	569545	638636.2	716457	804153.4
	GROSS MARGIN				144000	161400	180990	203056.5	227924.8	255964.3	287594.8	323293.4	363602.8	409140.2	460607.8	518805.3	584643	659158
	EXPENSES
		SALARIES – SUPVR			15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000	15000
		COMMISSIONS			66000	73800	82560	92403	103468.4	115914	129919	145686.6	163447.3	183462.8	206030.6	231488.3	260220	292662.3
		RENT			10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000
		INSURANCE			4000	4000	4000	4000	4000	4000	4000	4000	4000	4000	4000	4000	4000	4000
		SHIPPING			53000	59200	66155	73960.75	82725.61	92572.28	103639.7	116085.5	130088	145849.9	163601	183602.1	206149.5	231579.7
		SUPPLIES			1440	1614	1809.9	2030.565	2279.248	2559.643	2875.948	3232.934	3636.028	4091.402	4606.078	5188.053	5846.43	6591.58
		INTEREST				58.33333	175	291.6667	350	408.3333	466.6667	408.3333	291.6667	233.3333	175	116.6667	58.33333	0
		MISC			5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000
		TOT EXPENSES			154440	168672.3	184699.9	202686	222823.2	245454.2	270901.4	299413.3	331463	367637.5	408412.7	454395.1	506274.3	564833.5
	OPERATING INCOME				-10440	-7272.33	-3709.9	370.5183	5101.565	10510.02	16693.41	23880.11	32139.84	41502.67	52195.16	64410.14	78368.74	94324.5
BALANCE SHEET
	ASSETS
		CASH			25360	13547.67	14663.77	17955.89	13826.16	12669.96	14941.94	1281.609	-17651.4	-21224.1	-18641.2	-8988.39	8785.846	35890.76
		ACCOUNTS REC		180000	202000	229500	259200	292567.5	330073.9	372253.3	419711.5	473135.5	533304.8	601104.4	677539.3	763751.3	861038.3	970875.7
		JIT INVENTORY			0	0	0	0	0	0	0	0	0	0	0	0	0	0
					227360	243047.7	273863.8	310523.4	343900	384923.3	434653.5	474417.1	515653.4	579880.3	658898.1	754762.9	869824.1	1006766
	LIABILITIES
		ACCTS PAYABLE			111600	124560	139086	155375.1	173650.2	194163.4	217200.2	243083.7	272180.1	304904.4	341727	383181.7	429874.2	482492.1
		LINE OF CREDIT			0	10000	30000	50000	60000	70000	80000	70000	50000	40000	30000	20000	10000	0
					111600	134560	169086	205375.1	233650.2	264163.4	297200.2	313083.7	322180.1	344904.4	371727	403181.7	439874.2	482492.1
	STOCKHOLDERS EQUITY
		COMMON STOCK			330000	330000	330000	330000	330000	330000	330000	330000	330000	330000	330000	330000	330000	330000
		RETAINED EARNINGS		-203800	-214240	-221512	-225222	-224852	-219750	-209240	-192547	-168667	-136527	-95024.1	-42828.9	21581.2	99949.94	194274.4
					115760	108487.7	104777.8	105148.3	110249.8	120759.9	137453.3	161333.4	193473.2	234975.9	287171.1	351581.2	429949.9	524274.4
	TOT LIAB & STK EQ				227360	243047.7	273863.8	310523.4	343900	384923.3	434653.5	474417.1	515653.4	579880.3	658898.1	754762.9	869824.1	1006766
					0	0	0	0	0	0	0	0	0	0	0	0	0	0
CASH FLOW STATEMENT
	OPERATIONS
		RECEIPTS			308000	341500	383100	428647.5	479835.4	537390.5	602136.9	675009	757067.1	849514.6	953718	1071229	1203813	1353474
		INVENTORY PURCH			-178200	-194640	-217284	-242669	-271142	-303092	-338964	-379256	-424537	-475450	-532722	-597181	-669765	-751536
		EXP – OTHER			-154440	-168672	-184700	-202686	-222823	-245454	-270901	-299413	-331463	-367638	-408413	-454395	-506274	-564834
					-24640	-21812.3	-18883.9	-16707.9	-14129.7	-11156.2	-7728.02	-3660.33	1066.963	6427.355	12582.88	19652.8	27774.24	37104.92
	INVESTMENT
		NONE YET
	FINANCING
		LINE OF CREDIT				10000	20000	20000	10000	10000	10000	-10000	-20000	-10000	-10000	-10000	-10000	-10000
	CHANGE IN CASH				-24640	-11812.3	1116.1	3292.118	-4129.73	-1156.2	2271.979	-13660.3	-18933	-3572.64	2582.882	9652.797	17774.24	27104.92
	BEGINNING BALANCE				50000	25360	13547.67	14663.77	17955.89	13826.16	12669.96	14941.94	1281.609	-17651.4	-21224.1	-18641.2	-8988.39	8785.846
	ENDING BALANCE			50000	25360	13547.67	14663.77	17955.89	13826.16	12669.96	14941.94	1281.609	-17651.4	-21224.1	-18641.2	-8988.39	8785.846	35890.76

Advertisement