The XYZ company's projected balance sheet as of December 31, 2010 is provided below:

CashUSD 35,000

Accounts receivableUSD 270,000

Marketable securitiesUSD 15,000

Inventory USD 154,000

Net PPEUSD 626,000

Total assetsUSD 1,100,000

Accounts payableUSD 176,400

Bond interest payableUSD 12,500

Property tax payableUSD 3,600

Bonds payable (10% due in 2016)USD 300,000

Common stockUSD 500,000

Retained earningsUSD 107,500

Total liabilities and equityUSD 1,100,000

Now the company is preparing budgets for first quarter of 2011. The following additional information is provided:

1.Projected sales for December 2010 are USD 400,000. Credit sales are typically 75% of total sales. Sun credit experience shows that 10% of credit sales are collected during the month of sales, and remainder is collected in the following month. Sales are expected to increase by 10% each month over the previous month's sales.

2.COGS is 70% of sales. Inventory is purchased on account and 40% of each month's purchases are paid during the month of purchase. The remainder - in the following month. In order to have adequate stock, at the end of the month the level of inventory has to be half of month's projected COGS.

3.The company has estimated other expenses:

a.Sales salaryUSD 21,000

b.Advertising and promotionUSD 16,600

c.Administrative salariesUSD 21,000

d.DepreciationUSD 25,000

e.Interest on bondsUSD 2,500

f.Property taxesUSD 900

g.In addition sales commission is 1% of sales.

4.The company also plans to purchase equipment for 125,000. The purchase will be financed from company's cash and marketable securities. If necessary the company may obtain the loan to finance the purchase. The minimum period is 10 month and interest rate is 10% p.a. If loan is necessary the company plans to repay it at the end of the first quarter.

5.The shareholders demanding to pay them dividends of USD 50,000 at the end of each quarter.

6.The interest on short-term loan of quarter will be paid at the loan repayment. The interest on the company's bond is paid semiannually on January 31 and July 31 for the preceding six-month period.

7.Property taxes are paid semiannually on February 28 and August 31 for preceding six month period.

Required:

Prepare XYZ Company's master budget for first quarter of 2011 by comleting sales budget, cash receipts budget, purchases budget, cash disbursement budget

Prepare budgeted income statement for 1 quarter of 2011

Prepare budgeted balance sheet as of March 31, 2011