Question

In: Finance

Accounts receivable at the beginning of the year are 300. The company has a 30-days collection...

Accounts receivable at the beginning of the year are 300. The company has a 30-days collection period. Calculate cash collections in each of the four quarters by completing the following.

Q1 Q2

Q30

Q4
beginning receivables 300 208
Sales 540 570 630 780
Cash collections 662 560 610 731
Ending receivables 208

Solutions

Expert Solution


Related Solutions

Mervyn’s Fine Fashions has an average collection period of 40 days. The accounts receivable balance is...
Mervyn’s Fine Fashions has an average collection period of 40 days. The accounts receivable balance is $46,000. What is the value of its annual credit sales? (Use a 360-day year.)
Accounts Receivable The following table indicates the historical breakout of accounts receivable Days Current 30 to...
Accounts Receivable The following table indicates the historical breakout of accounts receivable Days Current 30 to 60 60 to 90 Over 90 Percent of Balance 50% 30% 15% 5% Percent Collectible 95% 90% 80% 60% The company uses the gross method of recording all sales on accounts. Marketable Securities The interest rate earned on marketable securities is 6.0%. Inventory In 20x2, the company had used the gross method to record inventory purchases on account. As of January 1, 20x3, the...
ABC Company provided this information regarding its accounts receivable at the beginning of the current year:...
ABC Company provided this information regarding its accounts receivable at the beginning of the current year: Accounts receivable $1,320,000.00 Allowance for doubtful accounts ($320,000.00) Net realizable value $1,000,000.00 ABC Company reported $21,000,000.00 of net credit sales during the year. ABC Company only collected $9,900,00.00 of the reported net credit sales. ABC Company wrote off $51,000.00 of actual bad debts for the year. ABC Company estimates the allowance for doubtful accounts at 4% of the ending accounts receivable balance. Required: Prepare...
Swathmore Clothing Corporation grants its customers 30 days credit. The company uses the uncollectible accounts receivable....
Swathmore Clothing Corporation grants its customers 30 days' credit. The company uses the uncollectible accounts receivable. During the year, a monthly bad debt accrual is made by multiplying 2% times the amount of credit sales for the month. At the fiscal year-end of December 31, an aging of accounts receivable schedule is prepared and the allowance for uncollectible accounts is adjusted accordingly. At the end of 2015, accounts receivable were $612,000 and the allowance account had a credit balance of $76,000....
Macro Company has the following adjusted accounts and balances at June 30: Accounts Payable $ 300...
Macro Company has the following adjusted accounts and balances at June 30: Accounts Payable $ 300 Accounts Receivable 550 Accumulated Amortization 150 Accumulated Depreciation 250 Cash 1,020 Common Stock 300 Deferred Revenue 100 Depreciation Expense 110 Equipment 1,400 Income Tax Expense 110 Income Tax Payable 30 Interest Expense 180 Interest Revenue 50 Notes Payable (long-term) 1,300 Office Expenses 820 Prepaid Rent 40 Rent Expense 400 Retained Earnings 120 Salaries and Wages Expense 660 Sales Revenue 3,600 Software 200 Supplies 710...
At the end of 2018, accounts receivable amounted to $163,000. At the beginning of the year...
At the end of 2018, accounts receivable amounted to $163,000. At the beginning of the year it was $242,000. Net credit sales for the year amounted to $720,000 and net income was calculated to be $197,000. Determine the days sales outstanding ratio and the accounts receivable turnover ratio. Do not enter dollar signs or commas in the input boxes. Round your answer to 2 decimal places. Days Sales Outstanding = Answer days Accounts Receivable Turnover = Answer times
At the end of the year, a company has the following accounts receivable and estimates of...
At the end of the year, a company has the following accounts receivable and estimates of uncollectible accounts: 1. Accounts not yet due = $76,000: Estimated uncollectible = 7% 2. Accounts 1-30 days past due =$39,000' estimated uncollectible = 25% 3. accounts more than 30 days past due = $7,000; estimated uncollectible = 45% Record the year-end adjustment for uncollectible accounts, assuming the current balance of the Allowance for Uncollectible accounts is (1,800 (debit) Record the bad debt expense
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of...
A company has Cash of $1000, Accounts Receivable of $200, Inventory of $300, Long-Term Assets of $4000, Accounts Payable of $500 and a Long-Term Bank Loan of $5000. Calculate the company's current ratio. Question 1 options: 1 2 3 4 Question 2 Using the following information, calculate the inventory turnover for ABC Retailers: Sales are $4800, Cost of Goods Sold is $2000, operating expenses are $1000, and average inventory is $500. Question 2 options: 4 5 6 7 Question 3...
Garham Company had $360,000 in sales on account last year. The beginning accounts receivable balance was...
Garham Company had $360,000 in sales on account last year. The beginning accounts receivable balance was $20,000 and the ending accounts receivable balance was $36,000. The company's average collection period (age of receivables) was closest to: 20.28 days. 28.39 days. 36.50 days. 56.78 days.
The following information relates to a company’s accounts receivable: accounts receivable balance at the beginning of...
The following information relates to a company’s accounts receivable: accounts receivable balance at the beginning of the year, $410,000; allowance for uncollectible accounts at the beginning of the year, $30,000 (credit balance); credit sales during the year, $1,500,000; accounts receivable written off during the year, $21,000; cash collections from customers, $1,400,000. Assuming the company estimates that future bad debts will equal 8% of the year-end balance in accounts receivable. 1. Calculate the year-end balance in the allowance for uncollectible accounts....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT