I need help with the below.. I do not know where to go with this...

The company is Tootsie Roll Industries, Inc. - The financial statements for Tootsie, Inc. are published via the company's web site. The information included herein contains, in part, income statement and balance sheet information for the periods ending 12/31/16 through 12/31/18.

make a financial analysis (spreadsheet) in Excel using the company's financial statements.The spreadsheet should include historical financial statements (balance sheet and income statement), projected financial statements (balance sheet and income statement), a three year ratio analysis of the company's historical financial statements, and a three year ratio analysis of the company's projected financial statements.The accounting periods for the historical are 12/31/16, 12/31/17 and 12/31/18l and projected analysis are 12/31/19, 12/31/20 and 12/31/2021. The ratio analysis should include several types of liquidity, solvency, and profitability ratios. Incorporate industry comparisons with your ratio analysis and list your assumptions

statement for the periods ending 12/31/2016, 12/31/17, 12/31/2018, 12/31/2019, 12/31/2020, and 12/31/2021 in one tab. Enter the balance sheet for the aforementioned years in a separate tab of your spreadsheet. Column A of each tab will list the account names such as, in part, Net Product Sales, Rental and Royalty Revenue, Cash and cash equivalents, etc. Each column thereafter will list the annual accounting numbers. Add a separate column for each year.

It should be consistent and conform with the company's 10-K. With respect to the income statement, include the accounts net product sales through net earnings attributable to Tootsie Roll Industries, Inc.