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...
-
Your1040Return.com's main business strategy involves the delivery of services via the Internet. What are some threats to the viability of Your1040Return.com's business strategy?
-
Which of Vasilevas assumptions regarding regression analysis is incorrect? A. Assumption 1 B. Assumption 2 C. Assumption 3 Elena Vasileva recently joined EnergyInvest as a junior portfolio analyst....
-
The efficiency of a self-locking machine is _____ 50 percent.
-
Assume that HOS could issue a zero coupon bond at an annual interest rate of 4 percent with semiannual compounding for 20 years. If HOS receives $ 2,264.45 for the bond, how much would it have to pay...
-
Please summarize the changing use of positive psychology over time, including how it compares with other theories in personality psychology. Consider the future relevance of positive psychology...
-
David is age 40 and was widowed in 2022. He has a daughter, Linda, age 8.David provided the entire cost of maintaining the household and over half of the support for Linda. In order to work, he pays...
-
The Fourier Transformation of a function f(x) is defined as following: will be 2k k +1 The Fourier Transform of the function (a) g(k) = f(x) exp (-ikx) dx (b) -00 2k k+1 d4 dx dx [exp(-x))] f(x)= =...
-
Suppose that Loki started out his investment with $50 at the beginning of 2018. Loki did not invest any additional amount at the beginning of 2019. Later on, he deposited an additional $500 at the...
-
A Financial Institute (FI) offers investors a deposit instrument that guaranteed the instrument buyer a 6-month return which will be the greater of (a) zero and (b) 40% of the return on a specific...
-
Using ROE, P/B ratio and P/E ratios, discuss the market's expectation on future performance of A and B relative to their current performance (current ROE/ profitability). Company A and B are in the...
-
A thin plate is under a condition of plane stress (Tzx=0, Tzy=0, Tzz=0). It is also subjected to the uniform loading shown on the boundary. Determine the range of possible values of txx at the...
-
5. [-/1 Points] DETAILS OSCOLPHYS2 25.3.P.015. MY NOTES Suppose the figure below represents a ray of light going from air through crown glass into water, such as going into a fish tank. Calculate the...
-
Solve the following optimization problem by inspection (use your understanding of the problem statement to determine a global maximizer). Report both the
-
TRUE OR FALSE: 1. Banks with a significantly large share of fixed-interest rate home loans are less exposed to interest rate risks. 2. Although Australian banks are pretty big, they are not...
-
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....
-
Consider the multiple linear regression model fit to the baseball data in Problem 3.41. Problem 3.41 Consider the 2016 major league baseball data in Table B.22. While team ERA was useful in...
-
Consider the simple linear regression model fit to the rental price data from Problem 2.36. Data From Problem 2.36 Table B.24 contains data on median family home rental price and other data for 51 US...
-
Consider the multiple linear regression model fit to the rental price data in Problem 3.42. Problem 3.42 Table B.24 contains data on median family home rental price and other data for 51 US cities....
Study smarter with the SolutionInn App