Question: Please display the content only in excel format. Thank you . The following information to answer the questions are provided below . Using the information

Please display the content only in excel format. Thank you.
The following information to answer the questions are provided below.
 Please display the content only in excel format. Thank you. The
following information to answer the questions are provided below. Using the information
Using the information from above, respond to the questions that are provided below:
from above, respond to the questions that are provided below: The response
The response for 1a-1d and 2a-2d should be in EXCEL FORMAT. Part 3 is a written response that can be delivered in any formal way.

THE ATHLETIC ATTIC Income Statements For the years ended December 31 2022 2021 Net sales $10,400,000 $8,900,000 Cost of goods sold 6,800,000 3.450,000 3.600.000 3.450,000 Gross profit Expenses Operating expenses Depreciation expense 1,600,000 1.600.000 200,000 210.000 Interest expense 40.000 50.000 Income tax expense 400,000 360,000 Total expenses 2.240.000 2.220,000 Net income S 1.360,000 $1.230,000 THE ATHLETIC ATTIC Balance Sheets December 31 2022 2021 2020 Assets Current assets Cash $ 225,000 $ 214,000 $ 164,000 790,000 1.405.000 810.000 1,075,000 85,000 110.000 1,150,000 1,150,000 (420,000) (210.000) $3.199.000 $3,124,000 Accounts receivable 990,000 Inventory 1.725,000 Supplies 130.000 Long-term assets: Equipment 1,100,000 Less: Accumulated depreciation (600,000 Total assets $3,570.000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 175.000 Interest payable 4,000 Income tax payable 40,000 Longterm liabilities: Notes payable 500.000 Stockholders' equity Common stock 600,000 Retained earnings 2.251.000 Total liabilities and stockholders' equity $3.570,000 $ 115,000 $ 91,000 0 5.000 40.000 31,000 600.000 600,000 700.000 700,000 1.744,000 $3.199.000 1.697,000 $3.124.000 Required: 1. Calculate the following risk ratios for 2021 and 2022: a. Receivables turnover ratio. b. Inventory turnover ratio. c. Current ratio. d. Debt to equity ratio. 2. Calculate the following profitability ratios for 2021 and 2022: a. Gross profit ratio. b. Return on assets. c. Profit margin d. Asset turnover. 3. Based on the ratios calculated, determine whether overall risk and profitability improved from 2021 to 2022

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!