A
B
D
E
F
G
1
Balance Sheet (Millions of $)
Common-Size Statements
Points
2 Assets
2012
Ratios
1 Current Ratio (CR)
Notes
5
3 Cash and securities
4 Accounts receivable
Inventories
$1,594.00
9,940.00
13,560.00
6
Total current assets
$25,094.00
2 Quick Ratio (QR)
3 Days Sales Outstanding (DSO)
4 Total Assets Turnover (TAT)
1
5 Inventory Turnover Ratio
7 Net plant and equipment
15,946.00
8 Total assets
$41.040.00
9 Liabilities and Equity
10 Accounts payable
11 Notes payable
12 Accruals
$7,440.00
5,630.00
4,570.00
13 Total current liabilities
$17,640.00
14 Long-term bonds
10,940.00
6 Times Interest Earned (TIE)
7 EBITDA Coverage
8 Debt Ratio
9 Return on Assets (ROA)
10 ROE (Return on Equity)
11 Basic Earning Power (BEP)
12 Net Profit Margin (NPM)
13 Dividends Per Share (DPS)
Use 365 day year
Use C23 to represent COGS
Assume Principal Repayme
Use Total Debt
15 Total debt
$28,580.00
16 Common stock
17 Retained earnings
18 Total common equity
3,160.00
9.300.00
$12,460,00
1
14 Cash Flow Per Share (CFPS)
15 Earnings Per Share (EPS)
19 Total liabilities and equity
20
21 Income Statement (Millions of $)
22 Net sales
23 Operating costs except depr'n
24 Depreciation
25 Earnings bef int and taxes (EBIT)
$41.040.00
2012
$58,200.00
$54,558.00
$1,024.00
$2,618.00
16 P/E Ratio
17 Book Value Per Share (BVPS)
18 Market-To-Book Ratio (M/B or P/B)
19 Equity Multiplier (EM)
Insert formulas using cell references in cells highlighted yellow a
Do not use values!
Total Points
1
26 Less interest
27 Earnings before taxes (EBT)
28 Taxes
170.2
$2,447.80
$881.20
29 Net income
30 Other data:
$1.566.60
31 Shares outstanding (millions)
32 Common dividends (Millions of $)
33 Int rate on notes payable & L-T bonds
34 Federal plus state income tax rate
35 Year-end stock price
36
37
38
39
40
41
42
43
44
45
173
$511.21
6.50%
36%
$77.97
Insert formulas using cell references for common-size statements in areas highlighted blue above
Do not use values!
Total Points
3
Grand Total Points
