| CASE STUDY 3—Cash Budget Template |
| SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS |
| Credit Sales | | | May | June |
| April |
| May |
| June |
| Total Cash Collections | | | - 0 | - 0 |
| SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY |
| Inventory purchases | | | May | June |
| April |
| May |
| June |
| Total Payments for Inventory Purchases | | | - 0 | - 0 |
| | LBJ Company |
| | Cash Budget |
| | For the Two Months of May and June |
| | | | May | June |
| Cash balance |
| Add: Receipts |
| Collections from customers | | | 0 | 0 |
| Sale of plant assets |
| Sale of new common stock |
| Cash sales |
| Total receipts | | | 0 | 0 |
| Total Available Cash | | | 0 | 0 |
| Less: Disbursements |
| Purchases of inventory | | | 0 | 0 |
| Operating expenses |
| Selling and administrative expenses |
| Equipment purchase |
| Dividends |
| Total disbursements | | | - 0 | - 0 |
| Excess (deficiency of available cash over disbursements) | | | - 0 | - 0 |
| Financing |
| Borrowings |
| Repayments |
| Ending cash balance | | | $0 | - 0 |
| Please answer the three qualitative questions on the next tab called Qualitative Questions. |
TheOne
acct504_case_study_3_cash_budget_template.xlsx
