Question: 4 - Castor, Inc. is preparing its master budget for the quarter ended June 3 0 . Budgeted sales and cash payments for merchandise for

4- Castor, Inc. is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Sales are \(50\%\) cash and \(50\%\) on credit. Sales in March were \(\$ 24,000\). All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of \(\$ 12,000\) in cash, and \(\$ 2,000\) in loans payable. A minimum cash balance of \(\$ 12,000\) is required. Loans are obtained at the end of any month when the preliminary cash balance is below \(\$ 12,000\). Interest is \(1\%\) per month based on the beginning-of-themonth loan balance and is paid at each month-end. If a preliminary cash balance above \(\$ 12,000\) at monthend exists, loans are repaid from the excess. Expenses are paid in the month incurred and consist of sales commissions (\(10\%\) of sales), shipping (\(2\%\) of sales), office salaries (\(\$ 5,000\) per month) and rent (\(\$ 3,000\) per month). a) Prepare a schedule of cash receipts from sales for April, May, and June. b) Prepare a cash budget for each of April, May, and June.
4 - Castor, Inc. is preparing its master budget

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!