Basant,
The gain/loss% column would have been more accurate if calculated on CAGR basis.
|
Good suggestion. can anyone suggest how it is done in Excel?
|
well when I saw the comparisons, i immediately caught the error in representation. % comparisons only make a good sense when they are on annualized basis.
The formula is CAGR in %= {[ ((Final money)/(Initial Money))^(1/time in years) ]*100}-100
Suppose the sum has become 10 times in 3.6 years, then 10^(1/3.6) is 1.297, i.e. the money has become 1.297 times every year, ie 29.7% Annual Return.
If 20% return in 7 months, then (1.2)^(12/7)= 1.367, i.e. 36.7 CAGR.
This formula can be arrived at using very simple maths, and generally CFA level-1 courses have plenty of such practice problems.