Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The PINK Company has budgeted sales revenues as follows: Credit sales Cash sales Total sales Jan $27,000 18,000 $45,000 Feb $24,000 51,000 $75,000 March $18,000
The PINK Company has budgeted sales revenues as follows: Credit sales Cash sales Total sales Jan $27,000 18,000 $45,000 Feb $24,000 51,000 $75,000 March $18,000 39,000 $57,000 Past experience indicates that 60% of the credit sales will be collected in the mouth of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the mouth of purchase and 50% in the month following purchase. Budgeted inventory purchases are: Jan Feb March $60,000 45,000 21,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $7,000 each month, (b) dividends of $20,700 will be paid in Feb, and (c) purchase of a computer in March for $6,000 cash. The company wishes to maintain a minimum cash balance of $10,000 at the end of each month. The company borrows money from the bank at 9% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on Feb 1 was $10,000. Assume that borrowed money in this case is for one month. Required: Prepare a cash budget for the months of Feb and March
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started