Question

In: Accounting

Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...

Budgeted Cash Collections, Budgeted Cash Payments

Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows:

40 percent of credit sales in the month of the sale
35 percent of credit sales in the first subsequent month
20 percent of credit sales in the second subsequent month
5 percent of credit sales in the third subsequent month

The forecast for both cash and credit sales is as follows.

January $185,000
February 184,000
March 193,000
April 195,000
May 220,000

Required:

1. What is the forecasted cash inflow for Ragman Company for May?
$

2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow related to sales made in April? (CMA adapted)

Cash will    by $.

Solutions

Expert Solution

Solution 1:

While preparing cash forecast for May, credit sales from february to April will also be realized in part.

Solution 2:

If Ragman company creates a bad- debt adjustment of 2% of credit sales, it will reduce the cash forecast .

Total Sales of April = $195,000

Credit Sales = 80%

Total Credit Sales = $195,000 * 80% = $156,000

If the company creates the provision in the month of april while preparing the budget, it will create a bad-debt provision of $156,000 * 2% = $3,120

Total Expected cash inflow will reduce by $3,120 due to adjustment of provisioning for bad-debt.


Related Solutions

Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month...
X Company has the following budgeted cash flows for January Cash collections    $55,000 Cash Payments...
X Company has the following budgeted cash flows for January Cash collections    $55,000 Cash Payments Inventory 17,000 Operating Expenses 13,000 Capital Expenditures 18,000 If the cash balance is $5,000 on January 1 and the company wants to maintain a minimum cash balance of $5,000, what amount can either be invested or used to pay down existing debt for January?
ily Company has historically reported a bad debt expense amount of between 1% and 4% of...
ily Company has historically reported a bad debt expense amount of between 1% and 4% of sales. The percentage for any given year is a function of both the business conditions for the year and whether recent experience suggests that the estimates in past years have been too high or too low. For example, if estimates in past years have been too high, a lower amount of bad debt expense is recognized in the current year. Lily Company's board of...
Budgeted Cash Collections In an effort to improve cash collection, Suburban Medical Clinic offers terms of...
Budgeted Cash Collections In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patient payments made with cash. Suburban estimates its total billings for the second calendar quarter of the year as follows: April, $200,000; May, $240,000; and June, $290,000. Historically, Suburban has had the following patient collection patterns: Portions of Total Sales In month of sale: Cash at time of sale 25% On account during the discount period 20%...
Historically, your company has calculated bad debts using an aging of accounts receivable. Near the end...
Historically, your company has calculated bad debts using an aging of accounts receivable. Near the end of the fiscal year, the company is in a cash crunch and needs to borrow money from the bank, using accounts receivable as collateral. The owner of the company knows that many of the accounts receivable are more than 90 days past due, resulting in net receivables equal to only 80% of total receivables. Respond to the following in a minimum of 175 words:...
Historically, your company has calculated bad debts using an aging of accounts receivable. Near the end...
Historically, your company has calculated bad debts using an aging of accounts receivable. Near the end of the fiscal year, the company is in a cash crunch and needs to borrow money from the bank, using accounts receivable as collateral. The owner of the company knows that many of the accounts receivable are more than 90 days past due, resulting in net receivables equal to only 80% of total receivables. Respond to the following in a minimum of 175 words:...
Reflect on your feelings regarding collections of personal debt (whether related to your own experience, someone...
Reflect on your feelings regarding collections of personal debt (whether related to your own experience, someone you know or just your general perception – no need to specify in this post). Of the potential actions available to companies for collections described in this chapter, which do you feel is most likely to be successful? Please provide details.
A company had the following balances: Beginning April balance in allowance for bad debt: $6,000 (credit)...
A company had the following balances: Beginning April balance in allowance for bad debt: $6,000 (credit) Beginning April balance in accounts receivable: $200,000 During the month of April the company recorded the following: Bad debt expense is calculated as using the percent of credit sales method. The percent is 2%. The company recorded the entry for bad debt. Collection of cash related to accounts receivables of $120,000 Additional sales on account of $90,000 What is the company's net realizable value...
Flyer Company has provided the following information prior to any year-end bad debt adjustment: Cash sales,...
Flyer Company has provided the following information prior to any year-end bad debt adjustment: Cash sales, $168,000 Credit sales, $468,000 Selling and administrative expenses, $128,000 Sales returns and allowances, $48,000 Gross profit, $508,000 Accounts receivable, $285,000 Sales discounts, $32,000 Allowance for doubtful accounts credit balance, $3,000 Flyer prepares an aging of accounts receivable and the result shows that 3% of accounts receivable is estimated to be uncollectible. What is the balance in the allowance for doubtful accounts after bad debt...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT