0
0

0
0

0
0

0
0

0
0

0
0

0
0

0
0

0
0

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