Make Firm Valuation Report on TESCO PLC

A technical document (max. 9000 words - pls note: its a limit, not min.) in which you report and carefully discuss your model and the underlying assumptions that you made. The Technical Report In the technical report, you will carefully discuss the decisions that you made when building your Excel spreadsheet. I therefore expect you to carefully comment each step of your valuation model and justify your assumptions (in terms of number of growth stages, growth rates, FCF, discount rate, etc.) The report should not include theory: I want to know why you made the decisions that appear in the spreadsheet. You must submit your technical report in PDF format. The report should be between 8000-9000 words (excluding the title page and appendices) but it should include the following elements. 1. Overview of the company : Short history, main business(es), business and geographical segments (which are most profitable and most rapidly growing?), management team, leadership (if relevant), shareholder structure, size indicators (revenues, market cap, number of employees), strategy and any expected changes. 2. Industry overview and firm’s competitive advantage: Is this a cyclical or a defensive industry? What are the main trends in the industry? What growth is expected in the short-/long-term? Who are the main competitors? 3. Financials: Evolution of revenue and profitability (EBIT margin, earnings per share) over time; trends in debt levels; dividends; any other fundamental indicators relevant for your company. 4. Growth drivers Strictly No Plagiarism, No Copy Paste - Otherwise no payment