Calculating the Cash Budget. Here are some important figures from the budget of Red Barchetta, Inc., for the second quarter of 2010:
| April | May | June |
Credit sales | $398,000 | $347,000 | $435,000 |
Credit purchases | 175,000 | 163,000 | 196,000 |
Cash disbursements |
|
|
|
Wages, taxes, and expenses | 79,300 | 74,800 | 103,500 |
Interest | 9,000 | 9,000 | 9,000 |
Equipment purchases | 31,000 | 3,500 | 143,000 |
The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase.
In March 2010, credit sales were $325,000. Using this information, complete the following cash budget:
| April | May | June |
Beginning cash balance | $105,000 |
|
|
Cash receipts |
|
|
|
Cash collections from credit sales |
|
|
|
Total cash available |
|
|
|
Cash disbursements |
|
|
|
Purchases | 167,000 |
|
|
Wages, taxes, and expenses |
|
|
|
Interests |
|
|
|
Equipment purchases |
|
|
|
Total cash disbursements |
|
|
|
Ending cash balance |
|
|
|
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.