Financial Statement Analysis Excel Spreadsheet

Description

Fill in the the attached excel spreadsheet, “Copy of FSAP 9e – Template Blank”, with the correct data. For the company “Hasbro” using its annual reports (balance sheet, income statement, statement of cash flows and supplemental data). Make sure that all the numbers add up correctly to the data, for example the “current liabilities” must be the same on the excel sheet as it is on the financial statements. It needs to be done for all the 6 years; 2023,2022,2021,2020,2019,2018.

Do not copy and paste in the numbers from a downloaded version of the balance sheet, they must be entered manually.

I have included a downloaded version of the balance sheet, both standardised and as reported, for Hasbro from the website Mergent that you can use, you can also find the data on annual reports from the Hasbro website. I have also included the income statement standardised and as reported. You will need to find the data for the statement of cash flows and supplemental data. It is most important that everything adds up correctly and again it cannot be copy and pasted it must be done manually. Thank you