please see attached

Instructions:

I NEED TO SEE YOUR EXCEL SKILLS . For all the questions that require estimation, the answer cell (s) should be HIGHLIGHTED IN GREEN, and such cell(s) should contain the corresponding formula(s).

You will not receive credit if an answer cell has no formulas in it.

For the questions that don’t require estimations, you should insert a text box to write your answer. For questions requiring to draw a diagram, you may just insert it or copy and paste it.

Make sure you label your answers. USE ONE SHEET PER QUESTION, each sheet should be named Question_1, Question_2 and so forth.

1. Suppose the stock price is $25, there are 1.5 million shares of stock, the firm has $13.5 million of preferred stock, and $62 million of debt. Estimate

a. The total value

b. The WACC weights.

i. Write the WACC formula with the corresponding weights.

2. Estimate the cost of debt. Assume that you are issuing a 10 yr, 6% semiannual bond that sells for $1,015.72. (Use the excel formula)

a. Illustrate the before-tax cost of debt by showing the corresponding time line.

b. If the tax rate is 40%, what is the after-tax cost of debt?

c. What role do flotation costs play in the cost of debt? Explain.

3. Estimate the annual and quarterly cost of issuing preferred stock (use the cost of preferred stock formula studied in class). Assume the price of preferred stock is $104.35, 4% dividend,

$100 par (face) value and flotation costs (F) of 5%.

a. Draw the time line of preferred stock. Remember that dividends are paid quarterly.

b. Make sure your result is correct by estimating the cost of issuing preferred stock using the corresponding excel formula.

4. Use the CAPM Cost of Equity model to determine the cost of issuing common stock. Assume that the risk free rate is 3.2%, the market risk premium is 4% and the estimate of beta is 0.98.

a. Re write the WACC formula, substituting the values you have found in all the previous questions.

b. What is the hurdle rate? What does it mean? Explain.

5. Define an agency relationship.

a. If you are the only employee, and only your money is invested in the business, would any agency problems exist? Explain.

b. Would hiring additional people create agency problems? Explain.

c. Define the concept of Corporate Governance.

6. Suppose the government is running a budget deficit (previously the budget was balanced). Explain in detail what happens in the following markets:

a. Loanable Funds Market (draw a diagram)

b. Net Capital Outflow (draw a diagram)

c. Foreign-Currency Exchange (draw a diagram)

d. US Net exports

7. The January 29, 2014 nominal exchange rate for the following currencies were as follows:

8. Find the indirect quotation for December 4, 2015 and determine whether the currencies have appreciated or depreciated, and by how much.

a. For each currency, explain what is happening in the Foreign-Currency exchange market and in the trade balance between the US and each of these countries.

9. A Big Mac costs $3.50 in U.S., 60 pesos in Mexico. The nominal exchange rate is e = 17.05 pesos per $USD. Compute the real exchange rate.

a. Does the real exchange rate follows the “law of one price”? (i.e. follows the Purchasing Power Parity condition?). If it does not, what would be exchange rate according to the PPP condition? Explain.

b. If the CPI inflation rate is 12% in Mexico and 2% in the US, what will happen to the exchange rate? Explain.