FINC 5000, Problems Assignment Fall 2, 2014

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 persons 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.
—————————–

Page 1

FINC 5000, Fall 2, 2013

Question 1: (Cost of Capital) 8 points
You are provided the following information on a company. The total market value is $40 million.
The companys capital structure, shown here, is considered to be optimal.
Market Value
Bonds, $1000 par, 6% coupon, 4% YTM
Preferred Stock, 3%, $100 par, 100,000 shares @ $70 per share
Common Stock, 100,000 shares @ $230 per share

$10,000,000
$7,000,000
$23,000,000

a. What is the after-tax cost of debt? (assume the companys 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
0 (Now)
1
2
3
4

Project X
($30,000)
11,000
10,000
9,000
8,000

Project Y
($30,000)
4,000
8,000
12,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 projects 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?

Page 2

FINC 5000, Fall 2, 2013

Question 3: (Capital Structure) 8 points
Dick & Jane Childrens Books is trying to determine its optimal capital structure. The companys
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)
10%
20%
30%
40%
50%

Percent financed
with equity (Ws)
90%
80%
70%
60%
50%

Debt to Equity
(D/S)
.11
.25
.43
.67
1.0

Bond Rating
AAA
AA
A
BB
B

Before-tax cost
of debt (BT Rd)
3.0%
4.0%
4.5%
5.0%
6.0%

The companys 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 companys optimal capital structure, and what is the
firms 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?

Page 3

FINC 5000, Fall 2, 2014

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

Click here to have a similar paper done for you by one of our writers within the set deadline at a discounted

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

FINC 5000, Problems Assignment Fall 2, 2014

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 persons 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.
—————————–

Page 1

FINC 5000, Fall 2, 2013

Question 1: (Cost of Capital) 8 points
You are provided the following information on a company. The total market value is $40 million.
The companys capital structure, shown here, is considered to be optimal.
Market Value
Bonds, $1000 par, 6% coupon, 4% YTM
Preferred Stock, 3%, $100 par, 100,000 shares @ $70 per share
Common Stock, 100,000 shares @ $230 per share

$10,000,000
$7,000,000
$23,000,000

a. What is the after-tax cost of debt? (assume the companys 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
0 (Now)
1
2
3
4

Project X
($30,000)
11,000
10,000
9,000
8,000

Project Y
($30,000)
4,000
8,000
12,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 projects 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?

Page 2

FINC 5000, Fall 2, 2013

Question 3: (Capital Structure) 8 points
Dick & Jane Childrens Books is trying to determine its optimal capital structure. The companys
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)
10%
20%
30%
40%
50%

Percent financed
with equity (Ws)
90%
80%
70%
60%
50%

Debt to Equity
(D/S)
.11
.25
.43
.67
1.0

Bond Rating
AAA
AA
A
BB
B

Before-tax cost
of debt (BT Rd)
3.0%
4.0%
4.5%
5.0%
6.0%

The companys 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 companys optimal capital structure, and what is the
firms 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?

Page 3

FINC 5000, Fall 2, 2014

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

Click here to have a similar paper done for you by one of our writers within the set deadline at a discounted

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now