12 Month Income Statement

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Designed by:	www.PracticalSpreadsheets.com										Copyright © 2009 Practical Spreadsheets
2
3	<Company Name>
4	Income Statement
5	For the Year Ending <Date>
6			January	February	March	April	May	June	July	August	September	October	November	December	YTD
7	Revenue
8	Sales		$50,000	$52,500	$55,125	$57,881	$60,775	$63,814	$67,005	$70,355	$73,873	$77,566	$81,445	$85,517	$795,856
9	Sales Returns		0	0	0	0	0	0	0	0	0	0	0	0	0
10	Sales Discounts		5,000	5,250	5,513	5,788	6,078	6,381	6,700	7,036	7,387	7,757	8,144	8,552	79,586
11	<Other Revenue>		0	0	0	0	0	0	0	0	0	0	0	0	0
12	<Other Revenue>		0	0	0	0	0	0	0	0	0	0	0	0	0
13	<Other Revenue>		0	0	0	0	0	0	0	0	0	0	0	0	0
14	Net Sales		$55,000	$57,750	$60,638	$63,669	$66,853	$70,195	$73,705	$77,391	$81,260	$85,323	$89,589	$94,069	$875,442
15	Cost of Goods Sold		20,000	21,000	22,050	23,153	24,310	25,526	26,802	28,142	29,549	31,027	32,578	34,207	318,343
16	Gross Profit		$35,000	$36,750	$38,588	$40,517	$42,543	$44,670	$46,903	$49,249	$51,711	$54,296	$57,011	$59,862	$557,099
17	Operating Expenses
18	Salaries & Wages		$7,500	$7,875	$8,269	$8,682	$9,116	$9,572	$10,051	$10,553	$11,081	$11,635	$12,217	$12,828	$119,378
19	Depreciation Expenses		500	525	551	579	608	638	670	704	739	776	814	855	7,959
20	Office Expenses		475	499	524	550	577	606	637	668	702	737	774	812	7,561
21	Rent Expense		1,500	1,575	1,654	1,736	1,823	1,914	2,010	2,111	2,216	2,327	2,443	2,566	23,876
22	Travel Expenses		250	263	276	289	304	319	335	352	369	388	407	428	3,979
23	Maintenance Expenses		100	105	110	116	122	128	134	141	148	155	163	171	1,592
24	Advertising Expenses		200	210	221	232	243	255	268	281	295	310	326	342	3,183
25	<Other Expense>		0	0	0	0	0	0	0	0	0	0	0	0	0
26	<Other Expense>		0	0	0	0	0	0	0	0	0	0	0	0	0
27	<Other Expense>		0	0	0	0	0	0	0	0	0	0	0	0	0
28	Total Operating Expenses		$10,525	$11,051	$11,604	$12,184	$12,793	$13,433	$14,105	$14,810	$15,550	$16,328	$17,144	$18,001	$167,528
29	Income From Operations		$24,475	$25,699	$26,984	$28,333	$29,750	$31,237	$32,799	$34,439	$36,161	$37,969	$39,867	$41,861	$389,572
30	Interest Income (Expense)		(100)	(105)	(110)	(116)	(122)	(128)	(134)	(141)	(148)	(155)	(163)	(171)	(1,592)
31	Income Before Income Taxes		$24,375	$25,594	$26,873	$28,217	$29,628	$31,109	$32,665	$34,298	$36,013	$37,814	$39,704	$41,690	$387,980
32	Income Tax Expense		750	788	827	868	912	957	1,005	1,055	1,108	1,164	1,222	1,283	11,938
33	Net Income		$23,625	$24,806	$26,047	$27,349	$28,716	$30,152	$31,660	$33,243	$34,905	$36,650	$38,483	$40,407	$376,042
34