Question

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 Invoice price 93 PRICE settlement, maturity, coupon rate, YTM, redemption value.coupoon frequenc COUPAYSsettlement, maturity, frequency basis *** enter for basis 182 COUPDAsettlement, maturity, frequency, basist enter for basis 0.0073 use the definition in lecture side 102.676 use the definition in lecture slide 1/28/20 1/28/38 30 Selve for YTM 31 Settlement date 32 Maturity date 33 Annual coupon rate 34 Redemption value of par) 35 Coupon payment per year 36 Flat price of par) 37 Yield to Maturity 6.52% YELD settlement, maturity, coupon rate price, redemption, coupon frequency per year of par? Fill the banks below. 40 For the bond above, how can you get YTC is 41 Settlement date 42 Call date 43 Annual Coupon rate 7 44 Redemption value of par) L ED 45 Coupons payment per year 45 Flat price of par) in 5 years call price 110 1/28/20 1 1 /28/25 .00 4 Y es MacBook Pro # Ô 8 w
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.

Answer 1

B. settlement date call date Annual coupon rate Redemption value coupon payment per year|| flat price Yield 1/28/2020 1/28/2025 7% 110 105 7.47%

Formula used :-

Yield=YIELD(C6,C7,C8,C11,C9,C10,0)

i hope my efforts will be fruitful to you...?