help in finance and accounting excel sheet

profilesaud.t1
book1.xlsx

Sheet1

Dayton Corporation $ in million
Income Statement for fiscal year ending 2013
2012 2013
Sales revenue $ 47,715 $ 40,363
Cost of goods sold $ 27,842 $ 21,485
Gross Profit $ 19,873 $ 18,878
Selling, general and admin expense $ 8,090 $ 7,708
Depreciation & amortizaton $ 628 $ 555
Total operating expense $ 8,718 $ 8,263
Earnings before interest and taxes (EBIT) $ 11,155 $ 10,615
Interest expense $ 754 $ 792
Earnings before taxes $ 10,401 $ 9,823
Income taxes $ 754 $ 792
Net profit after taxes $ 9,647 $ 9,031
Dividend per share
Earning per share $ 4.19 $ 3.93
No of common share outstanding 2300 2300
Market price per share $ 45 $ 45
Dayton Corporation $ in million
Comparative Balance sheet ending Dec 2013
2012 2013
Assets
Current assets
Cash and equivalents $ 2,144 $ 2,536
Receivables $ 5,215 $ 5,017
Inventories $ 3,579 $ 3,021
Other current assets $ 2,022 $ 2,777
Total current assets $ 12,960 $ 13,351
Non current assets
Property, plant and equipment $ 18,956 $ 16,707
Accumulated depreciation $ (5,853) $ (5,225)
Property, plant and equipment net $ 13,103 $ 11,482
Intangible assets $ 7,746 $ 7,374
Other non current assets $ 10,465 $ 7,700
Total non current assets $ 31,314 $ 26,556
Total Assets $ 44,274 $ 39,907
Liabilities and stockholders equity
Current liability
Account payable $ 5,108 $ 4,361
Short term debt $ 4,066 $ 3,319
Other current liabilities $ 2,369 $ 2,029
Total current liabilities $ 11,543 $ 9,709
Non current liabilities
Long term debt $ 4,798 $ 3,600
Other non current liabilities $ 4,837 $ 5,020
Total non current liabilities $ 9,635 $ 8,620
Total liabilities $ 21,178 $ 18,329
Stockholders equity
Common shares $ 6,776 $ 6,746
Retained earnings $ 16,320 $ 14,832
Total stockholders equity $ 23,096 $ 21,578
Total liabilities and stockholders equity $ 44,274 $ 39,907
Dayton Corporation
2012 2013
Liquidity measure
Current ratio 1.12 1.38
Quick ratio 0.81 1.06
Activity measure
Receivable turnover 9.15 8.05
Inventory turnover 7.78 7.11
Total assets turnover 1.08 1.01
Leverage measures
Debt equity ratio 0.21 0.17
Times interest earned 14.79 13.40
Profitability measures
Net profit margin 20.22% 22.37%
Return on assets 21.79% 22.63%
Return on equity 41.77% 41.85%
Common stock measure
Earning per share $ 4.19 $ 3.93
Price to earning ratio 10.73 11.46
Book value per share 10.04 9.38
Price to book value ratio 4.48 4.80