Optimist Obligor Rating System_x0020_Rating,System.String Override_x0020_Rating,System.String Override_x0020_Reason,System.String Override_x0020_Comments,System.String Rating_x0020_Comments,System.String Assesment_x0020_User_x0020_Name,System.String Override_x0020_User_x0020_Name,System.String Assessment_x0020_Date,System.String Risk_x0020_Score,System.String LegalEntityId,System.Guid 1e2a1b0de69d4537978939835d66deca Obligor Rating Covenants Occurrences Action_x0020_Date,System.String Actual_x0020_Value,System.Double CovenantId,System.Int32 Due_x0020_Date,System.DateTime Extended_x0020_By_x0020__x0028_Days_x0029_,System.Int32 Id,System.Guid Occurrence_x0020_Date,System.DateTime Compliance,System.String Financial_x0020_Statement,System.String 1e0eb07e4b084bcfbd5f7e7dba24f8ea Occurrences Financial_x0020_Measure,System.String Criteria,System.String Requirement,System.String Number_x0020_of_x0020_Steps,System.String Step_x0020_Frequency,System.String Step_x0020_Start_x0020_Date,System.String Step,System.String Description,System.String EndDate,System.DateTime Frequency,System.Int32 Id,System.Int32 Is_x0020_Financial,System.String Status,System.String LegalEntityId,System.Guid Name,System.String StartDate,System.DateTime Model_x0020_Name,System.String Covenant_x0020_Type,System.String c31bedb939094ed78fd90a500d7191fc Covenants Occurrences Action_x0020_Date,System.String Actual_x0020_Value,System.Double CovenantId,System.Int32 Due_x0020_Date,System.DateTime Extended_x0020_By_x0020__x0028_Days_x0029_,System.Int32 Id,System.Guid Occurrence_x0020_Date,System.DateTime Compliance,System.String Financial_x0020_Statement,System.String 8b270938bdf84587b21568710a12282c Occurrences Legal Entity Obligor Rating System_x0020_Rating,System.String Override_x0020_Rating,System.String Override_x0020_Reason,System.String Override_x0020_Comments,System.String Rating_x0020_Comments,System.String Assesment_x0020_User_x0020_Name,System.String Override_x0020_User_x0020_Name,System.String Assessment_x0020_Date,System.String Risk_x0020_Score,System.String LegalEntityId,System.Guid 27da4442fc7a44dab0fe3bdf80526e0a Obligor Rating Covenants Occurrences Action_x0020_Date,System.String Actual_x0020_Value,System.Double CovenantId,System.Int32 Due_x0020_Date,System.DateTime Extended_x0020_By_x0020__x0028_Days_x0029_,System.Int32 Id,System.Guid Occurrence_x0020_Date,System.DateTime Compliance,System.String Financial_x0020_Statement,System.String d067bcc15e9b462fbdc0646be0cc056c Occurrences Financial_x0020_Measure,System.String Criteria,System.String Requirement,System.String Number_x0020_of_x0020_Steps,System.String Step_x0020_Frequency,System.String Step_x0020_Start_x0020_Date,System.String Step,System.String Description,System.String EndDate,System.DateTime Frequency,System.Int32 Id,System.Int32 Is_x0020_Financial,System.String Status,System.String LegalEntityId,System.Guid Name,System.String StartDate,System.DateTime Model_x0020_Name,System.String Covenant_x0020_Type,System.String c85471980dbf469fa073ea8ce0e031b0 Covenants Extra_x0020_Field1,System.String Extra_x0020_Field2,System.String Extra_x0020_Field3,System.String Extra_x0020_Field4,System.String Id,System.Guid Industry_x0020_Code,System.String Industry_x0020_Code_x0020_Level_x0020_1,System.String Industry_x0020_Code_x0020_Level_x0020_2,System.String Industry_x0020_Code_x0020_Level_x0020_3,System.String Industry_x0020_Code_x0020_Level_x0020_4,System.String Name,System.String Reference_x0020_Code,System.String Risk_x0020_Rating_x0020_Grade,System.String Portfolio_x0020_Name,System.String Industry_x0020_Name_x0020_Local,System.String Sector_x0020_Policy,System.String Brand,System.String Entity_x0020_type_x0020__x0028_Legal_x0020_Form_x0029_,System.String State_x0020__x002F__x0020_Territory,System.String Post_x0020_Code,System.String Customer_x0020_Type,System.String Bank_x0020_Segment_x0020_Type,System.String Entity_x0020_Segment_x0020_Type,System.String Site_x0020_Code_x0020__x0028_WBC_x0020_Only_x0029_,System.String Next_x0020_Review_x0020_Date,System.DateTime Financial_x0020_Monitoring,System.String RGS_x0020_Primary_x0020_Key,System.String WOS_x0020_Customer_x0020_Type,System.String ASCO,System.String Party_x0020_Type,System.String Sole_x0020_Trader,System.String Manager_x0020_Number,System.String BSB,System.String Manager_x0020_Name,System.String Total_x0020_Approved_x0020_Exposure,System.String Total_x0020_Security_x0020_Lending_x0020_Value,System.String Available_x0020_Security_x0020_Capacity,System.String Loan_x0020_to_x0020_lending_x0020_Value_x0020_Ratio,System.String Customer_x0020_Risk_x0020_Grade,System.String Data_x0020_Last_x0020_Credit_x0020_Approved_x0020_Risk_x0020_Grade,System.String GSA_x0020_Status,System.String GSA_x0020_Amount,System.String Date_x0020_of_x0020_Last_x0020_Valuation,System.String Connection_x0020_Total_x0020_Approved_x0020_Exposure,System.String Connection_x0020_Security_x0020_LV,System.String Connection_x0020_Number,System.String WBC_x0020_CRMs_x0020_Salary_x0020_Id,System.String CRMs_x0020_WOUP_x0020_Key,System.String SGB_x0020_CRMs_x0020_Salary_x0020_Id,System.String 217cf3539ecf43439dd145ea0cfcaf2b Legal Entity Optimist f6889a1cd8384b0ca19c1846dac8cf60 Optimist ServiceabilityAssessmentSchema BusinessFinancials BusinessFinancials_Id,System.Int32 ServiceabilityAssessmentReportData_Id,System.Int32 d1371052cefc4201a6792d22fd2f09f0 BusinessFinancials BusinessEntities BusinessEntities_Id,System.Int32 BusinessFinancials_Id,System.Int32 a17a6b921b5e48da8c8d1da2b6c2d1af BusinessEntities Entity EntityName,System.String ZNumber,System.String StatementPeriod,System.DateTime ICR,System.Double DSC,System.Double Surplus,System.Double EntityComments,System.String Entity_Id,System.Int32 BusinessEntities_Id,System.Int32 252227ec35494d7d91648c7989a5c9ea Entity Accounts Accounts_Id,System.Int32 Entity_Id,System.Int32 d4359a4fc1734861890808344b9fa957 Accounts Account Label,System.String Alias,System.String Value,System.Double Accounts_Id,System.Int32 73abab7701614b0a94a3c6fcdc4a86af Account Loans Loans_Id,System.Int32 Entity_Id,System.Int32 dda561aa8fee4ddeba38117d7ddf79e6 Loans Loan Type,System.String AccountNumber,System.String Interest,System.Double TotalPayment,System.Double Loans_Id,System.Int32 cb48ce78f7aa4add8c6ac1dfb40a80b6 Loan PersonalFinancials PersonalFinancials_Id,System.Int32 ServiceabilityAssessmentReportData_Id,System.Int32 ceb62ed5b8094fb588f5e5eee45174d0 PersonalFinancials HouseholdEntities HouseholdEntities_Id,System.Int32 PersonalFinancials_Id,System.Int32 54596a8a03484182b83e037f6995c8e9 HouseholdEntities HouseholdEntity Person1EntityName,System.String Person1ZNumber,System.String Person2EntityName,System.String Person2ZNumber,System.String Person1Comments,System.String Person2Comments,System.String ICR,System.Double DSC,System.Double ActualSurplus,System.Double RequiredSurplus,System.Double EntityComments,System.String HouseholdEntity_Id,System.Int32 HouseholdEntities_Id,System.Int32 ea64e98518f243da91c145ebb7f8e00f HouseholdEntity Person1Accounts Person1Accounts_Id,System.Int32 HouseholdEntity_Id,System.Int32 8dd3f943123a43a69ac6591d3baecb92 Person1Accounts Person1Account Label,System.String Alias,System.String Value,System.Double Person1Accounts_Id,System.Int32 3abfcab26ab4443dbdfebdbe65ec1801 Person1Account Person2Accounts Person2Accounts_Id,System.Int32 HouseholdEntity_Id,System.Int32 2e317c0cbfae40cfa1a80261f1822df0 Person2Accounts Person2Account Label,System.String Alias,System.String Value,System.Double Person2Accounts_Id,System.Int32 79d773bdafc24976ac2b61057a21cca2 Person2Account ServiceabilityAssessmentReportData AssessmentName,System.String AssessmentNumber,System.String DateCreated,System.DateTime GroupName,System.String GroupNumber,System.String ManagerName,System.String OverallComments,System.String OverallICR,System.Double OverallDSC,System.Double OverallSurplus,System.Double ServiceabilityAssessmentReportData_Id,System.Int32 7ca2df0c4d404f4f9ee9d1fe108b3e83 ServiceabilityAssessmentReportData Person1Loans Person1Loans_Id,System.Int32 HouseholdEntity_Id,System.Int32 1337f1e263c449e4b9d09d04c8f3481c Person1Loans Person1Loan Type,System.String AccountNumber,System.String Interest,System.Double TotalPayment,System.Double Person1Loans_Id,System.Int32 151f7d541b82492b8eeb6e1bfb5a703a Person1Loan Person2Loans Person2Loans_Id,System.Int32 HouseholdEntity_Id,System.Int32 f438db00ecb04b7495eb83443a423b19 Person2Loans Person2Loan Type,System.String AccountNumber,System.String Interest,System.Double TotalPayment,System.Double Person2Loans_Id,System.Int32 3e9d8802cbc24184aa818147412ed9b7 Person2Loan ServiceabilityAssessmentSchema 0cbe126f0b664f3d9898a55cc2716038 ServiceabilityAssessmentSchema EngineV2 //Panel7.Enabled = false; None;Black;2;Solid;False;4;Black Transparent Bottom;[127:127:127];1;Solid;False;4;Black Transparent 0,0.4,19,1.6 p.Page2 Transparent 0,0,15.8,0.6 ph.PageHeaderBand1 Arial,10 a6a3e4eac8474b50a92d02503aa1077f 0,0,0,0 Text27 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.GroupName} - {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.GroupNumber} Black Expression Transparent 0,0.6,14.4,0.6 ph.PageHeaderBand1 Arial,8 851b8c01dfd641728f3b37c2b6c16814 0,0,0,0 Text29 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.AssessmentName} ({ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.AssessmentNumber}) [127:127:127] Expression Transparent 15.8,0,3.2,0.6 ph.PageHeaderBand1 Arial,8 0e575977d0764ef9a4f70eb223bd79ae Right 0,0,0,0 Text30 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.ManagerName} [127:127:127] Expression Transparent 14.4,0.6,4.6,0.6 ph.PageHeaderBand1 Arial,8 0eb3a9e1995046a1a6fddda48db96296 Right 0,0,0,0 Text31 Date Created: {Format("{0:dd/MM/yyyy}", Time)} [127:127:127] Expression PageHeaderBand1 Transparent True 0,2.8,19,16.4 p.Page2 Transparent 0,0,19,0.8 ph.PageHeaderBand2 Arial,20 1e896182558c49cda732283da265ed4b Center 0,0,0,0 Text32 Overall Servicing Ratios [63:63:63] Expression Center Transparent 6.4,1.8,6.2,1.4 ph.PageHeaderBand2 _x007B_ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallDSC_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,33 aef23a971bb8497da7201be6351ba56e Center 0,0,0,0 Text33 {Format("{0:N2}", ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallDSC)}x [12:12:12] , 1 False Expression Center Transparent 12.6,1.8,6.4,1.4 ph.PageHeaderBand2 _x007B_ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallSurplus_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,33 093f4f38f28046238961be61bca5fb8a Center 0,0,0,0 Text34 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallSurplus} [12:12:12] 0 , 1 0 False Expression Center Transparent 6.4,1,6.2,0.6 ph.PageHeaderBand2 Arial,8 9db087b1ea0c46edbe6184a3b669b2f1 Center 0,0,0,0 Text35 Overall DSC [127:127:127] Expression Center Transparent 12.6,1,6.4,0.6 ph.PageHeaderBand2 Arial,8 82b534f5b71f4c9d833101b71c55e71f Center 0,0,0,0 Text36 Overall Surplus [127:127:127] Expression Center Transparent 0,1,6.4,0.6 ph.PageHeaderBand2 Arial,8 13d7c50160f742299155099714efa141 Center 0,0,0,0 Text37 Overall ICR [127:127:127] Expression Center Transparent 0,1.8,6.4,1.4 ph.PageHeaderBand2 _x007B_ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallICR_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,33 3a75790745aa4c719d9c44182fce14bb Center 0,0,0,0 Text38 {Format("{0:N2}", ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallICR)}x [12:12:12] , 1 False Expression Center Transparent True True 0,3.6,19,12.6 ph.PageHeaderBand2 1 Transparent 73abab7701614b0a94a3c6fcdc4a86af True 0,0.4,19,0 ph.Panel5 _x007B_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_401700_x0022__x007D_ 94e28002d5514be1a2889a6e84480516 BusinessEBITAggregatorBand 1 1 Transparent 73abab7701614b0a94a3c6fcdc4a86af True 0,1.2,19,0 ph.Panel5 _x007B_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_401600_x0022__x007D_ 665d130977b84378998e931aa71d5b95 BusinessEBITDAAggregatorBand 1 1 Transparent 73abab7701614b0a94a3c6fcdc4a86af True 0,2,19,0 ph.Panel5 _x007B_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_170000_x0022__x007D_ 06038e9c388043948fd038d58bcfd27d BusinessTaxAggregatorBand 1 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 True 0,2.8,19,0 ph.Panel5 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_1200005_x0022__x007D_ 6f6e9a67dfa2430fb8401e1ddc234b30 Person1IAFDSAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 True 0,3.6,19,0 ph.Panel5 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_1200005_x0022__x007D_ 8539ff6586c94681857f02dfb72c4e1a Person2IAFDSAggregatorBand Transparent cb48ce78f7aa4add8c6ac1dfb40a80b6 True 0,4.4,19,0 ph.Panel5 ea764f02b9194d38ba0b6958270b0a0c BusinessLoanAggregatorBand Transparent True 0,5.2,19,3.6 ph.Panel5 Transparent True 0,0.8,6,0.6 d.DataBand19 Arial,8 5dd1cee07c054243a57413a58476421a 0,0,0,0 Text50 Business ICR ((IAFDS - Dep)/Bus Int) [63:63:63] Expression Center Transparent True 17,0.8,2,0.6 d.DataBand19 Arial,8 1e4417496f714aabbb266150ac8ddaab Right 0,0,0,0 Text65 {Format("{0:N2}", ((Sum(Person1IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)+Sum(BusinessEBITAggregatorBand,ServiceabilityAssessmentSchema.Account.Value))/(Sum(BusinessLoanAggregatorBand,ServiceabilityAssessmentSchema.Loan.Interest)/1000)))}x [63:63:63] , 1 Expression Center Transparent True 0,1.4,6,0.6 d.DataBand19 Arial,8 ce545b7a6bd844bea8d59667ff5328cc 0,0,0,0 Text71 Business ICR (IAFDS/Bus Int) [63:63:63] Expression Center Transparent True 17,1.4,2,0.6 d.DataBand19 Arial,8 dd669245d6fa49ba80ce53e0cd39d2ee Right 0,0,0,0 Text77 {Format("{0:N2}", (Sum(Person1IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)+Sum(BusinessEBITDAAggregatorBand,ServiceabilityAssessmentSchema.Account.Value))/(Sum(BusinessLoanAggregatorBand,ServiceabilityAssessmentSchema.Loan.Interest)/1000))}x [63:63:63] , 1 Expression Center Transparent True 0,2,6,0.6 d.DataBand19 Arial,8 749de5798af04e4c961540b434b112fc 0,0,0,0 Text78 Business DSC ((IAFDS - Tax)/Bus PIF) [63:63:63] Expression Center Transparent True 17,2,2,0.6 d.DataBand19 Arial,8 285ba4b4a8b04af5a31813658969dff7 Right 0,0,0,0 Text79 {Format("{0:N2}", (Sum(Person1IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2IAFDSAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)+Sum(BusinessEBITDAAggregatorBand,ServiceabilityAssessmentSchema.Account.Value)-Sum(BusinessTaxAggregatorBand,ServiceabilityAssessmentSchema.Account.Value))/(Sum(BusinessLoanAggregatorBand,ServiceabilityAssessmentSchema.Loan.TotalPayment)/1000))}x [63:63:63] 0 , 1 0 False Expression Center [216:216:216] 0,0.2,19,0.6 d.DataBand19 Arial,8,Bold 58aab5a3daf54d538422492841f455e9 0,0,0,0 Text9 Business Ratios (IAFDS) [89:89:89] Expression Center [216:216:216] 0,2.8,19,0.6 d.DataBand19 Arial,8,Bold 42814d8a4b85453f96bcebe6f743c4c3 0,0,0,0 Text39 Overall Comments [89:89:89] Expression Center DataBand19 Transparent True 0,9.6,19,1.6 ph.Panel5 [216:216:216] True True True 0,0,19,1.6 d.DataBand5 Arial,8 True da2557d7ce8f4998a991179ae3e0ffdc 0,0,0,0 OverallComments {System.Text.RegularExpressions.Regex.Replace(System.Text.RegularExpressions.Regex.Replace(System.Text.RegularExpressions.Regex.Replace(ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.OverallComments,"&#34;",@""),"<br/>","\r\r\r"),@"<(.|n)*?>", String.Empty)} [89:89:89] ,,,,WordWrap=True,A=0 Wysiwyg Expression DataBand5 Transparent True 0,12,19,0.6 ph.Panel5 Bottom;[127:127:127];1;Solid;False;4;Black Transparent 0,0,19,0.6 d.DataBand18 _x007B_Count_x0028_ServiceabilityAssessmentSchema.Entity_x0029__x003D__x003D_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None,None Arial,20 027b312f3f224e1cb63619af0c343fdf 0,0,0,0 Text41 Business Financials [63:63:63] Expression Center DataBand18 True Panel5 PageHeaderBand2 OnlyFirstPage Transparent 0,347,19,1 p.Page2 Transparent True 0,0,19,0.6 pf.PageFooterBand2 Arial,8 1d6ad4db3c8a4e9c9695fc4af76983f8 Center 0,0,0,0 Text73 {PageNofM} [63:63:63] 0 , 1 0 False SystemVariables Center 0c21b96b67d0442f9020edddcbcb57fd PageFooterBand2 Transparent True 0,20,19,3.2 p.Page2 Transparent True 0,0,19,0.6 d.DataBand6 Arial,8,Bold ff937705dd79463dbc0c51f9041493c5 0,0,0,0 Text42 BUSINESS ENTITY [218:41:28] Expression Center Transparent True 0,1.8,7.8,0.6 d.DataBand6 Arial,8,Bold 09321ed5c6ae468a952d328b5dfba121 0,0,0,0 Text43 Statement Period [63:63:63] Expression Center Transparent True 14.4,1.8,4.6,0.6 d.DataBand6 Arial,8,Bold d44178270df04cca80946077d4b565a1 Right 0,0,0,0 Text44 {ServiceabilityAssessmentSchema.Entity.StatementPeriod} [63:63:63] DataColumn Center Transparent True 0,0.6,7.8,0.6 d.DataBand6 Arial,8,Bold 556610535d2f45e0bd672f5c641710bf 0,0,0,0 Text45 Entity Name [63:63:63] Expression Center Transparent True 7.8,0.6,11.2,0.6 d.DataBand6 Arial,8,Bold 4aad39c65fda4fd0938f72337a4d4624 Right 0,0,0,0 Text46 {ServiceabilityAssessmentSchema.Entity.EntityName} [63:63:63] DataColumn Center Transparent True 0,1.2,7.8,0.6 d.DataBand6 Arial,8,Bold 4916afaa12b34f7690d9e541556e9acd 0,0,0,0 Text47 CIS/CRS [63:63:63] Expression Center Transparent True 14.4,1.2,4.6,0.6 d.DataBand6 Arial,8,Bold d053c30212164f0ea4f74d27646b831a Right 0,0,0,0 Text48 {ServiceabilityAssessmentSchema.Entity.ZNumber} [63:63:63] DataColumn Center [242:242:242] True 0,2.6,19,0.6 d.DataBand6 Arial,8,Bold a16bec78010542df888f8ff1d45d672f 0,0,0,0 Text49 Income [63:63:63] Expression Center {ServiceabilityAssessmentSchema.Entity.Entity_Id} False GroupHeaderBand5 Transparent 252227ec35494d7d91648c7989a5c9ea 0,24,19,0 DataBand7 Transparent 0,24.8,19,1 p.Page2 Transparent True True 0,0,19,1 1 Transparent 73abab7701614b0a94a3c6fcdc4a86af True 0,0.4,19,0.6 p.Page2 Transparent True 0,0,9,0.6 d.DataBand7 Arial,8 bcf569756eea4db6afd5afb77f8c58a1 0,0,0,0 Text51 {ServiceabilityAssessmentSchema.Account.Label} [63:63:63] DataColumn Center Transparent True 12.4,0,6.6,0.6 d.DataBand7 _x007B_ServiceabilityAssessmentSchema.Account.Value_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,8 ab14b166feb841c387ae5853dc47c026 Right 0,0,0,0 Text52 {ServiceabilityAssessmentSchema.Account.Value} [63:63:63] 0 , 1 0 False DataColumn Center _x007B_ServiceabilityAssessmentSchema.Account.Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.Entity.Entity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_401600_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_402000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_170000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_162300_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_180000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_180006_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_160000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_160200_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Account.Alias_x003D__x003D__x0022_161000_x0022__x007D_ e8296efd4a8648b8a59f17e750d0e9f7 True KeepDetailsTogether DataBand6 1 True Panel7 False ChildBand2 Transparent True 0,26.6,19,2.6 p.Page2 Transparent True True 0,0,19,2.6 d.ChildBand1 Transparent True 0,0.4,19,0.8 d.Panel1 [242:242:242] True 0,0.2,9,0.6 gh.GroupHeaderBand1 Arial,8,Bold afa6ba28a5b242d384699ea2334ee71f 0,0,0,0 Text1 Facilities [63:63:63] Expression Center [242:242:242] True 9,0.2,5,0.6 gh.GroupHeaderBand1 Arial,8,Bold 8ce0bac0fcb2464ab7962249cd571838 Right 0,0,0,0 Text4 Interest Payable [63:63:63] Expression Center [242:242:242] True 14,0.2,5,0.6 gh.GroupHeaderBand1 Arial,8,Bold 054795abf9bd408f8f0320d0e44b97fb Right 0,0,0,0 Text5 Total Payable [63:63:63] Expression Center GroupHeaderBand1 1 Transparent cb48ce78f7aa4add8c6ac1dfb40a80b6 True 0,2,19,0.6 d.Panel1 Transparent True 0,0,9,0.6 d.BusinessLoansBand Arial,8 3ea586fb603b44359b4962a91f9d77fa 0,0,0,0 Text2 {ServiceabilityAssessmentSchema.Loan.Type} [63:63:63] DataColumn Center Transparent True 14,0,5,0.6 d.BusinessLoansBand Arial,8 2f5a898895e7404e99d7c00a8cae13be Right 0,0,0,0 Text3 {Format("{0:C2}", ServiceabilityAssessmentSchema.Loan.TotalPayment/1000)} [63:63:63] 0 , 1 0 False Expression Center Transparent True 9,0,5,0.6 d.BusinessLoansBand Arial,8 04cd6bf068f54fc6a184364d62717773 Right 0,0,0,0 Text6 {Format("{0:C2}", ServiceabilityAssessmentSchema.Loan.Interest/1000)} [63:63:63] 0 , 1 0 False Expression Center _x007B_ServiceabilityAssessmentSchema.Loan.Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.Entity.Entity_Id_x007D_ 49be4cc2ec1a4fef9a00924bcb8df809 BusinessLoansBand 1 True Panel1 False ChildBand1 Transparent 0,30,19,6.9 p.Page2 Transparent True 0,0,19,6.9 d.ChildBand3 Transparent True 0,0.4,19,0.7 d.Panel2 [242:242:242] True 0,0.2,19,0.6 gh.GroupHeaderBand2 Arial,8,Bold a87655f6663e4d43817fcbe3ed4c2819 0,0,0,0 Text7 Business Servicing Ratios [63:63:63] Expression Center 4fb4b3631ec6472293daee1a9655939b GroupHeaderBand2 Transparent True 0,1.9,19,2.6 d.Panel2 Transparent True 0,0,6,0.6 d.DataBand2 Arial,8 6f306bc56fee4631b1f42e7d0d4ee250 0,0,0,0 Text14 Business ICR ((Adj EBIT)/Bus Int) [63:63:63] Expression Center Transparent True 17,0,2,0.6 d.DataBand2 Arial,8 2de8e879f94d49d5a5e6e6a04f79262f Right 0,0,0,0 Text15 {Format("{0:N2}", ServiceabilityAssessmentSchema.Entity.ICR)}x [63:63:63] , 1 Expression Center Transparent True 0,0.6,6,0.6 d.DataBand2 Arial,8 a3eaf89414604faaa19879c673e18610 0,0,0,0 Text18 Business DSC ((Adj EBITDA - Tax)/Bus PIF) [63:63:63] Expression Center Transparent True 17,0.6,2,0.6 d.DataBand2 Arial,8 19966c7d949f4fad89b2d8e13b33c64a Right 0,0,0,0 Text19 {Format("{0:N2}", ServiceabilityAssessmentSchema.Entity.DSC)}x [63:63:63] , 1 Expression Center [216:216:216] 0,2,19,0.6 d.DataBand2 Arial,8,Bold 41dab6c638ff40069932ba10e7d57054 0,0,0,0 Text69 Business Financials Comments [89:89:89] Expression Center Transparent 0,1.2,6,0.6 d.DataBand2 Arial,8 0,0,0,0 Text12 Business Surplus (Adj EBITDA - Tax - Bus PIF) [63:63:63] Expression Center Transparent 17,1.2,2,0.6 d.DataBand2 Arial,8 Right 0,0,0,0 Text13 {Format("{0:C2}", ServiceabilityAssessmentSchema.Entity.Surplus)} [63:63:63] , 1 Expression Center DataBand2 Transparent True True 0,5.3,19,0.8 d.Panel2 True [216:216:216] True True True 0,0,19,0.8 d.DataBand16 Arial,8 True 0686c771ba7b4d9cac141c121993b92a 0,0,0,0 Text70 {ServiceabilityAssessmentSchema.Entity.EntityComments} [89:89:89] Wysiwyg DataColumn DataBand16 Transparent 0,6.9,19,0 d.Panel2 GroupFooterBand1 True Panel2 ChildBand3 b96c825a306f477dabf1ff1a9b8df9ec True 12 1,1,1,1 Page2 31 21 A4 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Bottom;[127:127:127];1;Solid;False;4;Black Transparent 0,0.4,19,1.6 p.Page1 Transparent 0,0,15.8,0.6 ph.PageHeaderBand3 Arial,10 65822a545b4c46c091943949bb0f09c5 0,0,0,0 Text16 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.GroupName} - {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.GroupNumber} Black Expression Transparent 0,0.6,14.4,0.6 ph.PageHeaderBand3 Arial,8 cf5014c5d74b4e48ba320a0e1dbe8c6e 0,0,0,0 Text17 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.AssessmentName} ({ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.AssessmentNumber}) [127:127:127] Expression Transparent 15.8,0,3.2,0.6 ph.PageHeaderBand3 Arial,8 d2c0f375d2884d05997691c4b1742656 Right 0,0,0,0 Text20 {ServiceabilityAssessmentSchema.ServiceabilityAssessmentReportData.ManagerName} [127:127:127] Expression Transparent 14.4,0.6,4.6,0.6 ph.PageHeaderBand3 Arial,8 c46f6e4e740c4832a8015ac1093a05b5 Right 0,0,0,0 Text21 Date Created: {Format("{0:dd/MM/yyyy}", Time)} [127:127:127] Expression fb5bbe0b3f7541ac9fd603fe3af7750a PageHeaderBand3 Transparent 0,115.2,19,0.8 p.Page1 Transparent True 0,0,19,0.8 pf.PageFooterBand1 Arial,8 b1d6b11843d14a80864688833a94c245 Center 0,0,0,0 Text72 {PageNofM} [63:63:63] 0 , 1 0 False SystemVariables Center PageFooterBand1 Transparent True 0,2.8,19,1 p.Page1 Bottom;[127:127:127];1;Solid;False;4;Black Transparent 0,0.2,19,0.8 gh.GroupHeaderBand3 Arial,20 a965b3bbb99143d48650bbccbaf6f20d 0,0,0,0 Text23 Personal Financials [63:63:63] Expression Center {ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id} 8895abe25b6f4bf791afb4803cb99453 GroupHeaderBand3 Transparent ea64e98518f243da91c145ebb7f8e00f True True 0,4.6,19,14.5 p.Page1 Transparent True True 0,0,10,14.5 d.DataBand3 Transparent 0,0.4,10,0 d.Panel3 {ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id} GroupHeaderBand4 Transparent True 0,1.2,10,2.6 d.Panel3 Transparent True 0,0,10,0.4 d.DataBand4 _x007B_ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName_x003D__x003D__x0022__x0022__x007D_,Red,Transparent,Arial_x002C_8,True,True,_x0022_PERSONAL_x0020_ENTITY_x0022_,,None,None Arial,8,Bold 4e0a8baac5c441cdb9b4763de2544da5 0,0,0,0 Text24 HOUSEHOLD [218:41:28] Expression Center Transparent True 0,1,10,0.6 d.DataBand4 Arial,8,Bold 13b0191462f44b74b55a074df7806a7e 0,0,0,0 Text25 Entity Name [63:63:63] Expression Center Transparent True 0,1.6,10,0.4 d.DataBand4 Arial,8,Bold 6d2ccd827a6a4f4681e7364a2cdda487 0,0,0,0 Text26 CIS/CRS [63:63:63] Expression Center [242:242:242] True 0,2.2,10,0.6 d.DataBand4 Arial,8,Bold 8b1a58d3fd54411aa13837ea5d2079a9 0,0,0,0 Text53 Income [63:63:63] Expression Center Transparent True 0,0.4,10,0.6 d.DataBand4 _x007B_ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName_x003D__x003D__x0022__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None,None Arial,8,Bold 8cf90551b9204b5683f1ac1490f9c0fa 0,0,0,0 Text40 This household consists of {ServiceabilityAssessmentSchema.HouseholdEntity.Person1EntityName} and {ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName} Black ,,,,WordWrap=True,A=0 Expression Center DataBand4 Transparent True 0,4.6,10,1.1 d.Panel3 Transparent True 0,0,10,1 d.ChildBand4 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 True 0,0.4,10,0.6 d.Panel4 Transparent True 0,0,10,0.6 d.DataBand8 Arial,8 f7eae17243d9488ebdc8ba1b40606716 0,0,0,0 Text54 {ServiceabilityAssessmentSchema.Person1Account.Label} [63:63:63] Expression Center _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_160001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_160002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_170000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_180000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ DataBand8 Panel4 ChildBand4 Transparent 0,6.5,10,2.6 d.Panel3 Transparent True 0,0,10,2.4 gf.ChildBand7 Transparent True 0,0.4,10,0.8 gf.Panel14 [242:242:242] True 0,0.2,10,0.6 gh.GroupHeaderBand8 Arial,8,Bold e189a004d79d4faaa727d2a1e568e303 0,0,0,0 Text63 Outgoings (Actual PM) [63:63:63] Expression Center GroupHeaderBand8 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 True True 0,2,10,0.6 gf.Panel14 Transparent True 0,0,10.2,0.6 d.DataBand13 Arial,8 013d991280224ce5b7607befa51da973 0,0,0,0 Text64 {IIF(ServiceabilityAssessmentSchema.Person1Account.Alias=="200000"||ServiceabilityAssessmentSchema.Person1Account.Alias=="200001","Bank "+ServiceabilityAssessmentSchema.Person1Account.Label,IIF(ServiceabilityAssessmentSchema.Person1Account.Alias=="210000"||ServiceabilityAssessmentSchema.Person1Account.Alias=="210001","Other Bank "+ServiceabilityAssessmentSchema.Person1Account.Label,ServiceabilityAssessmentSchema.Person1Account.Label))} [63:63:63] Expression Center _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_210000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_210001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_200000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_200001_x0022__x007D_ DataBand13 630d10bb2da44a0399b398f76e8c72f8 Panel14 ChildBand7 Transparent 0,9.9,10,0.2 d.Panel3 6156e2206fde4c7faf54f6b2e9cadd2e GroupFooterBand5 Transparent True 0,10.9,10,0.6 d.Panel3 [242:242:242] True 0,0,10,0.6 gh.GroupHeaderBand9 Arial,8,Bold 7393682afe404216835f7d1339823342 0,0,0,0 Text109 Facilities [63:63:63] Expression Center 2f88201ef1124202bd71a95474a5b560 GroupHeaderBand9 Transparent 151f7d541b82492b8eeb6e1bfb5a703a True True 0,12.3,10,0.6 d.Panel3 Transparent True 0,0,5.4,0.6 d.DataBand22 Arial,8 4af20c9b16f141088a51fc693af1ef67 0,0,0,0 Text104 {ServiceabilityAssessmentSchema.Person1Loan.Type} [63:63:63] DataColumn Center Transparent True 6,0,3.6,0.6 d.DataBand22 Arial,8 b87d9c3ca8d449f6b0328395e0434213 0,0,0,0 Text10 {ServiceabilityAssessmentSchema.Person1Loan.AccountNumber} [127:127:127] DataColumn Center _x007B_ServiceabilityAssessmentSchema.Person1Loan.Person1Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ f1c1231f7f95498eaf65ffad805cab2e DataBand22 Transparent 3e9d8802cbc24184aa818147412ed9b7 True True 0,13.7,10,0.6 d.Panel3 Transparent True 0,0,5.4,0.6 d.DataBand25 Arial,8 e4865b12e97647989759865837f312e8 0,0,0,0 Text110 {ServiceabilityAssessmentSchema.Person2Loan.Type} [63:63:63] Expression Center Transparent True 6,0,3.6,0.6 d.DataBand25 Arial,8 eac7d09a763b4d9295e3436f6ed782f4 0,0,0,0 Text11 {ServiceabilityAssessmentSchema.Person2Loan.AccountNumber} [127:127:127] DataColumn Center _x007B_ServiceabilityAssessmentSchema.Person2Loan.Person2Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ ae187c49b5964998a2f83dd3584f21f3 DataBand25 True Panel3 Transparent True True 10,0,4.8,14.5 d.DataBand3 Transparent 0,0.4,4.8,0 d.Panel8 {ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id} 05af4ad6816f4e8787bf57f24b13aa40 GroupHeaderBand6 Transparent True 0,1.2,4.8,2.6 d.Panel8 Transparent True 0,1,4.8,0.6 d.DataBand9 Arial,8,Bold 1564fb6dc4a14f339e7c528d8a53e757 Right 0,0,0,0 Text56 {ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName} [63:63:63] Expression Center Transparent True 0,1.6,4.8,0.4 d.DataBand9 Arial,8,Bold db7ea85a33b44633aebee29010461bed Right 0,0,0,0 Text57 {ServiceabilityAssessmentSchema.HouseholdEntity.Person2ZNumber} [63:63:63] DataColumn Center [242:242:242] True 0,2.2,4.8,0.6 d.DataBand9 Arial,8,Bold a52508252b69485db766d536f57a4c43 0,0,0,0 Text58 [63:63:63] Expression Center a75545cba6a245f7882070b6f6357bfe DataBand9 Transparent True 0,4.6,4.8,1.1 d.Panel8 Transparent True 0.8,0,4,1 d.ChildBand5 Transparent 79d773bdafc24976ac2b61057a21cca2 True 0,0.4,4,0.6 d.Panel9 Transparent True 0,0,4,0.6 d.DataBand10 _x007B_ServiceabilityAssessmentSchema.Person2Account.Value_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,8 be339cfd62274b5b8aae65c88469bb75 Right 0,0,0,0 Text59 {ServiceabilityAssessmentSchema.Person2Account.Value} [63:63:63] , 1 0 DataColumn Center 5 _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_160001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_160002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_170000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_180000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ 27f3991e0caf456db920820978efbc32 DataBand10 7393695020cd4b65b85860b52fc50d35 Panel9 Transparent True 0,0,0.8,1 d.ChildBand5 Transparent True 0,0.4,0.8,0.6 d.Panel9 5 _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_160001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_160002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_170000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_180000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ cd706e426ffe4102991691bc41fb0755 DataBand3 2392ae1845d142faa41a7acfa5951d01 Panel6 645750d94f1b473fabdaa9c430f50f7c ChildBand5 Transparent 0,6.5,4.8,2.6 d.Panel8 Transparent True 0,0,4.8,2.4 gf.ChildBand8 Transparent True 0,0.4,4.8,0.8 gf.Panel13 [242:242:242] True 0,0.2,4.8,0.6 d.DataBand9 Arial,8,Bold d53ee4d4518246cf80b5af5e55d8f36e 0,0,0,0 Text80 [63:63:63] Expression Center DataBand1 Transparent 79d773bdafc24976ac2b61057a21cca2 True True 0,2,4.8,0.6 gf.Panel13 Transparent True 0,0,4.8,0.6 d.DataBand14 _x007B_ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName_x003D__x003D__x0022__x0022__x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None,None _x007B_ServiceabilityAssessmentSchema.Person2Account.Value_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,8 dd2fd82751304792afabb9641fbea98b Right 0,0,0,0 Text67 {ServiceabilityAssessmentSchema.Person2Account.Value} [63:63:63] , 1 0 DataColumn Center _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_220001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_220000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_220002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_210000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_210001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_200000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_200001_x0022__x007D_ DataBand14 bac3c7a25798462f83fc946e8f3ed8f2 Panel13 ChildBand8 Transparent 0,9.9,4.8,0.2 d.Panel8 GroupFooterBand4 [242:242:242] True 0,10.9,4.8,0.6 d.Panel8 [242:242:242] True 2.6,0,2.2,0.6 gh.GroupHeaderBand10 Arial,8,Bold ba978740ecf04567a9ffd749e2f76978 Right 0,0,0,0 Text112 Total Payable [63:63:63] Expression Center [242:242:242] True 0,0,2.6,0.6 gh.GroupHeaderBand10 Arial,8,Bold 5e8efb944b4148ed99addee04e9da465 Right 0,0,0,0 Text111 Interest Payable [63:63:63] Expression Center _x007B_ServiceabilityAssessmentSchema.HouseholdEntity.Person2EntityName_x003D__x003D__x0022__x0022__x007D_,Red,[242:242:242],Arial_x002C_8,False,False,,,None,None GroupHeaderBand10 Transparent 151f7d541b82492b8eeb6e1bfb5a703a 0,12.3,4.8,0.6 d.Panel8 _x007B_ServiceabilityAssessmentSchema.Person1Loan.Person1Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ DataBand26 Transparent 3e9d8802cbc24184aa818147412ed9b7 True True 0,13.7,4.8,0.6 d.Panel8 Transparent True 0,0,2.6,0.6 d.Person2LoanBand Arial,8 ee407d0eb6aa47b2aa012fb6918d72e3 Right 0,0,0,0 Text105 {Format("{0:C2}", ServiceabilityAssessmentSchema.Person2Loan.Interest/1000)} [63:63:63] 1 , 1 0 False Expression Center Transparent True 2.6,0,2.2,0.6 d.Person2LoanBand Arial,8 4bca9656524e420ebffb2d614dcf4bf9 Right 0,0,0,0 Text106 {Format("{0:C2}", ServiceabilityAssessmentSchema.Person2Loan.TotalPayment/1000)} [63:63:63] 1 , 1 0 False Expression Center _x007B_ServiceabilityAssessmentSchema.Person2Loan.Person2Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 6361d037fa9f4cbf8c82ac3d0f1f4a7a Person2LoanBand True 9cbd72ed247e4f48bc0370c759342e74 Panel8 Transparent True True 14.8,0,4.2,14.5 d.DataBand3 Transparent 0,0.4,4.2,0 d.Panel10 {ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id} f3f398ec2f8742d1be4997daebd15d6a GroupHeaderBand7 Transparent True 0,1.2,4.2,2.6 d.Panel10 Transparent True 0,1,4.2,0.6 d.DataBand11 Arial,8,Bold 3bd6a8fe0710415fa63bd8213abea3af Right 0,0,0,0 Text55 {ServiceabilityAssessmentSchema.HouseholdEntity.Person1EntityName} [63:63:63] DataColumn Center Transparent True 0,1.6,4.2,0.4 d.DataBand11 Arial,8,Bold 26cae211ac6a4c92a24ba0dd1868961e Right 0,0,0,0 Text60 {ServiceabilityAssessmentSchema.HouseholdEntity.Person1ZNumber} [63:63:63] DataColumn Center [242:242:242] True 0,2.2,4.2,0.6 d.DataBand11 Arial,8,Bold b60383fa16de4ce4979358eefd938ddd 0,0,0,0 Text61 [63:63:63] Expression Center dc39b433e0ab45aebdcd14575d407541 DataBand11 Transparent True 0,4.6,4.2,1.1 d.Panel10 Transparent True 0,0,4.2,1 d.ChildBand6 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 True 0,0.4,4.2,0.6 d.Panel11 Transparent True 0,0,4.2,0.6 d.DataBand12 _x007B_ServiceabilityAssessmentSchema.Person1Account.Value_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,8 1246095ffe554ca89df94bade1dac3f8 Right 0,0,0,0 Text62 {ServiceabilityAssessmentSchema.Person1Account.Value} [63:63:63] , 1 0 Expression Center _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_160001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_160002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_170000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_180000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ 2f78294612aa465ca6c1fb73c35cd1e9 DataBand12 0a07784b3d7447909d82aa28320d2a4f Panel11 2e42ec383043432f875f7544a1ad5431 ChildBand6 Transparent 0,6.5,4.2,2.6 d.Panel10 Transparent True 0,0,4.2,2.4 gf.ChildBand9 Transparent True 0,0.4,4.2,0.8 gf.Panel12 [242:242:242] True 0,0.2,4.2,0.6 d.DataBand9 Arial,8,Bold 195670332cf941cc927b86ecefbd4f73 0,0,0,0 Text81 [63:63:63] Expression Center DataBand17 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 True True 0,2,4.2,0.6 gf.Panel12 Transparent True 0,0,4.2,0.6 d.DataBand15 _x007B_ServiceabilityAssessmentSchema.Person1Account.Value_x003C_0_x007D_,[192:0:0],Transparent,Arial_x002C_8,True,False,,,None,TextColor Arial,8 22e860753cfa4c14915d19a36d980043 Right 0,0,0,0 Text68 {ServiceabilityAssessmentSchema.Person1Account.Value} [63:63:63] , 1 0 DataColumn Center _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220002_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_210000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_210001_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_200000_x0022__x007C__x007C_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_200001_x0022__x007D_ DataBand15 f0154768c34d4b86a510c0f8d038883d Panel12 ChildBand9 Transparent 0,9.9,4.2,0.2 d.Panel10 GroupFooterBand6 Transparent True 0,10.9,4.2,0.6 d.Panel10 [242:242:242] True 0,0,2.2,0.6 gh.GroupHeaderBand11 Arial,8,Bold dd1a94ea13844c129cadd555627398ee Right 0,0,0,0 Text113 Interest Payable [63:63:63] Expression Center [242:242:242] True 2.2,0,2,0.6 gh.GroupHeaderBand11 Arial,8,Bold e60dd5289159408b83e74cb6f1ddf5be Right 0,0,0,0 Text114 Total Payable [63:63:63] Expression Center GroupHeaderBand11 Transparent 151f7d541b82492b8eeb6e1bfb5a703a True True 0,12.3,4.2,0.6 d.Panel10 Transparent True 0,0,2.2,0.6 d.Person1LoanBand Arial,8 97143b843c7c4b828df2d384e9b9ecdc Right 0,0,0,0 Text107 {Format("{0:C2}", ServiceabilityAssessmentSchema.Person1Loan.Interest/1000)} [63:63:63] 1 , 1 0 False Expression Center Transparent True 2.2,0,2,0.6 d.Person1LoanBand Arial,8 f519a40975ba4090bacfd576d26c54d1 Right 0,0,0,0 Text108 {Format("{0:C2}", ServiceabilityAssessmentSchema.Person1Loan.TotalPayment/1000)} [63:63:63] 1 , 1 0 False Expression Center _x007B_ServiceabilityAssessmentSchema.Person1Loan.Person1Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 7b958716be214711a9032cb512e71e22 Person1LoanBand Transparent 3e9d8802cbc24184aa818147412ed9b7 0,13.7,4.2,0.6 d.Panel10 _x007B_ServiceabilityAssessmentSchema.Person2Loan.Person2Loans_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ DataBand27 True 911a29ea546147579e5c8bffa8f5342c Panel10 HouseholdBand Transparent True 0,19.9,19,20 p.Page1 Transparent True True 0,0,19,19.6 d.ChildBand11 Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,0.4,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_400002_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ Person1AssetsAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,1.2,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_400002_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ ddd1979183c5468abe37a45ddf86ee27 Person2AssetsAggregatorBand Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,2,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_410001_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 21140e07cc414b70ad34359f18681ae5 Person1LiabilitiesAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,2.8,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_410001_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 775e5c6815054af9b1462c8e7f5444df Person2LiabilitiesAggregatorBand Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,3.6,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_220000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ b7586e93ab694d27b225843b466d46e5 Person1LivingExpenseAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,4.4,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_220000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ bfea8e4fcca14e448f87157f8b92ef49 Person2LivingExpenseAggregatorBand Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,5.2,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ bb54b0d28e474acc8b4d3c39846b8644 Person1AfterTaxIncomeAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,6,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_180001_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 4c0ecbf167e948229c3a60404cc851df Person2AfterTaxIncomeAggregatorBand Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,6.8,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_170000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ 58bc7d7b56494181a694a1aa3e2622ac Person1PreTaxIncomeAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,7.6,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_170000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ ac350ffb3f864f0bb21d28057dc4c492 Person2PreTaxIncomeAggregatorBand Transparent 3abfcab26ab4443dbdfebdbe65ec1801 0,8.4,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person1Account.Alias_x003D__x003D__x0022_500000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person1Account.Person1Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ dd3a45d116634524841cabf7f6ae0273 Person1HEMAggregatorBand Transparent 79d773bdafc24976ac2b61057a21cca2 0,9.2,19,0 d.Panel17 _x007B_ServiceabilityAssessmentSchema.Person2Account.Alias_x003D__x003D__x0022_500000_x0022__x007D_ _x007B_ServiceabilityAssessmentSchema.Person2Account.Person2Accounts_Id_x003D__x003D_ServiceabilityAssessmentSchema.HouseholdEntity.HouseholdEntity_Id_x007D_ b2dcf6b03638454894299be4e4209fd5 Person2HEMAggregatorBand 1 Transparent True True 0,10,19,6.8 d.Panel17 Transparent True 0,1,10.2,0.6 d.DataBand21 Arial,8 8190716b0e924d8f96aaadd7dd2137ce 0,0,0,0 Text98 Actual Personal Surplus [63:63:63] Expression Center Transparent True 10.2,1,8.8,0.6 d.DataBand21 Arial,8 eca9445a19224e7ab09ae3d5a71b1a31 Right 0,0,0,0 Text99 {Format("{0:C2}",ServiceabilityAssessmentSchema.HouseholdEntity.ActualSurplus)} [63:63:63] 0 , 1 0 False Expression Center Transparent True 0,1.6,10.2,0.6 d.DataBand21 Arial,8 45ec98f8c8ff40249295d4f050d7f27e 0,0,0,0 Text100 Required Personal Surplus [63:63:63] Expression Center Transparent True 10.2,1.6,8.8,0.6 d.DataBand21 Arial,8 37ed70eec5b2439690c67c572f233080 Right 0,0,0,0 Text101 {Format("{0:C2}",ServiceabilityAssessmentSchema.HouseholdEntity.RequiredSurplus)} [63:63:63] 0 , 1 0 False Expression Center [242:242:242] True 0,0.2,19,0.6 d.DataBand21 Arial,8,Bold 0fea1e3fc4bc40638025bce755ae546a 0,0,0,0 Text66 Household Servicing Ratios [63:63:63] Expression Center Transparent True 0,2.2,10.2,0.6 d.DataBand21 Arial,8 32e2c73831cd473cb3ffb8eb7657fe03 0,0,0,0 Text74 ICR [63:63:63] Expression Center Transparent True 10.2,2.2,8.8,0.6 d.DataBand21 Arial,8 55cd73b1f46246918e505d013502d953 Right 0,0,0,0 Text75 {Format("{0:N2}", ServiceabilityAssessmentSchema.HouseholdEntity.ICR)}x [63:63:63] , 1 Expression Center Transparent True 0,2.8,10.2,0.6 d.DataBand21 Arial,8 2ba21bdd24c446a3996cd011bffe703b 0,0,0,0 Text76 Commitment Cover Ratio (CCR /DSC) [63:63:63] Expression Center Transparent True 10.2,2.8,8.8,0.6 d.DataBand21 Arial,8 3d9eafd44ea3459f8660d0228ea7d646 Right 0,0,0,0 Text82 {Format("{0:N2}", (decimal)ServiceabilityAssessmentSchema.HouseholdEntity.ActualSurplus/(Sum(Person1LoanBand,ServiceabilityAssessmentSchema.Person1Loan.TotalPayment)+Sum(Person2LoanBand,ServiceabilityAssessmentSchema.Person2Loan.TotalPayment))/1000)}x [63:63:63] , 1 Expression Center Transparent True 0,3.4,10.2,0.6 d.DataBand21 Arial,8 de5e9b60c11e4d4d9a308825135531b2 0,0,0,0 Text83 Living Expense / Income Ratio [63:63:63] Expression Center Transparent True 10.2,3.4,8.8,0.6 d.DataBand21 Arial,8 f9a471e73a1f4083a9cc9e7f4c419497 Right 0,0,0,0 Text84 [63:63:63] 0 , 1 0 False Expression Center Transparent True 0,4,5.6,0.6 d.DataBand21 Arial,8,Italic d0c805a2bb59407c8d438beca4d0407c Right 0,0,0,0 Text85 Net Income (WBC) [63:63:63] Expression Center Transparent True 10.2,4,8.8,0.6 d.DataBand21 Arial,8 28020aeef6f54d49838afd1b722c64b8 Right 0,0,0,0 Text86 {IIF((Sum(Person1AfterTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2AfterTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value))==0,0,(((Sum(Person1LivingExpenseAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2LivingExpenseAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)))*12/1000)/(Sum(Person1AfterTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2AfterTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)))} [63:63:63] , 0 0 % Expression Center Transparent True 0,4.6,5.6,0.6 d.DataBand21 Arial,8,Italic 55ec492b43b74e0f9af4e8c8bd15a7a9 Right 0,0,0,0 Text88 Gross Income (SBG) [63:63:63] Expression Center Transparent True 0,5.2,10.2,0.6 d.DataBand21 Arial,8 a4997e5a3b7f4685a5a2f696932ec9dc 0,0,0,0 Text102 Net Equity $'000 [63:63:63] Expression Center Transparent True 10.2,5.2,8.8,0.6 d.DataBand21 Arial,8 d2b712cac0ec41a7a262a1c7fd1c8b31 Right 0,0,0,0 Text103 {Sum(Person1AssetsAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2AssetsAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)-Sum(Person1LiabilitiesAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)-Sum(Person2LiabilitiesAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)} [63:63:63] 0 , 1 0 False Expression Center [216:216:216] 0,6.2,19,0.6 d.DataBand21 Arial,8,Bold 9f1d783411c547f5aea499ed63bcfe85 0,0,0,0 Text22 Personal Financials Comments [89:89:89] Expression Center Transparent True 10.2,4.6,8.8,0.6 d.DataBand21 Arial,8 13dc9e8ddb614e9c9e710380e1f7ee5d Right 0,0,0,0 Text8 {IIF((Sum(Person1PreTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2PreTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value))==0,0,((Sum(Person1LivingExpenseAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2LivingExpenseAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)))*12/1000/(Sum(Person1PreTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person1Account.Value)+Sum(Person2PreTaxIncomeAggregatorBand,ServiceabilityAssessmentSchema.Person2Account.Value)))} [63:63:63] , 0 0 % Expression Center False f092c5e6c34a4cad93d39c3e1cbbf88c DataBand21 1 Transparent True True 0,17.6,19,0.8 d.Panel17 True [216:216:216] True True True 0,0,19,0.8 d.DataBand20 Arial,8 True e9bcf74b56d9443d86dc3ffe38c3e408 0,0,0,0 Text28 {ServiceabilityAssessmentSchema.HouseholdEntity.Person1Comments} {ServiceabilityAssessmentSchema.HouseholdEntity.Person2Comments} [89:89:89] Wysiwyg DataColumn DataBand20 True Panel17 ChildBand11 _x007B_Count_x0028_ServiceabilityAssessmentSchema.HouseholdEntity_x0029__x003D__x003D_0_x007D_,Red,Transparent,Arial_x002C_8,False,False,,,None b3d1c033f2df4eddb98237e79b320ce5 True 1,1,1,1 Page1 31 21 A4 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 7/11/2016 5:15:52 PM 6/19/2016 8:25:46 PM f6cd300326af4a20be5173868bb1c942 Report Centimeters 2015.3.0 CSharp [242:242:242] Empty ComponentType, Placement Arial,8 Style1 Black