1. Prepare a shedule of expected cash collection for December
Schedule of Expected Cash Collection
Particulars | Amount |
December Cash Sales | $ 95,800 |
Collection on account; | |
October Sales | $ 74,700 |
November Sales | $ 368,400 |
Decmber Sales | $ 138,400 |
Total Cash Collection | $ 677,300 |
Explanation;
# October Sales : $ 415, 000 * 18 % = $74,700
#November Sales : $ 614,000 * 60 % = $ 368,400
# December Sales : $ 692,000 * 20 % = $ 138,400
2.) Prepare a shedule of expected cash disbursements for merchandise Purchase for December;
Schedule of Expected Cash Disbursements
Particulars | Amount |
Payment to Suppliers; | |
November Purchase | $174,500 |
December Purchase | $112,800 |
Total Cash Payments | $287,300 |
Working Note;
December Purchases ; $ 376,000 * 30 % = $112,800
3.) Prepare Cash Budget for December . Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not paid until the following.
ASHTON COMPANY
Cash Budget
For the month of December
Particulars | Amount | Amount |
Beginning Cash Balance | $ 41,000 | |
Add: Collection from Customer | $ 677,300 | |
Total Cash Available | $ 718,300 | |
Less: Cash Disbursements | ||
Payments to Suppliers for Inventory | $ 287,300 | |
Selling and Administration Expenses | $ 388,500 | |
New Web Server | $ 86,500 | |
Dividend Paid | $ 10,500 | |
Total Cash Disbursments | $ 772,800 | |
Excess (Deficency) of cash available over disbursement | ($54,500) | |
Financing ; | ||
Borrowings | $ 74,500 | |
Repayments | ||
Interest | ||
Total Financing | $ 74,500 | |
Ending Cash Balance | $ 20,000 |
Problem 8-21 Schedules of Expected Cash Collections and Disbursements (L08-2, LO8-4, LO8-8) You have been asked...
Problem 8-21 Schedules of Expected Cash Collections and Disbursements [LO8-2, LO8-4, LO8-8] You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $50,800. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 77,800 $ 83,400 $ 99,800 $ 475,000 $...
Problem 8-21 Schedules of Expected Cash Collections and Disbursements [LO8-2, LO8-4, LO8-8] You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $53,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 27.000 $ 81,200 $ 87,800 $ 435,000 $538,000...
Thanks for the help! Problem 8-21 Schedules of Expected Cash Collections and Disbursements (LOB-2, L08-4LO8-8] You have been asked to prepare a December cash budoet for Ashton Company, a distributor of exercise equipment. The following Information is available about the company's operations The cash balance on December 547500 b. Actual sales for October and November and expected sales for December are as follows: Otober Novexter Dec 3 , 00 3, 00 $ 405.000 615,000 $628000 Sales on account are collected...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $41,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 Sales on account are collected over a three-month period...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 73,200 $ 485,000 November December $ 78,000 $ 92,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $58,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 73,200 $ 78,000 $ 92,000 $ 485,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period...
Required information Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet (LO8-2, LO8-4, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $51,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 71, 600 S 80,200 $ BB, 600 $ 120,000 $$80,000 $ 652,000 Sales on account are collected over a three-month...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $41,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 68,400 $ 87,400 $ 95, 800 $ 415,000 $ 614,000 $ 692,000 Sales on account are collected over a three-month...
Required information Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet (LO8-2, LO8-4, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity...