Screenshot 2024-04-10 at 5.55.40 PM ' Screenshot Sc Screenshot 2024-0....53.33 PM 2024-0....41.29 PM 2024- 1 A B C A B C 1 Balance Sheet (Millions of $) 2 Assets 2 Income Statement (Millions of $) 3 Net sales 4 Operating costs except depr'n 5 Depreciation 2012 2013 3 Cash and securities Screenshot 6 Earnings bef int and taxes (EBIT) 2024-0....42.52 PM Sc 2024- 7 Less interest 8 Earnings before taxes (EBT) 9 Taxes 10 Net income $58,200.00 $57,036.00 $54,558.00 $48,556.62 $1,024.00 $1,136.64 $2,618.00 $7,342.74 170.2 $211.05 $2,447.80 $7,131.69 $881.20 $2,567.41 $1.566.60 5 4 Accounts receivable Inventories 6 Total current assets 8 Total assets $4,564.28 11 Notes payable 12 Accruals 11 Other data: 13 Total current liabilities 12 Shares outstanding (millions) Screenshot 2024-0....53.42 PM Sc 2024- 13 Common dividends (Millions of $) 14 Int rate on notes payable & L-T bonds 15 Federal plus state income tax rate 16 Year-end stock price 173 $511.21 6.50% $1,489.41 36% $77.97 7 Net plant and equipment 9 Liabilities and Equity 10 Accounts payable 14 Long-term bonds 15 Total debt 16 Common stock 17 Retained earnings 2012 2013 $1,594.00 $2,506.33 9,940.00 $11,132.80 13,560.00 $15,322.80 $25,094.00 $28,961.93 15,946.00 $16,105.46 $41,040.00 $45.067.39 $7,440.00 $7,291.20 5,630.00 $5,067.00 4,570.00 $3,975.90 $17,640.00 $16,334.10 10,940.00 $12,471.60 $28,580.00 $28,805.70 3,160.00 $3,886.80 9,300.00 $12,374.89 17 18 Total common equity $12,460.00 $16,261.69 19 Total liabilities and equity 20 $41,040.00 $45,067.39 Screenshot 2024-04-10 at 5.54.35 PM A B 1 Ratios 2 1 Current Ratio (CR) 3 2 Quick Ratio (QR) 4 3 Days Sales Outstanding (DSO) 5 4 Total Assets Turnover (TAT) 6 5 Inventory Turnover Ratio 7 6 Times Interest Earned (TIE) 8 7 EBITDA Coverage 9 8 Debt Ratio 10 9 Return on Assets (ROA) 11 10 ROE (Return on Equity) 12 11 Basic Earning Power (BEP) 13 12 Net Profit Margin (NPM) 14 13 Dividends Per Share (DPS) 15 14 Cash Flow Per Share (CFPS) 16 15 Earnings Per Share (EPS) 17 16 P/E Ratio 18 17 Book Value Per Share (BVPS) 19 18 Market-To-Book Ratio (M/B or P/B) 20 19 Equity Multiplier (EM) 21 22 23 21 C 2012 D 2013 Notes Insert formulas using cell references in cells highlighted green above. Do not use values! E F Points Change 0.31 0.31 Use 365 day year 0.31 0.31 Use C23 to represent COGS 0.31 0.31 Assume Principal Repayments and Lease Payments are zero Use Total Debt 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 Search G Comment on the change from 2012 to 2013 Point out whether performance has improved or worsened and on what measure C M