1) Calculation of Total cash collections for December
December cash sales | $88600 |
December credit sales to be collected (652000*20%) | 130400 |
November credit sales to be collected (580000*60%) | 348000 |
October credit sales to be collected (420000*18%) | 75600 |
Total cash collections | $642600 |
2) Calculation of Cash disbursements for merchandise purchase
December purchases (287000*30%) | $86100 |
November purchases | 160000 |
Cash disbursements for merchandise purchase | $246100 |
3)
Ashton Company | ||
Cash Budget | ||
For the Month of December | ||
Beginning cash balance | $51400 | |
Add: Collections from customers | 642600 | |
Total cash available | 694000 | |
Less: Cash disbursements: | ||
Payments to suppliers for inventory | 246100 | |
Selling and administrative expenses (501000-92300) | 408700 | |
New web server | 113500 | |
Dividend paid | 10000 | |
Total cash disbursements | (778300) | |
Excess (deficiency) of cash available over disbursements | $(84300) | |
Financing: | ||
Borrowings | 104300 | |
Repayment | - | |
Interest | - | |
Total financing | 104300 | |
Ending cash balance | $20000 |
Borrowings= Excess (deficiency) of cash available over disbursements+Ending cash balance
= $84300+20000= $104300
You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
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...
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 $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...
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: The cash balance on December 1 is $41,000. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 68,400 $ 87,400 $ 95,800 Sales on account $ 415,000 $ 614,000 $ 692,000 Sales on account are collected over a three-month period as follows:...
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 $40,000, b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 65,000 $ 400,000 November $ 70,000 5 525,eee December $ 83,000 $ 600,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 $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...
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: points a. The cash balance on December 1 is $56,600. b. Actual sales for October and November and expected sales for December are as follows: eBook Cash sales Sales on account October November December $ 71,200 $ 73,400 $ 86,200 $ 440,000 $ 576,000 $ 639,000 Print Sales on account are collected over...
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 $ 77,000 $ 81,200 $ 87,800 $435,000 $538,000 $644,800 Sales on account are collected over a three-month period as follows: 20%...
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,200. b. Actual sales for October and November and expected sales for December are shown below. 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...