SECTION ONE IV The Billig Company's recent and forecasted sales for certain months 2005 and 20x6 are: November December July, 2035 $75,000 August 50,000 September 50,000 October 125,000 The September 30, 20x5 balance sheet shows: $150,000 75.000 January, 2006 90,000 80,000 February EQUITIES $ 70,000 1,500 17.500 $89,000 Stockholders' Equity 40.800 Total Equities S129,900 ASSETS Cash $ 3.000 Accounts payable Accounts receivable 30,000 Dividends payable Inventory 75.000 Rent payable Prepaid Insurance 1,800 Total liabilities Fixtures (net) 20.000 Total Assets S129.000 Sales are forecasted at an average price that is twice the average cost per unit Monthly operating expanses are as follows: Fixed wages $38,000 Insurance expired 200 Depreciation 300 Fixed miscellaneous 3,000 Rent 500 + 10% of sales Cash dividends of $1,500 are to be paid quarterly, beginning October 15, and are declared on the fifteenth of the previous month. All operating expenses are paid as incurred, except insurance, depreciation, and rent. Rent of $500 is paid at the beginning of each month, and the additional 10 percent of sales is paid quarterly on the tenth of the month following the quarter. The next Settlement is due October 10. The company desires an ending minimum cash balance of $3,000 each month. Inventories are supposed to equal 120 percent of the next month's projected sales. Inventories are carried at cost. Purchases during any given month are paid in full during the following month. All sales are on credit, payable within thirty days, but experience has shown that 50 percent of current sales are collected in the current month, 40 percent in the next month and 10 percent in the month thereafter. Bad debts are negligible. Continued on next page SECTION ONE Continued from previous page Money can be borrowed and repaid in multiples of $1.000 at an interest rate of 18 percent per annum. Management wants to minimize borrowing and repay as soon as possible. At the time principal is repaid, interest is computed on the portion of principal that is repaid Borrowing takes place at the beginning, and repayments at the end of the months in question. Money is never borrowed and repaid at the end of the same month. Ignore income taxes. REQUIRED: Prepare a master budget for the three months ending December 31, 20x5 including the following five parts: 1. Schedule of purchases 2.Schedule for the collections of sales! 3.Cash budget OCE , Jee 4. Income statement 5. Balance sheet