Reference no: EM131267754
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:
October November December Cash sales $ 73,200 $ 78,000 $ 92,000
Sales on account 485,000 568,000 663,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 $316,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 $162,000, all of which will be paid in December.
d. Selling and administrative expenses are budgeted at $514,000 for December. Of this amount, $52,000 is for depreciation.
e. A new web server for the Marketing Department costing $117,500 will be purchased for cash during December, and dividends totaling $12,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.
Calculate the amount of the bank service charge
: The cash account in the general ledger of XYZ Company shows a balance of $18,700 at June 30, 2004. Error in recording check #6301 from a customer. The check was received from a customer who was paying for services performed by XYZ Company. Calculate ..
|
Compute a schedule of operating cash flows
: BioCom, Inc. is weighing a proposal to manufacture and market a fiber-optic device that will continuously monitor blood pressure during cardiovascular surgery and other medical procedures in which precise, real-time measurements are critical. Compute..
|
Estimated factory overhead costs-direct labor hours
: Almer Company operates two factories. The company applies factory overhead to jobs on the basis of machine hours in Factory 1 and on the basis of direct labor hours in Factory 2. Estimated factory overhead costs, direct labor hours, and machine hours..
|
Compute their free cash flow
: Company A wants you to compute their free cash flow. They provide you with the following information: cash dividends $100, stock dividends 100 shares, sales of plant assets $50, cash flows from investing activities $475, purchase of plant assets $175..
|
Prepare schedule of expected cash disbursements
: 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: Prepare a schedule of expected cash collections for December. Prepar..
|
Prepare in general journal form the entries required
: Annabelle Benton, great-granddaughter of the founder of the Town of Benton, made a cash contribution in the amount of $500,000 to be held as an endowment. To account for this endowment, the town has created the Alex Benton Park Endowment Fund. Prepar..
|
Statement of revenues-expenditures-changes in fund balance
: Annabelle Benton, great-granddaughter of the founder of the Town of Benton, made a cash contribution in the amount of $500,000 to be held as an endowment. To account for this endowment, the town has created the Alex Benton Park Endowment Fund. A bala..
|
In practice a market portfolio is often represented by
: In practice a market portfolio is often represented by:
|
Difference between the present value and future value
: The only difference between the present value and future value of a lump sum is the amount of interest that is earned in the intervening time span.
|