. Prepare a monthly cash budget and supporting schedules for March, April, and May. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
|
|
|
|
| For the Three Months Ending May 31, 2012 |
|
|
|
|
|
|
|
|
| Estimated cash receipts from: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Collection of accounts receivable |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated cash payments for: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Selling and administrative expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Note payable (including interest) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash increase or (decrease) |
|
|
|
|
|
|
|
| Cash balance at beginning of month |
|
|
|
|
|
|
|
| Cash balance at end of month |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|