You areprovided 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.
.
L` I DAVID JONES FINANCIAL RATIOS 2 3 Ratios Provided 2010 2011 2012 2013 4 5. EBIT !' Sales 12 . 109/0 12 . 509/0 8. 3.09/0 3 . 109/0 EF'S 14, 4 73 34 31. 5 BE 47 17 . 5 30 10 1 1| Debt to Equity 10. 409/0 13 . 30 9/0 13 . 009/6) 4. 709` 12 13 ROE 22.5 21 . 4 13 12 . ] 14 15 15 17 Other Ratios Insert formula this column Insert numerical answers these columns - yellow 10 19 Return on Operating assets 20 21 22 Profit Margin 23 24 25\\ Asset Turnover ZE27 28| Asset Turnover Ratios 24 30 Net Current Operating ASSETs / Sales 0. 040597 25| 0. 05 5415 1 1| 0. 03140243 0. 01781285 31 32| Current Operating ASSETS !' Sales 0. 18 20 7 80 1 0. 1 85 23837| 0. 15 5 5 9 958| 0. 1831245 5 33| Current Operating Liabilities !' Sales 0. 1 19 10309| 0. 1 1032475| 0. 141650.02 0. 141517 78 35.| Property Plant and Equip !' Sales 0. 370935 5 5 0. 40595295 0. 437 5:403 0. 4527 7375 35 Other Non Current Net Operating ASSETs / Sales - 0 . 0451357 - 0.0630092 - 0 . 053743 - 0. 03535 1 1 \\Other Non Current Operating ASSETS !' Sales 0. 05127458 0. 0453 0: 452| 0. 0535 5408\\ 0.058.37 74 \\Other Non Current Operating Liabilities !' Sales 0 . 10.04 1 172 0. 10835385 0. 10739703 0. 0947 5.845 4 1| Short Term Liquidity 42 Current Ratio 1 . 341597 7 1| 1. 5 1 135475| 1. 22157 453 1. 125 515 58 43 Quick Ratio 0 . 1870453 0. 17 67 3504 0. 16585878 0. 164841 12 4 4 45.| Dividend Ratios Dividend Payout Ratio 0. 90205185 0. 840:48 485 0. 8$235294 0. BOBBEERS 47 Sustainable Growth Rate 2. 24278351| 3. 24242424 1. 52041 175 1. 41 1 1 1 1 1 1 4:47DAVID JONES LINE ITEMS E 2010 1 5 ) 201 1 / 4 ) 2012 15 ) 2013 /4 ) Sales 2053087 195174 4 1867817 18:45012 Gross Profit $157 24 767259 595030 70514 4 EBIT 24917 7 245710 154 413 148958 NOFAT 170 TEE 168135 101013 1015.54 Inventory ZEZ345 280850 27909.9 251543 1 \\Other current assets 45730 3825 1 $4150 43152 PPE 76155.5 798415 $ 17432 $35373 E other non - current ASSETS 105272 100215 107 707 4 Total ASSETS 1 194521 12145 50 1240847 1237 7 85 5 Payables 24 4525 215425 2545.45 Provisions 47420 32910 3213{ 42.945 Interest - bearing Liabilities 103.945 131943 100350 \\Other liabilities 54785 32454 3154 4 Total Liabilities 450583 429070 45 5 153 Z Net ASSETS 744230 785480 775704
