Question 4: A more involved cash flow budget Goats-R-Us, Inc. has budgeted sales revenues as follows:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 4: A more involved cash flow budget Goats-R-Us, Inc. has budgeted sales revenues as follows: Credit sales Cash sales Total sales June July August $135,000 $125,000 $ 90,000 90,000 255,000 195,000 $225.000 $380,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on account with 50% paid in the month of purchase and 50% paid in the month following purchase. Budgeted inventory purchases are as follows: June July August $300,000 240,000 105,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $48,000 each month, (b) dividends of $103,000 will be paid in July, and (c) purchase of equipment in August for $30,000 cash. The company's policy is to maintain a minimum cash balance of $50,000 at the end of each month. The company borrows money from the bank at 6% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $50,000. Assume that borrowed money in this case is for one month. Instructions 1. Prepare a Schedule of Expected Collections from Customers (1.5%) 2. Prepare a Schedule of Expected Payments for Purchases of Inventory (1.5%) 3. Prepare a cash budget for the months of July and August (4%) Question 4: A more involved cash flow budget Goats-R-Us, Inc. has budgeted sales revenues as follows: Credit sales Cash sales Total sales June July August $135,000 $125,000 $ 90,000 90,000 255,000 195,000 $225.000 $380,000 $285,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on account with 50% paid in the month of purchase and 50% paid in the month following purchase. Budgeted inventory purchases are as follows: June July August $300,000 240,000 105,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $48,000 each month, (b) dividends of $103,000 will be paid in July, and (c) purchase of equipment in August for $30,000 cash. The company's policy is to maintain a minimum cash balance of $50,000 at the end of each month. The company borrows money from the bank at 6% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $50,000. Assume that borrowed money in this case is for one month. Instructions 1. Prepare a Schedule of Expected Collections from Customers (1.5%) 2. Prepare a Schedule of Expected Payments for Purchases of Inventory (1.5%) 3. Prepare a cash budget for the months of July and August (4%)
Expert Answer:
Answer rating: 100% (QA)
1 Schedule of Expected Collections from Customers June Credit Sales 135000 60 81000 July Credit Sale... View the full answer
Posted Date:
Students also viewed these accounting questions
-
complete the asset disposal account for the sake of the Kia picanto on 32 May
-
You stated that employee morale, expectations, and the ability to anticipate problems and make informed decisions are all negatively impacted by withholding information, which is nothing more than an...
-
The first compound of the TCA cycle is (a) Oxalo-succinic acid. (b) Oxaloacetic acid. (c) Citric acid. (d) Cis-aconitic acid.
-
What are the Key Success factors in the Daycare industry? explain
-
Company EJ plans to build a new plant to manufacture bicycles. EJ sells its bicycles in the world market for $400 per bike. It could locate the plant in Province P, which levies a 20 percent tax on...
-
Akshay Limited uses the average cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [13] in the following perpetual inventory schedule. (Use unrounded numbers...
-
Which of the following statements is correct? a. A bridge is used to connect a LAN and a WAN. b. Packet switching combines the messages of multiple users into a "packet" for transmission. At the...
-
You can use the computer based Electronic Workpapers on the textbook website to prepare the schedule of interbank transfers required in this problem. EverReady Corporation is in the home building and...
-
Homework: CHAPTER M-8 Question 2, PM8-29B (book/static) Part 1 of 3 HW Score: 0%, 0 of 5 points Points: 0 of 1 Save Members of the board of directors of Security Team have received the following...
-
Eagle and Hank have partner capital balances of $255,000 and $225,000, respectively. Eagle receives 70% of profits and losses, and Hank receives 30%. Assume Potvin contributes $120,000 to acquire a...
-
Community Catering (CC) began as a "meals on wheels" agency, providing dinners to elderly people and individuals who were permanently or temporarily homebound. Almost all of its clients were single...
-
Lopez Company is considering replacing one of its old manufacturing machines. The old machine has a book value of $47,000 and a remaining useful life of five years. It can be sold now for $57,000....
-
The data is about the store that sells wine and other alcohols beverages. 1) What is your recommendation regarding the price for Product No 2114 and the price for Product No 3804. Use the data you...
-
In Figure 1, determine the point (other than infinity) where the electric field is zero. Leave q1 = - 1.80 /C and 92 = 6.80 /C. 91 -1.00 m Figure 1 92
-
The purpose of this assignment is to provide an introduction to Excel's what-if analysis.In cost accounting determining the relationships between cost, volume and profit are very important. This...
-
Nathan Taxpayer Wife Taxpayer 412-34-5670 2b 2c 2d 2e 2f 2g 2h 2i 2j 2k 21 2m 2n 20 2p 29 2r 2s 2t 3 4 0 Part I Alternative Minimum Taxable Income (See instructions for how to complete each line.) 1...
-
Show that the block upper triangular matrix A in Example 5 is invertible if and only if both A 11 and A 22 are invertible. Data from in Example 5 EXAMPLE 5 A matrix of the form A = [ A11 A12 0 A22 is...
-
Ganados Phases. What are the main phases that Ganado passed through as it evolved into a truly global firm? What are the advantages and disadvantages of each?
-
Why Go. Why do firms become multinational?
-
Financial Globalization. Explain the twin agency problems. How do the twin agency problems limit financial globalization?
Study smarter with the SolutionInn App