Normal cash collection experience has been that 40% of sales are collected during the month of sale, 20% in the month following sale,and 35% in the second month following sale. The remaining 5% of sales is never collected.Prepare the schedule of cash collections for the third quarter, by month and in total.Cash Collection ScheduleJul.Aug.Sep.Total planned sales360000350000$330000Credit sales collected during monthCredit sales collected one month laterCredit sales collected two months later$$ Whispering Company has the following sales projections for its second and third quarters:Аpril$300,000Мay$320,000June$340,000July$360,000August$350,000September$330,000Normal cash collection experience has been that 40% of sales are collected during the month of sale, 20% in the month following sale,and 35% in the second month following sale. The remaining 5% of sales is never collected.

Normal cash collection experience has been that 40% of sales are collected during the month of sale, 20% in the month following sale, and 35% in the second month following sale. The remaining 5% of sales is never collected. Prepare the schedule of cash collections for the third quarter, by month and in total.

Normal cash collection experience has been that 40% of sales are collected during the month of sale, 20% in the month following sale, and 35% in the second month following sale. The remaining 5% of sales is never collected. Prepare the schedule of cash collections for the third quarter, by month and in total.

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

Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $225,000 $ 293,000 $ 438,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May: 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate…
Cash collections The treasurer of Homeyra Corp. needs to estimate cash collections from accounts receivable for September, October, and November. Forty percent of the company's customers pay in cash and the rest are credit customers. The collection pattern for the credit customers is 20 percent in the month of sale and 80 percent in the following month. Because of Homeyra's established client base, the company experiences almost zero uncollectible accounts. Estimated total sales for August, September, October, and November follow. Month Sales August $78,000 September 80,000 October 95,000 November 91,000 Determine Homeyra Corp.'s cash collections for September, October, and November. Cash Collections: September $ 32,000 x October $ 0 x November $ 0 x Check
Karim Corporation requires a minimum $8,100 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $8,100 is used to repay loans at month-end. The cash balance on July 1 is $8,500, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash available July August $ 24,100 $ 32,100 28,150 30,100 Total cash payments Preliminary cash balance Loan activity Ending cash balance September $ 40,100 32,100 KARIM CORPORATION Cash Budget $ July Loan balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance…
Cloudy Company had the following historical collection pattern for its credit sales: 70% collected in the month of sale 12% collected in the first month after month of sale 10% collected in the second month after month of sale 5% collected in the third month after month of sale 3% uncollectible The sales on open account (credit sales) have been budgeted for the last six months of the year as shown below: July August September October November December The estimated cash collection by Cloudy Company during September from credit sales in July, August, and September is: Multiple Choice $83,840. $100,160. $90,880. $ 92,000 $ 104,000 $ 116,000 $ 128,000 $ 140,000 $ 122,000 $64,400.
.
Justin Company's budget includes the following credit sales for the current year: September, $41,000; October, $52,000; November, $46,000; December, $48,000. Credit sales are collected as follows: 20% in the month of sale, 55% in the first month after sale, 22% in the second month after sale, and 3% is uncollectible. How much cash can Justin expect to collect in November as a result of current and past credit sales? Multiple Choice $35,420. $46,820. $49,620. $44,220. $46,000.
The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $140, and total sales in January were $290. TT February March $ 420 April Total sales $ 440 $ 400 125 135 115 Cash purchases Credit purchases Labor and administrative purchases Taxes, interest, and dividends Capital expenditures 95 85 95 85 85 85 65 65 65 210 Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.) February March Aprit Sources of cash Collections on current sales Collections on amounts receivable Total sources of cash 0 $ Uses of cash Payments of accounts payable Cash purchases o search
Peach Corporation's only cash receipts are those derived from customer sales. Peach makes both cash sales and sales on account. For its credit sales, Peach collects 50% in the month of the sale, 40% in the month following the sale, and 10% in the second month following the sale. Peach is preparing its cash budget for the upcoming year. Sales on account for the month of March are budgeted at $150,000. The budgeted accounts receivable balance on March 1 is $113,000, of which $90,000 represents uncollected sales made in February and $23,000 represents uncollected sales made in January. If Peach's total cash receipts for the month of March are budgeted at $205,000, what are Peach's budgeted cash sales during March? O $17,000 O $35,000 $53,000 $71,000 O None of the above
Dog
5 At Lyman Company, past experience reveals that 10% of sales are for cash and the remaining 90% are on credit. Lyman Company expects to collect 30% of its credit sales in the month of sale, 50% in the month following sale, and 18% in the second month following sale. Which ONE of the following is part of the cash collections expected to be made in January? O Cash sales from the preceding December O Cash collections of credit sales from the preceding December O Cash collections of credit sales from the preceding September O Cash sales from the preceding November
Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done