Question
fill in rach of these bumbers in the shaded area using the income statement and balance sheet on the below

AUTOSave Home Insert Draw Page Layout Formulas Data Review View Tell me х Calibri (Body) 16 Α Α == v a Wrap Text Paste BIU
Home AutoSave OP € Insert Draw Page Layout X Calibri (Body) 16 Formulas Data Review View Tell me 2 Wrap Text - A A avau Paste
LUHUR Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body 16 - A Ă a-A- 2 Wrap Text General B TU Mer
Tell me Calibri (Body) 11 y = = Paste Α Α А ~ 25 Wrap Text BIU General Merge & Center H23 x $ % ) A 1 2 ds Dec 31, 2019 D D
D 11 12 Soru proves, property requerer Restricted cash Operating lease assets Other assets Goodwill Total assets 13 с 2.930,0
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution ;

1. Gross profit margin = Gross profit / Revenue

    a) 2019 = 1903321 / 5586369 = 0.34

     b) 2018 = 1591023 / 4864985 = 0.33

     c) 2017 = 1407860 / 4476412 = 0.31

2. Operating margin = Operating income / Revenue

   a) 2019 = 443958 / 5586369 = 0.08

    b) 2018 = 258368 / 4864985 = 0.05

    c) 2017 = 270794 / 4476412 = 0.06

3. Net margin = Net income / Revenue

   a) 2019 = 350158 / 5586369 = 0.063

   b) 2018 = 176553 / 4864985 = 0.036

   c) 2017 = 176253 / 4476412 = 0.04

4. Current ratio = Current asset / Current liabilities

a) 2019 = 1072204 / 666593 = 1.61

b) 2018 = 814794 / 449990 = 1.81

5. Avg. Collection period = ( Average trade receivable / Net credit sale ) * 12

If cash revenue from operations is not specifically given ,the given revenue from operations may

be taken as credit revenue from operations .

a). 2019 =( 80545 / 5586369 ) * 12 = 0.17

b). 2018 = ( 62312 / 4864985 ) * 12 = 0.15

6. Total asset turn over = Revenue / Average total asset

   a) 2019 = 5586369 / 5104604 = 1.09 or 1.1

    b) 2018 = 4864985 / 2265518 = 2.15

7. Debt ratio = Total liability / Total Assets

a) 2019 = 3421578 / 5104604 = 0.67

   b) 2018 = 824179 / 2265518 = 0.36

8. Debt equity ratio = Long term debt / Shareholder's fund

a) 2019 = 2678374 / 1683026 = 1.6

b) 2018 = 0 / 1441339

9. Return on Assets = Net income / Total Assets

a) 2019 = 350158 / 5104604 = 0.07

b) 2018 = 176553 / 2265518 = 0.08

10. Return on equity = Net income / Shareholder's equity

     a) 2019 = 350158 / 1683026 = 0.21

     b) 2018 = 176553 / 1441339 = 0.12

Dupont ROE = Net Profit Margin * Total Assets Turnover * Financial leverage

Financial leverage =Total Asset / Shareholder's equity

2019 = 5104604 / 1683026 = 3.

2018 = 2265518 / 1441339 = 2

2019 = 0.063 * 1.1 * 3 = 0.21

2018 = 0.036 * 2.15 * 2 = 0.15

