Choose a company to value. Create a spreadsheet with 5 yrs o

Choose a company to value. Create a spreadsheet with 5 yrs of historical information and 5 years of projected information. Compute NI, FCF for all 10 years. Follow the example given. Place a Horizon value on the firm at the end of 5 years. Discount the FCF of 5 year to the horzon. Total valuation. 1. Balance sheet must balance2.Compute the free cash flow and disposition of free cash flow.3.Take a look at the case study rubric, try to answer the questions.4.The spread sheet should follow the example given.