StudentSpreadsheet

StudentSpreadsheet - HANSSON PRIVATE LABEL Income Statement...

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

View Full Document Right Arrow Icon
HANSSON PRIVATE LABEL Income Statement Operating Results: 2003 2004 2005 2006 2007 Revenue $503.4 $543.7 $587.2 $636.1 $680.7 Less: Cost of Goods Sold 405.2 432.3 496.2 513.4 558.2 Gross Profit 98.2 111.4 91.0 122.7 122.5 Less: 37.8 44.6 45.8 51.5 49.0 EBITDA 60.4 66.8 45.2 71.2 73.5 Less: Depreciation 6.8 6.2 6.0 5.9 6.1 EBIT 53.6 60.6 39.2 65.3 67.4 Less: Interest Expense 5.5 5.8 5.9 5.3 3.3 EBT 48.1 54.8 33.3 60.0 64.1 Less: Taxes 19.2 22.0 13.3 24.0 25.6 Net Income $28.9 $32.8 $20.0 $36.0 $38.5 Margins: Revenue Growth NA 8.0% 8.0% 8.3% 7.0% Gross Margin 19.5% 20.5% 15.5% 19.3% 18.0% 7.5% 8.2% 7.8% 8.1% 7.2% EBITDA Margin 12.0% 12.3% 7.7% 11.2% 10.8% EBIT Margin 10.6% 11.1% 6.7% 10.3% 9.9% Net Income Margin 5.7% 6.0% 3.4% 5.7% 5.7% Effective Tax Rate 39.9% 40.1% 39.9% 40.0% 39.9% Harvard Business Publishing
Background image of page 1

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

View Full DocumentRight Arrow Icon
HANSSON PRIVATE LABEL Balance Sheet Assets: 2003 2004 2005 2006 2007 $4.3 $5.1 $4.8 $7.8 $5.0 Accounts Receivable 62.1 70.1 78.8 87.1 93.3 Inventory 57.7 58.0 61.2 61.9 67.3 Total Current Assets 124.1 133.2 144.8 156.8 165.6 201.4 202.9 203.1 202.3 204.4 Other Non-Current Assets 12.3 12.1 11.8 12.5 10.8 Total Assets $337.8 $348.2 $359.7 $371.6 $380.8 $42.2 $45.0 $51.6 $53.4 $58.1 Long-Term Debt 91.6 82.8 73.8 65.8 54.8 Owners' Equity 204.0 220.4 234.3 252.4 267.9 $337.8 $348.2 $359.7 $371.6 $380.8 Net Working Capital: Accounts Receivable 62.1 70.1 78.8 87.1 93.3 Plus: Inventory 57.7 58.0 61.2 61.9 67.3 Less: 42.2 45.0 51.6 53.4 58.1 Net Working Capital 77.6 83.1 88.4 95.6 102.5 Net Working Capital/Revenue 15.4% 15.3% 15.1% 15.0% 15.1% Days Sales Outstanding 44.4x 46.4x 48.3x 49.3x 49.3x Days Sales Inventory 41.3x 38.4x 37.5x 35.0x 35.6x
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/08/2011 for the course FIN 311 taught by Professor Layish during the Spring '08 term at Binghamton.

Page1 / 7

StudentSpreadsheet - HANSSON PRIVATE LABEL Income Statement...

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

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