Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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.)
1. There are a number of instructions with which you should be familiar to use these computerized models. These instructions appear in a separate worksheet labeled INSTRUCTIONS. If you have not already done so, you should read these instructions now. To read these instructions, click on the worksheet labeled INSTRUCTIONS 2. Only two projects can be analyzed with this model, and those projects must be entered in order of higher IRR first and the lower IRR next 3. The easiest way to work on this problem is to make the required changes in the input section, observe the change in yield record the change, and then answer the questions as required. INPUT DATA: KEY OUTPUTS: Previous dividend: Proposed dividend: Shares outstanding Earnings: Current stock price Debt ratio Cost of new debt, rd: Net price new stock Cost of equity.rs Tax rate: $3.00 $3.00 3,000,000 $14,250,000 $56.25 45.00% 11.00% $51.25 14.00% 40.00% Expected payout 63.16% WACC before break 10.67% WACC after break 10.96% Breakpoint with $3 div. $9.545.455 Break point with $0 di $25.909.091 Optimal capital budget Project IRR Cost 1 18.00% $15.000.000 0.00% $0 Total capital budget $15.000.000 Cum. Cost $15.000.000 $21.000.000 Project 1 2 Total Cost $15.000.000 $6.000.000 $21,000,000 IRR 18.00% 10.40% MODEL-GENERATED DATA With proposed dividend Earings Dividend Retained earnings Borrow Financing before break 14.250,000 (9.000.000) 5.250,000 4.295.455 9.545.455 Marginal cost of capital up to break point: Component Percent Debt 45% RE 55% After-Tex Cost 0.0660 0.1400 Weighted Cost 0.0770 0.1067 Marginal cost of capital above break point: Component Percent Debt RE 55% Weighted Cost After-Tax Cost 0.0660 0.1452 0.0799 0.1096 Capital cost: Range of financing 1 9,545,455 9,545,456 50.000.000 Capital cost 10.67% 10.67% 10.96% 10.96% Optimal capital budget Project 1 0 IRR 18.00% 0.00% Cost 15,000,000 . 15,000,000
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.)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/668eb98c96b34_644668eb98c0869e.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started