Question

In: Finance

The below table reports the $ amounts of inventory, receivables, payables, net sales and cost of...

The below table reports the $ amounts of inventory, receivables, payables, net sales and cost of good sols the XYZ Company in 200N.

Accounts

Beginning

Ending

Inventory

$10,000

$12,000

Receivables

8,000

10,000

Accounts payable

6,000

7,000

Net sales

30,000

Cost of Goods sold

14,000

  1. Calculate the inventory turnover and inventory period. Interpret.
  2. Calculate the receivable turnover and receivable period. Interpret.
  3. Calculate the operating cycle (OC). Interpret.
  4. Calculate and interpret the cash cycle (CC).

Solutions

Expert Solution


Related Solutions

Item Beginning Ending Inventory $17,385 $19,108 Accounts Receivables 13,182 13,973 Accounts Payables 15,385 16,676 Net Sales...
Item Beginning Ending Inventory $17,385 $19,108 Accounts Receivables 13,182 13,973 Accounts Payables 15,385 16,676 Net Sales $178,312 Cost of Goods Sold 140,382 Assume all Sales are made on credit. Given the information provided, compute the Receivables Period. Answer should include one decimal place.
BAF Limited is involved in international business. It has the following receivables and payables: Table A:...
BAF Limited is involved in international business. It has the following receivables and payables: Table A: Total receivables US$10 million Market Exchange rate Expected amount in GHC Spot rate GHC1.5/$        X 1 month Forward rate GHC1.4/$        Y 3 month forward rate GHC1.71/$        Z Table B: Total payables £20 million Market Exchange rate Expected amount in GHC Spot rate GHC1.5/£        C 1 month Forward rate GHC1.4/£        D 3 month forward rate GHC1.71/£        E Will BAF...
A company reports inventory using the lower-of-cost and net realizable value. Below is information related to...
A company reports inventory using the lower-of-cost and net realizable value. Below is information related to its year-end inventory: Inventory Quantity Cost NRV Unit A 10            $30          $32          Unit B 18            43          40          Unit C 12            23          27          Unit D 15            18          17              a. Calculate ending inventory under the lower-of-cost and net realizable value. b. Prepare the necessary adjusting entry to inventory. (If no entry is required for a transaction/event, select...
Given the following information, calculate the cash cycle. Use average inventory, receivables, and payables in your...
Given the following information, calculate the cash cycle. Use average inventory, receivables, and payables in your calculations. Credit sales = $1,000,000 Cost of goods sold = $750,000 Beginning balances: Inventory = $300,000 Accounts Receivable = $280,000 Accounts Payable = $260,000 Ending balances: Inventory = $280,000 Accounts Receivable = $250,000 Accounts Payable = $240,000 a)141 days b)261 days c)97 days d)116 days e)238 days
In thousands of dollars, if a company’s Sales were $551,970, Receivables were $82,500, Payables were $45,913,...
In thousands of dollars, if a company’s Sales were $551,970, Receivables were $82,500, Payables were $45,913, Inventory was $62,228, and Gross Profit was $141,710, what is COGS as a % of sales?
Home furnishings reports inventory using the lower of cost and net realizable value (NRV).
Home furnishings reports inventory using the lower of cost and net realizable value (NRV). Below is information related to its year-end inventory.    Required: 1. Calculate the total recorded cost of ending inventory before any adjustments.  2. Calculate ending inventory using the lower of cost and net realizable value.  3. Record any necessary adjustment to inventory.  4. Explain the impact of the adjustment in the financial statements. 
A company reports inventory using the lower of cost and net realizable value. See the following...
A company reports inventory using the lower of cost and net realizable value. See the following information related to its year-end inventory:    Inventory Quantity Cost NRV Item A 150 $ 29 $ 34 Item B 50 34 24    a. Calculate ending inventory for the company under the lower of cost and net realizable value. b. Record the necessary adjusting entry to inventory.
The Mohamed & Ahmed Co. reports net sales $ 150,000, cost of goods sold $ 50,000,...
The Mohamed & Ahmed Co. reports net sales $ 150,000, cost of goods sold $ 50,000, selling and administrative expenses $ 37,000. Interest allowances are Mohamed $9,000 and Ahmed $6,000; partner salary allowances are Mohamed $30,000 and Ahmed $25,000 and the remainder is shared 6:4 respectively. Instructions: Indicate the division of net income to each partner and prepare journal entry for net income/net loss division. Solution question 4: Item Mohamed Ahmed Total Journal entry:         Date Account title and explanation...
GAAP requires receivables be reported on the balance sheet net of uncollectible amounts (bad debt). This...
GAAP requires receivables be reported on the balance sheet net of uncollectible amounts (bad debt). This means the allowance method must be used to record uncollectible accounts. The allowance method includes making an adjusting entry. In your own words, explain this procedure to a new accounting student. Address these topics: the two accounts used in the adjusting entry two methods of estimating the bad debt expense amount for the adjusting entry how each estimating method could result in a different...
Debit (RM) Credit RM) Account receivables/payables 165,520 72,440 Carriage inwards 3,520 Inventory as at 1/1/2019 65,980...
Debit (RM) Credit RM) Account receivables/payables 165,520 72,440 Carriage inwards 3,520 Inventory as at 1/1/2019 65,980 Carriage outwards 4,360 Discount allowed/received 2,680 60 Electricity and water 25,100 Loan from Maybank (long-term loan) 80,000 Return inwards/outwards 3,840 3,580 Bank 10,400 Premises 160,000 Motor vehicles 56,000 Furniture and fittings 27,600 Cash 2,160 Accumulated depreciation – Motor vehicles 20,160 Accumulated depreciation – Furniture and fittings 8,280 Salaries and wages 68,600 Bad debts 2,940 Rent received 7,500 Printing and stationeries 9,400 Drawings 3,560 Insurance...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT