The Equity addin creates
a worksheet to hold data describing the oneperiod return statistics
for a collection of candidate securities, constructs the nonlinear
programming programming model and provides buttons to solve
the model for a specified target return or to find the sequence
of solutions that comprise the efficient frontier. Three different
assumptions are accommodated by the model:
 The returns are independent random variables.
 The returns are correlated random variables with the correlation
matrix given by the analyst.
 The mean and standard deviations of the returns and the
correlation matrix are estimated by data included directly
on the worksheet.
Click the icon below to see a sequence of pages describing
how to use the addin for independent returns.
Click the icon below to see a sequence of pages describing
how to use the addin for correlated returns.
Click the icon below to see a sequence of pages describing
how to use the addin when security statistics are computed
directly from data.


Security
Statistics from Data 


The examples are described more carefully in the following
pages. 