Exam instructions:Students are required to submit a working website link of the selected case study company’s financial statements used in answering the respectivequestions.The link is part of what...

1 answer below »

View more »
Answered 1 days AfterJan 16, 2022

Answer To: Exam instructions:Students are required to submit a working website link of the selected case study...

Sandeep answered on Jan 18 2022
136 Votes
Task 1
        Profitability Ratio
                2018    2019    2020
                (€ million)    (€ million)    (€ million)
    1    Gross Profit Ratio        43.70%    44.01%    43.45%        Gross Profit
                                Sales
    2    Operating Profit Ratio        24.79%    16.75%    16.37%        Operating Profit
                                Sales
    3    Net Profit Ratio        19.20%    11.59%    11.97%        Net Income
                                Sales
        Efficiency Ratio
                2018    2019    2020
    1    Inventory Turonver Ratio(T times)        6.95    6.88    6.65        COGS
                                Av. Inventory
    2    Recievable Turover Ratio(T times)        8.71    7.89    8.72        Credit Sales
                                Av. AR
    3    Assest Turnover Ratio(T times)        0.852    0.837    0.766        Net Sales
                                Av Total Assest
        Liquid Ratio
        Current Ratio    Current Assest    0.783    0.783    0.785
            Current Liability
        Quick Ratio    Current Assest - Inventory    0.565    0.585    0.568
            Current Liability
        Financial Gearing Ratio
        D/E Ratio    
Total Debt(Short +Long +Fixed)    1.761    1.697    1.294
            Total Equity
        Debt to Capital Ratio    Total Debt(Short +Long +Fixed)    0.638    0.629    0.564
            Total Debt + Equity
