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
-
Complete a deposit slip (Figure 4 - 44) to deposit checks in the amounts of $136.00 and $278.96, and $480 cash on May 8, 20XX. Figure 4 - 44 DEPOSIT TICKET CURRENCY CASHCOIN S & R Consulting Co. PO...
-
Joanna Browne is considering either leasing or purchasing a new Chrysler Sebring convertible that has a manufacturers suggested retail price (MSRP) of $33,000. The dealership offers a 3-year lease...
-
Refer to Googles financial statements in Appendix A to compute its equity ratio as of December 31, 2015, and December 31, 2014. Data From Google Financial Statement Appendix A Google Inc....
-
Takemoto Corporation borrowed $60,000 on November 1, 2010, by signing a $61,350, 3-month, zero-interest-bearing note. Prepare Takemotos November 1, 2010, entry; the December 31, 2010, annual...
-
Under the independent investor test, all the other factors are examined from the perspective of an independent investor. This requires an analysis of the return on equity (ROE) of the...
-
Forced conduction heat transfer from a flat plate (thermal boundary layer extends beyond the momentum boundary layer), show that the result analogous to Eq. 12.4-14 for > 1 is 2 3 1 37 1 315 Pr 140...
-
Compare and contrast the functions of management accounting and financial accounting in the context of organisational decision - making and financial reporting and discuss how the two affect the...
-
Can you elaborate on the concepts of lock-free and wait-free algorithms in concurrent programming, and how they enable high-performance and scalable solutions by minimizing contention and eliminating...
-
Can you analyze the impact of multi-core and many-core architectures on thread-level parallelism and concurrency management strategies, and how developers can leverage hardware advancements to...
-
Assume a stock with a volatility of 0.5 sells at $50. The risk-free rate is 6% per annum and volatility is 0.2. What is the price of a European call with a $50 strike and time to expiration 3 months?
-
On an air table, a 170g puck moving to the right with a speed of 1.8m/s, collides with a 290g puck initially at rest. If after collision the 170g puck is moving with a speed of 0.65m/s to the left,...
-
Examine the principles of functional programming paradigms in the context of building reactive systems and event-driven architectures, discussing the use of concepts like pure functions,...
-
Suppose you plan to buy a house. The price of the house is $80,000. You have $10,000 for the down payment and plan to borrow $70,000 plus enough to pay for the points and closing costs. First...
-
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...
-
What might be problematic about these responses to interview questions? How might the answers be improved? a. Q: Tell me about yourself. A: Im really easy-going and casual. b. Q: I noticed that you...
-
Revise the follow-up message below to be more professional and effective, based on the principles in this chapter. December 2, 2021 Ms. Charlotte LeClaire Pebble Creek Publishing Inc. New York, NY...
-
Write a follow-up email message or letter after an office visit or plant trip. Thank your hosts for their hospitality; relate your strong points to things you learned about the company during the...
Study smarter with the SolutionInn App