8.7.86.3 Early Redemption (Prepayment Model)

Table 8-65 Early Redemption (Prepayment Model)

Report Name Assumptions - Early Redemption (Prepayment Model)
Report Criteria "Prepayment"."Calc Method", "Prepayment"."Cash Flow Treatment Type", "Prepayment"."Start Date (User Prepayments Date)", "Prepayment"."End Date (User Prepayments Date)", "Prepayment"."Prepayment Model Coefficient", case when "Prepayment"."Prepayment Model category Cd" is null then 'Not applicable' else "Prepayment"."Prepayment Model Category" end, case when "Prepayment"."Prepayment Model Sys Id" in (0) then 'Not Applicable' else "Prepayment"."Prepayment Model Name" end, '['||"Prepayment"."Currency Code (IRCS)"||']'||' '||"Prepayment"."IRC Name"||' '||'('||cast("Prepayment"."IRC Code" as char)||')', "Prepayment"."Rate Spread", "Prepayment"."Rate Term", Case when "Prepayment"."Seasonality Flg" in (0) then 'No' else 'Yes' end, "Prepayment"."January Coefficient", "Prepayment"."Febuary Coefficient", "Prepayment"."March Coefficient", "Prepayment"."April Coefficient", "Prepayment"."May Coefficient", "Prepayment"."June Coefficient", "Prepayment"."July Coefficient", "Prepayment"."August Coefficient", "Prepayment"."September Coefficient", "Prepayment"."October Coefficient", "Prepayment"."November Coefficient", "Prepayment"."December Coefficient", "Prepayment"."Ccy Cd", "Prepayment"."Prepayment Desc Short", "Product - Assumptions"."Product Id", "Product - Assumptions"."Product Name", "Prepayment"."Ppmt Sys Id"