Please see attachment

Document Preview:

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT A – Case 9-30 Student Name: SALES BUDGET: Budgeted unit sales Selling price per unit Total Sales April May June Quarter SCHEDULE OF EXPECTED CASH COLLECTIONS: February sales March sales April sales May sales June sales Total Cash Collections MERCHANDISE PURCHASES BUDGET: Add desired ending inventory Total needs Less beginning inventory Required purchases Cost of purchases @ $4 per unit BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES: Accounts payable April purchases May purchases June purchases Total cash payments EARRINGS UNLIMITED CASH BUDGET FOR THE THREE MONTHS ENDING JUNE 30 Cash balance Add collections from customers Total cash available Less Disbursements Merchandise purchases Advertising Rent Salaries Commissions Utilities Equipment purchases Dividends paid Total Disbursements over disbursements Excess (deficiency) of receipts Financing: Borrowings Repayments Interest Total financing Cash balance, ending BUDGETED INCOME STATEMENT FOR THE THREE MONTHS ENDED JUNE 30 Sales Variable expenses: Cost of goods sold Contribution Margin Fixed expenses: Advertising Insurance Depreciation Net operating income Interest expense Net income BUDGETED BALANCE SHEET JUNE 30 Assets: Cash Accounts receivable (see below) Inventory Prepaid insurance Property and equipment, net Total assets Liabilities and Stockholders’ Equity Accounts payable, purchases Dividends payable Capital stock Retained earnings (see below) Total liabilities and stockholders’ equity Accounts receivable at June 30: May sales x ?% June sales x ?% Total Retained earnings at June 30: Balance, March 31 Add net income Less dividends declared Balance, June 30 ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????