Gross Profit Ratio    
(€ million)    (€ million)    (€ million)    2018    2019    2020    0.43699737162135655    0.44013081954597921    0.43450831953315983    Operating Profit Ratio    
(€ million)    (€ million)    (€ million)    2018    2019    2020    0.24791102742144286    0.16752597152751059    0.16368977209999211    Net Profit Ratio    
(€ million)    (€ million)    (€ million)    2018    2019    2020    0.19198932956729825    0.11592920353982301    0.1197263622742686    
(€ million)    (€ million)    (€ million)    2018    2019    2020    
(€ million)    (€ million)    (€ million)    2018    2019    2020    
(€ million)    (€ million)    (€ million)    2018    2019    2020    
(€ million)    (€ million)    (€ million)    2018    2019    2020    
Task 3
    Scenario A- Trade receivables of each of the 3 years are 10% higher than currently “forecasted
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    10%    7134        6695    10%    7365        4939    10%    5433
        Inventories        4301    0    4301        4164    0    4164        4462    0    4462
        Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Payable Turnover ratio (T Times)        2.06        2.06        1.99        1.99        1.99    0.00    1.99
        Days Payable outstanding(DPO)    365    177.29        177.29        183.27        183.27        183.87        183.87
            Payable turnover Ratio
        Days Recievable outstanding(DRO)    365    41.91        44.23        46.27        50.90        41.86        46.04
            Recievable turnover Ratio
        Days Inventory Outstanding(DIO)    365    52.54        52.54        53.08        53.08        54.88        54.88
            Inventory turnover Ratio
        Operating Cash Cycle/WCC    DIO + DRO -DPO    -82.84        -80.52        -83.91        -79.28        -87.13        -82.95
    Scenario B- Trade receivables of each of the 3 years are 20% lower than currently “forecasted”
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    -20%    5188        6695    -20%    5356        4939    -20%    3951
        Inventories        4301    0    4301        4164    0    4164        4462    0    4462
        Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Payable Turnover ratio (T Times)        2.06        2.06        1.99        1.99        1.99    0    1.99
        Days Payable outstanding(DPO)    365    177.29        177.29        183.27        183.27        183.8742853159        183.87
            Payable turnover Ratio
        Days Recievable outstanding(DRO)    365    41.91        37.26        46.27        37.02        41.86        33.49
            Recievable turnover Ratio
        Days Inventory Outstanding(DIO)    365    52.54        52.54        53.08        53.08        54.88        54.88
            Inventory turnover Ratio
        Operating Cash Cycle/WCC    DIO + DRO -DPO    -82.84        -87.48        -83.91        -93.17        -87.13        -95.51
    Scenario C- Trade payables of each of the 3 years are 30% higher than currently “forecasted”
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    0    6485        6695    0    6695        4939    0    4939
        Inventories        4301    0    4301        4164    0    4164        4462    0    4462
        Trade Payable        14457    30%    18794        14768    30%    19198        14132    30%    18372
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    18794        14768    0    19198        14132    0    18372
        Payable Turnover ratio (T Times)        2.06        1.78        1.99        1.73        1.99    0.00    1.73
        Days Payable outstanding(DPO)    365    177.29        204.86        183.27        211.055        183.8742853159        210.85
            Payable turnover Ratio
        Days Recievable outstanding(DRO)    365    41.91        41.91        46.27        46.27        41.86        41.86
            Recievable turnover Ratio
        Days Inventory Outstanding(DIO)    365    52.54        52.54        53.08        53.08        54.88        54.88
            Inventory turnover Ratio
        Operating Cash Cycle/WCC    DIO + DRO -DPO    -82.84        -110.42        -83.91        -111.70        -87.13        -114.11
    Scenario D- Trade payables of each of the 3 years are 15% lower than currently “forecasted
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    0    6485        6695    0    6695        4939    0    4939
        Inventories        4301    0    4301        4164    0    4164        4462    0    4462
        Trade Payable        14457    -15%    12288        14768    -15%    12553        14132    -15%    12012
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    12288        14768    0    12553        14132    0    12012
        Payable Turnover ratio (T Times)        2.06        2.23        1.99        2.15        1.99    0.00    2.14
        Days Payable outstanding(DPO)    365    177.29        163.50        183.27        169.380        183.8742853159        170.39
            Payable turnover Ratio
        Days Recievable outstanding(DRO)    365    41.91        41.91        46.27        46.27        41.86        41.86
            Recievable turnover Ratio
        Days Inventory Outstanding(DIO)    365    52.54        52.54        53.08        53.08        54.88        54.88
            Inventory turnover Ratio
        Operating Cash Cycle/WCC    DIO + DRO -DPO    -82.84        -69.05        -83.91        -70.02        -87.13        -73.65
    Scenario E- Inventories of each of the 3 years are 40% higher than currently “forecasted”
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    0    6485        6695    0    6695        4939    0    4939
        Inventories        4301    40%    6021        4164    40%    5830        4462    40%    6247
        Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Opening Inventory        3962    0    3962        4301    0    4301        4164    0    4164
        Closing Trade Inventory        4301    0    6021        4164    0    5830        4462    0    6247
        Payable Turnover ratio (T Times)        2.06        2.06        1.99        1.99        1.99    0.00    1.99
        Days Payable outstanding(DPO)    365    177.29        177.29        183.27        183.271        183.8742853159        183.87
            Payable turnover Ratio
        Days Recievable outstanding(DRO)    365    41.91        41.91        46.27        46.27        41.86        41.86
            Recievable turnover Ratio
        Days Inventory Outstanding(DIO)    365    52.54        63.48        53.08        63.53        54.88        66.24
            Inventory turnover Ratio
        Operating Cash Cycle/WCC    DIO + DRO -DPO    -82.84        -71.90        -83.91        -73.47        -87.13        -75.78
    Scenario E- IInventories of each of the 3 years are 20% lower than currently “forecasted”
                2018    Variance    Forecasted         2019    Variance    Forecasted         2020    Variance    Forecasted
                (€ million)        (€ million)        (€ million)        (€ million)        (€ million)        (€ million)
        Trade Recievable         6485    0    6485        6695    0    6695        4939    0    4939
        Inventories        4301    -20%    3441        4164    -20%    3331        4462    40%    6247
        Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Net Credit Purchases        28703    0    28703        29102    0    29102        28684    0    28684
        Opening Trade Payable        13426    0    13426        14457    0    14457        14768    0    14768
        Closing Trade Payable        14457    0    14457        14768    0    14768        14132    0    14132
        Opening Inventory        3962    0    3962        4301    0    4301        4164    0    4164
        Closing...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30