What is the formula

Assignment Help Finance Basics
Reference no: EM13304640

The balance sheet that follows indicates the capital structure for Nealon. Inc. Flotation costs are (a) 15 percent of market value for a new bond issue, and (b) $2.01 per share for preferred stock. The dividends for common stock were $2.50 last year an are projected to have an annual growth rate of 6 percent. The firm is in a 34 percent tax bracket.. what is the weighted average cost of capital if the firm's finances are in the following proportions?

TYPE OF FINANCING PERCENTAGE OF FUTURE FINANCING
Bonds [8%, $1,000 par, 16 year maturity] 38%
Preferred stock [5,000 shares outstanding,
$50par, $1.50 dividend] 15%
Common equity 47%
Total 100%


a. Market prices are $1.0.35 for bonds, $19 for preferred stock and $35 for common stock. There will be sufficient internal common equity funding (i.e., retained earnings) available suck that the firm does not plant to issue new common stock.

b. In part a we assumed that Nealon would have sufficient retained earnings such that it would not need to sell additional common stock to finance its new investments. Consider the situation now, when Nealon's retained earnings anticipated for the coming year are expected to fall short of the equity requirement of 47 percent of new capital raised. Consequently, the firm foresees the possibility that new common shares will have to be issued. To facilitate the sale of shares, Nealon's investment banker has advised management that they should expect a price discount of approximately 7 percent, or $2.45 per share. Under these terms, the new shares should provide net proceeds of about $32.55.

I need help with computing the bond net price in Excel. What is the formula?

 

Reference no: EM13304640

Questions Cloud

Determine how long should the basin be : Assume Stoke's Law holds true for the following question. You are asked to desgin a settling basin. Flow rates are 16 million gallons/day. The basin must be 4m deep, and 4m wide. Particle size ranges from 0.2-50 mm in diameter.
Acommercial complex in the heart of the city : Our organisation is bidding for a construction project, which consists of building a commercial complex in the heart of the city.
Find the location-velocity and acceleration of a box : The motion of a box on a spiral conveyor is defined by the following position vector: r = 0.5sin(2t) i + 0.5cos(2t) j - 0.2t k where r is in meters and t is in seconds. Find the location, velocity, and acceleration when t = 0.8 s.
Determine agi ad the capital losses to be carried forward : To better understand the rules for offsetting capital losses and how to treat capital losses carried forward, analyze the following data for an unmarried individual for the period for the period 2007 through 2010. No capital loss carryforwards are..
What is the formula : Market prices are $1.0.35 for bonds, $19 for preferred stock and $35 for common stock. There will be sufficient internal common equity funding (i.e., retained earnings) available suck that the firm does not plant to issue new common stock.
How far will the truck travel before coming to a stop : It was observed that the truck traveled a distance of 120 ft after the brake was engaged before coming to a complete stop. If instead the driver brings the truck to a velocity of 90 mph and completely engages the brake
Identify the organisational cultural barriers : Identify the organisational cultural barriers and enablers to innovation.
Proposals for each of these five elements should appear : Proposals for each of these five elements should appear in a budget format, showing the element and the expected cost for its purchase or implementation.
What percentage of families own both a dog and a cat : In a certain community 36% of the families own a dog, and 22 percent of the families that own a dog also own a cat. In addition 30 percent of the families own a cat. a.) what percentage of families own both a dog and a cat

Reviews

Write a Review

Finance Basics Questions & Answers

  Stock price and market capitalization

Suppose Cisco Systems pays no dividends but spent 5 billion dollars on share repurchase last year. What stock price does this correspond to?

  Describe the various actions

Describe the various actions that you might take and their implications.

  Which of these two bonds should the investor select

Which of these two bonds should the investor select? Why?

  Explain the implication the law of one price has for price

Explain the implication the Law of One Price has for the price of a financial security. Provide examples.

  How much must the member pay

An HMO has a point of service (POS) option for its members but will pay only 80 percent of approved charges. If a member goes out of network for a medical procedure with a charge of $2,000 of which $1,2000 is approved how much must the member pay.

  Profitable deployment of additional direct labor hours

Lamb Golf Accessories Limited produces a range of specialized waterproof golf shoes, in 4 different quality specifications. Deluxe 600, Palmer 20, Nicholas 360, Standard 640.

  What is the balance in the account at the end

You have been depositing money at the end of each year into an account drawing 8% interest. what is the balance in the account at the end of year four if you deposited the following amounts? Year End of year deposit 1 $350 2 $500 3 $725 4 $400

  Calculate the fair price of a 6 month forward contract

The current price of a share of stock is 5, and the stock is expected to pay a dividend of 1 per share in 2 months and again in 5 months. The risk free annual effective rate of interest is 6%.

  What sum of money should be invested today

What sum of money should be invested today so that 5 annual payments of $1,000 commencing in 3 years can be paid? Use j1 = 6%.

  Explain analysis of data through capm model

Explain Analysis of Data through CAPM Model and The period should include exactly 5 years of data

  Calculate present value if the discount rate is 12 percent

Calculate present value if the discount rate is 12%? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

  What is the value per share of your firm stock

after which growth should be at a constant rate of 6%. The last dividend paid was $1.00. What is the value Per share of your firm's stock?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd