Table $2$: Government Bond YTM forecasts for the next $2$ years

Canadian Government Bonds

US Government Bonds

Note the following definitions:

Q$1=$ Quarter $1($Jan$-$Mar $31)$

Q$2=$ Quarter $2($April $1-$ June $30)$

Q$3=$ Quarter $3($July $1-$ Sept $30)$

Q$4=$ Quarter $4($ Oct $1-$ Dec $31)$

Assume you hold a Canadian bond portfolio comprised of $70\%$ government bonds and $30\%$ corporate bonds at the beginning of $20$X$1$ that has an average maturity of $10$ years. Your portfolio currently has a mixture of bonds of various maturities. Assume you do not want to change the weighting of government vs corporate bonds. What would be a good investment strategy? Explain briefly. does the approach remain the same

explain further on what the steps to solve are.

i want to do this in excel using the PV functions.But How do i go representing it$.$What steps do i take to solve this comprehensively