Question

In: Accounting

Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC...

Income statement and balance sheet data for The Athletic Attic are provided below.

THE ATHLETIC ATTIC
Income Statements
For the years ended December 31
   2019    2018
  Net sales $11,520,000 $10,000,000
  Cost of goods sold 7,520,000 6,200,000
       Gross profit 4,000,000 3,800,000
  Expenses:
      Operating expenses 1,680,000 1,630,000
      Depreciation expense 200,000 200,000
      Interest expense 48,000 48,000
      Income tax expense 496,000 430,000
        Total expenses 2,424,000 2,308,000
  Net income $1,576,000 $1,492,000
THE ATHLETIC ATTIC
Balance Sheets
December 31
   2019    2018    2017
  Assets
  Current assets:
      Cash $   233,000    $   162,000    $   220,000   
      Accounts receivable 998,000    748,000    768,000   
      Inventory 1,733,000    1,363,000    1,033,000   
      Supplies 138,000    108,000    83,000   
  Long-term assets:
        Equipment 1,420,000    1,420,000    1,420,000   
        Less: Accumulated depreciation (680,000) (480,000) (280,000)
          Total assets $3,842,000    $3,321,000    $3,244,000   
  Liabilities and Stockholders' Equity
  Current liabilities:
      Accounts payable $   198,200    $   129,000    $     112,200   
      Interest payable 4,800    0    4,800   
      Income tax payable 48,000    43,000    38,000   
Long-term liabilities:
      Notes payable 580,000    580,000    580,000   
  Stockholders' equity:
      Common stock 680,000    680,000    680,000   
      Retained earnings 2,331,000    1,889,000    1,829,000   
         Total liabilities and stockholders’ equity $3,842,000    $3,321,000    $3,244,000   
2018 2019
Receivables turnover ratio times times
Inventory turnover ratio times times
Current ratio to 1 to 1
Debt to equity ratio % %
2018 2019
Gross profit ratio % %
Return on assets % %
Profit margin % %
Asset turnover times times

Solutions

Expert Solution

Answer:

2019

2018

Receivables turnover ratio

13.1959

times

13.1926

times

Inventory turnover ratio

4.858

times

5.175

times

Current ratio

12.359

13.843

Debt to equity ratio

27.60%

29.27%

2019

2018

Gross profit ratio

34.72%

38.00%

Return on assets

44.00%

45.45%

Profit margin

13.68%

14.92%

Asset turnover

3.217 times

3.046 times

Working notes for the above answer is as under


