Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 »
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 has to be included in the introduction paragraph when answering questions. ONLY the excerpts of the case study financial statements must be shown in the appendix. Note that failure to submit the said financial statements will cause your paper NOT to be assessed
QuestionsSelect a public company that is in the business of producing and marketing fast-moving consumer goods (e.g., Unilever). Be sure to timely enlist the company of your choice with your teacher, as a company can only be used once in each class. The enlisting will be done on a first-come, first- served basis.To execute the tasks below consult the company’s annual report over the 3-year period XXXXXXXXXXIn addition to the requirements for each question, ensure to provide formulas, assumptions and models as appropriate. Analysis or conclusions which are not based on the applicable theory will consequently limit your marks.
Task 1. Ratio analysis (30 marks)Analyse the company’s consolidated financial statements using:A. 3ProfitabilityratiosB. 3EfficiencyratiosC. 2 Liquidity ratiosD. 2 Financial gearing ratiosReflect on the development of the ratio outcomes over the 3-year period and provide your conclusions and recommendations to the Board.
Task 2. Sensitivity analysis (20 marks)Treat the figures in the XXXXXXXXXXIncome Statement and Balance Sheet of the company of your choice as to if it were a prognosis. You are asked to execute a separate sensitivity analysis on the original figures as presented in the company’s annual report with each of the following 4 items, using the percent of sales method:A. Sales in each of the 3 years are 10% higher than currently “forecasted”B. Sales in each of the 3 years are 10% lower than currently “forecasted”C. Operating costs in each of the 3 years are 7% higher than currently “forecasted”D. Operating costs in each of the 3 years are 7% lower than currently “forecasted”Show the effects that each of the situation’s A, B, C, and D have on the total 3-year Income Statements and Balance Sheets, including the effect on the required financing.Discuss the implications of each of these effects with the Board and draw conclusions with respect to the main risks in the business over this “prognosis” period.Type 1 Examination
Task 3. Working capital analysis (25 marks)In this task, you are also to assume that the figures in the XXXXXXXXXXIncome Statement and Balance Sheet of the company of your choice are a 3-year prognosis. Discuss the effects of eachof theA. B. C. D. E. F.following 6 deviations from the original figures on the operating cash cycle in all 3 years:Trade receivables of each of the 3 years are 10% higher than currently “forecasted” Trade receivables of each of the 3 years are 20% lower than currently “forecasted” Trade payables of each of the 3 years are 30% higher than currently “forecasted” Trade payables of each of the 3 years are 15% lower than currently “forecasted” Inventories of each of the 3 years are 40% higher than currently “forecasted” Inventories of each of the 3 years are 20% lower than currently “forecasted”Based on your analysis provide recommendations to the Board on what the focus of their working capital management should be for each of the six (6) scenarios above.
Task 4. Capital structure analysis (25 Marks)a) Discuss the capital structure of the company over the years XXXXXXXXXX, relating the term of the different sources of funds to the term of the different uses of funds. Ensure to provide the rationale for your conclusions for each of the ‘’term of sources and application (uses)’’ of funds based on the appropriate concepts used in capital budgeting.b) Explain the difference between Ordinary and Preference share. What affects the value of a share price?
Answered 1 days AfterJan 16, 2022

Solution

Sandeep answered on Jan 18 2022
57 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
        Cu
ent Ratio    Cu
ent Assest    0.783    0.783    0.785
            Cu
ent Liability
        Quick Ratio    Cu
ent Assest - Inventory    0.565    0.585    0.568
            Cu
ent 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 cu
ently “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 cu
ently “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 cu
ently “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 cu
ently “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 cu
ently “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 cu
ently “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