calculating an annual rate

  • Thread starter Thread starter L. T. Portella
  • Start date Start date
L

L. T. Portella

a b c d e
f

Purchase Purchase Today's Market $ Profit % Profit
Date Price Date Value
1 1/1/02 100.00 9/4/03 150.00 50.00

given the above, what is the formula that I should put in column f to get
the percentage profit expressed as an annual rate. Please note that the %
profit could NOT be 50% because almost 20 months have elapsed from January
1, 2002 to September 4, 2003.

Many thanks
 
L. T. Portella said:
a b c d e
f

Purchase Purchase Today's Market $ Profit % Profit
Date Price Date Value
1 1/1/02 100.00 9/4/03 150.00 50.00

given the above, what is the formula that I should put in column f to get
the percentage profit expressed as an annual rate. Please note that the %
profit could NOT be 50% because almost 20 months have elapsed from January
1, 2002 to September 4, 2003.

Many thanks
Click to expand...

Cross posting:

See reply here in the Microsoft.public.excel group:

news:[email protected]
 
Back
Top