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 $40,000. b. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $65,000 $70,000 $83,000 Sales on account $400,000 $525,000 $600,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 $280,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 $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,000 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 increase its cash balance as needed. Required: 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. 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 $40,000. b. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $65,000 $70,000 $83,000 Sales on account $400,000 $525,000 $600,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 $280,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 $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,000 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 increase its cash balance as needed. Required: 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.
Expert Answer:
Related Book For
Elementary Linear Algebra with Applications
ISBN: 978-0471669593
9th edition
Authors: Howard Anton, Chris Rorres
Posted Date:
Students also viewed these accounting questions
-
Entry for Jobs Completed; Cost of Unfinished Jobs The following account appears in the ledger prior to recognizing the jobs completed in August: Work in Process $9,100 73,980 79,810 41,950 Balance,...
-
Homework In a location of highway construction project, where the (cross and longitudinal ) sections of the earthworks profile in that location are as shown in the given figure. Estimate the totally...
-
Homework of Earthworks In a location of highway construction project , where the ( cross and longitudinal ) sections of the earthworks profile in that location are as shown in the given figure....
-
Graph each inequality or compound inequality. 5x - y > 6
-
On March 10, 2006, Nortel Networks Corp. announced that it would delay filing its 2005 financial reports with the SEC. The delay arose because Nortel and its auditors decided that certain revenue...
-
Refer to the table given for Exercise 5.19. a. If a person is chosen randomly, what is the probability that the person is female? b. If a person is chosen randomly, what is the probability that the...
-
For a sample of size 18, the following values were obtained: b0 = 2.27, b1 = 1.46, se = 5.72, (x x)2 = 360.26, and x = 1.95. a. Construct a 99% confidence interval for the mean response when x = 2....
-
On January 8, the end of the first weekly pay period of the year, Royal Companys payroll register showed that its employees earned $11,380 of office salaries and $32,920 of sales salaries....
-
In the following questions, consider the function f(x) = 2sin(x)+7 cos(x) on (-, ). Enter DNE if an answer does not exist. a) Give the domain of f (in interval notation): (-,) help (intervals) b)...
-
Assume the Black-Scholes framework. You are given: (i) The current dollar/euro exchange rate is 1.2. (ii) The continuously compounded risk-free interest rate in the United States is 2%. (iii) The...
-
In 2020, Kanyiti ltd started a sporting equipment business with GHC7000 from personal savings which he lodged into a bank account for the business. The following transactions took place during the...
-
In respect of Enrons SPEs Chewco and Jedi, the Powers Report identified three sources of fictitious income streams: a ______________ fee, management fees, and revenue recognized on Enrons own stock.
-
The birth of the weather derivative grew out of Enrons attention to fundamental weather information for its gas trading. True/False
-
Securitization refers to the pooling of loans and the trading of portions of these loans on securities markets in the form of collateralized debt obligations. True/False
-
Explain how Enron used the Prepay Transactions to overstate CFFO.
-
In order to finance Chewco as an SPE that did not have to become consolidated into Enrons consolidated financial statements, it had to have a minimum of 3 percent of its equity ______________...
-
The demand for beer for heavy drinkers is given by the following demand function: Qd=190-3P. The demand for beer for light drinkers is given by the following demand function Qd=60-4P. Suppose the...
-
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...
-
Use Theorem 5.2.1 to determine which of the following are subspaces of Mnn. (a) All n x n matrices A such that AT = -A (b) All n x n matrices A such that the linear system Ax = 0 has only the trivial...
-
Find conditions that the b's must satisfy for the system to be consistent. x1 - 2x2 + 5x3 = b1 4x1 - 5x2 + 8x3 = b2 - 3x1 + 3x2 - 3x3 = b3
-
For which values of a will the following system have no solutions? Exactly one solution? Infinitely many solutions? x + 2y - 3z = 4 3x - y + 5z = 2 4x + y + (a2 - 14)z = a + 2
-
Since the management of a company is responsible for its financial statements and the auditor is responsible only for the report, management may choose the form of presentation and the degree of...
-
For each one of the following statements indicate whether the statement is true or false. a. Use of a computer for significant accounting applications does not in any way change specific audit...
-
The following questions relate to the use of computer-assisted audit techniques. Select the best response. a. Which of the following is true of generalized audit software packages? 1. They can be...
30 Ideas You Can Earn An Income With In Less Than 30 Days 1st Edition - ISBN: B0CWDZWHCX - Free Book
Study smarter with the SolutionInn App