A retirement portfolio for Mr$.$ and Mrs$.$ Schrute

Mr$.$ and Mrs$.$ Schrute have asked you to assist them with their investment portfolio. They have asked you to conduct an analysis and present it to them.

Mr$.$ and Mrs$.$ Schrute have just retired and have $$250,000$ that they would like invested in an income producing bond portfolio. They need the income to cover their expenses in retirement. Safety is important to the Schrutes. They want their funds invested in either Government bonds or corporate bonds that are rated by S&P as BBB rated or better.

$1.$ Create a diversified portfolio for the Schrutes with a minimum of $5$ bonds. Balance the income of the portfolio so that the quarterly income of the portfolio is reasonably balanced. Structure the bonds in a bond ladder with approximate maturities of $2,4,6,8,$ & $10$ years.

$2.$ Calculate both the quarterly and the annual income of the portfolio for the first two years.