What are the current yield and yield-to-maturity

Reference no: EM13202223

Financial Modelling

PowerTool is the largest US manufacturer of industrial hand tools. Its sales force is strong but clients have complained that marketing is weak. The industrial tool business is mature, with little or no future expected growth.

PowerTool has acquired Fenton Manufacturing, a small innovative company whose sales are entirely in the retail tool market. The retail tool market is expected to grow at a 5% annual rate.

Fenton recently developed a patented line of rechargeable home power tools that displayed strong potential in test markets. Fenton expects this line to generate 50 percent of its sales within five years, but lacks a sales force to market this product line. Jerry Fenton, the company's founder, recently retired.

PowerTool management is highly respected and the company has experienced little management turnover. However, the Chief Executive Officer has announced her retirement after 18 years of service, and will be replaced by the current Chief Operating Officer.

You are a private investor with a large investment in PowerTool bonds and shares, and wish to determine the effect of the acquisition of Fenton on PowerTool's bonds and other related issues.

Question 1

PowerTool has a 6% coupon semi-annual bond with 3 more years to maturity.

(a) The market price is $108. What are the Current Yield and Yield-to-Maturity (YTM) of this bond?

(b) What is the Modified Duration of this bond when the market yield is at YTM

(c) Explain why and when Modified Duration under-predicts and over-predicts the change in bond price as the market yield changes.

(d) Suppose this is a callable bond and has only one call date happens 1 year from now. The call price is at $105. Would investors still pay $108 for this bond? Higher or lower? Explain.

(e) If investors still pay $108 for it, and the bond is called. What is the YTM of this investment?

(f) Explain what market conditions under which PowerTool would likely call its bond.

Question 2

PowerTool has a $12 strike European call option on its stock, is trading at $2.40 when the underlying is at $13.60. This option will expire in 6 months time. The risk-free rate is 4%.

(a) With the given call option and the Solver in EXCEL, estimate the implied volatility of PowerTool. (Note: PowerTool is a non-dividend paying stock).

(b) With the EXCEL spread sheet setup in part (a), determine the premium of the corresponding put option.

(d) What is the Delta of this put option?

(e) With the EXCEL spread sheet setup in part (b), re-determine the put option premium when the underlying is $13.55.

(f) Verify your results from part (b) and (e) with that of part (d).

Question 3

Assuming that PowerTool has called its bond and therefore there is no debt in its current capital structure. It is studying two possible structures with debt being further introduced. The details are given in the following table:

744_Financial Modelling.png

Shares Outstanding 1 1500 1 1000 I 500

(a) Given Earning Before Interest & Tax (EBIT) = $1200, based on the information in the table, which capital structure should PowerTool adopt?

(b) Plot the EPS (Y-axis) vs EBIT (X-axis) chart (with EXCEL), thereby determine the cross-over EBIT that PowerTool would switch from one structure to the other?

(c) Determine the Return on Equity (ROE) for both structure 1 and 2. Explain why the use of debt (Le. financial leverage) in Structure 2 decreases both ROE and EPS instead?

(d) Assuming EBIT is fixed at $1200 and tax rate 40%, by varying the debt cost at 4%, 10% and 20% in Structure 1, plot the line ROE (Y-axis) vs Debt Cost (X-axis) with EXCEL, thereby determine the cost of debt threshold that use of more debt will NOT improve the 8% ROE when the finn is unlevered.

Question 4:

a) With the EXCEL spread sheet, determine the Cash Flow from Assets, Cash Flow to Creditors and the Cash Flow to Stockholders.

(b) With the cash flows obtained in part (a), verify that the following identity holds: Cash Flow from Assets = Cash Flow to Creditors + Cash Flow to Stockholders.

(d) Comment on the health of PowerTool by examining the three ratio components in the DuPont Identity.

972_Financial Modelling1.png

214_Financial Modelling2.png

Reference no: EM13202223

Questions Cloud

What is the planning value for the population standard : What is the planning value for the population standard deviation? How large a sample should be taken if the desired margin of error is.

Sketch a graph of the depth of the coffee in the mug : Coffee is being poured into the mug at a constant rate. Sketch a graph of the depth of the coffee in the mug as a function of time. Account for the shape of the graph in terms of concavity.

Analyze the effects of the government policies : benefits Does government intervention improve the situation. analyze the effects of the following government policies on the market equilibrium. Increases in the Minimum Wage Restrictions on International Trade Pollution Controls Natural Monopolie..

What is the mass of the earth : What is the mass of the earth?" Your challenge in this Thought Project is to devise a strategy for finding the mass of the earth using only the equations and equipment that were available to scientists in the late seventeenth and early eighteenth ..

What are the current yield and yield-to-maturity : The market price is $108. What are the Current Yield and Yield-to-Maturity (YTM) of this bond and what is the Modified Duration of this bond when the market yield is at YTM

What proportion of the trees are expected : The diameters of Douglas firs grown at a Christmas Tree Farm are normally distributed with a mean of 4 inches and a standard deviation of 1.5 inches. What proportion of the trees are expected to have diameters greater than 5 inches?

Find the elasticity of demand for laptop computers : Suppose that over the past year, the price of laptop computers has fallen from $2,000 to $1,800. Over the same time period, sales to consumers have increased from 700,000 to 800,000 units. Calculate the elasticity of demand between these two point..

At what rate would the npv become zero : Determine the Net Present Value of the cash flow at annual interest rates of 15%, 20%, and 30%. At what rate would the NPV become zero What is such a rate called Also, calculate the payback periods, both simple and discounted at 15% per year.

How much money should robertson inc deposit today : Robertson Inc. wishes to set aside lump sum money to withdraw from and invest in automating parts of its business over the next 5 years. This money is expected to earn compound interest at the rate of 10% per year.

User Account

All Pages