List the formulas using cell refrences in cells highlighted yellow. DO NOT USE VALUES

Balance Sheet (Millions of S) Assets Cash and securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Notes payable Accmals Total current Long-term bonds Total debt Common stock R etained earnings Total common equity Total and equity Income Statement (Millions of S) Net sales Operating costs except depr'n Depr eciation Earnings bef int and taxes (EBYT) Less interest Earnings before taxes (EBT) Taxes Net income Other data: Shares outstanding (mNions) Common diGdends (Mlions of S) Int rate on notes payable & L-T bonds F ederal plus state income tax rate Year-end stock price Common-Size Statements 2012 $1,594.00 9,940 _ 00 13 560.00 $25,094.00 15 946.00 $7,440.00 *630.00 $17,640.00 10940.00 $28,580.00 3,160.00 noo_oo SIX460_oo 2012 58200.00 Sl 024.00 2618.00 170_2 2447.80 $881_20 $511.21 650% 360/0 $77.97 Points Ratios 1 Current Ratio (CR) 2 Quick Ratio (QR) 3 Days Sales Outstanding (DSO) 4 Total Assets Turnover (TAT) 5 Inventory Turnover Ratio 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) 14 Cash Flow Per Share (CFPS) 15 Earnings Per Share (EPS) 16 PIE Ratio 17 Book Value Per Share (BVPS) 18 Market-To-Book Ratio (M/B or P/B) 19 Equity Multiplier (EM) Notes Use 365 day year Use C23 to represent COGS Assume Principal Repayments and Lease Payments are zero Use Total Debt Insert formulas using cell references in cells highlighted yellow above. Do not use values! Total Points Grand Total Points Points 19