You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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,800. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $77,800 $83,400 $ 99,800 475,000 558,000 622,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 $375,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 $206,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $448,000 for December. Of this amount, $97,200 is for depreciation. e. A new web server for the Marketing Department costing $80,000 will be purchased for cash during December, and dividends totaling $14,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. Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections 2. Prepare a schedule of expected cash disbursements for merchandise purchases for December. Schedule of Expected Cash Disbursements Payments to suppliers: November purchases December purchases Total cash payments 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. Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Ashton Company Cash Budget For the Month of December Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance 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,800. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $77,800 $83,400 $ 99,800 475,000 558,000 622,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 $375,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 $206,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $448,000 for December. Of this amount, $97,200 is for depreciation. e. A new web server for the Marketing Department costing $80,000 will be purchased for cash during December, and dividends totaling $14,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. Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections 2. Prepare a schedule of expected cash disbursements for merchandise purchases for December. Schedule of Expected Cash Disbursements Payments to suppliers: November purchases December purchases Total cash payments 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. Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Ashton Company Cash Budget For the Month of December Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance
Expert Answer:
Answer rating: 100% (QA)
Calculation in Excel 4 0 Schedule of Cash Collection... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these accounting questions
-
On November 1 2017 the account balances of Hamm Equipment Repair were as follows No Debits No Credits 101 Cash 2430 154 Accumulated DepreciationEquipment 2180 112 Accounts Receivable 4230 201...
-
On December 1 Martin Company signed a $7500, 3 months, 7% note payable with the principle plus interest due on March 1 of the following year. What amount of interest expense is accrued at December 31...
-
You are evaluating a project to produce a new mix of juices which enhances the flavor of your existing product. Which of the following expenditures should be included as an incremental (unlevered)...
-
What is the future value of the following cash flows, given an appropriate discount rate of 7.74% (to the nearest penny)? Year 1 Year 2 Year 3 Year 4 Year 5 $2,005 $4,054 $6,159 $8,532 $11,985
-
Show that for k = 2 the likelihood ratio statistic of Exercise 12.25 can be expressed in terms of the ratio of the two sample variances and that the likelihood ratio test can, therefore, be based on...
-
Mitch is converting his personal use computer to 100% business use for use in his public accounting practice. The computer originally cost \($1,500\) and it is now worth \($700.\) What is Mitchs gain...
-
The numbers of false fire alarms were counted each month at a number of sites. The results are given in the following table. Test the hypothesis that false alarms are equally likely to occur in any...
-
Therapy Inc. experienced the following events in 2014, its first year of operation: 1. Performed counseling services for $ 18,000 cash. 2. On February 1, 2014, paid $ 12,000 cash to rent office space...
-
Please respond to all questions related to Fixed Assets. 1. Is it necessary for a business to use the same method of computing depreciation: (a) for all classes of its depreciable assets, (b) for...
-
Stryker Corporation is a leading medical technology company headquartered in Kalamazoo, Michigan, that trades on the New York Stock Exchange. Following are selected financial data for Stryker for the...
-
Wimpy earns $200 per month and consumes 60 Hardees hamburgers each month. He pays $2 for each hamburger. Hardees is considering implementing a frequent-eaters program whereby a monthly charge of $30...
-
Write out each of the following sums and compute where possible. a. \(\sum_{i=1}^{3}\left(a-b x_{i} ight)\) b. \(\sum_{t=1}^{4} t^{2}\) c. \(\sum_{x=0}^{2}\left(2 x^{2}+3 x+1 ight)\) d....
-
Estimate and interpret multiple regression models with polynomial and interaction variables.
-
Obtain restricted least squares estimates that include nonsample information in the estimation procedure.
-
Explain the difference between finite and large sample properties of an estimator.
-
Explain what is meant by (a) an omitted variable and (b) an irrelevant variable. Explain the consequences of omitted and irrelevant variables for the properties of the least squares estimator.
-
Walter and Jesse dissolve their partnership, but Walter wants to continue to the company on his own as a sole proprietor. Which statement is false? Walter and Jesse dissolve their partnership, but...
-
For the vector whose polar components are (Vr = 1, Vθ = 0), compute in polars all components of the second covariant derivative Vα;μ;ν. To find...
-
Multiple-Choice Questions 1. If beginning inventory is $40,000, purchases is $215,000, and ending inventory is $35,000, what is cost of goods sold as determined by the cost of goods sold model? a....
-
Thornwood Partners began business on January 1, 2011. The corporate charter authorized issuance of 75,000 shares of $1 par value common stock, and 8,000 shares of $3 par value, 10 percent cumulative...
-
JDM Inc. made the following prepayments for expense items during 2011: a. Prepaid building rent for one year on April 1 by paying $6,600. Prepaid rent was debited for the amount paid. b. Prepaid...
-
Determine the maximum eccentric load \(P\) the 2014-T6aluminum-alloy strut can support without causing it either to buckle or yield. The ends of the strut are pin connected. a $150 mm 150 mm 100 mm...
-
The W14 \(\times 26\) structural A-36 steel member is used as a column that is assumed to be fixed at its top and pinned at its bottom. If the 15-kip load is applied at an eccentric distance of 10...
-
The W14 \(\times 26\) structural A-36 steel member is used as a 20 -ft-long column that is assumed to be fixed at its top and fixed at its bottom. If the 15-kip load is applied at an eccentric...
Study smarter with the SolutionInn App