Spreadsheet: 142596d1329924606-vlookup-and-col_index_num-issue-financial-statements_vlookup_question
Sheet: Income Statement

 |  |  |  |  |  |  |  |  | 2012 Budget
 |  |  |  |  | Jan 2012 | Feb 2012 | Mar 2012 | Apr 2012 | May 2012 | Jun 2012 | Jul 2012 | Aug 2012 | Sep 2012 | Oct 2012 | Nov 2012 | Dec 2012
Revenue
 | A |  |  |  | 100000000
 | B |  |  |  | 60000
 | C |  |  |  | 3000
 | D |  |  |  | 20000
 | E |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | G |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Cost of Goods Sold
 | 1 |  |  |  | 10
 | 2 |  |  |  | 2.2
 | 3 |  |  |  | 20
 | 4 |  |  |  | 60
 | 5 |  |  |  | 68
 | 6 |  |  |  | 70
 | 7 |  |  |  | 50
 | 8 |  |  |  | 0
Total COGS
Gross Margin
R&D Expense
 | Payroll |  |  |  | 1000000
 | Bonus / Commission |  |  |  | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Payroll Tax |  |  |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 | Variable Expense |  |  |  | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600
 | R&D Other Expense |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total R&D Expense |  |  |  |  |  | 45352.58216216216 | 46776.03213706757 | 49824.03121208739 | 51438.1144427348 | 51668.4651015847 | 55406.72154220018 | 55897.41485498079 | 58069.14201685814 | 56005.71983090938 | 56864.84959543919 | 852543.7409459461
Sales Expense
 | Payroll |  |  |  | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
 | Bonus / Commission |  |  |  | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000 | 500000
 | Payroll Tax |  |  |  | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Travel & Entertainment |  |  |  | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90 | 90
 | Marketing |  |  |  | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300
 | Software Expense |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Total Sales Expsense
Administrative Expense
 | Payroll |  |  |  | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000
 | Bonus / Commission |  |  |  | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000
 | Payroll Tax |  |  |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | Recruiting Expense |  |  |  | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160 | 160
 | Professional Fees |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Insurance Expense |  |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | Rent Expense |  |  |  | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500
 | Utilities Expense |  |  |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | Employee Benefit Plan Expense |  |  |  | 0 | 0 | 0 | 0 | 0 | 1600.3 | 0 | 0 | 0 | 0 | 0 | 130000
 | Office Expense |  |  |  | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000 | 600000
 | Office Equipment |  |  |  | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5
 | Office Supplies |  |  |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
 | Telephone & Internet Expense |  |  |  | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900
 | Depreciation Expense |  |  |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | Bad Debt Expense |  |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 | Other |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Total Admin Expense
Total Operating Expense
Operating Profit (EBIT)
EBITDA
Net Income