View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karl Thompson Karl Thompson is offline
external usenet poster
 
Posts: 12
Default Another algebra equation needed

Once again, I need a general equation that will solve for "A". Can someone
tell me what that would be please?


K = -1000
R = 0.0083333
N=5

A = (K*(1+R)^-1) + (K*(1+R)^-2) + (-A*(1+R)^-3) + ... + (A*(1+R)^-N)

FYI: In this case I know A equals -40,554.920

Please note (don't know if it's important) that "A" can be negated one or
more times..

TIA