Fixed income about Bullet and Barbell, bond portfolio management

Please answer all the questions and show your calculation in Excel.

Please answer each question as comprehensively as possible.

Please send me the solved Excel and the word document showing your answers for each question. Thanks.