Thread: Simple interest
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Simple interest

That would be fine if the investment had a compounding interval of 35 days,
but that would be an unusual interval; in many cases the compounding
interval is annual or biannual.
[But, as you said in another post, the OP asked for simple interest, not
compound interest.]
--
David Biddulph

"Fred Smith" wrote in message
...
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%


"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 ?


"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