Goya Direct Music Limited operates a mail order business offering classical music CDs to the general public. The balance sheet is as follows: Current assets Cash Accounts receivable Inventory Total current assets Property, plant, and equipment Furniture and fixtures Less: Accumulated depreciation Motor vehicles Less: Accumulated depreciation Total property, plant, and equipment Total assets Current liabilities Accounts payable Accrued overhead Goya Direct Music Limited Balance Sheet As at May 31, 2010 (in $ thousands) Long-term liabilities Debentures (10%, 2015) Total liabilities Shareholders' equity Common shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity June July August September October November Sales (5) 130,000 140,000 150,000 110,000 90,000 105,000 72 (24) 46 (28) Purchases ($) 102,000 118,000 115,000 88,000 67,000 110,000 27 107 80 48 18 93 17 10 100 214 66 280 110 60 170 The following forecast information for the six months ended November 30, 2010, is available: 1. Sales and purchases for the six months ended November 30, 2010, are estimated as follows: 110 280 2. The gross profit margin on goods sold is 40%. 3. Customers are allowed one month's credit. Suppliers are paid one month after the month of purchase. 4. Salaries and wages are expected to be $30,000 each month. In addition, an annual staff bonus of $12,000 is due for payment in October 2010. All salaries and wages are paid in the month incurred. 5. Selling and administration expenses are expected to be $20,000 per month, and are payable one month after incurred. This figure includes a charge of $3,000 per month of depreciation of property, plant, and equipment. In addition to these expenses, the business is committed to a large advertising campaign. This is not due to commence until December 2010, although advance pay- ments of $60,000 must be made to newspapers and magazines in November 2010. 6. The only financing expense incurred by the business is debenture interest that is not payable until the year end. 7. $10,000 of the debenture loan will be repaid in August 2010. The business has arranged with the bank an overdraft limit of $100,000 to cover the next 12 months, which both parties agreed should not be exceeded. Ignore taxation. Required: (a) Prepare a cash budget for each of the six months to November 30, 2010. (b) Prepare a pro forma income statement for the six months ended November 30, 2010. (A monthly breakdown is not required.) (c) Discuss the problems, if any, the business is likely to face in the next six months and how these might be resolved.