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...
The Collins Group, a leading producer of custom automobile accessories, has hired you to estimate the...
The Collins Group, a leading producer of custom automobile 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 $ 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 Common stock (10,000,000 shares) 30,000,000 Retained earnings...
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...
1. Individual Problems 14-1 Suppose Mattel, the producer of Barbie dolls and accessories (sold separately), has...
1. Individual Problems 14-1 Suppose Mattel, the producer of Barbie dolls and accessories (sold separately), has two types of consumers who purchase its dolls: low-value consumers and high-value consumers. Each of the low-value consumers tends to purchase one doll and one accessory, with a total willingness to pay of $56. Each of the high-value consumers buys one doll and two accessories and is willing to pay $109 in total. Mattel is currently considering two pricing strategies: • Strategy 1: Sell...
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