Home > Forum Home > Excel Portfolio Optimization Template > Probability of achieving target return Share

Probability of achieving target return

Excel Help for Probability Of Achieving Target Return in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Probability Of Achieving Target Return

Rate this:
(3.5/5 from 2 votes)
ConfusedI ran the optimization for my assets, it returns a daily mean of 0.05% with sd of 1.73%. What  I am confused is the row below it which says -

"Probability  of achieving 0.1% targer return : 49.29%"

What it means? Please clarify in reference in this result context. Thanks!

 
 Sura
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most recent | Chronological | Highest Rated
Oops
Rate this:
(4.3/5 from 3 votes)
The 0.1% is, in fact, 0.08% but the cell formatting is set at one decimal place.  If you unprotect the sheet and increase the number of decimal places, you will see the 0.08%.

The annual equivalent is 29.2% (0.08 * 365).
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(2/5 from 2 votes)
i think am getting there. Please clarify in specific to my data than general explaination. I entered my tatrget return of 0.08% and all my prices data are "DAILY"; Why it is not showing the proability of achieving target return of 0.08%. i am confused where this 0.1% came from.
 Sura
 Posted by on
Happy
Rate this:
(3/5 from 1 vote)
The target return is entered in the Input sheet and represents a target return corresponding to the periodicity of the data.  If data is monthly, then 0.1% represents 1.2% annual return for the portfolio.

Monte Carlo simulation is run to calculate the probability of achieving this return based on the normal distribution of portfolio returns given the mean and standard deviation (volatility).  More information on this can be found in the user guide.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Probability of achieving target return in the