Question

In: Accounting

The following are the selected account balances or total as of January 1, 2020: Accounts receivable

The following are the selected account balances or total as of January 1, 2020:

Accounts receivable $380,000

Merchandise Inventory $260,000

Current Liabilities $280,000

Selected relationship for the year:

Gross profit rate 40%

DSO based on average 40 days

Inventory turnover based on COGS 8X

Current ratio 3:1

Acid Test ratio 2:1

The balance of accounts receivable as of December 31, 2020 is

$380,000
$390,000
$400,000
$420,000

Expert Solution

Answer:

Option D: $420,000

Explanation:

Current Ratio = 3:1

Therefore, Current asset = Current liabilities × 3

= $280,000 × 3 = $840,000

Acid test ratio = 2:1

Therefore, Quick asset = Current liabilities × 2

= $280,000 × 2 = $560,000

Closing inventory = Current assets – Quick assets

Closing inventory = $840,000 -$560,000 = $280,000

Average inventory = (Opening inventory + Closing inventory) / 2

Average inventory = ($260,000 + $280,000) /2 = $270,000

Inventory turnover based on COGS 8X

Therefore, COGS = Average inventory × 8

COGS = $270,000 × 8 = $2,160,000

Gross profit rate = 40%

Therefore, COGS rate = 100%-40% = 60%

Total sales = COGS / COGS rate

Total sales = $2,160,000 / .6

Total sales = 3,600,000

Days sale outstanding (DSO) based on average = 40 days

Receivables turnover = 360 days / 40 days

Receivables turnover = 9

Average Receivables = Total Sales / Receivables turnover

Average Receivables = 3,600,000 / 9

Average Receivables = $400,000

Average Receivables = (opening Receivables + closing Receivables) / 2

$400,000 = ($380,000 + Closing receivables) / 2

Closing receivables / 2 = $400,000- $380,000/2

Closing inventory = $210,000 × 2

Closing inventory = $420,000

ekkarill92 answered 1 year ago

On January 1, 2020, the general ledger of a Company includes the following account balances: Accounts...

On January 1, 2020, the general ledger of a Company includes the following account balances: Accounts Debit Credit Cash $ 84,000 Accounts Receivable 53,000 Allowance for Uncollectible Accounts $ 5,000 Inventory 44,000 Building 84,000 Accumulated Depreciation 24,000 Land 214,000 Accounts Payable 34,000 Notes Payable (8%, due in 3 years) 48,000 Common Stock 114,000 Retained Earnings 254,000 Totals $ 479,000 $ 479,000 The $44,000 beginning balance of inventory consists of 400 units, each costing $110. During January 2020, the following transactions...

American Laser, Inc., reported the following account balances on January 1. Debit Credit Accounts Receivable $...

American Laser, Inc., reported the following account balances on January 1. Debit Credit Accounts Receivable $ 5,000 Accumulated Depreciation $ 30,000 Additional Paid-in Capital 122,000 Allowance for Doubtful Accounts 2,000 Bonds Payable 0 Buildings 279,000 Cash 18,000 Common Stock, 10,000 shares of $1 par 10,000 Notes Payable (long-term) 18,000 Retained Earnings 120,000 Treasury Stock 0 TOTALS $ 302,000 $ 302,000 The company entered into the following transactions during the year. Jan. 15 Issued 21,000 shares of $1 par common stock...

On January 1, Griffin Company had the following (normal) account balances: Accounts Receivable: $69,400 Allowance for...

On January 1, Griffin Company had the following (normal) account balances: Accounts Receivable: $69,400 Allowance for Bad Debts: 1,270 The bookkeeper, Barbara Jackson, has prepared the following information for the year to assist you in creating a balance sheet. Credit Sales for the Year: $230,400 Collections of Accounts Receivable: 228,040 Write-off of Bad Debts: 160 Bad Debts Expense for Year: 350 (recorded as an adjusting entry on December 31)

ohnson Company had the following selected account balances: Cash, $20,000 Accounts Receivable, $22,000 ...

