Question

Minot Corporation is preparing its cash budget for August. The following information is available concerning its...

Minot Corporation is preparing its cash budget for August. The following information is available concerning its accounts receivable:

Estimated credit sales for August $ 200,000
Actual credit sales for July $ 151,000
Estimated collections in August for credit sales in August 25 %
Estimated collections in August for credit sales in July 70 %
Estimated collections in August for credit sales prior to July $ 16,000
Estimated write-offs in August for uncollectible credit sales $ 8,000
Estimated provision for bad debts in August for credit sales in August $ 7,000


Required:

What is the estimated amount of cash receipts from accounts receivable collections in August?

Homework Answers

Answer #1

Answer: $169700

Explanation:

Estimated amount of cash receipts from accounts receivable collections in August = Estimated collections in August for credit sales in August + Estimated collections in August for credit sales in July + Estimated collections in August for credit sales prior to July

Estimated amount of cash receipts from accounts receivable collections in August = (200,000 - 8000)*25% + $151000*70% + $16000

Estimated amount of cash receipts from accounts receivable collections in August = $48000 + $105700 + $16000

=$169700

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Overland Company is preparing its cash budget for the month of June. The following information...
The Overland Company is preparing its cash budget for the month of June. The following information is available concerning its accounts receivable:    Estimated credit sales for June $ 334,000 Actual credit sales for May 259,000 Estimated collections in June for credit sales in June 25 % Estimated collections in June for credit sales in May 65 % Estimated collections in June for credit sales prior to May $ 52,000 Estimated write-offs in June for uncollectible credit sales 46,000 Estimated...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
At December 31, 2012, SPK Inc reported the following information on its balance sheet: Accounts Receivable...
At December 31, 2012, SPK Inc reported the following information on its balance sheet: Accounts Receivable 900,000 Allowance for Doubtful Accounts 54,000 (credit) During 2013, the company had the following transactions related to receivables: Sales on Account 3,000,000 Collections on Account 2,850,000 Write-offs of uncollectible accounts 60,000 Recovery of previously written off accounts 12,000 A) Assume that bad debts are estimated to be 5% of year end receivables, determine the Net Realizable Value (after adjustments) of Accounts Receivable. B) If...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $120,000 and $136,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 60%; month following the month of sale, 35%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale. What is the net cash estimated to be collected in December? Net cash estimated collections:_________
(N ONE)    Beech Corporation is a merchandising company that is preparing a master budget for...
(N ONE)    Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:                              Beech Corporation                           Balance Sheet June 30 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . .                               . . . $ 90,000 Accounts receivable . . ....
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions...
Required information Problem 20-2A Manufacturing: Cash budget LO P2 [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 64,000 $ 80,000 $ 48,000 Budgeted cash payments for Direct materials 16,160 13,440 13,760 Direct labor 4,040 3,360 3,440 Factory overhead 20,200 16,800 17,200 Sales are 20% cash and 80% on...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...