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
What is the present value of an annuity of $27 received at the beginning of each year for the next sixyears? The first payment will be received today, and the discount ra...
Jun 02 2021Amount demanded at various prices is called?
Jul 01 2021LPP-COMPANY Cost of Equity 10.58% Cost of debt 3.24% structure long term debt short term debt equity total capital VGR - COMPANY in thousands (PLN) weight in % 267707 18%...
Aug 18 2020You are given an investment to analyze. The cash flows from this investment are as follows. End of year: $2217 $5895 $685 $3014 $1500 What is the future value of this inv...
May 21 2018A fertilizer contains nitrogen by mass. What mass of this fertilizer, in kilograms, is required for an application requiring of nitrogen?
May 17 2021Define, compare, and justify cash dividends, stock dividends, stock splits, and reverse stock splits.
Nov 27 2019Historically, usury laws that put below-equilibrium ceilings on interest rates have been used by some states to make credit available to poor people who could not otherwi...
Dec 05 2019How do you know if a service was created/provided in an ethical manner?
Aug 24 2020Assume that a country's money velocity remains constant and that the rate of money growth is 4%. A) What is the rate of spending growth? B) If money growth increases by 1...
Apr 05 2020Explain why the Leontief paradox and the more recent Bowen, Leamer, and Sveikauskas results reported in the text contradict the factor-proportions theory.
Mar 30 2020