On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 629,000 (estimated) April 571,000 (estimated) May 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale 50 % Collections one month after the sale 30 Collections two months after the sale 15 Uncollectible accounts 5 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. Compute Spicer's budgeted cash balance at the ends of March, April, and May.

On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 629,000 (estimated) April 571,000 (estimated) May 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale 50 % Collections one month after the sale 30 Collections two months after the sale 15 Uncollectible accounts 5 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. Compute Spicer's budgeted cash balance at the ends of March, April, and May.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 4P

See similar textbooks

Similar questions

Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year
Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. January February March Month Credit Sales $300,000 (actual) 400,000 (actual) 473,000 (estimated) April May 671,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 50% 30 15 5 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. Compute Spicer's budgeted cash balance at the ends of March, April, and May. Answer is complete but not entirely…
On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month January February March April May Credit Sales $ 300,000 (actual) 400,000 (actual) 559,000 (estimated) 556,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. 50% 30 Cash balance on March 31 Cash balance on April 30 Cash balance on May 31 15 5 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. Compute Spicer's budgeted cash…
4. On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month Credit Sales $ 300,000 (actual) 400,000 (actual) 625,000 (estimated) 876,000 (estimated) 800,000 (estimated) January February Ask March April May 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 50% 30 15 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 tinvesting activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March. April, and May Cash balance on March 31 Cash…
On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November, and December. All of Molloy's sales are made on account. The following information was used in preparing estimated cash collections: August sales (actual) September sales (actual) October sales (estimated) November sales (estimated) December sales (estimated) $ 40,000 $ 50,000 $ 20,000 $ 70,000 $ 60,000 Approximately 60% of all sales are collected in the month of the sale, 30% is collected in the following month, and 10% is collected in the month thereafter. Budgeted collections from customers in October total:
Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $68,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.)
The following information was taken from Concord Corporation cash budget for the month of July: Beginning cash balance $100000 Cash receipts 96000 Cash disbursements 136000 If the company has a policy of maintaining an end of the month cash balance of $100000, the amount the company would have to borrow is
On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November, and December. All of Molloy's sales are made on account. The following information was used in preparing estimated cash collections: August sales (actual) September sales (actual) October sales (estimated) November sales (estimated) December sales (estimated) Approximately 60% of all sales are collected in the month of the sale, 30% is collected in the following month, and 10% is collected in the month thereafter. Budgeted collections from customers in November total: $ 40,000 $ 50,000 $ 20,000 $ 70,000 $ 60,000
Use the information for the company below to answer the question that follow.A company is preparing its cash budget. Its cash balance on January 1 is $290,000, and it has a minimum cash requirement of $340,000. The following data have been provided: January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 984,500 1,210,000 1,075,000 What is the amount of the deficiency or excess cash (after considering the minimum cash balance required) for January?