attached accounting/finance forcasting assignment

profileiamnickok
jones_electrical_case.xls

Exhibits

Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006, Exhibit 2 Balance Sheet as of December 31, 2004-2006
and for the first quarter 2007 (thousands of dollars) and March 31, 2007 (thousands of dollars)
Exhibit 1 Exhibit 2
First Quarter First Quarter
2004 2005 2006 2007 a 2004 2005 2006 2007
Net sales $1,624 $1,916 $2,242 $608 Cash $45 $53 $23 $32
Cost of goods sold $1,304 $1,535 $1,818 $499 Accounts receivable $187 $231 $264 $290
Gross profit on sales $320 $381 $424 $109 Inventory $243 $278 $379 $432
Total current assets $475 $562 $666 $755
Operating expense b $272 $307 $347 $94
Interest expense $27 $30 $31 $8 Property & equipment $187 $202 $252 $252
Net income before taxes $21 $44 $46 $7 Accumulated depreciation ($74) ($99) ($134) ($142)
Total PP&E, net $113 $103 $118 $110
Provision for income taxes $7 $15 $16 $2
Net income $14 $29 $30 $5 Total assets $588 $665 $784 $865
Accounts payable $36 $42 $120 $203
Line of credit payable $149 $214 $249 $250
Accrued expenses $13 $14 $14 $12
Long term debt, current portion $24 $24 $24 $24
Current liabiliities $222 $294 $407 $489
Long-term debt $182 $158 $134 $128
Total liabilities $404 $452 $541 $617
Net worth $184 $213 $243 $248
Total liabilities and net worth $588 $665 $784 $865