Question

In: Accounting

10a. Alpha's net accounts receivable were $500,000 at December 31, 2015, and $600,000 at December 31,...

10a. Alpha's net accounts receivable were $500,000 at December 31, 2015, and $600,000 at December 31, 2016.  Net cash sales for 2016 were $250,000.  The accounts receivable turnover for 2016 was 5.3.  Use this information to determine the Fiscal Year 2016: (Round & enter your answers to one decimal place for non-dollar ratios and enter the value. For dollar ratio enter as whole dollars only.)

1. Total Net Sales

2. Total Net Credit Sales

10b. The following financial information is for Alpha Corporation are for the fiscal years ending 2017 & 2016 (all balances are normal):

Item/Account

2017

2016

Cash

$26,000

$16,000

Accounts Receivable

40,000

50,000

Inventory

30,000

22,000

Current Liabilities

76,000

42,000

Net Sales (all credit)

390,000

360,000

Cost of Goods Sold

260,000

250,000

Use this information to determine for FY 2017: (Round & enter your answers to one decimal place and enter the value.)

1. the inventory turnover ratio: ________        

2. number of days of inventory: ________

3. Gross Profit Margin:____________

10 c.

The following financial information is for Alpha Corporation are for the fiscal years ending 2017 & 2016 (all balances are normal):

Item/Account

2017

2016

Cash

$26,000

$16,000

Accounts Receivable

30,000

50,000

Inventory

30,000

22,000

Current Liabilities

76,000

42,000

Net Sales (all credit)

390,000

360,000

Cost of Goods Sold

260,000

250,000

Use this information to determine the quick ratio for FY 2017: (Round & enter your answers to one decimal place and enter the value.)

10d.

The following financial information is for Alpha Corporation are for the fiscal years ending 2017 & 2016 (all balances are normal):

Item/Account

2017

2016

Cash

$26,000

$16,000

Accounts Receivable

40,000

50,000

Inventory

30,000

22,000

Current Liabilities

76,000

42,000

Net Sales (all credit)

390,000

360,000

Cost of Goods Sold

260,000

250,000


Use this information to determine for FY 2017: (Round & enter your answers to one decimal place for non-dollar ratios and enter the value. For dollar ratio enter as whole dollars only.)

1. the Current Ratio

2. Working Capital

Solutions

Expert Solution

Solution 10a:

Accounts receivable turnover = 5.3

Credit sales / Average accounts receivables = 5.3

Average accounts receivables = ($500,000 + $600,000) / 2 = $550,000

Credit Sales = $550,000 * 5.3 = $2,915,000

Total net sales = Credit sales + Cash sales = $2,915,000 + $250,000 = $3,165,000

Total net credit sales = $2,915,000

Solution 10b:

Total inventory turnover ratio = Cost of goods sold / Average inventory

Average inventory = ($30,000 + $22,000) / 2 = $26,000

Inventory turnover ratio = $260,000 / $26,000 = 10 times

Number of days of inventory = Nos of day in a year / Inventory turnover ratio = 365/10 = 36.5 days

Gross profit margin = Sales - COGS = $390,000 - $260,000 = $130,000

Solution 10c:

Quick ratio = Quick assets / Current liabilities

Quick Assets = Cash + Accounts receivables = $26,000 +$30,000 = $56,000

Quick ratio for FY 2017 = $56,000 / $76,000 = 0.7

Solution 10d:

Current ratio = Current assets / Current liabilities

Current assets = Cash + Accounts receivables + Inventory = $26,000 + $40,000 + $30,000 = $96,000

Current liabilities = $76,000

Current ratio = $96,000 / $76,000 = 1.3

Working capital = Current Assets - Current liabilities = $96,000 - $76,000 = $20,000


Related Solutions

