Preparation of a budget for jan feb march 2014

Consider the following Income statement and balance sheet at Dec 31 2013 income statment for Dec 2013 Sales 400 000,00 - should be increased by Noy in the next month. Cogs Grosss profit 100 000,00 operating expenses 300 000,00 30 000,00 rent 10 000,00 salaries 15 000,00 electricity 5 000,00 net income Div 270 000,00 R /E 120 000,00 150 000,00 balance sheet as of Dec 31st 2013 Assets Liabilities Cash 100 000,00 160 000,00 A / P. A/R 40 000,00 150 000,00 Note/payable 60 000,00 Inv 60.000,00 . equipment 20 000,00 O/E E ) LTD 470 000,00 land 180 000,00 C/S 320 000,00 R/E as asset 150 000,00 570 000,00 570 000,00 sales are budgeted to increase by 10% 70% of sales is collected in current month while 30% for the next month 70% of purchases are paid in current month while 30% for the next month Ending inventory 20 000,00 plus 80% next month COGS Minimum cash desired each month 15 000,00 equipmet to increase by 10% * land to increase by 15% operating expenses to change in the following manner rent to increase by 5% each month salries to increase by 10% each month 2% of sales electricity Prepare a budget for jan -feb -march 2014 9. Budgeted income statement 1. Sales budget 10. Budgeted balance sheet 2. Sales collection budget 3. Purchases budget 4. Cash disbursement for inventory purchase budget repayment 5. Operating expenses budget 6. Capital expenditure budget 7. Cash disbursement for capital expenditure budget 8. Cash budget