Which formula to use for compounding interest for specific # of da

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, May 30, 2006.

  1. Guest

    Guest Guest

    Principal amount is $57,310.38; interest is 3% per annum, length of time is
    195 days with 1 payment at the end of the 195 days. I'm clueless as to which
    formula to use and what #'s to plug in. Hope someone can help.
     
    Guest, May 30, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Is this compounded daily, or is it compounded once at the end of the 195 days
    (in which case wouldn't technically be compounded)? By "1 payment" I assume
    you mean the entire pricipal is to be paid back after 195 days. I'll assume
    compounded daily and entire principal paid @ t=195 days:

    Amount paid Back = 57,310.37 * (1+ .03/365)^195 = $58,236.27
    Resulting in $925.90 in interest paid (58,236.27-57,310.37)

    Does that help?
    --
    Regards,
    Dave


    "ROL" wrote:

    > Principal amount is $57,310.38; interest is 3% per annum, length of time is
    > 195 days with 1 payment at the end of the 195 days. I'm clueless as to which
    > formula to use and what #'s to plug in. Hope someone can help.
     
    Guest, May 30, 2006
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Hornblow

    Formula for compounding Interest

    John Hornblow, Aug 23, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    464
    John Hornblow
    Aug 23, 2003
  2. Mike Deblis

    Calculating compount interest from a table of dates/interest rates

    Mike Deblis, Feb 3, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    1,269
    Norman Harker
    Feb 4, 2004
  3. Guest

    Interest Earned on Investment w/Daily Compounding

    Guest, Feb 7, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    267
    Guest
    Feb 7, 2005
  4. Guest

    Effective rate of Interest and Copounding Interest

    Guest, Apr 12, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    431
    Fred Smith
    Apr 13, 2005
  5. Guest

    What compounding assumption does excel use for its XIRR function?

    Guest, Feb 13, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    1,877
    Harlan Grove
    Feb 13, 2007
  6. Guest

    PMT: Daily interest compounding; monthly payment

    Guest, Jul 20, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    2,166
    Guest
    Jul 20, 2007
  7. charrismd

    What is the formula for compounding interest with annual additions

    charrismd, Aug 25, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    2,149
    Duke Carey
    Aug 25, 2008
  8. mzuaiter

    Flat interest rate Vs Reducing interest Rate

    mzuaiter, Mar 18, 2012, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    940
    mzuaiter
    Mar 18, 2012
Loading...