The mid-term project tests you Chapters 1-7. In this project, you need to select a public company and apply everything you have learned so far in this class to give an analysis. Your submission should include (not limited to): 1. Overview of the public company that you select. 2. Financial statements, i.e. the balance sheet and the income statement, and give a brief analysis of the company's finances. 3. Step by step calculation of the free cash flow (FCF). 4. Financial ratio analysis: liquidity ratios, asset management ratios, debt management ratios, profitability ratios, etc. 5. Estimated required return on the company's stock by using the capital asset pricing model (CAPM). 6. Stock valuation. Use one of the following valuation models: FCF valuation model with a constant growth rate on FCF. FCF valuation model with non-constant growth Dividend valuation model with constantly growing dividend Dividend valuation model with non-constantly growing dividend You can upload a word or excel file. Either way, please make your calculation and analysis in detail.