Dear All

I have a doozie! I was wondering if anyone who is an expert at Mathematics/excel can tell me why the yield calc in the attached spreadsheet does not equal the discount rate. It is only marginally out but I am racking my brains as to why!

Please help the yeild should equal 12.5% exactly