Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Percentage calculation (XP)

    I have to calculate a percentage.
    Mr X gives company money, takes it out after several days/weeks with interest.
    I now have to calculate the interest amount, the interest percentage and the interest he received per day.
    I have attached a spreadsheet and like to know if I'm on the right track.
    Not sure if I calculated the interest per day correctly.
    Thanks for your help

  2. #2
    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: Percentage calculation (XP)

    I calculate the interest/ day for row 11 as:
    =(EXP(LN(D11/B11)/E11)-1)

    = 6.5%/day

    Steve

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

    Re: Percentage calculation (XP)

    Or
    <code>
    =(D11/B11)^(1/E11)-1
    </code>

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Percentage calculation (XP)

    Thanks for that. I would have never known that

    Thanks again

  5. #5
    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: Percentage calculation (XP)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> I thought it could be simplified.

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>I guess that will teach me not to post right before I pack up to go home and don't make time to simplify...

    Steve

Posting Permissions

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