{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Form","CSVFormat","Ref","ReleaseNotes","CSVFormat2","Ref2","ReleaseNotes2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":188,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":false,"merged":[[3,1,3,7],[50,5,50,7],[63,1,63,7],[64,1,64,7],[9,7,9,10],[5,1,5,6],[6,1,6,6],[7,1,7,6],[8,1,8,6],[49,5,49,7],[21,1,21,5],[21,6,21,7],[23,1,23,7],[4,1,4,14],[9,12,9,14],[20,3,20,7],[9,1,9,6],[15,3,15,6],[14,1,14,2],[30,5,30,7],[27,5,27,7],[12,1,12,6],[30,12,30,13],[15,1,15,2],[14,3,14,6],[32,12,32,13],[31,5,31,7],[32,5,32,7],[20,1,20,2],[14,10,14,11],[28,12,28,13],[29,12,29,13],[21,10,21,13],[19,10,20,13],[23,10,23,13],[5,12,5,14],[6,12,6,14],[7,7,7,14],[8,7,8,14],[5,10,5,11],[6,10,6,11],[5,7,5,9],[6,7,6,9],[66,8,66,14],[44,5,44,7],[49,10,49,14],[59,1,61,14],[66,1,66,7],[46,5,46,7],[65,1,65,7],[63,12,63,14],[64,12,64,14],[47,5,47,7],[48,5,48,7],[64,8,64,11],[53,1,53,4],[45,5,45,7],[54,1,56,14],[39,5,39,7],[43,5,43,7],[40,10,40,14],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[35,5,35,7],[34,5,34,7],[33,5,33,7],[3,11,3,12],[28,5,28,7],[37,5,37,7],[36,5,36,7],[39,10,39,14],[29,5,29,7],[26,12,26,13],[27,12,27,13],[26,5,26,7],[12,12,12,14],[12,7,12,10],[14,7,14,9],[15,7,15,9],[15,10,15,11],[31,12,31,13],[38,5,38,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notification of Mortgage Insurance Modification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(For use with performing loan refinances, non-performing"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," modifications and Radian approved exception modifications.)"]
[null,"Radian Guaranty Inc. · 550 East Swedesford Road, Suite 350 · Wayne, PA · 19087\nPhone:  877 723.4261 (Customer Care)"]
[null,"Instructions: Tab through the below fields to complete the form electronically. Save and send completed form (in Excel format) via email to certmods@radian.com."]
[null,"Submitting Servicer/Lender Name",null,null,null,null,null,"Borrower Last Name",null,null,"First Name",null,"Middle"]
[]
[null,"Submitting Servicer/Lender Street Address",null,null,null,null,null,"Property Street Address"]
[]
[null,"Submitting Servicer/Lender City, State, Zip",null,null,null,null,null,"Property  City",null,null,null,"Property State","Property Zip"]
[null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,"PR"]
[]
[]
[null,"Radian Master Policy Number",null,"Existing Loan Number",null,null,null,"New Loan Number (if refinance)",null,null,"Existing Radian Certificate Number"]
[]
[]
[]
[]
[null,"Refinance Modification",null,null,null,null,null,null,null,null,"Non-GSE Performing, Non-Performing, and Radian Approved Exceptions"]
[null,"Request Type"]
[null,"Is this a Fannie Mae High LTV Refinance Option or Freddie Mac Enhanced Relief Refinance℠?"]
[null,"Program Name (select from list)",null,null,null,null,null,null,null,null,"Program Name (select from list)"]
[]
[]
[null,"Required Pre and Post Close Data (New Loan)",null,null,null,null,null,null,null,null,"Modified/New Loan Data"]
[null,"Loan Type",null,null,null,null,null,null,null,null,"P&I"]
[null,"New Loan Amount",null,null,null,null,null,null,null,null,"PITI"]
[null,"Interest Rate %",null,null,null,null,null,null,null,null,"Gross Modified UPB"]
[null,"P&I",null,null,null,null,null,null,null,null,"Interest Rate %"]
[null,"PITI",null,null,null,null,null,null,null,null,"Term (months)"]
[null,"Term (months)",null,null,null,null,null,null,null,null,"Loan Type"]
[null,"Occupancy Type",null,null,null,null,null,null,null,null,"Interest Only (Y/N)"]
[null,"MI Premium Source",null,null,null,null,null,null,null,null,"Interest Only Term"]
[null,"MI Renewal Type",null,null,null,null,null,null,null,null,"Potential Neg. Am. (Y/N)"]
[null,"Qualifying Property Value",null,null,null,null,null,null,null,null,"Forbearance (Y/N)"]
[null,"Closing Costs",null,null,null,null,null,null,null,null,"Forbearance Amount"]
[null,"Existing Loan Payoff Amount",null,null,null,null,null,null,null,null,"Closing Date of Modification"]
[null,"Borrower FICO"]
[null,"Closing Date "]
[]
[null,null,null,null,null,null,null,null,null,null,"If Modified/New Loan is a step rate:"]
[null,"Post Close - ARMs Only",null,null,null,null,null,null,null,null,null,"Rate (%)",null,"Term (Months)"]
[null,"Index",null,null,null,null,null,null,null,null,"1st"]
[null,"Margin",null,null,null,null,null,null,null,null,"2nd"]
[null,"Months to first payment adjustment",null,null,null,null,null,null,null,null,"3rd"]
[null,"Initial adjustment rate cap percent",null,null,null,null,null,null,null,null,"4th"]
[null,"Months to first rate adjustment",null,null,null,null,null,null,null,null,"5th"]
[null,"Months between rate adjustments"]
[null,"Subsequent adjustments rate cap percent"]
[null,"Life of loan interest (max) rate cap"]
[]
[]
[null,{"$f":"IF(OR(PMTIndicator=\"\", PMTIndicator=\" \"),\"\",\"Prior Approval (Performing Loans):\")","v":""}]
[null,{"$f":"IF(OR(PMTIndicator=\"\",PMTIndicator=\" \"),\"\",(IF(G22=\"No\",('Ref2'!AA2),('Ref2'!AB2))))","v":""}]
[]
[]
[]
[null,"Eligibility/Submission:"]
[null,"Servicers are required to report all loss mitigation workouts and modifications that change the terms of the loan. Servicers have full delegated authority to complete loss mitigation workouts and modifications that conform to the requirements outlined in Radian’s Servicing Guides. Loss mitigation workouts and modifications that do not conform to a delegated program require Radian’s approval. Approval requests should be submitted to our Customer Care Team."]
[]
[]
[null,"Servicer/Lender Certification, contact information and endorsement instructions"]
[null,"Submitting Servicer/Lender's authorized representative's name",null,null,null,null,null,null,"Submitting Date",null,null,null," (Area Code) Phone Number"]
[]
[null,"Submitter's email address",null,null,null,null,null,null,"Does the Lender request an endorsement modifying the certificate?"]

{"sheet":"CSVFormat","index":1,"n_rows":3,"n_cols":120,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Report Date","Workout Status","Certificate Number","Servicing Company Name","Servicer Contact Name","Servicer Contact Phone","Servicer Contact Fax","Servicer Contact email","Servicer Loan Number","Investor Name","Investor Loan Number","Pool Contract ID","Primary Borrower Last Name","Workout Type","Workout Program Name","Program Name if Other","Pending Mod Start Date","Pending Mod End Date","SMP Trial Period Payment Amount","HSF Start Date\n(mm-dd-yyyy)","HSF End Date\n(mm-dd-yyyy)","HSF Payment Amount","Mod Effective Date","Y/N New Note Executed","Y/N Existing Loan is Delinquent","Next Due (prior to Mod)","Number of months Delinquent","Delinquent Amount","Borrower Cash Contribution Amount","Capitalized Amount $","Y/N Forgiveness of Debt","$ amount of any debt forgiveness","$ Amount principal forbearance, if applicable","Existing Loan Type (primary type)","Current unpaid principal balance for existing loan","Existing loan Interest/Note Rate %","Remaining Term in months existing loan","Existing P & I payment","Existing PITI","NEW/Modified Loan Type","HTI Ratio","DTI Ratio","New/Modified starting unpaid principal balance ","NEW/Modified Loan Interest/Note Rate %","NEW/Modified Maturity Term","NEW/Modified Loan Maturity Date","NEW/Modified P & I payment","NEW/Modified PITI","New/Modified loan 1st payment due date","Interest Only Term in months","Balloon Payment Amount","Index Name","Margin","Months to 1st Rate Adjustment","Initial Rate Cap","ARM Change Date","Months Between Subsequent Rate Adjustments","Subsequent Adjustments Rate Cap","Life of Loan Rate Cap","Months to 1st Payment Adjustment","Months between Payment Adjustments","Payment Cap per Adjustment","Number of Payment Adjustments","Total buydown term in Years","Step 1 Rate%","Step 1 Term Months","Step 2 Rate %","Step 2 Term Months","Step 3 Rate %","Step 3 Term Months","Step 4 Rate%","Step 5 Rate %","New Servicer Loan Number","Servicer Master Policy Number","Replacement Certificate","Forbearance Indicator","Interest Only Indicator","Temporary Buydown Indicator","Mod Type","Process Type","Exception Override","Modification Method","Balloon Indicator","Neg Am Indicator","Originator Customer Name","Originator Customer Address Line1","Originator Customer Address Line2","Originator Customer City","Originator Customer State","Originator Customer Zip Code","Property Address Line 1","Property Address Line 2","Property City","Property State","Property Zip Code","NEW/Modified Loan Amount","Property Valuation Amount","Periodic 30Days Late Count","Periodic 60Days Late Count","Property Usage Type Code","Estimated Closing Costs Amount","Estimated Cash To Borrower Amount","Balloon Term","FICO Score Borrower 1","FICO Score Borrower 2","Servicer Contact Preferred Delivery Method","Servicer Endorsement Contact Name","Servicer Endorsement Contact Phone","Servicer Endorsement Contact Fax","Servicer Endorsement Contact email","Servicer Endorsement Preferred Delivery Method","Missing Data Indicator","Number of Modifications","First Notification Received Date","First Completed Modification Date","Cumulative Forgiveness Amount","New Servicer Master Policy Number","New MI Product Type","New Renewal Type","GSEHighLTVInd"]
[{"$f":"IF(ISBLANK(ReportDate),\"\",ReportDate)","v":""},null,{"$f":"IF(ISBLANK(CertificateNumber),\"\",TRIM(CertificateNumber))","v":""},{"$f":"IF(ISBLANK(ServicerName),\"\",TRIM(ServicerName))","v":""},{"$f":"IF(ISBLANK(ServicerContactName),\"\",TRIM(ServicerContactName))","v":""},{"$f":"IF(ISBLANK(ServicerContactPhone),\"\",TEXT(TRIM(ServicerContactPhone), \"###-###-####\"))","v":""},null,{"$f":"IF(ISBLANK(ServicerContactEmail),\"\",TRIM(ServicerContactEmail))","v":""},{"$f":"IF(ISBLANK(ServicerLoanNumber),\"\",TRIM(ServicerLoanNumber))","v":""},null,null,null,{"$f":"IF(ISBLANK(BorrowerLastName),\"\",TRIM(BorrowerLastName))","v":""},null,null,null,{"$f":"TODAY()","v":"2024-05-16"},null,null,null,null,null,{"$f":"IF(ModEffectiveDate>0,ModEffectiveDate,IF(NPModEffectiveDate>0,NPModEffectiveDate,\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ModifiedForbearanceAmount=0, ISTEXT(ModifiedForbearanceAmount)),\"\",ModifiedForbearanceAmount)","v":""},null,{"$f":"IF(ISBLANK(CurrentUnpaidPrincipalBalance), \"\", CurrentUnpaidPrincipalBalance)","v":""},null,null,null,null,{"$f":"IF(ModifiedLoanType>0,ModifiedLoanType,IF(NPModifiedLoanType>0,NPModifiedLoanType,\"\"))","v":""},null,null,{"$f":"IF(ModifiedLoanBalance>0,ModifiedLoanBalance,IF(NPModifiedLoanBalance>0,NPModifiedLoanBalance,\"\"))","v":""},{"$f":"IF(ModifiedInterestRate>0,ModifiedInterestRate,IF(NPModifiedInterestRate>0,NPModifiedInterestRate,\"\"))","v":""},{"$f":"IF(ModifiedTerm>0,ModifiedTerm,IF(NPModifiedTerm>0,NPModifiedTerm,\"\"))","v":""},null,{"$f":"IF(ModifiedPI>0, ModifiedPI, IF(ModifiedPIPayment>0, ModifiedPIPayment,\"\"))","v":""},{"$f":"IF(ModifiedPITIPayment>0, ModifiedPITIPayment, IF(NPModifiedPITIPayment>0, NPModifiedPITIPayment,\"\"))","v":""},null,{"$f":"IF(OR(ModifiedInterestOnlyTerm=0, ISTEXT(ModifiedInterestOnlyTerm)),\"\",ModifiedInterestOnlyTerm)","v":""},null,{"$f":"IF(ISBLANK(ARMIndex),\"\",TRIM(ARMIndex))","v":""},{"$f":"IF(Margin=0,\"\",Margin)","v":""},{"$f":"IF(MonthsToFirstRateAdjustment=0,\"\",MonthsToFirstRateAdjustment)","v":""},{"$f":"IF(InitialRateCap=0,\"\",InitialRateCap)","v":""},null,{"$f":"IF(MonthsBetweenRateAdjustments=0,\"\",MonthsBetweenRateAdjustments)","v":""},{"$f":"IF(SubsequentAdjustmentsRateCap=0,\"\",SubsequentAdjustmentsRateCap)","v":""},{"$f":"IF(LifetimeRateCap=0,\"\",LifetimeRateCap)","v":""},{"$f":"IF(MonthsToFirstPaymentAdjustment=0,\"\",MonthsToFirstPaymentAdjustment)","v":""},null,null,null,null,{"$f":"IF(Step1Rate=0,\"\",Step1Rate)","v":""},{"$f":"IF(Step1Term=0,\"\",Step1Term)","v":""},{"$f":"IF(Step2Rate=0,\"\",Step2Rate)","v":""},{"$f":"IF(Step2Term=0,\"\",Step2Term)","v":""},{"$f":"IF(Step3Rate=0,\"\",Step3Rate)","v":""},{"$f":"IF(Step3Term=0,\"\",Step3Term)","v":""},{"$f":"IF(Step4Rate=0,\"\",Step4Rate)","v":""},{"$f":"IF(Step5Rate=0,\"\",Step5Rate)","v":""},{"$f":"IF(ISBLANK(NewServicerLoanNumber),\"\",TRIM(NewServicerLoanNumber))","v":""},{"$f":"IF(OR(ISBLANK(ServicerMasterPolicyNumber), (AND(ISBLANK(ModType),ISBLANK(NonPerformingModType)))),\"\",IF(ISBLANK(NonPerformingModTypeModType),\"\",IF(ModMethod<>\"Lender Refi Radian Transfer\",ServicerMasterPolicyNumber,\"\")))","v":""},null,{"$f":"IF(ISBLANK(ModifiedForbearanceIndicator), \"\", ModifiedForbearanceIndicator)","v":""},{"$f":"IF(ISBLANK(ModifiedInterestOnlyIndicator),\"\",ModifiedInterestOnlyIndicator)","v":""},null,{"$f":"IF(AND(ISBLANK(ModType), ISBLANK(NonPerformingModType)),\"\",VLOOKUP(IF(ISBLANK(ModType), NonPerformingModType, ModType),ModificationMethodLookup,2,FALSE))","v":{"$error":"#NAME?"}},"New Modification",null,{"$f":"IF(AND(ISBLANK(ModType), ISBLANK(NonPerformingModType)),\"\",VLOOKUP(IF(ISBLANK(ModType), NonPerformingModType, ModType),ModificationMethodLookup,3,FALSE))","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISBLANK(ModifiedNegAmIndicator), \"\", ModifiedNegAmIndicator)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(PropertyAddress),\"\",TRIM(PropertyAddress))","v":""},null,{"$f":"IF(ISBLANK(PropertyCity),\"\",TRIM(PropertyCity))","v":""},{"$f":"IF(ISBLANK(PropertyState),\"\",TRIM(PropertyState))","v":""},{"$f":"IF(ISBLANK(PropertyZip),\"\",TRIM(PropertyZip))","v":""},{"$f":"IF(ModifiedLoanBalance>0,ModifiedLoanBalance,IF(NPModifiedLoanBalance>0,NPModifiedLoanBalance,\"\"))","v":""},{"$f":"IF(ISBLANK(PropertyValuationAmount), \"\", PropertyValuationAmount)","v":""},null,null,{"$f":"IF(ModifiedOccupancyType>0,ModifiedOccupancyType,IF(NonPerformingOccupancyType>0,NonPerformingOccupancyType,\"\"))","v":""},{"$f":"IF(ISBLANK(ClosingCosts),\"\",TRIM(ClosingCosts))","v":""},null,null,{"$f":"IF(ISBLANK(BorrowerFICO),\"\",TRIM(BorrowerFICO))","v":""},null,{"$f":"IF(EndorsementRequested=\"Y\",\"Email\",\"\")","v":""},{"$f":"IF(ISBLANK(ServicerContactName),\"\",TRIM(ServicerContactName))","v":""},{"$f":"IF(ISBLANK(ServicerContactPhone),\"\",TEXT(TRIM(ServicerContactPhone), \"###-###-####\"))","v":""},null,{"$f":"IF(ISBLANK(ServicerContactEmail),\"\",TRIM(ServicerContactEmail))","v":""},{"$f":"IF(EndorsementRequested=\"Y\",\"Email\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(OR(ISBLANK(ServicerMasterPolicyNumber), (AND(ISBLANK(ModType),ISBLANK(NonPerformingModType)))),\"\",IF(ISBLANK(ModType),\"\",IF(ModMethod=\"Lender Refi Radian Transfer\",ServicerMasterPolicyNumber,\"\")))","v":""},{"$f":"IF(ISBLANK(NewProductType),\"\",TRIM(NewProductType))","v":""},{"$f":"IF(ISBLANK(NewRenewalType),\"\",TRIM(NewRenewalType))","v":""},{"$f":"IF(ISBLANK(PMTIndicator), \"\", PMTIndicator)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(NonPerformingModType),\"\",IF(VLOOKUP(NonPerformingModType,ModificationMethodLookup,4,FALSE)=\"N\",IF(NPModifiedLoanBalance=0,\"\",NPModifiedLoanBalance),\"\"))","v":{"$error":"#NAME?"}}]

{"sheet":"Ref","index":2,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":true,"merged":[[1,26,9,26],[1,27,9,27]]}
["Workout Status","Workout Type","Workout Program Name","Existing Loan Type (primary type)","NEW/Modified Loan Type","Index Name","Mod Type","Process Type","Modification Method","Property Usage Type Code","Property Value","Preferred Delivery Method","Form Mod Type","CSV Mod Type Map","Modification Method Map","Is HARP? Map ","Is Loan Current?","Existing Loan is Delinquent Map","New MI Product Type","Performing Mod Types",null,"Non Performing Mod Types","New Renewal Type","Endorsement Required","Refi Mod Type ","High/Enhanced Mod Type (if Yes)","Prior Approval Text HARP (if No)","Prior Approval Text New (if Yes)","High LTV Refi Option / Enhanced Relief Refinance Question",null,null,"States","RequestType","Non-performing Loan Type","Interest Only","Potential Neg AM","Forbearance"]
["New Addition","Modification","Home Affordable Modification(HAM)","FixedRate/FixedPayment","FixedRate/FixedPayment","3-Month Treasury Bills","Fannie Mae HARP - New Servicer","New Modification","Lender Mod Radian Mod","Primary Residence (Owner Occupied)","New exterior appraisal","Email","Fannie Mae DU Refi Plus™  (HARP) Same Servicer","Fannie Mae HARP - Same Servicer","Lender Refi Radian Mod","Y","Y","N","Borrower Paid","Fannie Mae DU Refi Plus™  (HARP) Same Servicer","Lender Refi Radian Mod","Fannie Mae Flex Modification","Constant","Y","Yes","Same Servicer - Fannie Mae High LTV Refinance Option","The submitter represents that the HARP Refinance Loan meets the requirements of Radian Guaranty Inc. (“Radian”)’s HARP Program, and the HARP Program requirements as published by Fannie Mae or Freddie Mac, in effect on the day of submission, and that insurance for the Loan is currently in force with Radian. The submitter also acknowledges that Radian is relying on the above representations for the continuation of mortgage insurance coverage for the HARP Refinance loan and that Radian may cancel or rescind the mortgage insurance coverage if the Loan does not meet the terms of Radian’s Master Policy and/or all applicable HARP program requirements.","The submitter represents that the refinance modification loan meets the requirements of Radian Guaranty Inc. (“Radian”)’s GSE Refinance Modification Program, and the High LTV Refinance Option or Enhanced Relief Refinance Program requirements as published by Fannie Mae or Freddie Mac, in effect on the day of submission, and that insurance for the Loan is currently in force with Radian. The submitter also acknowledges that Radian is relying on the above representations for the continuation of mortgage insurance coverage for the refinance modification loan and that Radian may cancel or rescind the mortgage insurance coverage if the Loan does not meet the terms of Radian's Master Policy and/or all applicable High LTV Refinance Option or Enhanced Relief Refinance program requirements.","Yes","Same Servicer - Fannie Mae High LTV Refinance Option",null,"AL","Pre-Closing Notification","FixedRate/FixedPayment","Y","Y","Y"]
["In Trial Period","Forbearance","FNM-HMP","ARM","1/1 ARM","6-Month Treasury Bills","Freddie Mac HARP - New Servicer","New Replacement Cert","Lender Refi Radian Mod","Second Home (Owner Occupied)","New full appraisal","Fax","Fannie Mae Refi Plus™ (HARP) Same Servicer","Fannie Mae HARP - Same Servicer","Lender Refi Radian Mod","Y","N","Y","Lender Paid","Fannie Mae Refi Plus™ (HARP) Same Servicer","Lender Refi Radian Mod","Freddie Mac Flex Modification","Declining","N","No","New Servicer - Fannie Mae High LTV Refinance Option",null,null,"Yes","New Servicer - Fannie Mae High LTV Refinance Option",null,"AK","Pre-Closing Update/Change Notification","1/1 ARM","N","N","N"]
["Completed","Repayment","FRE-HMP","Interest Only","2/1 ARM","1-Year Treasury Bills","Fannie Mae HARP - Same Servicer","Maintain","Lender Refi Radian Replacement","Non-Owner Occupied","Original appraisal (property value is not less than the original appraised value)",null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer","Freddie Mac HARP - Same Servicer","Lender Refi Radian Mod","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer","Lender Refi Radian Mod","Fannie Mae Extend Modification for Disaster Relief",null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refinance",null,null,"Yes","Same Servicer - Freddie Mac Enhanced Relief Refinance",null,"AZ","Post-Closing Modification Order","2/1 ARM"]
["Cancelled","DIL","HomeSaver Advance (HSA)","PayOption (POA)","3/1 ARM","3-Year Treasury Bills","Freddie Mac HARP - Same Servicer","Cancel","Lender Refi RadianTransfer",null,"Property Fieldwork Waiver",null,"Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer","Freddie Mac HARP - New Servicer","Lender Refi Radian Mod","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer","Lender Refi Radian Mod","Freddie Mac Extend Modification for Disaster Relief",null,null,null,"New Servicer - Freddie Mac Enhanced Relief Refinance",null,null,"Yes","New Servicer - Freddie Mac Enhanced Relief Refinance",null,"AR",null,"3/1 ARM"]
[null,"Short Sale","HomeSaver Forbearance (HSF)",null,"3/3 ARM","5-Year Treasury Securities","HARP - Defensive Refinance","Delete",null,null,"Home Value Explorer ®",null,"Non GSE refinance modification Same Servicer","HARP - Defensive Refinance","Lender Refi Radian Mod","Y",null,null,null,"Non GSE refinance modification Same Servicer","Lender Refi Radian Mod","Standard Delegated Defensive Modification",null,null,null,null,null,null,"No","Fannie Mae DU Refi Plus™  (HARP) Same Servicer",null,"CA",null,"3/3 ARM"]
[null,null,"Other",null,"5/1 ARM","11th District COFI","FNM-HMP",null,null,null,"Other",null,"Standard Delegated Performing Modification","Defensive Modification","Lender Mod Radian Mod","N",null,null,null,"Fannie Mae DU Refi Plus™ (HARP) New Servicer","Lender Refi Radian Transfer","Standard Delegated Default Modification",null,null,null,null,null,null,"No","Fannie Mae Refi Plus™ (HARP) Same Servicer",null,"CO",null,"5/1 ARM"]
[null,null,null,null,"7/1 ARM","National Median COFI","FRE-HMP",null,null,null,null,null,"Standard Delegated Default Modification","Default Modification","Lender Mod Radian Mod","N",null,null,null,"Fannie Mae Refi Plus™ (HARP) New Servicer","Lender Refi Radian Transfer",null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer",null,"CT",null,"7/1 ARM"]
[null,null,null,null,"10/1 ARM","Other","HomeSaver Forbearance (HSF)",null,null,null,null,null,"Fannie Mae DU Refi Plus™ (HARP) New Servicer","Servicing Transfer - Fannie Mae HARP","Lender Refi Radian Transfer","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer","Lender Refi Radian Transfer",null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer",null,"DE",null,"10/1 ARM"]
[null,null,null,null,"15/1 ARM","Prime Rate","Default Modification",null,null,null,null,null,"Fannie Mae Refi Plus™ (HARP) New Servicer","Servicing Transfer - Fannie Mae HARP","Lender Refi Radian Transfer","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer","Lender Refi Radian Transfer",null,null,null,null,null,null,null,"No","Non GSE refinance modification Same Servicer",null,"FL",null,"15/1 ARM"]
[null,null,null,null,"Step Rate","Federal COFI","Defensive Modification",null,null,null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer","Servicing Transfer - Freddie Mac HARP","Lender Refi Radian Transfer","Y",null,null,null,null,null,null,null,null,null,null,null,null,"No","Fannie Mae DU Refi Plus™ (HARP) New Servicer",null,"GA",null,"Step Rate"]
[null,null,null,null,"Interest Only Fixed","LIBOR","Servicing Transfer - Fannie Mae HARP",null,null,null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer","Servicing Transfer - Freddie Mac HARP","Lender Refi Radian Transfer","Y",null,null,null,null,null,null,null,null,null,null,null,null,"No","Fannie Mae Refi Plus™ (HARP) New Servicer",null,"HI",null,"Interest Only Fixed"]
[null,null,null,null,"Interest Only ARM","Certificates of Deposit","Servicing Transfer - Freddie Mac HARP",null,null,null,null,null,"Fannie Mae (HMP)","FNM-HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer",null,"ID",null,"Interest Only ARM"]
[null,null,null,null,null,"National Average Contract Rate on Previously Occupied Homes","Non-GSE HMP",null,null,null,null,null,"Freddie Mac (HMP)","FRE-HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer",null,"IL"]
[null,null,null,null,null,null,"Streamline Modification - Fannie Mae",null,null,null,null,null,"Non GSE (HMP)","Non-GSE HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,null,null,null,null,null,"Streamline Modification - Freddie Mac",null,null,null,null,null,"Standard Delegated Defensive Modification","Defensive Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
[null,null,null,null,null,null,"Streamline Modification - Non-GSE",null,null,null,null,null,"Streamline Modification - Fannie Mae","Streamline Modification - Fannie Mae","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
[null,null,null,null,null,null,"Same Servicer - Fannie Mae High LTV Refi",null,null,null,null,null,"Streamline Modification - Freddie Mac","Streamline Modification - Freddie Mac","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
[null,null,null,null,null,null,"Servicing Transfer - Fannie Mae High LTV Refi",null,null,null,null,null,"Streamline Modification - Non-GSE","Streamline Modification - Non-GSE","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,null,null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refi",null,null,null,null,null,"Same Servicer - Fannie Mae High LTV Refinance Option","Same Servicer - Fannie Mae High LTV Refi","Lender Refi Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,"Servicing Transfer - Freddie Mac Enhanced Relief Refi",null,null,null,null,null,"New Servicer - Fannie Mae High LTV Refinance Option","Servicing Transfer - Fannie Mae High LTV Refi","Lender Refi Radian Transfer","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,"Fannie Mae Flex Modification",null,null,null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refinance","Same Servicer - Freddie Mac Enhanced Relief Refi","Lender Refi Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
[null,null,null,null,null,null,"Freddie Mac Flex Modification",null,null,null,null,null,"New Servicer - Freddie Mac Enhanced Relief Refinance","Servicing Transfer - Freddie Mac Enhanced Relief Refi","Lender Refi Radian Transfer","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,null,null,null,"Fannie Mae Extend Modification for Disaster Relief",null,null,null,null,null,"Fannie Mae Flex Modification","Fannie Mae Flex Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,"Freddie Mac Extend Modification for Disaster Relief",null,null,null,null,null,"Freddie Mac Flex Modification","Freddie Mac Flex Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fannie Mae Extend Modification for Disaster Relief","Fannie Mae Extend Modification for Disaster Relief","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Freddie Mac Extend Modification for Disaster Relief","Freddie Mac Extend Modification for Disaster Relief","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]

{"sheet":"ReleaseNotes","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[[2,0,8,0],[2,1,8,1]]}
["Date","Version","Enhancements and Bug Fixes"]
["2005-04-08",1,"Initial Version"]
["2005-04-08",2,"Removed \"Non-GSE Refinance Modification\" and \"Other\" from \"Program Name\" dropdown on the form"]
[null,null,"Added automatic map to \"Modification Method\" on the CSV based upon \"Program Name\" on the form"]
[null,null,"Added automatic entry of \"New/Modified Loan Amount\" on the CSV for any HARP program in \"Program Name\" on the form"]
[null,null,"Fixed \"Months Between Adjustment\" on the form to also map to \"Months Between Payment Adjustments\" on the CSV"]
[null,null,"Added map from \"Is Loan Current\" on the form to \"Existing Loan is Delinquent\" on the CSV"]
[null,null,"Added map from \"Due Date\" on the form to \"Next Due (prior to Mod)\" on the CSV"]
[null,null,"Added security to the form"]
["2005-04-08",2.1,"Fixed the date problem when copying from this template to another worksheet"]
["2009-04-13",2.2000000000000002,"Fixed \"Existing Loan is Delinquent\" mapping to reverse the Y/N value to sync with the \"Is Loan Current?\" question on the form"]
["2009-04-28",3,"Added new Enums for \"Mod Type\" field\nAdded 7 new columns\" FICO scores + Endorsement fax, phone, email and preference\nMapped \"Preferred Delivery Method\" on the form \"Servicer Contact Preferred Delivery Method\" on CSV"]
["2009-04-30",3.1,"Sync the \"Program Names\" on the form with the PDF version.  Map these to the LMA \"Modification Types\" on the CSV."]
["2009-05-04",3.2,"Add back the text after the asterisk previously removed by mistake\nAdded a box around the \"Program Name\" field on the form\nCorrected the \"TM\" to \"SM\" on the Freddie Mac Relief Refinance Program"]
["2009-05-12",3.3,"Removed \"For pool coverage, any amount capitalized may not be included in any \nfuture claim for loss\" from the form."]
["2009-06-02",3.4,"Updated with new Mod Types\nUpdated mapping between Mod Types on the form and the CSV"]
["2009-06-05",3.5,"Add text (\"For use with Same Servicer …. \") below \"Notification of Mortgage Insurance Modification\" on form \nCorrected mapping of \"Performing Modification\" to \"Lender Mod, Radian Mod\" on the CSV"]
["2009-07-13",3.6,"Added 2 new \"Modified Loan Types\" :  1/1 and 2/1 ARM.  Added \"Interest Only Indicator\" on the form and corrected logic on \"Interest Only Indicator\" field in CSV. Added additional logic in map to trap non-numeric values entered on the form for \"Interest Only Term\" and \"Balloon Term\" "]
["2009-09-14",4,"Added 3 fields for Step Terms.  Added new Mod Type : \"Freddie Mac - New Servicer\", and changed \"Freddie Mac HARP\" to \"Freddie Mac - Same Servicer\"."]
["2009-09-22",4.0999999999999996,"Added 3 fields for Step Terms to the data entry form."]
["2009-09-22",4.2,"Update existing Freddie Mac program and add a new one.  Add Balloon Amount."]
["2009-12-07",5,"Added support for 4th and 5th step rates/terms on the form.  No changes to the CSV."]
["2009-12-29",5.0999999999999996,"Remove logic to set \"Temporary Buydown Indicator\" = Y when there is a \"Step 1 Rate %\""]
["2011-12-07",5.2,"Changed format for HARP 2.0"]
["2013-04-08",5.4,"Added Renewal Type"]
["2013-05-17",5.6,"Added 3 new Mod Types"]
["2018-11-06",6,"Added 8 new mod Types for High LTV programs, Added High LTV Indicator, Added P&I for performing loans, removed balloon fields and added Forbearance fields. Updated to auto clear Mod type field if High LTV indicator is changed. Added Clear Form button"]
["2018-11-12",6.1,"Added Request Type, made State a drop down."]
["2019-01-02",6.2,"Added validation that will not allow the rest of the form to be filled in if Program Type is not selected along with appropriate error messaging. Added verbiage to assist with completing Program Name field. "]

{"sheet":"CSVFormat2","index":4,"n_rows":3,"n_cols":120,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Report Date","Workout Status","Certificate Number","Servicing Company Name","Servicer Contact Name","Servicer Contact Phone","Servicer Contact Fax","Servicer Contact email","Servicer Loan Number","Investor Name","Investor Loan Number","Pool Contract ID","Primary Borrower Last Name","Workout Type","Workout Program Name","Program Name if Other","Pending Mod Start Date","Pending Mod End Date","SMP Trial Period Payment Amount","HSF Start Date\n(mm-dd-yyyy)","HSF End Date\n(mm-dd-yyyy)","HSF Payment Amount","Mod Effective Date","Y/N New Note Executed","Y/N Existing Loan is Delinquent","Next Due (prior to Mod)","Number of months Delinquent","Delinquent Amount","Borrower Cash Contribution Amount","Capitalized Amount $","Y/N Forgiveness of Debt","$ amount of any debt forgiveness","$ Amount principal forbearance, if applicable","Existing Loan Type (primary type)","Current unpaid principal balance for existing loan","Existing loan Interest/Note Rate %","Remaining Term in months existing loan","Existing P & I payment","Existing PITI","NEW/Modified Loan Type","HTI Ratio","DTI Ratio","New/Modified starting unpaid principal balance ","NEW/Modified Loan Interest/Note Rate %","NEW/Modified Maturity Term","NEW/Modified Loan Maturity Date","NEW/Modified P & I payment","NEW/Modified PITI","New/Modified loan 1st payment due date","Interest Only Term in months","Balloon Payment Amount","Index Name","Margin","Months to 1st Rate Adjustment","Initial Rate Cap","ARM Change Date","Months Between Subsequent Rate Adjustments","Subsequent Adjustments Rate Cap","Life of Loan Rate Cap","Months to 1st Payment Adjustment","Months between Payment Adjustments","Payment Cap per Adjustment","Number of Payment Adjustments","Total buydown term in Years","Step 1 Rate%","Step 1 Term Months","Step 2 Rate %","Step 2 Term Months","Step 3 Rate %","Step 3 Term Months","Step 4 Rate%","Step 5 Rate %","New Servicer Loan Number","Servicer Master Policy Number","Replacement Certificate","Forbearance Indicator","Interest Only Indicator","Temporary Buydown Indicator","Mod Type","Process Type","Exception Override","Modification Method","Balloon Indicator","Neg Am Indicator","Originator Customer Name","Originator Customer Address Line1","Originator Customer Address Line2","Originator Customer City","Originator Customer State","Originator Customer Zip Code","Property Address Line 1","Property Address Line 2","Property City","Property State","Property Zip Code","NEW/Modified Loan Amount","Property Valuation Amount","Periodic 30Days Late Count","Periodic 60Days Late Count","Property Usage Type Code","Estimated Closing Costs Amount","Estimated Cash To Borrower Amount","Balloon Term","FICO Score Borrower 1","FICO Score Borrower 2","Servicer Contact Preferred Delivery Method","Servicer Endorsement Contact Name","Servicer Endorsement Contact Phone","Servicer Endorsement Contact Fax","Servicer Endorsement Contact email","Servicer Endorsement Preferred Delivery Method","Missing Data Indicator","Number of Modifications","First Notification Received Date","First Completed Modification Date","Cumulative Forgiveness Amount","New Servicer Master Policy Number","New MI Product Type","New Renewal Type","GSEHighLTVInd"]
[{"$f":"IF(ISBLANK(ReportDate),\"\",ReportDate)","v":""},null,{"$f":"IF(ISBLANK(CertificateNumber),\"\",TRIM(CertificateNumber))","v":""},{"$f":"IF(ISBLANK(ServicerName),\"\",TRIM(ServicerName))","v":""},{"$f":"IF(ISBLANK(ServicerContactName),\"\",TRIM(ServicerContactName))","v":""},{"$f":"IF(ISBLANK(ServicerContactPhone),\"\",TEXT(TRIM(ServicerContactPhone), \"###-###-####\"))","v":""},null,{"$f":"IF(ISBLANK(ServicerContactEmail),\"\",TRIM(ServicerContactEmail))","v":""},{"$f":"IF(ISBLANK(ServicerLoanNumber),\"\",TRIM(ServicerLoanNumber))","v":""},null,null,null,{"$f":"IF(ISBLANK(BorrowerLastName),\"\",TRIM(BorrowerLastName))","v":""},null,null,null,{"$f":"TODAY()","v":"2024-05-16"},null,null,null,null,null,{"$f":"IF(ModEffectiveDate>0,ModEffectiveDate,IF(NPModEffectiveDate>0,NPModEffectiveDate,\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ModifiedForbearanceAmount=0, ISTEXT(ModifiedForbearanceAmount)),\"\",ModifiedForbearanceAmount)","v":""},null,{"$f":"IF(ISBLANK(CurrentUnpaidPrincipalBalance), \"\", CurrentUnpaidPrincipalBalance)","v":""},null,null,null,null,{"$f":"IF(ModifiedLoanType>0,ModifiedLoanType,IF(NPModifiedLoanType>0,NPModifiedLoanType,\"\"))","v":""},null,null,{"$f":"IF(ModifiedLoanBalance>0,ModifiedLoanBalance,IF(NPModifiedLoanBalance>0,NPModifiedLoanBalance,\"\"))","v":""},{"$f":"IF(ModifiedInterestRate>0,ModifiedInterestRate,IF(NPModifiedInterestRate>0,NPModifiedInterestRate,\"\"))","v":""},{"$f":"IF(ModifiedTerm>0,ModifiedTerm,IF(NPModifiedTerm>0,NPModifiedTerm,\"\"))","v":""},null,{"$f":"IF(ModifiedPI>0, ModifiedPI, IF(ModifiedPIPayment>0, ModifiedPIPayment,\"\"))","v":""},{"$f":"IF(ModifiedPITIPayment>0, ModifiedPITIPayment, IF(NPModifiedPITIPayment>0, NPModifiedPITIPayment,\"\"))","v":""},null,{"$f":"IF(OR(ModifiedInterestOnlyTerm=0, ISTEXT(ModifiedInterestOnlyTerm)),\"\",ModifiedInterestOnlyTerm)","v":""},null,{"$f":"IF(ISBLANK(ARMIndex),\"\",TRIM(ARMIndex))","v":""},{"$f":"IF(Margin=0,\"\",Margin)","v":""},{"$f":"IF(MonthsToFirstRateAdjustment=0,\"\",MonthsToFirstRateAdjustment)","v":""},{"$f":"IF(InitialRateCap=0,\"\",InitialRateCap)","v":""},null,{"$f":"IF(MonthsBetweenRateAdjustments=0,\"\",MonthsBetweenRateAdjustments)","v":""},{"$f":"IF(SubsequentAdjustmentsRateCap=0,\"\",SubsequentAdjustmentsRateCap)","v":""},{"$f":"IF(LifetimeRateCap=0,\"\",LifetimeRateCap)","v":""},{"$f":"IF(MonthsToFirstPaymentAdjustment=0,\"\",MonthsToFirstPaymentAdjustment)","v":""},null,null,null,null,{"$f":"IF(Step1Rate=0,\"\",Step1Rate)","v":""},{"$f":"IF(Step1Term=0,\"\",Step1Term)","v":""},{"$f":"IF(Step2Rate=0,\"\",Step2Rate)","v":""},{"$f":"IF(Step2Term=0,\"\",Step2Term)","v":""},{"$f":"IF(Step3Rate=0,\"\",Step3Rate)","v":""},{"$f":"IF(Step3Term=0,\"\",Step3Term)","v":""},{"$f":"IF(Step4Rate=0,\"\",Step4Rate)","v":""},{"$f":"IF(Step5Rate=0,\"\",Step5Rate)","v":""},{"$f":"IF(ISBLANK(NewServicerLoanNumber),\"\",TRIM(NewServicerLoanNumber))","v":""},{"$f":"IF(OR(ISBLANK(ServicerMasterPolicyNumber), (AND(ISBLANK(ModType),ISBLANK(NonPerformingModType)))),\"\",IF(ISBLANK(NonPerformingModTypeModType),\"\",IF(ModMethod<>\"Lender Refi Radian Transfer\",ServicerMasterPolicyNumber,\"\")))","v":""},null,{"$f":"IF(ISBLANK(ModifiedForbearanceIndicator), \"\", ModifiedForbearanceIndicator)","v":""},{"$f":"IF(ISBLANK(ModifiedInterestOnlyIndicator),\"\",ModifiedInterestOnlyIndicator)","v":""},null,{"$f":"IF(AND(ISBLANK(ModType), ISBLANK(NonPerformingModType)),\"\",VLOOKUP(IF(ISBLANK(ModType), NonPerformingModType, ModType),ModificationMethodLookup,2,FALSE))","v":{"$error":"#NAME?"}},"New Modification",null,{"$f":"IF(AND(ISBLANK(ModType), ISBLANK(NonPerformingModType)),\"\",VLOOKUP(IF(ISBLANK(ModType), NonPerformingModType, ModType),ModificationMethodLookup,3,FALSE))","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISBLANK(ModifiedNegAmIndicator), \"\", ModifiedNegAmIndicator)","v":""},null,null,null,null,null,null,{"$f":"IF(ISBLANK(PropertyAddress),\"\",TRIM(PropertyAddress))","v":""},null,{"$f":"IF(ISBLANK(PropertyCity),\"\",TRIM(PropertyCity))","v":""},{"$f":"IF(ISBLANK(PropertyState),\"\",TRIM(PropertyState))","v":""},{"$f":"IF(ISBLANK(PropertyZip),\"\",TRIM(PropertyZip))","v":""},{"$f":"IF(ModifiedLoanBalance>0,ModifiedLoanBalance,IF(NPModifiedLoanBalance>0,NPModifiedLoanBalance,\"\"))","v":""},{"$f":"IF(ISBLANK(PropertyValuationAmount), \"\", PropertyValuationAmount)","v":""},null,null,{"$f":"IF(ModifiedOccupancyType>0,ModifiedOccupancyType,IF(NonPerformingOccupancyType>0,NonPerformingOccupancyType,\"\"))","v":""},{"$f":"IF(ISBLANK(ClosingCosts),\"\",TRIM(ClosingCosts))","v":""},null,null,{"$f":"IF(ISBLANK(BorrowerFICO),\"\",TRIM(BorrowerFICO))","v":""},null,{"$f":"IF(EndorsementRequested=\"Y\",\"Email\",\"\")","v":""},{"$f":"IF(ISBLANK(ServicerContactName),\"\",TRIM(ServicerContactName))","v":""},{"$f":"IF(ISBLANK(ServicerContactPhone),\"\",TEXT(TRIM(ServicerContactPhone), \"###-###-####\"))","v":""},null,{"$f":"IF(ISBLANK(ServicerContactEmail),\"\",TRIM(ServicerContactEmail))","v":""},{"$f":"IF(EndorsementRequested=\"Y\",\"Email\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(OR(ISBLANK(ServicerMasterPolicyNumber), (AND(ISBLANK(ModType),ISBLANK(NonPerformingModType)))),\"\",IF(ISBLANK(ModType),\"\",IF(ModMethod=\"Lender Refi Radian Transfer\",ServicerMasterPolicyNumber,\"\")))","v":""},{"$f":"IF(ISBLANK(NewProductType),\"\",TRIM(NewProductType))","v":""},{"$f":"IF(ISBLANK(NewRenewalType),\"\",TRIM(NewRenewalType))","v":""},{"$f":"IF(ISBLANK(PMTIndicator), \"\", PMTIndicator)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(NonPerformingModType),\"\",IF(VLOOKUP(NonPerformingModType,ModificationMethodLookup,4,FALSE)=\"N\",IF(NPModifiedLoanBalance=0,\"\",NPModifiedLoanBalance),\"\"))","v":{"$error":"#NAME?"}}]

{"sheet":"Ref2","index":5,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,26,9,26],[1,27,9,27]]}
["Workout Status","Workout Type","Workout Program Name","Existing Loan Type (primary type)","NEW/Modified Loan Type","Index Name","Mod Type","Process Type","Modification Method","Property Usage Type Code","Property Value","Preferred Delivery Method","Form Mod Type","CSV Mod Type Map","Modification Method Map","Is HARP? Map ","Is Loan Current?","Existing Loan is Delinquent Map","New MI Product Type","Performing Mod Types",null,"Non GSE Performing Non Performing Radian Approved ","New Renewal Type","Endorsement Required","Refi Mod Type ","High/Enhanced Mod Type (if Yes)","Prior Approval Text HARP (if No)","Prior Approval Text New (if Yes)","High LTV Refi Option / Enhanced Relief Refinance Question",null,null,"States","RequestType","Non-performing Loan Type","Interest Only","Potential Neg AM","Forbearance"]
["New Addition","Modification","Home Affordable Modification(HAM)","FixedRate/FixedPayment","FixedRate/FixedPayment","3-Month Treasury Bills","Fannie Mae HARP - New Servicer","New Modification","Lender Mod Radian Mod","Primary Residence (Owner Occupied)","New exterior appraisal","Email","Fannie Mae DU Refi Plus™  (HARP) Same Servicer","Fannie Mae HARP - Same Servicer","Lender Refi Radian Mod","Y","Y","N","Borrower Paid","Fannie Mae DU Refi Plus™  (HARP) Same Servicer","Lender Refi Radian Mod","Fannie Mae Flex Modification","Constant","Yes","Yes","Same Servicer - Fannie Mae High LTV Refinance Option","The submitter represents that the HARP Refinance Loan meets the requirements of Radian Guaranty Inc. (“Radian”)’s HARP Program, and the HARP Program requirements as published by Fannie Mae or Freddie Mac, in effect on the day of submission, and that insurance for the Loan is currently in force with Radian. The submitter also acknowledges that Radian is relying on the above representations for the continuation of mortgage insurance coverage for the HARP Refinance loan and that Radian may cancel or rescind the mortgage insurance coverage if the Loan does not meet the terms of Radian’s Master Policy and/or all applicable HARP program requirements. \n**HARP Eligible Modification program is retired and replaced with the Radian’s GSE Refinance Modification Program for refinance applications received on or after November 1, 2018.","The submitter represents that the Radian GSE Refinance Modification meets the requirements of Radian Guaranty Inc. (“Radian”)’s Refinance Program, and the Refinance Program requirements as published by Fannie Mae or Freddie Mac, in effect on the day of submission, and that insurance for the Loan is currently in force with Radian.  The submitter also acknowledges that Radian is relying on the above representations for the continuation of mortgage insurance coverage for the Refinance Program  loan and that Radian may cancel or rescind the mortgage insurance coverage if the Loan does not meet the terms of Radian’s Master Policy and/or all applicable Refinance Program requirements.","Yes","Same Servicer - Fannie Mae High LTV Refinance Option",null,"AL","Pre-Closing Notification","FixedRate/FixedPayment","Y","Y","Y"]
["In Trial Period","Forbearance","FNM-HMP","ARM","1/1 ARM","6-Month Treasury Bills","Freddie Mac HARP - New Servicer","New Replacement Cert","Lender Refi Radian Mod","Second Home (Owner Occupied)","New full appraisal","Fax","Fannie Mae Refi Plus™ (HARP) Same Servicer","Fannie Mae HARP - Same Servicer","Lender Refi Radian Mod","Y","N","Y","Lender Paid","Fannie Mae Refi Plus™ (HARP) Same Servicer","Lender Refi Radian Mod","Freddie Mac Flex Modification","Declining","No","No","New Servicer - Fannie Mae High LTV Refinance Option",null,null,"Yes","New Servicer - Fannie Mae High LTV Refinance Option",null,"AK","Pre-Closing Update/Change Notification","1/1 ARM","N","N","N"]
["Completed","Repayment","FRE-HMP","Interest Only","2/1 ARM","1-Year Treasury Bills","Fannie Mae HARP - Same Servicer","Maintain","Lender Refi Radian Replacement","Non-Owner Occupied","Original appraisal (property value is not less than the original appraised value)",null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer","Freddie Mac HARP - Same Servicer","Lender Refi Radian Mod","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer","Lender Refi Radian Mod","Fannie Mae Extend Modification for Disaster Relief",null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refinance",null,null,"Yes","Same Servicer - Freddie Mac Enhanced Relief Refinance",null,"AZ","Post-Closing Modification Order","2/1 ARM"]
["Cancelled","DIL","HomeSaver Advance (HSA)","PayOption (POA)","3/1 ARM","3-Year Treasury Bills","Freddie Mac HARP - Same Servicer","Cancel","Lender Refi RadianTransfer",null,"Property Fieldwork Waiver",null,"Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer","Freddie Mac HARP - New Servicer","Lender Refi Radian Mod","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer","Lender Refi Radian Mod","Freddie Mac Extend Modification for Disaster Relief",null,null,null,"New Servicer - Freddie Mac Enhanced Relief Refinance",null,null,"Yes","New Servicer - Freddie Mac Enhanced Relief Refinance",null,"AR",null,"3/1 ARM"]
[null,"Short Sale","HomeSaver Forbearance (HSF)",null,"3/3 ARM","5-Year Treasury Securities","HARP - Defensive Refinance","Delete",null,null,"Home Value Explorer ®",null,"Non GSE refinance modification Same Servicer","HARP - Defensive Refinance","Lender Refi Radian Mod","Y",null,null,null,"Non GSE refinance modification Same Servicer","Lender Refi Radian Mod","Non-GSE Performing Rate and Term Modification",null,null,null,null,null,null,"No","Fannie Mae DU Refi Plus™  (HARP) Same Servicer",null,"CA",null,"3/3 ARM"]
[null,null,"Other",null,"5/1 ARM","11th District COFI","FNM-HMP",null,null,null,"Other",null,"Standard Delegated Performing Modification","Defensive Modification","Lender Mod Radian Mod","N",null,null,null,"Fannie Mae DU Refi Plus™ (HARP) New Servicer","Lender Refi Radian Transfer","Standard Delegated Defensive Modification",null,null,null,null,null,null,"No","Fannie Mae Refi Plus™ (HARP) Same Servicer",null,"CO",null,"5/1 ARM"]
[null,null,null,null,"7/1 ARM","National Median COFI","FRE-HMP",null,null,null,null,null,"Standard Delegated Default Modification","Default Modification","Lender Mod Radian Mod","N",null,null,null,"Fannie Mae Refi Plus™ (HARP) New Servicer","Lender Refi Radian Transfer","Standard Delegated Default Modification",null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ (HARP) Same Servicer",null,"CT",null,"7/1 ARM"]
[null,null,null,null,"10/1 ARM","Other","HomeSaver Forbearance (HSF)",null,null,null,null,null,"Fannie Mae DU Refi Plus™ (HARP) New Servicer","Servicing Transfer - Fannie Mae HARP","Lender Refi Radian Transfer","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer","Lender Refi Radian Transfer",null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ Open Access Same Servicer",null,"DE",null,"10/1 ARM"]
[null,null,null,null,"15/1 ARM","Prime Rate","Default Modification",null,null,null,null,null,"Fannie Mae Refi Plus™ (HARP) New Servicer","Servicing Transfer - Fannie Mae HARP","Lender Refi Radian Transfer","Y",null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer","Lender Refi Radian Transfer",null,null,null,null,null,null,null,"No","Non GSE refinance modification Same Servicer",null,"FL",null,"15/1 ARM"]
[null,null,null,null,"Step Rate","Federal COFI","Defensive Modification",null,null,null,null,null,"Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer","Servicing Transfer - Freddie Mac HARP","Lender Refi Radian Transfer","Y",null,null,null,null,null,null,null,null,null,null,null,null,"No","Fannie Mae DU Refi Plus™ (HARP) New Servicer",null,"GA",null,"Step Rate"]
[null,null,null,null,"Interest Only Fixed","LIBOR","Servicing Transfer - Fannie Mae HARP",null,null,null,null,null,"Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer","Servicing Transfer - Freddie Mac HARP","Lender Refi Radian Transfer","Y",null,null,null,null,null,null,null,null,null,null,null,null,"No","Fannie Mae Refi Plus™ (HARP) New Servicer",null,"HI",null,"Interest Only Fixed"]
[null,null,null,null,"Interest Only ARM","Certificates of Deposit","Servicing Transfer - Freddie Mac HARP",null,null,null,null,null,"Fannie Mae (HMP)","FNM-HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ (HARP) New Servicer",null,"ID",null,"Interest Only ARM"]
[null,null,null,null,null,"National Average Contract Rate on Previously Occupied Homes","Non-GSE HMP",null,null,null,null,null,"Freddie Mac (HMP)","FRE-HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,"No","Freddie Mac Relief Refinance Mortgage℠ Open Access New Servicer",null,"IL"]
[null,null,null,null,null,null,"Streamline Modification - Fannie Mae",null,null,null,null,null,"Non GSE (HMP)","Non-GSE HMP","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN"]
[null,null,null,null,null,null,"Streamline Modification - Freddie Mac",null,null,null,null,null,"Standard Delegated Defensive Modification","Defensive Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IA"]
[null,null,null,null,null,null,"Streamline Modification - Non-GSE",null,null,null,null,null,"Streamline Modification - Fannie Mae","Streamline Modification - Fannie Mae","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KS"]
[null,null,null,null,null,null,"Same Servicer - Fannie Mae High LTV Refi",null,null,null,null,null,"Streamline Modification - Freddie Mac","Streamline Modification - Freddie Mac","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY"]
[null,null,null,null,null,null,"Servicing Transfer - Fannie Mae High LTV Refi",null,null,null,null,null,"Streamline Modification - Non-GSE","Streamline Modification - Non-GSE","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA"]
[null,null,null,null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refi",null,null,null,null,null,"Same Servicer - Fannie Mae High LTV Refinance Option","Same Servicer - Fannie Mae High LTV Refi","Lender Refi Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ME"]
[null,null,null,null,null,null,"Servicing Transfer - Freddie Mac Enhanced Relief Refi",null,null,null,null,null,"New Servicer - Fannie Mae High LTV Refinance Option","Servicing Transfer - Fannie Mae High LTV Refi","Lender Refi Radian Transfer","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MD"]
[null,null,null,null,null,null,"Fannie Mae Flex Modification",null,null,null,null,null,"Same Servicer - Freddie Mac Enhanced Relief Refinance","Same Servicer - Freddie Mac Enhanced Relief Refi","Lender Refi Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA"]
[null,null,null,null,null,null,"Freddie Mac Flex Modification",null,null,null,null,null,"New Servicer - Freddie Mac Enhanced Relief Refinance","Servicing Transfer - Freddie Mac Enhanced Relief Refi","Lender Refi Radian Transfer","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
[null,null,null,null,null,null,"Fannie Mae Extend Modification for Disaster Relief",null,null,null,null,null,"Fannie Mae Flex Modification","Fannie Mae Flex Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MN"]
[null,null,null,null,null,null,"Freddie Mac Extend Modification for Disaster Relief",null,null,null,null,null,"Freddie Mac Flex Modification","Freddie Mac Flex Modification","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fannie Mae Extend Modification for Disaster Relief","Fannie Mae Extend Modification for Disaster Relief","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Freddie Mac Extend Modification for Disaster Relief","Freddie Mac Extend Modification for Disaster Relief","Lender Mod Radian Mod","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]

{"sheet":"ReleaseNotes2","index":6,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,8,0],[2,1,8,1]]}
["Date","Version","Enhancements and Bug Fixes"]
["2005-04-08",1,"Initial Version"]
["2005-04-08",2,"Removed \"Non-GSE Refinance Modification\" and \"Other\" from \"Program Name\" dropdown on the form"]
[null,null,"Added automatic map to \"Modification Method\" on the CSV based upon \"Program Name\" on the form"]
[null,null,"Added automatic entry of \"New/Modified Loan Amount\" on the CSV for any HARP program in \"Program Name\" on the form"]
[null,null,"Fixed \"Months Between Adjustment\" on the form to also map to \"Months Between Payment Adjustments\" on the CSV"]
[null,null,"Added map from \"Is Loan Current\" on the form to \"Existing Loan is Delinquent\" on the CSV"]
[null,null,"Added map from \"Due Date\" on the form to \"Next Due (prior to Mod)\" on the CSV"]
[null,null,"Added security to the form"]
["2005-04-08",2.1,"Fixed the date problem when copying from this template to another worksheet"]
["2009-04-13",2.2000000000000002,"Fixed \"Existing Loan is Delinquent\" mapping to reverse the Y/N value to sync with the \"Is Loan Current?\" question on the form"]
["2009-04-28",3,"Added new Enums for \"Mod Type\" field\nAdded 7 new columns\" FICO scores + Endorsement fax, phone, email and preference\nMapped \"Preferred Delivery Method\" on the form \"Servicer Contact Preferred Delivery Method\" on CSV"]
["2009-04-30",3.1,"Sync the \"Program Names\" on the form with the PDF version.  Map these to the LMA \"Modification Types\" on the CSV."]
["2009-05-04",3.2,"Add back the text after the asterisk previously removed by mistake\nAdded a box around the \"Program Name\" field on the form\nCorrected the \"TM\" to \"SM\" on the Freddie Mac Relief Refinance Program"]
["2009-05-12",3.3,"Removed \"For pool coverage, any amount capitalized may not be included in any \nfuture claim for loss\" from the form."]
["2009-06-02",3.4,"Updated with new Mod Types\nUpdated mapping between Mod Types on the form and the CSV"]
["2009-06-05",3.5,"Add text (\"For use with Same Servicer …. \") below \"Notification of Mortgage Insurance Modification\" on form \nCorrected mapping of \"Performing Modification\" to \"Lender Mod, Radian Mod\" on the CSV"]
["2009-07-13",3.6,"Added 2 new \"Modified Loan Types\" :  1/1 and 2/1 ARM.  Added \"Interest Only Indicator\" on the form and corrected logic on \"Interest Only Indicator\" field in CSV. Added additional logic in map to trap non-numeric values entered on the form for \"Interest Only Term\" and \"Balloon Term\" "]
["2009-09-14",4,"Added 3 fields for Step Terms.  Added new Mod Type : \"Freddie Mac - New Servicer\", and changed \"Freddie Mac HARP\" to \"Freddie Mac - Same Servicer\"."]
["2009-09-22",4.0999999999999996,"Added 3 fields for Step Terms to the data entry form."]
["2009-09-22",4.2,"Update existing Freddie Mac program and add a new one.  Add Balloon Amount."]
["2009-12-07",5,"Added support for 4th and 5th step rates/terms on the form.  No changes to the CSV."]
["2009-12-29",5.0999999999999996,"Remove logic to set \"Temporary Buydown Indicator\" = Y when there is a \"Step 1 Rate %\""]
["2011-12-07",5.2,"Changed format for HARP 2.0"]
["2013-04-08",5.4,"Added Renewal Type"]
["2013-05-17",5.6,"Added 3 new Mod Types"]
["2018-11-06",6,"Added 8 new mod Types for High LTV programs, Added High LTV Indicator, Added P&I for performing loans, removed balloon fields and added Forbearance fields. Updated to auto clear Mod type field if High LTV indicator is changed. Added Clear Form button"]
["2018-11-12",6.1,"Added Request Type, made State a drop down."]
["2019-01-02",6.2,"Added validation that will not allow the rest of the form to be filled in if Program Type is not selected along with appropriate error messaging. Added verbiage to assist with completing Program Name field. "]
["2020-06-12",6.3,"Updating radian.biz to radian.com.  Revision to labeling of Non-Performing and Performing mod catagories.   Updating verbiage associated with GSE Reinance programs. Removing of Endorsement mailing language"]
["2020-07-22",7,"Updated CertMod from .biz to .com, revised Description, renamed Performing to be Refinanced, renamed Non Performing to include Radian Approved Exceptions, changed wording when Refi Mod Prior Approval is Yes and when it is No, Changed Notification to Eligibility/Submission and revised wording "]
["2024-04-07",7.1,"Added Workout Program Name \"Non-GSE Performing Rate and Term Modification\""]
["2024-05-16",7.2,"Removed Workout Program Name \"Non GSE Performing Loan Modification\""]