Thread: Daily compound interest
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Daily compound interest
Hope this helps..
http://support.microsoft.com/kb/213907

If this post helps click Yes
---------------
Jacob Skaria


"Karen" wrote:

I need to calculate daily compound interest and I tried the following formula

Column A (no of days) | Column B
1 | 3000
2 | =FVSCHEDULE(B1,0.05974/365)
3 | =FVSCHEDULE(B1,0.05974/365)
And so forth

However, this doesnt work so well if the number of days gets larger, e.g
5000 days. Is there a better way to calculate daily compound interest?

Thank you.

Reply With QuoteReply With Quote