I M Having Trouble Understanding Bond Valuations I Tried Using My Excel Spreadsh

I’m having trouble understanding bond valuations. I tried using my Excel spreadsheet but I’m not sure if I’m plugging in the information correctly. I keep getting the wrong answers. Here’s an example: 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"