is there a formula for calculating daily compounding on a CD?

[bryantsheriff]

i am trying to calculate daily compounding interest on a certificate of
deposit, but don't want to take up 365 lines to do so. is there formula that
can calculate it more simply?

 

[Daniel CHEN]

assume annual rate is r (like 0.1) and compounded daily.
the APY = (1+r/365)^365-1, format as percentage.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================

 

[joeu2004]

i am trying to calculate daily compounding interest on a certificate of
deposit, but don't want to take up 365 lines to do so. is there formula
that can calculate it more simply?

If A1 is the principal value of the CD, A2 is the annual interest rate,
and A3 is the length of the term of the CD in days, then:

=fv(A1/365, A3, 0, -A2) - A2

computes the total interest.