Calculation guide
Enter 2–12 assets and each covariance pair once. A volatility of 10% has variance 100 in squared percentage points. Use a positive-definite annual matrix. Weights sum to 100%; short positions are allowed. A target below the minimum-variance return selects the global minimum. Change the target to trace the efficient frontier.
Minimize wᵀΣw subject to Σwᵢ = 1 and wᵀμ ≥ target.
Inputs
Minimum expected annual return (%)
Example entry 8.
Expected annual return (%)
Example entry 5. Allowed range -100 to 10000.
First asset number
Example entry 1. Allowed range 1 to 12. Use whole numbers.
Second asset number
Example entry 1. Allowed range 1 to 12. Use whole numbers.
Covariance in percentage-points squared
Example entry 100. Allowed range -100000000.0 to 100000000.0.
Worked example
| Input | Value |
|---|---|
| Minimum expected annual return (%) | 8 |
Assets in numbered order
| Expected annual return (%) |
|---|
| 5 |
| 10 |
Annual covariance matrix entries (one row per unordered pair)
| First asset number | Second asset number | Covariance in percentage-points squared |
|---|---|---|
| 1 | 1 | 100 |
| 1 | 2 | 0 |
| 2 | 2 | 400 |
| Result | Value |
|---|---|
| Annual portfolio volatility | 12.649111% |
| Expected annual return | 8% |
| Return at global minimum variance | 6% |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Minimum expected annual return (%) | 8 | 9 | Annual portfolio volatility | 12.649111% | 16.124515% |
| Expected annual return (%) (row 1) | 5 | 6 | Annual portfolio volatility | 12.649111% | 11.18034% |
| Covariance in percentage-points squared (row 1) | 100 | 110 | Annual portfolio volatility | 12.649111% | 12.712199% |
