FINC 5000, Fall 2, 2013 - MID - SOLUTION

profileRSaleem
 (Not rated)
 (Not rated)
Chat

Problems

 

 Directions:  You may complete the exam in Excel or in Word.

  Reminders:

 

  In Excel, use formulas in the spreadsheet to solve the problems so your instructor can see how you arrived at your answers.  If your instructor cannot determine how an answer was calculated, no credit will be given for that answer.  If a question calls for a text answer, such as a few sentences or a short paragraph, create a text box on the spreadsheet and enter your text in the box.  In Word, be sure to show clearly how you arrived at your answers by entering the calculations as text.  If your instructor cannot determine how an answer was calculated, no credit will be given for that answer.

 

  Be sure to complete the exam by the deadline posted for it.  Late submissions without good reason will be assessed a penalty.

 

  Be sure to put your name on the spreadsheet or in the Word document.

 

  You must complete the exam by yourself, without assistance from anyone else.  Copying and pasting from another person’s spreadsheet or Word document or from the Internet is not allowed.  Also, you must not give assistance to anyone else.  That means you may not send your files, or parts of your files to anyone else and you may not receive files, or parts of files from anyone else.

 

  Ask your instructor if you have any questions.

 Exam problems begin on the next page.  There are five questions worth a total of 40 points.


Question 1:  (Cost of Capital)  8 points

 

You are provided the following information on a company. The total market value is $40 million. The company’s capital structure, shown here, is considered to be optimal.

                                                                                                             Market Value

 

Bonds, $1000 par, 6% coupon, 4% YTM                                           $10,000,000

Preferred Stock, 3%, $100 par, 100,000 shares @ $70 per share         $7,000,000

Common Stock, 100,000 shares @ $230 per share                            $23,000,000

 

a.  What is the after-tax cost of debt?  (assume the company’s effective tax rate = 40%)

 

b.  Assuming a $3 dividend paid annually, what is the required return for preferred shareholders (i.e. component cost of preferred stock)?  (assume floatation costs = $0.00)

 

c.  Assuming the risk-free rate is 1%, the expected return on the stock market is 7%, and the company's beta is 1.1, what is the required return for common stockholders (i.e., component cost of common stock)?

 

d.  What is the company's weighted average cost of capital (WACC)?

 

Question 2:  (Capital Budgeting)  10 points

 

It's time to decide how to use the money your firm is expected to make this year.  Two investment opportunities are available, with net cash flows as follows:

 

                                    Year                Project X         Project Y

                                     0 (Now)         ($30,000)        ($30,000)

                                     1                       11,000              4,000

                                     2                       10,000              8,000

                                     3                         9,000           12,000

                                     4                         8,000           16,000

 

a.  Calculate each project's Net Present Value (NPV), assuming your firm's weighted average cost of capital (WACC) is 6%

 

b.  Calculate each project’s Internal rate of Return (IRR).

 

c.  Plot NPV profiles for both projects on a graph).

 

d.  Assuming that your firm's WACC is 6%:

 

            (1) If the projects are independent which one(s) should be accepted?

            (2) If the projects are mutually exclusive which one(s) should be accepted?

 

Question 3:  (Capital Structure)  8 points

 

Dick & Jane Children’s Books is trying to determine its optimal capital structure. The company’s capital structure consists of debt and common stock. In order to estimate the cost of debt, the company has produced the following table:

 

Percent financed with debt (Wd)

Percent financed with equity (Ws)

Debt to Equity (D/S)

Bond Rating

Before-tax cost of debt (BT Rd)

10%

90%

.11

AAA

3.0%

20%

80%

.25

AA

4.0%

30%

70%

.43

A

4.5%

40%

60%

.67

BB

5.0%

50%

50%

1.0

B

6.0%

 

The company’s tax rate, T, is 35 percent. The company uses the CAPM to estimate its cost of common equity, Rs. The risk-free rate is 1 percent and the estimated return on the stock market is 6 percent. Dick & Jane estimates that if it had no debt its beta would be 0.9. (i.e., its “unlevered beta,” bU, equals 0.9.)

 

On the basis of this information, what is the company’s optimal capital structure, and what is the firm’s cost of capital at this optimal capital structure?

 

Question 4:  (Forecasting)  8 points

 

A firm has the following balance sheet:

            Cash                          $  200     Accounts payable               $ 200

            Accounts receivable      200     Notes payable                       400

            Inventory                       200      Long-term debt                    800

            Fixed assets                1,800     Common stock                      800

                                                             Retained earnings                  200

            Total assets              $2,400     Total liabilities & Equity  $2,400

 

Sales for the year just ended were $5,000, and fixed assets were used at 80 percent of capacity.  Current assets and accounts payable vary directly with sales.  Sales are expected to grow by 20 percent next year, the expected net profit margin is 5 percent, and the dividend payout ratio is 50 percent.

 

How much additional funds (AFN) will be needed next year, if any?

 

 Question 5:  Working Capital Management  6 points

 

The Roosterman Corporation has an inventory conversion period of 50 days, a receivables collection period of 40 days, and a payables deferral period of 30 days.  Its annual credit sales are $5,000,000, and its annual cost of goods sold (COGS) is 60% of sales.

 

a.  What is the length of the firm's cash conversion cycle?

 

b.  What is the firm's investment in accounts receivable?

 

c.  What is the company's inventory turnover ratio?

 

d.  Identify three ways in which the company could  reduce its cash conversion cycle?

 

e.  What are the possible risks of reducing the cash conversion cycle per your recommendations in part d?

    • 12 years ago
    Perfect Solution - Well-EXPLAINED
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      sol-fin.xlsx