Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed
image text in transcribed
Using the information from above, respond to the questions that are provided below:
image text in transcribed
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

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

Step: 3

blur-text-image

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, and Terry D. Warfield

15th edition

978-1118159644, 9781118562185, 1118159640, 1118147294, 978-1118147290

More Books

Students also viewed these Accounting questions