bond valuation

please see attached excel spreadsheet.  there are two seperate problems but all fields must be entered and the quesiton answered at the end of each page.  Please use excel calculation formulas.  Not just the plain numbers.  It is very important to do this so if you are unsure please do not accept the assginment thank you.