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

Cash USD 35,000

Accounts receivable USD 270,000

Marketable securities USD 15,000

Inventory  USD 154,000

Net PPE USD 626,000

Total assets USD 1,100,000

Accounts payable USD 176,400

Bond interest payable USD 12,500

Property tax payable USD 3,600

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

Common stock USD 500,000

Retained earnings USD 107,500

Total liabilities and equity USD 1,100,000

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

• 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.
• 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.
• The company has estimated other expenses:
  • Sales salary USD 21,000
  • Advertising and promotion USD 16,600
  • Administrative salaries USD 21,000
  • Depreciation USD 25,000
  • Interest on bonds USD 2,500
  • Property taxes USD 900
  • In addition sales commission is 1% of sales.
• 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.
• The shareholders demanding to pay them dividends of USD 50,000 at the end of each quarter.
• 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.
• Property taxes are paid semiannually on February 28 and August 31 for preceding six month period. 

Required:

Prepare Sun Company’s master budget for first quarter of 2011 by completing 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