Assignment task:
Methodology 1. Pick a listed company. It's okay if two groups pick the same company; I only request that each group submit their own valuation and spreadsheet. 2. For the company you have chosen, download and enter on your worksheet the income statement, balance sheet and cash flow statement for the past five years. (This gives us two years pre-Covid and two post-). You may gather these data from CapitalIQ (all Pitt Business students have free access to this database) or from the company's 10-K statements (annual reports) which you can Google for - usually companies post these on their websites under "Investor Relations." 3. Following our forecasting models from class work, forecast the free cash flows for this company for a horizon of your choice. Choose the horizon based on the nature of the company after discussion. 4. Estimate the cost of capital for your company. 5. Using discounted cash flow (DCF) methodology, derive the value the company.