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 / Revenue
Operating Profit Margin % 25.60% 7.2% Operating Income / Net Sales
Data from Financial Statements 2003 2004 2005 2006
Inventories 117.0 121.1 193.4 191.9
Accounts Recievable 153.2 158.9 175.1 224.8
Total current assets 316.5 338.0 414.5 435.1
Total assets 44.8-58.9-78.1-96.4
Accounts payable 53.8-54.7-86.2-84.2
Total current liabilities 415.1 451.6 578.8 615.7
Total liabilities (Total debt) 468.9 506.3 665.0 699.9
Total shareholders equity (total equity) 884.0 957.9-1,243.7-1,315.6
Net revenue (Sales) 985.0-1,040.0-1,236.0-1,305.0
Sales per day 2.69 2.85 3.38 3.57
Cost of revenue (Cost of goods sold) 748.6 774.8 928.2 978.8
Cost of goods per day 2.05 2.12 2.54 2.68
Gross margin (Gross profit) 236.4 265.2 307.8 326.3
Operating income (Operating profit; EBIT) 133.4 181.0 313.0 334.2
Interest expense 7.0-6.0-5.0-4.0
Net income (Net profit) 29.5-27.0-31.0-35.2
- Enter data from financial statements, using cell addresses from the BS and IS tabs
- Calculate all ratios for 2006, using cell addresses and formulas
You’re 81% through this paper. Sign up to read the full paper.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.