Get documents about "12345-SFR-shortsale-yyyymmdd
Document Sample
Short Sale Loss - Monthly or Quarterly Download
Single-Family Residence (SFR)
Column Field # Field Description Type Comments Required Allowable Values Formatting Width 2b(1) if written 2b(2) if NOT 2b(3) if
Field Req. down prior to previously previously
Loss Share modified modified
The as-of-date for the file. For
example, for a report submitted July 15,
2009 the Shared-Loss Month cutoff
date would be June 30, 2009 and the
A 1 Shared-Loss Month field would appear as 20090630. Date Yes YYYYMMDD 8 x x x
Unique identifier used for all reporting
records. May be FDIC specific loan ID
B 2 Loan number or other account number. Alphanumeric Yes 34 x x x
C 3 Interest Paid-to date Last interest paid date. Date Yes YYYYMMDD 8 x x x
D 4 Short sale payoff date Date short sale transaction completed. Date Yes YYYYMMDD 8 x x x
The contractual rate of interest currently
E 5 Note Interest rate applied to this note. Numeric Yes .99999 6 x x x
Data Code Field - Populate field with 1 = Owner Occupied; 2 =
Occupancy status when notice of allowable values. If allowable code is not Investor Property; 3 = Second
F 6 Occupancy default was filed. Numeric used, data key definition is required. No Home; 4 = Vacant 9 1 x x
Gross annual household income
Household current gathered or documented (last Please provide if property is owner-
G 7 annual income documented record). Numeric occupied and data is available. No 9(12).99 15 x x
Estimated NPV of loan NPV value generated as an alternative Please provide if property is owner-
H 8 modification to foreclosure. Numeric occupied and data is available. No 9(12).99 15 x x
If more than one valuation occurred
within 90 days, please provide all recent
valuations. Please provide unique field
names for each valuation and a data key
for valuation type. E.g. val_date1
Property valuation date. Includes val_date2, val_amt1 val_amt2, val_type1
I 9 Valuation Date interior and exterior evaluations. Date val_type2. Yes YYYYMMDD 8 x x x
Property value determined by Appraisal,
J 10 Valuation Amount BPO, interior, or exterior evaluation. Numeric Yes 9(12).99 15 x x x
INT = Interior; EXT = Exterior;
AVM = Automated Valuation
Model; BPO = Broker price
Opinion; DA = Desktop
Appraisal; DB = Drive By; FA =
Data Code Field - Populate field with Full Appraisal; PAU = Prior
allowable values. If allowable code is not Appraisal Used; TV = Tax
K 11 Valuation Type Indicates valuation type. Alphanumeric used, data key definition is required. Yes Valuation; None; Other 40 x x x
Unpaid principal balance at short sale Principal balance excluding past due Yes, if
L 12 Loan UPB payoff date. Numeric interest or accrued fees. applicable 9(12).99 15 x
For loans written down to book value
Book Value at date of Loss Share prior to Loss Share Agreement. If not Yes, if
M 13 Book Value Agreement. Numeric applicable, please insert blank(s). applicable 9(12).99 15 x
Principal payments received post For loans written down to book value
Post closing principal closing for loans written down at date of prior to Loss Share Agreement. If not Yes, if
N 14 payments Loss Share agreement. Numeric applicable, please insert blank(s). applicable 9(12).99 15 x
NPV of projected cash NPV submitted for loan restructuring Required only for short sales following a Yes, if
O 15 flows at loan modification loss share payment. Numeric covered restructuring. applicable 9(12).99 15 x
Post modification Amount of principal payments received Required only for short sales following a Yes, if
P 16 principal payments between modification and short sale. Numeric covered restructuring. applicable 9(12).99 15 x
1 of 18
Short Sale Loss - Monthly or Quarterly Download
Single-Family Residence (SFR)
Column Field # Field Description Type Comments Required Allowable Values Formatting Width 2b(1) if written 2b(2) if NOT 2b(3) if
Field Req. down prior to previously previously
Loss Share modified modified
Accrued interest that qualifies as a
covered loss—not all accrued interest as
reportable under GAAP. Accrued
interest equals zero in case of short sale Yes, if
Q 17 Accrued interest Accrued Interest Limited to 90 Days. Numeric following a covered restructuring. applicable 9(12).99 15 x
Attorney's fees and costs (BK and FC).
May include court fees, publications, Yes, if
R 18 Attorney's fees title fees, and motions for relief. Numeric applicable 9(12).99 15 x x x
May include origination fees,
commissions, title and closing, pest, Yes, if
S 19 Foreclosure costs/fees and recording/county fees. Numeric applicable 9(12).99 15 x x x
May include property securing, pool
drainage, broken windows, repairs to Any such costs with respect to
Property preservation any structural damage or environmental remediation activities are limited to
costs, maintenance and abatements, grass cutting, and utility $200,000 without Assuming Bank having Yes, if
T 20 repairs bills. Numeric received the prior consent of the FDIC. applicable 9(12).99 15 x x x
Yes, if
U 21 T&I advances Tax & Insurance Advances. Numeric applicable 9(12).99 15 x x x
Appraisal/ Broker's Price Yes, if
V 22 Opinion fee Appraisal/Broker's Price Opinion fees. Numeric applicable 9(12).99 15 x x x
Yes, if
W 23 Inspections Property inspections. Numeric applicable 9(12).99 15 x x x
Please provide written explanation of Yes, if
X 24 Other advances Other advances/costs. Numeric other costs or advances. applicable 9(12).99 15 x x x
Cost for keys or other incentive Yes, if
Y 25 Incentive to Borrower payment to borrower. Numeric applicable 9(12).99 15 x x x
Amount accepted in Purchase Contract
(add back the normal property
maintenance fees or other fees which are
Amount accepted in included in the gross balance Yes, if
Z 26 Short-Sale Net amount accepted at Short Sale. Numeric recoverable by purchaser). applicable 9(12).99 15 x x x
Yes, if
AA 27 Hazard insurance Hazard Insurance Proceeds. Numeric applicable 9(12).99 15 x x x
Yes, if
AB 28 Mortgage insurance Mortgage Insurance proceeds. Numeric applicable 9(12).99 15 x x x
T&I escrow balance, if Yes, if
AC 29 positive Positive T & I Escrow account balance. Numeric applicable 9(12).99 15 x x x
Please provide written explanation of Yes, if
AD 30 Other credits Other account credits. Numeric other credits. applicable 9(12).99 15 x x x
Calculated loss amount submitted for
AE 31 Loss Amount coverage. Numeric Yes 9(12).99 15 x x x
FDIC unique asset identifier found in
Schedule A. Provide loan ID if FDIC
asset identifier is not available for loans
AF 32 FDIC Asset ID added to Schedule A after adjustments. Alphanumeric Yes 34 x x x
AG 33 MI claim date Date initial MI claim filed Date No YYYYMMDD 8 x x x
AH 34 MI claim amount Initial MI claim amount filed Numeric No 9(12).99 15 x x x
Date MI coverage paid, rescinded or
AI 35 MI response date denied Date No YYYYMMDD 8 x x x
Data supplied above is used to verify the loss amount provided in Section 2 of the Loss Share Certificate. Specifically the Loss Amount is
verified via the following calculations:
Loan written down to book value prior to Loss Share - Exhibit 2b(1)
2 of 18
Short Sale Loss - Monthly or Quarterly Download
Single-Family Residence (SFR)
Column Field # Field Description Type Comments Required Allowable Values Formatting Width 2b(1) if written 2b(2) if NOT 2b(3) if
Field Req. down prior to previously previously
Loss Share modified modified
Field 13 minus Field 14 plus Fields 18-
Gross Balance 25 (only the costs incurred after closing
Recoverable date)
Total Cash Recovery Less Sum of Field 26-30
(Gain)/Loss Amount Loss Amount
No preceding loan mod under loss share - Exhibit 2b(2)
Gross Balance
Recoverable Sum of Field 12 and Fields 17- 25
Total Cash Recovery Less Sum of Field 26 - 30
(Gain)/Loss Amount Loss Amount
Short Sale after a covered loan mod
Gross Balance Field 15 minus Field 16 plus Fields 18 -
Recoverable 25
Total Cash Recovery Less Sum of Field 26 - 30
(Gain)/Loss Amount Loss Amount
3 of 18
SFR Short Sale file
Data Validations
Column Field # Field Validation Criteria Error or Warning
A 1 Shared-Loss Month Must be populated. Error
B 2 Loan number Must be unique Error
C 3 Interest Paid-to date Must be populated. Warning
D 4 Short sale payoff date Must be populated. Warning
E 5 Note Interest rate Must be populated. Warning
I 9 Valuation Date Must be populated. Warning
J 10 Valuation Amount Must be populated. Warning
K 11 Valuation Type Must be populated. Warning
L 12 Loan UPB Must be populated. Warning
M 13 Book Value Must be populated. Warning
N 14 Post closing principal payments Must be populated. Warning
O 15 NPV of projected cash flows at loan modification Must be populated. Warning
P 16 Post modification principal payments Must be populated. Warning
Q 17 Accrued interest Must be populated. Warning
R 18 Attorney's fees Must be populated. In some cases there is a legitimate business reason(s) why field is not populated. Warning
S 19 Foreclosure costs/fees Must be populated. In some cases there is a legitimate business reason(s) why field is not populated. Warning
T 20 Property preservation costs, maintenance and repairs Must be populated. In some cases there is a legitimate business reason(s) why field is not populated. Warning
U 21 T&I advances Must be populated. In some cases there is a legitimate business reason(s) why field is not populated. Warning
4 of 18
(Fund ID) - (Failed Institution)
(YYYYMMDD)
(Record Count)
SHARED_LOSS_MONTH LOAN_NUMBER INTEREST_PAID_TO_DATE
SHORT_SALE_PAYOFF_DATE NOTE_INTEREST_RATE OCCUPANCY
HOUSEHOLD_CURRENT_ANNUAL_INCOME ESTIMATED_NPV_OF_LOAN_MODIFICATION
VALUATION_DATE VALUATION_AMOUNT VALUATION_TYPE LOAN_UPB
BOOK_VALUE POST_CLOSING_PRINCIPAL_PAYMENTS
NPV_OF_PROJECTED_CASH_FLOWS_AT_LOAN_MODIFICATION
POST_MODIFICATION_PRINCIPAL_PAYMENTS ACCRUED_INTEREST ATTORNEYS_FEES
FORECLOSURE_COSTS_FEES
PROPERTY_PRESERVATION_COSTS_MAINTENANCE_AND_REPAIRS T_AND_I_ADVANCES
APPRAISAL_BROKER_PRICE_OPINION_FEE INSPECTIONS OTHER_ADVANCES
INCENTIVE_TO_BORROWER AMOUNT_ACCEPTED_IN_SHORT_SALE HAZARD_INSURANCE
MORTGAGE_INSURANCE T_AND_I_ESCROW_BALANCE_IF_POSITIVE OTHER_CREDITS
LOSS_AMOUNT FDIC_ASSET_ID MI_CLAIM_DATE
MI_CLAIM_AMOUNT MI_RESPONSE_DATE
Related docs
Other docs by niusheng11
