Question

Sunland Company has these comparative balance sheet data: SUNLAND COMPANY Balance Sheets December 31 2022 2021...

Sunland Company has these comparative balance sheet data:

SUNLAND COMPANY
Balance Sheets
December 31

2022

2021

Cash

$ 33,345

$ 66,690

Accounts receivable (net)

155,610

133,380

Inventory

133,380

111,150

Plant assets (net)

444,600

400,140

$766,935

$711,360

Accounts payable

$ 111,150

$ 133,380

Mortgage payable (15%)

222,300

222,300

Common stock, $10 par

311,220

266,760

Retained earnings

122,265

88,920

$766,935

$711,360


Additional information for 2022:

1. Net income was $31,000.
2. Sales on account were $380,200. Sales returns and allowances amounted to $27,700.
3. Cost of goods sold was $206,700.
4. Net cash provided by operating activities was $57,100.
5. Capital expenditures were $26,600, and cash dividends were $17,500.


Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.)

(a) Current ratio.

enter current ratio rounded to 2 decimal places

:1
(b) Accounts receivable turnover.

enter accounts receivable turnover in times rounded to 1 decimal place

times
(c) Average collection period.

enter average collection period in days rounded to 1 decimal place

days
(d) Inventory turnover.

enter inventory turnover in times rounded to 2 decimal places

times
(e) Days in inventory.

enter days in inventory rounded to 1 decimal place

days
(f) Free cash flow.

$enter free cash flow in dollars rounded to 1 decimal place

Homework Answers

Answer #1

Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.)

(a) Current ratio. 322335/111150 = 2.90 :1
(b) Accounts receivable turnover. (380200-27700)/144495 = 2.4 times
(c) Average collection period. 365/2.4 = 152.1 days days
(d) Inventory turnover. 206700/122265 = 1.69 times
(e) Days in inventory. 365/1.69 = 215.0 days
(f) Free cash flow. 57100-26600-17500 = 13000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Culver Company has these comparative balance sheet data: CULVER COMPANY Balance Sheets December 31 2022 2021...
Culver Company has these comparative balance sheet data: CULVER COMPANY Balance Sheets December 31 2022 2021 Cash $ 48,700 $ 29,900 Accounts receivable (net) 71,300 66,700 Inventory 70,300 58,600 Plant assets (net) 185,800 172,000 $376,100 $327,200 Accounts payable $ 50,200 $ 55,400 Mortgage payable (15%, due in 15 years) 94,100 123,900 Common stock, $10 par 172,800 100,600 Retained earnings 59,000 47,300 $376,100 $327,200 Additional information for 2022: 1. Net income was $21,800. 2. Sales on account were $426,000. Sales returns...
Current Attempt in Progress Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets...
Current Attempt in Progress Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31 2020 2019 Cash $ 16,000 $ 29,000 Accounts receivable (net) 71,000 59,000 Inventory 59,000 49,000 Plant assets (net) 205,000 182,000 $351,000 $319,000 Accounts payable $50,000 $59,300 Mortgage payable (15%) 106,500 106,500 Common stock, $10 par 141,500 124,500 Retained earnings 53,000 28,700 $351,000 $319,000 Additional information for 2020: 1. Net income was $24,000. 2. Sales on account were $404,100. Sales returns and allowances...
1. Using these data from the comparative balance sheet of Crane Company, perform horizontal analysis. (If...
1. Using these data from the comparative balance sheet of Crane Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Accounts receivable $ 489,060 $ 429,000 $enter a dollar amount enter percentages rounded to 0 decimal places % Inventory $ 731,250 $ 625,000 $enter a dollar amount enter...
Exercise 18-09 Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31...
Exercise 18-09 Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31 2020 2019 Cash $ 14,000 $ 29,000 Accounts receivable (net) 69,000 59,000 Inventory 59,000 49,000 Plant assets (net) 195,000 175,000 $337,000 $312,000 Accounts payable $50,000 $59,000 Mortgage payable (15%) 100,000 100,000 Common stock, $10 par 135,000 115,000 Retained earnings 52,000 38,000 $337,000 $312,000 Additional information for 2020: 1. Net income was $24,000. 2. Sales on account were $403,000. Sales returns and allowances amounted to...
Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for...
Nordstrom, Inc. operates department stores in numerous states. Selected hypothetical financial statement data (in millions) for 2022 are presented below. End of Year Beginning of Year Cash and cash equivalents $ 740 $ 77 Accounts receivable (net) 1,980 1,830 Inventory 900 910 Other current assets 310 443 Total current assets $3,930 $3,260 Total current liabilities $1,990 $1,630 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities...
The comparative statements of Cullumber Company are presented here. CULLUMBER COMPANY Income Statements For the Years...
The comparative statements of Cullumber Company are presented here. CULLUMBER COMPANY Income Statements For the Years Ended December 31 2022 2021 Net sales $1,894,200 $1,755,700 Cost of goods sold 1,063,575 1,011,200 Gross profit 830,625 744,500 Selling and administrative expenses 505,200 484,200 Income from operations 325,425 260,300 Other expenses and losses    Interest expense 23,500 21,500 Income before income taxes 301,925 238,800 Income tax expense 93,065 74,500 Net income $ 208,860 $ 164,300 CULLUMBER COMPANY Balance Sheets December 31 Assets 2022 2021...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable $581,000 Less: Allowance for doubtful accounts 37,000 During 2022, the company had the following transactions related to receivables. 1. Sales on account $2,355,000 2. Sales returns and allowances 49,000 3. Collections of accounts receivable 2,050,000 4. Write-offs of accounts receivable deemed uncollectible 38,000 5. Recovery of bad debts previously written off as uncollectible 16,000 Compute the accounts receivable turnover and average collection period, assuming...
The following data exists for Crane Company. 2022 2021 Accounts Receivable $84,000 $78,000 Net Sales 563,000...
The following data exists for Crane Company. 2022 2021 Accounts Receivable $84,000 $78,000 Net Sales 563,000 415,000 Calculate the accounts receivable turnover and the average collection period for accounts receivable in days for 2022. (Round answers to 1 decimal place, e.g. 15.2. Use 365 days for calculation.) Accounts receivable turnover Enter the accounts receivable turnover in times times Average collection period Enter the average collection period in days days
Pharoah Company provides you with the following balance sheet information as of December 31, 2022. Current...
Pharoah Company provides you with the following balance sheet information as of December 31, 2022. Current assets $10,350 Current liabilities $10,800 Long-term assets 23,850 Long-term liabilities 12,600    Total assets $34,200 Stockholders’ equity 10,800    Total liabilities and stockholders’ equity $34,200 In addition, Pharoah reported net income for 2022 of $14,400, income tax expense of $2,880, and interest expense of $1,170. Compute the current ratio and working capital for Pharoah for 2022. (Round current ratio to 2 decimal places, e.g. 2.75. Enter...
The following data exists for Ivanhoe Company. 2022 2021 Accounts Receivable $85,000 $77,000 Net Sales 561,000...
The following data exists for Ivanhoe Company. 2022 2021 Accounts Receivable $85,000 $77,000 Net Sales 561,000 477,000 Calculate the accounts receivable turnover and the average collection period for accounts receivable in days for 2022. (Round answers to 1 decimal place, e.g. 15.2. Use 365 days for calculation.) Accounts receivable turnover times Average collection period days