Startup  Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May June Yearly
Sales
  Online 100 200 400 500 1,000 1,000 1,000 1,100 1,200 1,300 1,500 1,700 11,000
  Festivals and fundraisers 0 0 0 300 2,500 300 0 0 0 0 300 0 3,400
   Less Fundraising discount 0 0 0 (60) (500) (60) 0 0 0 0 (60) 0 (680)
Net Sales 100 200 400 740 3,000 1,240 1,000 1,100 1,200 1,300 1,740 1,700 13,720
 
COGS 0.6 60 120 240 480 2,100 780 600 660 720 780 1,080 1,020 8,640
Gross Profit 40 80 160 260 900 460 400 440 480 520 660 680 5,080
Expenses
Payroll 0 0 0 0 0 0 0 0 0 0 0 0 0
Marketing
Display ad Renewal magazine 75 75 75 75 75 75 75 75 75 75 75 75 900
Catalog 229 229 229 229 229 229 229 229 229 229 229 229 2,750
Depreciation 26 26 26 26 26 26 26 26 26 26 26 26 310
Insurance 300 0 0 0 0 0 300 0 0 0 0 0 600
Legal & Professional Services: 250 500 750
Office Expense: 50 50 50 50 50 50 50 50 50 50 50 50 50
Taxes
   State Excise tax (3% of sales) 3 6 12 22 90 37 30 33 36 39 52 51 412
   L&I ($.10/hour, 160 hrs/mo) 16 16 16 16 16 16 16 16 16 16 16 16 192
Telephone 50 50 50 50 50 50 50 50 50 50 50 50 600
Travel 0 0 0 50 150 50 0 0 0 0 50 0 300
Utilities 15 15 15 15 15 15 15 15 15 15 15 15 15
Web hosting and e-commerce 42 43 46 48 55 55 55 57 58 60 63 66 645
Total Expenses 1,056 510 519 581 756 603 846 551 555 1,060 626 578 8,239
Net Income Before Taxes (1,016) (430) (359) (321) 144 (143) (446) (111) (75) (540) 34 103 (3,159)
Beginning Cash          -   4,000 584 566 445 63 2,083 2,383 1,936 2,024 1,911 1,310 1,682 2,062
Cash In    5,900 100 200 400 740 3,000 1,240 1,000 1,100 1,200 1,300 1,740 1,700
Cash Out:  Startup    1,300 0 0 0 0 0 0 0 0 0 0 0 0
                        Inventory purchases       600 0 0 300 780 600 660 720 780 1,080 1,020 1,080 1,080
                      Expenses 3,517 218 221 273 380 280 530 232 233 735 288 241
                       Taxes          -   0 0 0 69 0 0 197 0 0 147 0 0
Total Cash Out    1,900 3,517 218 521 1,122 980 940 1,447 1,012 1,313 1,902 1,368 1,321
Ending Cash    4,000 584 566 445 63 2,083 2,383 1,936 2,024 1,911 1,310 1,682 2,062