Add a comment
Know the answer?
Add Answer to:
fill in rach of these bumbers in the shaded area using the income statement and balance...
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
  • Help!! I am in need of assitance with this problem. Please fill in the grey spaces...

    Help!! I am in need of assitance with this problem. Please fill in the grey spaces and provide some details for the Dupont for 2019 & 2018 12 Months Ended Dec. 31, 2019 Dec. 31, 2018 Dec 31, 2017 $ 5,586,369 $4,864,985 $ 4,476,412 Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands Consolidated Statements of Income [Abstract] Revenue Restaurant operating costs (exclusive of depreciation and amortization shown separately below): Food, beverage and packaging Labor Occupancy...

  • Please fill in the grey spaces for the 2020 Balance Sheet. Dec. 31, 2019 Dec. 31,...

    Please fill in the grey spaces for the 2020 Balance Sheet. Dec. 31, 2019 Dec. 31, 2018 Balance in TL enda Current assets. Cash and cash equivalents Accounts receivable, net Inventory Prepaid expenses and other current assets Income tax receivable Investments Total current assets Leasehold improvements, property and equipment, Restricted cash Operating lease assets Other assets Goodwill Total assets $ 480,626 80,545 26,096 57,076 27,705 400,156 1,072,204 1,458,690 27,855 2,505,466 18,450 21.939 5,104,604 $249,953 62,312 21,555 54,129 0 426,845 814,794...

  • P4-42. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below...

    P4-42. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below for Under Armour Inc. UNDER ARMOUR INC. Consolidated Statements of Income For 12 Months Ended ($ in 000s) Dec. 31, 2015 M Net revenues ................................ Cost of goods sold ......... Gross profit.. Selling, general and administrative expenses ....... Income from operations ........ Interest expense, net ....... Other expense, net..................................................... Income before income taxes........... Provision for income taxes............... Net income.... o n o polduOHS. ...............

  • Using the income statement and balance sheets shown above, create an appropriate cash flow statement including...

    Using the income statement and balance sheets shown above, create an appropriate cash flow statement including the required disclosures. Thank you. (Dollars in Millions) 2017 2016 $1,074 3,795 378 5,247 8,103 224 $13, 574 $707 4,038 331 5,076 8, 308 222 $13, 606 $1,507 1,200 24 112 $1,251 1,180 26 130 Assets Current assets: Cash and cash equivalents Merchandise inventories Prepaid expenses Total current assets Property and equipment, net Other assets Total assets Liabilities and Shareholders Equity Current liabilities: Accounts...

  • Using the income statement and balance sheets shown above, create an appropriate cash flow statement including...

    Using the income statement and balance sheets shown above, create an appropriate cash flow statement including the required disclosures. Thank you. (Dollars in Millions) 2017 2016 Assets Current assets: Cagh and cash equivalents Merchandise inventories Prepaid expenses Total current assets Property and equipment, net Other assets Total assets $1,074 3,795 378 5,247 8,103 224 $13, 574 $707 4,038 331 5,076 8, 308 222 $13, 606 $1,507 1,200 24 112 $1,251 1,180 26 130 134 127 All current portion paid Liabilities...

  • Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...

    Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008 Net revenue $ 44,423 $ 35,127 $ 37,586 Cost of sales 15,132 15,566 16,742 Gross margin 29,291 19,561 20,844 Research and development 6,576 5,653 5,722 Marketing, general and administrative 6,309 7,931 5,452 Restructuring and asset impairment charges -- 231 710 Amortization...

  • P3-45. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below...

    P3-45. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below for Facebook Inc. FACEBOOK INC. Consolidated Statement of Income For Year Ended December 31, $ millions 2018 $55,838 9,355 10,273 7,846 3,451 Revenue.... Costs and expenses Cost of revenue Research and development Marketing and sales .. General and administrative. Total costs and expenses. Income from operations .... Interest and other income (expense), net. ... Income before provision for income taxes .. Provision for income...

  • The following summaries from the income statements and balance sheets of Koutis Company and Brittania, Inc....

    The following summaries from the income statements and balance sheets of Koutis Company and Brittania, Inc. are presented below. (1) For both companies for Year 2, compute the: (a) Current ratio (b) Acid-test ratio (c) Accounts receivable turnover (d) Inventory turnover (c) Days' sales in inventory (f) Days' sales uncollected Which company do you consider to be the better short-term credit risk? Explain. (2) For both companies for Year 2, compute the: (a) Profit margin ratio (b) Return on total...

  • Refer to the balance sheets and income statement for Under Armour Inc. in P3-47. Use these...

    Refer to the balance sheets and income statement for Under Armour Inc. in P3-47. Use these financials to answer the requirements. For the 2015 fiscal year, Under Armour had a return on net operating assets (RNOA) of 15.17%. a. Compute ROE. b. Compute net nonoperating obligations (NNO). c. Compute FLEV and Spread. d. Show that ROE = RNOA + (FLEV X Spread). e. What is the nonoperating return for the year? What does this suggest about Under Armour's use of...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 99.08% 0 $ 495,761 4,582 500,343 $ 481,317 4,556 485,873 99.06% 0.94% 0 373,396 106,510 0 o 361,256 101,853 20,437 22,764 3 Revenues: 4 Net sales 5 Membership and other income 6 Total revenues 7 Costs and expenses: 8 Cost of sales Operating, selling, general and administrative 9 expenses 10 Operating income 11 Interest: 12 Debt 13 Capital...

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