| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | [Company Name] | [Logo] | |||||||||||||
2 | INCOME | January | February | March | April | May | June | July | August | September | October | November | December | YEAR | |
3 | Operating Income | ||||||||||||||
4 | Category 1 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $120 000,00 | |
5 | Category 2 | $10 000,00 | $10 000,00 | $10 000,00 | $10 000,00 | $10 000,00 | $10 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $60 000,00 | |
6 | Category 3 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $20 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $120 000,00 | |
7 | Category 4 | $25 000,00 | $25 000,00 | $25 000,00 | $25 000,00 | $25 000,00 | $25 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $150 000,00 | |
8 | Subtotal | $75 000,00 | $75 000,00 | $75 000,00 | $75 000,00 | $75 000,00 | $75 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $450 000,00 | |
9 | Operating Income | ||||||||||||||
10 | Interest Income | $5 000,00 | $5 000,00 | $5 000,00 | $5 000,00 | $5 000,00 | $5 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $30 000,00 | |
11 | Rental Income | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $12 000,00 | |
12 | Gifts Received | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $6 000,00 | |
13 | Subtotal | $8 000,00 | $8 000,00 | $8 000,00 | $8 000,00 | $8 000,00 | $8 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $48 000,00 | |
14 | TOTAL INCOME | $83 000,00 | $83 000,00 | $83 000,00 | $83 000,00 | $83 000,00 | $83 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $498 000,00 | |
15 | |||||||||||||||
16 | EXPENSES | January | February | March | April | May | June | July | August | September | October | November | December | YEAR | |
17 | Employee | ||||||||||||||
18 | Wages | $50 000,00 | $50 000,00 | $50 000,00 | $55 000,00 | $55 000,00 | $55 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $315 000,00 | |
19 | Benefits | 25% | $12 500,00 | $12 500,00 | $12 500,00 | $13 750,00 | $13 750,00 | $13 750,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $78 750,00 |
20 | Subtotal | $62 500,00 | $62 500,00 | $62 500,00 | $68 750,00 | $68 750,00 | $68 750,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $393 750,00 | |
21 | Office | ||||||||||||||
22 | Office Lease | $9 000,00 | $9 000,00 | $9 000,00 | $9 000,00 | $9 000,00 | $9 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $54 000,00 | |
23 | Gas | $300,00 | $300,00 | $300,00 | $200,00 | $100,00 | $100,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $1 300,00 | |
24 | Electric | $250,00 | $250,00 | $250,00 | $250,00 | $250,00 | $250,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $1 500,00 | |
25 | Water | $40,00 | $40,00 | $40,00 | $40,00 | $40,00 | $40,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $240,00 | |
26 | Telephone | $200,00 | $200,00 | $200,00 | $200,00 | $200,00 | $200,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $1 200,00 | |
27 | Internet | $150,00 | $150,00 | $150,00 | $150,00 | $150,00 | $150,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $900,00 | |
28 | Office Supplies | $200,00 | $200,00 | $200,00 | $200,00 | $200,00 | $200,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $1 200,00 | |
29 | Security | $500,00 | $500,00 | $500,00 | $500,00 | $500,00 | $500,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $3 000,00 | |
30 | Subtotal | $10 640,00 | $10 640,00 | $10 640,00 | $10 540,00 | $10 440,00 | $10 440,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $63 340,00 | |
31 | Marketing | ||||||||||||||
32 | Web Site Hosting | $400,00 | $400,00 | $400,00 | $400,00 | $400,00 | $400,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $2 400,00 | |
33 | Web Site Updates | $250,00 | $250,00 | $250,00 | $250,00 | $250,00 | $250,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $1 500,00 | |
34 | Marketing Events | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $12 000,00 | |
35 | Miscellaneous | $100,00 | $100,00 | $100,00 | $100,00 | $100,00 | $100,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $600,00 | |
36 | Subtotal | $2 750,00 | $2 750,00 | $2 750,00 | $2 750,00 | $2 750,00 | $2 750,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $16 500,00 | |
37 | Training/Travel | ||||||||||||||
38 | Training Classes | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $6 000,00 | |
39 | Training-Related Travel | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $1 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $6 000,00 | |
40 | Subtotal | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $2 000,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $12 000,00 | |
41 | TOTAL EXPENSES | $77 890,00 | $77 890,00 | $77 890,00 | $84 040,00 | $83 940,00 | $83 940,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $0,00 | $485 590,00 | |