Key bond valuation questions

Key bond valuation questions

I need to solve problems 6-1 and 6-2. I need to complete the assignment in Excel to show the yield. I need this by Thursday. Thanks.

Attachments: