Spreadsheet Exercises 21-1 Assume you are doing some personal planning for the management of your portfolio It is early 2016. You have decided to build a portfolio that is either 40 percent bonds/60 percent stocks or 30 percent bonds/70 percent stocks. However, at this time an Aggregate U.S. bond index is yielding only 2.2 percent. In order for you to make a judgment as to your likelihood of success, you will need to determine how much stocks will have to return to provide an overall portfolio return ranging from 6 percent to 10 percent, as shown in the spreadsheet below. a. Fill in the spreadsheet below by determining what equity return will (approxi- A m ately) provide you with the portfolio objective shown b. Which portfolio combination would you choose, based on what you now know about likely equity returns? 40% bonds 60% 30% bonds 70% stocksPf Return Pf Objective stocks Pf Return 6% 8% 0.022 bodembe 0.022 hotelow 0.022 0.022 0.022 d al 0.022 0.022 0.022 0.022 0.022 -IS 9% 10%