Are you able to help me one last time? I would need help with all 8 tabs on the attached excel spreadsheet. Any questions please let me know.

Thank you again!

Chapter 26 Question 4 Input Area: Current assets Other assets Net fixed assets Total Current assets Other assets Net fixed assets Total $ Silver Enterprises Current liabilities Long-term debt Equity - $ - $ All Gold Mining Current liabilities Long-term debt Equity - $ - $ - Market value of fixed assets New long-term debt Output Area: Current assets Other assets Net fixed assets Goodwill Total Silver Enterprises - Post Merger $ - Current liabilities - Long-term debt - Equity $ - $ - 3. Changes in the Operating Cycle - Indicate the effect that the following will have on the operating c 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. 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 d the letter N for no change: 11. Calculating the Cash Budget [LO3] Here are some important figures from the budget of Nashville Nougats ANSWER et of Nashville Nougats, Inc., for the second quarter of 2015: 8. 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? ANSWER 14. Credit Policy Evaluaton [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. ANSWER 4. Using Spot and Forward Exchange Rates [LO1] Suppose the spot exchange rate for the Canad 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 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 ratesthe United States or Canada? Explain. ange rate for the Canadian dollar is Can$1.09 and the six-month forward rate is Can$1.11. ANSWER 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? ANSWER ANSWER ANSWER ANSWER 7. 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? ANSWER 1. Calculatng 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 economic sense for Pearl, what is the minimum estimated value of the synergistic benefits from the merger? ANSWER Balance Sheets for Mergers [LO2] Consider the following premerger information about Firm X and Input Area: Firm X Firm Y Total earnings Shares outstanding Per-share values Market Book Merger premium Output Area: Asset from X (book value) Asset from Y (market value) Purchase price of Y Goodwill Total assets XY = Total equity XY $ $ $ $ $ - er information about Firm X and Firm Y