Compute a budgeted cash balance
Not what you're looking for?
Sherman Company has a cash balance on January 1 of $123,219. Given the following data, compute Sherman's budgeted cash balance on March 31. Round all amounts to the nearest dollar.
Past and budgeted future activity, in $000:
Sales Operating expense
November 1,625 525
December 1,790 460
January 1,428 448
February 1,295 395
March 1,306 421
April 1,422 404
Sherman has a gross profit of 40%, and has a policy of maintaining an inventory of 150% of expected next-month sales. Operating expenses are paid 75% in the current month, and 25% in the following month. Purchases of merchandise are paid for 50% in the current month, and 50% in the following month. All sales are on credit. Normal pattern of collections is: 40% in month of sale, 44% in following month, 11% in next following month, 5% uncollectible.
Purchase this Solution
Solution Summary
This solution illustrates how to compute a budgeted cash balance.
Solution Preview
Please see the attached Excel 97-2003 spreadsheet for format and formulas.
Sherman Company has a cash balance on January 1 of $123,219.Ã? Ã? Given the following data, compute Sherman's budgeted cash balance on March 31.Ã? Ã? Round all amounts to the nearest dollar.
Past and budgeted future activity, in $000:
Operating
Sales expense
November $1,625 $525
December $1,790 $460
January $1,428 $448
February $1,295 $395
March $1,306 $421
April $1,422 $404
Sherman has a gross profit of 40%, and has a policy of maintaining an inventory of 150% of expected next-month sales.Ã? Ã? Operating expenses are paid 75% in the
current month, and 25% in the following month.Ã? Ã? Purchases of merchandise are paid for 50% in the ...
Purchase this Solution
Free BrainMass Quizzes
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.