1

2
3
4
5
6
7
8
9
10
11
12

Sr. Financial Metrics

1 Return of Equity (ROE)
2 Return of Assets (ROA)

3 Return of Financial leverage (ROFL)

4 Accounts Payable Turnover (APT)
5 Profit Margin
6 Asset Turnover
7 Accounts Receivable Turnover (ART)
8 Collecting Money from Sales
9 Inventory Turnover (INVT)
10 Inventory Sat with Firm
11 Property, Plant and Equipment Turnover (PPET)
12 Cash to Cash (C2C) cycle

13 SG&A / Revenue
 Parameters Walmart
Tax Rate 0.35
Net Income 17,756
Average share holder equity 76,343
Interest Expense 2,251
Avg total asset 203,105
Cost of goods sold 352,488
Accounts payable 59,099
Sales revenue 469,162
Accounts Receivable 6,768
Inventories 43,803
Property, plant and equipment 116,681
Selling, General, and Administrative Expense 88,873

Formula Walmart
= Net income/Average shareholder equity 23.26%
= Earnings before interest/Average total asset
9.46%
= (Net income + [ Interest Expense * (1-Tax Rate)])/Average total asset
= ROE -ROA 14%
= Cost of goods sold/ Accounts Payable 5.96
= Earnings before interest/ Sales revenue 4.10%
= Sales revenue / total assets 2.31
= Sales revenue/ Accounts Receivable 69.32
= 52/ ART 0.75
= Cost of goods sold/ Inventories 8.05
= 52/ INVT 6.46
= Sales revenue/PPE 4.02
-0.03
= (-Weeks Payable/APT) + (Weeks inventory/INVT) + (Weeks Receivable /ART)
-1.51
=SG&A / revenue 18.94%
Macy’s Amazon Norstorm Blue Nil Zales Tiffany
0.35 0.35 0.35 Net sales 400 1,888.00 3,794.20
1,198 274 735 Cost of sales 325 903.6 1,631.00
6,051 9,746 1,913 Gross profit 75.1 984.4 2,163.20
425 141 160 Selling, general, and admini 62.8 916.3 1,466.10
20,991 40,159 8,089 Operating income 12.3 35.1 697.2
16,538 54,181 7,432 Net income 8.4 10 416.1
4,951 21,821 1,011 Cash and cash equivalents 87 17.1 504.8
27,686 74,452 12,148 Net receivables 3.5 — 174
371 4,767 2,356 Inventories 33.3 767.5 2,234.30
5,308 7,411 1,360 Total current assets 125.9 837.2 3,151.60
8,196 10,949 2,579 Property and equipment 7.9 108.9 818.8
8,440 19,526 3,371 Other assets 12.1 241.2 660.4
Total assets 145.9 1,187.30 4,630.90
Accounts payable 116.2 220.6 295.4
Stockholder equity 14.1 185.3 2,611.30

Macy’s Amazon Norstorm

19.80% 2.81% 38.42%
7.02% 0.91% 10.37%

13% 2% 28%
3.34 2.48 7.35
5.32% 0.49% 6.91%
1.32 1.85 1.50
74.63 15.62 5.16
0.70 3.33 10.08
3.12 7.31 5.46
16.69 7.11 9.52
3.38 6.80 4.71
0.03 -0.20 0.24 years
1.82 -10.50 12.53 weeks
30.48% 26.23% 27.75%
 1
2
3
4
5
6
7
8
9
10
11
12

Sr. Financial Metrics

1 Return of Equity (ROE)
2 Return of Assets (ROA)

3 Return of Financial leverage (ROFL)

4 Accounts Payable Turnover (APT)
5 Profit Margin
6 Asset Turnover
7 Accounts Receivable Turnover (ART)
8 Collecting Money from Sales
9 Inventory Turnover (INVT)
10 Inventory Sat with Firm
11 Property, Plant and Equipment Turnover (PPET)
12 Cash to Cash (C2C) cycle

13 SG&A / Revenue
 Parameters Blue Nile
