I recommend checking on FactSet early on that you’re able to access data on your firm.
For the assignment, you will
Summarize firm’s info
Forecast future performance
Perform DCF analysis
Perform multiples analysis
Scenario & sensitivity analyses
Calculate Beta (levered & unlevered)
Calculate WACC
Recalculate hypothetical WACC using different capital structure
Apply Gordon Growth Model
Illustrate payout policies
Make a buy/sell recommendation
Rubric attached for your convenience: Firm analysis rubric v3.2.xlsx Download Firm analysis rubric v3.2.xlsx
You can submit everything in the Excel file answering all questions listed in the rubric and an Excel file with all your calculations.