Please help check my calculation, and help complete the RIOC and statement of cash flow. Thank you!
Common 2004 100.0% 80.3% 19.7% 2005 100.0% 80.1% 19.9% First Quarter 2006 2007 100.0% 100.0% 81.1% 82.1% 18.9% 17.9% 16.7% 1.7% 1.3% 16.0% 1.6% 2.3% 15.5% 1.4% 2.1% 15.5% 1.3% 1.2% 0.5% 0.8% 0.8% 1.5% 0.7% 1.3% 0.4% 0.8% Common 1 Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006, 2 and for the first quarter 2007 (thousands of dollars) 3 4 Exhibit 1 5 6 First Quarter 7 2004 2005 2006 2007 8 Net sales $1,624 $1,916 $2,242 $608 9 Cost of goods sold $1,304 $1,535 $1,818 $499 10 Gross profit on sales $320 $381 $424 $109 11 b 12 Operating expense $272 $307 $347 $94 13 Interest expense $27 $30 $31 $8 14 Net income before taxes $21 $44 $46 $7 15 16 Provision for income taxes $7 $15 $16 $2 17 Net income $14 $29 $30 $5 18 19 Exhibit 2 Balance Sheet as of December 31, 2004-2006 20 and March 31, 2007 (thousands of dollars) 21 22 Exhibit 2 23 24 First Quarter 25 2004 2005 2006 2007 26 Cash $45 $53 $23 $32 27 Accounts receivable $187 $231 $264 $290 28 Inventory $243 $278 $379 $432 29 Total current assets $475 $562 $666 $755 30 31 Property & equipment $202 $252 $252 32 Accumulated depreciation ($74) ($99) ($134) ($142) 33 Total PP&E, net $113 $103 $118 $110 34 35 Total assets $588 $665 $784 $865 36 37 Accounts payable $36 $42 $120 $203 38 Line of credit payable $149 $214 $249 $250 39 Accrued expenses $13 $14 $14 $12 40 Long term debt, current portioi $24 $24 $24 $24 41 Current liabilities $222 $294 $407 $489 42 43 Long-term debt $182 $158 $134 $128 44 Total liabilities $404 $452 $541 $617 45 46 Net worth $184 $213 $243 $248 47 Total liabilities and net worth $588 $665 $784 $865 48 49 2005 2.9% 2004 7.7% 31.8% 41.3% 80.8% 8.0% 34.8% 41.8% 84.5% First Quarter 2006 2007 3.7% 33.7% 33.6% 48.3% 50.0% 84.9% 87.3% $187 31.8% -12.6% 19.2% 30.4% -14.9% 15.5% 32.2% -17.1% 15.1% 29.1% -16.4% 12.7% 100.0% 100.0% 100.0% 100.0% 6.1% 25.4% 2.2% 4.1% 6.3% 32.2% 2.1% 3.6% 44.2% 15.3% 31.8% 1.8% 3.1% 51.9% 23.5% 28.9% 1.4% 2.8% 56.5% 37.7% 31.0% 68.7% 23.8% 68.0% 17.1% 69.0% 14.8% 71.3% 31.3% 100.0% 32.0% 100.0% 31.0% 100.0% 28.6% 100.0% Ratio Analysis Play Area First Quarter 2007 2004 2005 2006 2.14 0.57 1.91 0.63 1.64 0.53 1.54 0.52 6.68 42.00 14.37 2.76 6.90 44.00 18.61 2.88 5.92 43.00 19.00 2.86 1.41 43.00 5.52 0.701 Liquidity Current Quick Asset Mangement Inventory turnover DSO F/A turnover Total asset turnover Debt Management Total debt to total capital Times-Interest Earned Profitability Operating Margin Profit Margin ROA ROE ROIC BEP 0.66 1.79 0.65 2.48 0.63 2.47 0.62 1.93 2.95% 0.85% 2.34% 7.46% 3.86% 1.50% 4.32% 13.49% 3.44% 1.34% 3.83% 12.35% 2.44% 0.78% 0.55% 1.91% 8.15% 11.13% 9.85% 1.72% 1 2004 $45 $187 $243 $475 2005 Change $53 $8 $231 $44 $278 $35 $562 $87 $187 ($74) $113 $202 ($99) $103 $15 ($25) ($10) 2 3 Cash 4 Accounts receivable 5 Inventory 6 Total current assets 7 8 Property & equipment 9 Accumulated depreciation 10 Total PP&E, net 11 12 Total assets 13 14 Accounts payable 15 Line of credit payable 16 Accrued expenses 17 Long term debt, current portion 18 Current liabiliities 19 20 Long-term debt 21 Total liabilities $588 $665 $77 $36 $149 $13 $24 $222 $42 $214 $14 $24 $294 $6 $65 $1 $0 $72 $182 $404 $158 $452 ($24) $48 22 $29 23 Net worth 24 Total liabilities and net worth 25 $184 $588 $213 $665 $77 2005 $53 $231 $278 $562 2006 $23 $264 $379 $666 Change ($30) $33 $101 $104 2006 $23 $264 $379 $666 2007 Change $32 $9 $290 $26 $432 $54 $755 $89 $202 ($99) $103 $252 ($134) $118 $50 ($35) $15 $252 ($134) $118 $252 ($142) $110 $0 ($8) ($8) $665 $784 $119 $784 $865 $81 $78 $35 $42 $214 $14 $24 $294 $120 $249 $14 $24 $407 $1 $120 $249 $14 $24 $407 $203 $250 $12 $24 $489 $83 $1 ($2) $0 $82 $0 $113 $158 $452 $134 $541 ($24) $89 $134 $541 $128 $617 ($6) $76 $213 $665 $243 $784 $30 $119 $243 $784 $248 $865 $5 $81 Q1 2007 $ 25 26 Statements of Cash Flows: 2005 and 2006 and through Q1 2007 27 28 2005 2006 2005-06 29 30 Net Income $14 $29 $15 31 Depreciation $74 $99 $25 32 Inventory ($243) ($278) ($35) 33 Accounts receivable $187 $231 $44 34 Trade credit (Accounts payable) $36 $42 $6 35 Accrued expenses $14 $14 $0 36 Cash flows from operations $82 $137 $55 37 38 Capital expenditures 39 Cash flows from investing activities $0 $0 $0 40 41 Bank borrowing (Line of credit) $214 $249 $35 42 Reduce long-term debt 43 Cash flow from financing activities $214 $249 $35 44 45 Increase / (decrease) in cash $296 $386 $90 46 47 5 $142 ($432) $290 $203 $12 $220 $0 $250 $250 $470 Common 2004 100.0% 80.3% 19.7% 2005 100.0% 80.1% 19.9% First Quarter 2006 2007 100.0% 100.0% 81.1% 82.1% 18.9% 17.9% 16.7% 1.7% 1.3% 16.0% 1.6% 2.3% 15.5% 1.4% 2.1% 15.5% 1.3% 1.2% 0.5% 0.8% 0.8% 1.5% 0.7% 1.3% 0.4% 0.8% Common 1 Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006, 2 and for the first quarter 2007 (thousands of dollars) 3 4 Exhibit 1 5 6 First Quarter 7 2004 2005 2006 2007 8 Net sales $1,624 $1,916 $2,242 $608 9 Cost of goods sold $1,304 $1,535 $1,818 $499 10 Gross profit on sales $320 $381 $424 $109 11 b 12 Operating expense $272 $307 $347 $94 13 Interest expense $27 $30 $31 $8 14 Net income before taxes $21 $44 $46 $7 15 16 Provision for income taxes $7 $15 $16 $2 17 Net income $14 $29 $30 $5 18 19 Exhibit 2 Balance Sheet as of December 31, 2004-2006 20 and March 31, 2007 (thousands of dollars) 21 22 Exhibit 2 23 24 First Quarter 25 2004 2005 2006 2007 26 Cash $45 $53 $23 $32 27 Accounts receivable $187 $231 $264 $290 28 Inventory $243 $278 $379 $432 29 Total current assets $475 $562 $666 $755 30 31 Property & equipment $202 $252 $252 32 Accumulated depreciation ($74) ($99) ($134) ($142) 33 Total PP&E, net $113 $103 $118 $110 34 35 Total assets $588 $665 $784 $865 36 37 Accounts payable $36 $42 $120 $203 38 Line of credit payable $149 $214 $249 $250 39 Accrued expenses $13 $14 $14 $12 40 Long term debt, current portioi $24 $24 $24 $24 41 Current liabilities $222 $294 $407 $489 42 43 Long-term debt $182 $158 $134 $128 44 Total liabilities $404 $452 $541 $617 45 46 Net worth $184 $213 $243 $248 47 Total liabilities and net worth $588 $665 $784 $865 48 49 2005 2.9% 2004 7.7% 31.8% 41.3% 80.8% 8.0% 34.8% 41.8% 84.5% First Quarter 2006 2007 3.7% 33.7% 33.6% 48.3% 50.0% 84.9% 87.3% $187 31.8% -12.6% 19.2% 30.4% -14.9% 15.5% 32.2% -17.1% 15.1% 29.1% -16.4% 12.7% 100.0% 100.0% 100.0% 100.0% 6.1% 25.4% 2.2% 4.1% 6.3% 32.2% 2.1% 3.6% 44.2% 15.3% 31.8% 1.8% 3.1% 51.9% 23.5% 28.9% 1.4% 2.8% 56.5% 37.7% 31.0% 68.7% 23.8% 68.0% 17.1% 69.0% 14.8% 71.3% 31.3% 100.0% 32.0% 100.0% 31.0% 100.0% 28.6% 100.0% Ratio Analysis Play Area First Quarter 2007 2004 2005 2006 2.14 0.57 1.91 0.63 1.64 0.53 1.54 0.52 6.68 42.00 14.37 2.76 6.90 44.00 18.61 2.88 5.92 43.00 19.00 2.86 1.41 43.00 5.52 0.701 Liquidity Current Quick Asset Mangement Inventory turnover DSO F/A turnover Total asset turnover Debt Management Total debt to total capital Times-Interest Earned Profitability Operating Margin Profit Margin ROA ROE ROIC BEP 0.66 1.79 0.65 2.48 0.63 2.47 0.62 1.93 2.95% 0.85% 2.34% 7.46% 3.86% 1.50% 4.32% 13.49% 3.44% 1.34% 3.83% 12.35% 2.44% 0.78% 0.55% 1.91% 8.15% 11.13% 9.85% 1.72% 1 2004 $45 $187 $243 $475 2005 Change $53 $8 $231 $44 $278 $35 $562 $87 $187 ($74) $113 $202 ($99) $103 $15 ($25) ($10) 2 3 Cash 4 Accounts receivable 5 Inventory 6 Total current assets 7 8 Property & equipment 9 Accumulated depreciation 10 Total PP&E, net 11 12 Total assets 13 14 Accounts payable 15 Line of credit payable 16 Accrued expenses 17 Long term debt, current portion 18 Current liabiliities 19 20 Long-term debt 21 Total liabilities $588 $665 $77 $36 $149 $13 $24 $222 $42 $214 $14 $24 $294 $6 $65 $1 $0 $72 $182 $404 $158 $452 ($24) $48 22 $29 23 Net worth 24 Total liabilities and net worth 25 $184 $588 $213 $665 $77 2005 $53 $231 $278 $562 2006 $23 $264 $379 $666 Change ($30) $33 $101 $104 2006 $23 $264 $379 $666 2007 Change $32 $9 $290 $26 $432 $54 $755 $89 $202 ($99) $103 $252 ($134) $118 $50 ($35) $15 $252 ($134) $118 $252 ($142) $110 $0 ($8) ($8) $665 $784 $119 $784 $865 $81 $78 $35 $42 $214 $14 $24 $294 $120 $249 $14 $24 $407 $1 $120 $249 $14 $24 $407 $203 $250 $12 $24 $489 $83 $1 ($2) $0 $82 $0 $113 $158 $452 $134 $541 ($24) $89 $134 $541 $128 $617 ($6) $76 $213 $665 $243 $784 $30 $119 $243 $784 $248 $865 $5 $81 Q1 2007 $ 25 26 Statements of Cash Flows: 2005 and 2006 and through Q1 2007 27 28 2005 2006 2005-06 29 30 Net Income $14 $29 $15 31 Depreciation $74 $99 $25 32 Inventory ($243) ($278) ($35) 33 Accounts receivable $187 $231 $44 34 Trade credit (Accounts payable) $36 $42 $6 35 Accrued expenses $14 $14 $0 36 Cash flows from operations $82 $137 $55 37 38 Capital expenditures 39 Cash flows from investing activities $0 $0 $0 40 41 Bank borrowing (Line of credit) $214 $249 $35 42 Reduce long-term debt 43 Cash flow from financing activities $214 $249 $35 44 45 Increase / (decrease) in cash $296 $386 $90 46 47 5 $142 ($432) $290 $203 $12 $220 $0 $250 $250 $470
