I recently created a spreadsheet with the goal of determining the best country indices to invest in based various criteria. The spreadsheet allows you to adjust the weighting of several factors which then adjust the projected returns and the rank of the country indexes/ETFs.
The way the sheet is set up currently, the projected returns column is distributed based on the returns distribution over 10 years following a given CAPE value (using data from a Star Capital study.) This means that if you aren't giving the CAPE values a high weight, these projections become less useful, but still work as rankings. The expense ratio of a corresponding country index ETF is subtracted from the returns value. Some supporting and/or related data is shown in additional tabs. Let me know if you have ideas for improvements or how the results should be applied.
Tl;dr: Check out my spreadsheet, ask me questions, and make a copy so you can mess with the weighting of the various factors!
Submitted April 05, 2017 at 01:41AM by dominodanger http://ift.tt/2oYP9ao
