Cash Budget Essay

401 Words2 Pages
CASE STUDY 3—Cash Budget Template Pape Ndiaye SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS Credit Sales May June April 65,800 May 26,850 62,650 June 22,500 Total Cash Collections 92,650 85,150 SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases May June April 117,000 May 54,000 81,000 June 25,200 Total Payments for Inventory Purchases 171,000 106,200 LBJ Company Cash Budget For the Two Months of May and June May June Cash balance $20,000 $20,000 Add: Receipts Collections from customers 92,650 85,150 Sale of plant assets 33,000 Sale of new common stock 50,000 Cash sales 75,000 57,000 Total receipts 200,650 192,150 Total Available Cash 220,650 212,150 Less: Disbursements 220,650 212,150 Purchases of inventory 171,000 106,200 Operating expenses 15,000 15,000 Selling and administrative expenses 10,150 10,150 Equipment purchase 35,000 Dividends 20,000 Total disbursements 231,150 151,350 Excess (deficiency of available cash over disbursements) (10,500) 60,800 Financing Borrowings 30,500 Repayments (31,008.33) Ending cash balance $20,000 29, Please answer the three qualitative questions on the next tab called Qualitative Questions. 1) What are the three sections of a cash budget, and what is included in each section? Cash budget is the budget for expected cash inflows and outflows during the specific period of time. Cash budget consists of four sections: receipts, disbursements, cash surplus or deficit, and financing section. The receipts section lists the beginning cash balance, cash collections from customers, and other receipts. The disbursements section shows all cash payments. The cash surplus (deficit) section provides the difference between cash receipts and cash disbursements.

More about Cash Budget Essay

Open Document