{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Disclaimer","Inputs","Member Calcs","Member Statement","Print Member Statement"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":16,"comments":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Disclaimer","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"flags":["formulas_cached_only"]}
[]
[]
[null,"Please Read the Disclaimer Below. "]
[null,"If you agree to the Disclaimer you will be brought to the Pension Estimator"]
[]
[null,"Disclaimer"]
[]
[null,"The data, information or results contained in, furnished by or obtained from the use of the Pension Estimator"]
[]
[null,"is for the general guide of members with respect to pension scheme benefits. No responsibility is accepted by "]
[]
[null,"or on behalf of The University of Dublin for any errors, omissions, or misleading statements obtained through "]
[]
[null,"the use of the Pension Estimator. The data, information or results obtained through the use of the Pension "]
[]
[null,"Estimator have no legal standing and, in particular, are not suitable for use in family law cases. The legislation, "]
[]
[null,"policies and terms applicable to your pension scheme will govern any entitlements to pension scheme benefits. "]
[]
[null,"The calculation provided by the Pension Estimator is based on the information provided by you. In the event of "]
[]
[null,"any error in this estimate, the legal requirements of the scheme rules will govern. At the time of retirement or should you "]
[]
[null,"require information for official purposes you should calculate the relevant pension department."]

{"sheet":"Inputs","index":1,"n_rows":103,"n_cols":26,"rows_kept":103,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"Scheme Details"]
[]
[null,"Are you paid Fortnightly or Monthly",null,"Monthly Paid",{"$nulls":13},"Weekly or monthly",{"$nulls":3},{"v":1,"d":"100%"},null,"Day","Month","Year"]
[{"$nulls":17},"Fortnightly Paid",{"$nulls":3},{"v":0.99,"d":"99%"},null,1,1,2010]
[null,"Do you pay Class A or Class D PRSI",null,"Class A",{"$nulls":13},"Monthly Paid",{"$nulls":3},{"v":0.98,"d":"98%"},null,2,2,2011]
[{"$nulls":21},{"v":0.97,"d":"97%"},null,3,3,2012]
[null,"Are you a member of the New Scheme",null,"New Entrant",{"$nulls":17},{"v":0.96,"d":"96%"},null,4,4,2013]
[{"$nulls":3},"",{"$nulls":13},"PRSI Class",{"$nulls":3},{"v":0.95,"d":"95%"},null,5,5,2014]
[null,"Personal Details",{"$nulls":15},"Class A",{"$nulls":3},{"v":0.94,"d":"94%"},null,6,6,2015]
[{"$nulls":17},"Class D",{"$nulls":3},{"v":0.93,"d":"93%"},null,7,7,2016]
[null,"Surname",null,"Doe",{"$nulls":17},{"v":0.92,"d":"92%"},null,8,8,2017]
[{"$nulls":17},"New or Old Scheme",{"$nulls":3},{"v":0.91,"d":"91%"},null,9,9,2018]
[null,"First Name",null,"John",{"$nulls":13},"New Entrant",{"$nulls":3},{"v":0.9,"d":"90%"},null,10,10,2019]
[{"$nulls":17},"Other",{"$nulls":3},{"v":0.89,"d":"89%"},null,11,11,2020]
[null,"Date of Birth",null,"1970-01-01",{"$nulls":13},"Yes/No",{"$nulls":3},{"v":0.88,"d":"88%"},null,12,12,2021]
[{"$nulls":17},"Yes",{"$nulls":3},{"v":0.87,"d":"87%"},null,13,null,2022]
[{"$nulls":21},{"v":0.85,"d":"85%"},null,14,null,2023]
[null,"Service and Salary Details",{"$nulls":19},{"v":0.84,"d":"84%"},null,15,null,2024]
[{"$nulls":21},{"v":0.83,"d":"83%"},null,16,null,2025]
[null,"Enter your service to date",null,0,"year(s)",0,"day(s)",{"$nulls":10},"Benefit Statement",{"$nulls":3},{"v":0.82,"d":"82%"},null,17,null,2026]
[{"$nulls":8},"",{"$nulls":8},"Retirement Benefits",{"$nulls":3},{"v":0.81,"d":"81%"},null,18,null,2027]
[null,"Enter Details of transferred service/added years/notional service",null,0,"year(s)",0,"day(s)",null,"",{"$nulls":8},"Preserved Benefits",{"$nulls":3},{"v":0.8,"d":"80%"},null,19,null,2028]
[{"$nulls":17},"Actuarially Reduced Retirement",{"$nulls":3},{"v":0.79,"d":"79%"},null,20,null,2029]
[null,"Enter Pensionable Remuneration",null,{"v":0,"d":"€0"},{"$nulls":13},"Death in Service Benefits",{"$nulls":3},{"v":0.78,"d":"78%"},null,21,null,2030]
[{"$nulls":21},{"v":0.77,"d":"77%"},null,22,null,2031]
[null,"Enter Future Working Pattern",null,{"v":1,"d":"100%"},{"$nulls":13},"Normal Retirement Ages",{"$nulls":3},{"v":0.76,"d":"76%"},null,23,null,2032]
[{"$nulls":17},"Non New Entrant",null,"NRA_NE",null,{"v":0.75,"d":"75%"},null,24,null,2033]
[null,"Benefit Statements",{"$nulls":15},"Retire at age 60",null,60,null,{"v":0.74,"d":"74%"},null,25,null,2034]
[{"$nulls":17},"Retire at age 61",null,61,null,{"v":0.73,"d":"73%"},null,26,null,2035]
[null,"Select one of the following benefit statements",null,"Retirement Benefits",{"$nulls":13},"Retire at age 62",null,62,null,{"v":0.72,"d":"72%"},null,27,null,2036]
[{"$nulls":17},"Retire at age 63",null,63,null,{"v":0.71,"d":"71%"},null,28,null,2037]
[null,"Choose to retire/leave on a particular date or age",null,"Age",null,"",{"$nulls":11},"Retire at age 64",null,64,null,{"v":0.7,"d":"70%"},null,29,null,2038]
[{"$nulls":17},"Retire at age 65",null,65,null,{"v":0.69,"d":"69%"},null,30,null,2039]
[null,"Retirement Age","","Retire at 30 Sept after age 65","",null,"",{"$nulls":10},"Retire at 30 Sept after age 65",null,65.74,null,{"v":0.68,"d":"68%"},null,31,null,2040]
[{"$nulls":21},{"v":0.67,"d":"67%"},{"$nulls":3},2041]
[null,"",{"$nulls":3},"",{"$nulls":11},"New Entrant",{"$nulls":3},{"v":0.66,"d":"66%"},{"$nulls":3},2042]
[null,"",{"$nulls":3},"",{"$nulls":11},"Retire at 30 Sept after age 65",null,65.74,null,{"v":0.65,"d":"65%"},{"$nulls":3},2043]
[null,"",{"$nulls":15},"Retire at age 65",null,65,null,{"v":0.64,"d":"64%"},{"$nulls":3},2044]
[{"$nulls":17},"Retire at age 66",{"$nulls":3},{"v":0.63,"d":"63%"},{"$nulls":3},2045]
[{"$nulls":17},"Retire at age 67",{"$nulls":3},{"v":0.62,"d":"62%"},{"$nulls":3},2046]
[{"$nulls":17},"Retire at age 68",{"$nulls":3},{"v":0.61,"d":"61%"},{"$nulls":3},2047]
[{"$nulls":17},"Retire at age 69",{"$nulls":3},{"v":0.6,"d":"60%"},{"$nulls":3},2048]
[{"$nulls":17},"Retire at age 70",{"$nulls":3},{"v":0.59,"d":"59%"},{"$nulls":3},2049]
[{"$nulls":21},{"v":0.58,"d":"58%"},{"$nulls":3},2050]
[{"$nulls":17},"Weekly Other",{"$nulls":3},{"v":0.57,"d":"57%"},{"$nulls":3},2051]
[{"$nulls":17},"Retire at age 65",{"$nulls":3},{"v":0.56,"d":"56%"},{"$nulls":3},2052]
[{"$nulls":17},"Retire at 30 Sept after age 65",{"$nulls":3},{"v":0.55,"d":"55%"},{"$nulls":3},2053]
[{"$nulls":21},{"v":0.54,"d":"54%"},{"$nulls":3},2054]
[{"$nulls":17},"Age/Date",null,"Date Only",null,{"v":0.53,"d":"53%"},{"$nulls":3},2055]
[{"$nulls":17},"Age",null,"Date",null,{"v":0.52,"d":"52%"},{"$nulls":3},2056]
[{"$nulls":17},"Date",{"$nulls":3},{"v":0.51,"d":"51%"},{"$nulls":3},2057]
[{"$nulls":21},{"v":0.5,"d":"50%"},{"$nulls":3},2058]
[{"$nulls":17},"Early Retirement",{"$nulls":3},{"v":0.49,"d":"49%"},{"$nulls":3},2059]
[{"$nulls":17},"Non New Entrant",{"$nulls":3},{"v":0.48,"d":"48%"},{"$nulls":3},2060]
[{"$nulls":17},"Retire at age 50",null,50,null,{"v":0.47,"d":"47%"},{"$nulls":3},2061]
[{"$nulls":17},"Retire at age 51",null,51,null,{"v":0.46,"d":"46%"},{"$nulls":3},2062]
[{"$nulls":17},"Retire at age 52",null,52,null,{"v":0.45,"d":"45%"},{"$nulls":3},2063]
[{"$nulls":17},"Retire at age 53",null,53,null,{"v":0.44,"d":"44%"},{"$nulls":3},2064]
[{"$nulls":17},"Retire at age 54",null,54,null,{"v":0.43,"d":"43%"},{"$nulls":3},2065]
[{"$nulls":17},"Retire at age 55",null,55,null,{"v":0.42,"d":"42%"},{"$nulls":3},2066]
[{"$nulls":17},"Retire at age 56",null,56,null,{"v":0.41,"d":"41%"},{"$nulls":3},2067]
[{"$nulls":17},"Retire at age 57",null,57,null,{"v":0.4,"d":"40%"},{"$nulls":3},2068]
[{"$nulls":17},"Retire at age 58",null,58,null,{"v":0.39,"d":"39%"},{"$nulls":3},2069]
[{"$nulls":17},"Retire at age 59",null,59,null,{"v":0.38,"d":"38%"},{"$nulls":3},2070]
[{"$nulls":17},"Retire at age 60",null,60,null,{"v":0.37,"d":"37%"},{"$nulls":3},2071]
[{"$nulls":21},{"v":0.36,"d":"36%"},{"$nulls":3},2072]
[{"$nulls":17},"New Entrant",{"$nulls":3},{"v":0.35,"d":"35%"},{"$nulls":3},2073]
[{"$nulls":17},"Retire at age 55",{"$nulls":3},{"v":0.34,"d":"34%"},{"$nulls":3},2074]
[{"$nulls":17},"Retire at age 56",{"$nulls":3},{"v":0.33,"d":"33%"},{"$nulls":3},2075]
[{"$nulls":17},"Retire at age 57",{"$nulls":3},{"v":0.32,"d":"32%"},{"$nulls":3},2076]
[{"$nulls":17},"Retire at age 58",{"$nulls":3},{"v":0.31,"d":"31%"},{"$nulls":3},2077]
[{"$nulls":17},"Retire at age 59",{"$nulls":3},{"v":0.3,"d":"30%"},{"$nulls":3},2078]
[{"$nulls":17},"Retire at age 60",{"$nulls":3},{"v":0.29,"d":"29%"},{"$nulls":3},2079]
[{"$nulls":17},"Retire at age 61",null,61,null,{"v":0.28,"d":"28%"},{"$nulls":3},2080]
[{"$nulls":17},"Retire at age 62",null,62,null,{"v":0.27,"d":"27%"},{"$nulls":3},2081]
[{"$nulls":17},"Retire at age 63",null,63,null,{"v":0.26,"d":"26%"}]
[{"$nulls":17},"Retire at age 64",null,64,null,{"v":0.25,"d":"25%"}]
[{"$nulls":17},"Retire at age 65",null,65,null,{"v":0.24,"d":"24%"}]
[{"$nulls":17},"Retire at 30 Sept after age 65",null,65.74,null,{"v":0.23,"d":"23%"}]
[{"$nulls":17},"Retire at age 66",null,66,null,{"v":0.22,"d":"22%"}]
[{"$nulls":17},"Retire at age 67",null,67,null,{"v":0.21,"d":"21%"}]
[{"$nulls":17},"Retire at age 68",null,68,null,{"v":0.2,"d":"20%"}]
[{"$nulls":17},"Retire at age 69",null,69,null,{"v":0.19,"d":"19%"}]
[{"$nulls":17},"Retire at age 70",null,70,null,{"v":0.18,"d":"18%"}]
[{"$nulls":21},{"v":0.17,"d":"17%"}]
[{"$nulls":21},{"v":0.16,"d":"16%"}]
[{"$nulls":19},"n/a",null,{"v":0.15,"d":"15%"}]
[{"$nulls":17},10,7,2023,null,{"v":0.14,"d":"14%"}]
[{"$nulls":21},{"v":0.13,"d":"13%"}]
[{"$nulls":21},{"v":0.12,"d":"12%"}]
[{"$nulls":21},{"v":0.11,"d":"11%"}]
[{"$nulls":21},{"v":0.1,"d":"10%"}]
[{"$nulls":21},{"v":0.09,"d":"9%"}]
[{"$nulls":21},{"v":0.08,"d":"8%"}]
[{"$nulls":21},{"v":0.07,"d":"7%"}]
[{"$nulls":21},{"v":0.06,"d":"6%"}]
[{"$nulls":21},{"v":0.05,"d":"5%"}]
[{"$nulls":21},{"v":0.04,"d":"4%"}]
[{"$nulls":21},{"v":0.03,"d":"3%"}]
[{"$nulls":21},{"v":0.02,"d":"2%"}]
[{"$nulls":21},{"v":0.01,"d":"1%"}]
[{"$nulls":21},{"v":0,"d":"0%"}]

