Hi Tom
I think the OP wanted the second formula to be solved for P2 (though I
wasn't sure either about this)

--
Regards
Frank Kabel
Frankfurt, Germany

Tom Ogilvy wrote:
P1 = A * (1 + (R1 * (D1 + D2) ) ) - P2

P2 = A * (1 + (R1 * (D1 + D2) ) ) - P1


"Karl" wrote in message
...
I'm trying to complete an Excel 2000 model and I need some help with
the basic algebra.

Can someone please rewrite this for me to solve for P1?

A = ( P1+ P2 ) / ( 1+ ( R1 * ( D1 + D2 ) )

I know:

A = 99,200.881785616 (approx.)
P2 = 100,000.00
R1= 0.10 / 360 = 0.000277777778 (approx.)
D1= 31
D2= 29
and we know P1 will equal: 854.229815376 (approx.)


Additionally, can this be rewritten to solve for P2?

A = P2 / ( 1 + ( R1 * D2 ) )

Which, given the above value, P2 will again equal 100,000.00


Thanks a lot in advance. This would be a big help. I hate the idea
of
cracking some text books that I've not looked at in 30 years!

Karl