+ Reply to Thread
Results 1 to 3 of 3

Calculating Daily Compound Interest with a Difference

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    Mooloolaba, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Calculating Daily Compound Interest with a Difference

    Hello.

    I am calculating Daily compound interest on a Principal from a % p/a rate. I think I may have the right equation, however, I am not 100% confident with the answers.

    The principal amount is $20,776.00, the interest rate is 4% p/a, the number of days is 14.

    The equation I am using is = $20,776.00*(1+(4%/365))^14 = $20,807.90 I am pretty sure this is right.

    However, where things go iffy is when I need to make deposits into the account. The 1st deposit is $43,505.00, this brings the balance to $64,312.90 and is made at the end of the 14 day period and the next is 28 days later. So my next equation look like this:
    $64,312.90*(1+(4%/365))^28 =$64,510.53.

    This goes on over another 10 months or so with days between deposits changing.

    Am I doing this right? If not, how should I be doing it?

    Thank you
    Last edited by romperstomper; 07-14-2011 at 10:30 AM.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,672

    Re: Calculating Daily Compound Interest with a Difference

    That looks about right. My suggestion would be to change the exponential number to something like (Date2-Date1) so it will auto-calculate for your different dates.

    Pauley
    Last edited by romperstomper; 07-14-2011 at 10:30 AM.

  3. #3
    Registered User
    Join Date
    09-14-2011
    Location
    Los Angeles,CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Calculating Daily Compound Interest with a Difference

    We cannot all be Einsteinís. Several of us have been vexed by the complexity of those crucial abstractions since school days. Yet adults we have to develop certain math skills if we want to make healthy financial choices. Calculating interest and dividends for mathematically challenged. We have to know throw to compute simple interest, also as compound interest. Likewise, those looking to invest have to know how to compute dividend returns. In an effort to help, Personal Money Network offers some simple formulas to help de-mystify these concepts for the numerically challenged.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1