Question

In: Finance

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.

Solutions

Expert Solution

Receivable average collection period is calculated by dividing the average balance of accounts receivable by total net credit sales for the period and multiplying the quotient by the number of days in the period.

Days sales outstanding (DSO) is a measure of the average number of days that it takes a company to collect payment after a sale has been made. DSO is often determined on a monthly, quarterly or annual basis, and can be calculated by dividing the amount of accounts receivable during a given period by the total value of credit sales during the same period, and multiplying the result by the number of days in the period measured.

AVERAGE RECEIVABLE COLLECTION PERIOD = AVERAGE BALANCE OF ACCOUNTS RECEIVABLE / TOTAL NET CREDIT SALES * 365 (TOTAL DAYS IN A YEAR)

HERE IN THE PROBLEM

To calculate the accounts receivable turnover, start by adding the beginning and ending accounts receivable and divide it by 2 to calculate the average accounts receivable for the period.

AVERAGE RECEIVABLE = RECEIVABLE AT THE BEGINNING + RECEIVABLE AT THE END / 2

RECEIVABLE AT BEGINNING = $ 13182

RECEIVABLE AT ENDING = $ 13973

AVERAGE RECEIVABLE = (13182+13973)/2

= 13577.50

NET CREDIT SALES = $ 178312

AVERAGE RECEIVABLE COLLECTION PERIOD = AVERAGE BALANCE OF ACCOUNTS RECEIVABLE / TOTAL NET CREDIT SALES * 365 (TOTAL DAYS IN A YEAR)  

= 13577.50/178312*365

= 27.79 SAY IT AS 28 DAYS takes the firm to collect payment after a sale has been made


Related Solutions

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 Calculate the inventory turnover and inventory period. Interpret. Calculate the receivable turnover and receivable period. Interpret. Calculate the operating cycle (OC). Interpret. Calculate and interpret the cash cycle (CC).
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...
Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle =   days Cash Cycle =  days
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...
Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables = 6825 Beginning Payables = 8304 Ending Payables = 8758 Credit Sales = 91199 Cost of Goods Sold = 73243 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days
inventory: beginning $21,430 Ending $23,865 Accounts receivable: beginning $15,362 Ending $17,210 accounts payable: beginning $20,416 Ending...
inventory: beginning $21,430 Ending $23,865 Accounts receivable: beginning $15,362 Ending $17,210 accounts payable: beginning $20,416 Ending $21,803 net sales for the year: $243,612 cost of goods sold for the year: $108,915 what is the cash cycle?
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000...
6.          Calculate the Operating and Cash Cycles. Item Beginning Ending Inventory $10,000 $11,000 Accounts Receivable $5,000 $6,000 Accounts Payable $6,000 $65,000 Net Sales $140,000 Cost of Goods Sold $85,000 Operating Cycle Days Cash Cycle Days Please put the excel formulas en step by step solution so i can understand . thank you What does Operating and Cash Cycles tell you? Why are they important?
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000...
2014 2015 Sales $200,000 $150,000 Beginning inventory (a)______ (e)_______ Purchases, net 40,000 40,000 Ending inventory 25,000 5,000 Cost of goods sold (b)______ 60,000 Gross profit 65,000 (f)______ Operating expenses (c)______ (g)_______ Income before taxes (d)______ 40,000 Income tax expense (30%) 14,100 (h)_______ Net income (loss) 32,900 (i)________ Can you add your work for each missing blank please! Required: Fill in the blanks for the missing data.
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods...
Beginning inventory, purchases, and sales for an inventory item are as follows: Purchases Cost of Goods Sold Inventory Event Unit Cost Total Cost Unit Cost Total Cost Total Cost QTY Bought Qty sold Qty Unit Cost Beginning Inventory 150 755 First Sale 120 First Purchase 400 785 Second Sale 200 Second Purchase 300 805 Sale 290 The firm uses the perpetual inventory system and there are 240 units of the item on hand at the end of the year A....
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $...
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $ 4,880         $ 6,310            Accounts receivable 2,963         3,831            Accounts payable 4,018         5,195              Credit sales $ 50,484         Cost of goods sold 30,640        Required: (a) Calculate the operating cycles. (Do not round your intermediate calculations.) (Click to select)42.09days91.21days94.86days36.34days87.56days (b) Calculate the cash cycle. (Do not round your intermediate calculations.)
Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales...
Given the following information: Beginning Inventory $ 52,000 Ending Inventory 20,800 Sales 214,400 Purchases 69,600 Sales Returns and Allowances 3,600 Purchase Discounts 2,400 Transportation-In 4,400 Purchase Returns and Allowances 3,600 Sales Discounts 1,920 Required: a.     Determine net sales b.     Determine net cost of purchases c.     Determine gross margin d.     Determine cost of goods available for sale e.     Determine cost of goods sold (Show your work for each calculation labeling each amount included.)
Consider the following financial statement information for the Newk Corporation: Item Beginning Ending Inventory $ 11,500...
Consider the following financial statement information for the Newk Corporation: Item Beginning Ending Inventory $ 11,500 $ 12,500 Accounts receivable 6,500 6,800 Accounts payable 8,700 9,100 Credit sales $ 95,000 Cost of goods sold 75,000 Calculate the operating and cash cycles. (Use 365 days a year. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Operating cycle ____ days Cash cycle ____ days
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT