Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am having trouble setting this up and solving the ratios 1. Use the information in the provided Income Statement and Balance Sheet to create
I am having trouble setting this up and solving the ratios
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: 3. 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. 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 Project3-your last name. (For example:Project3-Smith.xIs). 5. Upload the completed assignment to Canves using the link provided. GRADING RUBRIC: FORMATIING (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. Aredollar signs used consistently?) ACCURACY/COMPLETENESS (25\%) The Statement of cash flows and ratios were completed by linking the calls 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 formulas). H \& K INC. Income Statement For the Years Ended December 31, 2023 and 2022 \$ in millions 20232022 Revenue Net sales Cost of merchandise sold Gross Profit Operating Expenses Selling, general and administrative Depreciation Amortization Operating income \begin{tabular}{|rr|} \hline 7,850 & 7,182 \\ 1,822 & 1,010 \\ 45 & 45 \\ \hline 12,957 & 14,644 \\ \hline \end{tabular} Interest expense, net Gain on sale of property \& equip Income before income taxes \begin{tabular}{|r|r|} \hline 276 & 235 \\ \hline 800 & 350 \\ \hline 13,481 & 14,759 \end{tabular} Provision for income taxes Net income $10,111$11,069 H 8K INC. Balance Sheet Deecmber 31.2023 and 2022 The conporypwd cash ovidende 1350in2023 Thec- ueienopyrchases or sales dirtangble apieta The oompany made paymervir of 1250 on iur debt oblgations, and took an addrichal 1450 in debt durngthe yeat Acid-Test Ratio = AR Turnover = Days Sales Uncolleoted = Inventory turnover = Days sales in Inventory = Toral Asset Turnover = Debrto Equity = Times lnterest Earned = Net Profi Margin = Returrion Total Assers = turn on Stockholders Equily= Earnngsper Share (EPS)= Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started