Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Thomas Edmonds, Christopher, Philip Olds, Frances McNair, Bor

4th edition

77862376, 978-0077862374

More Books

Students also viewed these Accounting questions

Question

Describe how projective tests are used.

Answered: 1 week ago