Your assignment is prepare a Cash Budget for April, May, and June!!!

FINANCIAL DATA Assets Equipment Purchases Cash 9,000 April $ 19,750 $ 48,000 $ 12,600 $ 200,000 Account Receivable May Inventory June Plant and Equipment (net) Budgeted Sales $ 269,000 $ 60,000 $ 70,000 $ 85,000 $ 90,000 $ 50,000 Total Assets March April Liabilities and Equity May Interest Payable June Note Payable July Accounts Payable 18,300 Share Capital $ 180,000 Minimum Cash Balance $ 8,000 Retained Earning 71,300 Sales Mix Total Liabilities and Equity $ 269,600 Cash Sales 20% Credit Sales 80% Budgeted Expenses (monthly) (Collected next month) Wages and Salaries 7,500 Freight Out (% of sales) 6% Gross Margin 40% Advertising 6,000 Amortization 2,000 Loan Interest Rate 12% Other expenses (% of sales) 4% (monthly payment) (Borrow at beginning period Repayment at end period) Inventory Paid 50% month of 50% month after Minimum Inventory Policy Dividend Paid (% of next months COGS) 30% April May June $ 4,000 Prepare a cash budget for April to June %24