Using Excel spreadsheet calculate YTM on a five-year bond with a 5% coupon payable twice a year knowing that the face value of the bond in question amounts to 1,000 m.u., its present market price amounts to 980.25 and that four years and twelve days have passed since its issue