You are provided with historical details of the financial statements for David Jones Ltd (formerly ASX:DJS) with four years of ratio data with certain key ratios removed. Students are required to: 1. calculate the financial ratios which have been removed using precise cell references from Sheet 2, and 2. provide a description of how you calculated each of the ratios, and also 3. identify if this ratio is average or poor, and if it is improving or deteriorating, and why. DAVID JONES FINANCIAL RATIOS 3 Ratios Provided 5 EBIT/Sales 7 EPS 2010 12.10% 19.4 17.5 10.40% 22.9 2012 8.30% 34 30 13.00% 2013 8.10% 31.5 28 9.70% 12.7 2011 12.60% DPS 1 Debt to Equity 3 ROE 28 13.30% 21.4 4 Insert formula this column Other Ratios Insert numerical answers these columns-yellow 9 Return on Operating assets 2 Profit Margin 5 Asset Turnover 8 Asset Turnover Ratios 9 0 Net Current Operating Assets Sales 0.04069725 0.05641511 0.03140243 0.01781289 2 Current Operating Assets Sales 3 Current Operating Liabilities Sales 4 5 Property Plant and Equip/ Sales 6 Other Non Current Net Operating Assets Sales -0.0491367 -0.06300920.053743 -0.0363911 0.18207801 0.18623837 0.19669968 0.18312455 0.11910309 0.11032479 0.14166002 0.14191778 0.37093655 0.40699296 0.4376403 0.45277375 8 Other Non Current Operating Assets/Sales 9 Other Non Current Operating Liabilities/ Sales 0 1 Short Term Liquidity 0.05127498 0.04538462 0.05365408 0.0583774 0.10041172 0.10839386 0.10739703 0.09476849 Current Ratio Quick Ratio 1.34169771 1.51135476 1.22167463 1.12551558 0.1870453 0.17673694 0.16685878 0.16484112 14 5 Dividend Ratios Dividend Payout Ratio Sustainable Growth Rate 0.90206186 0.84848485 0.88235294 0.88888889 1DAVID JONES LINE ITEMS 2010(S) 2011S) 2012( 2013($) 5 Sales 6 Gross Profit 7 EBIT 8 NOPAT 2053087 1961744 1867817 1845012 706144 148998 101554 815729 249177 170766 767269 246710 168139 699830 154413 101013 10 Inventory 11 Other current assets 12 PPE 282346 45738 761565 13 Other non-current assets 105272 288850 38251 798416 89033 279099 44150 817432 100216 251543 43162 835373 107707 1194921 1214550 1240897 1237785 14 Total Assets 15 16 Payables 17Provisions 244529 47420 18 Interest-bearing Liabilitie:103945 54789 450683 216429 32910 131943 47788 429070 264595 32138 136006 32454 465193 261840 42945 100360 31544 436689 9 Other llabilitles 20 Total Liabilities 21 22 Net Assets 23 744238 785480 775704 801096