Expected returns

Excel Help for Expected Returns in Excel Portfolio Optimization Template

Expected Returns

Rate this:
(3/5 from 1 vote)
 I have a vague understanding of the portfolio optimization process, but have always had to input the EXPECTED RETURNS in each of the other solvers that I have worked with in the past.  Does this optimization use EXPECTED RETURNS and if so, how are the expectations calculated?Separately, would like to have a telephonic conversation with an expert who supports this software.  I am interested in solving for a specific amount of risk as measured by semi variance, rather than a targeted return.  Who do I contact to schedule a call?thanks Posted by gilder on 31 Oct 2011
 Replies - Displaying 1 to 4 of 4 Order Replies By: Most Recent | Chronological | Highest Rated
 Rate this: (3/5 from 1 vote) For the data input there are several options.  To use expected returns as before simply enter the required data into the correlation matrix of the CoVar sheet.To have the returns and correlation calculated for you, enter the historical data into the input sheet (which can then be optionally modified in the Covar sheet before optimization). The input data can be either price/value or percentage returns. The expected returns are calculated as the average return from the input data.Currently the program has the option to use downside risk and the Sortino ratio only but not semi-deviation with a target threshold.  We can look into adding this if commonly demanded. Excel Business Forums Administrator Posted by Excel Helper on 31 Oct 2011
 Rate this: (3/5 from 1 vote) I'm willing to pay someone in your organization to modify my spreadsheet so that I can solve for semi-variance.  how do I go about this? Posted by gilder on 31 Oct 2011
 Rate this: (3/5 from 1 vote) We have emailed you a new version with the option to use semi-deviation below the target return for testing. Excel Business Forums Administrator Posted by Excel Helper on 31 Oct 2011
 Rate this: (3/5 from 1 vote) On dit merci. Leloup Posted by First on 17 Jan 2024
 Displaying page 1 of 1

 Find relevant Excel templates and add-ins for expected returns in the Excel Business Solutions Directory