Cash Budget - Renson Corporation
Not what you're looking for?
Renson Corporation, a wholesaler, provided the following information:
Month Merchandise Purchases Sales
January $142,000 $172,000
February 148,000 166,000
March 136,000 165,000
April 154,000 178,000
May 160,000 166,000
Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The company pays all invoices in the month following purchase and takes advantage of a 3% discount on all amounts due. Cash payments for operating expenses in May will be $119,500; Renson's cash balance on May 1 was $127,800.
Required: Determine the following:
A. Expected cash collections during May.
B. Expected cash disbursements during May.
C. Expected cash balance on May 31.
Purchase this Solution
Solution Summary
The solution provides cash budget for Renson Corporation in excel.
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Learning Lean
This quiz will help you understand the basic concepts of Lean.