Prepare a Cash Receipts budget for July - October DC's Projected Revenues & Expenses Sales Cost of
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
DC's Projected Revenues & Expenses Sales Cost of Goods Sold Gross Profit Admin & Selling Costs Net Income before Taxes June 85,000 52,700 32,300 21,000 11,300 July 86,275 53,491 32,785 21,000 11,785 August 87,569 54,293 33,276 21,000 12,276 Other Information: DC's operates on a calendar year basis Credit Sales from Events and Catering are 20% per month Collections are 60% in the month of sale and 40% in the following month Admin & Selling includes $1,000 depreciation expense Prime (direct) wages are 30% of Sales Admin & Sales salaries are $4,350 per month Wages are paid 80% in current month and 20% the following month Purchases of Direct Materials, which are 32% of Sales, are paid 50% in current month and 50% in following month Loan payment of $1,600 is made at the 1st of each month A dividend to the owners of 10% of the ending quarter's Net Income is paid in Jan, Apr, Jul, Oct April - June Net Income before taxes was $50,000 September 88,883 55,107 33,775 21,000 12,775 October November 91,569 56,773 34,796 21,000 13,796 Ending Inventory needs to be 30% of the following month's Direct Materials Cost of Goods Sold Accounts payable for purchases June 30 was $13,600 Beginning Cash Balance June 30 was $175,000 Effective tax rate is 23%. Quarterly estimated taxes are paid the month following the end of the quarter 90,216 55,934 34,282 21,000 13,282 DC's Projected Revenues & Expenses Sales Cost of Goods Sold Gross Profit Admin & Selling Costs Net Income before Taxes June 85,000 52,700 32,300 21,000 11,300 July 86,275 53,491 32,785 21,000 11,785 August 87,569 54,293 33,276 21,000 12,276 Other Information: DC's operates on a calendar year basis Credit Sales from Events and Catering are 20% per month Collections are 60% in the month of sale and 40% in the following month Admin & Selling includes $1,000 depreciation expense Prime (direct) wages are 30% of Sales Admin & Sales salaries are $4,350 per month Wages are paid 80% in current month and 20% the following month Purchases of Direct Materials, which are 32% of Sales, are paid 50% in current month and 50% in following month Loan payment of $1,600 is made at the 1st of each month A dividend to the owners of 10% of the ending quarter's Net Income is paid in Jan, Apr, Jul, Oct April - June Net Income before taxes was $50,000 September 88,883 55,107 33,775 21,000 12,775 October November 91,569 56,773 34,796 21,000 13,796 Ending Inventory needs to be 30% of the following month's Direct Materials Cost of Goods Sold Accounts payable for purchases June 30 was $13,600 Beginning Cash Balance June 30 was $175,000 Effective tax rate is 23%. Quarterly estimated taxes are paid the month following the end of the quarter 90,216 55,934 34,282 21,000 13,282
Expert Answer:
Related Book For
Advanced Financial Accounting
ISBN: 978-0132928939
7th edition
Authors: Thomas H. Beechy, V. Umashanker Trivedi, Kenneth E. MacAulay
Posted Date:
Students also viewed these accounting questions
-
Prepare a Cash Budget for the months of July and August 2017 Assume any interest will be paid at the end of the month that follows the month when the money was borrowed Also assume that any surplus...
-
Cash receipts budget. Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July . . . . . . . . . . . . . . . . ....
-
Prepare headings for a cash receipts journal like the one in Exhibit 7A.2. Journalize the November transactions shown in Exercise 7-4 that should be recorded in the cash receipts journal assuming...
-
Simplify each expression in Problems 722. Classify each answer by number of terms and degree. (x + 2y3z) - (x - 5y + 4z)
-
How will you advertise your restaurant? What percentage of total sales will be allocated to advertising?
-
An old-fashioned single-play vinyl record rotates on a turntable at 45 rpm. What are (a) The angular velocity in rad/s and (b) The period of the motion?
-
The adjusted trial balance for CED Electric, Inc., as of June 30, 2010, is presented next: Requirements 1. Prepare the multi-step income statement for June for CED Electric, Inc. 2. Calculate the...
-
Apocalyptica Corp. pays a constant $8.50 dividend on its stock. The company will maintain this dividend for the next 11 years and will then cease paying dividends forever. If the required return on...
-
Suppose that f(x) = (4-5x)5. Find f'(x). f'(x) =
-
Atlantic Airlines issued $100 million in bonds in 2008. Because of the firm's low credit rating (B3), the bonds were considered to be junk bonds. At the time of issue, the 20 year bonds were paying a...
-
AOC is a right angle and the ration ofAOB:BOC=2:3. What is the measure ifBOC?
-
For years, AT&T had been flirting with the idea of acquiring satellite pay TV company DirecTV. But such a deal would have resulted in increased market concentration that may have precluded getting...
-
What is the definition of ignorable treatment assignment? a. Give an example of a study where the treatment assignment is ignorable. b. Give an example of a study where the treatment assignment is...
-
Ashland Chemical, the largest US chemical distributor, acquired chemical manufacturer Hercules Inc. for \($3.3\) billion. This move followed Dow Chemical Companys purchase of Rohm & Haas. The...
-
After having acquired the OfficeMax superstore chain, Boise Cascade announced the sale of its paper and timber products operations to reduce its dependence on this cyclical business. Reflecting its...
-
A study has three experimental units and two treatments-A and B. List all possible treatment assignments for the study. How many are there? In general, show that there are $2^{N}$ possible treatment...
-
Using Euler's formula tme(o+jw)t = tmet cos(wt) + jtmeotsin (wt). . The real and imaginary parts of this expression
-
If a process has a six-sigma capability, what is the process capability index? a. 1 b. 2 c. 6 d. 12
-
Corporation S has 100,000 shares of common stock and 100,000 shares of non-voting preferred stock outstanding. Corporation P owns 60,000 of Ss common shares and 45,000 of Ss preferred shares. When P...
-
On January 1, 20X5, Purple Inc. purchased 80% of the common shares of Yellow Corp. for $1,200,000. On the date of acquisition, Yellows shareholders equity was as follows: Preferred shares: 8%...
-
Why is the equity method of reporting sometimes called the consolidation method of equity reporting?
-
Assume Knowlton Holdings Ltd. completed these long-term non-strategic investment transactions during 2020 : 1. Journalize Knowlton's investment transactions assuming the company reports any changes...
-
Suppose on February 1, 2020, General Motors paid \(\$ 41\) million for a \(40 \%\) investment in ABC Ltd., an auto parts manufacturer. Assume \(A B C\) earned net income of \(\$ 6\) million and paid...
-
Return to exercise SB-7, the Prudential Bache (PB) investment in CitiCorp bonds. Journalize the following on PB's books: a. Purchase of the bond investment on January 2, 2020. PB expects to hold the...
Study smarter with the SolutionInn App