Efficient Frontier

If you have a portfolio containing several risky assets you may need help defining the different weights for each asset.
To help you identify the minimum risk for a given return you can use an efficient frontier.
You can use Excel Solver to obtain the optimum weights for a given return.
If you repeat this optimisation for a large number of different returns you can generate a risk-return profile known as the efficient frontier.
An efficient portfolio can be determined by the set of weights that produce the required return with the lowest standard deviation.