Question

In: Finance

Tata Corp. needs to purchase new plastic moulding machines to meet the demand for its product....

Tata Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $8,927,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $1,894,864 annually for the next 3 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5. The firm's beta is 1.71, the risk free rate is 1.88% and the expected market return is 7.65%. Tata Corp.'s semi-annual bonds have 8.10% coupons, 25 years to maturity, and a quoted price of 108.410. Assume the firm's tax rate is 34%. The firm's last 5 dividends (the last in the list is D0) are 1.23, 1.56, 1.67, 2.17, and 2.72. Its current market price is $162.71.
1. What is Tata Corp.'s historic rate of dividend growth based on the last 5 dividends?
2. What is the firm's required return on equity based on the DDM model?
3. What is the firm's required return in equity based on the CAPM?
4. What is the firm's after-tax cost of debt?
5. What is the firm's WACC?
Short Answer A : Should the firm purchase the new equipment? (hint: you will need to make an additional calculation.)
Short Answer B: In calculating the firm's WACC, you had to make a couple of judgment calls. What were they and briefly discuss why you made the decisions you did.
Short Answer C: Assume that there are some large cleanup and disposal costs of $892,700 at the end of the project (in year 4). Explain in a sentence or two how this impacts the calculation of the internal rate of return? Note that no additional calculation is required to answer this question.
Short Answer D: Briefly explain which decision rule is best when trying to make a capital budget decision in this scenario where there are cleanup costs at the end of the project.
Short Answer E: Tata Corp. is changing its capital structure (target debt to equity ratio). In calculating WACC, we assume this only changes the weights used in the calculation. What else might change in the WACC calculation, why would it change, and what factors would influence this?

Solutions

Expert Solution

1]

Dividend now = dividend 5 years ago * (1 + growth rate)5

$2.72 = $1.23 * (1 + growth rate)5

growth rate = ($2.72 / $1.23)1/5 - 1

growth rate = 17.20%

2]

required return = (current dividend * (1 + growth rate) / current market price) + growth rate

required return = ($2.72 * (1 + 17.20%) / $162.71) + 17.20%

required return = 19.16%

3]

required return = risk free rate + (beta * (expected market return - risk free rate))

required return = 1.88% + (1.71 * (7.65% - 1.88%))

required return = 11.75%

4]

after tax cost of debt = YTM of bond * (1 - tax rate)

YTM is calculated using RATE function in Excel with these inputs :

nper = 25*2 (25 years to maturity with 2 semiannual coupon payments each year)

pmt = 100 * 8.1% / 2 (semiannual coupon payment = face value * annual coupon rate / 2. This is a positive figure as it is an inflow to the bondholder)

pv = -108.41 (current bond price. This is a negative figure as it is an outflow to the buyer of the bond)

fv = 100 (face value of the bond receivable on maturity. This is a positive figure as it is an inflow to the bondholder)

The RATE calculated is the semiannual YTM. To calculate the annual YTM, we multiply by 2. Annual YTM is 7.36%

after tax cost of debt = YTM * (1 - tax rate)

after tax cost of debt = 7.36% * (1 - 34%) ==> 4.86%

5]

WACC = (weight of debt * cost of debt) + (weight of equity * cost of equity)

The weights of debt and equity are taken based on the target capital structure, since it wants to quickly change its debt to equity ratio to 1.5.

Debt equity ratio = 1.5

Weight of debt = 1.5 / (1 + 1.5) = 1.5 / 2.5 = 0.6

Weight of equity = 1 / (1 + 1.5) = 1 / 2.5 = 0.4

cost of equity = average of DDM and CAPM methods = (19.16% + 11.75%) / 2 = 15.45%

WACC = (weight of debt * cost of debt) + (weight of equity * cost of equity)

WACC = (0.6 * 4.86%) + (0.4 * 15.45%)

WACC = 9.10%


Related Solutions

