Purpose of Assignment: Students should understand the operating and cash cycles of a company, the mechanics in preparing a cash budget, the use of exchange rates and interest rate parity in international finance and valuation of a company in a merger and acquisition.
Assignment Steps:
Resources: Tutorial help on Excel® and Word® functions can be found on the Microsoft®Office website. There are also additional tutorials via the web that offer support for office products.
Complete the following Questions and Problems from each chapter as indicated.
Show all work and analysis.
Prepare in Microsoft® Excel® or Word.
Format your assignment consistent with APA guidelines if submitting in Microsoft® Word.
1. Changes in the Operating Cycle [LO1] Indicate the effect that the following will have on the operating cycle. Use the letter I to indicate an increase, the letter D for a decrease, and the letter N for no change:
a. Average receivables goes up.
b. Credit repayment times for customers are increased.
c. Inventory turnover goes from 3 times to 6 times.
d. Payables turnover goes from 6 times to 11 times.
e. Receivables turnover goes from 7 times to 9 times.
f. Payments to suppliers are accelerated.
2. Calculating the Cash Budget [LO3] Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2015:
![1935_CS.png](https://secure.tutorsglobe.com/CMSImages/1935_CS.png)
The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase.
In March 2015, credit sales were $235,000 and credit purchases were $161,300. Using this information, complete the following cash budget:
![792_CS 1.png](https://secure.tutorsglobe.com/CMSImages/792_CS 1.png)
3. Size of Accounts Receivable [LO1] The Arizona Bay Corporation sells on credit terms of net 30. Its accounts are, on average, four days past due. If annual credit sales are $9.75 million, what is the company's balance sheet amount in accounts receivable?
4. Credit Policy Evaluation [LO2] The Snedecker Corporation is considering a change in its cash-only policy. The new terms would be net one period. Based on the following information, determine if the company should proceed or not. Therequired return is 2.5 percent per period.
![1354_CS 2.png](https://secure.tutorsglobe.com/CMSImages/1354_CS 2.png)
5. Using Spot and Forward Exchange Rates [LO1] Suppose the spot exchange rate for the Canadian dollar is Can$1.09 and the six-month forward rate is Can$1.11.
a. Which is worth more, a U.S. dollar or a Canadian dollar?
b. Assuming absolute PPP holds, what is the cost in the United States of an Elkhead beer if the price in Canada is Can$2.50? Why might the beer actually sell at a different price in the United States?
c. Is the U.S. dollar selling at a premium or a discount relative to the Canadian dollar?
d. Which currency is expected to appreciate in value?
e. Which country do you think has higher interest rates-the United States or Canada? Explain.
6. Interest Rates and Arbitrage [LO2] The treasurer of a major U.S. firm has $30 million to invest for three months. The interest rate in the United States is .31 percent per month. The interest rate in Great Britain is .34 percent per month. The spot exchange rate is £.573, and the three-month forward rate is £.575. Ignoring transaction costs, in which country would the treasurer want to invest the company's funds? Why?
7. Calculating Synergy [LO3] Pearl, Inc., has offered $357 million cash for all of the common stock in Jam Corporation. Based on recent market information, Jam is worth $319 million as an independent operation. If the merger makes sense for Pearl, what is the minimum estimated value of the synergistic benefits from the merger?
8. Balance Sheets for Mergers [LO2] Consider the following premerger information about Firm X and Firm Y:
![405_CS 3.png](https://secure.tutorsglobe.com/CMSImages/405_CS 3.png)
Information related to above question is enclosed below:
Attachment:- excelwrksht.rar