Need help with balance sheet

OctoberNovember December Total-Qtr Cash Budget Beginning cash balance Issuance of stock Collections from customers Cash available Less payments For inventory purchases g. 16 10,800 | 40,310 600,000 225,000 825,000 522,500 563,300 574,750 615,060 600,000 1,322,250 1,922,250 just a heading-no input this line 445,840 1,159,120 249.200 900,000 2,600 8,550 2,319,470 For S&A expenses 91,600 95,200 Purchase of store fixtures 900,000 Pay dividend Interest expense Total budgeted payments Cash balance before borrow/repay Financing activity Borrowing (repayment Ending cash balance 2,600 3,910 1,175,200 (350,200) 548,280 66,780 (32,690) just a heading- no input this line 73,000 40,310 (26,000) 40,780 438,000 40,780 check math 60 vertically too Balance Sheet Enter any contra-assets as negative numbers. Use a minus sign Assets Cash Accounts receivable Inventory Store fixtures Accumulated depreciation Total assets Liabilities Accounts payable Utilities payable Sales commissions payable Line of credit liability Total liabilities Equity Common stock Retained earnings Total equity Total liabilities and equity Total-Qtr a. Sales Budget 6Cash sales 272,250 275,000 Total budgeted sales 1,655,00 b. Total-Qtr Schedule of Cash Receipts Current cash sales Plus collections from A/R 8 225,000 (Hint-these do n Total-Qtr c. Inventory Purchases Budget 10 Budgeted cost of goods sold Plus desired ending inventory 132,000 Required purchases (on account) 532,000 453,200 d. Schedule of Cash Payments Budget for Inventory Purchases Total-Qtr Payment of current month's A/P Payment for prior month's AVP Total budgeted payments 212,800 319,200 e. Selling and Administrative Expense Budget alary expense Sales commissions expense Supplies expense Utilities Expense Depreciation expense on store fxtures Rent expense Miscellaneous expense Total S&A expenses October 38,400 25,000 10,000 3,200 9,125 12,000 November 38,400 7,500 11,000 3,200 9,125 12,000 Total-Qtr 115,200 82,750 33,100 9,600 27,375 36,000 6,000 310,025 38,400 30,250 3,200 9,125 12,000 2,000 ne 103,225 f. Schedule of Cash Payments for S&A Expenses (Some balances may be zero.) October Total-Qtr Salaries Sales commissions Supplies expense Utilities Depreciation on store foxtures 25,000 11,000 3,200 52,500 33,100 6,400 27,500 10,000 3,200 36,000 6,000 249.200 Miscellaneous 2,000 62,400 2,000 2,000 95,200 Total payments for S&A expenses 91,600