3 Cash Budget for July (yellow boxes have formulas built it ) Valley Manufacturing Inc Cash Budget For the Month of July Beginning cash balance Add: collections from customers Total cash available S Less: cash disbursements: Leave Blank Purchase of inventory Selling and administrative expenses Total cash disbursements Excess of cash available over disbursements Financing: Leave Blank Borrowing Repayments Interest Total financing $ Ending cash balanceValley Manufacturing Inc Balance Sheet June 30, 2021 Assets Cash 140,000 Accounts receivable 175,000 Inventory 45,200 Plant and equipment, net of depreciation 554,800 Total Assets 915,000 Liabilities and Stockholders' Equity Accounts payable 115,000 Common stock S 586,000 Retained earnings 214,000 Total Liabilities and Stockholders' Equity 915,000