Chapter 22: 15RQ (page 1228)
What are the three sections of the cash budget?
Cash receipts, cash payments, and short-term financing are three sections of the cash budget.
Over 30 million students worldwide already upgrade their learning with Vaia!
All the tools & learning materials you need for study success - in one app.
Get started for free
: Completing a comprehensive budgeting problem—merchandising company
Belton Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted income statement for the month of April 2018 and a balance sheet at April 30, 2018. The March 31, 2018, balance sheet follows:
As Belton Printing’s controller, you have assembled the following additional information:
a. April dividends of \(7,000 were declared and paid.
b. April capital expenditures of \)17,000 budgeted for cash purchase of equipment.
c. April depreciation expense, \(800.
d. Cost of goods sold, 55% of sales.
e. Desired ending inventory for April is \)24,800.
f. April selling and administrative expenses includes salaries of \(29,000, 20% of which will be paid in cash and the remainder paid next month.
g. Additional April selling and administrative expenses also include miscellaneous expenses of 10% of sales, all paid in April.
h. April budgeted sales, \)86,000, 80% collected in April and 20% in May.
i. April cash payments of March 31 liabilities incurred for March purchases of inventory, \(8,300.
j. April purchases of inventory, \)22,900 for cash and $37,200 on account. Half the credit purchases will be paid in April and half in May
Requirements
1. Prepare the sales budget for April.
2. Prepare the inventory, purchases, and cost of goods sold budget for April.
3. Prepare the selling and administrative expense budget for April.
4. Prepare the schedule of cash receipts from customers for April.
5. Prepare the schedule of cash payments for selling and administrative expenses for April.
6. Prepare the cash budget for April. Assume the company does not use short-term financing to maintain a minimum cash balance.
7. Prepare the budgeted income statement for April.
8. Prepare the budgeted balance sheet at April 30, 2018.
Preparing a financial budget—schedule of cash payments
Jefferson Company has budgeted purchases of merchandise inventory of \(457,500 in January and \)533,250 in February. Assume Jefferson pays for inventory purchases 70% in the month of purchase and 30% in the month after purchase. The Accounts Payable balance on December 31 is $98,275. Prepare a schedule of cash payments for purchases for January and February.
What are the budgeted financial statements? How do they differ from regular financial statements?
Using sensitivity analysis Holly Company prepared the following budgeted income statement for the first quarter of 2018:
Holly Company is considering two options. Option 1 is to increase advertising by \(700 per month. Option 2 is to use better-quality materials in the manufacturing process. The better materials will increase the cost of goods sold to 45% but will provide a better product at the same sales price. The marketing manager projects either option will result in sales increases of 30% per month rather than 20%.
Requirements
1. Prepare budgeted income statements for both options, assuming both options begin in January and January sales remain \)8,000. Round all calculations to the nearest dollar.
2. Which option should Holly choose? Explain your reasoning.
Preparing the financial budget—budgeted balance sheet
Barker, Inc. has the following balance sheet at December 31, 2018:
Barker projects the following transactions for 2019:
Sales on account, \(20,000
Cash receipts from customers from sales on account, \)17,600
Purchase of raw materials on account, \(7,000
Payments on account, \)3,500
Total cost of completed products, \(16,600, which includes the following:
Raw materials used, \)7,100
Direct labor costs incurred and paid, \(3,900
Manufacturing overhead costs incurred and paid, \)4,800
Depreciation on manufacturing equipment, \(800
Cost of goods sold, \)14,800
Selling and administrative costs incurred and paid, \(500
Purchase of equipment, paid in 2019, \)2,000
Prepare a budgeted balance sheet for Barker, Inc. for December 31, 2019. (Hint: It may be helpful to trace the effects of each transaction on the accounting equation to determine the ending balance of each account.)
What do you think about this solution?
We value your feedback to improve our textbook solutions.
