Question

You are provided with historical details of the financial statements for David Jones Ltd (formerly ASX:DJS) with four years oDAVID 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% 21DAVID JONES LINE ITEMS 2010(S) 2011S) 2012( 2013($) 5 Sales 6 Gross Profit 7 EBIT 8 NOPAT 2053087 1961744 1867817 1845012 70

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
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Details Other Ratios Year 2010 2011 2012 2013 Return on operating Assets (ROA Operating profile or net income/ Total Assets)*

Add a comment
Know the answer?
Add Answer to:
You are provided with historical details of the financial statements for David Jones Ltd (formerl...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash $ 25,900 Accounts payable $ 149,000 Accounts receivable 81,500 Bonds payable (long term) 80,300 Inventory 51,800 Long-Term Assets Stockholders' Equity Gross fixed assets $ 514,000 Common stock $ 150,000 Less: Accumulated depreciation 155,900 Paid-in capital 70,000 Net fixed assets* 358,100 Retained earnings 68,000 Total assets $ 517,300 Total liabilities and equity $ 517,300      Sales (on credit) $ 1,347,000 Cost of goods sold 790,000...

  • Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash $ 22,000 Accounts payable $ 127,000 Accounts receivable 81,100 Bonds payable (long term) 85,600 Inventory 50,000 Long-Term Assets Stockholders' Equity Gross fixed assets $ 526,000 Common stock $ 150,000 Less: Accumulated depreciation 150,700 Paid-in capital 70,000 Net fixed assets* 375,300 Retained earnings 95,800 Total assets $ 528,400 Total liabilities and equity $ 528,400      Sales (on credit) $ 1,326,000 Cost of goods sold 790,000...

  • Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash $ 22,000 Accounts payable $ 127,000 Accounts receivable 81,100 Bonds payable (long term) 85,600 Inventory 50,000 Long-Term Assets Stockholders' Equity Gross fixed assets $ 526,000 Common stock $ 150,000 Less: Accumulated depreciation 150,700 Paid-in capital 70,000 Net fixed assets* 375,300 Retained earnings 95,800 Total assets $ 528,400 Total liabilities and equity $ 528,400      Sales (on credit) $ 1,326,000 Cost of goods sold 790,000...

  • Given the financial statements for Jones Corporation and Smith Corporation JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation JONES CORPORATION Current Assets Liabilities Cash Accounts receivable Inventory $ 25,800 Accounts payable S188,000 80,400 88,700 54,200 Bonds payable (long term) Long-Term Assets Stockholders' Equity $578,000 153,900 Gross fixed assets Common stock $150,000 70,000 104,400 $592,800 Less: Accumulated Paid-in capital 424,100 Retained earnings $592,800 Net fixed assets* Total assets Total liabilities and equity Sales (on credit) Cost of goods sold Gross profit Selling and administrative $1,717,000 782,000 $935,000 283,000 nse...

  • Given the financial statements for Jones Corporation and Smith Corporation JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation JONES CORPORATION Current Assets Liabilities Cash Accounts receivable nven $123,300 Accounts payable $176,000 89,600 183,600 56,800 Bonds payable (long term) Long-Term Assets Stockholders' Equity Gross fixed assets $554,000 152,300 $150,000 70,000 279,800 $765,400 Total labilities and equity $765,400 Common stock Less: Accumulated depreciation Net fixed assets Paid-in capital 401,700 Retained earnings Total assets Sales (on credit) Cost of goods sold Gross profit Selling and administrative $1,255,000 678,000 577,000 355,000 nse...

  • Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation:   JONES CORPORATION Current Assets Liabilities Cash $ 123,300 Accounts payable $ 176,000 Accounts receivable 183,600 Bonds payable (long term) 89,600 Inventory 56,800 Long-Term Assets Stockholders' Equity Gross fixed assets $ 554,000 Common stock $ 150,000 Less: Accumulated depreciation 152,300 Paid-in capital 70,000 Net fixed assets* 401,700 Retained earnings 279,800 Total assets $ 765,400 Total liabilities and equity $ 765,400      Sales (on credit) $ 1,255,000 Cost of goods sold 678,000...

  • Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash...

    Given the financial statements for Jones Corporation and Smith Corporation: JONES CORPORATION Current Assets Liabilities Cash Accounts receivable Inventory $ 122,700 Accounts payable 80,700 52,600 s 106,000 89,300 Bonds payable (long term) Long-Term Assets Stockholders' Equity 565,000 154,900 s 150,000 70,000 250,800 $ 666,100 Gross fixed assets Common stock Paid-in capital Less: Accumulated depreciation Net fixed assets 410.100 Retained earnings $ 666,100 Total assets Total liabilities and equity Sales (on credit) Cost of goods sold Gross proft Selling and administrative...

  • Statement of the Assignment: Please prepare a comprehensive list of financial ratios as introduced in Chapter...

    Statement of the Assignment: Please prepare a comprehensive list of financial ratios as introduced in Chapter 3 of the textbook. Write a brief explanation below each financial ratio, e.g. what does the financial ratio measures or what the significance of it is. For example: Current Ratio = Current Assist / Current Liabilities Current ratio measures whether our current assets, if liquidated, are sufficient to pay all of our current liabilities. A CR of 1.5, for example, shows that if we...

  • Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets as of...

    Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2009 and 2010 2009 2010 2010 2009 Liabilities and Owners' Equity Assets Current assets Current liabilities Accounts payable Notes payable Other $ 2,188 1,785 97 3,001 $ 2,957 4,732 12,618 Cash 2,670 2,186 114 Accounts receivable 5,711 13,712 Inventory 4,070 4,970 Total $20,351 $ 22,380 Total $14,000 16,760 Long-term debt Owners' equity Common stock $41,500 $ 41,500 15,689 and paid-in surplus Accumulated...

  • The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash Accounts receivable (net) Inventory Property &e...

    The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash Accounts receivable (net) Inventory Property &equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement: Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data: Per share stock price at end of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT