IMPLIEDRETURNS

Calculate implied expected returns of your assets / instruments.

Description

Implied returns is a reverse mean-variance optimization methodology. It solves for a set of expected returns for the portfolio's assets under the assumption that the portfolio is on the efficient frontier (optimal).

This can help investors understand the implicit assumptions of maintaining their current portfolio allocations. An investor may choose to rebalance their portfolio if the implied returns are substantially different from the plausible range of expected asset returns.

Analysts may also use this method to contrast against other models of expected returns.

Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

=IMPLIEDRETURNS(assetReturns, weights, riskAversion, indexCash, rf, dataPeriodicity)
=IMPLIEDRETURNS(___, "Name1", value1, ..., "NameN", valueN)

Input(s)

Argument	Description
assetReturns	Required. Time series or matrix of asset returns.
weights	Required. Vector of portfolio weights.
riskAversion	Optional. Risk aversion constant. If not specified, it will default to 1.
indexCash	Optional. Integer to indicate the column index position of a cash asset in assetReturns. This is used to fix a variable in the system of equations in order to solve the reverse optimization. If not specified, it will default to the column index of the lowest return asset.
rf	Optional. Risk-free rate that would correspond with indexCash. If not specified, it will default to the annualized historical average of the lowest return asset.
dataPeriodicity	Optional. Periodicity of the data, used for annualization. If you do not enter the argument, it defaults to 1. e.g. Daily = 255, Monthly = 12, Yearly = 1, Quarterly = 4.

Name-Value Optional Arguments

Specify optional pairs of arguments where Name is the option argument name and Value is the corresponding input object. Name-value arguments must appear after other input argument(s) above, but the order of these pairs does not matter.

Example:

=IMPLIEDRETURNS(___, "Name1", value1, "Name2", value2, ..., "NameN", valueN)

Name	Value
covariance	Custom covariance matrix of asset returns. This may differ from historical covariance in order to solve implied returns under different risk models.

Output(s)

Row or column vector of implied expected returns. The output vector orientation follows the same orientation as the input vector weights.

Example

68KB

IMPLIEDRETURNS.xlsx

Open

Example Workbook: IMPLIEDRETURNS