Answer 1
Calculation of Cash Collection | |
December Cash Sales | $ 88,200 |
Collections On Account | |
October Sales = 410000*18% | $ 73,800 |
November Sales = 574000*60% | $ 344,400 |
December Sales = 609000*20% | $ 121,800 |
Total Cash Collections | $ 628,200 |
Answer 2
Calculation of Total Cash Disbursements | |
Payments to suppliers | |
November Purchases | $ 95,400 |
December Purchases | $ 172,000 |
Total Cash Payments | $ 267,400 |
Answer 3
Ashton Company | ||
Cash Budget | ||
For the Month of December | ||
Beginning cash balance | 53200 | |
Add collections from customers | $ 628,200 | |
Total cash available | $ 681,400 | |
Less cash disbursements: | ||
Payments to suppliers for inventory | $ 267,400 | |
Selling and administrative expenses | 467300 | |
New web server | 82000 | |
Dividends paid | 12000 | |
Total cash disbursements | $ 828,700 | $ 828,700 |
Excess (deficiency) of cash available over disbursements | $(147,300) | |
Financing: | ||
Borrowings | 167300 | |
Repayments | 0 | |
Interest | 0 | |
Total financing | 167300 | |
Ending cash balance | $ 20,000 |
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 will be $39,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 65,000 397,000 November $ 65,000 522,000 December $ 82,600 598,000 Sales on account are collected over a three-month period in the...
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 $56,600. 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...
value 10.00 points 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 November December $ 65,000 $ 70,000 $ 83,000 400,000 525,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 $43,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...
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: 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: 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 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 $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...