Tax Rate 0.35
Net Income 8.4
Average share holder equity 14.1
Interest Expense 1.0
Avg total asset 145.9
Cost of goods sold 325.0
Accounts payable 116.2
Sales revenue 400.0
Accounts Receivable 3.5
Inventories 33.3
Property, plant and equipment 7.9
Selling, General, and Administrative Expense 62.8

Formula Blue Nile

= Net income/Average shareholder equity 59.57%
= Earnings before interest/Average total asset
6.20%
= (Net income + [ Interest Expense * (1-Tax Rate)])/Average total asset
= ROE -ROA 53.37%
= Cost of goods sold/ Accounts Payable 2.80
= Earnings before interest/ Sales revenue 2.26%
= Sales revenue / total assets 2.74
= Sales revenue/ Accounts Receivable 114.29
= 52/ ART 0.46
= Cost of goods sold/ Inventories 9.76
= 52/ INVT 5.33
= Sales revenue/PPE 50.63
-0.25
= (-Weeks Payable/APT) + (Weeks inventory/INVT) + (Weeks Receivable /ART)
-12.81
=SG&A / revenue 15.70%
Zales Tiffany's
0.35 0.35 Blue Nile Zales Tiffany
10.0 416.1 Net sales 400 1,888.00 3,794.20
185.3 2,611.3 Gross profit 75.1 984.4 2,163.20
1.0 1.0 Operating 12.3 35.1 697.2
1,187.3 4,630.9 Total curren 125.9 837.2 3,151.60
903.6 1,631.0 Other asset 12.1 241.2 660.4
220.6 295.4 Cash and ca 87 17.1 504.8
1,888.0 3,794.0
- 174.0
767.5 2,234.3
108.9 818.8
916.3 1,466.1

Zales Tiffany's
5.40% 15.93%
0.90% 9.00%

4.50% 6.94%
4.10 5.52
0.56% 10.98%
1.59 0.82
#DIV/0! 21.80
#DIV/0! 2.38
1.18 0.73
44.17 71.23
17.34 4.63
0.61 1.23 years
31.47 64.20 weeks
48.53% 38.64%
 Zone
Wipes
North West South West Upper Midwest Lower Midwest North East
Chicago 0 0 0 0 0
Princeton 0 0 0 0 0
Atlanta 0 0 0 0 0
Los Angeles 0 0 0 0 0
Total 0 0 0 0 0
Demand 500 700 900 800 1000

Zone
Ointment
North West South West Upper Midwest Lower Midwest North East
Chicago 0 0 0 0 0
Princeton 0 0 0 0 0
Atlanta 0 0 0 0 0
Los Angeles 0 0 0 0 0
Total 0 0 0 0 0
Demand 500 700 900 800 1000

Transaction Cost / Zone

Unit North West South West Upper Midwest Lower Midwest North East
Chicago 6.32 6.32 3.68 4.04 5.76
Princeton 6.6 6.6 5.76 5.92 3.68
Atlanta 6.72 6.48 5.92 4.08 4.04
Los Angeles 4.36 3.68 6.32 6.32 6.72
 Total Fixed Cost Multiplier Fixed Cost Capacity
South East
0 0 1 5000 5000
0 0 0 2200 0
0 0 0 2200 0
0 0 1 2200 2200
0 0
600 4500

Total Fixed Cost Multiplier Fixed Cost Capacity

South East
0 0 1 1500 1500
0 0 1 1500 1500
0 0 0 1500 0
0 0 0 1500 0
0 0
600 4500

0
South East Wipes Ointment
5.96 Fixed Cost 7200 3000
4.08 Variable Cost 45000 90000
3.64 Transportation Cost 0 0
6.6 Total Cost 52200 93000 $ 145,200.00 Total Cost
 Transportation Cost

$ 6.32 $ 6.60 $ 6.72 $ 4.36

$ 6.32 $ 6.60 $ 6.48 $ 3.68
$ 3.68 $ 5.76 $ 5.92 $ 6.32
$ 4.04 $ 5.92 $ 4.08 $ 6.32
$ 5.76 $ 3.68 $ 4.04 $ 6.72
$ 5.96 $ 4.08 $ 3.64 $ 6.60