Fi504 Case Study 3 Cash Budget

520 Words3 Pages
CASE STUDY 3 - Cash Budget Template SCHEDULE OF EXPECTED CASH COLLECTIONS FROM CUSTOMERS: Credit Sales August September July 30,000 x 40% 12,000 August (24,000x60%) (24,000x40%) 14,400 9,600 September (24000x60%) 14,400 Total Cash Collections 26,400 24,000 SCHEDULE FOR EXPECTED PAYMENTS FOR PURCHASE OF INVENTORY Inventory purchases August September July (65,000 x 50%) 32,500 August (45,000 x 50%),collected Sept(45,000 x 50%) 22,500 22,500 September (21,000 x 50%), 10,500 Total Payments for Inventory Purchases 55,000 33,000 Oxford Company Cash Budget For the Two Months of August and September August September Cash balance $10,000 $10,000 Add: Receipts Collections from customers 26,400 24,000 Sale of plant assets 12,350 Sale of new common stock 16,850 Cash sales 51,000 39,000 Total receipts 89,750 79,850 Total Available Cash 99,750 89,850 Less: Disbursements Purchases of inventory 55,000 33,000 Operating expenses 6,750 6,750 Selling and administrative expenses12,500 12,500 Dividends 19,000 Equipment purchase 6,000 Total disbursements 93,250 58,250 Excess (deficiency of available cash over disbursements) 6,500 31,600 Financing Borrowings 3,500 Repayments (3,780) Ending cash balance $10,000 27,820 (3500 x12%x 8/12=280.00 +3500=3780) . Answer to the questions What are the three sections of a Cash Budget, and what is included in each section? The Cash receipts section includes expected receipts from the company’s principal source(s) of cash, such as cash sales and collections from customers on credit sales. This section also shows anticipated

More about Fi504 Case Study 3 Cash Budget

Open Document