I need help with this

Assignment instructions are as follows: 1. 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. 2. 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 formulos to caiculate all totais and sub-totals. 3. 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. 4. Save your Excel workbook Prolect3-your lost name. (For example: Project3-Smith.xis). 5. Upload the completed assignment to Cama using the link provided. GRADING RUBRIC: FORMATTING (15\%) Statement of Cash Flow should be formatted and easy to read/follow. This includes: - Properly underlined subtotals and grand totals. - Consistency in formatting (i.e. If decimals are used, they should be consistent. Are dollar signs used consistently?) ACCURACY/COMPLETENESS (25\%) The Statement of cash flows and ratios were completed by linking the cells back to the financial statements. STATEMENT OF CASH FLOWS (30%) All sub-totals and totals are accurately calculated (using Excel formulas). All sections of the statement are included and correctly subtotaled. The Statement matches the change in cash from the Balance Sheet. RATIOS (30\%) All ratios are accurately calculated (using Excel formulos). H \& K INC. H \& KINC. Balance Sheet December 31, 2023 and 2022 $ in millions Current Assets Cash and cash equivalents Accounts Receivable, net Merchandise inventorles Other current assets Total current Assets \begin{tabular}{rrr} 2023 & 2022 \\ \hline$ & 18,953$ & 9,839 \\ 3,512 & 2,010 \\ 3,120 & 4,029 \\ 315 & 326 \\ \hline 25,900 & 16,204 \end{tabular} Long-Term Assets Property and equipment Accumulated deprecialon Intangible assets, net of accumulated amortization Total Long-Term Assets Total Assets \begin{tabular}{rrr} & 13,405 & 11,995 \\ & (3,990) & (3,220) \\ & 148 & 193 \\ \hline$,563 & 8,968 \\ \hline$ & 35,463$ & 25,172 \\ \hline \end{tabular} Current Liabilities Accounts payable Accrued liabilities Income taxes payable Current portion of long-term debt Total Current Liabilities Non-current Liabilities Lons-term debt Total Liabilities \begin{tabular}{rr} 4,699 & 4,525 \\ \hline 9,736 & 9,555 \end{tabular} Sharaholders' Equity Common stock; 01 par value; 9,000 shares authorized; 380 and 370 shares issued & outstanding respectively Paid-in capital Treasury stock, at cost Retained earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity The coogharv oac cash tividends of 5350 in 2023. The comgary porchased 52.75 in epaipment for cash during the yes, In adehich, ansigment wat sold for 51,100 in cash: the equpmeot had a book value at the tine of wale of 5 joo There were no purchases or wiles ar intanisble assets. The company made pevments of 5250 on its debt obligations aed took an addetional Stso in debt during the year. Sunflower Designs Statement of Cash Flows (Indirect Approach) For the Year Ended March 31, 2017 USD (\$) in Millions H \&. KINC. Statement of Cash Flows For the Year Ended December 31, 2023 USD (\$) in Millions Sunflower Designs Ratio Analyses -or the Year Ended March 31, 2017 Current Ratio = Acid-Test Ratio - AR Turnover = Days Soles Uncollected = Inventory turnover = Days sales in Inventory = Total Asset Turnover - Debt to fquity = Times Interest Earned - Net Profit Margin = Return on Total Assets = Return on Stockholders Equity = Farnings per Share (EPS) =