f. Now assume the date is October 25,2020. Assume further that a 10%, 15-year bond was issued on July 1,2020, pays interest semiannually (on January 1 and July 1), and sells for $1,18 0. Again, it may be called in 7 years from the date of issue at a call price of $1,070. Use your spreadsheet to find the bond's yield. Round your answers to two decimal places. Yield to maturity: % Yield to call: %

f. Now assume the date is October 25,2020. Assume further that a 10%, 15-year bond was issued on July 1,2020, pays interest semiannually (on January 1 and July 1), and sells for $1,18 0. Again, it may be called in 7 years from the date of issue at a call price of $1,070. Use your spreadsheet to find the bond's yield. Round your answers to two decimal places. Yield to maturity: % Yield to call: %

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

Please correct answer and don't use hand rating
Give typing answer with explanation and conclusion 1- Imagine the bond above displayed the following details: $10,000 Matures: January 31, 2030; Interest of $200 payable June 30 and December 31 of each year. Can you calculate the annual effective interest rate for this bond? a)2% b)4% c)6% d)One cannot tell.
Determine the Purchase Price of a Bond that is purchased on the Coupon Date. A $500 bond matures on March 1, 2026, interest is 6.7% payable semi-annually. Determine the purchase price of the bond on September 1, 2020, to yield 8.7% compounded semi-annually. Will this bond sell at a premium or at a discount? discount a.) Determine the value of the coupon. b.) Determine the number of coupons left on the bond. 11 c.) Determine the Present Value of the Bond. d.) Determine the Present Value of the Coupons. e.) What is the purchase price of the Bond on September 1, 2020? >
Listen Assume that there is a bond that pays $20.00 at the and of year 2, and $105.00 at the end of year 7. It sells at a total =$(20.00+105.00). The Macauley duration of the bond is? Answer with two digits decimal accuracy. Blank Excel Worksheet Your Answer
PLEASE GIVE ME THE RIGHT ANSWERS
Bha
Consider a bond with semiannual interest payments that has a Settlement Date of 8/15/2020, a Maturity Date of 2/15/2031, a Coupon Rate of 5.00%, a Market Price of $975, a Face Value of $1,000, and a Required Return of 5.35%. What is the Macaulay Duration using the Duration function on these bonds expressed as a decimal calculated to two decimal places if you purchase them at the current market price? For example, if your answer is 12.345 then enter as 12.35 in the answer
Suppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $750, calculate the interest rate that the bond would yield to a bond buyer. Show all work.
Consider an investor who, on January 1, 2022, purchases a TIPS bond with an original principal of $111,000, an 10 percent annual (or 5 percent semiannual) coupon rate, and 15 years to maturity. a. If the semiannual inflation rate during the first six months is 0.5 percent, calculate the principal amount used to determine the first coupon payment and the first coupon payment (paid on June 30, 2022). b. From your answer to part a, calculate the inflation-adjusted principal at the beginning of the second six months. c. Suppose that the semiannual inflation rate for the second six-month period is 1.3 percent. Calculate the inflation-adjusted principal at the end of the second six months (on December 31, 2022) and the coupon payment to the investor for the second six-month period. (For all requirements, round your answers to 2 decimal places. (e.g., 32.16)) a. Principal amount Coupon payment b. Inflation-adjusted principal c. Inflation-adjusted principal at the end of the second six months…
Required: Find the duration of a bond with settlement date May 29, 2018, and maturity date November 19, 2027. The coupon rate of the bond is 6%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 7%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
Pls help with below homework.
give me answer