ohnson Company had the following selected account balances: Cash, $20,000 Accounts Receivable, $22,000 Merchandise Inventory, $48,000 Equipment, $100,000 Accounts Payable, $26,000 Note Payable due in six months, $12,000 Mortgage Payable due in five years, $75,000 What is Johnson Company's working capital? Multiple Choice $2,000 $52,000 $62,000 $77,000

Jr-6Wq Company reported the following account balances at January 1, 2039: accounts receivable ................ $246,822 allowance...

Jr-6Wq Company reported the following account balances at January 1, 2039: accounts receivable ................ $246,822 allowance for bad debts ............ $ 25,155 During 2039, Jr-6Wq Company wrote-off as uncollectible accounts receivable totaling $41,797. At December 31, 2039, Jr-6Wq Company prepared the following aging schedule: Accounts Receivable % Uncollectible not past due $225,200 2% 1-2 months past due 136,900 6% 3-4 months past due 83,120 10% 5-6 months past due 55,610 20% over 6 months past due 26,700 39% Calculate Jr-6Wq...

Metlock Company has the following balances in selected accounts on December 31, 2022. Accounts Receivable $...

Metlock Company has the following balances in selected accounts on December 31, 2022. Accounts Receivable $ 0 Accumulated Depreciation—Equipment 0 Equipment 7,840 Interest Payable 0 Notes Payable 11,200 Prepaid Insurance 2,352 Salaries and Wages Payable 0 Supplies 2,744 Unearned Service Revenue 33,600 All the accounts have normal balances. The following information has been gathered at December 31, 2022. 1. Metlock Company borrowed $11,200 by signing a 12%, one-year note on September 1, 2022. Interest will be paid when the note...

The following information is available for the McCain Manufacturing Company for 2020. Accounts receivable, January 1,...

The following information is available for the McCain Manufacturing Company for 2020. Accounts receivable, January 1, 2020 $120,000 Accounts payable, January 1, 2020 ? Raw materials, January 1, 2020 10,000 Work in process, January 1, 2020 25,000 Finished goods, January 1, 2020 75,000 Accounts receivable, December 31, 2020 80,000 Accounts payable, December 31, 2020 200,000 Raw materials, December 31, 2020 ? Work in process, December 31, 2020 60,000 Finished goods, December 31, 2020 50,000 Raw materials used in production 100,000...

Class Quest Company had the following balances as at January 1, 2016: Accounts Receivable $600,000

Class Quest Company had the following balances as at January 1, 2016: Accounts Receivable $600,000 Debit Allowance for Doubtful Accounts $32,000 Credit During the fiscal year 2016 (Jan 1 to Dec 31 2016), the company had the following transactions: Total Sales $7,200,000 (of which 40% represents cash sales). Cash collected from credit customers $3,000,000 Write-offs of uncollectible accounts $22,000. Required: If the company estimates that 2.50% of its accounts receivable balance is uncollectible, calculate the ending balance in the allowance...

Dreamland Security Services Inc. had the following account balances as of January 1, 2020: 1. On...

Dreamland Security Services Inc. had the following account balances as of January 1, 2020: 1. On January 1, 2020, Dreamland purchased land for $10,000 and a building for $90,000. The land was paid for with cash. The building was paid for with $5,000 cash and the remainder was financed with a 10-year notes payable. 2. Paid the accounts payable balance from 2019. 3. Purchase $500 of supplies on account. 4. Purchased 100 alarm systems (inventory) on account at a cost...

Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable,...

Sunny Corporation expects to have the following balances on July 1, 2020: Cash, $3,000; Accounts receivable, $135,000; and Accounts payable, $100,000. Its budgeted sales, merchandise purchases, and various expenses for the next three months follow. July August September Sales $220,000 $300,000 $380,000 Merchandise purchases 210,000 180,000 220,000 Payroll, rent, and other expenses 96,000 41,000 51,000 20% of the sales are for cash. Of the remaining credit sales, 30% are collected in the same month as the sale, and 70% are...