+ Reply to Thread
Results 1 to 4 of 4

How to calculate compounding?

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    Barcelona
    MS-Off Ver
    Excel 2003
    Posts
    4

    Unhappy How to calculate compounding?

    I would like to calculate interest on my savings account for each month (type of savings account) with compounding of interest.

    Annual rate is 5.25%

    Bank calculates this as follows:

    14,000euro * 5,25 % / 365 days = 2,01euro * 30 days = 60,41euro -19 % tax = 48,93euro
    48,93 is my interest after tax per month.

    What I want to do is to calculate it in excel. Trouble is, that after subtracting the 19% tax I cannot add it back to the principal.
    I mean I have the formula, it will lead me to 60,41euro but when I try to do +(A4) [to add the principal], it gives me ###

    - Could you have a look and advise please ?

    =(A4)*(B5/365)*30-(1-0.019)+(A4)

    A4 = 14000
    B5 = 5.25%
    than / 365 * 30 - 19% +principal

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to calculate compounding?

    =a4 * (1 + b5/365 * 30 * (1-19%))
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-25-2012
    Location
    Barcelona
    MS-Off Ver
    Excel 2003
    Posts
    4

    Thumbs up Re: How to calculate compounding?

    Quote Originally Posted by shg View Post
    =a4 * (1 + b5/365 * 30 * (1-19%))
    Thanks! Works great.
    Could you explain me why you used 1 + at the beginning ? I'm trying to learn how to do it myself in the future.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to calculate compounding?

    I factored the a4 term out of this:

    =a4 + a4 * b5/365 * 30 * (1-19%)
    Last edited by shg; 04-28-2012 at 12:59 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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