16/17

updated pics . please try to work with it.

Excel Online Structured Activity Bond valuation You are considering a 30 y $1,000 par valse bond. Is coupon rate is 10% and interest le pall semiannually. The data has been collected in the Microsoft Excel Online the below. Open the seraiheet and perform there analysis to the gostion below Open spread If you require an efectivama interest rate that a nominal rate how much should you be willing to w for the body of and intermediate stop and you to the Dk My W ENGO Gred Activity bond wat Anwester has two bands in the portfolio, Bond and fond zachond matures in years, tos atace value of $1.000 and have to mature Blond C11. the Bandenbord The data has been called in the red below. Open the past and perform there was to the below Open het Assuming that the vast te mutat att bord amber the naturears, create the price of the bed at each of the fore years to maturity. Our retro intermediate tallationen var answers to the restent Yes to Matty Bond Price and 1 2 + 1 + Extel Online Structured At Hond valuation An lovestor has two bands in her pustolo, Band C and Bond 2. Each band matures in wars, has a face value of 3.000, and has a video maturity of Bandpass a 1.5% am coupon, while donduro cupon bord. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required anysis to answer the questions belon. Open het Assumine that ma yuid to matulty of each one remains a swer the next years, calitate the price of the bondi at each of the tutoring years to maturity. Do not own termediate calculations. Soweit your artners to the warto Hulty of Bodo Blond 2 newest cent + . 1 2 $ 3 1 5 $ Excel Online Structured activity: Bond valuatie You weergavea $1,000 p valus bond ils ports 10 destis pult seninly The data has been collected in their continuow. Open the order and to the roured analysis to answer the question below. Oper spreadsheet of you require an effective sunt interest rate (nota nominal tate) of B.739. how much should you be willing to pay for the bond? Do not found intermediate steps. Round your answer to the nearest cont. CHARY