# II... A & B 1,2,3...

Finance 250-QCC Professor Ken Friedman Principals of Finance Bond Valuation Analvsis 1) For the following bond valuation scenarios determine: the market value of the bond, Pu, July, 2018 along with the present discounted value of its two components: the coupon interest payments and the principal value repaid at maturity c n Coupon Interest Rate Years Until Maturity kYield to Maturity (1) c-4%; k=5%; n-10 years (2) c-7% ; k=3%; n-20 years (3) c=2%; k=6%; n-5years (4) c= 5%; k=8%; n-30 years (5) c-6%; k-2%, n-10 years (6) c= 1%; k=3%; n-15 years II) (a) For the above scenarios, utilize the Excel spreadsheet function, PRICE, to determine the bond market price (b) For the following scenarios, determine the Yield to Maturity by utilizing the Excel financial function, YIELD: (1) c-4% ; PB = $110.50 ; n-10years (2) c-290 ; PB-$92.25 ; n 20 years (3) c-790 ; PB-$130.75 ; n-6 years