Create a financial model and analysis for a publicly traded company, including historic and pro forma financial statement analysis. A suggested format for the model is shown below. In one excel file, include a worksheet for: Revenues Income Statements Balance Sheets Cash Flow Statements Ratios Peer firm ratios Collect 10 years of data, forecast 3 years into the future. Use a common sized and indexed statement below the nominal statements. Use cell address links to connect each statement for the 3 years you are forecasting into the future. For most companies, you can use CAGR to project revenues, and % of revenues for all other income statement items. For some kinds of firms, for example those with exponential growth, like TESLA, you cannot use CAGR but will have to rely on a best fitting quadratic function as suggested in Excel. Again, think about each problem, make a decision, and state your assumption.Include bar, line, and pie charts throughout to illustrate concepts and numbers. The report should be single spaced and in electronic (word and/or excel).