asap please

calculations and report writing

For this assignment the company is Kingfisher You have to use S&P capital to get the data. If you do not have S&P capital account let me know I will send you my login details. Data from other sources are not accepted. Every data and calculations must be presented in Excel. Take screenshot of excel and put it in the word doc while writing up the assignment. I am also sending you a sample with the excel file. This coursework should be done like that. The sample coursework had the exact same question but different company. Assignment Please read the article entitled Are FTSE 100 Dividends Sustainable ? - Dividend Dashboard Q1 2018 from AJ Bell which can be found here: https://www.youinvest.co.uk/sites/default/files/AJ_Bell_Dividend_Dashboard_Q1_2018.pdf The article mentions the following companies listed on London Stock Exchange: Anglo American DS Smith G4S Glencore International Cons. Airlines Kingfisher Micro Focus Sainsbury Schroders WPP You will be allocated ONE company from the list above. Write a report to an investor considering investing in the company that you have selected, referring to the companys listing on the London Stock Exchange. Your report should cover the following areas: (a) Discount Rates & Capital Structure i. Calculate your chosen companys Cost of Equity (Ke), Cost of Debt (Kd), and Weighted Average Cost of Capital (WACC) for each year for at least the last 5 years. Show your workings and state the sources for any of your assumptions. (15 marks) ii. Critically assess and discuss the capital structure that your chosen company has and the impact that these choices have made on its cost of equity, cost of debt, and WACC. If your company has any debt funding, assess its ability to make the repayments required using a range of appropriate ratios. (10 marks) (b) Dividend Policy: i. What has the company paid out as dividends in each of the last 5 years? How is it changing? ii. Critically assess whether these pay-outs are affordable using a variety of measures. iii. Critically analyse whether the dividends that have been paid are consistent with the companys stated dividend policy. Provide appropriate academic theory on dividend policy where appropriate. (15 marks) (c) Valuation Value the equity shares of your chosen company using both Static valuation multiples An absolute valuation technique of your choice In both cases justify your choice of any parameters that you use. (20 marks) (d) Critically discuss where your chosen company is in the Corporate Life Cycle discussed during the module, and described in Corporate Financial Strategy by Ruth Bender, by analysing its: Revenue & profit growth Financing (proportions of debt and equity funding ) Free Cash Flow Dividend Payout ratio Justify your answer of where the company is in its lifecycle with a range of comparisons of the companys performance (20 marks) (e) Using the share price information analyse Shareholder Value performance for your company over at least the last 5 years. Critically assess its performance on each of the seven Rappaport Value Drivers and compare its performance against its leading competitors. (20 marks) Total (100 marks) Throughout your submission you should make reference, where possible, to appropriate academic theories. You must show YOUR workings for all ratios you should NOT use ratios calculated by other sources. If you use Excel for any calculations paste a copy/copies of the appropriate worksheets, showing values AND formulae into your Appendix.