Percentage calculation (XP)

**Karat** · 2006-07-10 17:13

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

**sdckapr** · 2006-07-10 18:58

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

= 6.5%/day

Steve

**HansV** · 2006-07-10 19:05

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

**Karat** · 2006-07-10 19:17

Thanks for that. I would have never known that

Thanks again

**sdckapr** · 2006-07-10 22:32

<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

Thread: Percentage calculation (XP)

Thread Tools