I require an Excel file with models built from scratch based on the 2013 Tesco Annual report. And a 2500 word report.
These are the steps:
• Balance the balance sheet by calculating company liquidity as well as gearing percentages.
• The model would also balance Forecast the receivables and creditor days in relation to the business situation as a percentage of sales approach.
• Adding non-cash items such as depreciation, amortization and changes in working capital.
• Error and feasibility check of the assumptions mainly using historical figures and calculations of past years.
• Provide a Comparison of industry competitors and changes in assumptions that would affect operations, investments and financing.
• Determine the competiveness of the market and include a ratio analysis of NOPAT and economic profit to determine the credibility of future forecasting.
• Calculate free cash flow and capex required to pay shareholders and debtors.
• Include a fade period and calculate the capex to sales ratio.
• Information and references would be traced from the official annual report as well related news articles to the purpose of the Analysis.