Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Gruber company has projected the following quarterly sales amounts for the coming year: First Quarter Second Quarter Third Quarter Fourth Quarter Sales ($
The Gruber company has projected the following quarterly sales amounts for the coming year: First Quarter Second Quarter Third Quarter Fourth Quarter Sales ($ in millions) $100 $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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started