Income Statement - Download as Excel

Document Sample
Income Statement - Download as Excel Powered By Docstoc
					Projected Income Statement
ABC Company
INCOME STATEMENT Revenue Stream 1 Revenue Stream 2 Revenue Stream 3 TOTAL REVENUES COGS - Rev Stream 1 COGS - Rev Stream 2 COGS - Rev Stream 3 TOTAL COGS TOTAL GROSS MARGIN $ GM % Mo 1 4,000 5,000 7,000 16,000 1,800 2,600 4,550 8,950 7,050 44% Mo 2 4,000 5,000 7,000 16,000 1,800 2,600 4,550 8,950 7,050 44% Mo 3 3,000 5,000 7,000 15,000 1,350 2,600 4,550 8,500 6,500 43% Mo 4 6,000 6,000 4,000 16,000 2,700 3,120 2,600 8,420 7,580 47% Mo 5 5,000 6,000 4,000 15,000 2,250 3,120 2,600 7,970 7,030 47% Mo 6 8,000 6,000 4,000 18,000 3,600 3,120 2,600 9,320 8,680 48% Mo 7 3,000 8,000 4,000 15,000 1,350 4,160 2,600 8,110 6,890 46% Mo 8 4,000 8,000 5,000 17,000 1,800 4,160 3,250 9,210 7,790 46% Mo 9 4,000 8,000 5,000 17,000 1,800 4,160 3,250 9,210 7,790 46% Mo 10 7,000 12,000 5,000 24,000 3,150 6,240 3,250 12,640 11,360 47% Mo 11 10,000 12,000 7,000 29,000 4,500 6,240 4,550 15,290 13,710 47% Mo 12 9,000 12,000 7,000 28,000 4,050 6,240 4,550 14,840 13,160 47% Yr 1 Tot 67,000 93,000 66,000 226,000 30,150 48,360 42,900 121,410 104,590 46% % Sales Year 2 30% 41% 29% 100% 13% 21% 19% 54% 46% 75,000 100,000 75,000 250,000 33,750 52,000 48,750 134,500 115,500 46% Year 3 90,000 110,000 80,000 280,000 40,500 57,200 52,000 149,700 130,300 47%

Advertising Marketing Payroll / Benefits Commissions Travel / Entertainment - Mktg Mailing Costs - Marketing TOTAL MARKETING EXP

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

500 2,000 100 100 100 2,800

6,000 24,000 1,200 1,200 1,200 33,600

3% 11% 1% 1% 1% 15%

8,000 27,000 1,500 1,500 2,000 40,000

10,000 27,000 1,500 1,500 2,000 42,000

Rent Utilities Repairs / Maintenance Payroll / Benefits Depreciation Expense Professional Services Travel / Entertainment - G&A Insurance Telephone Dues & Subscriptions Office Supplies Security System Misc Expenses TOTAL G&A EXPENSES TOTAL EXPENSES NET PROFIT (EBIT) % of Sales Interest Expenses NET PROFITS (EBT) Taxes (Will be "0" unless C-Corp) NET PROFITS AFTER TAXES
COGS = Cost of Goods Sold

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 420 3% 100 320 0 320

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 420 3% 100 320 0 320

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 -130 -1% 100 -230 0 -230

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 950 6% 100 850 0 850

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 400 3% 100 300 0 300

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 2,050 11% 100 1,950 0 1,950

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 260 2% 100 160 0 160

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 1,160 7% 100 1,060 0 1,060

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 1,160 7% 100 1,060 0 1,060

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 4,730 20% 100 4,630 0 4,630

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 7,080 24% 100 6,980 0 6,980

500 300 50 2,000 100 300 100 100 100 30 100 50 100 3,830 6,630 6,530 23% 100 6,430 0 6,430

6,000 3,600 600 24,000 1,200 3,600 1,200 1,200 1,200 360 1,200 600 1,200 45,960 79,560 25,030

3% 2% 0% 11% 1% 2% 1% 1% 1% 0% 1% 0% 1% 20% 35% 11%

6,000 3,700 800 30,000 1,200 4,000 2,000 1,200 1,500 360 1,500 600 2,000 54,860 94,860 20,640 8% 1,200 19,440 8% 0 19,440 8%

6,000 3,900 1,000 36,000 1,500 5,000 3,000 1,500 2,500 360 1,800 600 3,000 66,160 108,160 22,140 8% 1,200 20,940 7% 0 20,940 7%

1,200 23,830 0 23,830

1% 11% 0% 11%

G&A = General & Administrative

EBIT = Earnings Before Interest & Taxes

EBT = Earnings Before Taxes

Download this form at www.kusbdc.net - Go to the "Resources" section, then to the "Accounting" section, then click "download income statement spreadsheet in EXCEL."


				
DOCUMENT INFO
Shared By:
Stats:
views:4671
posted:9/25/2007
language:English
pages:1
Jason  Nazar Jason Nazar Ceo
About Jason is the Co-Founder and CEO of Docstoc.com, the premier online destination to start and grow small businesses. Before starting Docstoc, he was a partner in a venture consulting firm in Los Angeles where he worked with dozens of startups. He holds have a BA from UCSB and his JD/MBA from Pepperdine University, where he was the Student Body President of both Universities.