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