calculating an annual rate

[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

 

[Alan]

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

Cross posting:

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

news:[email protected]