Thread: Simple interest
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Simple interest

Regardless of the result, the formula does not properly annualize the rate of
return. Your formula assumes you earn $22.75 every 35 days. However, if you
reinvested the $122.75 for 35 days at the same rate, you would earn $27.93.

The proper way to annualize the rate of return is to use the future value
function, as in:

=fv(22.75%,365/35,0,-1)-1 or 747.94%

--
Regards,
Fred


"Stefi" wrote in message
...
Sorry, of course you are right. Next time I'll check my post more carefully.
237.25% interest is still not bad!

Stefi

"David Biddulph" ezt írta:

Shouldn't it be =(122.75-100)*(365/35)/100 (a mere 237.25%) Stefi ?
--
David Biddulph

"Stefi" wrote in message
...
(122.75*(365/35))/100-1=11.80107143=1180.11%
Please, let me know the next such investment opportunity!
Regards,
Stefi


"Gorthi" ezt írta:

I invested 100$ 35 days back and got 122.75$ today, I want to calculte
the
interest received