Kellogg Company's financial managers are meeting with the company's bank to renew their line of credit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kellogg Company's financial managers are meeting with the company's bank to renew their line of credit and discuss their investment needs. They have prepared the company's operating cash budget for the last six months of the year. The following budget assumptions were used to construct the budget: • Kellogg's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. • Kellogg's sales are made on credit with terms of 2/10, net 30. Kellogg's experience is that 15% is collected from customers who take advantage of the discount, 75% is collected in the second month, and the last 10% is collected in the third month after the sale. The budget assumes that there are no bad debts. • The cost of materials averages 55% of Kellogg's finished product. The purchases are generally made one month in advance of the sale, and Kellogg pays its suppliers in 30 days. Accordingly, if July sales are forecasted at $99.00 million, then purchases during June would be $54.45 million ($99.00 million x 55%), and this amount would be paid in July. • Other cash expenses include wages and salaries at 16% of monthly sales, monthly rent of $36.00 million, and other expenses equal to 5% of monthly sales. Estimated tax payments of $175.50 million and $185.40 million are required to be paid on July 15 and October 15, respectively. In addition, a $900.00 million payment for a new plant must be made in September. • Assume that Kellogg's targeted cash balance is $150.72 million, and the estimated cash on hand on July 1 is $150.72 million. Use the preceding information to fill in the missing amounts in the following cash budget for the period of July 1st to December 31st. Kellogg Company ($ millions) Cash Budget May Jun Jul Jul Aug Sep Oct Nov Dec Credit sales $85.50 $88.20 $90.00 $90.90 $92.70 $94.50 $97.20 $99.00 Credit purchases 49.50 50.99 51.98 53.46 54.45 Jul Aug Sep Oct Nov Dec Cash receipts Collections from this $13.36 $13.63 $13.89 $14.29 $14.55 month's sales Collections from 67.50 68.18 69.53 70.88 72.90 previous month's sales Collections from sales 8.82 9.00 9.09 9.27 9.45 two months previously Total cash receipts $89.68 $90.81 $92.51 $94.44 $96.90 Cash disbursements Payments for credit $49.50 $50.00 $50.99 $53.46 $54.45 purchases Wages and salaries 14.40 14.54 14.83 15.55 15.84 Rent 36.00 36.00 36.00 36.00 36.00 Other expenses 4.50 4.55 4.64 4.86 4.95 Тахes 175.50 Payment for plant 900.00 construction Total cash $279.90 $105.09 $1,006.46 $109.87 $111.24 disbursements Net cash flow (Receipts - -$191.97 -$15.41 -$915.65 -$200.72 -$15.43 -$14.34 disbursements) Beginning cash 150.72 -$41.25 -$56.66 -$972.31 -$1,173.03 -$1,188.46 balance Ending cash balance -$41.25 -$56.66 -$1,173.03 -$1,188.46 -$1,202.80 Target (minimum) -150.72 -150.72 -150.72 -150.72 -150.72 cash balance Surplus (shortfall) -$191.97 -$207.38 -$1,323.75 -$1,339.18 -$1,353.52 cash Use the information provided in the budget to complete the following sentences. Kellogg Company will be able to invest in short-term marketable securities in some months and will need to borrow to cover cash requirements in others. In the last six months of the year, Kellogg will to end the year with a cash of and a cash of . Kellogg Company will want a credit line of at least to cover the month with the greatest shortfall, and the financial managers can tell the bank to expect that they will be able to invest up to in short-term marketable securities. Kellogg Company's financial managers are meeting with the company's bank to renew their line of credit and discuss their investment needs. They have prepared the company's operating cash budget for the last six months of the year. The following budget assumptions were used to construct the budget: • Kellogg's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. • Kellogg's sales are made on credit with terms of 2/10, net 30. Kellogg's experience is that 15% is collected from customers who take advantage of the discount, 75% is collected in the second month, and the last 10% is collected in the third month after the sale. The budget assumes that there are no bad debts. • The cost of materials averages 55% of Kellogg's finished product. The purchases are generally made one month in advance of the sale, and Kellogg pays its suppliers in 30 days. Accordingly, if July sales are forecasted at $99.00 million, then purchases during June would be $54.45 million ($99.00 million x 55%), and this amount would be paid in July. • Other cash expenses include wages and salaries at 16% of monthly sales, monthly rent of $36.00 million, and other expenses equal to 5% of monthly sales. Estimated tax payments of $175.50 million and $185.40 million are required to be paid on July 15 and October 15, respectively. In addition, a $900.00 million payment for a new plant must be made in September. • Assume that Kellogg's targeted cash balance is $150.72 million, and the estimated cash on hand on July 1 is $150.72 million. Use the preceding information to fill in the missing amounts in the following cash budget for the period of July 1st to December 31st. Kellogg Company ($ millions) Cash Budget May Jun Jul Jul Aug Sep Oct Nov Dec Credit sales $85.50 $88.20 $90.00 $90.90 $92.70 $94.50 $97.20 $99.00 Credit purchases 49.50 50.99 51.98 53.46 54.45 Jul Aug Sep Oct Nov Dec Cash receipts Collections from this $13.36 $13.63 $13.89 $14.29 $14.55 month's sales Collections from 67.50 68.18 69.53 70.88 72.90 previous month's sales Collections from sales 8.82 9.00 9.09 9.27 9.45 two months previously Total cash receipts $89.68 $90.81 $92.51 $94.44 $96.90 Cash disbursements Payments for credit $49.50 $50.00 $50.99 $53.46 $54.45 purchases Wages and salaries 14.40 14.54 14.83 15.55 15.84 Rent 36.00 36.00 36.00 36.00 36.00 Other expenses 4.50 4.55 4.64 4.86 4.95 Тахes 175.50 Payment for plant 900.00 construction Total cash $279.90 $105.09 $1,006.46 $109.87 $111.24 disbursements Net cash flow (Receipts - -$191.97 -$15.41 -$915.65 -$200.72 -$15.43 -$14.34 disbursements) Beginning cash 150.72 -$41.25 -$56.66 -$972.31 -$1,173.03 -$1,188.46 balance Ending cash balance -$41.25 -$56.66 -$1,173.03 -$1,188.46 -$1,202.80 Target (minimum) -150.72 -150.72 -150.72 -150.72 -150.72 cash balance Surplus (shortfall) -$191.97 -$207.38 -$1,323.75 -$1,339.18 -$1,353.52 cash Use the information provided in the budget to complete the following sentences. Kellogg Company will be able to invest in short-term marketable securities in some months and will need to borrow to cover cash requirements in others. In the last six months of the year, Kellogg will to end the year with a cash of and a cash of . Kellogg Company will want a credit line of at least to cover the month with the greatest shortfall, and the financial managers can tell the bank to expect that they will be able to invest up to in short-term marketable securities.
Expert Answer:
Answer rating: 100% (QA)
In the last 6 months of the year Kellogg will lose 1434 to end the year wi... View the full answer
Related Book For
Corporate Financial Accounting
ISBN: 978-1305653535
14th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these general management questions
-
A firm purchases materials on terms of 2/10, net 70 and it can borrow the funds from a bank at an APR of 16%. Should the firm use the bank loan by taking the discount or the full credit period by...
-
Which of the following differential equations is NOT LINEAR? A B 6y-xy"+y' + 4y = 4x D xy"-y' + 2xy = 0 Cy"-y'+2yy' = 0 y""' = 8
-
Customers who made online purchases last quarter from an Internet retailer were randomly sampled from the retailers database. The dollar value of each customers quarterly purchases along with the...
-
Three partners. Ankamah, Kofi and David share profit and losses in the ratio 5: 3:2 for the year ending 31/12/2016. The profit generated from either business is $600,000. Partners' contributions are...
-
Use Figure 32.11 as a starting point for this problem and consider the initial impact of the following circumstances on the aggregate demand, long-run aggregate supply, and short-run aggregate supply...
-
Down the drain Most water tanks have a drain plug so that the tank may be emptied when its to be moved or repaired. How long it takes a certain size of tank to drain depends on the size of the plug,...
-
Consider the initial boundary value problem for the heat equation: \[\begin{array}{cc} u_{t}=2 u_{x x}, & 0 0 . \end{array}\] Use the finite transform method to solve this problem. Namely, assume...
-
Superior Company provided the following account balances for the year ended December 31 (all raw materials are used in production as direct materials): Selling expenses . . . . . . . . . . . . . . ....
-
3. With the development of the concept and practice of Corporate Social Responsibility (CSR) Then a theoretical discourse has also developed that explains the pros and cons of this field. a. How...
-
The focus of this project is to create a master budget for the Williams Company based on the companys industry outlook, recent company outcomes, and the companys business rules. You will create a...
-
On 30 April 20X2, Neuman Ltd. sells a product to a customer for $600,000. The product carries a one-year assurance warranty. Neuman management estimates that the probable cost of fulfilling the...
-
Provide an introduction to the problem - describe your experience (or an experience you observed). Introduce the organizational behavior concept(s) you will be introducing as possible lenses in which...
-
Before the global pandemic, warehouses performed mainly a role of protection i.e. protection from the weather and potential pilferage. Fast forward to current times i.e post global pandemic, the...
-
Find a vector orthogonal to (0,1,3) and (-2,2,0). Choose the correct answer below. OA. (-6,6,2) OB. (6,6,2) OC. (-6, -6,2) O D. (6, -6, -2)
-
Students will keep an electronic journal outlining ten ideas for a new business or expansion of an existing business. Idea journaling is where students use strategies to locate, identify, and...
-
Q1 Seaside Company uses the weighted-average method in its process costing system. The Sanding Department started the month with 8,000 units in its beginning work-in-process inventory that were 70%...
-
Escoge una empresa de servicios e identifica las actividades que realiza en el rea de Marketing y Ventas. Lista tales actividades y evala si agregan o no valor. Justifica el anlisis de las activ...
-
Refer to the information from Exercise 22-19. Use the information to determine the (1) Weighted average contribution margin , (2) Break-even point in units, and (3) Number of units of each product...
-
The balance in the equipment account is $3,150,000, and the balance in the accumulated depreciation-equipment account is $2,075,000. A. What is the book value of the equipment? B. Does the balance in...
-
In teams, select a public company that interests you. Obtain the company's most recent annual report on Form 10-K. The Form 10-K is a company's annually required filing with the Securities and...
-
A diesel-powered tractor with a cost of $90,000 and estimated residual value of $15,000 is expected to have a useful operating life of 30,000 hours. During April, the tractor was operated 120 hours....
-
Draw up a consolidated balance sheet as at 31 December 2007 from the following: At the balance sheet date, Child owes Parent 3,200. During the year Parent sold goods which had cost 6,000 to Child for...
-
You are to draw up a consolidated balance sheet as at 31 December 2005 from the following: At the balance sheet date, Son 1 owed Pa and Mum 2,500 and Son 2 1,100, and Pa and Mum owed Son 2 2,100. Pa...
-
You are presented with the following information from the Seneley group of companies for the year to 30 September 2006: Additional information: (a) The authorised, issued and fully paid share capital...
Study smarter with the SolutionInn App