EX-99.7 45 ea025949101_ex99-7sch5.htm SCHEDULE 5 - DATA COMPARE

Exhibit 99.7 Schedule 5

 

ASF Loan Number Loan ID Seller Loan ID Investor Loan ID Transaction ID Field Name Source Verified Value Bid Tape Value Comment
400095916 XX     XX Application Date complianceDetailPage XX XX Application date confirmed from application 1039.
400098330 XX     XX Note Date notePage XX XX Note date verified from Note document.  Tape Data is the Disbursement Date.
400098330 XX     XX Verified Doc Type employmentIncomePage 24 Month Bank Statement ALT DOC Doctype updated as per loan program and documentation.
400098350 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC Doctype updated per loan program & documentation.
400098350 XX     XX Calculated DSCR diligenceFinalLookPage 1.119 1.1 Our calculated DSCR is Rents of $1,600/ PITIA of $1,430.23 = 1.119 DSCR Tape data showing 1.1 difference is 0.019
400098332 XX     XX Property Type propertyValuationPage Two to Four Unit 2-4 Family Property type confirmed with appraisal  report.
400098332 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC DSCR file income not required.
400098332 XX     XX Calculated DSCR diligenceFinalLookPage 1.14 1.17 Tape Considered the highest rent of $3300 from 1025 market rent but Lease rent is $3200. 
400098360 XX     XX Note Date notePage XX XX Note date verified from Note document.  Tape value is the Disbursement Date.
400098360 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doctype updated as per loan program and documentation.
400098360 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 49.77 32.92 DTI discrepancy on the loan. Audit DTI is 49.7670%.  Initial Lender DTI, per the Tape, is 32.92%. However, a corrected 1008 was received putting the DTI at 49.96%.  That is 0.193% variance from the audit DTI; within tolerance.
400100979 XX     XX Note Date notePage XX XX Note date verified from Note document page 492
400100979 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doctype updated per loan program & documentation.
400100979 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 4680.73 3571.53 Qualifying Total Housing expenses PITIA is matching with 1008 Tape data not included Taxes and Insurance
400100979 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 48.18 48.66 DTI discrepancy on the loan, as per the DTI calculations our calculated DTI is 48.21% but Originator DTI is 48.66%. Variance is 0.45 within tolerance due to the difference in tradelines
CC $138 reflecting in final 1003 but in credit report its reflecting $62 updated as per credit report
CC $51 reflecting in final 1003 but in credit report its reflecting $48 updated as per credit report
400098339 XX     XX Verified Doc Type employmentIncomePage 1099 Verified ALT DOC Verified Doc Type considered per loan program & documentation.
400100992 XX     XX Note Date notePage XX XX Note date updated per Note document on page #585.
400100992 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC Doc type updated per income qualification method, DSCR was used fr qualification.
400098351 XX     XX Note Date notePage XX XX Note date considered from Note on page 701.
400098351 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Verified Doc Type considered per loan program & documentation.
400098351 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 8163.67 5692.92 Tape data excluding TIA in calculation.
400098351 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 19.79 19.47 DTI Variance 0.03 less than 1% tolerance due to monthly property tax discrepancy between 1008 & actual tax cert.
400101006 XX     XX Note Date notePage XX XX Note date updated per Note document on page #361
400101006 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doc type updated per income qualification method,, 12 months bank statements were used for qualfiication.
400098312 XX     XX Borrower 1 Self-Employment Flag employmentIncomePage No Yes B1 is wage earner  and asset depletion fie.
400098312 XX     XX Note Date notePage XX XX Tape considered disbursement date as note date.
400098312 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 3543.92 3266.99 Escrow waiver file , Tape considered the P&I as monthly payment.
400098323 XX     XX Note Date notePage XX XX Note date verified from Note document
400098323 XX     XX Verified Doc Type employmentIncomePage Business P&L ALT DOC Doctype updated as per loan program and documentation.
400101003 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doctype updated as per loan program and documentation.
400101003 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 2950.63 2108.75 Tape Data not included Monthly Property Tax & Homeowner's insurance amounts, However file is No Escrows.
400101003 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 31.02 31.25 DTI discrepancy on the loan, as per the DTI calculations our calculated DTI is 31.02% but Tape data DTI is 31.25%. Variance is 0.23 within tolerance.
400100997 XX     XX Property Type propertyValuationPage PUD Single Family Detached Property type is PUD verified from appraisal pg. #54 and PUD rider is on pg. #337.
400100997 XX     XX Verified Doc Type employmentIncomePage 1099 Verified ALT DOC Doctype updated as per loan program and documentation.
400100997 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 1873.51 1842.26 Tape Data not included HOA amount and the subject property is PUD. HOA per Appraisal Report is $375/12=$ 31.25. 
400100997 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 43.57 43.66 DTI discrepancy on the loan, as per the DTI calculations our calculated DTI is 43.57% but Originator DTI is 43.66%. Variance is 0.09 within tolerance DUE to HOA amount in Appraisal report $31.25*12=$375 but in 1008 document HOA amount is $39.58 due to that there is a DTI Discrepancy.
400101002 XX     XX Property Type propertyValuationPage Two to Four Unit 2-4 Family Property has 4 units per 1003, 1008 and appraisal report.
400101002 XX     XX Note Date notePage XX XX Note date updated per Note document on page #369.
400101002 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC Doc type updated per income qualification method, DSCR was used for qualification.
400100985 XX     XX Qualifying LTV propertyValuationPage 65.55 70.00 Received updated 1008 with correct value LTV is now in line at 65.50 refer to findings  
400100985 XX     XX Qualifying CLTV propertyValuationPage 65.55 70.00 Property value is not matching with Appraisal due to that there is LTV Variance. Appraisal value is as per 1003 and 1008 appraisal value is XXwhere as actual appraisal value is XX.
400100985 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC File is DSCR not required for Income documents.
400100985 XX     XX Calculated DSCR diligenceFinalLookPage 1.065 1.01 Correctly calculated DSCR Ratio is Rent amount$2,200/PITIA$2,064.91=1.065 and Originator DSCR is =1.010 Variance is 0.055.
400100972 XX     XX Property Type propertyValuationPage PUD Single Family Detached Property type confirmed with appraisal report.
400100972 XX     XX Note Date notePage XX XX Tape considered the disbursement date as note date.
400100972 XX     XX Borrower 1 Self-Employment Flag employmentIncomePage No Yes SSI, Asset utilization and Retirement incomes are used.
400100972 XX     XX Verified Doc Type employmentIncomePage Asset Utilization (DTI) ALT DOC SSI, Asset utilization and Retirement incomes are used.
400100972 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 4174.96 3065.42 Escrow waiver file, tape not considered the Tax and insurance amount.
400100991 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doc type updated per income qualification method, 12 months bank statements were used for qualication.
400100991 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 16.09 17.89 Audited DTI is 16.09 and Lender DTI is 17.89. the difference is 1.8. This is because:

