ࡱ> 5764  !"#$%&'()*+,-./23Root Entry F@g^1WorkbookZSummaryInformation(DocumentSummaryInformation8, \pgegan Ba==8<.8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Arial1Calibri1Calibri1 Calibri1Calibri""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- 0.0000.0                                                                      ff + ) , *     P  P        `            a>    "   "    " !      " ||H'`P}-}; _-;_-* "}A}1 _-;_-* "-@_- }A}2 _-;_-* "?-@_- }A}3 _-;_-* "23-@_- }-}4 _-;_-* "}A}0 a_-;_-* "-@_- }A}( _-;_-* "-@_- }A}7 e_-;_-* "-@_- }}5 ??v_-;_-* "̙-@_-    }}9 ???_-;_-* "-@_- ??? ??? ??? ???}}) }_-;_-* "-@_-    }A}6 }_-;_-* "-@_- }}* _-;_-* "-@_- ??? ??? ??? ???}-}= _-;_-* "}x}8_-;_-* "-@_??? ??? ???}-}/ _-;_-* "}U}< _-;_-* "-@_ }A}" _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}# _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}$ _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}% _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A} _-;_-* "23-@_}A}& _-;_-* "-@_}A} _-;_-* "ef-@_}A} _-;_-* "L-@_}A}  _-;_-* "23-@_}A}' _-;_-* " -@_}A} _-;_-* "ef -@_}A} _-;_-* "L -@_}A}! _-;_-* "23 -@_ 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L湸 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ٗ % 60% - Accent3M( 60% - Accent3 23֚ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16` 0 CRB examples D FS examples,V`8Data summary of worked examples for final salary members9Final Salary Members - 20 year examples - no career break USS pension TPS pension6TPS pension reduced by additional member contributionsHTPS pension reduced by additional member contributions accumulated at 3%HTPS pension reduced by additional member contributions accumulated at 6%DFinal Salary Members - 20 year examples - career break after 5 yearsEFinal Salary Members - 20 year examples - career break after 10 years9Final Salary Members - 10 year examples - no career breakDFinal Salary Members - 10 year examples - career break after 5 yearsEFinal Salary Members - 10 year examples - career break after 10 years/Data summary of worked examples for CRB membersCRB Members - no career break1a1b2a2b3a3b4a4b5a5b&Amount attributed to change in accrual:Amount attributed to change in active revaluation and LRFsCRB Members - no career breaks(CRB Members - career break after 5 years+Short Service CRB Members - no career break+Short Service CRB members - no career break"=+ ,U.$}.LccB  '%1CAC  dMbP?_*+%&?'?(?)?"B??d &U} D}  '  8                           > @ A A A A A A A A  A  A Gmy@GXR@G,@GT=h2@G@FD@GS"|i@Gg@G/9K@ GC@ G@ G+ U@Ge@G* >ڬ@GkP՚@G0mV@G0R_d/@G ɳA@GLV@ G3.@ GX8x@ GcR@G3B|@G@kkOKի@GY@GPhw@Gp-Q(@Ge8h$@GP@ GpTZ@ GȨa7b@ G/@Glu@GLt@GD>@GSit1@Gο@GHG@Gc@ Gqo@ G@kK@ @ A A A A A A A A A A  Gmy@ GXR@ G,@ GT=h2@ G@FD@ GS"|i@ Gg@ G/9K@ GC@ G@ D G/@ Glu@ GLt@ GD>@ GSit1@ Gο@ GHG@ Gc@ Gqo@ G@kK@ E Ge>@ GB s@ G5@ G=nF@ G:@%@ G2r^J@ GLv@ Gx Ѫ@ G@ Gy@ EGz3@G@GV~@GQw@Gv0 vy@GH@G`@Gxk@ G+Ę@ G=`Nk@ EGl@G)u @Gە@Gfv@G?@G2XL @G @G/"@ GljǷ@ Gç@ @ A A A A A A A A  A  A G\S@GO@C@G:Ф]@G<ߕeg}@G}x@Gy۲@G{uo@G0j5@ G-@ Ga$@ DGz8@G}{@G@GԹ@G(<@G@n@GԊR@G*.|Ə@ Gt<@ GōY@ EGZ9@G.V@G=it@Gtj3@G33A@Gb}@GBU@G ;ȗQ@ G1g|ބ@ G(s B2Y@ EGviAZ@G3@}@GcDٴ@GMm@GP |@G6@Gp bs@G)@ G/@ G(I,@ EGcݐ@G4¶@G2=,[@Gadz@G>Xn@GZVc@GI @m@GlD@ GSg@ Gx֯ @ @A?A@A@AAAAAAA G ץK@GV+@G$H UP@ GnN@G35@G+b@ Gw@@G?@Gr?@ Gxb@G&F@G@:4DDD !"#$%& @!A?A@A@ ""G ץK@"GV+@"G$H UP@ #D#Gxb@#G&F@#G@ $E$GigT@$G>±@$Gft@ %E%G5@%GnV@%G-PY[@ &E&G O{@~ &GA&GX^@xDDDD>@^Z $$$7ggD  1%ERZ  dMbP?_*+%&?'?(?)?"??&U} UF}  ?}  q 1  8    ?        ?       ?          > @$A?A@A@A@A@BBBBBB CK7@CcX9T6@C7A`@C\K@Cw@BBBBBB DCæ@Cm=-@C:{@CS0@CH$@AAAAAA ECNI@Crl@CQPQ/@CoSJ@C B@FFFFFF EC1&,'@CU!6j@CEf@C2Q~@CSʘ@FFFFFF ECW0,4@C=?@CZ*G@CY@CY]@@FFFFFF  EGGGGGFFFFFF @$ A?A@A@A@A@ BBBBBB  C-;@ C@ C.@ CR@ C4FC<@ BBBBBB D C=a@ C߿kg@ CC՗N@ C>@ CT"@ AAAAAA ECۭ?G<@C9teZ@Ca<(I@C@C2t*G@FFFFFF ECm-_@C  8@Cp @CU .;X@CF@FFFFFF ECj#U@C@C2@C9KF@Cʹ;g@FFFFFF @$A?A@A@A@A@BBBBBB C-;@C@C.@CR@C4FC<@BBBBBB DC=a@C߿kg@CC՗N@C>@CT"@AAAAAA EC2<@CNsZ@C}of@C^e@C'&|@FFFFFF EC@C j-8@Cj@CTQuX@Cd[o@FFFFFF ECʶ@CΙtr@C[ @Cu\a=@CϨ|߬@FFFFFF @ GGGGGFFFFFF E$A?A@A@A@A@FFFFFF CW@Cl@CFgc @Cg2l@C.q^b@FFFFFF DC@C1@C\ !@CF@CǍ8@FFFFFF ECx@C&x &@Cme@CG6?@CBA@FFFFFF ECKq@C@]@C9Wq̲@C\Y@C!6@FFFFFF >( 0>~~~~~">~~~~~>~~~~~.H~~~ " # $ % & ' ( * + , - . / 0 E C=J@ C b@ CPTo@ C}ѣ@ Cd@.C7@.FFFFFF /E/C'|2@/CT-2@/CAJ@/Ch@/CAX܋@/FFFFFF 0E0CL)@0C@0C֖I @0COʒ@0C~+j@"@h.H~~~~h.H~~~~>@jj 7ggD  Oh+'0@H\l  Vicky WoodsgeganMicrosoft Excel@#@-5u3՜.+,D՜.+,< PX  $Mercer Human Resource Consulting  CRB examples FS examples  Worksheets X%-My MPR_PEERREVIEW MPR_DocID_AdHocReviewCycleID_NewReviewCycle_EmailSubject _AuthorEmail_AuthorEmailDisplayName _ReviewingToolsShownOncePeer Review Identifier$85F0FF6274B347DC9BE0A3CBFF1C62E6@qProgramme GroupEdwin.S.Topper@mercer.comTopper, Edwin S F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89qCompObjrRoot Entry Fi8WorkbookZSummaryInformation(DocumentSummaryInformation8  !"#$%&'()*+,-./493 Oh+'0@H\l  Vicky WoodsgeganMicrosoft Excel@#@-5u3՜.+,D՜.+,< PX  $Mercer Human Resource Consulting  CRB examples FS examples  Worksheets`0(TMPR_PEERREVIEW MPR_DocID_AdHocReviewCycleID_NewReviewCycle_EmailSubject _AuthorEmail_AuthorEmailDisplayName _ReviewingToolsShownOncePeer Review Identifier$85F0FF6274B347DC9BE0A3CBFF1C62E6347DC9BE0A3CBFF1C62E6@qProgramme GroupEdwin.S.Topper@mercer.c