Part A - Creating the Excel Workbook A.1 - Financial Statement Analysis and Valuation You are an analyst at the valuation department of a consulting firm. You are required to build a valuation forecast model and arrive at a valuation calculation for a UK-based, public company of your choice. The Data Collect the most current financial statement data from the company's annual reports. Tasks In an Excel worksheet, complete the following tasks: a) Clearly outline your model assumptions. b) Create forecasting models for the key financial statements, including income statement, balance sheet, and cash flow statement. c) Calculate and analyse key performance ratios and the WACC. d) Perform cash flow valuation. e) Perform sensitivity analysis.