Wonderland Manufacturing produces a variety of industrial valves. The company is preparing its cash budget for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Wonderland Manufacturing produces a variety of industrial valves. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement 1. Prepare a combined cash budget for Wonderland Manufacturing for the third quarter, with a column for each month and for the quarter total. www g www-- Wonderland Manufacturing O More Info Combined Cash Budget For the Months of July through September a. Cash collections from sales in July, August, and September, are projected to be $91,000, S152,000, and $126,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $141,000 in July, $105,000 in August, and $139,000 in September, c. The cash balance as of the first day of the third quarter is projected to be $39,000. d. Wonderland Manufacturing has a policy that they must maintain a minimum cash balance of $24,000. July August September Quarter Beginning balance of cash Cash collections Total cash available The company has a line of credit with the local bank that allows it to borrow funds in months that it would not otherwise have a minimum balance of $24,000. If the company has more than $24,000 at the end of any given month, it uses the excess funds to pay off any outstanding line of credit balance. Each month, Wonderland Manufacturing pays interest on the prior month's line of credit ending balance. The actual interest rate that Wonderland Manufacturing will pay floats since it is tied to the prime rate. However, the interest rate paid during the budget period is expected to be 2% of the prior month's line of credit ending balance (if the company did not have an outstanding balance at the end of the prior month, then Wonderland Manufacturing does not have to pay any interest). All line of credit borrowings are taken or paid off on the first day of the month. As of the first day of the third quarter, Wonderland Manufacturing did not have a balance on its line of credit. Cash payments Ending cash balance before financing Financing: Borrowings Repayments Interest Payments Print Done Ending cash balance Wonderland Manufacturing produces a variety of industrial valves. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement 1. Prepare a combined cash budget for Wonderland Manufacturing for the third quarter, with a column for each month and for the quarter total. www g www-- Wonderland Manufacturing O More Info Combined Cash Budget For the Months of July through September a. Cash collections from sales in July, August, and September, are projected to be $91,000, S152,000, and $126,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $141,000 in July, $105,000 in August, and $139,000 in September, c. The cash balance as of the first day of the third quarter is projected to be $39,000. d. Wonderland Manufacturing has a policy that they must maintain a minimum cash balance of $24,000. July August September Quarter Beginning balance of cash Cash collections Total cash available The company has a line of credit with the local bank that allows it to borrow funds in months that it would not otherwise have a minimum balance of $24,000. If the company has more than $24,000 at the end of any given month, it uses the excess funds to pay off any outstanding line of credit balance. Each month, Wonderland Manufacturing pays interest on the prior month's line of credit ending balance. The actual interest rate that Wonderland Manufacturing will pay floats since it is tied to the prime rate. However, the interest rate paid during the budget period is expected to be 2% of the prior month's line of credit ending balance (if the company did not have an outstanding balance at the end of the prior month, then Wonderland Manufacturing does not have to pay any interest). All line of credit borrowings are taken or paid off on the first day of the month. As of the first day of the third quarter, Wonderland Manufacturing did not have a balance on its line of credit. Cash payments Ending cash balance before financing Financing: Borrowings Repayments Interest Payments Print Done Ending cash balance
Expert Answer:
Answer rating: 100% (QA)
All amounts are in Wonderland Manufacturing Combined Cash Budget for the months of July through Sept... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
The St. Germaine Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. a. The...
-
Duluth Company is preparing its cash budget for December. The following information is available concerning its accounts receivable: Estimated credit sales for December . . . . . . . . . . . . . . ....
-
Doreen Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable: Actual credit sales for March .................$120,000...
-
The following data were gathered to use in reconciling the bank account of Torres Company: Balance per bank ................................... $14,385 Balance per company records ...................
-
What is the difference between the actual probabilities and the pseudo-probabilities, and on what does it depend? Explain your answer.
-
What is the degree of the sum of the two polynomials in Problem 51? Data from Problem 51 If you are given two polynomials, one of degree m and the other of degree n, where m is greater than n, what...
-
Anita Maxwell Company expects the following for 2007: Net cash provided by operating activities of $150,000 Net cash provided by financing activities of $60,000 Net cash used for investing...
-
On January 1, 2015, Global Manufacturing purchased a machine for $920,000 that it expected to have a useful life of five years. The company estimated that the residual value of the machine was...
-
There are plenty of good stories to tell about how the social sector helps communities. Impact investing is becoming mainstream. Two forms of investment that aligns funding with positive social...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
Scenario You are the senior clinical analyst for the Oakridge Health System. Oakridge Health System is comprised of Medicare-certified hospitals, home health, hospice, inpatient rehabilitation and...
-
Same car insurance problem as above, but now you are willing to self-insure any losses up to $1000 (i.e., have a deductible of $1000). Your maximum coverage is 123 thousand USD, and the probability...
-
A jogger with mass m=85kg uses energy at a rate of P=744W when she jogs on horizontal ground at a constant speed of s=3.9m/s.The efficiency of her"human engine"however, is e=0.36.(In other words, the...
-
On December 31, 2016, Silver Lane Partners, a private equity firm, acquired the operations of Baezmore Telecom (BT), a company with last twelve months (LTM) EBITDA of $882.7 million at an enterprise...
-
Problem 6: A firm expects to sell 8,000 pieces per year during the next 10 years (sale price = 7.2 / unit). It can buy the pieces from a supplier at a fix price of 4.85/unit, or it can buy a machine...
-
solve for t 1 2 0 0 = 1 0 ( 2 t + 2 ) ^ 2 - 2 0 ( 2 t + 2 ) + 5 0 0
-
In the late 1980s and early 1990s, government regulations, marketing, and public demand resulted in the installation of air bags in many new cars to decrease injuries and fatalities in automobile...
-
Chris Zulliger was a chef at the Plaza Restaurant in the Snowbird Ski Resort in Utah. The restaurant is located at the base of a mountain. As a chef for the Plaza, Zulliger was instructed by his...
-
What are the limitations of joint product cost allocation?
-
Each summer the Harbour Report (www.oliverwyman.com/ow/automotive.htm) rates the productivity of the major automakers, including the Detroit Big 3, Toyota, Honda, and many other brands. The report is...
-
Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. SPFs management team thinks that the store will improve its...
-
Part of the water supply for the South Rim of Grand Canyon National Park is taken from the Colorado River [54]. A flow rate of \(600 \mathrm{gpm}\) taken from the river at elevation \(3734...
-
Consider the pump and piping system of Problem 10.51. Estimate the percentage reductions in volume flow rate that occur after (a) 20 years (b) 40 years of use, if the pump characteristics remain...
-
Consider the pump and piping system of Problem 10.50. Determine the volume flow rate and gate valve loss coefficient for the case of two identical pumps installed in parallel. Data From Problem 10.50...
Study smarter with the SolutionInn App