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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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