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 $58,600.
Actual sales for October and November and expected sales for December are as follows:
|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.
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.
Selling and administrative expenses are budgeted at $514,000 for December. Of this amount, $52,000 is for depreciation.
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.
The company maintains a minimum cash balance of $20,000. An open line of credit is available from the companyâs bank to increase its cash balance as needed.
1. Calculate the expected cash collections for December.
2. Calculate the 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.
How would you prepare 1600 mL of a pH = 1.50 solution using 12 M HCl?Jul 30 2021
Procter and Gamble (PG) paid an annual dividend of $1.72 in 2009. You expect PG to increase its dividends by 8% per year for the next five years (through 2014), and there...Jun 07 2021
Arrange the following in order of increasing boiling point? Explain your reasoning?RbF, CO2, CH3OH, CH3BrMay 24 2021
You have observed the following returns on Konyv stocks over the past 6 years: 8%, -2%, 12%, 3%, 4% and 3%. What is the arithmetic rate of return on the stock? What is th...Aug 24 2020
Use a production possibilities frontier to describe the idea of "efficiency."Here is a tip:When resources are left unused, then an economy is not working with its full potential.Jul 11 2021
1. Calculate the cold feed rate in tons per hour (tons/h) for a drum-mix asphalt plant under the following conditionsAsphalt content = 6%Aggregate composition:Coarse A = ...Jul 22 2020
The 2015 financial statements for Growth Industries are presented below. Sales and costs in 2016 are projected to be 20% higher than in 2015. Both current assets and acco...Mar 29 2020
Find the Equation for the pressure drop in a U-Tube manometer?Jun 08 2020
Prove that if Xn convergence b in probability and Yn convergence c in probability and g x y is a function that is continuous at x y b c then g Xn Yn convergence g in probabilityMar 17 2020
When a firm exports, it need not bear the costs associated with FDI, and it can reduce the risks associated with selling abroad by using a native sales agent. Exporting, ...Jan 11 2020