{"sheet":"Member Calcs","index":2,"n_rows":47,"n_cols":55,"rows_kept":47,"hidden":true,"flags":["formulas_cached_only"]}
[{"$nulls":4},"2023-07-10"]
[]
[{"$nulls":3},{"v":13843.35,"d":"13,843.35"},"State Pension",{"v":13843.35,"d":"13,843.35"},null,"2035-09-30",null,"Normal Retirement Date",{"$nulls":37},"State",13843.35]
[null,null,"2023-01-01",{"v":13843.35,"d":"13,843.35"},{"$nulls":3},"2035-09-30",null,"For Preserved"]
[{"$nulls":16},"Include added yrs",null,null,"no",{"$nulls":11},"Accrued","Accrued","Potential","Potential",null,"Accrued","Potential",{"$nulls":4},"Potential","Potential"]
[{"$nulls":31},"200ths accrual","80ths accrual","200ths accrual","80ths accrual",null,"3/80ths accrual","3/80ths accrual",null,null,12.22,null,"200ths accrual","80ths accrual",null,"4 or more",null,null,"Reduction Factor","Reduction Factor"]
["First Name","Surname","PRSI Class","New or Non-New Entrant","DOB","Age","Retirement Age","NRD","Minimum NRD","Age at NRD",null,"FTE Salary","Pensionable Allowance","FT Equiv Pensionable Remuneration","Future Part Time %","Accrued Service","Accrued service with added yrs","Transferred in Service","Transferred in Service Earned","Accrued Service incl Transfer In","Future Service (capped)","Future Service (capped) - NRA 65","Future Service with added yrs","Future Service with added yrs","Future Service","Future Service 65","Potential Service","Potential Service - NRA 65",null,"3 1/3rd State",null,"Pension","Pension","Pension","Pension",null,"Gratuity","Gratuity",null,null,"Additional Service for DIS/Ill-health","Death Gratuity","Prospective Pension 65","Prospective Pension 65","DIS Spouses Pension","Childrens Max Pension",null,"80ths Pension","200ths Pension","Lump Sum",null,"Spouses DIR Pension","Childrens Max DIR Pension",null,"Fortnightly / Monthly"]
[]
["Doe","John","Class A","New Entrant","1970-01-01",{"v":53.52,"d":"53.520"},{"v":65.74,"d":"65.740"},"2035-09-30","2035-01-01",65.744,null,0,0,0,{"v":1,"d":"100.00%"},{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},12.224,11.48,{"v":16.3,"d":"16.30"},15.31,12.224,11.48,12.224,11.48,null,{"v":46144.5,"d":"46,144.50"},null,0,0,0,0,null,0,0,null,null,7.78,0,0,0,0,0,null,0,0,0,null,0,0,null,"Monthly Paid"]
[{"$nulls":7},65.79,{"$nulls":10},"HSE site does not abate TV service",{"$nulls":12},0,0,{"$nulls":8},7.78]
[{"$nulls":7},{"v":65,"d":"65.00"},9,{"$nulls":9},0,{"$nulls":7},{"v":12,"d":"12.00"},{"$nulls":7},0,{"$nulls":12},{"v":65,"d":"65.00"},{"v":1,"d":"1.000"},{"v":1,"d":"1.000"}]
[{"$nulls":7},65.79,null,null,"Deferred - Over min NRA",{"$nulls":3},"Early Retirement",{"$nulls":11},0.22,{"$nulls":17},11.48,null,null,{"v":66,"d":"66.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":5},"Below Minimum Normal",null,1,0,null,0,1,1,null,0,1,1,{"$nulls":30},65.74,{"v":0.26,"d":"0.260"},{"v":0.26,"d":"0.260"}]
[{"$nulls":5},"Below Minimum Early Ret",null,0,0,{"$nulls":11},12.224,{"$nulls":5},12.224,"Calendar Future",{"$nulls":20},{"v":26,"d":"26.000"},{"v":26,"d":"26.000"}]
[{"$nulls":48},0]
[{"$nulls":48},0,{"$nulls":4},0]
[]
[]
[]
[]
[null,"Day Start","Month Start","Year Start","Date",null,"Day end","Month End","Year End","Date",null,"PT Perc",null,"Service"]
["Service 1",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0,"",null,null,{"$error":"#DIV/0!"}]
["Service 2",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
["Service 3",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
["Service 4",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
["Service 5",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
["Service 6",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
["Service 7",{"$nulls":3},"NA",{"$nulls":4},"NA",{"$nulls":3},{"v":0,"d":"0.00"},null,0,0]
[{"$nulls":15},""]
[{"$nulls":13},{"v":0,"d":"0.00"},null,""]
[{"$nulls":13},{"v":0,"d":"0.00"},0]
[]
[]
[]
[{"$nulls":3},"Non New Entrant",{"$nulls":3},"New Entrant"]
[{"$nulls":3},"Pension","Lump Sum",null,null,"Pension","Lump Sum"]
[null,null,50,{"v":0.624,"d":"62.4%"},{"v":0.822,"d":"82.2%"},null,55,{"v":0.582,"d":"58.2%"},{"v":0.824,"d":"82.4%"}]
[null,null,51,{"v":0.651,"d":"65.1%"},{"v":0.839,"d":"83.9%"},null,56,{"v":0.611,"d":"61.1%"},{"v":0.84,"d":"84.0%"}]
[null,null,52,{"v":0.679,"d":"67.9%"},{"v":0.855,"d":"85.5%"},null,57,{"v":0.641,"d":"64.1%"},{"v":0.856,"d":"85.6%"}]
[null,null,53,{"v":0.71,"d":"71.0%"},{"v":0.872,"d":"87.2%"},null,58,{"v":0.674,"d":"67.4%"},{"v":0.873,"d":"87.3%"}]
[null,null,54,{"v":0.743,"d":"74.3%"},{"v":0.889,"d":"88.9%"},null,59,{"v":0.71,"d":"71.0%"},{"v":0.89,"d":"89.0%"}]
[null,null,55,{"v":0.778,"d":"77.8%"},{"v":0.907,"d":"90.7%"},null,60,{"v":0.748,"d":"74.8%"},{"v":0.907,"d":"90.7%"}]
[null,null,56,{"v":0.816,"d":"81.6%"},{"v":0.924,"d":"92.4%"},null,61,{"v":0.79,"d":"79.0%"},{"v":0.925,"d":"92.5%"}]
[null,null,57,{"v":0.857,"d":"85.7%"},{"v":0.943,"d":"94.3%"},null,62,{"v":0.836,"d":"83.6%"},{"v":0.943,"d":"94.3%"}]
[null,null,58,{"v":0.901,"d":"90.1%"},{"v":0.961,"d":"96.1%"},null,63,{"v":0.885,"d":"88.5%"},{"v":0.961,"d":"96.1%"}]
[null,null,59,{"v":0.948,"d":"94.8%"},{"v":0.98,"d":"98.0%"},null,64,{"v":0.94,"d":"94.0%"},{"v":0.98,"d":"98.0%"}]
[null,null,60,{"v":1,"d":"100%"},{"v":1,"d":"100%"},null,65,{"v":1,"d":"100%"},{"v":1,"d":"100%"}]

{"sheet":"Member Statement","index":3,"n_rows":120,"n_cols":11,"rows_kept":120,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"                                                 University of Dublin Trinity College Model Pension Scheme (\"the Scheme\")"]
[null,"                                                               and Allied Spouse's, Civil Partner's, and Children’s Pension Scheme"]
[]
[null,"Illustration of Potential Retirement Benefits"]
[]
[null,"Name:","John Doe"]
[]
[null,"Date of Birth:","1970-01-01"]
[]
[null,"Normal Retirement Date:","2035-09-30"]
[]
[null,"PRSI Class","Class A"]
[]
[null,"New Entrant / Other :","New Entrant"]
[]
[null,"Anticipated Retirement Date","2035-09-30"]
[]
[null,"Pensionable Service Completed"]
[null,"from Date of Joining Scheme to date:","0 year(s)"]
[]
[null,"Future Pensionable Service"]
[null,"to Date of Retirement (Age 65 and 9 Months)","12.224 year(s)"]
[]
[null,"Transferred In Service / Additional Years:","0 year(s)"]
[]
[null,"Total Potential Service to Retirement Date ","12.224 year(s)"]
[]
[null,"Pensionable Remuneration for illustration purposes:",{"v":0,"d":"€0"}]
[]
[null,"Current Annual State Contributory Pension (SCP) p.a.:",{"v":13843,"d":"€13,843"}]
[null,"3.333333 x SCP:",{"v":46145,"d":"€46,145"}]
[]
[]
[null,"Calculation of Illustrative Retirement Benefits payable from 30/09/2035 based on the information above"]
[]
[null,"Once-off Tax Free Retirement Gratuity",""]
[]
[null,"3/80 * 12.224 years * €0",{"v":0,"d":"€0"}]
[null,""]
[null,"Co-ordinated Scheme Pension"]
[]
[null,"1/200 * 12.224 years * €0",{"v":0,"d":"€0"}]
[null,"Plus"]
[null,"1/80 * 12.224 years * €0",{"v":0,"d":"€0"}]
[]
[null,"Total Scheme Pension","€0 per annum"]
[]
[]
[]
[]
[null,"Spouses and Childrens Benefits on Death after Retirement based on the information above"]
[]
[null,"If you are a member of the Spouse and Children's Scheme and should you predecease your "]
[null,"spouse after your retirement, your spouse would receive a pension of ","€0 per annum"]
[]
[]
[null,"Pensions are payable in respect of children up to a maximum of","€0 per annum"]
[null,"(in respect of three or more children)"]
[]
[]
[null,"Your pension under the Scheme payable is in addition to any entitlement to the State Contributory Pension that"]
[null,"may be payable separately by the Department of Social Protection – currently €13,843 per annum (full rate)."]
[null,"Members should contact the Department of Social Protection to ascertain eligibility for benefits "]
[null,"under Social Welfare Acts (www.welfare.ie or LoCall 1890 500 000)"]
[]
[null,"IMPORTANT:  PLEASE SEE SUPPLEMENTAL INFORMATION OVERLEAF"]
[]
[null,"Date Prepared 10/07/2023"]
[]
[null,"Page 1 of 2"]
[]
[]
[]
[null,"                                                 University of Dublin Trinity College Model Pension Scheme (\"the Scheme\")",{"$nulls":8},"E & OE"]
[null,"                                                               and Allied Spouse's, Civil Partner's, and Children’s Pension Scheme"]
[]
[null,"Benefit Statement Notes"]
[]
[null,"1. This Statement should be read in conjunction with the Member Explanatory Leaflet"]
[]
[null,"2. This statement is for illustrative purposes only and is not legally binding.  It assumes that all contributions due"]
[null,"    have been paid. Your final retirement benefits will be subject to formal approval at retirement.  "]
[null,"    The Scheme Rules will take precedence in the event of any dispute.  "]
[]
[null,"3. Member benefits may be subject to revision in the event that a Pension Adjustment Order is granted pursuant to Family Law "]
[null,"    Act proceedings"]
[]
[null,"4. Please apply in writing for your retirement benefits at least three months prior to your proposed retirement. "]
[null,"    All pensions are payable in equal monthly instalments in arrears"]
[]
[null,"5. Increases in preserved benefits and pensions in payment are not guaranteed although it has been the practice in the"]
[null,"    University to increase pensions in line with salary increases awarded to serving staff.  Any increases in such benefits "]
[null,"    under this Scheme will be as authorised from time to time by the Higher Education Authority with the consent of "]
[null,"    the Minister for Education and Skills and the Minister for Public Expenditure & Reform."]
[]
[null,"6. Under the terms of the  Scheme, a Supplementary Pension may be payable by the College in the event that a "]
[null,"   member does not qualify for a State Contributory Pension or other Social Welfare benefits through no fault of their own.  This "]
[null,"   Supplementary Pension would be the difference between co-ordinated pension and a pension as if it had been calculated on a "]
[null,"   non-coordinated basis less any other Social Welfare benefits payable.  Further details may be obtained by contacting "]
[null,"   the Pensions Section."]
[]
[null,"7. Should you cease employment prior to Normal Retirement Age and should your new employer be a Public Sector body deemed "]
[null,"    to be an Approved Organisation under the terms of the Superannuation and Pensions Act 1963, and subject to the agreement "]
[null,"    between the organisation concerned, it is possible that your Pensionable Service under this Scheme to date of leaving service "]
[null,"    may transfer to your new employer’s Pension Scheme.   If you wish to initiate a transfer of service to such an Approved "]
[null,"    Organisation, you should contact the Pensions Officer of your new employer in the first instance."]
[]
[null,"8. Please note that any retirement taken before your contractual retirement date is deemed to be an early retirement. Please"]
[null,"    refer to the HR website for details regarding this process and the approval needed, or alternatively contact the Pensions Office."]
[]
[]
[]
[]
[null,"Page 2 of 2"]
[]
[]
[null,"Date Prepared 10/07/2023"]
[]
[{"$nulls":10},"E & OE"]

{"sheet":"Print Member Statement","index":4,"n_rows":118,"n_cols":3,"rows_kept":118,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"                                                 University of Dublin Trinity College Model Pension Scheme (\"the Scheme\")"]
[null,"                                                               and Allied Spouse's, Civil Partner's, and Children’s Pension Scheme"]
[]
[null,"Illustration of Potential Retirement Benefits"]
[]
[null,"Name:","John Doe"]
[]
[null,"Date of Birth:","1970-01-01"]
[]
[null,"Normal Retirement Date:","2035-09-30"]
[]
[null,"PRSI Class","Class A"]
[]
[null,"New Entrant / Other :","New Entrant"]
[]
[null,"Anticipated Retirement Date","2035-09-30"]
[]
[null,"Pensionable Service Completed"]
[null,"from Date of Joining Scheme to date:","0 year(s)"]
[]
[null,"Future Pensionable Service"]
[null,"to Date of Retirement (Age 65 and 9 Months)","12.224 year(s)"]
[]
[null,"Transferred In Service / Additional Years:","0 year(s)"]
[]
[null,"Total Potential Service to Retirement Date ","12.224 year(s)"]
[]
[null,"Pensionable Remuneration for illustration purposes:",{"v":0,"d":"€0"}]
[]
[null,"Current Annual State Contributory Pension (SCP) p.a.:",{"v":13843,"d":"€13,843"}]
[null,"3.333333 x SCP:",{"v":46145,"d":"€46,145"}]
[]
[]
[null,"Calculation of Illustrative Retirement Benefits payable from 30/09/2035 based on the information above"]
[]
[null,"Once-off Tax Free Retirement Gratuity",""]
[]
[null,"3/80 * 12.224 years * €0",{"v":0,"d":"€0"}]
[null,""]
[null,"Co-ordinated Scheme Pension"]
[]
[null,"1/200 * 12.224 years * €0",{"v":0,"d":"€0"}]
[null,"Plus"]
[null,"1/80 * 12.224 years * €0",{"v":0,"d":"€0"}]
[]
[null,"Total Scheme Pension","€0 per annum"]
[]
[]
[]
[]
[null,"Spouses and Childrens Benefits on Death after Retirement based on the information above"]
[]
[null,"If you are a member of the Spouse and Children's Scheme and should you predecease your "]
[null,"spouse after your retirement, your spouse would receive a pension of ","€0 per annum"]
[]
[]
[null,"Pensions are payable in respect of children up to a maximum of","€0 per annum"]
[null,"(in respect of three or more children)"]
[]
[]
[null,"Your pension under the Scheme payable is in addition to any entitlement to the State Contributory Pension that"]
[null,"may be payable separately by the Department of Social Protection – currently €13,843 per annum (full rate)."]
[null,"Members should contact the Department of Social Protection to ascertain eligibility for benefits "]
[null,"under Social Welfare Acts (www.welfare.ie or LoCall 1890 500 000)"]
[]
[null,"IMPORTANT:  PLEASE SEE SUPPLEMENTAL INFORMATION OVERLEAF"]
[]
[null,"Date Prepared 10/07/2023"]
[]
[null,"Page 1 of 2"]
[]
[]
[]
[null,"                                                 University of Dublin Trinity College Model Pension Scheme (\"the Scheme\")"]
[null,"                                                               and Allied Spouse's, Civil Partner's, and Children’s Pension Scheme"]
[]
[null,"Benefit Statement Notes"]
[]
[null,"1. This Statement should be read in conjunction with the Member Explanatory Leaflet"]
[]
[null,"2. This statement is for illustrative purposes only and is not legally binding.  It assumes that all contributions due"]
[null,"    have been paid. Your final retirement benefits will be subject to formal approval at retirement.  "]
[null,"    The Scheme Rules will take precedence in the event of any dispute.  "]
[]
[null,"3. Member benefits may be subject to revision in the event that a Pension Adjustment Order is granted pursuant to Family Law "]
[null,"    Act proceedings"]
[]
[null,"4. Please apply in writing for your retirement benefits at least three months prior to your proposed retirement. "]
[null,"    All pensions are payable in equal monthly instalments in arrears"]
[]
[null,"5. Increases in preserved benefits and pensions in payment are not guaranteed although it has been the practice in the"]
[null,"    University to increase pensions in line with salary increases awarded to serving staff.  Any increases in such benefits "]
[null,"    under this Scheme will be as authorised from time to time by the Higher Education Authority with the consent of "]
[null,"    the Minister for Education and Skills and the Minister for Public Expenditure & Reform."]
[]
[null,"6. Under the terms of the  Scheme, a Supplementary Pension may be payable by the College in the event that a "]
[null,"   member does not qualify for a State Contributory Pension or other Social Welfare benefits through no fault of their own.  This "]
[null,"   Supplementary Pension would be the difference between co-ordinated pension and a pension as if it had been calculated on a "]
[null,"   non-coordinated basis less any other Social Welfare benefits payable.  Further details may be obtained by contacting "]
[null,"   the Pensions Section."]
[]
[null,"7. Should you cease employment prior to Normal Retirement Age and should your new employer be a Public Sector body deemed "]
[null,"    to be an Approved Organisation under the terms of the Superannuation and Pensions Act 1963, and subject to the agreement "]
[null,"    between the organisation concerned, it is possible that your Pensionable Service under this Scheme to date of leaving service "]
[null,"    may transfer to your new employer’s Pension Scheme.   If you wish to initiate a transfer of service to such an Approved "]
[null,"    Organisation, you should contact the Pensions Officer of your new employer in the first instance."]
[]
[null,"8. Please note that any retirement taken before your contractual retirement date is deemed to be an early retirement. Please"]
[null,"    refer to the HR website for details regarding this process and the approval needed, or alternatively contact the Pensions Office."]
[]
[]
[]
[]
[null,"Page 2 of 2"]
[]
[]
[null,"Date Prepared 10/07/2023"]