Attachment 2 MCM 4.0 Appendix A MCM Historical Data FY18 to FY24_.xlsx

14 KB Posted

Attached to
4. 0 Mortgagee Compliance Manager (MCM) Services
Solicitation number
Solicitation_86616025R00002
Issued by

About this file

Written by GovTribe AI ·

This Excel file is an Appendix A containing historical data for Mortgagee Compliance Manager (MCM) activities from Fiscal Year 2018 to Fiscal Year 2024. The data tracks various mortgage-related activities including extensions, over-allowables, claims, title reviews, CWCOT (Claims Without Conveyance of Title) claim reviews, administrative remedies, reconveyance activities, and customer service metrics across multiple fiscal years.

Key observations from the historical data show a general trend of fluctuating activity levels across different categories. For instance, extensions peaked at 34,332 unique cases in FY2019 and declined to 6,892 in FY2024. Over-Allowables remained consistently high, ranging from 132,872 to 231,974 total activities. Claims processing, reconveyance activities, and customer service interactions are also tracked, providing a comprehensive view of mortgage compliance management workload from FY2018 through the current fiscal year. This data corresponds with the related HUD solicitation for MCM 4.0 Services, which seeks contractor support for pre-conveyance and post-conveyance activities associated with FHA Single Family insured assets.

View the file

Other files

File Type Posted
Solicitation 86616025R00002 Mortgagee Compliance Manager MCM 4.0 Amendment 0001 Consolidated Questions and Answers.pdf PDF
Revised Attachment 6 MCM 4.0 Pricing Sheet Amendment 0001.xlsx XLSX spreadsheet
Solicitation Number 86616025R00002 Mortgagee Compliance Manager MCM 4.0 Conformed Solicitation Copy Amendment 0001.pdf PDF
Solicitation 86616025R00002 _Amendment 0001 SF 30 Acknowledge Amendment Document .pdf PDF
Mortgagee Compliance Manager 4.0 Amendment 001 Summary of Changes .pdf PDF
Solicitation 86616025R00002 4.0 Mortgagee Compliance Manager (MCM)) .pdf PDF
Attachment 4 MCM 4.0 PWS Appendix C - Sample MCM Directors Report .pdf PDF
Attachment 7 MCM 4.0 Nondisclosure Agreement .pdf PDF
Attachment 1 MCM 4.0 HOC_Map.pdf PDF
Attachment 6 MCM 4.0 Pricing Sheet.xlsx XLSX spreadsheet
Attachment 3 MCM 4.0 Appendix B - REO Steps In HRSR.pdf PDF
Attachment 5 MCM 4.0 Solicitation Questions Form.docx DOCX document
Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Sheet1

Appendix A - Historical Data
Fiscal Year 2018Fiscal Year 2019
Total ActivitiesUnique CasesGroup Unique CasesTotal ActivitiesUnique CasesGroup Unique Cases
Extensions (includes appeals)10,31828,778114,56934,33226,38299,601
Over-Allowables (includes appeals)231,97459,714178,63648,810
HECM Over-Allowables (includes appeals)95,61220,77393,64520,274
Surchargable Total - post and pre4,0293,1402,8232,276
Occupied Conveyance (all work)3,1982,1642,7251,859
Claims Part A (includes appeals and demands)14,34224,10965,92911,12816,04376,413
Claims Parts B,C,D & E (includes appeals and demands)31,45132,33816,82216,598
Title (includes appeals)31,21957521,3056,353
CWCOT Claim Review (includes appeals and demands)N/A5,767N/A35,143
Surchargable Total - post and pre4,0293,1402,8232,276
Administrative Remedies (First Demands, Demand Appeals & Notice of Offset Letters)100,209Reporting not available in P260105,721Reporting not available in P260
Reconvey Activities (total reconveyance activities minus completed reconveyances & reacquisitions)4,0693,6276,8052,3451,8223,423
Reconvey to Mortgagee (all work associated completed reconveyances)1,618826920485
Reacquisitions (all activities required for completed reacquisitions)8,9202,3524,7861,116
Customer Service ( Scanned documents, Incoming calls, MCM inboxes)31,839NADo not have case # data in these areas28,536Do not have case # data in these areas
Conveyances (Claims Filed)25,628NANA19,441NANA
CWCOT (Claims filed)41,163NANA35,654NANA

