CAR Technology & Tools 2 — Questions and Answers
Question 1: What is the primary function of the Uniform Collateral Data Portal (UCDP) in the appraisal review process?
- To schedule appraisal inspections electronically
- To submit appraisal data in XML format to Fannie Mae and Freddie Mac (Correct answer)
- To store comparable sales photographs for reviewers
- To generate automated adjustments for market conditions
Correct answer: To submit appraisal data in XML format to Fannie Mae and Freddie Mac
UCDP is the joint GSE portal that accepts appraisal data submissions in MISMO XML format for Fannie Mae and Freddie Mac loan deliveries.
Question 2: Collateral Underwriter (CU) assigns a risk score to appraisals on a scale of:
- 1 to 10
- 1 to 5 (Correct answer)
- 0 to 100
- A to F
Correct answer: 1 to 5
Fannie Mae's Collateral Underwriter scores appraisals on a 1–5 scale, with higher scores indicating greater risk and more scrutiny warranted.
Question 3: Which data standard governs the XML schema used for electronic appraisal report submissions to GSEs?
- UAD
- MISMO (Correct answer)
- ANSI
- FIRREA
Correct answer: MISMO
MISMO (Mortgage Industry Standards Maintenance Organization) defines the XML schema standard used for transmitting appraisal data electronically.
Question 4: A reviewer notices that a CU feedback message flags an appraisal for 'overvaluation risk.' The most appropriate next step is to:
- Automatically reject the appraisal without further review
- Review the comparables and adjustments for support relative to the flagged risk (Correct answer)
- Request the appraiser raise the value to match CU's estimate
- Dismiss the flag since CU is only advisory
Correct answer: Review the comparables and adjustments for support relative to the flagged risk
CU flags are risk signals that prompt deeper scrutiny of comparable selection and adjustments, not automatic rejection or value changes.
Question 5: Which tool is most commonly used by appraisers to extract and analyze paired sales from MLS data when developing regression-based adjustments?
- Electronic Appraisal Delivery (EAD) portal
- Statistical analysis or spreadsheet software (Correct answer)
- UCDP submission portal
- Collateral Underwriter dashboard
Correct answer: Statistical analysis or spreadsheet software
Appraisers use statistical software or spreadsheet programs such as Excel to perform paired-sales or regression analysis from MLS extracted data.
Question 6: In appraisal software using UAD standardized condition ratings, a property rated C4 is best described as:
- A newly constructed property with no deferred maintenance
- A property with minor deferred maintenance and some updating needed (Correct answer)
- A property in average condition that has been adequately maintained
- A well-maintained property with only minor wear
Correct answer: A property with minor deferred maintenance and some updating needed
UAD condition rating C4 indicates a property with some deferred maintenance and minor obsolescence that requires updating.
Question 7: FHA's Electronic Appraisal Delivery (EAD) portal differs from UCDP primarily in that it:
- Accepts only PDF appraisals rather than XML data
- Processes appraisals specifically for FHA-insured loans rather than conventional GSE loans (Correct answer)
- Is operated by Freddie Mac instead of HUD
- Only reviews commercial properties
Correct answer: Processes appraisals specifically for FHA-insured loans rather than conventional GSE loans
The EAD portal is HUD's system for receiving FHA case appraisals, while UCDP serves Fannie Mae and Freddie Mac conventional loan submissions.
CAR Technology & Tools 2
What is the primary function of the Uniform Collateral Data Portal (UCDP) in the appraisal review process?