Hi
I hope this is not homework :-)
1. P1 = A * [1+(R*(D1+D2))] - P2

2. P2 = A * [ 1+ (R1*D1)]


--
Regards
Frank Kabel
Frankfurt, Germany

Karl wrote:
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