Bs - Tableau Balance Sheet

BS - Tableau Balance Sheet of the Holly Fashions Company: 2003-2006 Apple Inc.

Income Statement Holly Fashions Income Statements: 2003-2006 (in 000s) (in millions) (in 000s) mos to 2003 2004 2005 2006 Fiscal years ended Sept 26, 2010 6/25/11 2010 2009 2008 2007 2006 2003 2004 2005 2006 ASSETS: Net sales 79,979 65,225 42,905 37,491 24,006 19,315 Sales 985.0-1,040.0-1,236.0-1,305.0 Cash 40.4-51.9-38.6-10.6 Cost of sales 47,541 39,541 25,683 24,294 15,852 13,717 Cost of Goods 748.6 774.8 928.2 978.8 Receivables 153.2 158.9 175.1 224.8 Inventory 117.0 121.1 193.4 191.9 Operating expenses: Gross margin 236.4 265.2 307.8 326.3 Other current assets 5.9-6.2-7.4-7.8 Research and development 1,784 1,782 1,333 1,109 782 712 Total current assets 316.5 338.0 414.5 435.1 Selling, general, and administrative 5,574 5,517 4,149 3,761 2,963 2,433 Operating expenses: Administrative 169.4 202.8 236.1 249.3 Gross fixed assets 44.8-58.9-78.1-96.4 Depreciation 10.8-11.4-13.6-14.4 Accumulated depreciation (12.0) (23.4) (37.0) (51.4) Total operating expenses 7,358 7,299 5,482 4,870 3,745 3,145 Net fixed assets 32.8-35.5-41.1-45.0 Operating income 56.1-51.0-58.1-62.6 Interest 7.0-6.0-5.0-4.0 Total assets 349.3 373.5 455.5 480.1 Provision for income taxes 6,115 4,527 3,831 2,828 1,512 829 EBT 49.1-45.0-53.1-58.6 LIABILITIES & NET WORTH Net income Taxes 19.7-18.0-21.2-23.5 Accounts payable 53.8-54.7-86.2-84.2 Debt due 10.0-10.0-10.0-10.0 Net income 29.5-27.0-31.9-35.2 Accruals 19.7-26.0-24.7-26.1 Total current liabilities 83.5-90.7 120.9 120.3 Long-term debt 60.0-50.0-40.0-30.0 Total liabilities 143.5 140.7 160.9 150.3 Common stock 150.0 150.0 180.0 180.0 Retained earnings 55.8-82.8 114.6 149.8 Total net worth (shareholders equity) 205.8 232.8 294.6 329.8 Total liabilities & net worth 349.3 373.5 455.5 480.1 IS - Tableau 1 Holly Fashions Income Statements: 2003-2006 (in 000s) 2003 2004 2005 2006 Sales 985.0-1,040.0-1,236.0-1,305.0 Cost of Goods 748.6 774.8 928.2 978.8 Gross margin 236.4 265.2 307.8 326.3 Operating expenses: Administrative 169.4 202.8 236.1 249.3 Depreciation 10.8-11.4-13.6-14.4 Operating income 56.1-51.0-58.1-62.6 Interest 7.0-6.0-5.0-4.0 EBT 49.1-45.0-53.1-58.6 Taxes 19.7-18.0-21.2-23.5 Net income 29.5-27.0-31.9-35.2 ratios - Tableau 1 Financial Management 2012 Name Due December 16th 2012 Holly Fashions Industry Average 2003 2004 2005 2006 2003-06 Formula for ratio RATIOS Current Ratio 70.60% 1.7 Current assets / Current liabilities Quick ratio (Acid-test ratio) 2.02 0.8 Cash + Investments Recievables / Current Liabilities Debt Ratio (Debt to Total Equity) 7.26-57.0% Total Debt / Total Assets Times interest earned 13.36 3.9% of Interest Inventory Turnover (times per year) 5.1-6.0 Cost of Goods / Inventories Days receivables outstanding (average collection period) 62.8-50.0 Accounts receivable / total sales *Number of days Average payment period (days purchases outstanding) 23.58-25.0 Accounts Payable / Average Purchases per day Gross profit margin (Gross margin) 24.90% 26.0% Sales-Costs of Goods Sold / Sales Net Profit Margin (Profit Margin) % 56.00% 3.1% Net Income /.