Question

In: Finance

The Parker Group, a leading producer of custom home electronic accessories, has hired you to estimate...

The Parker Group, a leading producer of custom home electronic accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets The stock is currently selling for $15.25 per share, and its noncallable $1,000 par value, 20-year, 7.25% bonds with semiannual payments are selling for $875.00. The beta is 1.25, the yield on a 6-month Treasury bill is 3.50%, and the yield on a 20-year Treasury bond is 5.50%. The required return on the stock market is 11.50%, but the market has had an average annual return of 14.50% during the past 5 years. The firm's tax rate is 40%. What is the best estimate of the after-tax cost of debt? Question 8 options:

a) 5.03%

b) 5.14%

c) 5.40%

d) 5.67%

Solutions

Expert Solution

Answer: b) 5.14%

There are a total of 40 periods since coupon payments are half yearly, Following figures show cash flows and present value of cash flows for these 40 years.

PV= $875

Coupon 1 = Coupon 2 = Coupon 3 = ............= Coupon 40 = 1000*7.25%/2 = $36.25

FV = $1000

Substituting these values in the above equation and solving for r, we get r= 4.28%. This is equal to pre-tax cost of debt.

Goal Seek function can be used in Excel to solve for r.

4.28% is the half yearly rate, annual rate = 4.28%*2 = 8.57%

After-tax annual cost of debt = 8.57% * (1-40%) = 5.14%

To calculate the PV, PV function in Excel can also be used.

PV(4.28%,40,36.25,1000).

r can be substituted as a guess value, say 5%, initially. Then Foal Seek can be used to get a PV of $875


Related Solutions

The Stetson Group, a leading producer of custom women's accessories, has hired you to estimate the...
The Stetson Group, a leading producer of custom women's accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below.   Assets Current assets $7,780,000 Net plant, property, and equipment 131,230,000 Total assets $139,010,000   Liabilities and Equity Accounts payable $10,003,000 Accruals 9,007,000 Current liabilities $19,010,000 Long-term debt (30,000 bonds, $1,000 par value) 30,000,000 Total liabilities $49,010,000 Common stock (10,000,000 shares) 40,000,000 Retained earnings 50,000,000 Total shareholders' equity 90,000,000 Total...
Suppose you have been hired by Raytheon, the world's leading producer of defense equipments, as a...
Suppose you have been hired by Raytheon, the world's leading producer of defense equipments, as a financial consultant. The company is looking at setting up a manufacturing plant to produce a new line of defense equipments,.The new manufacturing plant will cost $12 million to build. The manufacturing plant has an eight-year depreciation tax life and a six year useful life. Raytheon uses straight-line depreciation. At the end of the project (i.e., the end of Year 6), the plant can be...
Sinaloa Appliance, Inc., a private firm that manufactures home appliances, has hired you to estimate the...
Sinaloa Appliance, Inc., a private firm that manufactures home appliances, has hired you to estimate the company’s beta. You have obtained the following equity betas for publicly traded firms that also manufacture home appliances. ($ millions) Firm Beta Debt Market Value of Equity iRobot 0.93 $0 $ 3,190 Middleby's 1.88 759 7,490 National Presto 0.13 0 838 Newell Brands 1.08 11,938 26,670 Whirlpool 1.78 4,515 14,190 a. Estimate an asset beta for Sinaloa Appliance.
After completing your degree you are hired by a world-leading drug company that has developed a...
After completing your degree you are hired by a world-leading drug company that has developed a new drug called EX-factor that enhances basal (resting) levels of fatty acid oxidation in skeletal muscle. EX-factor has undergone extensive safety testing and there are no reported side effects. It has been shown to “boost” the amount of fatty acids that are completely oxidized in skeletal muscle by ~30% at rest and is therefore being touted as “exercise in a pill”. The company has...
Sinaloa Appliance, Inc., a private firm that manufactures homeappliances, has hired you to estimate the...
Sinaloa Appliance, Inc., a private firm that manufactures home appliances, has hired you to estimate the company’s beta. You have obtained the following equity betas for publicly traded firms that also manufacture home appliances.($ millions)FirmBetaDebtMarket Value of EquityiRobot0.87$0$2890Middleby's1.827417,370National Presto0.070772Newell Brands1.0211,90826,070Whirlpool1.724,48513,770a. Estimate an asset beta for Sinaloa Appliance.
Assume that you have been hired as a consultant by Clabber Girl, a major producer of...
Assume that you have been hired as a consultant by Clabber Girl, a major producer of home kitchen goods, to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Liabilities and Equity (Reduced for simplicity; shows book-values only) Long-term debt (40,000 bonds, $1,000 par value) $40,000,000 Common stock (10,000,000 shares) $30,000,000 The stock is currently selling for $15.25 per share, and its noncallable $1,000 par value, 20-year, 1.70% bonds with semiannual...
Assume that you have been hired as a consultant by CGT, a major producer of chemicals...
Assume that you have been hired as a consultant by CGT, a major producer of chemicals and plastics, including plastic grocery bags, styrofoam cups, and fertilizers, to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below.   Assets Current assets $38,000,000 Net plant, property, and equipment $101,000,000 Total assets $139,000,000 Liabilities and Equity Accounts payable $10,000,000 Accruals $9,000,000 Current liabilities $19,000,000 Long-term debt (40,000 bonds, $1,000 par value) $40,000,000 Total liabilities $59,000,000...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and...
You are a newly hired analyst at one of the leading bond rating agencies, Standard and Poor’s. The first day on the job you are asked to rate the following bonds: a. The bonds of an Internet start-up company b. The bonds of a country with a history of inflation and political instability c. The bonds of company operating a network of toll highways d. The bonds of a company with a long illustrious history that has fallen on hard...
the leading causes of death in the world. Pretend you have been hired by the WHO...
the leading causes of death in the world. Pretend you have been hired by the WHO to address one of these causes. Write a one-page, typed paper discussing the cause of death you have chosen to address, why you chose it, and three ideas you have for addressing it. You will need to do some additional reading to determine health promoting activities/strategies that reduce the risk of your choice.  
You have been hired by a home security company to design and implement a home alarm...
You have been hired by a home security company to design and implement a home alarm system. The logic of the system is as follows: once the alarm system has been armed, it is to sound if the front door is opened, the back door is opened or either of two windows is opened (you can assume there are only two windows). Design the necessary circuit to implement the situation described above. Your circuit should have five inputs (A =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT