Question
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
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 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started