How do I solve for C?

**tommystanek** · 12-03-2015, 06:23 PM

ESTIMATING (before the job starts):

A=Job Cost (known)
B=overhead percentage (known)
C=profit percentage (known)
D=Contract Price (need to know)

Here is how we solve for D/create a "Contract Price": A/(1-(B+C))=D

ACTUAL (after the job is over):

A=Job Cost (changed, but known)
B=overhead percentage (stays the same, known)
C=profit percentage (need to know now based on the changes to A)
D=Contract Price (stays the same, known)

So after the job is complete, I know A, B, & D. But I need to know the ACTUAL profit percentage is. What formula (in excel) would solve for C?