Note that this is simplified because it does not take a whole host of other things into account.

Design an asset allocation based only on the choices in the spreadsheet. Do NOT use an optimizer.

I have provided two such columns (first and second iterations) to make things easier for you. You can enter a set of weights in the first column, and leave that as is, make changes to two funds or more (increasing or decreasing allocations), and see how expected returns, standard deviations, and expense ratios change. This should allow you to do very simple form of asset allocation. Note that this is simplified because it does not take a whole host of other things into account.

Think of each of these as an asset class. For this assignment, ignore Tax Advantaged Fixed Income Funds (group #2). The template sheet contains the annual portfolio turnover of each fund in percent, the average number of holdings in each fund and the net expense ratio in percent (so 0.30 means 0.30% or 30 basis points)

data

https://drive.google.com/open?id=1dXt8C_14PVya-wiO8eVDcf6zNHZKH-o-