Mellon 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!
Transcribed Image Text:
Mellon 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: • Mellon's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. • Mellon's sales are made on credit with terms of 2/10, net 30. Mellon's experience is that 25% is collected from customers who take advantage of the discount, 65% 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 45% of Mellon's finished product. The purchases are generally made one month in advance of the sale, and Mellon pays its suppliers in 30 days. Accordingly, if July sales are forecasted at $1,100 million, then purchases during June would be $495 ($1,100 million x 0.45), and this amount would be paid in July. • Other cash expenses include wages and salaries at 19% of sales, monthly rent of $40 million, and other expenses at 5% of sales. Estimated tax payments of $59 million and $61 million are required to be paid on July 15 and October 15, respectively. In addition, a $1,000 million payment for a new plant must be made in September. • Assume that Mellon's targeted cash balance is $251, and the estimated cash on hand on July 1 is $251. Use the preceding information to fill in the missing amounts in the following cash budget. Mellon Company Cash Budget For the Six Months Ended December 31, Year 1 ($ millions) May June July August September October November December Credit sales $950 $980 $1,000 $1,010 $1,030 $1,050 $1,080 $1,100 Credit purchases 450 464 473 486 495 July August September October November December Cash receipts Collections from this month's sales 247 252 257 265 270 Collections from previous month's sales 650 657 670 683 702 Collections from sales two months previously 98 100 101 103 105 Total cash receipts $995 $1.009 $1,028 $1,051 $1,077 Cash disbursements Payments for credit purchases 450 455 464 486 495 Wages and salaries 190 192 196 205 209 Rent 40 40 40 40 40 Other expenses 50 51 52 54 55 Taxes 59 Payment for plant construction 1,000 Total cash disbursements $789 $738 $1,752 $785 $799 Net cash flow (Receipts - disbursements) $188 $257 -$743 $201 $266 $278 Beginning cash balance 251 439 696 -47 154 420 Ending cash balance $439 $696 $154 $420 $698 Target (minimum) cash balance 251 251 251 251 251 Surplus (shortfall) cash $188 $445 -$97 $169 $447 Mellon 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, Mellon will 2$ to end the year with a cash of $ v and a cash v of $ v . Mellon 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. Mellon 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: • Mellon's total sales for each month were first calculated in the sales budget and are reflected on the first line of the cash budget. • Mellon's sales are made on credit with terms of 2/10, net 30. Mellon's experience is that 25% is collected from customers who take advantage of the discount, 65% 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 45% of Mellon's finished product. The purchases are generally made one month in advance of the sale, and Mellon pays its suppliers in 30 days. Accordingly, if July sales are forecasted at $1,100 million, then purchases during June would be $495 ($1,100 million x 0.45), and this amount would be paid in July. • Other cash expenses include wages and salaries at 19% of sales, monthly rent of $40 million, and other expenses at 5% of sales. Estimated tax payments of $59 million and $61 million are required to be paid on July 15 and October 15, respectively. In addition, a $1,000 million payment for a new plant must be made in September. • Assume that Mellon's targeted cash balance is $251, and the estimated cash on hand on July 1 is $251. Use the preceding information to fill in the missing amounts in the following cash budget. Mellon Company Cash Budget For the Six Months Ended December 31, Year 1 ($ millions) May June July August September October November December Credit sales $950 $980 $1,000 $1,010 $1,030 $1,050 $1,080 $1,100 Credit purchases 450 464 473 486 495 July August September October November December Cash receipts Collections from this month's sales 247 252 257 265 270 Collections from previous month's sales 650 657 670 683 702 Collections from sales two months previously 98 100 101 103 105 Total cash receipts $995 $1.009 $1,028 $1,051 $1,077 Cash disbursements Payments for credit purchases 450 455 464 486 495 Wages and salaries 190 192 196 205 209 Rent 40 40 40 40 40 Other expenses 50 51 52 54 55 Taxes 59 Payment for plant construction 1,000 Total cash disbursements $789 $738 $1,752 $785 $799 Net cash flow (Receipts - disbursements) $188 $257 -$743 $201 $266 $278 Beginning cash balance 251 439 696 -47 154 420 Ending cash balance $439 $696 $154 $420 $698 Target (minimum) cash balance 251 251 251 251 251 Surplus (shortfall) cash $188 $445 -$97 $169 $447 Mellon 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, Mellon will 2$ to end the year with a cash of $ v and a cash v of $ v . Mellon 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)
Total for May June July August Sept Oct Nov Dec 6 months Credit Sales Credit Puchases 556 Cash recei... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324664553
Concise 6th Edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these accounting questions
-
Using the internet, find at least three sources for coping with a backstabber in the workplace. Carefully review each site for suggestions for dealing with this type of behavior. Based on your...
-
The following graph shows the value of a stock's dividends over time. The stock's current dividend is $1.00 per share, and dividends are expected to grow at a constant rate of 3.50% per year. The...
-
A ball is projected upward at time=0.00 s, from a point on a roof 80 m above the ground and experiences negligible air resistance. The ball rises, then falls and strikes the ground. The initial...
-
In a recombinant protein expression process the host microorganism, Pichia pastoris needs to be separated from the culture supernatant after production. A pilot scale bioreactor with a working volume...
-
Politics is not inherently bad. It is merely a way to get things accomplished within organizations. Do you agree or disagree? Defend your position.
-
A Geneva with six slots is used to operate the worktable of a dial-indexing machine. The slowest workstation on the dial-indexing machine has an operation time of 2.5 sec, so the table must be in a...
-
True or False. A deterministic system requires deterministic system properties and loading.
-
Moreno Company publishes a monthly sports magazine, Fishing Preview. Subscriptions to the magazine cost $20 per year. During November 2014, Moreno sells 15,000 subscriptions beginning with the...
-
RiverRocks (whose WACC is 11.8%) is considering an acquisition of Raft Adventures (whose WACC is 14.5%). The purchase will cost $101.1 million and will generate cash flows that start at $14.9 million...
-
All American Telephones Inc. is considering the production of a new cell phone. The project will require an investment of $13 million. If the phone is well received, the project will produce cash...
-
Explain the benefits and challenges of asynchronous replication (also called lazy replication) in contrast to synchronous replication. Discuss both the configuration that uses a single master and one...
-
DNA gyrase a. promotes negative supercoiling. b. relaxes positive supercoils. c. cuts DNA strands as part of its function. d. does all of the above.
-
A bacterial chromosome typically contains a. a few thousand genes. b. one origin of replication. c. some repetitive sequences. d. all of the above.
-
What is the correct order for the steps of transformation given in the following list? Recombination with the bacterial chromosome 2.Binding of a large DNA fragment to the surface of a bacterial cell...
-
Which of the following is an example of horizontal gene transfer? a. The transfer of a gene from one strain of E. coli to a different strain via conjugation b. The transfer of a gene from one strain...
-
With regard to conjugation, a key difference between F+ and Hfr cells is that an Hfr cell a. is unable to conjugate. b. transfers a plasmid to the recipient cell. c. transfers a portion of the...
-
Using Mason's Rule find the transfer function of the system R(s) 1 5+1 -E' -6 S s+3 1 Y(s) -E $+2 -10 Indicate the transfer function in terms of Pi, li, A and Ai 10
-
Horse serum containing specific antibody to snake venom has been a successful approach to treating snakebite in humans. How do you think this anti-venom could be generated? What are some advantages...
-
SKI tries to match the maturity of its assets and liabilities. Describe how SKI could adopt a more aggressive or a more conservative financing policy.
-
Coleman estimates that if it issues new common stock, the flotation cost will be 15%. Coleman incorporates the flotation costs into the DCF approach. What is the estimated cost of newly issued common...
-
A companys 5-year bonds are yielding 7.75% per year. Treasury bonds with the same maturity are yielding 5.2% per year, and the real risk-free rate (r*) is 2.3%. The average inflation premium is 2.5%;...
-
Using the fourth-order Runge-Kutta method, solve Problem 11.15. Data From Problem 11.15:- Using the second-order Runge-Kutta method, solve the differential equation \(\ddot{x}+1000 x=0\) with the...
-
Using the central difference method, find the response of the two-degree-of-freedom system shown in Fig. 11.2 when \(c=2, F_{1}(t)=0, F_{2}(t)=10\). Figure 11.2:- X1(t) -x2(t) F(1) k=2 -F2(t) k = 4...
-
Using the central difference method, find the response of the system shown in Fig. 11.2 when \(F_{1}(t)=10 \sin 5 t\) and \(F_{2}(t)=0\). Figure 11.2:- X1(t) -x2(t) F(1) k=2 -F2(t) k = 4 k2=6 00000...
Study smarter with the SolutionInn App