I only need help with the last two questions please Percentages need to be entered in decimal format, for instance 3% would be entered as .03. Ybor City Tobacco Company has for many years enjoyed a moderate, but stable growth in sales and earnings. In recent times, however, cigar consumption and consequently Ybor's sales have been falling, primarily because of the public's greater awareness of the health dangers associated with smoking. Anticipating further declines in tobacco sales in the future, Ybor's management hopes eventually to move almost entirely out of the tobacco business and into a newly developed, diversified product line in growth-oriented industries. The company is especially interested in the prospects of pollution-control devices, because its research department has already done much work on the problems of filtering smoke. Right now, the company estimates that an investment of $15 million will be necessary to purchase new facilities and to begin production of these products, but the investment could earn a return of about 18% within a short time. The only other available investment opportunity costs $6 million and is expected to return about 10.4%. The company is expected to pay a $3.00 dividend on its three million outstanding shares, the same as its dividend last year. The directors could be persuaded to change the dividend if there are good reasons for doing so. Total earning after taxes for the year are expected to be $14.25 million; the common stock is currently selling for $56.25 per share; the firm's target debt/assets ratio is 45%; and its marginal tax rate is 40%. The costs of various forms of financing are as follows: (This information is shown on the spreadsheet provided.) New bonds, rd = 11% (the before-tax rate) New common stock sold at $56.25 per share will net $51.25 Required rate of return on retained earnings (cost of equity), rs =14% Identify Ybor's expected payout ratio, the weighted average cost of capital (WACC) before the break, and the WACC percentage after the break. How large should Ybor's capital budget be for the year? Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.) Assume that Ybor's management is considering a change in the firm's capital structure to include more debt. Management would therefore like to analyze the effects of an increase in the debt ratio to 60%. The treasurer believes that such a move would cause lenders to increase the required rate of return on new bonds (rd) to 12% and that cost of equity (rs) would rise to 14.5%. Explain how this change affects the optimal capital budget. Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.) Considering the information presented in Question 3, if rs rose to 16%, would the low-return project be acceptable? (Refer to the Optimal Capital Budget under Key Outputs.) Considering the information presented in Question 4, would the project selection be affected if the proposed dividend was eliminated ($0)? (Refer to the Optimal Capital Budget under Key Outputs.

I only need help with the last two questions please Percentages need to be entered in decimal format, for instance 3% would be entered as .03. Ybor City Tobacco Company has for many years enjoyed a moderate, but stable growth in sales and earnings. In recent times, however, cigar consumption and consequently Ybor's sales have been falling, primarily because of the public's greater awareness of the health dangers associated with smoking. Anticipating further declines in tobacco sales in the future, Ybor's management hopes eventually to move almost entirely out of the tobacco business and into a newly developed, diversified product line in growth-oriented industries. The company is especially interested in the prospects of pollution-control devices, because its research department has already done much work on the problems of filtering smoke. Right now, the company estimates that an investment of $15 million will be necessary to purchase new facilities and to begin production of these products, but the investment could earn a return of about 18% within a short time. The only other available investment opportunity costs $6 million and is expected to return about 10.4%. The company is expected to pay a $3.00 dividend on its three million outstanding shares, the same as its dividend last year. The directors could be persuaded to change the dividend if there are good reasons for doing so. Total earning after taxes for the year are expected to be $14.25 million; the common stock is currently selling for $56.25 per share; the firm's target debt/assets ratio is 45%; and its marginal tax rate is 40%. The costs of various forms of financing are as follows: (This information is shown on the spreadsheet provided.) New bonds, rd = 11% (the before-tax rate) New common stock sold at $56.25 per share will net $51.25 Required rate of return on retained earnings (cost of equity), rs =14% Identify Ybor's expected payout ratio, the weighted average cost of capital (WACC) before the break, and the WACC percentage after the break. How large should Ybor's capital budget be for the year? Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.) Assume that Ybor's management is considering a change in the firm's capital structure to include more debt. Management would therefore like to analyze the effects of an increase in the debt ratio to 60%. The treasurer believes that such a move would cause lenders to increase the required rate of return on new bonds (rd) to 12% and that cost of equity (rs) would rise to 14.5%. Explain how this change affects the optimal capital budget. Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.) Considering the information presented in Question 3, if rs rose to 16%, would the low-return project be acceptable? (Refer to the Optimal Capital Budget under Key Outputs.) Considering the information presented in Question 4, would the project selection be affected if the proposed dividend was eliminated ($0)? (Refer to the Optimal Capital Budget under Key Outputs.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Question

I only need help with the last two questions please

Percentages need to be entered in decimal format, for instance 3% would be entered as .03.

Ybor City Tobacco Company has for many years enjoyed a moderate, but stable growth in sales and earnings. In recent times, however, cigar consumption and consequently Ybor's sales have been falling, primarily because of the public's greater awareness of the health dangers associated with smoking. Anticipating further declines in tobacco sales in the future, Ybor's management hopes eventually to move almost entirely out of the tobacco business and into a newly developed, diversified product line in growth-oriented industries. The company is especially interested in the prospects of pollution-control devices, because its research department has already done much work on the problems of filtering smoke. Right now, the company estimates that an investment of $15 million will be necessary to purchase new facilities and to begin production of these products, but the investment could earn a return of about 18% within a short time. The only other available investment opportunity costs $6 million and is expected to return about 10.4%.

The company is expected to pay a $3.00 dividend on its three million outstanding shares, the same as its dividend last year. The directors could be persuaded to change the dividend if there are good reasons for doing so. Total earning after taxes for the year are expected to be $14.25 million; the common stock is currently selling for $56.25 per share; the firm's target debt/assets ratio is 45%; and its marginal tax rate is 40%. The costs of various forms of financing are as follows: (This information is shown on the spreadsheet provided.)

New bonds, r_d = 11% (the before-tax rate)
New common stock sold at $56.25 per share will net $51.25
Required rate of return on retained earnings (cost of equity), r_s =14%

Identify Ybor's expected payout ratio, the weighted average cost of capital (WACC) before the break, and the WACC percentage after the break.
How large should Ybor's capital budget be for the year? Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.)
Assume that Ybor's management is considering a change in the firm's capital structure to include more debt. Management would therefore like to analyze the effects of an increase in the debt ratio to 60%. The treasurer believes that such a move would cause lenders to increase the required rate of return on new bonds (r_d) to 12% and that cost of equity (r_s) would rise to 14.5%. Explain how this change affects the optimal capital budget. Which project(s) can be accepted? (Refer to the Optimal Capital Budget under Key Outputs.)
Considering the information presented in Question 3, if r_s rose to 16%, would the low-return project be acceptable? (Refer to the Optimal Capital Budget under Key Outputs.)
Considering the information presented in Question 4, would the project selection be affected if the proposed dividend was eliminated ($0)? (Refer to the Optimal Capital Budget under Key Outputs.

INPUT DATA:
KEY OUTPUTS:
$3.00
$3.00
3,000,000
$14,250,000
$56.25
Previous dividend:
Expected payout:
63.16%
Proposed dividend:
Shares outstanding:
Earnings:
Current stock price:
WACC before break:
10.67%
WACC after break:
10.96%
Break point with $3 div:
Break point with $0 div:
$9,545,455
$25,909,091
Debt ratio:
45.00%
11.00%
Cost of new debt, rd:
Net price new stock
Cost of equity, rs
Optimal capital budget:
Project
$51.25
IRR
Cost
$15,000,000
$0
14.00%
1
18.00%
Tax rate:
40.00%
0.00%
Total capital budget
$15,000,000
Project
Cost
IRR
Cum. Cost
$15,000,000
$6,000,000
$21,000,000
$15,000,000
$21,000,000
1
18.00%
2
10.40%
Total
MODEL-GENERATED DATA:
With proposed dividend:
Earnings
14,250,000
(9,000,000)
5,250,000
Dividend
Retained earnings
4,295,455
9,545,455
Borrow
Financing before break
Marginal cost of capital up to break point:
After-Tax
Weighted
Component
Percent
Cost
Cost
Debt
45%
0.0660
0.0297
RE
55%
0.1400
0.0770
0.1067
Marginal cost of capital above break point:
After-Tax
Weighted
Cost
Component
Percent
Cost
Debt
45%
0.0660
0.0297
RE
55%
0.1452
0.0799
0.1096
Capital cost:
Capital cost
10.67%
Range of financing
1
9,545,455
9,545,456
50,000,000
10.67%
10.96%
10.96%
Optimal capital budget:
Project
IRR
Cost
1
18.00%
15,000,000
0.00%
15,000,000

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.