Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    Year Current Ratio

    Uploaded by

    psana99gmailcom
    The document contains financial ratio data for a company from 2018 to 2016. The current ratio was highest in 2016 at 1.0074 and lowest in 2017 at 0.8109. The debt ratio was highest in 2017 at 0.562 and lowest in 2016 at 0.4262. The return on investment was highest in 2018 at 18.6881% and lowest in 2017 at 14.6063%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Year Current Ratio

    Uploaded by

    psana99gmailcom
    46 views13 pages
    The document contains financial ratio data for a company from 2018 to 2016. The current ratio was highest in 2016 at 1.0074 and lowest in 2017 at 0.8109. The debt ratio was highest in 2017 at 0.562 and lowest in 2016 at 0.4262. The return on investment was highest in 2018 at 18.6881% and lowest in 2017 at 14.6063%.

    Original Description:

    Data interpretation

    Original Title

    Analysis

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains financial ratio data for a company from 2018 to 2016. The current ratio was highest in 2016 at 1.0074 and lowest in 2017 at 0.8109. The debt ratio was highest in 2017 at 0.562 and lowest in 2016 at 0.4262. The return on investment was highest in 2018 at 18.6881% and lowest in 2017 at 14.6063%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    46 views13 pages

    Year Current Ratio

    Uploaded by

    psana99gmailcom
    The document contains financial ratio data for a company from 2018 to 2016. The current ratio was highest in 2016 at 1.0074 and lowest in 2017 at 0.8109. The debt ratio was highest in 2017 at 0.562 and lowest in 2016 at 0.4262. The return on investment was highest in 2018 at 18.6881% and lowest in 2017 at 14.6063%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 13

    Year Current ratio

    2018 0.942
    2017 0.8109
    2016 1.0074

    Current ratio
    1.2

    0.8

    0.6

    0.4

    0.2

    0
    2018 2017 2016
    rrent ratio Current ratio

    2018
    2017
    Current ratio 2016

    2016
    o

    2018
    2017
    2016
    year Debt ratio
    2018 0.3951
    2017 0.562
    2016 0.4262

    Debt ratio

    2018
    2017
    2016
    Year Return on investment
    2018 18.6881
    2017 14.6063
    2016 15.3434

    Return on investment
    20
    18
    16
    14
    12 Return on investment
    10
    8
    6
    4
    2
    0
    2018 2017 2016
    Return on investment

    2018
    2017
    2016
    Particular Asset turnover ratio
    2018 0.6028
    2017 0.5756
    2016 0.6045

    Asset turnover ratio


    0.605
    0.6
    0.595
    0.59
    Asset turnover ratio
    0.585
    0.58
    0.575
    0.57
    0.565
    0.56
    2018 2017 2016
    Asset turnover ratio

    2018
    2017
    2016
    Particular 2018 change in % 2017 change in % 2016
    Revenue 59434 7.793314834 55137 0.889775669 55632
    COGS 32726 7.985217449 30306 -1.04357683 29993
    Gross profit 26708 7.559099513 24831 3.151448964 25639
    R&D expenses
    SG&A expense 8860 8.365949119 8176 6.60269591 8754
    Other operating income 44630 7.900971907 41362 0.164132271 41430
    Operating expense 14804 7.470054446 13775 3.006618786 14202
    TOtal non operating expense -75 -676.923077 13 98.04804805 666
    pre income tax 14729 6.824775167 13788 7.263922518 14868
    Income tax 1663 -62.3925825 4422 12.91847184 5078
    Income after tax 13066 39.50459107 9366 4.330949949 9790
    Income from continues operations
    Income from discontinues operations 13066 39.50459107 9366 4.330949949 9790

    net income 12598 40.28953229 8980 4.376530721 9391


    EBITDA 17815 7.597994806 16557 1.028154701 16729
    EBIT 14804 7.470054446 13775 3.006618786 14202
    BASED SHARE OUTSTANDING 1499 -4.4005102 1568 3.744628607 1629
    SHARES OUTSTANDING 1507 -4.49936629 1578 3.721781574 1639
    BASIC EPS 8.4 46.59685864 5.73 0.520833333 5.76
    EPS 8.36 46.92442882 5.69 0.698080279 5.73
    FY12 FY13 FY14 FY15 FY16 FY17
    Balance sheet

    Net working capital


    Current assets 13709 14109 15176 16758 16966
    Current liabilities 12813 11704 13292 16334 16842

    Net working capital in % 896 2405 1884 424 124 1181.6


    2.1 3.3 3.9 o.8 0.2 2

    FREE CASH FLOW


    EBIT 9390 9924 12254 13985 15128 15774.7
    (-TAX) 3192.6 3374.16 4166.36 4754.9 5143.52 5363.398
    Tax effected EBIT 6197.4 6549.84 8087.64 9230.1 9984.48 10411.3

    Depreciation and amortization 1987.0 2192.0 2288.0 2554.0 2527.0 2717.7


    other non cash expnses 408 402 408 410 393 404.2
    NOPAT 8592.4 9143.8 10783.6 12194.1 12904.5 13533.2
    (Change in working capital) 1509 321 1460 300 1037.6
    (Change in expenditure) 2796.0 3311.0 4265.0 4773.0 5317.3
    4305 3632 5725 5073 6354.9
    Unlevered free cashflow 4838.8 7151.6 6469.1 7831.5 7178.3
    FY18 FY19 FY20 FY21

    1252.5 1327.7 1407.3 1491.8


    2 2 2 2

    16721.2 17724.4 18787.9 19915.2


    5685.208 6026.296 6387.886 6771.168
    11035.99 11698.1 12400.01 13144.03

    2880.8 3053.6 3236.9 3431.3


    403.4 403.7 402.9 401.4
    14320.2 15155.4 16039.8 16976.7
    70.9 75.2 79.7 84.4
    5886.8 6505.6 7177.4 7506.4
    5957.7 6580.8 7257.1 7590.8
    8362.5 8574.6 8782.7 9385.9
    12 months ended Sep 29, 2018 Sep 30, 2017 Oct 1, 2016 Oct 3, 2015 Sep 27, 2014 Sep 28, 2013
    Services 85.59% 84.96% 84.72% 83.66% 82.45% 82.77%
    Products 14.41% 15.04% 15.28% 16.34% 17.55% 17.23%
    Revenues 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

    Cost of services,
    exclusive of
    depreciation
    and
    amortization -46.32% -45.92% -44.31% -44.20% -43.75% -44.60%

    Cost of
    products,
    exclusive of
    depreciation
    and
    amortization -8.75% -9.04% -9.60% -9.86% -10.37% -10.98%
    Cost of
    revenues,
    exclusive
    of
    depreciati
    on and
    amortizati
    on -55.06% -54.96% -53.91% -54.06% -54.12% -55.58%
    Gross profit 44.94% 45.04% 46.09% 45.94% 45.88% 44.42%

    Selling, general,
    administrative
    and other -14.91% -14.83% -15.74% -16.25% -17.55% -18.57%

    Depreciation
    and
    amortization -5.07% -5.05% -4.54% -4.49% -4.69% -4.87%

    Restructuring
    and impairment
    charges -0.06% -0.18% -0.28% -0.10% -0.29% -0.48%
    Operating
    income 24.91% 24.98% 25.53% 25.10% 23.35% 20.51%
    Gains on
    sales of real
    estate and
    property
    rights 0.94% — — — — —
    Settlement of
    litigation 0.06% -0.32% — — — —
    Gain related
    to the
    acquisition of
    BAMTech 0.01% 0.46% — — — —
    Other — — — — -0.06% -0.15%

    Other
    income
    (expense),
    net 1.01% 0.14% — — -0.06% -0.15%
    Interest
    expense -1.15% -0.92% -0.64% -0.51% -0.60% -0.77%

    Interest and
    investment
    income 0.18% 0.22% 0.17% 0.28% 0.65% 0.25%

    Interest
    income
    (expense),
    net -0.97% -0.70% -0.47% -0.22% 0.05% -0.52%

    Equity in the
    income (loss) of
    investees, net -0.17% 0.58% 1.66% 1.55% 1.75% 1.53%

    Income
    before
    income taxes 24.78% 25.01% 26.73% 26.43% 25.09% 21.36%
    Income taxes -2.80% -8.02% -9.13% -9.56% -8.69% -6.63%
    Net income 21.98% 16.99% 17.60% 16.87% 16.40% 14.73%

    Net income
    attributable to
    noncontrolling
    interests -0.79% -0.70% -0.72% -0.90% -1.03% -1.11%

    Net income
    attributable to
    The Walt Disney
    Company
    (Disney) 21.20% 16.29% 16.88% 15.98% 15.37% 13.62%

    You might also like