Please answer in Excel format with proper labels and detailed formulas for a great rating. Thank you!

You expect interest rates to decline over the next six months. a. Given your interest rate outlook, state what lands of bonds you want in your portfolio in terms of duration, and explain your reasoning for this choice. b. You must make a choice between the following three sets of nonsalable bonds. For each set, select the bond that would be best for your portfolio, given your interest rate outlook and the consequent strategy set forth in Part a. In each case briefly discuss why you selected the bond