Computing Cash Collections and Ending Balances
Not what you're looking for?
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
Jan. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $300,000 (actual)
Feb. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400,000 (actual)
Mar. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 600,000 (estimated)
Apr. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 700,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.
Purchase this Solution
Solution Summary
This solution illustrates how to compute cash collections given monthly credit sales and historical collection patterns, and how to computing the ending budgeted cash balance given the cash expenditures and beginning cash balance.
Purchase this Solution
Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Basics of corporate finance
These questions will test you on your knowledge of finance.