Home > Forum Home > Excel Portfolio Optimization Template > Assets other than stocks in portfolio Share

Assets other than stocks in portfolio

Excel Help for Assets Other Than Stocks In Portfolio in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Assets Other Than Stocks In Portfolio

Rate this:
(2.5/5 from 2 votes)
ConfusedHi, My business portfolio includes real estate properties and private equity, all of the other assets are return based. What is the best way to include this assets, as they are not measured in monthly returns bases. Thank you
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(4/5 from 2 votes)
The input data can be either all return based or all price based.  When we have a mix of return and price data we can convert the price data to returns in a separate spreadsheet by using a simple formula: (end price-start price)/start price.  The resulting return data can then be used in the input data along with the other returns.

If we do not have any return or price data for assets that we want to include in optimization, we can also use proxies.  In this case we need to find publicly traded securities which may include indices or ETFs that best reflect the industry or type of investment asset that we require a weighting for in the portfolio.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Assets other than stocks in portfolio in the