Question

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 amounted to $20,600.
3. Cost of goods sold was $199,800.
4. Net cash provided by operating activities was $45,100.
5. Capital expenditures were $24,800, and cash dividends were $9,600.


Compute the following ratios at December 31, 2020. (Round current ratio to 2 decimal places, e.g. 1.67. Round Accounts receivable turnover, Average collection period, Inventory turnover and Days in inventory to 1 decimal place, e.g. 1.6.)

(a) Current ratio enter the Current ratio rounded to 2 decimal places :1
(b) Accounts receivable turnover enter the Accounts receivable turnover rounded to 1 decimal place times
(c) Average collection period enter the Average collection period rounded to 1 decimal place days
(d) Inventory turnover enter the Inventory turnover rounded to 1 decimal place times
(e) Days in inventory enter the Days in inventory rounded to 1 decimal place days
(f) Free cash flow $enter a dollar amount

Homework Answers

Answer #1
(a) Current ratio 2.92 : 1 =(16000+71000+59000)/50000
(b) Accounts receivable turnover ratio 5.9 Times =(404100-20600)/((71000+59000)/2)
(c. ) Average Collection period            61.9 Days =((71000+59000)/2)*365/(404100-20600)
(d) Inventory Turnover 3.7 Times =199800/((59000+49000)/2)
(e.) Days in Inventory            98.6 Days
(f) Free Cash Flows        20,300 $ =45100-24800
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
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...
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...
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...
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...
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...
Current Position Analysis The following items are reported on a company's balance sheet: Cash $334,100 Marketable...
Current Position Analysis The following items are reported on a company's balance sheet: Cash $334,100 Marketable securities 261,000 Accounts receivable (net) 312,900 Inventory 136,200 Accounts payable 454,000 Determine (a) the current ratio and (b) the quick ratio. Round to one decimal place. a. Current ratio b. Quick ratio Accounts Receivable Analysis A company reports the following: Sales $1,931,580 Average accounts receivable (net) 71,540 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim...
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
In 2020, Nash Company has net credit sales of $1,030,000 for the year. It had a...
In 2020, Nash Company has net credit sales of $1,030,000 for the year. It had a beginning accounts receivable (net) balance of $100,000 and an ending accounts receivable (net) balance of $106,000. Compute Nash Company’s accounts receivable turnover. (Round answer to 1 decimal place, e.g. 2.5.) Accounts receivable turnover times       Compute Nash Company’s average collection period in days. (Round answer to 1 decimal place, e.g. 2.5. Use 365 days for calculations.) Average collection period days
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT