> 7
!"#$%&'()*+,./01234569Root Entry F88WorkbookuiSummaryInformation(DocumentSummaryInformation8d ' `\pNancy Ba=
=.B#8X@"1rArial1rArial1rArial1rArial1rArial1rArial1rArial1rArial1rArial1rArial1$rArial1rVerdana1rArial1rVerdana1rVerdana"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_)
"$"#,##0$[$409]dddd\,\ mmmm\ dd\,\ yyyy
m/d/yy;@
00000"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ 2]\ #,##0.00_);[Red]\([$ 2]\ #,##0.00\) + ) , *
@ h@ @ x@ @ ,@ @ "p@ @ d@ @ l@ @ d@ @ l@ @ l@ @ 1 l@ @ ! "X "x@ @ + *x@ @ + *@ @ + 1*@ @ +
*@ @ + *x@ + `@ @ + `@@ + `@ + `@ h@ + l @ + h@ @ + ! "x@ @ `;!Sheet1YeSheet2`fSheet3ggSheet4nhSheet5 ;"WO Adj PriceVendorCityTypeCt WtCutColorClarityCertReference Source: (Rap, Guide, Palmieri, etc.)Of the sample selected: Subject:What is the mode?What is the median?What is the mean?What is the range?DateRoundedMeanMedianModeRange$TEnter the (same) Rap or other reference for the Subject in every row under /Subj Ref9Enter the Subject carat weight in every row under Subj WtGEnter the source of the reference price above after "Reference Source:)
Const $/CTII adjusted the selling price of each comparator to 20xx dollars by . . . LIn order to analyze the sales, I converted all transaction prices to $/carat+Analyze the amount of adjustment in "Ratio"Indicated Value:Adj Price/CT #
Const $ Adj *Subj Ct WtLot #Subj Ref $/Ct / Comp Ref $/Ct * Ratio$ Price
Price /Ct,Col AL: Enter data for each comparable saleZ Col M: Divide $ Price by Ct Wt (Col F/Col H) to convert transaction prices to Price/ctRiCol N: Enter the adjustment to convert to constant dollars in Const $ Adj (US BLS Inflation Calculator) >JY Col 0: Multiply Price/Ct x Const $ Adj (Col M x Col N) to find "Constant Dollars /Ct"ClCol P: Enter the per/carat reference price for Subject (from an industry matrix) in every row under Subj RefdbCol Q: Enter the per/carat reference price for each comp (from the same matrix) under Com Ref $/CtVr Col R: Calculate Ratio of subject/comp by dividing Subject Reference $/Ct by Comp Reference $/Ct (Col P/Col Q)T Col S: Multiply each Constant $/Ct by Ratio (Col O x Col R) to get Adjusted $/CtG4Col T: Enter the Subject Carat Weight into every row%r Col U: Multiply each Adjusted $/Ct times the Subject Ct Weight (Col S x Col T) to get each Adjusted Price what_m^ that comp would have sold for had its value attributes been the same as the subject Analysis/Col U: SORT data by adjusted price, low to high`Col V: It may be necessary to round the adjusted prices to a significant figure to find the Modes Col W: Subtract 1 from each Ratio (Col R). The results closest to 1 , either higher or lower, are more reliable.#YThe comps that needed least adjustment are the most reliable. (Ratios closest + or  "1")AWhat is your opinion of value? (Rounded to a significant figure.)eWhat is your degree of confidence: a reasonable degree of jewelry appraisal probability or certainty?LW [d &======================================Comparison of comps to subject:Analysis of sales data:Do not use the mean as the indicated value. (Rejected by IRS.) Use the least adjusted, (above), the mode if there is one, and/or median. Formula to round to a significant figure is " =ROUND(COLrow, 3) " for nearest thousand; 2 for nearest hundred might help establish a modeState your opinion of the (kind of value), to a reasonable degree of jewelry appraisal probability (more than 50% probable) or certainty (more than 80% certain). mNever state the % on an appraisal or in testimony. Probability and Certainty are legally understood measures.~Write a narrative explaining the similarities and differences between each comp and the subject, how and why you adjusted each[transaction price, your analysis of the results, and how you formed your opinion of value. .This is best done by breaking it into 2 parts.Comp 1 (compare and explain differences to subject, and explain significance) Comp #1 weighed more than the subject but was lower in color.The larger size is more desirable, but the lower color is less desirable. I adjusted the transaction price down for weight and up for color to make #the comp equivalent to the subject Comp 2 (compare and explain differences to subject, and explain significance) etc. Comp #2 weighed the same as the subject, but the color was vbetter while the clarity was lower. I adjusted the transaction price to compensate down for color and up for clarity. Next, I adjusted the selling price of each comp for any differences in value attributes to make it equivalent to the subjectEtc, etc . . .Opinion of value1 RatioRO7rUP
[
ccV
' >ML_d
dMbP?_*+%.+&C&"Arial,Bold"Analysis of Comparable Sales
Page &PM HP Photosmart D7400 series4)C
od,,LetterDINU"` X6` SMTJP HP Photosmart D7400 seriesInputBinFORMSOURCERESDLLUniresDLLHPPreAnalysisFalseMSPreAnalysisFalseHPReportSymmetricMarginsFalseHPPaperSourceMappingTrueHPMinimizeMarginsTrueHPAlignMarginsForMDTrueDuplexNONEHPPrintPreviewFalseHPOverSprayOptionAutomaticHPOverSpray100HPBorderLessPhotoFalseHPCustomBorderlessTrueHPOutputOrderReverseTrueJobUITruePaperSizeLETTEROrientationPORTRAITHPPaperSizeDuplexConstraintsLEGALHPDocPropResourceDatahpzhl5ha.cabHPNUseDiffFirstPageChoiceTrueHPDryTimeOptionAutomaticHPDryTime0HPInkVolumeOptionAutomaticHPInkVolumeNormalHPPrintInGrayScaleFalsePrintQualityNormalPrintQualityGroupPQGroup_2HPJobAccountingHPJOBACCT_TIMESTAMPHPColorModeCOLOR_MODEHPPDLTypePDL_PCL3HPXMLFileUsedhpo74003.xmlHPTilingSelectionTrueHPMediaTypeTreeviewPopupTrueColorModeColor24MediaTypeAUTOMATICResolution600dpiPQDPIInstalledHPMirrorPrintFalseHPAutoDuplexScalingTrueHPPrintOnBothSidesManuallyFalseHPManualDuplexDialogItemsInstructionID_01_FACEUPNOROTATEHPManualDuplexPageRotateUserRotateHPManualFeedOrientationFACEUPHPSpeedMechFastDraftHPOutputBinOrientationFACEUPHPManualDuplexDialogModelModalHPManualDuplexPageOrderOddPagesFirstHPMapManualFeedToTray1FalsePSAlignmentFileHPZ3A5haPSServicesOptionHPServiceFileNameEndHPConsumerCustomPaperHPCustomHPColorSelectionForHPAEnabledHPSmartDuplexSinglePageJobTrueHPBornOnDateHPBODHPInputColorSpaceCOLORSMARTJobUINetworkTrueHPDriverDataDriverDataHPCustomSizeCommandTRUEHPSendPreloadCommandTRUEESPRITSupportedTrueHPUseAutoDuplexUnitFalseHPRESDLLNameHPFRS5haHPRedEyeReductionOffHPDigitalImagingHPHomePrintingHPSmartFocusOnHPContrastOnHPDigitalFlashOnHPSharpnessLowHPSmoothingOnHPJpegPngPassthroughTrueHPReverseBandOrderForEvenPagesReverseBandOrderHalftoneHT_PATSIZE_DEFAULTHPMDSideCountTrueHPHagakiPrintingTRUEHPHTDLLNameHPFIG5haHPMHDLLNameHPFIE5haHPHPAFilterTrueHPIntentPERCEPTUALHPAdvancedColorSettingTrueHPICCPrinterFamily5700_6500HPCRDCommandTrueHPSendUnitMeasureCommandTRUEHPPaperSizeTreeviewPopupMetricHPSimplifiedUITrueHPPosterPrintingOptionSUIFalseHPPhotoFixBASICHPRPOFileNamehpfcn071.rpoIUPHdLetter
o [none] [none]Arial4Pd?NANCY<Automatic>44dMicrosoft Office ExcelNone< BBICEDEXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXENancyNFSDESKIPACDRWDSGATCAPI;F4E8Q;Ki݅&E%9xPPBHAERP"d,,??U}}
}
}m
}m>'
(!
($
(
(
(
)(
)
)
)
)
)
)
*)
)"
*
*%
*&
+'
,
+#
*

N~
8?$% LL
LL
! " LL LL~
# LL'
DA"
L~
8@$%
! " # LA"~
8@$%
! " # "~
8@$%
! " # "~
8@$%
! " # " ~
8@$%
! " # "~
8@$%
! " # "~
8 @$%
! " # "~
8"@ $%
! " # "
!%X"
D
......
/
00
2
341
6*
6+
6,
6
6.
6/
60
61
62
63
&4
&
5
55
5
56
5
57
5
58
&&
7
7
DlBR33333338^&BBB&4&0&&&& !"#$%&'()*+,./0123456789:;<= 7
7
!7
!7!
!"7
"7#7
#7$
$79$%7&7
&M'7
'7?(7
(7@)7
)7:*7
*7;+7
+7A,7
,7B
77.
.C/
/D
0E
17<
2=
37F
47G
57H
67I
77J87
9>
:7
;7
<7K
=7L@D00,
>@7
' f
dMbP?_*+%"??U>@7
' g
dMbP?_*+%"??U>@7
' h
dMbP?_*+%"??U>@7
' &i
dMbP?_*+%"??U>@7
Oh+'0@HXh
NancyNancyMicrosoft Excel@RG@]08՜.+,04 PXt
Indiana University'Sheet1Sheet2Sheet3Sheet4Sheet5Sheet1!Print_AreaWorksheets
Named Ranges