(1) Lender considered hazard insurance amount as $296.50 whereas per hazrad insurance, final CD, payment letter, IEAD it is $254.83.
(2) Lender considered all other monthly payments as $10,949 where as per documentation it is $9,317 (REO $322 + $Monthly Debt $8,995). The difference is $1,632. GAP credit report is missing from file.
400100976 XX     XX Property Type propertyValuationPage PUD Single Family Detached Property type is PUD verified from appraisal pg. #61 and PUD rider is on pg. #458.
400100976 XX     XX Note Date notePage XX XX Note date verified from Note document
400100976 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doctype updated as per loan program and documentation.
400100976 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 3530.36 3452.37 Tape Data not included HOA amount and the subject property is PUD. HOA per Appraisal Report is $ 78. 
400100976 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 39.62 39.60 DTI discrepancy on the loan, as per the DTI calculations our calculated DTI is 39.62% but Tape data DTI is 36.60%. Variance is 0.02 
400098315 XX     XX Property Type propertyValuationPage Two to Four Unit Single Family Detached Property type is 2 to 4 Units verified from appraisal pg #34 and 1-4 rider is on pg. #1
400098315 XX     XX Prepayment Penalty Type notePage Hard 3 Prepayment Penalty Type updated Correctly.
400098315 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC File is DSCR not required for Income documents.
400098315 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 7158.3 6061.24 Qualifying Total Housing Expense PITIA Updated as per 1008 Document.
400098315 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 0 282.19 Debt to Income Ratio not required for DSCR Program.
400101005 XX     XX Note Date notePage XX XX Note date verified from Note document
400101005 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 5420.35 4060.39 Tape Data not included Monthly Property Tax & Homeowner's insurance amounts & HOA amount, However file is No Escrows.
400100994 XX     XX Property Type propertyValuationPage PUD Single Family Detached Property type is PUD verified from appraisal pg. #39 and PUD rider is on pg. #453.
400100994 XX     XX Note Date notePage XX XX Note date verified from Note document
400100994 XX     XX Verified Doc Type employmentIncomePage 12 Month Bank Statement ALT DOC Doctype updated as per loan program and documentation.
400100994 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 2591.3 2506.15 Tape Data not included HOA amount and the subject property is PUD. HOA per Appraisal Report is $ 85.15. 
400100994 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 46.57 50.00 Income was revised (increased) from a prior calculation.  Tape Data is the DTI with the earlier income calculation; Audited/True Data is the DTI with the updated/revised income.
400100988 XX     XX Prepayment Penalty Type notePage Hard 3 Prepayment penalty type updated from drop down. tape and true data gives same value.
400100988 XX     XX Note Date notePage XX XX Note date updated per Note document on page #281.
400100988 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC Doc type updated per income qualification method, DSCR was used for qualification.
400100988 XX     XX Calculated DSCR diligenceFinalLookPage 1.095 1.08 Audited DSCR is 1.095, which is based off the rent $5,000 / PITIA of $4,566.09 ($3,736.09 P&I + $750 Taxes + $80 Hazard Insurance + $0.00 Flood Insurance). Lender DSCR is 1.08. The difference in the DSCR calculation is 0.015. Received DSCR worksheet DSCR is in line at 1.095
400100993 XX     XX Property Type propertyValuationPage Two to Four Unit Single Family Detached Property has 4 units per 1003, 1008, appraisal report.
400100993 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC Doc type updated per income qualification method, DSCR was used for qualfiication.
400100987 XX     XX Property Type propertyValuationPage Two to Four Unit Single Family Detached property type confirmed with appraisal report.
400100987 XX     XX Verified Doc Type employmentIncomePage Debt Service Coverage Ratio ALT DOC DSCR file.
400100987 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 3348.41 2387.62 Escrow waiver file, tape not considered the Tax and insurance amount into PITI.
400100987 XX     XX Calculated DSCR diligenceFinalLookPage 1.135 1.13 Calculated DSCR is Rent $3800 / PITI$3348.51 = 1.135.
400100973 XX     XX Verified Doc Type employmentIncomePage Asset Utilization (DTI) ALT DOC Asset depletion files comes under alt Doc category.
400100973 XX     XX Borrower 1 Self-Employment Flag employmentIncomePage No Yes Asset depletion file and borrower not a self-employed.
400104433 XX     XX Occupancy the1003Page Primary Residence OwnerOccupied Occupancy is Primary Residence confirmed in Final 1003.
400104433 XX     XX Interest Rate notePage 7.25 0.0000 Interest Rate is 7.25% per Note document.
400104433 XX     XX Monthly Property Tax Amount titlePage 2899.1 0.00 Property Tax Amount per property cert page #643 is $34,789.18 annually. So Monthly Property Tax Amount will be $34,789.18/12 = $2,899.10
400104433 XX     XX Total Monthly Property Insurance Amount propertyInsurancePage XX XX Property Insurance Amount per property Insurance document page #399 is $XX. So Total Monthly Property Insurance Amount will be $XX
400104433 XX     XX Qualifying Total Debt Income Ratio diligenceFinalLookPage 33.29 32.20 DTI variance due to variance in All other monthly payments $815.
400104449 XX     XX Borrower 1 Self-Employment Flag employmentIncomePage Yes coming soon Borrower 1 Self-Employment Flag is yes hence updated the same.
400104449 XX     XX Total Monthly Property Insurance Amount propertyInsurancePage XX XX Total Monthly Property Insurance Amount includes HOI amount and Flood insurance amount. Tape data does not include flood insurance. 
400100986 XX     XX Note Date notePage XX XX Tape considered the disbursement date as note date.
400100986 XX     XX Verified Doc Type employmentIncomePage 1099 Verified ALT DOC 1099-only was used for income qualification.
400100986 XX     XX Qualifying Total Housing Expense PITIA diligenceFinalLookPage 2398.51 2398.50 Difference of $0.01 due to rounding.
400104464 XX     XX Application Date complianceDetailPage XX XX Confirmed the application date from the Initial 1003.