Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bank Account Formula (Any)

    How do I calculate simple interest that a savings account would accrue? All I can easily find is ways to calculate Loan Payments -- not a simple savings account.

    For example, I just want a formula that would take $10,000 in a bank account with an annual interest rate of 5%, then have it determine the future value at different points -- say 6 months, 12 months, two years, etc.

    Maybe I am making this too complicated or looking for a complicated formula when a simple formula is all that is needed! However, I have looked through the Excel functions and I did not easily find one that fits the bill!

    Help an idiot out. Thanks. ;-]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bank Account Formula (Any)

    You use the same functions for a savings account as for a loan. In this case, the FV (future value) function with a payment of 0. See attached workbook.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Long Beach, California, USA
    Posts
    1,912
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bank Account Formula (Any)

    Thank you, sir. Now, how would I do that to make it "compouned monthly"? I believe your formula is showing it compounded semiannually, but I believe banks compound monthly -- or something, correct?

    EDIT:

    OK, I guess the formula is here.

    But... is that formula in Excel's formula list, or do I have to enter it like you did??

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Bank Account Formula (Any)

    =FV(5%/12,6,0,-10000) for 6 months
    =FV(5%/12,12,0,-10000) for 12 months, etc

    Or to use Hans' Setup
    =FV($B$2/12,A7,0,$B$1)
    and copy it down:
    Where A7 is 6, A8 is 12, etc, to get 6 mons, 12 months, etc

    Steve
    Concerning the formula you found, the FV should calculate the same Value
    =10000*(1+5%/12)^6
    for 6 months
    =10000*(1+5%/12)^12
    for 12 months

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bank Account Formula (Any)

    Just change the 6 month interest rate to the monthly rate.
    Legare Coleman

  6. #6
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bank Account Formula (Any)

    In the U.S. banks usually have to quote a "Rate" and a "Yield". The relationship between the two is determined by the compounding frequency.

    If you have 5% rate compounded monthly, your yield is (1+.05/12)^12-1=5.116%. Your 1,000 deposit will be 1051.16 at the end of the year.
    If you have 5% rate compounded daily, your yield is (1+.05/365)^365-1=5.127%. Your 1,000 deposit will be 1051.27 at the end of the year.

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bank Account Formula (Any)

    I believe that he asked for a 5% rate compounded monthly which is what I calculated. My result is the same as yours if I change the $10,000 he asked for to the $1,000 you used in your calculation. If he had asked for 5% compounded daily, I would have changed the formula in cell B3 to =B2/365. That would have given the same result as your second formula if I also changed the $10,000 to $1,000.

    So, I am not sure what you are saying.
    Legare Coleman

  8. #8
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bank Account Formula (Any)

    I responded to the wrong post since I view threads in flat mode. I was just trying to shed some light on what compounding means since the original poster seemed a little hazy on the term.

Posting Permissions

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