The accounts receivable balance for Renue Spa at December 31, 2015, was $85,000. Also on that...
The accounts receivable balance for Renue Spa at December 31, 2015, was $85,000. Also on that date, the balance in the Allowance for Doubtful Accounts was $2,300. During 2016, $2,700 of accounts receivable were written off as uncollectible. In addition, Renue unexpectedly collected $180 of receivables that had been written off in a previous accounting period. Services provided on account during 2016 were $220,000, and cash collections from receivables were $222,018. Uncollectible accounts expense was estimated to be 1 percent...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net...
Dec. 31, 2015 Dec. 31, 2014 Assets Cash and cash equivalents 129,852 593,175 Accounts receivable, net 433,638 279,835 Inventories 783,031 536,714 Prepaid expenses and other current assets 152,242 87,177 Deferred income taxes 52,498 Total current assets 1,498,763 1,549,399 Property and equipment, net 538,531 305,564 Goodwill 585,181 123,256 Intangible assets, net 75,686 26,230 Deferred income taxes 92,157 33,570 Other long-term assets 78,582 57,064 Total assets 2,868,900 2,095,083 Liabilities and Stockholders Equity Accounts payable 200,460 210,432 Accrued expenses 192,935 147,681 Current maturities...
You are auditing Accounts Receivable of HUSKY Corp. as of December 31, 2013. The Accounts Receivable...
You are auditing Accounts Receivable of HUSKY Corp. as of December 31, 2013. The Accounts Receivable general ledger balance is $4,263,919.52. Access the textbook's resources on the Cengage website. The files are labeled "HUSKY Unpaid Invoices 2013" (the 12/31/2013, unpaid invoices), "HUSKY Shipping File 2013" (contains the shipment numbers and shipment dates for those invoices), and "HUSKY Credit Limit 2013" (contains each customer's credit limit). Sales are made FOB shipping point. The auditor has verified that the last shipment in...
On December 31, 2020, Pina Colada Corp. estimated that 4% of its net accounts receivable of...
On December 31, 2020, Pina Colada Corp. estimated that 4% of its net accounts receivable of $455,200 will become uncollectible. The company recorded this amount as an addition to Allowance for Doubtful Accounts. The allowance account had a zero balance before adjustment on December 31, 2020. On May 11, 2021, Pina Colada Corp. determined that the Jeff Shoemaker account was uncollectible and wrote off $2,276. On June 12, 2021, Shoemaker paid the amount previously written off. Prepare the journal entries...
Clark Company estimated the net realizable value of its accounts receivable as of December 31, 2019,...
Clark Company estimated the net realizable value of its accounts receivable as of December 31, 2019, to be $175,000, based on an aging schedule of accounts receivable. Clark has also provided the following information: The allowance for doubtful accounts balance on January 1, 2019 was $17,000. The accounts receivable balance on December 31, 2019 was $187,000. Uncollectible accounts receivable written off during 2019 totaled $13,000. How much is Clark's 2019 bad debt expense? A. 8,000 B. 16,000 C. 12,000 D....
Cottonwood Company has net income of $600,000. It had 500,000 shares of common stock throughout 2015....
Cottonwood Company has net income of $600,000. It had 500,000 shares of common stock throughout 2015. It also had 50,000 shares of convertible preferred stock. Each share pays an annual dividend of $3 and each preferred share can be converted into 4 shares of common stock. Cottonwood also had 20,000 stock options outstanding. Each option can be used to purchase a share of common stock at $22 per share. The average market price of common stock for 2015 was $20....
On December 31, 2019, the following were the balances in SRK Inc’s Trial Balance: Accounts Receivable:...
On December 31, 2019, the following were the balances in SRK Inc’s Trial Balance: Accounts Receivable: DR $107,250; Allowance for Doubtful Accounts: CR$1,900. What amount should be debited to Bad Debt Expense, assuming 6% of the outstanding Accounts Receivable at December 31, 2019 are still estimated to be uncollectible? Provide a journal entry to show the adjustment.
Selected financial data from Barrymore Co. are As of December 31 Cash $75,000 Accounts receivable (net)...
Selected financial data from Barrymore Co. are As of December 31 Cash $75,000 Accounts receivable (net) 225,000 Merchandise inventory 270,000 Trading securities (current) 40,000 Land and building (net) 500,000 Mortgage payable-current portion 30,000 Accounts payable and accrued liabilities 2,000 Short-term notes payable 50,000 Year Ended December 31 Sales $1,500,000 Cost of goods sold 900,000 Barrymore’s quick (acid-test) ratio as of December 31 is
Assets Liabilities & Owners’ Equity Cash $500,000 Accounts Payable 0 Accounts Receivable $550,000  Notes Payable $600,000 Inventory...
Assets Liabilities & Owners’ Equity Cash $500,000 Accounts Payable 0 Accounts Receivable $550,000  Notes Payable $600,000 Inventory $750,000 Accruals $400,000 Total Current Assets $1,800,000 Total Current Liabilities 1,000,000 Net Plant & Equip $6,200,000 Long-Term Debt $4,000,000 Total Debt $5,000,000 Retained Earnings $1,500,000 Stockholders’ Equity $1,500,000 Total Equity 3,000,000 Total Assets $8,000,000 Total Liabilities & Owners’ Equity $8,000,000 You currently work for Capital One Financial. The firm is interested in pursuing a new banking project, but they are unsure of where and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT