analysis 2

profileA112233A
test2.xls

Sheet1

RATIO ANALYSIS SPREADSHEET = Pos,Neu,Neg
Company KSS
2,019 2,018 2,017 Industry
Average
BALANCE SHEET RATIOS: Stability (Staying Power) Access csimarket.com and query by stock symbol
1 Current Ability to meet current obligations
Current Assets 4,835,000 1.77 5,380,000 1.99 5,247,000 1.76
Current Liabilities 2,730,000 2,709,000 2,974,000 1.09
2 Debt-to-Equity Margin of Safety to Creditors
Total Liabilities 6,942,000 1.26 7,970,000 1.47 8,397,000 1.62
Equity 5,527,000 5,419,000 5,177,000 0.05
INCOME STATEMENT RATIOS: Profitability (Earning Power)
3 Gross Margin Gross Profit expressed as a % of Sales
Gross Profit 8,030,000 39.7% 7,908,000 39.4% 7,737,000 39.3%
Sales 20,229,000 20,084,000 19,681,000 31.9%
4 Operating Profit Margin Operating Profit expressed as a % of Sales
Operating Profit 1,433,000 1,438,000 1,369,000
Sales 20,229,000 7.1% 20,084,000 7.2% 19,681,000 7.0% 5.8%
5 Net Margin Net Profit expressed as a % of Sales
Net Income 801,000 4.0% 859,000 4.3% 556,000 2.8%
Sales 20,229,000 20,084,000 19,681,000 3.8%
ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
6 Earnings Quality Measures cash generated from sales; higher % the better
Cash flow from Operations 2,107,000 263% 1,691,000 197% 2,153,000 387%
Net Income 801,000 859,000 556,000 n/a
7 Return on Assets Measures the profitability of using the assets
Net Income 801,000 6.4% 859,000 6.4% 556,000 4.1%
Total Assets 12,429,000 13,389,000 13,574,000 6.5%
8 Return on Equity Measures the profitability of the stockholders investment
Net Income 801,000 14.5% 859,000 15.9% 556,000 10.7%
Equity 5,527,000 5,419,000 5,177,000 18.9%
ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
9 Inventory Turnover Measures the efficiency of moving the inventory
Cost of Revenue/Goods Sold 12,199,000 4 12,176,000 3 11,944,000 3
Inventory 3,475,000 3,542,000 3,795,000 5
10 Inventory Turn-Days Average # of days it takes to move inventory
360 360 102.55 360 104.72 360 114.38
Inventory Turnover 4 3 3 79.82
11 Accounts Receivable Turnover Measures the efficiency of collecting Accounts Receivable
Sales 20,229,000 697.55 20,084,000 323.94 19,681,000 728.93 1,502.99
Accounts Receivable 29,000 62,000 27,000
12 Accounts Receivable Turn-Days Average # of days it takes to collect Accounts Receivable
360 360 1 360 1 360 0
Accts. Rec. Turnover 698 324 729 0
13 Accounts Payable Turnover Measures the efficiency of paying Accounts Payable
Cost of Revenue/Goods Sold 12,199,000 10.28 12,176,000 9.58 11,944,000 7.93
Accounts Payable 1,187,000 1,271,000 1,507,000 n/a
14 Average Payment Period Average # of days it takes to pay Accounts Payable
360 360 35 360 38 360 45
Accts. Pay. Turnover 10 10 8

Sheet2

Sheet3