ExcelBanter - annual percentage return

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - annual percentage return (https://www.excelbanter.com/excel-worksheet-functions/81443-annual-percentage-return.html)

Stephen Watson

annual percentage return

If an investment of say £1000 was made on 02/05/02 and is now worth £1500
today.

What is the formula I need to work out the % I would have needed to invest
the money at had the amount been invested at a guaranteed rate.

Thanks

Duke Carey

annual percentage return

=(1500/1000)^(1/((TODAY()-DATE(2002,5,2))/365))-1

or just under 11%

"Stephen Watson" wrote:

If an investment of say Â£1000 was made on 02/05/02 and is now worth Â£1500
today.

What is the formula I need to work out the % I would have needed to invest
the money at had the amount been invested at a guaranteed rate.

Thanks

Fred Smith

annual percentage return

Or use the Rate function:

=rate((today()-date(2,5,2))/365,0,-1000,1500)

--
Regards,
Fred

"Duke Carey" wrote in message
...
=(1500/1000)^(1/((TODAY()-DATE(2002,5,2))/365))-1

or just under 11%

"Stephen Watson" wrote:

If an investment of say £1000 was made on 02/05/02 and is now worth £1500
today.

What is the formula I need to work out the % I would have needed to invest
the money at had the amount been invested at a guaranteed rate.

Thanks

All times are GMT +1. The time now is 01:34 PM.