Home / Questions / Using a Spreadsheet to Calculate Bond Values What is the value of a $1000 bond with a 12-y...
Using a Spreadsheet to Calculate Bond Values. What is the value of a $1,000 bond with a 12-year maturity and an 8 percent coupon rate (paid semiannually) if the required return is 5 percent, 6 percent, 8 percent, and 10 percent? ( LG 3-2 )
( LG 3-2 )
Bond Valuation Formula Used to Calculate Fair Present Values
Most bonds pay a stated coupon rate of interest to the holders of the bonds. These bonds are called coupon bonds. The interest, or coupon, payments per year, INT, are generally constant (are fixed) over the life of the bond. 5 Thus, the fixed interest payment is essentially an annuity paid to the bond holder periodically (normally semiannually) over the life of the bond. Bonds that do not pay coupon interest are called zero-coupon bonds. For these bonds, INT is zero. The face or par value of the bond, on the other hand, is a lump sum payment received by the bond holder when the bond matures. Face value is generally set at $1,000 in the U.S. bond market.
May 18 2020 View more View Less
ABC Company earns a net profit of $500,000, and has $7,000,000 common shares outstanding that sell on the open market for an average of $18 per share. In addition, there ...
Apr 17 2020Find the vertex, focus, directrix of the parabola, and sketch its graph.
Jun 28 2021What do the stages of economic development include?
Jun 04 2021Strategic management is a process through which managers formulate and implement strategiesgeared toward optimizing strategic goal attainment, given available environment...
Dec 13 2017The antiderivative of y=3x2 +1 is
May 16 2021Compute the weighted average cost of capital for each of these firms. Assume a marginal tax rate of 40 percent.- A. B. C. D. E.Target capital structure is 45% debt and 55...
May 10 20211. You own a fixed income asset with a duration of five years. If the level of interest rates, which is currently 8%, goes down by 10 basis points, how much to expect the...
May 23 2018Select a small business with which you are familiar. Imagine that you have been called into that business to provide a consultation on training. Create a comprehensive tr...
Feb 04 2020(Leverage analysis) You have developed the following income statement for the Hugo Boss Corporation. It represents the most recent year’s operations, which ended yesterda...
May 28 2020Where is the best place to develop geothermal energy in terms of world regions?7.What is the principle advantage of geothermal energy?8.What is the main advantage and dis...
Feb 14 2020