Palestine Corp. needs to purchase new plastic moulding machines to meet the demand for its product....
Palestine Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $3,724,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $700,601 annually for the next 6 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5. The firm's...
Question 3: Coca-Cola Corp. needs to purchase new plastic moulding machines to meet the demand for...
Question 3: Coca-Cola Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $3,028,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $611,671 annually for the next 5 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5....
Question 3: Coca-Cola Corp. needs to purchase new plastic moulding machines to meet the demand for...
Question 3: Coca-Cola Corp. needs to purchase new plastic moulding machines to meet the demand for its product. The cost of the equipment is $3,028,000. It is estimated that the firm will increase after tax cash flow (ATCF) by $611,671 annually for the next 5 years. The firm is financed with 40% debt and 60% equity, both based on current market values, though the firm has announced that it wants to quickly change its debt to equity ratio to 1.5....
A company needs to purchase several new machines to meet its future production needs. It can...
A company needs to purchase several new machines to meet its future production needs. It can purchase three different types of machines A,B,andC. Each machine A costs $80,000 and requires 2,000 square feet of floor space. Each machine B costs$50,000 and requires 3,000 square feet of floor space. Each machine C costs $40,000 and requires 5,000 square feet of floor space. The machines can produce 200, 250 and 350 units per day respectively. The plant can only afford $500,000 for...
Hashem Oghli is a manufacturer of plastic products. Unfortunately, one of the moulding machines is out...
Hashem Oghli is a manufacturer of plastic products. Unfortunately, one of the moulding machines is out of order and needs to be replaced. After receiving quotes from various suppliers, you find two types of moulding machines that are suitable. Type A moulding machine is a high-end machine; it has a higher purchase price but makes higher quality products that sell better on the market and bring more revenue. Type B moulding machine is lower-end; it is cheaper, but produces lower...
Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’,...
Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’, which is used in food processing. A new machine, with a useful life of four years and a maximum output of 600,000 kg of Quago per year, could be bought for $800,000, payable immediately. The scrap value of the machine after four years would be $30,000. Forecast demand and production of Quago over the next four years is as follows: Year 1 2 3...
 A firm is considering renewing its equipment to meet increased demand for its product. The cost...
 A firm is considering renewing its equipment to meet increased demand for its product. The cost of equipment modifications is $ 1.88 million plus $ 111,000 in installation costs. The firm will depreciate the equipment modifications under​ MACRS, using a​ 5-year recovery period​. Additional sales revenue from the renewal should amount to $ 1.17 million per​ year, and additional operating expenses and other costs​ (excluding depreciation and​ interest) will amount to 40 % of the additional sales. The firm is...
Taylor United is considering overhauling its equipment to meet increased demand for its product. The cost...
Taylor United is considering overhauling its equipment to meet increased demand for its product. The cost of equipment overhaul is $3.88 million, plus $213,415.00 in installation costs. The firm will straight-line depreciate the equipment to zero using a 5-year recovery period. Additional sales from the overhaul should amount to $207,575.00 per year, and additional operating expenses and other costs (excluding depreciation) will amount to 36.00% of the additional sales. The firm has an ordinary tax rate of 34.00%. What is...
Wesson United is considering updating its equipment to meet increased demand for its product. The cost...
Wesson United is considering updating its equipment to meet increased demand for its product. The cost of the equipment update is $380,000, plus $20,000 in installation costs. Due to the increased sales, there will be an additional $40,000 working capital needed. The company will depreciate the equipment to zero over its 5 year life using a straight-line depreciation method. Additional sales revenue from the modifications should amount of $220,000 per year, and additional operating expenses and other costs (excluding depreciation)...
A marketing director needs to estimate the demand for a new product and she obtains the...
A marketing director needs to estimate the demand for a new product and she obtains the pessimistic, the optimistic and the most likely estimates of the demand from the company's store manager. What probability distribution should be used to describe this random variable in computer simulation? Uniform distribution Triangular distribution Exponential distribution Normal distribution Binomial distribution QUESTION Which of the following statements is true with regard to uncertain variables in RSPE software? Each uncertain variable must have a discrete probability...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT