% of list price realized and % of appraisal price realized Formulas

[vaio]

I am trying to figure out the formulas to obtain % of List Price Realized and the % of Appraisal Price Realized. I was given a table similar to this one:

Project APPRAISAL LIST PRICE SELL PRICE LIST DATE sale date SQFT.
CO.129 $67,800 $67,000 $64,500 01-Feb-11 19-Apr-11 1250
AM.1082 $69,900 $68,900 $66,890 25-Apr-11 28-Jun-11 1350
BN.1029 $70,300 $69,900 $66,700 25-Apr-11 09-Sep-11 1250
AM.43-23 $95,300 $93,000 $94,150 01-Jan-11 28-Mar-11 1700

And I am asked to obtain the % of list price realized and % of appraisal price realized.


Project: AM.43-23
Appraisal: $95,300.00
List Price: $93,000.00
Sale Price: $94,150.00
% of List Price Realized :
% of Appraisal Realized : =((C16-C18)/C18)*100 ( This is what i used but it is incorrect) any tips on how to obtain these 2 formulas?
Thank you!

 

[Andrew Poulsom]

List price =C17/C16, Appraisal price =C18/C16 formatted as Percent.

 

[vaio]

Thanks so much!