Home / Questions / Using a Spreadsheet to Calculate Yield to Maturity What is the yield to maturity on the fo...
Using a Spreadsheet to Calculate Yield to Maturity. What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent (paid semiannually). The bonds’ current market values are $945.50, $987.50, $1,090.00, and $1,225.875, respectively. ( 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
Compound Interest(a) A deposit of $550 is made in a savings account that pays an annual interest rate of 1% compounded monthly. What is the balance after 11 years?(b) How...
Aug 16 2021Bette Santoro borrowed $3,000 from Reese Bank on May 19th, at a rate of 9.75% simple interest. The loan was paid back on October 1st. What was the total interest accrued ...
Apr 02 2021What is the difference between the following pairs?(a) crystalline solid; amorphous solid(b) ionic solid; molecular solid(c) molecular solid; network solid(d) metallic so...
Jul 17 2021What is happening to the amount of carbon dioxide in the atmosphere? (A) It is increasing (B) It is decreasing (C) It is holding steady (D) It is fluctuating wild...
Mar 21 2018A tea-drinking Canadian friend of yours claims to have a very refined palate. She tells you that she can tell if, in preparing a cup of tea, milk is first added to the cu...
Apr 05 2020Helena is now 13 and is exhibiting signs that she may be suffering from an eating disorder. Her mother and father are worried and in need of a workshop that will educate ...
Feb 03 2020Choose the correct answer.Over three fourths of the contract(a) has,(b) havebeen ratified.
Jul 01 2021A bridge on a prominent public roadway in the city of Papagos, Arizona, was deteriorating and in need of repair. The city posted notices seeking proposals for an artistic...
Aug 18 2021Graph the Simpsons' consumption function and find their house hold's marginal property to consume. Instructions: On the graph above, click the plotter tool and drag the f...
Jul 10 2021Monica loves flowers and she has quasilinear preferences. Her inverse demand function for flowers is p(x) = 49 - 6.1, where I is the number of flowers that she consumes. ...
Apr 10 2021