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

Thanks Tom, Dana and Keyt for your help.

There turns out to be one more variation to this that I'm hoping one of you
can help me with.

Given this:

K = -1000
K2 = 500.0011
R = 1/120 = 0.0083333333..
N=5

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

Again, how do I solve for A?

In this case A equals 2,602.01

TIA,
Karl


"Karl Thompson" wrote in message
...
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