Ewing Company is preparing a cash budget for September. The following information on accounts receivable collections is available from past collection experience. Percent of current month's sales collected this month Percent of prior month's sales collected this month Percent of sales two months prior to current month collected this month Percent of sales three months prior to current month collected this month 308 55 10 3 The remaining 2 percent is not collected and is written off as bad debts. Credit sales to date are as follows. September-estimated August July $170,000 153,000 130,000 155,000 June Required: What are the estimated cash receipts from accounts receivable collections in September? Estimated cash receipts

Ewing Company is preparing a cash budget for September. The following information on accounts receivable collections is available from past collection experience. Percent of current month's sales collected this month Percent of prior month's sales collected this month Percent of sales two months prior to current month collected this month Percent of sales three months prior to current month collected this month 308 55 10 3 The remaining 2 percent is not collected and is written off as bad debts. Credit sales to date are as follows. September-estimated August July $170,000 153,000 130,000 155,000 June Required: What are the estimated cash receipts from accounts receivable collections in September? Estimated cash receipts

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: Revenues April May $ 253,000 $ 272,000 $ 299,000 $ 346,000 $ 355,000 June July August Carmen's sales are 60% cash and 40% store credit. The credit sales are collected 60% in the month of sale, the remainder the following month. Accounts receivable on April 1 are $34,000. Carmen's cost of sales averages 65% of revenues. The inventory policy is to carry 30% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 40% in the month of purchase and 60% the following month. Accounts payable on April 1 is $133,000. a. Prepare a purchases budget for as many months as is possible. April May June July August Sales Cost of Sales Percentage % % Cost of Sales Ending Inv Beginning Inv Purchases
The Overland Company is preparing its cash budget for the month of June. The following information is available concerning its accounts receivable: $304,000 229,000 Estimated credit sales for June Actual credit sales for May Estimated collections in June for credit sales in June Estimated collections in June for credit sales in May Estimated collections in June for credit sales prior to May 25% 65% $ 22,000 16,000 14,000 Estimated write-offs in June for uncollectible credit sales Estimated provision for bad debts in June for credit sales in June What are the estimated cash receipts from accounts receivable collections in June?
A company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
Western Company is preparing a cash budget for June. The company has $10,400 in cash at the beginning of June and anticipates $31,600 in cash receipts and $37,700 in cash payments during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company has no loans outstanding. To maintain the $10,000 required balance, during June the company must:
Ahmed Company purchases all merchandise on credit. It recently budgeted the month-end accounts payable balances below. Cash payments on accounts payable during each month are expected to be June, $1,450,000; July, $1,300,000; and August, $1,300,000. Hint: Use the relation (Beg. Accounts Payable + Purchases on Credit - Payments on Accounts Payable = End. Accounts Payable) to solve for budgeted purchases. Accounts payable May 31 June 30 $ 130,000 $ 110,000 Ending accounts payable Add: Cash paid on accounts payable Total accounts payable Less: Beginning accounts payable Budgeted merchandise purchases Computing budgeted merchandise purchases from accounts payable Budgeted amounts: $ June July 31 $ 400,000 0 0 $ July 0 August 31 $ 170,000 0 $ August 0 0
Urban Industries needs to maintain a minimum cash balance of $10,000 and has entered into an agreement with their bank to accomplish this. Urban is preparing a cash budget for September. Urban has $11,300 in cash at the beginning of September and anticipates $30,700 in cash receipts and $35,900 in cash payments during September. As of August 31, the company has no loans outstanding. To maintain the $10,000 required balance, during September the company must: O A. Borrow $3,900. O B. Borrow $10,000. OC. Borrow $5,200. OD. Repay $3,900. OE.Repay $6.100.
1. Calculate the expected cash collections for July. 2. Calculate the expected cash disbursements for merchandise purchases for July. 3. Prepare a cash budget for July.
Aswer correctly. Options already selected are not all correct. Revise and answer.
The following assumptions are made by a company when preparing its cash budget Invoices paid in the month after sales. Invoices paid in the second month after sale Invoices paid in the third month after sale Bad debts 50% 30% 15% 5% Invoices are issued on the last day of each month. Customers paying in the month after sale are entitled to deduct a 4% settlement discount. Credit sales values for August to November are budgeted as follows: August September October November $100 000 $120 000 $80 000 $70 000 The amount budgeted to be received from credit sales in November is ABCD ] $89 400 ] $91000 [ ] ] $100 000 $92 000
Provide examples of critical customer and operational performance metrics that may be included in an IAA balanced scorecard (without requiring any computations).
Jake Company needs to calculate the amount of cash it expects to collect for themonth of july using the following info: Month Credit SaIesMay　　　　200,000　budgetedJune　　　　230,000 budgetedJuIy　　　　 220,000　budgetedAugust　　　250,000　budgetedThe company has historically collected its receivables as follows:Collections in month of sale 30%Collections one month after the sale 50%ColIections two months after the sale 20%
Subject :- Accounting