Question

In: Accounting

Forward Company makes all its sales on account. Forward's accounts receivable payment experience is as follows:...

Forward Company makes all its sales on account. Forward's accounts receivable payment experience is as follows: Percent paid in the month of sale 30% Percent paid in the month after sale 65% Percent paid in the second month after sale 3% Forward provided information on sales as follows: September $120,000 October $140,000 November $220,000 December (expected) $260,000 ? What are the expected cash receipts in December? a. $210,400 b. $250,000 c. $225,200 d. $50,000 e. $179,000

Solutions

Expert Solution

c. $225,200

Working:

September October November December Total
Sales        1,20,000 1,40,000      2,20,000 2,60,000
Collection of :
September Sales            36,000      78,000            3,600 1,17,600
October Sales      42,000         91,000         4,200 1,37,200
November Sales         66,000 1,43,000 2,09,000
December Sales      78,000      78,000
Total            36,000 1,20,000      1,60,600 2,25,200 5,41,800

Related Solutions

Pardon Company, a retail entity makes all of its sales to customers on account and purchases...
Pardon Company, a retail entity makes all of its sales to customers on account and purchases 100% of its Merchandise Inventory on account from vendor, Power Company. Pardon provides you with the following selected account balances all of which are normal: 12/31/2018 12/31/2019 Accounts Receivable $32,000 $28,000 Merchandise Inventory 70,000 82,000 Prepaid Insurance Expense 6,500 5,800 Supplies 12,000 9,000 Equipment 130,000 115,000 Accumulated Depreciation 78,000 86,000 Accounts Payable- Power Company 26,000 40,000 Salaries Payable 3,200 5,400 Sales Revenue $615,000 Gain...
– Problem – Accounts Receivable Blair Co. makes most of its sales on a credit basis....
– Problem – Accounts Receivable Blair Co. makes most of its sales on a credit basis. Blair uses the allowance method to account for credit losses. The company adjusts its accounts just once a year, at the December 31 year-end. Consider the following balances available from the company’s unadjustedtrial balance at year-end 2018: Account Debit Credit Accounts receivable 2,571,500 Allowance for doubtful accounts 21,065 Blair prepared an aging of accounts at year-end 2018, as follows: Age Group Amount Estimated %...
The following information is available for Quality Book Sales' sales on account and accounts receivable: Accounts...
The following information is available for Quality Book Sales' sales on account and accounts receivable: Accounts receivable balance, January 1, Year 2 $ 125,900 Allowance for doubtful accounts, January 1, Year 2 3,520 Sales on account, Year 2 812,740 Collection on accounts receivable, Year 2 844,776 After several collection attempts, Quality Book Sales's wrote off $2,520 of accounts that could not be collected. Quality Book Sales estimates that 1.25 percent of sales on account will be uncollectible. Required a. Compute...
The following information is available for Quality Book Sales’ sales on account and accounts receivable: Accounts...
The following information is available for Quality Book Sales’ sales on account and accounts receivable: Accounts receivable balance, January 1, 2016 $ 79,500 Allowance for doubtful accounts, January 1, 2016 4,910 Sales on account, 2016 560,000 Collection on accounts receivable, 2016 566,000 After several collection attempts, Quality Book Sales wrote off $2,960 of accounts that could not be collected. Quality Book Sales estimates that 5 percent of the ending accounts receivable balance will be uncollectible. Required: a. Compute the following...
In order to convert Account Receivable into faster cash, a company can sell its accounts receivable...
In order to convert Account Receivable into faster cash, a company can sell its accounts receivable to another company, called a factor, at a discount. Assume your average credit sales are $50 million per year and average accounts receivable are $5 million. A factoring company offers you an agreement that it will be buying your accounts receivable at a 2.20% discount. Your bank offers you a credit at R% per year (actual yearly rate). What would be the minimum R%...
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 accounts receivable turnover ratio of a company is 2; if its annual credit sales is...
The accounts receivable turnover ratio of a company is 2; if its annual credit sales is $ 951810, what is the average value of outstanding credit (or value of accounts receivable)? If the company operates 350 a year, what is the average number of days it takes to get a credit sale paid? Average outstanding credit = $  . (Round to TWO places of decimal) Average number of days to get payment on a credit sale =   (Round to the nearest integer)
Bradshaw Company has a balance in its Accounts Receivable control account of $13,500 on January 1,...
Bradshaw Company has a balance in its Accounts Receivable control account of $13,500 on January 1, 2019. The subsidiary ledger contains three accounts: Brown Company, balance $6,000; Smith Company, balance $2,500 and Coco's Company. During January, the following receivable-related transactions occurred. Credit Sales Collections Returns Brown Company $15,000 $6,000 $ -0- Smith Company $9,000 $4,500 $1,000 Coco's Company $8,500 $6,500 $-0- Instructions: (a) What is the January 1, 2019 balance in the Coco's Company subsidiary account? (b) What is the...
At December 31, 2019, Bedford Company had a balance of $248,100 in its Accounts Receivable account...
At December 31, 2019, Bedford Company had a balance of $248,100 in its Accounts Receivable account and a credit balance of $900 in its Allowance for Doubtful Accounts account. Bedford analyzed and aged its accounts receivable based on the following estimated uncollectible amounts: Age of Accounts Receivables Balance Estimated % Uncollectible Current $ 130,500 0.6% 31 to 60 day 66,300 2.0% 61 to 90 days 26,700 5.5% Over 91 days    24,600 21.0% Total $248,100 The company bases its provision...
At December 31, 2017, Engel Company had a balance of $770,000 in its Accounts Receivable account...
At December 31, 2017, Engel Company had a balance of $770,000 in its Accounts Receivable account and an unused balance of $7,000 in its Allowance for Doubtful Accounts.  The company then analyzed and aged its accounts receivable as follows:             Current                                                           $468,000             1-60 days past due                                           244,000             61-180 days past due                                        38,000             Over 180 days past due                                     20,000                                                                                     ------------- Total accounts receivable                                         $770,000                                                                                     ======== In the past, the company experienced losses as follows:  1% of current balances, 5% of balances 1-60 days past due, 15% of balances 61-180...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT