I answered A-D, need help with E-J

Cash Basis 50000 54000 58000 Sale on Account 75000 81000 87000 Total Budgeted Sale 125000 135000 145000 Req-B October November December Schedule of cash receipt Current Cash Sales 50000 54000 58000 Plus : collection from A/R o 50000 54000 Total collection 50000 104000 112000 Req-C October November December Inventory purchased budget Cost of goods sold 75000 81000 87000 Add: Desired ending inventory 8100 8700 6000 Inventory needed 83100 89700 93000 Less: beginning Inventory 0 8100 8700 Required purchased 83100 81600 84300 Req-D October November December Schedule of cash Payment Budget Payment of Current Month Account payable 58170 57120 59010 Payment of Prior month Account payable o 24930 24480 Total budget payment of Inventory 58170 82050 83490 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F Required G Required H Required! Required) Prepare a selling and administrative expenses budget. November December October Selling and Administrative Expense Budget Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F Required G Required H Required I Required Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses. November December October Schedule of Cash Payments for S&A Expenses Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total payments for S&A expenses Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F Required G Required H Required I Required) Camden borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $5,000 cash cushion. Prepare a cash budget. (Any repayments should be indicated with a minus sign.) Show less Cash Budget October November December Section 1: Cash Receipts Total cash available Section 2: Cash Payments Total budgeted disbursements Section 3: Financing Activities Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F Required G Required H Required I Required Prepare a pro forma income statement for the quarter. CAMDEN COMPANY Pro Forma Income Statement For the Quarter Ended December 31, Year 1 Required A Required B Required C Required D Required E Required F. Required G Required H Required 1 Required) Prepare a pro forma balance sheet at the end of the quarter. (Amounts to be deducted should be indicated by a minus sign.) CAMDEN COMPANY Pro Forma Balance Sheet December 31, Year 1 Assets Total assets Liabilities Equity Total liabilities and equity Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Required F Required G Required H Required I Required Prepare a pro forma statement of cash flows for the quarter. (Cash outflows should be indicated with a minus sign.) CAMDEN COMPANY Pro Forma Statement of Cash Flows For the Quarter Ended December 31, Year 1 Cash flows from operating activities Net cash flows from operating activities Cash flows from investing activities Cash flow from financing activities