Related Solutions

Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC...
Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC Income Statements For the years ended December 31 2022 2021 Net sales $ 11,240,000 $ 9,700,000 Cost of goods sold 7,340,000 6,000,000 Gross profit 3,900,000 3,700,000 Expenses: Operating expenses 1,660,000 1,610,000 Depreciation expense 200,000 200,000 Interest expense 46,000 46,000 Income tax expense 472,000 410,000 Total expenses 2,378,000 2,266,000 Net income $ 1,522,000 $ 1,434,000 THE ATHLETIC ATTIC Balance Sheets December 31 2022 2021 2020...
Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC...
Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC Income Statements For the years ended December 31 2019 2018   Net sales $11,800,000 $10,300,000   Cost of goods sold $7,700,000 $6,400,000        Gross profit $4,100,000 $3,900,000   Expenses:         Operating expenses $1,700,000 $1,650,000       Depreciation expense $200,000 $200,000       Interest expense $50,000 $50,000       Income tax expense $520,000 $450,000         Total expenses $2,470,000 $2,350,000   Net income    $1,630,000 $1,550,000 THE ATHLETIC ATTIC Balance Sheets December 31 2019 2018 2017   Assets      Current assets:   ...
Income statement and balance sheet data for Great Adventures, Inc., are provided below.
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC. Income Statement For the year ended December 31, 2022 Net sales revenues       $ 193,410   Interest revenue         400   Expenses:             Cost of goods sold $ 39,900         Operating expenses   68,480         Depreciation expense   18,650         Interest expense   10,276  ...
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC....
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC. Income Statement For the Year Ended December 31, 2020   Revenues:      Service revenue (clinic, racing, TEAM) $561,000      Sales revenue (MU watches) 136,000         Total revenues $697,000   Expenses:      Cost of goods sold (MU watches) 79,000      Operating expenses 305,176      Depreciation expense 59,000      Interest expense 30,624      Income tax expense 62,400                  Total expenses 536,200   Net income $160,800 GREAT ADVENTURES, INC. Balance Sheets December 31, 2020 and 2019 2020 2019...
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC....
Income statement and balance sheet data for Great Adventures, Inc., are provided below. GREAT ADVENTURES, INC. Income Statement For the year ended December 31, 2022 Net sales revenues $ 168,330 Interest revenue 160 Expenses: Cost of goods sold $ 38,700 Operating expenses 53,840 Depreciation expense 17,450 Interest expense 7,284 Income tax expense 14,700 Total expenses 131,974 Net income $ 36,516 GREAT ADVENTURES, INC. Balance Sheets December 31, 2022 and 2021 2022 2021 Assets Current assets: Cash $ 197,660 $ 64,540...
Using the formulas provided for the exam, and the balance sheet and income statement shown below,...
Using the formulas provided for the exam, and the balance sheet and income statement shown below, calculate the ratios (1 point each): CORRIGAN CORPORATION: BALANCE SHEET AS OF DECEMBER 31: Cash                                                         72,000 Accounts Receivable                              439,000 Inventory                                                 894,000             Total Current Assets               1,405,000 Land and Building                                  238,000 Machinery                                               132,000 Other Fixed Assets                                    61,000 Total Assets                                         1,836,000                                                           ========== Accounts Payable                                     80,000 Accrued Liabilities                                    45,010 Notes Payable                                         476,990             Total Current Liabilities            602,000 Long-term Debt                                       404,290              Total Liabilities                       1,006,290 Common Stock                                       ...
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet...
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet data, the end-of-year information is in the left column. Balance Sheet Data   20X2   20X1 Accounts Payable................................................................................................ 95............................................................. 165 Accumulated Depreciation................................................................................ 520 ...........................................................339 Cash      ................................................................................................................ 130 ..........................................................100 Common Stock ..............................................................................................    1,000......................................................... 700 DIVIDENDS PAYABLE......................................................................................... 40............................................................ 25 Equipment......................................................................................................... 2,395....................................................... 2,700 Income Tax Payable ..........................................................................................100............................................................ 135 Inventory.......................................................................................................... 1,120........................................................... 890 Mortgage Payable.............................................................................................. 900......................................................... 1,500 Prepaid General Expenses............................................................................... 300............................................................. 350 Retained Earnings (ending balance, after closing)...................................... 1,240...................................................... 1,098 Unearned Sales Revenue.....................................................................................
Provided below is the incomplete income statement (for 2020) and balance sheet (Dec 31 2019 and...
Provided below is the incomplete income statement (for 2020) and balance sheet (Dec 31 2019 and Dec 31 2020) for SCOTTY Inc. SCOTTY Inc. Income Statement For the year ended Dec. 21, 2020 Net sales $8,953 Cost of goods sold $5,865 Depreciation $? EBIT $? Interest paid $675 Earnings before taxes $? Taxes $400 Net income $705 Dividends paid $? Addition to retained earnings $450 SCOTTY Inc. Balance Sheet as at December 31, 2019 and 2020 2019 2020 2019 2020...
For the information provided below, prepare a balance sheet statement.
For the information provided below, prepare a balance sheet statement.The value of the land is $100,000 and the value of the building is $1,010,000.The current portion of the bonds payable is $80,000.The current portion of the notes payable is $50,000.The current portion of mortgage payable is $35,000.The marketable securities are being held to be sold if and when cash might be needed.The name of the company is UAN.The amounts shown are the ending amounts from the period from January 1,...
Create an income statement and balance sheet using the data below. Important: double the balance of...
Create an income statement and balance sheet using the data below. Important: double the balance of the Net Sales and make the necessary corrections to balance. Inputs Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120,000 Cash 7,000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, Plant, and Equipment 400,000 Interest Expense 15,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT