Western Publishing Group, Inc., has estimated sales (in millions) for the next four quarters as: (4+6...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Western Publishing Group, Inc., has estimated sales (in millions) for the next four quarters as: (4+6 Marks) Beginning cash balance Net cash inflow Q1 $210 Sales Sales for the first quarter of the year after this one are projected at $225 million. Accounts receivable at the beginning of the year were $76 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecasted sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 30 percent of sales. Interest and dividends are $15 million per quarter. Ending cash balance. Minimum cash balance Cumulative surplus (deficit) a. Complete a cash budget for Wildcat by filling in the following: WILDCAT, INC. Cash Budget (in millions) Q1 $68 Western Publishing Group, Inc., plans a major capital outlay in the second quarter of $90 million. Finally, the company started the year with a $68 million cash balance and wishes to maintain a $30 million minimum balance. Q2 $180 Beginning cash balance Net cash inflow New short-term investments Income from short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance Minimum cash balance Cumulative surplus (deficit) Beginning short-term investments 30 Ending short-term investments Beginning short-term debt Ending short-term debt Short-Term Financial Plan (in millions) 92 Q1 $68 30 Q3 $240 IQRA NATIONAL UNIVERSITY PESHAWAR Department Of Business Administration b. Assume that Western Publishing Group, Inc., can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter, and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. Prepare a short-term financial plan by filling in the following schedule. What is the net cash cost (total interest paid minus total investment income earned) for the year? Q3 Q2 Q4 Q4 $270 Q3 Q4 Western Publishing Group, Inc., has estimated sales (in millions) for the next four quarters as: (4+6 Marks) Beginning cash balance Net cash inflow Q1 $210 Sales Sales for the first quarter of the year after this one are projected at $225 million. Accounts receivable at the beginning of the year were $76 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecasted sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 30 percent of sales. Interest and dividends are $15 million per quarter. Ending cash balance. Minimum cash balance Cumulative surplus (deficit) a. Complete a cash budget for Wildcat by filling in the following: WILDCAT, INC. Cash Budget (in millions) Q1 $68 Western Publishing Group, Inc., plans a major capital outlay in the second quarter of $90 million. Finally, the company started the year with a $68 million cash balance and wishes to maintain a $30 million minimum balance. Q2 $180 Beginning cash balance Net cash inflow New short-term investments Income from short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance Minimum cash balance Cumulative surplus (deficit) Beginning short-term investments 30 Ending short-term investments Beginning short-term debt Ending short-term debt Short-Term Financial Plan (in millions) 92 Q1 $68 30 Q3 $240 IQRA NATIONAL UNIVERSITY PESHAWAR Department Of Business Administration b. Assume that Western Publishing Group, Inc., can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter, and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. Prepare a short-term financial plan by filling in the following schedule. What is the net cash cost (total interest paid minus total investment income earned) for the year? Q3 Q2 Q4 Q4 $270 Q3 Q4
Expert Answer:
Answer rating: 100% (QA)
Answer Lets start by completing the cash budget for Wildcat a Wildcat Inc Cash Budget in millions Quarter Beginning Cash Balance Net Cash Inflow Ending Cash Balance Minimum Cash Balance Cumulative Sur... View the full answer
Posted Date:
Students also viewed these general management questions
-
How might you go about determining whether a person is worth the salary he or she is paid?
-
How might a corporate management team go about determining whether the company should diversify? What factors should they consider? What kinds of information should they collect?
-
You need to do Financial analysis on the Merck & co. Inc
-
Is the State of Michigan justified in advertising the prize amount as $1.586 billion? Explain.
-
Let S = $100,K = $95, r = 8%, T = 0.5, and = 0. Let u = 1.3, d = 0.8, and n = 1. a. Verify that the price of a European call is $16.196. b. Suppose you observe a call price of $17. What is the...
-
The publisher of Celebrity Living claims that the mean sales for personality magazines that feature people such as Angelina Jolie or Paris Hilton are 1.5 million copies per week. A sample of 10...
-
You are in a meeting to decide on a new product development investment. The VP in charge of the meeting seems to be asking a lot of questions of the design engineers. And it also seems like the VP...
-
A five-year project has a projected net cash flow of $15,000, $25,000, $30,000, $20,000, and $15,000 in the next five years. It will cost $50,000 to implement the project. If the required rate of...
-
Ben is a CPA working on a tax return for a client. They are also doing some tax planning and cost accounting processes for this client. They were asked by the client's bank to provide financial...
-
In this assignment you will be required to complete tasks related to job costing. Download the document, complete the required information, save the document, and submit the assignment in Blackboard....
-
A triangular prism has base edges 4cm,5cm, and 8cm long. Its lateral area is 408cm^(2). What is the height of the prism?
-
The entity integrity rule implies that no attribute that is a member of the primary key may accept a a. Null value b. Integer data type c. Character data type d. Real data type
-
If a colleague showed you the slide in Figure 16, how would you change it? Working in trios, reduce the text on this slide to make it easier to read, more logically organized, and more graphical....
-
Refer to Section 5.3.2, and build a similar Java Ant application named SumTwoNumbers with the following functions: a) Build a GUI by adding a JFrame Form with two TextFields, Num1Field and Num2Field;...
-
Imagine that you made it through first-round interviews with a company you admire. For the second round, they ask you to prepare a three-minute presentation on any topic. Youll deliver this to the...
-
Imagine that youre preparing to talk with your team of employees about a new inventory management system at a retail store. You have noticed items missing and want a better tracking system. The...
-
After being seriously injured in an automobile accident, Joseph Andrews took his case to court and today was awarded an annual payment of $20,000 payable with the first payment due at the end of this...
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
Explore whether the original Bell inequality can be violated at large angles as well.
-
Consider an EPR state \(|\phiangle_{A B}\); Alice measures the spin on \(z\), then Bob measures it on \(x\), and then Alice measures it again on \(z\). Classify the possible answers for the second...
-
Instead of the Bell-CHSH inequality in the text, consider an inequality obtained in the same way from \(\tilde{M}=\left(A+A^{\prime} ight) B^{\prime}+\left(A-A^{\prime} ight) B\) instead of \(M\). Is...
Study smarter with the SolutionInn App