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:

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:
4. Sales salary USD 21,000
5. Advertising and promotion USD 16,600
6. Administrative salaries USD 21,000
7. Depreciation USD 25,000
8. Interest on bonds USD 2,500
9. Property taxes USD 900
10. In addition sales commission is 1% of sales.
11. 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.
12. The shareholders demanding to pay them dividends of USD 50,000 at the end of each quarter.
13. 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.
14. 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 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

Exercise 1 Budgeting 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 rst quarter of 2011. The following additional inforrnaticn 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 dung 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 salary USD 21,000 b. Advertising and promotion USD 16,600 c. Administrative salaries USD 21,000 d. Depreciation USD 25,000 e. Interest on bonds USD 2,500 f. Property taxes USD 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 nanced from company's cash and marketable securities. If necessary the company may obtain the loan to nance 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 rst 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: 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