For this project you will select a publically traded company to do an analysis of the comany, including a sensitivity analysis. You will be providing completed spreadsheets and a written paper (4-6 pages of analysis).
.
1. Select a publically traded company (you can use your own organization if the financial data is available.**you will need to provide the professor (attached) where you pulled the information from.
2. Gather 2 years of financial data and use a sensitivity template and/or projection templates (budgets), and any others you find to be necessary, to take the information into the future.
3. Read the notes in the report about what the future plans of the organization are – and based upon that make some assumptions to use in your projections for the future. Be sure to include any capital projects planned.
4. Provide in a separate document your thoughts and conclusions on the future of the organization based upon your findings. Be sure to look deeply into the results. Describe your predictions for the financial success of the firm into the future. Feel free to include a discussion on debt financing, fixed asset ratios, and liquidity.
