Question

In: Accounting

Use the following information to prepare a cash budget for December. The cash balance on December...

Use the following information to prepare a cash budget for December.

  1. The cash balance on December 1 is $53,400.

  2. Actual sales for October and November and expected sales for December are as follows:

October November December
Cash sales $ 77,000 $ 81,200 $ 87,800
Sales on account $ 435,000 $ 538,000 $ 644,000

Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible.

  1. Purchases of inventory will total $341,000 for December. Thirty percent of a month’s inventory purchases are paid during the month of purchase. The accounts payable remaining from November’s inventory purchases total $165,000, all of which will be paid in December.

  2. Selling and administrative expenses are budgeted at $516,000 for December. Of this amount, $94,900 is for depreciation.

  3. A new web server for the Marketing Department costing $121,500 will be purchased for cash during December, and dividends totaling $13,000 will be paid during the month.

  4. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company’s bank to increase its cash balance as needed.

Required:

Calculate the expected cash collections for December.

Calculate the expected cash disbursements for merchandise purchases for December.

Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month.

Solutions

Expert Solution

Expected cash collections December
   Cash sales of December $87,800
From credit sales:
   October sales ($435,000*18/100) $78,300
   November sales ($538,000*60/100) $322,800
   December sales ($644,000*20/100) $128,800
Total Cash Collections $617,700
Expected cash disbursements for material purchases December
   Accounts payable - November $165,000
   December purchases ($341,000*30/100) $105,300
Total cash disbursements for material purchases $270,300
Cash Budget December
Beginning cash balance $53,400
Add: Expected cash collections $617,700
Total Cash Available (a) $671,100
Less: Cash Disbursements:
   For material purchases $270,300
   For selling and administrative expenses ($516,000 - $94,900) $421,100
   For Purchase of Web Server $121,500
   For Dividends $13,000
Total Cash Disbursements (b) $825,900
Preliminary Cash balance (a - b) ($154,800)
Financing:
Borrowings ($154,800 + $20,000) $174,800
Repayments $0
Interest Expense $0
Ending Cash Balance $20,000

Related Solutions

You have been asked to prepare a December cash budget for Garrick Company. The following information...
You have been asked to prepare a December cash budget for Garrick Company. The following information is available for December for Garrick Company’s operations: a. The cash balance on December 1 is $44,400. b. Actual sales for October and November and expected sales for December are as follows: October November December Sales on account $500,000 $700,000 $720,000 c. Sales on account are collected over a three-month period as follows: 30% collected in the month of sale and 60% collected in...
You have been asked to prepare a December cash budget for Garrick Company. The following information...
You have been asked to prepare a December cash budget for Garrick Company. The following information is available for December for Garrick Company’s operations:            The cash balance on December 1 is $44,400.             Actual sales for October and November and expected sales for December are as follows:                                                                               October               November          December Sales on account               $500,000              $700,000              $720,000              Sales on account are collected over a three-month period as follows: 30% collected in the month of sale and 60%...
Use the following information to prepare the July cash budget for Acco Co. It should show...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $68,000. Cash receipts from sales: 20% is collected in the month of sale, 50% in the next month, and 30% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,800,000; June...
Use the following information to prepare the July cash budget for Acco Co. It should show...
Use the following information to prepare the July cash budget for Acco Co. It should show expected cash receipts and cash payments for the month and the cash balance expected on July 31. Beginning cash balance on July 1: $66,000. Cash receipts from sales: 25% is collected in the month of sale, 50% in the next month, and 25% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are May (actual), $1,950,000; June...
Use the following information to prepare the July cash budget for Anker Co. It should show...
Use the following information to prepare the July cash budget for Anker Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31. a. Beginning cash balance on July 1: $63,000. b. Cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual),...
Using the following information prepare a cash flow statement. Hamilton Beach Company Comparative Balance Sheets December...
Using the following information prepare a cash flow statement. Hamilton Beach Company Comparative Balance Sheets December 31, 2018 and 2019 Assets 2018 2019 Difference Cash 15,000        47,000           32,000 Accounts Receivable 55,000        47,000           (8,000) Inventory 110,000      144,000           34,000 Prepaid Expenses 5,000          1,000           (4,000) Long Term Investments 127,000      115,000         (12,000) Land 55,000        55,000                    -   Building & Equipment 450,000     660,000         210,000 Accumulated Depr-Building & Equipt (68,000) (103,000)         (35,000)...
Use the information below to prepare the Balance Sheet as of December 31. Glow Styling Adjusted...
Use the information below to prepare the Balance Sheet as of December 31. Glow Styling Adjusted Trial Balance December 31 Account Title Debit Credit Cash $4,200.00 Rent Receivable $200.00 Prepaid Insurance($1480-$1240) $240.00 Shop Supplies(Given) $210.00 Shop Equipment $3,860.00 Building $57,500.00 Land $55,000.00 Accumulated Depreciation-Shop Equipment($770+$350) $1,120.00 Accumulated Depreciation-Building($3840+$2220) $6,060.00 Wages Payable($50*4) $200.00 Property Taxes Payable(given) $450.00 Interest Payable(given) $600.00 Unearned Rent($1600-$800) $800.00 Long Term Note Payable $50,000.00 G.Capital $49,860.00 Rent Earned($2400+$200+$800) $3,400.00 Fees Earned $23,400.00 Wages Expense($3200+$200) $3,400.00 Utilities Expense...
From the following data, prepare a cash budget for the three months ending 31st December,2019                           &nbsp
From the following data, prepare a cash budget for the three months ending 31st December,2019                                                                                                   (1) Months Sales (AED) Materials (AED) Wages (AED) Overheads (AED) September 10000 5000 1000 200 October 20000 4000 1000 200 November 25000 3000 2500 200 December 10000 4200 2000 300 (2) Credit terms are:        (a) sales/debtors- 50% sales are on cash basis, 50% of the credit sales are collected next month.        (b) Creditors for materials- 1 months for wages- Same months for...
Use the following data to prepare the Indirect Cash Flow Statement for December 31, 2014: Cash...
Use the following data to prepare the Indirect Cash Flow Statement for December 31, 2014: Cash at End of the Year 2013 - $50,000; 2014 - $40,000 Net Income for 2014 - $130,000 Purchase of Equipment with Cash- $30,000 Non-cash Adjustments to Current Assets and Current Liabilities ($90,000) Note: This is negative: Declared and paid $20,000 in Cash Dividends. The Alpha Corporation issues $5,000,000 of 5%, 15 year bonds dated January 1, 2014, that pay interest semiannually on June 30...
Use the following information to prepare a multistep incomestatement and a balance sheet for Sherman...
Use the following information to prepare a multistep income statement and a balance sheet for Sherman Equipment Co. for 2016. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.)(Balance Sheet only: Items to be deducted must be indicated with a minus sign.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT