Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation $ 68,800 34, 000 64, 600 122,000 $ 289,400 Total assets Liabilities and Stockholders Equity Accounts payable Connon stock Retained earnings $ 96, 500 70, 000 122,900 $ 289,400 Total liabilities and stockholders' equity Budgeted Incone Statements April $ 182,000 109, 200 72,800 18, 800 $ 54,000 May $ 192,000 115, 200 76,800 20, 300 $ 56,500 June $ 212,000 127, 200 84, 800 23, 300 $ 61,500 Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating incone Budgeting Assumptions: a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale and the remalning 80% are collected in the month subsequent to the sale. b. Budgeted sales for July are $222,000. c. 10% of merchandise Inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit purchases. All purchases on credit are pald in the month subsequent to the purchase. The accounts payable at March 31 will be paid in April. d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold. e. Depreclation expense is $1,300 per month. All other selling and administrative expenses are pald in full in the month the expense is Incurred. Required: 1. Calculate the expected cash collections for April, May, and June. 2. Calculate the budgeted merchandise purchases for April, May, and June. 3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June. 4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash pald for selling and administrative expenses during April, May, and June to determine the cash balance in your June 30th balance sheet.) Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation $ 68,800 34, 000 64, 600 122,000 $ 289,400 Total assets Liabilities and Stockholders Equity Accounts payable Connon stock Retained earnings $ 96, 500 70, 000 122,900 $ 289,400 Total liabilities and stockholders' equity Budgeted Incone Statements April $ 182,000 109, 200 72,800 18, 800 $ 54,000 May $ 192,000 115, 200 76,800 20, 300 $ 56,500 June $ 212,000 127, 200 84, 800 23, 300 $ 61,500 Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating incone Budgeting Assumptions: a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale and the remalning 80% are collected in the month subsequent to the sale. b. Budgeted sales for July are $222,000. c. 10% of merchandise Inventory purchases are paid in cash at the time of the purchase. The remaining 90% of purchases are credit purchases. All purchases on credit are pald in the month subsequent to the purchase. The accounts payable at March 31 will be paid in April. d. Each month's ending merchandise inventory should equal $10,000 plus 50% of the next month's cost of goods sold. e. Depreclation expense is $1,300 per month. All other selling and administrative expenses are pald in full in the month the expense is Incurred. Required: 1. Calculate the expected cash collections for April, May, and June. 2. Calculate the budgeted merchandise purchases for April, May, and June. 3. Calculate the expected cash disbursements for merchandise purchases for April, May, and June. 4. Prepare a budgeted balance sheet at June 30th. (Hint: You need to calculate the cash pald for selling and administrative expenses during April, May, and June to determine the cash balance in your June 30th balance sheet.)
Expert Answer:
Answer rating: 100% (QA)
1 Budgeted cash collections for April May June Budgeted cash collection Apr May June Credit sales 40 ... View the full answer
Related Book For
Financial accounting
ISBN: 978-0132751124
9th edition
Authors: Walter T. Harrison Jr., Charles T. Horngren, C. William Thom
Posted Date:
Students also viewed these accounting questions
-
Choose an A matrix (with all non-zero elements) with n = 2 states and rank(A) = 2. (a) [+1, 5 min] Find a B matrix such that the system is controllable. (b) [+1, 5 min] Find a suitable Q and R matrix...
-
Compare the number of new businesses per 10,000 residents between Professional and Agriculture SA3s (both in 2011). The p-value (2 decimal places) obtained after performing a one-tailed t-test for...
-
Accounts Payable Accounts Receivable Cash Inventory and Sales Revenue are not involved in the Other Accounts column in either the cash receipts or cash payments journal and are not involved in any...
-
Python Question needed solving is at bottom #Function implementing the Extended Euclidean Algorithm import mathdef egcd(a,b): # b must not be zero otherwise the concept of gcd will fail #base case if...
-
Identify and describe the two stages of cost allocation in an activity-based costing system.
-
(a) Express dw/dt as a function of t, both by using the Chain Rule and by expressing w in terms of t and differentiating directly with respect to t. Then (b) Evaluate dw/dt at the given value of t. W...
-
In a single stage steam turbine saturated steam at 10 bar is supplied through a convergent divergent steam nozzle of \(20^{\circ}\) angle. The mean blade speed is \(400 \mathrm{~m} / \mathrm{s}\)....
-
An investment with initial value zero can go up or down $10,000 per month with equal likelihood. (a) What is probability that the investment will reach $1,000,000 without reaching $250,000? (b) What...
-
In the context of Orica Ltd's operations in 2022, drawing from the insight that 'Managers regard relevance, accuracy, and timeliness as important characteristics of information. However, much of...
-
Hotel Baroneii International is an international hospitality group that is present in more than 100 countries with 12 brands and 5000 plus properties. The group also has a strong loyalty membership...
-
Suppose that the shadow price for assembly time is $5 per hour. The allowable increase for the assembly time constraint is 40 hours, and the allowable decrease is 30 hours. If all assembly hours were...
-
You are being interviewed for a sales position with a national electronics retailer. The job is very important to you as it will help pay your living expenses while you complete your studies. During...
-
Several weeks ago, Joy Hong fell in love with the Scion tC coupe. After reading about the car in a magazine, she decided to visit a local Scion dealer. A test drive convinced her to place an order....
-
Select a large firm with which you are at least somewhat familiar. Utilize the search engines at www.findarticles.com, and identify some of the important social and technological influences on the...
-
Suppose you own a retail business and are considering whether to allow your customers to have quantity discounts, sales discounts and sales allowances. Required: How do you think quantity discounts,...
-
Sanjay and Sophia looked out over the factory floor in dismay. They both worked in human resources management, and just a week ago they had delivered some safety training in an attempt to reduce...
-
10. List the department ID, department name, count of sales reps, and average commission rate for each department. Group by department, and sort by average commission rate in ascending order. Show...
-
Choose a company from the SEC EDGAR Web site for your Key Assignment to evaluate for the impact of convergence to IFRS. Review the financial reports and notes of the company you have chosen from the...
-
Companies that operate in different industries may have very different financial ratio values. These differences may grow even wider when we compare companies located in different countries. Compare...
-
Carter-Pierce Investments specializes in low-risk government bonds. Identify each of Carter-Pierces transactions as operating (O), investing (I), financing (F), non-cash investing and financing...
-
Footnote 10 of Abercrombie and Fitch Co.s financial statements for fiscal year 2010 (January 29, 2011) contains the following information: At January 29, 2011, the Company was committed to...
-
Sample size = 81, sample mean = 4.5 km, sample standard deviation = 3.1 km Assume that population means are to be estimated from the samples described. In each case, use the sample results to...
-
n = 100, x = 8.0 ft, s = 2.0 ft Assume that population means are to be estimated from the samples described. In each case, use the sample results to approximate the margin of error and 95% confidence...
-
Margin of error = \($5\), standard deviation = \($20\)
Study smarter with the SolutionInn App