Question

In: Accounting

Reliable company specializes in homemade biscuits and receives all income from sales. The sales estimates (in...

Reliable company specializes in homemade biscuits and receives all income from sales. The sales estimates (in million$) for the four quarters for the company are as follows: 01 = 600, Q2 = 500, Q3 = 550, Q4 = 640. The average collection period for accounts receivables is 45 days. Beginning receivables (Q1 beginning) is $300 million. The purchases are 50, of next quarter sales. Beginning payables (Q1 beginning) is $100 million. The accounts payable period is 45 days. The beginning cash balance (Q1 beginning) is $50 million so how much will be the cash balance at the end of Quarter 2

Solutions

Expert Solution

Since the number of days in each quarter is not known (as the year start and end details are not given, whether Calendar year or any other fiscal year) we have taken days in quarter as 90. If the number of days in a quarter are known, we would have used that to find the closing accounts receivable of quarter.

Amounts are in $ and in millions

Closing Cash balance at end of 2nd quarter is $712.50 million

Note :

For purchases it was mentioned as "Purchases are 50, of next quarter sales". It is taken as purchases are 50% of next quarter sales assuming there is printing mistake.

Also if you have taken actual number of days in quarter instead of 90 days, the answer would have been different. As there is no information regarding that it is ignored


Related Solutions

Reliable company specializes in homemade biscuits and receives all income from sales. The sales estimates (in...
Reliable company specializes in homemade biscuits and receives all income from sales. The sales estimates (in million$) for the four quarters for the company are as follows: 01 = 600, Q2 = 500, Q3 = 550, Q4 = 640. The average collection period for accounts receivables is 45 days. Beginning receivables (Q1 beginning) is $300 million. The purchases are 50, of next quarter sales. Beginning payables (Q1 beginning) is $100 million. The accounts payable period is 45 days. The beginning...
Pet Treats, Inc. specializes in gourmet pet treats and receives all income from sales and has...
Pet Treats, Inc. specializes in gourmet pet treats and receives all income from sales and has the following account details: Last year’s ending payables and receivables were $125M and $250M, respectively, while the cash balance was $80M. Historically, the average receivables turnover ratio has been 12.16667, while the average payables period has been 45 days. Recently, purchases have been approximately one half of sales but are purchased a quarter in advance. The firm likes to maintain a minimum balance of...
Give the following information, prepare a cash budget for Q1-Q4: ABC Ltd. receives all income from...
Give the following information, prepare a cash budget for Q1-Q4: ABC Ltd. receives all income from sales: Sales estimates (in millions): Q1 = 500; Q2 = 340; Q3 = 300; Q4 = 900; Q1 next year = 550 Accounts receivable: Beginning receivables = $300 Average collection period (ACP) = 15 days Accounts payable Purchases = 75% of next quarter’s sales Beginning payables = 125 Accounts payable period is 20 days Other expenses Wages, taxes and other expense are 25% of...
Caroline is retired and receives income from a number of sources. the payments are from bonds...
Caroline is retired and receives income from a number of sources. the payments are from bonds that Caroline purchased over past years and disability insurance policy that Caroline purchased. Calculate her income Distributions from qualified pension plan $5400 Interest on binds issued by City of Austin, Texas $2500 Social Security benefits $8200 Interest on US Treasury Bills $2300 Interest on bonds issued by Ford Motor Company $1900 Interest on bonds issued by City of Quebec, Canada $2750 Disability insurance $9500
Why would we avoid estimates? What about Sales or Income taxes?
This will be probably the most important discussion we have, the 60-day rule. In government, as you can see we have few estimates. If we make all receipts only count if the cash is received (or paid) within 60 day of year end, by the time we complete financial reports (usually within 90 days of year end) we KNOW what will be collected. This fits with the current approach we use for funds. While only required for property tax, we...
A soap company specializes in a luxury type of bath soap. The sales of this soap...
A soap company specializes in a luxury type of bath soap. The sales of this soap fluctuate between two levels — low and high — depending upon two factors: (1) whether they advertise and (2) the advertising and marketing of new products by competitors. The second factor is out of the company’s control, but it is trying to determine what its own advertising policy should be. For example, the marketing manager’s proposal is to advertise when sales are low but...
Assume that you have a company. And the management estimates that 5% of sales will be...
Assume that you have a company. And the management estimates that 5% of sales will be uncollectible. Give any amount of sales and prepare the journal entry using the percent of sales method. Q3 A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory. January 1: Purchased 40 units at SAR10 per unit February 5: Purchased 40 units at SAR 12 per unit March 16: Sold 50 Units for SAR...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y7, are as follows: Cereal Division Snack Cake Division Retail Bakeries Division Sales $25,000,000 $8,000,000 $9,750,000 Cost of goods sold 16,670,000 5,575,000 6,795,000 Operating expenses 7,330,000 1,945,000 2,272,500 Invested assets 10,000,000 4,000,000 6,500,000 The management of The Crunchy Granola...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y7, are as follows: Cereal Division Snack Cake Division Retail Bakeries Division Sales $27,100,000 $8,040,000 $9,750,000 Cost of goods sold 16,690,000 5,575,000 6,710,000 Operating expenses 8,784,000 1,741,400 2,260,000 Invested assets 9,033,333 2,010,000 3,900,000 The management of The Crunchy Granola...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The...
The Crunchy Granola Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y7, are as follows: Cereal Division Snack Cake Division Retail Bakeries Division Sales $25,000,000 $8,120,000 $9,750,000 Cost of goods sold 16,620,000 5,555,000 6,720,000 Operating expenses 7,130,000 1,915,400 2,542,500 Invested assets 7,142,857 2,030,000 3,250,000 The management of The Crunchy Granola...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT