January February March April May $ 300,000 (actual) 400,000 (actual) 445,000 (estimated) 589,000 (estimated) 800,000 (estimated) The company's collection activity on credit sales historically has been as follows: Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. 50% 30 15 Required: Compute Spicer's budgeted cash balance at the ends of March, April, and May Beginning Cash Collections on January Sales Collections on February Sales March April May

January February March April May $ 300,000 (actual) 400,000 (actual) 445,000 (estimated) 589,000 (estimated) 800,000 (estimated) The company's collection activity on credit sales historically has been as follows: Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. 50% 30 15 Required: Compute Spicer's budgeted cash balance at the ends of March, April, and May Beginning Cash Collections on January Sales Collections on February Sales March April May

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Accounts Receivable Balance XYZ Corp sells widgets to consumers for $20 each. Its beginning accounts receivable balance was $24,975, and it sold 12,376 widgets throughout the year. The total cash collections for the year amounted to $217,750. Required: Calculate the ending accounts receivable balance.
Dedpul Company provided the following transactions affecting accounts receivable during the current year: Sales (cash and credit) P5,900,000 Cash received from credit customers, all of whom took advantage of the discount feature of the credit terms 4/10, n/30 3,024,000 Cash received from cash customers 2,100,000 Accounts receivable written off as worthless 50,000 Credit memorandum issued to credit customers for sales returns and allowances 250,000 Cash refunds given to cash customers for sales returns and allowances 20,000 Recoveries on accounts receivable written off as uncollectible in prior periods not included in cash received from customers stated above 80,000 The balances on January 1 were as follows: Accounts receivable P950,000 Allowance for doubtful accounts 100,000 The entity provided for uncollectible account losses by crediting allowances for doubtful accounts in the amount of P70,000 for the…
Jay Company provided the following data relating to accounts receivable for the current year: Accounts receivable, January 1 650,000 Credit Sales 2,700,000 Sales returns 75,000 Accounts written off 40,000 Collections from customers 2,150,000 Estimated future sales returns at December 31 50,000 Estimated uncollectible accounts at 12/31 per aging 110,000 What is the amortized cost of accounts receivable on December 31? a. 1,200,000 b. 1,125,000 c. 1,085,000 d. 925,000
Guidry Corporation's beginning accounts receivable balance at January 1 was $200,000 and the ending accounts receivable balance at December 31 is $300,000. Assuming cash collections from receivables totaled $1,100,000, what were credit sales for the period? A. $1,300,000 B. $1,500,000 C. $1,200,000 D. $1,100,000
Use the following information to answer questions 1-3: January Cash Sales $40,000 Credit Sales $120,000 February March April $35,000 $110,000 $25,000 $90,000 $30,000 $100,000 20% of the credit sales are collected in the month of sale, 70% in the month after sale, and 10% in the second month after sale. What is the balance of accounts receivable on March 31? Multiple Choice $11,000 $12,000 $72,000 $83,000
For the month of December, the records of Scrooge Corporation show the following information: Cash received on accounts receivable $45,000 Cash sales 30,000 Accounts receivable, December 1 80,000 Accounts receivable, December 31 75,000 Accounts receivable written off 2,000 The corporation uses the direct write-off method in accounting for uncollectible accounts receivable. What are the gross sales for the month of December? a.$72,000 b.$61,000 c.$59,000 d.$60,000
reported the following information: At the beginning of current year, Nostalgia Company Accounts receivable Allowance for doubtful accounts 1,500,000 60,000 The following summary transactions affecting accounts receivable occurred during the current year: Sales- all on account 2/10, 1/15, n /60 7,935,000 Cash received from customers 8,000,000 The cash received from customers included the following. Customers paying within the 10-day discount period 4,410,000 Customers paying within the 15-day discount period 2,475,000 Recovery of accounts written off 15,000 Customers paying beyond the discount period Accounts receivable written off as worthless 55,000 Credit memoranda for sales return 30,000 Required: a. Prepare journal entries to record the transactions. b. Prepare the adjustment for doubtful accounts if the entity follows the percentage of accounts receivable consistently. c. Determine the net realizable value of accounts receivable at year-end?
The following selected transactions occurred during the year ended December 31, 2026 of RANOA COMPANY: Gross sales (cash and credit) P900,736.80 Collections from credit customers, net of 2% cash discount 294,000.00 Cash sales 180,000.00 Uncollectible accounts written off 19,200.00 Credit memos issued to credit customers for sales ret./allow. 10,080.00 Cash refunds given to cash customers for sales ret./allow. 15,168.00 Recoveries on accounts receivable written-off in prior years (not included in cash received stated above) 6,505.20 At year-end, the company provides for estimated bad debts losses by crediting the Allowance for Bad Debts account for 2% of its net credit sales for the year. The allowance for bad debts at the beginning of the year is P19,327.20. 9. How much is the RANOA COMPANY’s gross sales? 10. RANOA credit sales at December 31, 2026 is: 11. How much is the RANOA COMPANY’s net credit sales? 12. The Bad Debts Expense of RANOA COMPANY at December 31,…
XYZ Company has the following information: Beginning accounts receivable: $50,000 Ending accounts receivable: $60,000 Credit sales: $200,000 Cash collections: $180,000 Calculate the company's accounts receivable turnover ratio and average collection period.
The accounting staff of Lambert Company has assembled the following information for the year ended December 31 of the current year. Cash sales $ 726,000 Credit sales 2,500,000 Collections on accounts receivable 2,205,000 Cash transferred from the money market fund to the general bank account 250,000 Interest and dividends received 100,000 Purchases (all on account) 1,800,000 Payments on accounts payable to merchandise suppliers 1,530,000 Cash payments for operating expenses (including payroll) 1,065,000 Interest paid 180,000 Income taxes paid 95,000 Loans made to borrowers 500,000 Collections on loans (excluding receipts of interest) 260,000 Cash paid to acquire plant assets 3,100,000 Book value of plant assets sold 651,300 Loss on sales of plant assets 75,200 Proceeds from issuing bonds payable 2,500,000 Dividends paid 120,000 Cash and cash equivalents, Jan. 1 512,000 Required: a. Prepare a statement of cash flows. Use the direct method of reporting cash flows from operating…
Assume the following information for Marin Corp. Accounts receivable (beginning balance) $136,000 Allowance for doubtful accounts (beginning balance) 11,480 Net credit sales 938,000 Collections 905,000 Write-offs of accounts receivable 5,000 Collections of accounts previously written off 1,900 Uncollectible accounts are expected to be 8% of the ending balance in accounts receivable. Prepare the entries to record sales and collections during the period. Prepare the entry to record the write-off of uncollectible accounts during the period. Prepare the entries to record the recovery of the uncollectible account during the period. Determine the ending balance in Accounts Receivable and the unadjusted balance in Allowance for Doubtful Accounts. Prepare the entry to record bad debt expense for the period. Determine the ending (adjusted) balance in Allowance for Doubtful Accounts. Ending (adjusted) balance in Allowance for Doubtful Accounts…
Month Cash Sales Sales on Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale30% in the first month following the sale20% in the second month following the sale ii) Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in accordance with the credit terms –2/30, n60:60% in the month in which the inventory is purchased40% in the following month iii) Fixed operating expenses which accrue evenly throughout the year, are estimated to be $1,680,000 per annum, (including depreciation on non-current assets of $420,000 per annum) and is settled monthly. iv) Wages and salaries are…