Accounts Receivable Collections Budget Example 1 Accounts Receivable Collections Budget $ December 15,000 Actual Sales: (excl GST) Expected Sales: January 13,000 (excl GST) February 10,000 March 8,000 All sales are made on credit and the expected pattern of receipts is: - 50% pay in the month of sale - 50% pay in the following month GST is accounted for on a cash basis. Required: Prepare an accounts receivable collections budget for January, February and March, showing GST collected separately.

Accounts Receivable Collections Budget Example 1 Accounts Receivable Collections Budget $ December 15,000 Actual Sales: (excl GST) Expected Sales: January 13,000 (excl GST) February 10,000 March 8,000 All sales are made on credit and the expected pattern of receipts is: - 50% pay in the month of sale - 50% pay in the following month GST is accounted for on a cash basis. Required: Prepare an accounts receivable collections budget for January, February and March, showing GST collected separately.

Name: LTE 11%4-22-1 - Nije spremljeno5Accounts Receivable Collections Budge
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: LTE 11%4-22-1 - Nije spremljeno5Accounts Receivable Collections BudgetExample 1Accounts Receivable Collections Budget$December15,000Actual Sales:(excl GST)January13,000Expected Sales:(excl GST)February10,000March8.000All sales are made on credit and

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 Company sells jar candles. The sales forecast (units) for the coming months is: April May June July August 230 250 220 170 230 Each candle costs $12. The ending inventory policy is 40% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 30% in the month of purchase and 70% the following month. Accounts payable on April 1 is $3,150. a. Prepare a purchases budget for the quarter ending June 30. Note: Deductible values must be indicated with a minus sign. Budgeted unit sales) Plus: Ending inventory Less: Beginning inventory Budgeted purchases (units) Cost of merchandise (per unit) Total cost of merchandise purchases Merchandise Purchases Budget (Candles) For the Quarter Ending June 30 April May b. Prepare a cash payments budget for the quarter ending June 30. June Total
MARS PAUTANG 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 P200,000Actual credit sales for May P150,000Estimated collections in June for credit sales in June 20%Estimated collections in June for credit sales in May 70%Estimated collections in June for credit sales prior to May P12,000Estimated write-offs in June for uncollectible credit sales P8,000Estimated provision for bad debts in June for credit sales in June P7,000What are the estimated cash receipts from accounts receivable collections in June?
Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $113,000 November 141,000 December 207,000 The Accounts Receivable balance on September 30 was $76,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $115,000 November 144,000 December 210,000 The Accounts Receivable balance on September 30 was $77,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
The information in the following table is from a company's sales budget Expected sales April May June $ 96,000 116,000 126,000 Cash sales are normally 25% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in June OAS118,500 O $31,500 OC$213,000 005126,000 O $87,000
Need interest per month and borrowing
J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: Fourth Quarter September (actual) $ 73,000 October November December $ 63,000 58,000 83,000 Experience has shown that 35 percent of sales are collected in the month of sale, 60 percent are collected in the following month, and 5 percent are never collected. Prepare a schedule of cash receipts for J. Lo's Clothiers covering the fourth quarter (October through December). Credit sales Collections: In month of sales One month after sales Total cash receipts J. Lo's Clothiers September October November December $ 0 $ 0 $ 0
Book Hint Print Exer Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts Cash payments $ 521,000 $ 465,600 405,000 478,000 349,600 522,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
1
None
Budgeting Cash Collections Lowell Consulting, which sells on terms 2/10, n/30, had credit sales for March and April of $90,000 and $75,000, respectively. Analysis of Lowell's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales) In month of sale in month of following sale Uncollectible accounts, returns, and allowances Receiving Discount Beyond Discount Period Totals 20% 60% 20% 35% 5% 100% 40% 15% Determine the estimated cash collected on customers' accounts in April.