Please find attached, I need it solved in excel. This is from Financial management Theory and Practice 14th edition.
A 1 2 3 4 B C D Name______________________________________ Mid-term Examination FINC 5880 Session 5 5 6 Question 1. (15 points) NORREL Corporation's stock is selling for $35 per share. An investor is 7 considering buying a call option with an exercise price of $40. The investor is willing to pay the premium 8 of 50 cents per option. 9 10 a. Calculate the exercise value of the option? 11 12 13 14 15 16 17 18 19 200 $20 January 2001 futures 20 Use short hedge, sell futures contracts. Sell 100 contracts ($100,000 x 100 = $10 million). June futures selling for selling for current value is value is $21,056,250 ($20 million x 105 If interest interest by June, company can 117 17/32,105 9/32, current$11,753,125 ($10 million x 117 17/32%). 9/32%). Ifrates riserates rise by January 21 company caninvestor willing at lower cents at lower help offsetwill help offset the loss from financing interest rate. b. Why is an repurchase futures contracts an option when the their loss from $35? 22 repurchase futures contracts to pay 50 cost which willcost which stock is going forfinancing at the higher at the higher interest rate. So, the firm has hedged interest rates. So, the firm has hedged against rising against rising interest rates. 23 24 25 26 27 28 29 30 c. Calculate the exercise value if the price of the stock increases to $42 per share. 31 32 33 34 35 36 d. What is the difference between a put option and a call option? 37 38 39 40 41 42 43 44 45 e. If the exercise price for both the call option and the put option is $40, which will have a higher premium if 46 the underlying stock price falls to $30 per share? Why? 47 48 49 50 51 52 53 54 55 56 57 A 58 B C D A 1 B C D E F G Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 Question 2. (15 points) Your company is evaluating new equipment that will cost $1,000,000. The equipment is in the MACRS 3-year class and will be sold after 3 years for $100,000. Use of the equipment will increase net working capital by 100,000. The equipment will save $450,000 per year in operating costs. The company's tax rate is 30 percent and its cost of capital is 10%. Part a. Calculate the cash flow in Year 0. Part b. Calculate the incremental operational cash flows . Reference: MACRS Depreciation Percentages for three-year class life assets: 0.3333 0.4445 0.1481 0.0741 c. Calculate the non-operating terminal year cash flow. Part d. Calculate the project's payback period. Part e. Calculate the project's NPV. Part f. Calculate the project's IRR. Part g. Calculate the project's MIRR. . . .. A B C D 72 Part h. Investment Decision: Should the project be accepted or rejected? Why or why not? 73 74 75 E F G A 1 B C D E F Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 Question 3. (15 points) Reynolds company is evaluating its dividend policy. Selected data for the company are shown below. 7 Capital budget $10,000,000 8 Desired capital structure 40% Debt 9 60% Equity 10 Expected net income $7,000,000 11 Outstanding shares 5,000,000 12 Last annual dividend per share $0.50 13 14 15 a. If the company follows a residual policy, how much will it pay out in dividends? 16 17 18 19 20 21 22 23 24 b. If the company decides to maintain last year's dividend, how much will it pay out in dividends this year? 25 26 27 28 29 30 31 32 c. What are the company's options for raising the equity needed for the capital budget? 33 34 35 36 37 38 d. Should the company follow the residual dividend policy? Why or why not? 39 40 41 42 43 44 45 46 47 e. Which is better for the stockholder--cash dividends or stock repurchases? Why? 48 49 50 51 52 53 54 55 56 57 G A 58 59 B C D E F G A 1 B C D E F G Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Question 4. (10 points) The exchange rate between the Japanese yen and the U.S. dollar is 94.72 yen = 1U.S$. A U.S. company agrees to purchase goods for 40 million yen, with payment due in 6 months. Payment will be made in yen. a. How many U.S. dollars would the company need to purchase the goods and pay for them today? b. Has the yen appreciated or depreciated against the dollar if the exchange rate is 95.61 yen to 1$US in 6 months? Why? c. How many U.S. dollars will be needed to pay for the goods if the exchange rate is 95.61yen to 1$US? d. Does the Japanese exporter or the U.S. importer bear the exchange rate risk ? Why? e. Describe 3 ways in which the U.S. company can reduce exchange rate risk. A 56 B C D E F G A 1 B C D E F Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Question 5. (15 points) Taylor Corporation wants to raise $40 million. Its stock price is now $25 per share. The new issue will be priced at $23 per share. The company will incur expenses of $1 million. The underwriters' compensation will be 8% of the issue price and the underwriter will incur expenses of $1.2 million. a. How many shares of stock must be sold for the company to net $40 million after costs and expenses? b. Calculate the profit or loss for the investment banker? c. Explain the terms "best efforts basis" and "underwriting" as they are used in investment banking. . d. What is the most important single reason for a firm to go public. e. What is the most important single reason for a firm NOT to go public. A 56 B C D E F A 1 B C D E F Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 The company appears to be carrying excess inventory and 7 Question 6. (15 points) Andiola Corporation is evaluating whether to lease or purchase equipment. Its tax rate is financing extensively with debt. Bank borrowings are already high, 8 30 percent. The purchase price is $1.2 million, required modications to the equipment will cost $50,000. The and the liquidity situation is poor. On the basis of these 9 company would depreciate the equipment over 4 years, using straight-line depreciation. A 4-year lease calls for a observations, the the beginning of denied, If the equipment is purchased, 10 payment of $350,000 atloan should beeach year. and the treasurer should the company will borrow from be advised to seek permanent capital, especially equity capital. 11 its bank at an interest rate of 10 percent. 12 13 a. Calculate the cost of purchasing the equipment. 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 b. Calculate the cost of leasing the equipment. 38 39 40 41 42 43 44 45 46 47 48 49 50 c. Calculate the net advantage to leasing. Should the company purchase or lease the equipment? c. Calculate the net advantage to leasing. Should the company purchase or lease the equipment? A B C D E 51 52 53 54 55 56 57 58 F A 1 B C D E F G Name______________________________________ 3 Mid-term Examination FINC 5880 4 Session 5 2 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Question 7 (15 points) How might Wal-Mart (or another company) take advantage of each of the following: Do not merely provide a definition. Provide a specific example of each a. Flexibility option b. Growth option c. Investment timing option d. Abandonment option e. Decision-tree analysis A 51 52 53 54 55 B C D E F G
