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 | 185,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
| Particulars | January | February | March | April | May | ||
| Sales | $ 185,000.00 | $ 185,000.00 | $ 193,000.00 | $ 195,000.00 | $ 220,000.00 | ||
| Cash sales (20%) | (a) | $ 37,000.00 | $ 37,000.00 | $ 38,600.00 | $ 39,000.00 | $ 44,000.00 | |
| Credit sales (80%) | $ 148,000.00 | $ 148,000.00 | $ 154,400.00 | $ 156,000.00 | $ 176,000.00 | ||
| Collection of credit sales for: | |||||||
| January | $ 59,200.00 | $ 51,800.00 | $ 29,600.00 | $ 7,400.00 | |||
| February | $ 59,200.00 | $ 51,800.00 | $ 29,600.00 | $ 7,400.00 | |||
| March | $ 61,760.00 | $ 54,040.00 | $ 30,880.00 | ||||
| April | $ 62,400.00 | $ 54,600.00 | |||||
| May | $ 70,400.00 | ||||||
| Credit collection | (b) | $ 59,200.00 | $ 111,000.00 | $ 143,160.00 | $ 153,440.00 | $ 163,280.00 | |
| Total collection | (a+b) | $ 96,200.00 | $ 148,000.00 | $ 181,760.00 | $ 192,440.00 | $ 207,280.00 | |
| 1) | Forecasted cash flow for May | $ 207,280.00 | |||||
| Particulars | January | February | March | April | May | |||
| Sales | $ 185,000.00 | $ 185,000.00 | $ 193,000.00 | $ 195,000.00 | $ 220,000.00 | |||
| Cash sales (20%) | (a) | $ 37,000.00 | $ 37,000.00 | $ 38,600.00 | $ 39,000.00 | $ 44,000.00 | ||
| Credit sales (80%) | $ 148,000.00 | $ 148,000.00 | $ 154,400.00 | $ 156,000.00 | $ 176,000.00 | |||
| Less: | Estimated Bad Debts (2%) | $ - | $ - | $ - | $ 3,120.00 | $ 3,520.00 | ||
| Estimated Good Debts | $ 148,000.00 | $ 148,000.00 | $ 154,400.00 | $ 152,880.00 | $ 172,480.00 | |||
| Collection of credit sales for: | ||||||||
| January | $ 59,200.00 | $ 51,800.00 | $ 29,600.00 | $ 7,400.00 | ||||
| February | $ 59,200.00 | $ 51,800.00 | $ 29,600.00 | $ 7,400.00 | ||||
| March | $ 61,760.00 | $ 54,040.00 | $ 30,880.00 | |||||
| April | $ 61,152.00 | $ 53,508.00 | ||||||
| May | $ 68,992.00 | |||||||
| Credit collection | (b) | $ 59,200.00 | $ 111,000.00 | $ 143,160.00 | $ 152,192.00 | $ 160,780.00 | ||
| Total collection | (a+b) | $ 96,200.00 | $ 148,000.00 | $ 181,760.00 | $ 191,192.00 | $ 204,780.00 | ||
| 2) | Cash will decrease by $ 2500 ($ 207280 - $ 204780) | |||||||
Hey, is this correct?
ekkarill92 answered 10 months agoRelated 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
Latest Questions
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
- Kant says that to act morally is to act out of duty. How does this differ...
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
- List the arithmetic operators used in BASIC and state their priorities of execution in a statement....
- Describe the espoused values of a company you have worked for (or been exposed to -...
ADVERTISEMENT