Coupon Rate is same in all 3 situations.
Except number of times coupon is paid, everything is same.
Situation 1: 1 time and YTM 4.564%
Situation 2: 2 times and YTM 4.571%
Situation 3: 4 times and YTM 4.575%
Effective Coupon Rate = [1+(i/n)]n - 1
where, i = Annual Interest Rate and n = Number of times coupon is paid in a year
It is clear from above that As Number of times Coupons are paid is increasing i.e. As EFECTIVE COUPON RATE is increasing(because all othe factors are same), the YTM also increases. If the number of times coupon paid is increased but Annual Coupon Rate is reduced then EFFECTIVE COUPON RATE might come down. Therefore, Annual Coupon Rate or Number of times coupon is paid in a year, INDIVIDUALLY does not have any relationship with YTM. But, Effective Coupon Rate is the rate that is related. There is direct relationship between Effective Coupon Rate and YTM(provided Redemption Value is same)
(If this was helpful then please rate positively. Thank You:)
Q1: You have been asked to evaluate the yield of maturity AAPL 6.25 maturing at 15th...
The spreadsheet shows you how to calculate invoice price for 6-year maturity bond with a coupon rate of 2.25% (paid semiannually). The market interest rate given is 7.9%. Now, please modify the spreadsheet and calculate invoice price of bond with 6.25% coupon (paid semiannually), settlement date July 31,2012, maturity date May 15, 2030, YTM 7.9%. 2.25% coupon bond, maturing July 31, 2018 Formula in column B Settlement date 7/31/2012 =DATE(2012,7,31) Maturity date 7/31/2018 =DATE(2018,7,31) Annual coupon rate 0.0225 Yield to...
What is the yield to maturity for the company bond maturing in 20 years, paying semi-annual coupons with a coupon rate of 8% and a market price of $1.110.24? 73 6.97 6.40 6,41 7.11% Question 22 1 pts
You just purchased a $1000 par value bond maturing on 30th June 2025. Suppose today’s date (settlement date) is 30th June 2019 and the yield to maturity is 6%. Given all these inputs, do the following. a) Assume the bond is a zero coupon bond (with annual compounding). Compute the bond’s Macaulay duration (using the DURATION function) and modified duration (using the MDURATION function). b) Holding everything else constant, now assume the bond pays coupons semi-annually. Compute the bond’s Macaulay...
A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The previous coupon date was January 1, 2009. The next coupon date is January 1, 2010. The bond will mature on January 1, 2018. The bond’s annual coupon rate is 10% and the face value of the bond is $1,000. Coupons will be paid annually. Compute the bond’s yield to maturity on an accrued interest payment basis.
A bond was purchased on March 20, 2009 and the quoted bond price was $1075. The previous coupon date was January 1, 2009. The next coupon date is January 1, 2010. The bond will mature on January 1, 2018. The bond’s annual coupon rate is 10% and the face value of the bond is $1,000. Coupons will be paid annually. a. Compute the bond’s yield to maturity on an accrued interest payment basis. PLEASE USE EXCEL
for the bond above, how can you get YTC if it is callable in 5
years at call price 110 (% of par) fill out blanks below.
Dald Review View A A = Calibri (Body) 11 BIVA fx 0 / 70 Number Paste c29x Conditional Formatting Format as Table Cell Styles 22 Redemption value of par) 23 Coupons payment per year 24 Flat price of par) 25 Days since last coupon 26 Days in coupon period 27 Accrued interest 28...
Problem 1 (Required, 25 marks) You are given two 5-year callable bond (Bond A and Bond B) .Bond A: It has face value $600 and pays coupon semi-annually at an annual coupon rate 7.2%. Starting from 4th year, the bond can be redeemed on any coupon payment date (including maturity date) at price $660. Bond B: It has face value $650 and pays coupon quarterly at an annual coupon rate 7.2%. Starting from 4th year, the bond can be redeemed...
I am really not understanding how to do this and I
can't afford to miss this
7 Calculating a bond price. Excel FORMULAS DATA REVIEW x FILE HOME INSERT PAGE LAYOUT - Sign in VIEW Function Defined Formula Library Names Auditing ml Calculate Now Calculation calculate Sheet Options Calculation D17 Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a...
1) Consider a 10-year bond trading at $1150 today. The bond has a face value of $1,000, and has a coupon rate of 8%. Coupons are paid semiannually, and the next coupon payment is exactly 6 months from now. What is the bond's yield to maturity? 2)A coupon-paying bond is trading below par. How does the bond's YTM compare to its coupon rate? a. Need more info b. YTM = Coupon Rate c. YTM > Coupon Rate d. YTM <...
NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA.
X 5 ? X . HOME Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In FILE INSERT PAGE LAYOUT VIEW Paste B I U- - - A Alignment Number 8.12 oints Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped D17 А в E F G H I к eBook Print A Japanese company has a bond outstanding that sells for 91.53 percent of...