Due to the COVID-19 pandemic keeping families at home, demand for toys and board games have been on the rise. This has led to investors paying more attention to toy and gaming companies such as Hasbro.

The client would like to know if it is now worth investing in Hasbro despite under-performing the past few years. Consider that Hasbro’s revenues have been declining since Toys “R” Us went bankrupt in 2018.

Your task is to:

1. Create a 3-statement model and forecast Hasbro’s financial performance until 2025
2. Conduct a Discounted Cash Flow (DCF) valuation
3. Conduct a Porter’s 5 Forces analysis
4. The client would like you to present your findings through a PPT. Conclude the presentation with your recommendations to the client.

Submit the first two requirements as an excel file, the third requirement as a word document and the last requirement as a PowerPoint presentation. State relevant assumptions used in your computations. You may also use Hasbro’s 2020 Q1 data to help contextualize the effect of the pandemic on their current and future business performance.

you can download a template for the three statement model here.
https://corporatefinanceinstitute.com/resources/knowledge/modeling/3-statement-model/