Firstly, you need to change, using the annual reports for Hasbro.
"Ending cash on the BS and SCF in the Excel spreadsheet differ from the annual report by $600 Mil for 2023. Prepaid expenses and other current assets differ by the same amount. All data check cell amounts must be zero."
This has to be correct before doing the next part of the assignment...which is complete the following assignments instructions below:
1. Use the same FSAP 9e spreadsheet you created for the “Your Company (YC) #1 assignment. This is a financial statement analysis spreadsheet template file accompanying the Financial Reporting, Financial Statement Analysis and Valuation textbook.
2. Add a new spreadsheet tab to the file. Name the tab “Income Statement Trends”.
A. Use the data from the common-size balance sheet in the "Analysis" tab, lines 128 thru 152 (INCOME STATEMENT ITEMS AS A PERCENT OF REVENUES), to evaluate revenue and expense trends over the five-year period. 1. In the "Income Statement Trends" spreadsheet tab, discuss the positive or negative income statement trends that are evident over the five-year period for ALL of the revenue and expense accounts. 2. In your comments, provide a reason or reasons why these trends may have occurred.
3. Add Another new spreadsheet tab to the file. Name the tab “Balance Sheet Trends”.
A. Use the data from the common-size balance sheet in the "Analysis" tab, lines 195 thru 243 (COMMON SIZE BALANCE SHEET – AS A PERCENT OF TOTAL ASSETS), to evaluate balance sheet trends over the five-year period. 1. In the "Balance Sheet Trends" spreadsheet tab, discuss the positive or negative balance sheet trends that are evident over the five-year period for ALL of the balance sheet accounts. 2. In your comments, provide a reason or reasons why these trends may have occurred.
4. Create another new spreadsheet tab titled “Statement of Cash Flows Trends”.
Questions
- On the "Statement of Cash Flows Trends" spreadsheet, discuss positive or negative cash flow trends that are evident of the five-year period for ALL operating, investing, and financing activities cash flows on the statements.
- In your comments, provide a reason or reasons why these trends may have occurred.