1. Sales Budget 2. Merchandise Purchases Budget 3. Selling and Administrative Expense Budget 4. Capital Expenditures Budget 5. Collections and payments Budget 6. Pro-Forma (Budgeted) Income Statement 7. Cash Budget 8. Pro-Forma (Budgeted) Balance Sheet Big Banana Sport Drinks is a business that sells a specialty sports drinks. The company's fiscal year ends on December 31. Information to be used for the operating budget this coming year follows. Sales and Merchandise Purchases Budget Information - Sales for this coming year ending December 31 in units are expected to be as follows: - Each unit is sold for $12. - Cost of goods sold is 58% of sales (to be used for the merchandise purchases budget). Merchandise inventory is maintained at a level equal to 15% of the next quarter's cost of goods sold Budgeted sales for the first quarter of the following year are $2,442,000. Operating and Interest Expenses Budqet Information - Management estimates all other costs, aside from advertising and depreciation, are fixed. - Selling and administrative cost estimates for the first quarter of the coning year are: - Salary expenses for the fourth quarter will be $25,000 higher in anticipation of higher sales. - Advertising expenses for each quarter will be 10% higher than the previous quarter and will therefore increase throughout the year. Capital Expenditure and Cash Budget Information - The company plans to pay cash for property, plant, and equipment totaling $65,000 at the end of the third quarter. Note; this will cause the depreciation for the fourth quarter to increase by $1,600 to $46,700. - The company expects to collect 75 percent of sales in the quarter of sale and 25 percent the quarter following the sale. Accounts receivable at the end of last year totaled $500,000, all of which will be collected during the first quarter of this coming year - All inventory purchases are on credit. The company expects to pay 60 percent of inventory purchases in the quarter of purchase and 40 percent the following quarter. Accounts payable at the end of last year totaled $466,170, all of which will be paid during the first quarter of this coming year. - The cash balance at the beginning of this coming year is expected to be $45,000. - A dividend payment of $150,000 will be paid in each quarter to the owners of the business. - $250,000 of the long-term debt will be repaid at the end of Q4 Budgoted Balance Sheet and Income Statement Information - Assurne 25% of fourth quarter budgeted sales will be collected in full the following year (this represents accounts receivable at the end of the fourth quarter) - Big Banana started the year with long-term debt of $1,200,000. - Expected account balances at the end of the fourth quarter are: totaled $466,170, all of which will be paid during the first quarter of this coming year. - The cash balance at the beginning of this coming year is expected to be $45,000. - A dividend payment of $150,000 will be paid in each quarter to the owners of the business. - $250,000 of the long-term debt will be repaid at the end of Q4. Budqeted Balance Sheet and Income Statement Information - Assume 25% of fourth quarter budgeted sales will be collected in full the following year (this accounts receivable at the end of the fourth quarter). - Big Banana started the year with long-term debt of $1,200,000. - Expected account balances at the end of the fourth quarter are: - The company's income is taxed at a rate of 25%. - Actual retained earnings at the end of the last year totalled $338,970. Roquired: 1. Prepare a quarterly sales budget. 2. Prepare a quarterly merchandise purchases budget 3. Prepare a quarterly selling and administrative budget. 4. Prepare a quarterly capital expenditures budget. 5. Prepare a quarterly collections and inventory payments budget. 6. Prepare a quarterly budgeted income statement. 7. Prepare a quarterly cash budget 8. Prepare a budgeted balance sheet at December 31
