Exercise 23.9 (Algo) Budgeting an Ending Cash Balance (LO23-4, LO23-5) 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: The company's collection activity on credit sales historically has been as follows: 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. Required: Compute Spicer's budgeted cash balance at the ends of March, April, and May