Reference no: EM131292059
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,600.
b. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 74,400 $ 86,000 $ 85,000 Sales on account 515,000 533,000 672,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.
c. Purchases of inventory will total $317,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 $190,000, all of which will be paid in December.
d. Selling and administrative expenses are budgeted at $526,000 for December. Of this amount, $58,600 is for depreciation.
e. A new web server for the Marketing Department costing $78,000 will be purchased for cash during December, and dividends totaling $15,500 will be paid during the month.
f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company’s bank to bolster the cash position as needed. Required:
1. Prepare a schedule of expected cash collections for December. 2. Prepare a schedule of expected cash disbursements for merchandise purchases for December. 3. 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.
|
What is the original cost of asset
: Company sold office equipment for cash of $142,000. The accumulated depreciation at date of sale amounted to $138,000, and a gain of $18,000 was recognized on the sale. what is the original cost of asset.
|
|
Determined that their tax liability on their joint return
: Doug and Lisa have determined that their tax liability on their joint return is $5,400. They have made prepayments of $1,300 and also are entitled to child tax credits of $2,630. What is the amount of their tax refund or taxes due?
|
|
What is brittanys taxable income
: In 2015, Brittany, who is single, cares for her father Raymond. Brittany pays the bills relating to Raymond's home. She also buys groceries and provides the rest of his support. Raymond has no gross income. Brittany received $75,000 of salary from he..
|
|
Shares outstanding and the stock currently sells
: After successfully completing your corporate finance class, you feel the next challenge ahead is to serve on the board of directors of Schenkel Enterprises. If Schenkel has 590,000 shares outstanding and the stock currently sells for $29, how much wi..
|
|
Schedules of expected cash collections and disbursements
: 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. Prepare a schedule of expected cash collections for December..
|
|
How not-for-profit can stay strong amid uncertainty
: Write an article on the topic "How Not-For-Profit Can Stay Strong Amid Uncertainty" derived from www.journalofaccountancy.com . Please state all the codes, regulations associated with this topic. Your topic should be 1000 words and should be APA form..
|
|
Calculate the ratios with and without the bond issue
: Your company's summarized financial information for the beginning and projected end of the current year is as follows: Beginning of the Year End of the Year (projected) Assets $90,000 $100,000. Calculate the following ratios with and without the bond..
|
|
Determine range of operating volume that will make option
: Sandstone Corporation has one of its manufacturing plants operating on a single shift five-day week. The plant is operation at its full capacity (24,000 units of output per week) without the use of overtime or extra shifts. Fixed costs for single-shi..
|
|
Wholesale distributor of premium european chocolates
: Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below: The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budget..
|