Sample%20Financial%20Excel%20Workbook

Sample%20Financial%20Excel%20Workbook - Revenue: Expenses:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Confidential Annual 03/16/2012 Revenue: 50.0% 11.8% 10.5% Expenses: 75.0% 10.0% 10.0% FOR THE ANNUAL PERIODS ENDED 12/31 Exhibit 1 2005 Annualized Page 1 2002 2003 2004 Actual 2005 2006 2007 2008 October 31, 2005 ACTUAL ACTUAL ACTUAL 10 mths Estimated Projected NET SALES $76,065 $358,502 $1,135,905 $1,816,792 $2,240,000 $3,400,000 $3,800,000 $4,200,000 Percent change 371% 217% 97% 87.1% 11.8% 10.5% DIRECT OPERATING EXPENSES: $2,305 $97,727 $2,537 $7,670 $9,000 $8,000 $8,500 $9,000 7402 Software Hosting $17,303 $23,000 $24,000 $26,000 $28,000 7615 Webhosting Services $4,691 $21,042 $47,572 $63,084 $75,000 $100,000 $110,000 $120,000 8005 Bad Debts $5,807 $849 $2,771 $5,000 $5,000 $5,000 $5,000 Depreciation $3,296 $4,251 $77,395 $40,000 $48,000 $60,000 $60,000 $60,000 SUBTOTAL Direct Operating Expense $10,292 $128,827 $128,353 $130,828 $160,000 $197,000 $209,500 $222,000 GROSS PROFIT $65,773 $229,675 $1,007,552 $1,685,964 $2,080,000 $3,203,000 $3,590,500 $3,978,000 % NET SALES 86.5% 64.1% 88.7% 92.8% 92.9% 94.2% 94.5% 94.7% OPERATING EXPENSES: 7000 Advertising $737 $33,700 $107,204 $116,009 $125,000 $220,000 $240,000 $260,000 7100 Bank Charges $1,180 $3,897 $21,049 $41,781 $52,000 $90,000 $100,000 $110,000 7405 Compensation of Officers $3,054 $0 $55,000 $55,000 $55,000 $177 $391 $3,028 $1,500 $2,000 $3,500 $3,500 $3,500 7421 Equipment Lease - Printer $4,384 $5,659 $8,000 $12,000 $12,000 $12,000 7440 Insurance $1,495 $3,763 ($3,623) ($6,000) $2,200 $2,200 $2,200 7450 Insurance-Workers Compensation $6,024 $6,000 $10,000 $10,000 $10,000 $5,704 $9,269 $11,777 $35,676 $50,000 $90,000 $100,000 $110,000 7465 Memberships $2,387 $4,000 $10,000 $10,000 $10,000 7470 Meals and Entertainment $137 $1,241 $5,339 $18,347 $21,000 $40,000 $40,000 $40,000 7490 Office Expenses $4,408 $6,110 $14,859 $67,260 $75,000 $130,000 $140,000 $150,000 7507 401K Employer Match $1,474 $9,210 $13,000 $20,000 $20,000 $20,000 7520 Promotional $3,101 $1,199 $2,000 $2,000 $2,000 $2,000 7530 Rent or Lease $3,690 $4,989 $22,816 $44,194 $55,000 $100,000 $110,000 $120,000 $121,227 $579,002 $749,420 $925,000 $1,620,000 $1,780,000 $1,960,000 7556 Payrol Tax Account $108,432 $135,000 $240,000 $260,000 $290,000 7558 Contractor Payment Acct $43,851 $4,878 $11,108 $27,099 $35,000 $60,000 $70,000 $80,000 7570 Supplies $905 $556 $5,911 $4,977 $6,000 $22,000 $25,000 $27,000 $579 $1,548 $2,000 $10,000 $12,000 $14,000 7600 Travel $1,044 $2,275 $26,118 $54,276 $65,000 $110,000 $120,000 $130,000 7610 Travel Meals $1,635 $2,000 $5,000 $7,000 $10,000 7620 Utilities $4,630 $12,871 $27,355 $29,735 $35,000 $60,000 $70,000 $80,000 7650 Miscel aneous $898 $3,918 $5,704 $49,042 $50,000 $90,000 $100,000 $110,000 $1,295 $12,287 $15,000 $15,000 $15,000 $15,000 7800 Shipping Expenses $4,570 $8,048 $12,000 $9,000 $10,000 $11,000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/16/2012 for the course OPM 325 taught by Professor Ruodu during the Spring '12 term at Drexel.

Page1 / 3

Sample%20Financial%20Excel%20Workbook - Revenue: Expenses:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online