Please help! All information is provided!

Assignment instructions are as follows: 1. 2. 3. 4. 5. Use the information in the provided Income Statement and Balance Sheet to create the 2023 Statement of Cash Flows for H&K Inc. This should be created on the appropriate Tab of the Excel Workbook Template provided on Canvas. Formulas: a. use Excel to setup the Statement of Cash Flows by linking the values from the Income Statement and the Balance Sheet. b. Use Excel formulas to calculate all totals and sub-totals. Complete the ratio calculations for 2023 on the appropriate tab using the Income Statement and Balance Sheet. All ratios should be linked back to your financial statements. Save your Excel workbook Proiect3-vour last name. (For example: Project3-Smith.xls). Upload the completed assignment to Canvas using the link provided. Statement For the Years Ended December 31, 2023 and 2022 $ in millions Stet 202' 'rd 2022 10 11 13 14 16 17 19 20 21 22 23 24 Revenue Net sales Cost of merchandise sold Gross Profit Operating Expenses Selling, general and administrative Depreciation Amortization Operatirw income Interest expense, net Gain on sale of property and equipment Income before income taxes Provision for income taxes Net incorne K INC. Statement Of Cash Flows (Indirect Method) For the Year Ended December 31, 2023 USD ($) in Millions 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 53,478 35,922 17,556 8,907 1,678 63 6,908 367 570 7,111 1,778 5,333 46,219 28,435 17,784 7,654 1,230 63 8,837 319 230 8,748 2,187 6,561 Cash cash equivalents A CCOuntS receivable , net mer oment assets TMaI Current Assets and Accumulated Inta"ible assets, Mt Total Assets TMaI Awts A counts liablitieS tams mon lorwterm Current Lia*lities S Emity Corm-on stx*' .01 par value; shares a'tuited; 390 and shares issued L Paid-in capital at Retained earnirws Total Shar&lders' Equity The ash Of SIRO in 2023. 1,988 29,832 12,870 14,510) 8,445 77 1,574 8, 708 3,968 (3.039) 28.636 29.569 3,315 3, 576 12, 405 8, 761 2,619 9, 765 3.518 (2,824) 23,483 24,181 The 2023, for 2021. NO The purdtased $1,875 in equiprmnt cash during the year. In a"ition. equiprtnt was sdd 51.020 in cash had a at There were no purchases or sales of intangible assets. Of on its debt and an in year. 2023 hmtory turnovg DM in hvmtory Tot Turnovg to EquRy htst N Profn Mxn Rurn on Tot* Asss Rum Equity Eznh (EPS)