Loan, Bond & Annuity Problem

[Barnie]

I have attached a problem relating to a mortgage loan, annity & Bond problem as well as a spreadsheet containing the Interest %'s and assumptions

Your assistance in solving this using Excel will be most appreciated