8,052,593 8,107,807 7,988,355

Fiscal Year 2020Fiscal Year 2021
Total ActivitiesUnique CasesGroup Unique CasesTotal ActivitiesUnique CasesGroup Unique Cases
Extensions (includes appeals)24,15414,73570,9285,3493,56040,431
Over-Allowables (includes appeals)166,86937,215151,61623,276
HECM Over-Allowables (includes appeals)91,61416,17486,65612,655
Surchargable Total - post and pre2,3261,8401,334878
Occupied Conveyance (all work)1,4109647762
Claims Part A (includes appeals and demands)8,89715,01963,1353,9794,53732,541
Claims Parts B,C,D & E (includes appeals and demands)14,36716,7927,7365,574
Title (includes appeals)19,73615,4726,8194,832
CWCOT Claim Review (includes appeals and demands)29,19414,01218,32813,184
Surchargable Total - post and pre2,3261,8401,334878
Administrative Remedies (First Demands, Demand Appeals & Notice of Offset Letters)94,019Reporting not available in P26015,4673,536
Reconvey Activities (total reconveyance activities minus completed reconveyances & reacquisitions)1,7131,2882,3752,7739581,843
Reconvey to Mortgagee (all work associated completed reconveyances)668310522316
Reacquisitions (all activities required for completed reacquisitions)3,2037772,086569
Customer Service ( Scanned documents, Incoming calls, MCM inboxes)25,009Do not have case # data in these areas17,478Do not have case # data in these areas
Conveyances (Claims Filed)16,736NANA6,458NANA
CWCOT (Claims filed)21,846NANA10,686NANA
Fiscal Year 2022Fiscal Year 2023
Total ActivitiesUnique CasesGroup Unique CasesTotal ActivitiesUnique Cases
Extensions (includes appeals)5,1104,08738,3899,3647,35541,489
Over-Allowables (includes appeals)134,32019,943140,63421,119
HECM Over-Allowables (includes appeals)84,13613,29760,39911,991
Surchargable Total - post and pre842490885525
Occupied Conveyance (all work)717572648499
Claims Part A (includes appeals and demands)2,9312,75421,2076,4614,41522,448
Claims Parts B,C,D & E (includes appeals and demands)4,0863,0535,2213,693
Title (includes appeals)3,9372,7965,4524,068
CWCOT Claim Review (includes appeals and demands)12,8238,84515,9657,958
Surchargable Total - post and pre842490885525
Administrative Remedies (First Demands, Demand Appeals & Notice of Offset Letters)1,8933,2692,4661,789
Reconvey Activities (total reconveyance activities minus completed reconveyances & reacquisitions)6954401,1511,374415904
Reconvey to Mortgagee (all work associated completed reconveyances)2084671,131276
Reacquisitions (all activities required for completed reacquisitions)965244640213
Customer Service ( Scanned documents, Incoming calls, MCM inboxes)23,411Do not have case # data in these areas23,334Do not have case # data in these areas
Conveyances (Claims Filed)4,010NANA5,120NANA
CWCOT (Claims filed)9,378NANA10,243NANA
Fiscal Year 2024
Total ActivitiesUnique CasesGroup Unique Cases
Extensions (includes appeals)8,4726,89238,022
Over-Allowables (includes appeals)132,87221,120
HECM Over-Allowables (includes appeals)45,0108,798
Surchargable Total - post and pre1,346725
Occupied Conveyance (all work)1,097487
Claims Part A (includes appeals and demands)5,1914,36322,891
Claims Parts B,C,D & E (includes appeals and demands)5,2263,958
Title (includes appeals)5,2124,156
CWCOT Claim Review (includes appeals and demands)15,7337,916
Surchargable Total - post and pre1,346725
Administrative Remedies (First Demands, Demand Appeals & Notice of Offset Letters)2,4281,773
Reconvey Activities (total reconveyance activities minus completed reconveyances & reacquisitions)1,222376840
Reconvey to Mortgagee (all work associated completed reconveyances)1,034279
Reacquisitions (all activities required for completed reacquisitions)531185
Customer Service ( Scanned documents, Incoming calls, MCM inboxes)30,530Do not have case # data in these areas
Conveyances (Claims Filed)5,194NANA
CWCOT (Claims filed)11,284NANA

File details come from the government source that posted it. Updated .