The Gruber company has projected the following quarterly sales amounts for the coming year: Sales ($...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Gruber company has projected the following quarterly sales amounts for the coming year: Sales ($ in millions) First Quarter $100 Second Quarter Third Quarter Fourth Quarter $200 $150 $100 All of Gruber s' cash inflows come from sales. Accounts receivable at the beginning of the year are $100. The company has a 90-day collection period and 100 percent of sales are collected the following quarter. We assume that sales in the fourth quarter of the previous fiscal year were $100 million. The sales in the first quarter of the next fiscal year will be $100 million. Purchases = 40% next quarter's sales. Beginning payables = 23. Payables period is 45 days (half of the purchases will be paid for each quarter). Wages, taxes, and other expenses as following: Q1: 20, Q2: 40, Q3: 30, Q4: 20, The company plans a major capital expenditure of $100 in the fourth quarter. Interest and dividends are $10. The initial cash balance is $40, and Gruber had established a minimum operating cash balance equal to $30 million to facilitate transactions, protect against unexpected contingencies. a. Calculate cash collections in each of the four quarters. b. Calculate payments to suppliers in each of the four quarters. c. Calculate a cash balance for Gruber company. The Gruber company has projected the following quarterly sales amounts for the coming year: Sales ($ in millions) First Quarter $100 Second Quarter Third Quarter Fourth Quarter $200 $150 $100 All of Gruber s' cash inflows come from sales. Accounts receivable at the beginning of the year are $100. The company has a 90-day collection period and 100 percent of sales are collected the following quarter. We assume that sales in the fourth quarter of the previous fiscal year were $100 million. The sales in the first quarter of the next fiscal year will be $100 million. Purchases = 40% next quarter's sales. Beginning payables = 23. Payables period is 45 days (half of the purchases will be paid for each quarter). Wages, taxes, and other expenses as following: Q1: 20, Q2: 40, Q3: 30, Q4: 20, The company plans a major capital expenditure of $100 in the fourth quarter. Interest and dividends are $10. The initial cash balance is $40, and Gruber had established a minimum operating cash balance equal to $30 million to facilitate transactions, protect against unexpected contingencies. a. Calculate cash collections in each of the four quarters. b. Calculate payments to suppliers in each of the four quarters. c. Calculate a cash balance for Gruber company.
Expert Answer:
Answer rating: 100% (QA)
ANSWERS TO QUESTIONS A AS the sales made in the current quarter will be collected in the next quarte... View the full answer
Related Book For
Business and Professional Ethics
ISBN: 978-1285182223
7th edition
Authors: Leonard J. Brooks, Paul Dunn
Posted Date:
Students also viewed these accounting questions
-
A company makes two products in a single plant. It runs this plant for 100 hours each week. Each unit of product A that the company produces consumes two hours of plant capacity, earns the company a...
-
How much should the company spend to advertise the new Special K protein bars in Canada? What percentage of the snack food market do you think they will be able to capture in the first year, and what...
-
By how much should a pair of light rays from a common source differ in distance traveled to produce destructive interference?
-
Shemekia applied to a college that uses multiple regression to select students. This college only considers students whose predicted firstyear GPA is 3.0 or higher. Shemekias predicted GPA was 2.9...
-
Property and casualty insurance can be marketed under different marketing systems. Compare the independent agency system with the exclusive agency system with respect to each of the following: a....
-
If a hierarchy of charts is used in project planning, explain if there should be a corresponding hierarchy of plans as well.
-
(Efficient frontier) This question relates to the data in the previous question. Calculate and graph the efficient frontier of the stock portfolios composed of stocks X and Y.
-
An airline company must plan its fleet capacity and its long-term schedule of aircraft usage. For one flight segment, the average number of customers per day is 70, which represents a 65 percent...
-
\f
-
After retiring as a physician, Bob Guthrie became an avid downhill skier on the steep slopes of the Utah Rocky Mountains. As an amateur inventor, Bob was always looking for something new. With the...
-
Which conclusion should you avoid making when looking at correlations? Select an answer: Correlations are different than discrepancies. Corellations can have trends. Correlations represent...
-
(25 points) Use power series to solve the initial-value problem y" + 4xy' + 8y = 0, y(0) = 0, y' (0) = 1. Answer: y = x2n + + n=0 n=0 x2n+1
-
Discuss how cyber disruptions may impact the performance of essentials functions and identify solutions to address vulnerabilities in existing continuity plans.
-
Define Supportive pillar, Regulatory Pillar, Normative Pillar, and Cognitive Pillar in detail.
-
Set up an integral to find the volume of the solid generated when the region bounded by y = the x-axis and the line x = 1, is 2+11 (a) (7 points) Rotated about the x-axis using shells. (b) (7 points)...
-
Suppose you are an employee with the Ministry of Transport. The Ministry is interested in determining whether significant road maintenance is necessary on a particular stretch of road. In addition to...
-
MNO Enterprises, a construction company, reports its balance sheet as of December 31, 2023. The company's assets include cash, accounts receivable, construction equipment, and real estate properties....
-
What is a lobbyist in US? How did this term emerge?
-
Why don't codes of conduct or existing jurisprudence provide sufficient guidance for accountants in ethical matters?
-
When should an employee satisfy his or her self-interest rather than the interest of his or her employer?
-
1. Where were Wal-Marts questionable payments made, and where did this result in serious damage to the company and its executives? Why? 2. The gestores payments were made to third parties, who then...
-
Prepare a flexible budget for planning (Learning Objective 1) Lasting Bubbles produces multicolored bubble solution used for weddings and other events. The companys static budget income statement for...
-
Comprehensive flexible budget, standards, and variances problem (Learning Objectives 2, 3,4, 5) One System assembles PCs and uses flexible budgeting and a standard cost system. One System allocates...
-
Work backward through labor variances (Learning Objective 4) Amandas Music manufactures harmonicas. Amanda uses standard costs to judge performance. Recently, a clerk mistakenly threw away some of...
Study smarter with the SolutionInn App