ࡱ> GDEF \psmitatheoore B Annual Budget Enter Q1,Q2 Enter Q3,Q4 __IntlFixup3__IntlFixupTable;1 ChangeFont9<+%Data1:%Data1:&Data10<&Data11<&Data12:&Data12:&Data13:&Data13:&Data14:&Data14:&Data15:&Data15:&Data16:&Data16:&Data17:&Data17:&Data18:&Data18:&Data19<%Data2:&Data20<&Data21<&Data22<&Data23<&Data24<&Data25<&Data26<&Data27<&Data28<&Data29<%Data3< &Data30<&Data31<&Data32<&Data33<&Data34< &Data35<!!!&Data36<"""&Data37<###&Data38<$$$&Data39<%%%%Data4< &Data40<&&&&Data41<'''&Data42<(((&Data43<)))&Data44<***&Data45<+++&Data46<,,,&Data47<---&Data48<...&Data49<///%Data5< &Data50<000&Data51:&Data52:&Data52:&Data53:&Data53:&Data54:&Data54:&Data55:&Data55:&Data56:&Data56:&Data57:&Data57:&Data58:&Data58:&Data59:&Data59: %Data6< &Data60: &Data60:!&Data61:!&Data61:"&Data62:"&Data62:#&Data63:#&Data63:$&Data64:$&Data64:%&Data65:%&Data65:&&Data66:&&Data66:'&Data67:'&Data67:(&Data68:(&Data68:)&Data69:)&Data69:*%Data7<&Data70<&&&&Data71<'''&Data72<(((&Data73<)))&Data74<***&Data75<+++&Data76<,,,&Data77<---&Data78<...&Data79<///%Data8<&Data80<000&Data81<...&Data82<///&Data83<000&Data84:0&Data85:0%Data9<1display_area_2;<1display_area_2;93hmmToolsHeadline;3hmmToolsHeadline;1 InsertLogo9w4P0 LockSheet9xP)months;&NumMos:$ ;:$ ;6$ ;6* StartMonth: ) ThisMonth: 3 Village_But19pT3 Village_But29T3 Village_But39,@=x<$8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Times New Roman1hTimes New Roman1Times New Roman1Times New Roman1Times New Roman1Arial1Arial1 Arial1Arial1Times New Roman1Arial1 Times New Roman1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0_);8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)74_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_);;; dd\-mmm\-yy_) General_) mm/dd/yy_) 0.00_) mm/dd/yyGeneral;[Red]\-General dd\-mmm\-yy dd\-mmmmm/yy;;0.0%"$"#,##0.0_);\("$"#,##0.0\)#,##0\ "DM";\-#,##0\ "DM"!#,##0\ "DM";[Red]\-#,##0\ "DM""#,##0.00\ "DM";\-#,##0.00\ "DM"'$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM"<9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_-<9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-DA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-DA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-"CHF"\ #,##0;"CHF"\ \-#,##0# "CHF"\ #,##0;[Red]"CHF"\ \-#,##0$!"CHF"\ #,##0.00;"CHF"\ \-#,##0.00)&"CHF"\ #,##0.00;[Red]"CHF"\ \-#,##0.00A>_ "CHF"\ * #,##0_ ;_ "CHF"\ * \-#,##0_ ;_ "CHF"\ * "-"_ ;_ @_ ,)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ IF_ "CHF"\ * #,##0.00_ ;_ "CHF"\ * \-#,##0.00_ ;_ "CHF"\ * "-"??_ ;_ @_ 41_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ A>_("CHF"* #,##0.0_);_("CHF"* \(#,##0.0\);_("CHF"* "-"??_);_(@_)=:_("CHF"* #,##0_);_("CHF"* \(#,##0\);_("CHF"* "-"??_);_(@_)#,##0.00\ "DM"#,##0.00\ _D_M""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00!""#,##0.00;[Red]\-""#,##0.0030_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-*'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-2/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- ""\ #,##0.00%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\1%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\2%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\3%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\4%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\5%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\6%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\7%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\8%""CHF"\ #,##0.00;\-"CHF"\ #,##0.0\9%""CHF"\ #,##0.00;\-"CHF"\ #,##0.\10&#"CHF"\ #,##0.00;\-"CHF"\ #,##0.\1\1&#"CHF"\ #,##0.00;\-"CHF"\ #,##0.\1\2&##,##0.00_ "DM"\);\(#,##0.00\ "DM"\)$!#,##0.00_ "DM";\(#,##0.00\ "DM"\)&#"CHF"\ #,##0.00_;\("CHF"\ ###0.00\)%""CHF"\ #,##0.00;\("CHF"\ ###0.00\)&#"CHF"\ #,##0.00;\("CHF"\ #,##0.00\)'$"CHF"\ #,##0.00_ ;\("CHF"\ ###0.00\)&##,##0.00_ "CHF";\(#,##0.00\ "CHF"\)&##,##0.00\ "CHF";\(#,##0.00\ "CHF"\)(%"SFr."\ #,##0.00;\("SFr."\ #,##0.00\) "$"#,##0.00mmmm\ d\,\ yyyymmm#,##0.0_);[Red]\(#,##0.0\)m/dyyyy :                : + )   , *          :   :  :  :  :  :  : :  :  :  : : :  :  :  :       :  :  :   :   :  :    :  :   :       ( :  : ( (&  (&  (! (# (" @( (& (& 1! @( @(  ! @(" (! ( (* ( ("  (  (! (! (A (A# (# (! (! @( @(# (&| (# ( : ( | (&| (&t (#| ( | (!| & @& A (: (| (| @(| @ ("| @("| @ ( | ( | ("| @@("| @@  ( | (A | (A#| (& @(#| (# (&  @(& A (* @(* @ (# @! @ (# A@(# A@ (" A@(" A@ (" A@  # y@  # @  # @  # Ax@  # Ay@  # x@  # @  # A@  # x@  # AI@ (! A("| A(! A( | A!| A& | A("| I@ ("| H@ ("| AH@ ("| AH@ (&|  @(&| A (| @(| @ ("| A@("| A@  # A @ # AA  #x AI@ ( (& ( (" (  (A# ( &( &( & (& A&(# A&(# A&( -,( ,( E- ( (( @  ( ( (& ((& @ (& @ ( @ (" @ (A# @ ( A-&(& AE' ( A-(( A-( A-@ (&| &(&t &(&| &(&| & ( | (&| ( | (| (| ( | ("| ( | ( |  (A | ( | (#| (A#| ( | &( | &( | & ( | A&( | -,( | ,(| E- ( | ((| @  (| ( (&| ((| (( | A-&(| AE' (&| (( | A-(( | A-(| A-@ ( # I@ # Ɂ@ # y@ # # O@ # ρ@ # @ # ǁ # O@ # ρ@ # @ # ǁ # AH@ # A@ # Ax@ # A A# # # O@ # AɁ@ # A # Ay@ # H@ # @ # x@ #  # x@ #  @# O@ A# ǁ A# @ # AI@ # H@ # O@ A# ǁ A# @ # ρ@ # @ # ǁ # @O@ # Aρ@ # A@ # Aǁ # H@ # @ # x@ #  &#| I@ &#| A &# ρ@ &# y@ &# Ɂ@ &#| Ɂ@ &#| y@ &#| O@ &#| G &# @ &#| ρ@ &#| @ &#| O@ &#| G &# ρ@ &# @ &#| ρ@ &#| @ &#| AH@ &#| A@ &#| A@ &#| Ax@ &A#| &"| &#| &#| AI@ &#| AA &#| A &#| Ay@ &# x@ &#| @ &#| x@ &#| ǁ &@# @ &A# ǁ &A# @ &#| O@ &#| G &# ρ@ &@# @ &A# ǁ &A# @ &#| H@ &#| @ &# @ &# @ &#| ρ@ &#| @ &# I@ &# A &# &# y@ &# AH@ &# A@ &# A@ &A &# &" & &A# AI@ &A# A @&A# AA &A#| AI@ 1! @! A ( (& @(| @  (| '(| '(&t '&(&| '&(&| '&  (| '(| ' (| @(| (| ( ( (  ( ' ( ' ( '  (& & (& &(& &(& &  (& (&  ( ' (! '( '( '  (| '&(t '&(| '&(| '& ( @ ( @ (! @ Comma [0]_Int. Data TableComma_Int. Data TableCurrency [0]_Int. Data TableCurrency_Int. Data Table'$Dezimal [0]_Compiling Utility MacrosDezimal [0]_FixerSetupDlg"Dezimal [0]_TemplateInformation# Dezimal_Compiling Utility MacrosDezimal_FixerSetupDlgDezimal_TemplateInformationNormal_ChgLoan Normal_Code Normal_Customize Your Invoice!Normal_Int. Data Table"Normal_Int. Data Table_1# Normal_Lock$ Normal_Macros%Normal_Macros_1&Normal_Macros_2'Normal_Maint_1(Normal_Maint_1_1)Normal_Maint_1_2*Normal_Maint_2+Normal_Maint_2_1,Normal_Maint_2_2-Normal_Maint_2_Macros.Normal_Maint_2_Maint_1/Normal_Specifics0 Normal_VDlg1Normal_VDlg (2)2 Normal_VDlg_13 Normal_VDlg_24 Normal_VDlg_3%5"Normal_VDlg_Customize Your Invoice6Normal_VDlg_Macros7Normal_VDlg_Macros_18Normal_VDlg_VDlg9%:"Standard_Anpassen der Amortisation; Standard_ATW$<!Standard_Compiling Utility Macros=Standard_FixerSetupDlg>Standard_Sperren?Standard_Sperren_1@Standard_TemplateInformation!AStandard_TemplateInformation_1'B$Whrung [0]_Compiling Utility MacrosCWhrung [0]_FixerSetupDlg"DWhrung [0]_TemplateInformation#E Whrung_Compiling Utility MacrosFWhrung_FixerSetupDlgGWhrung_TemplateInformation83ffff̙3f3fff3f3f33333f33333J Annual BudgetN9 Enter Q1,Q2 Enter Q3,Q4  =L}7  dMbP?_*+%&?'?(?)?MHP LaserJet 5PBT@gXXb@MSUDNHP LaserJet 5P;d "FXX?? Enter Q1,Q2 Enter Q3,Q4cU} I,Q} I,Q} I,Q}  I,Q} I,Q} $ I,Q}  I,Q}  I,Q} $ I,Q} I,Q} $ I,Q} I,Q} $ I,Q} I,Q} $ I,Q}  I,Q}  I,Q}  I,Q} m I,Q} I,Q} I,Q} mI,Q} $ I,Q =2'Z+[@''b 'wb@'b@'Jb';bb';bb'; '; '@  'J ' '''2b@20222bb2b22 2l22222-222HHHHHHHHHHHHHHHHHHHHHH2HH2HJJJJJJJJJJJJJJJJJJH H7h/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS,iiiiiiiiiiiiiiiijH H/k'Annual Budgeting and Tracking Worksheet,llllllllllllllllm}H H~nvUse this tool to prepare and track an annual budget with monthly or quarterly revenues and expenses. Enter your annual,opppppppppppppppq~H Hrzbudget numbers on this sheet in the white cells. Use whole dollars for all entries. Monthly numbers will automatically be,LKKKKKKKKKKKKKKKs~H Hrwcalculated on the "Enter Q1, Q2" and "Enter Q3, Q4" sheets which follow. If you would like to alter the monthly numbers,LKKKKKKKKKKKKKKKs~H Hrxin order to show timing of revenues or expenses, do so by simply overwriting the formulas in the monthly budget columns.,LKKKKKKKKKKKKKKKs~H H rUse the "Annual Budget Check" columns to make sure that you have not changed the annual totals by reallocating the monthly numbers., LKKKKKKKKKKKKKKKs~H2 HtuvvvvvvvvvvvvvvvwH2 HMJJJJJJJJJJJJJJJH H N Unit Name Y * OPPPPPPPPPPPNQHH I?DAD H N Fiscal Year* STPPPPPPPPPPPPUH I@  AAD HNStart Date of Year~ V @T WEnter$PPPPPPPPPPPUHI?uCSC~XS 'C,SC~;XS &CSSC~bXSBHXYPWAnnual Q1  Q2   Q3   Q4 YTD YTD YTD H IYTD &IYTDHPPPZBudgetBudgetActual Budget Actual Budget Actual BudgetActualthrough @(&A DifferencePercent HIBudget&IActual H[Revenues UU \HereBudgetActual Difference HNI?I@I@I@I@I@I@I @I"@I$@I&@I(@$N&I?I@I@I@I@I@I@I @I"@I$@I&@I(@1HP]Source 1 PU?Z @:  BU?Z@: BU $?Z@: BU +?Z@: BU ?Z @:  BU +?Z@: BU ?Z@: BU?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N 2(LLA~LLB ?5LLLA~LLLB HISource 1(HZ(H Z (HZ (HZ(HZ(HZ(H Z( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()HZ(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP^Source 2 _U?Z @:  BU(?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ?Z@: BU ?Z@: BU ?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N $  HISource 2(HZ(H Z (HZ (HZ(HZ(HZ(H'Z( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP^Source 3 _U?Z @:  BU ?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ?Z@: BU +$?Z@: BU ?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N '$  HISource 3(HZ(H Z (HZ (HZ(HZ(HZ(HZ( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP^Source 4 _U?Z @:  BU?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ?Z@: BU $?Z@: BU ?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N   HISource 4(HZ(H Z (HZ (HZ(HZ(HZ(HZ( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP^Source 5 _U?Z @:  BU?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ?Z@: BU $?Z@: BU ?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N   HISource 5(HZ(H Z (HZ (HZ(HZ(HZ(HZ( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP^Source 6 _U?Z @:  BU?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ?Z@: BU $?Z@: BU ?Z@: B@*)$$CzQ"N @*)$&$&CzQ"N   HISource 6(HZ(H Z (HZ (HZ(HZ(HZ(HZ( H Z (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP[Total RevenuesPB0,%nA~%BU0?Z @:  BU0?Z@: BU 0 ?Z@: BU +?Z@: BU 0 ?Z @:  BU - ?Z@: BU 0 ?Z@: BU0?Z@: B! %!&& % 0   HITotal Revenues(HZ(H$Z (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&HZ('HZ ((H)Z ()H*Z(*H Z(+H Z(,H1Z(-H,Z (.H-Z (/HZ(0H.Z(1H0Z2H```aH(H1Z(HZ (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&H$Z('H&Z ((H'Z ()H(Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0Z HUExpenses*PPbH(H1Z(HZ (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&H$Z('H&Z ((H'Z ()H(Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP]Item 1 PU ?Z @:  BU?Z@: BU ?Z@: BU  ?Z@: BU ?Z @:  BU  ?Z@: BU $?Z@: BU-?Z@: B@*)$$CzQ"N @+1*)$&$&CzQ"N  2-(LLA~LLB ?-5LLLA~LLLB HIItem 1(HZ(H Z (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP]Item 2 PU?Z @:  BU&?Z@: BU ?Z@: BU *?Z@: BU  ?Z @:  BU  ?Z@: BU $?Z@: BU, ?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N    HIItem 2(HZ(H Z (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHP]Item 3 PU?Z @:  BU ?Z@: BU ?Z@: BU ,?Z@: BU $?Z @:  BU  ?Z@: BU  ?Z@: BU?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N   HIItem 3(HZ(H* Z (HZ (HZ(HZ(HZ(HZ( HZ (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZHPTotal Category 1[C  -%(%0 BC$-%(%0 BC--%(%0 BU ?Z@: BU - ?Z@: BC - -% (% 0 BC  -% (% 0 BU  ?Z@: BU?Z@: B@-*)$$CzQ"N @-*)$&$&CzQ"N -  HI Total COGS(HZ(H Z (HZ (HZ(HZ(HZ(H Z( HZ (!H Z ("H!Z(#H"Z($H#Z(&HZ('H&Z ((HZ ()H1Z(*H Z(+H Z(,H)Z(-H,Z (.H-Z (/H.Z(0HZ(1H/ZHP]Item 4 PU#?Z @:  BU ?Z@: BU ?Z@: BU ?Z@: BU # ?Z @:  BU ?Z@: BU # ?Z@: BU?Z@: B@*)$$CzQ"N @&*)$&$&CzQ"N #   HIItem 4(HZ(HZ (HZ (HZ(HZ(HZ(H$Z( HZ (!H Z ("H!Z(#H"Z($H#Z(&H'Z('H(Z ((HZ ()H1Z(*H)Z(+H*Z(,H+Z(-H,Z (.H-Z (/H.Z(0H/Z(1H0ZDwl666yq66yITVr{  2+[!2"2b#2b$2b%2b&2bb'2bb(2)2*2+2,2 -2.2/20b10234bb5b6x@ 78il@ 9<@:; < HP ]Item 5 PU  ?Z @:  BU !?Z@: BU ?Z@: BU  ?Z@: BU  ?Z @:  BU ! ?Z@: BU ?Z@: BU ?Z@: B@  *)$ $ CzQ"N @ &*)$ &$ &CzQ"N      H IItem 5( H Z( HZ ( H Z ( H Z( H Z( H Z( H$Z( H Z ( !H Z ( "H !Z( #H "Z( $H #Z( &H 'Z( 'H (Z ( (H Z ( )H1Z( *H )Z( +H *Z( ,H +Z( -H ,Z ( .H -Z ( /H .Z( 0H /Z( 1H 0Z!Hb!]Item 6 !PU!!?Z @:  BU!"?Z@: BU! !?Z@: BU! ?Z@: BU! ?Z @:  BU! " ?Z@: BU! ! ?Z@: BU! ?Z@: B@!!*)$!$!CzQ"N @! &*)$!&$!&CzQ"N! ! ! !H!IItem 6(!H!Z(!H Z (!H!Z (!H!Z(!H!Z(!H!Z(!H $Z(! H!Z (!!H! Z (!"H!!Z(!#H!"Z(!$H!#Z(!&H!'Z(!'H!(Z (!(H!Z (!)H 1Z(!*H!)Z(!+H!*Z(!,H!+Z(!-H!,Z (!.H!-Z (!/H!.Z(!0H!/Z(!1H!0Z"Hb"]Item 7 "PU""?Z @:  BU" #?Z@: BU" "?Z@: BU" ! ?Z@: BU" ! ?Z @:  BU" # ?Z@: BU" " ?Z@: BU" !?Z@: B@""*)$"$"CzQ"N @" !&*)$"&$"&CzQ"N" ! " " "H"IItem 7("H"Z("H!Z ("H"Z ("H"Z("H"Z("H"Z("H!$Z(" H"Z ("!H" Z (""H"!Z("#H""Z("$H"#Z("&H"'Z("'H"(Z ("(H"Z (")H!1Z("*H")Z("+H"*Z(",H"+Z("-H",Z (".H"-Z ("/H".Z("0H"/Z("1H"0Z#Hb#Total Category 2#PC# '-%"(%"0 BC##-%"(%"0 BC## -%"(%"0 BU# ?Z @:  BU#  ?Z @:  BC#  -%" (%" 0 BC# " -%" (%" 0 BU#  ?Z @:  BU#"?Z @:  B@##*)$#$#CzQ"N @#'*)$#&$#&CzQ"N#  # # #H#ITotal SG&A Expenses(#H#Z (#H"Z (#H#Z (#H#Z (#H#Z (#H#Z (#H* Z (# H#Z (#!H# Z (#"H#!Z (##H#"Z (#$H##Z (#&H#'Z (#'H#(Z (#(H#Z (#)H"1Z (#*H#)Z (#+H#*Z (#,H#+Z (#-H#,Z (#.H#-Z (#/H#.Z (#0H#/Z (#1H#0Z $HP$]Item 8 $P U$'?Z! @:!  BU$%?Z!@:! BU$ $?Z!@:! BU$ ?Z!@:! BU$ ' ?Z! @:!  BU$ % ?Z!@:! BU$ ' ?Z!@:! BU$#?Z!@:! B@$$*)$$$$CzQ"N @$"&*)$$&$$&CzQ"N$ ' $ $ $H$IItem 8($H$Z!($H#Z! ($H$Z! ($H$Z!($H$Z!($H$Z!($H"$Z!($ H$Z! ($!H$ Z! ($"H$!Z!($#H$"Z!($$H$#Z!($&H$'Z!($'H$(Z! ($(H$Z! ($)H#1Z!($*H$)Z!($+H$*Z!($,H$+Z!($-H$,Z! ($.H$-Z! ($/H$.Z!($0H$/Z!($1H$0Z!%HP%]Item 9 %PU%%?Z" @:"  BU%&?Z"@:" BU% %?Z"@:" BU% $ ?Z"@:" BU% $ ?Z" @:"  BU% & ?Z"@:" BU% % ?Z"@:" BU%$?Z"@:" B@%%*)$%$%CzQ"N @%$&*)$%&$%&CzQ"N% $ % % %H%IItem 9(%H%Z"(%H$Z" (%H%Z" (%H%Z"(%H%Z"(%H%Z"(%H$$Z"(% H%Z" (%!H% Z" (%"H%!Z"(%#H%"Z"(%$H%#Z"(%&H%'Z"(%'H%(Z" (%(H%Z" (%)H$1Z"(%*H%)Z"(%+H%*Z"(%,H%+Z"(%-H%,Z" (%.H%-Z" (%/H%.Z"(%0H%/Z"(%1H%0Z"&HP&]Item 10 &P U& &?Z# @:#  BU&'?Z#@:# BU& &?Z#@:# BU& % ?Z#@:# BU& % ?Z# @:#  BU& ' ?Z#@:# BU& & ?Z#@:# BU&%?Z#@:# B@&&*)$&$&CzQ"N @&%&*)$&&$&&CzQ"N& % & & &H&IItem 10(&H&Z#(&H%Z# (&H&Z# (&H&Z#(&H&Z#(&H&Z#(&H%$Z#(& H&Z# (&!H& Z# (&"H&!Z#(&#H&"Z#(&$H&#Z#(&&H&'Z#(&'H&(Z# (&(H&Z# (&)H%1Z#(&*H&)Z#(&+H&*Z#(&,H&+Z#(&-H&,Z# (&.H&-Z# (&/H&.Z#(&0H&/Z#(&1H&0Z#'HP'Total Category 3'PC' ,-%$&(%$&0 BC''-%$&(%$&0 BC'' -%$&(%$&0 BU' $?Z$@:$ BU' $ ?Z$@:$ BC' " -%$& (%$& 0 BC' & -%$& (%$& 0 BU' $ ?Z$@:$ BU'&?Z$@:$ B@''*)$'$'CzQ"N @'#&*)$'&$'&CzQ"N' " ' ' 'H 'ITotal Allocated Expenses('H'Z$('H&Z$ ('H'Z$ ('H'Z$('H'Z$('H'Z$('H#$Z$(' H'Z$ ('!H' Z$ ('"H'!Z$('#H'"Z$('$H'#Z$('&H''Z$(''H'(Z$ ('(H'Z$ (')H&1Z$('*H')Z$('+H'*Z$(',H'+Z$('-H',Z$ ('.H'-Z$ ('/H'.Z$('0H'/Z$('1H'0Z$(HP(]Item 11 (P U((?Z% @:%  BU(( ?Z%@:% BU( (?Z%@:% BU( $?Z%@:% BU( , ?Z% @:%  BU( ?Z%@:% BU( ( ?Z%@:% BU('?Z%@:% B@((*)$($(CzQ"N @()&*)$(&$(&CzQ"N( , ( ( (H(IItem 11((H(Z%((H'Z% ((H(Z% ((H(Z%((H(Z%((H(Z%((H&$Z%(( H(Z% ((!H( Z% (("H(!Z%((#H("Z%(($H(#Z%((&H('Z%(('H((Z% (((H(Z% (()H'1Z%((*H()Z%((+H(*Z%((,H(+Z%((-H(,Z% ((.H(-Z% ((/H(.Z%((0H(/Z%((1H(0Z%)HP)]Item 12 )PU))?Z& @:&  BU)) ?Z&@:& BU) )?Z&@:& BU) (?Z&@:& BU) ( ?Z& @:&  BU) ( ?Z&@:& BU) ) ?Z&@:& BU)(?Z&@:& B@))*)$)$)CzQ"N @)*&*)$)&$)&CzQ"N) ( ) ) )H)IItem 12()H)Z&()H(Z& ()H)Z& ()H)Z&()H)Z&()H)Z&()H($Z&() H)Z& ()!H) Z& ()"H)!Z&()#H)"Z&()$H)#Z&()&H)'Z&()'H)(Z& ()(H)Z& ())H(1Z&()*H))Z&()+H)*Z&(),H)+Z&()-H),Z& ().H)-Z& ()/H).Z&()0H)/Z&()1H)0Z&*HP*]Item 13 *PU**?Z' @:'  BU** ?Z'@:' BU* *?Z'@:' BU* )?Z'@:' BU* + ?Z' @:'  BU* ) ?Z'@:' BU* * ?Z'@:' BU*)?Z'@:' B@***)$*$*CzQ"N @*+&*)$*&$*&CzQ"N* + * * *H*IItem 13(*H*Z'(*H)Z' (*H*Z' (*H*Z'(*H*Z'(*H*Z'(*H)$Z'(* H*Z' (*!H* Z' (*"H*!Z'(*#H*"Z'(*$H*#Z'(*&H*'Z'(*'H*(Z' (*(H*Z' (*)H)1Z'(**H*)Z'(*+H**Z'(*,H*+Z'(*-H*,Z' (*.H*-Z' (*/H*.Z'(*0H*/Z'(*1H*0Z'+HP+]Item 14 +PU++?Z( @:(  BU++ ?Z(@:( BU+ +?Z(@:( BU+ *?Z(@:( BU+ ) ?Z( @:(  BU+ * ?Z(@:( BU+ + ?Z(@:( BU+*?Z(@:( B@++*)$+$+CzQ"N @+,*)$+&$+&CzQ"N+ ) + + +H+IItem 14(+H+Z((+H*Z( (+H+Z( (+H+Z((+H+Z((+H+Z((+H*$Z((+ H+Z( (+!H+ Z( (+"H+!Z((+#H+"Z((+$H+#Z((+&H+'Z((+'H+(Z( (+(H+Z( (+)H*1Z((+*H+)Z((++H+*Z((+,H++Z((+-H+,Z( (+.H+-Z( (+/H+.Z((+0H+/Z((+1H+0Z(,HP,Total Category 4,PC,--%(+(%(+0 BU,,?Z) @:)  BU,, ?Z)@:) BU, ,?Z)@:) BU, +?Z)@:) BU, & ?Z) @:)  BU, + ?Z)@:) BU, , ?Z)@:) BU,+?Z)@:) B!,, %(+!,'& %(+, & , , ,H-HP-[Total Expenses-PR-<DD#D'D,A~DD#D'D,BU-?Z* @:*  BU-?Z*@:* BU- - ?Z*@:* BU- 0 ?Z*@:* BU- ?Z* @:*  BU- 0 ?Z*@:* BU- - ?Z*@:* BU-/?Z*@:* B*--$,$'$#$B*-0$,$'$#$B- 0- - -H2.HPPPbbbbbbbbbbbbbH /H/[Operating Income*/PPbbbbbbbbbbbbbH0H[0[Operating Income0U0U10200 (LLA~LLB0U100U100 U1 00 U1 00 U1 00 U1 00 U1 00U100U 100U 100U 100bH1H[1Uas a % of Revenue1U1,1211 (LLA~LLB11111  11 (11 011 #11  11&11 11 11 11bH22HPPPaaaaaaaaaaaPbH23HPPP```````````PPH 4H4N Submitted by: 4c (4RaaaaaaaaaaaaaH 5H5N Date Updated: 5d &5efffffffffffPP26HH27HKKKKKKKKKKKKKKKKhH28HKKKKKKKKKKKKKKKKhH29HH,:HKKKKKKKKKKKKKKKK+:#Developed by Village Software, Inc. :H2;HH2<HHHHHHHHHHHHHHHHHHHHHH>q06Z66b`6666m6] < @xĚText 1Note: Italicized entries indicate sample headings that should be replaced. Shaded cells contain formulas that should not be overwritten. Enter Start Date of Year in MM/DD/YY format. =x<$8X> " U  ;\;/  dMbP?_*+%&?'?(?)?MHP LaserJet 5P <@g hhxt 1Note: Italicized entries i@MSUDOHP LaserJet 5P<d"Ahh?? Annual Budget Enter Q3,Q4cU} i,Q} i,Q} i,Q}  i,Q} i,Q}  i,Q}  i,Q} i,Q}  i,Q}  i,Q}  i,Q} i,Q} mi,Q}  i,Qsample1Village SoftwareVillage SoftwareSales and Marketing250002000030000140002000300033000sample2Village SoftwareVillage Software !"#$%250070015001700500700180040080003500820020004508200|sample3Village SoftwareVillage Software&'()*1100015001300025005000 Jonathan King&current1Village Software&Created by Village Software on 7/29/96&current2Village Software&Created by Village Software on 7/29/96 !"#$%q&current3Village Software&Created by Village Software on 7/29/96&'()*1 ;ZT0@ b@@b w@ @/@0 @0Jb@b @  @ @ @ r@@;0@@b@0@@ @@ @p0@p0@b@@b0@@b@@b66jjjjjjjjjjjjjjjjjjjjjj7e/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS2ffffffffffffffffffffg=c5Annual Budgeting and Tracking Worksheet: Monthly Data2^___________________d]#xAdjust monthly values here.2`aaaaaaaaaaaaaaaaaaab]6klkkkkkkkkkkkkkkkkkkkk6 m Unit Name('Z  .nnnnnnnnnnnnnnnnn  m Fiscal YearP Z:Z  :! B. nnnnnnnnnnnnnnnnn  mStart Date of Year(  @ Z. nnnnnnnnnnnnnnnnn6 mjjnnnnnnnnnnnnnnnnn on Annual p D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d January q pD AD D AD D ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d February q p2D AD D AD D ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dMarch q Q1 Total  p D AD D AD D ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dApril q p D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dMay q p D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dJune q Q2 Total  ss Annual  Budget tBudget uActual tBudget uActual tBudget uActual Budget Actual tBudget uActual tBudget uActual vBudget wActual Budget Actual  Revenues yyBudget Check*z{z{z{z{z{z{ (P  Z Source 1|XBZA@:@B:: :% :7 BP:U:g :y : B B 0&L A~L B   0 &L A~L B    0 &L A~L B   ?  5LLLLLL B  0&L A~L BL L ? 5LLLLLL B   (P4Z Source 2|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (PHZ Source 3|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (P\Z Source 4|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ %* ###$%  (PpZ Source 5|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (PZ Source 6|X&BZA@:@B':: :% :7 BP:U:g :y : B B( ) (   ) (   ) *  + ()()()*+  ([ZTotal RevenuesxX,BZA@:@B--:: :% :7 BP:U:g :y : B B.7-- - B/- .  /-  .  /  ./-./-./././ 6`}001111111111111111 Expenses2Pn221111111111111111 ([ZItem 1|XBZA@:@B:: :% :7 BP:U:g :y : B B D   D    D    ? 5LLLLLL B  D D D ?5LLLLLL B   ([ZItem 2|X!BZA@:@B":: :% :7 BP:U:g :y : B B D #  D  #  D  # $ % D #D #D #$%  ([ZItem 3|X!BZA@:@B":: :% :7 BP:U:g :y : B B D #  D  #  D  # $  % D #D #D #$%  ([ZTotal Category 1xX3BZA@:@B4*:: :% :7 BP:U:g :y : B B5 7--(-0 B6* 5  6 5  6*  56*5 65 6*5 6*56*  ([ ZItem 4|X!BZA@:@B" :: :% :7 BP:U:g :y : B B D 7  D  7  D  7 8 ? 5LLLLLL B9 D 7D 7D 78?5LLLLLL B9  ([Z Item 5|X!BZ A@: @B": : :% :7 BP:U :g :y : B B D #  D  #  D  # $ % D #D #D #$%  ([,Z!Item 6|X!BZ!A@:!@B":!:! :%! :7! BP:U!:g! :y! :! B B D #  D  #  D  # : % D #D #D #:%  ([<Z"Item 7|X!BZ"A@:"@B":":" :%" :7" BP:U":g" :y" :" B B D ;  D  ;  D  ; <  =  D ;D ;D ;< =  DEAl::{g:::ey:V T0@!b@"@b#@$@%@&@'b@(@b)@ * @+@,@-@r.@/@0;0@1@2b@30@ 4@ 5<@67 @8p0@p 9Z0@b:` ( [LZ#Total Category 2 xX 3 BZ#A@:#@B 4:#:# :%# :7# BP:U#:g# :y# :# B B 5$ 7 --(-0 B 6$  5$   6$   5$   6$   5!  6!  5$  6$  5$  6$  5$  6$  5!  6!   !(![p Z$Item 8!|X!!!BZ$A@:$@B!"$:$:$ :%$ :7$ BP:U$:g$ :y$ :$ B B!! D! !#! ! D! ! #! ! D! ! #! $"! ?!# 5LLLLLL B!%"! !!D! !#!!D! !#!!D! !#!$"!?!#5LLLLLL B!%"! ! "("[!Z%Item 9"|X"!"BZ%A@:%@B""!:%:% :%% :7% BP:U%:g% :y% :% B B"" D" "#" " D" " #" " D" " #" :#! "%#! ""D" "#""D" "#""D" "#":#!"%#! " #(#["Z& Item 10#|X#>#BZ&A@:&@B#?":&:& :%& :7& BP:U&:g& :y& :& B B#@# D# #A# @# D# # A# @# D# # A# B$ ! #C$! #@#D# #A#@#D# #A#@#D# #A#B$!#C$! # $($[#Z'Total Category 3$xX$3 BZ'A@:'@B$4:':' :%' :7' BP:U':g' :y' :' B B$5)$7$$--(-0 B$6)$$ 5) $$ 6) $$ 5) $$ 6) $$ 5%$$6%$$5)$$6)$$5)$$6)$$5)$$6)$$5%$$6%$ $ %(%[$Z( Item 11%|X%D%BZ(A@:(@B%E):(:( :%( :7( BP:U(:g( :y( :( B B%F% D% %7% F% D% % 7% F% D% % 7% 8&% ?%( 5LLLLLL B%9&% %F%D% %7%F%D% %7%F%D% %7%8&%?%(5LLLLLL B%9&% % &(&[%Z) Item 12&|X&!&BZ)A@:)@B&"%:):) :%) :7) BP:U):g) :y) :) B B&& D& &#& & D& & #& & D& & #& $'% &%'% &&D& &#&&D& &#&&D& &#&$'%&%'% & '('[&Z* Item 13'|X'!'BZ*A@:*@B'"(:*:* :%* :7* BP:U*:g* :y* :* B B'' D' '#' ' D' ' #' ' D' ' #' $(% '%(% ''D' '#''D' '#''D' '#'$(%'%(% ' (((['Z+ Item 14(|X(>(BZ+A@:+@B(?&:+:+ :%+ :7+ BP:U+:g+ :y+ :+ B B(( D( (G( @( D( ( G( @( D( ( G( H) % (I)% (@(D( (G(@(D( (G(@(D( (G(H)%(I)% ( )()x (Z,Total Category 4)xX)J$BZ,A@:,@B)K#:,:, :%, :7, BP:U,:g, :y, :, B B)L*)7))--(-0 B)M*)) L* )) M* )) L* )) M )) L* ))M ))L*))M*))L*))M ))L*))M ))L*))M ) ) *(*x( )Z-Total Expenses*xX*N)BZ-A@:-@B*O:-:- :%- :7- BP:U-:g- :y- :- B B*P-*F**<LLLLA~LLLLB*P** P- ** P ** P- ** P- ** P- **P**P-**P**P-**P-**P-**P-**P-**N-* *6+n}QRRRRRRRSSRRRR2222,, Operating Income2,nnTRRRRRRRSSRRRR2222 --xOperating Income-yX-UBZ0A@:0@B-U.-2--(LLA~LLB-U.--U.-- U. -- U. -- U. -- V. -- U. --U.--W.--U.--U.--U.--X.--X.--X.--X.- - ..xas a % of Revenues.yX.-BZ1A@:1@B.-.2..(LLA~LLB...... ..  ..  ..  ..  .. ................. .6/nnn~~~~~~~~~~~~~~~~~60nnn}}}}}}}}}}}}}}}}} 11m Submitted by:(1H Z4 .1\~~~~~~~~~~~~~~~~~ 22N Date Updated:(2L 1Z5 .2|fffffffffffffffff6364jjjjjjjjjjjjjjjjjjjjjj65g6_ 1999 by the President and Fellows of Harvard College and its licensors. All rights reserved.06gggggggggggggggggggg+6#Developed by Village Software, Inc.667jjjjjjjjjjjjjjjjjjjjjj68:11:^:::::::=x<$8X> ????m0btQt bEbVbhT0bbq0bb0bhTbAq0Fq0b mhT0DȚxbb]l0bšDl0DȚbxbbbl;Tbbqq     "   ;*9.  dMbP?_*+%&?'?(?)?MHP LaserJet 5P?@ghh@MSUDNHP LaserJet 5P;d "Ahh?? Annual Budget Enter Q1,Q2cU} i,Q} i,Q} i,Q}  i,Q} i,Q}  i,Q}  i,Q} i,Q}  i,Q}  i,Q}  i,Q} i,Q} mi,Q}  i,Q sample1Village SoftwareVillage SoftwareSales and Marketing7/1/96 - 7/31/96250002000030000140002000300033000sample2Village SoftwareVillage Software !"#$250070015001700500700180040080003500820020004508200sample3Village SoftwareVillage Software%&'()00100015001300025005000 Jonathan King35284 &current1Village Software&Created by Village Software on 7/29/96&current2Village Software&Created by Village Software on 7/29/96 !"#$x&current3Village Software&Created by Village Software on 7/29/96%&'()00 ;ZT0@ b@@b w@ @/@0 @0Jb@b @  @ @ @ r@@b@b@b@0@@ @@@p0@p@@@@@bb@@`@@T66jjjjjjjjjjjjjjjjjjjjjj7e/Harvard ManageMentor - FINANCE ESSENTIALS TOOLS2ffffffffffffffffffffg=c5Annual Budgeting and Tracking Worksheet: Monthly Data2^___________________d]#xAdjust monthly values here.2yzzzzzzzzzzzzzzzzzzz{]6klkkkkkkkkkkkkkkkkkkkk6 m Unit Name(P 'Z  .nnnnnnnnnnnnnnnnn  m Fiscal YearP T :Z  :! B. nnnnnnnnnnnnnnnnn  mStart Date of Year(  @ Z. nnnnnnnnnnnnnnnnn6 mjjnnnnnnnnnnnnnnnnn on Annual pX D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dJuly q pd  D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB dAugust q pt  D AD D ADD ADB '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d September q Q3 Total  p  D AD  D ADD AD B '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d October q p  D AD  D ADD AD B '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d November q p  D AD  D ADD AD B '5@KT^htJanuaryFebruary~MarchsAprilhMay_JuneUJulyKAugust?@ September,OctoberNovemberDecemberB d December q Q4 Total  ss Annual  Budget tBudget uActual tBudget uActual tBudget uActual Budget Actual tBudget uActual tBudget uActual vBudget wActual Budget Actual  Revenues yyBudget Check*z{z{z{z{z{z{ (] Z Source 1|XBZA@:@B:: :% :7 BP:U:g :y : B BL     L      L    ?  5LLLLLL B  L L L ? 5LLLLLL B   (] Z Source 2|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (] Z Source 3|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (] Z Source 4|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (] Z Source 5|X!BZA@:@B":: :% :7 BP:U:g :y : B B #    #    # $ % ###$%  (]$ Z Source 6|X&BZA@:@B':: :% :7 BP:U:g :y : B B( ) (   ) (   ) *  + ()()()*+  (x8 ZTotal RevenuesxX,*BZA@:@B--:: :% :7 BP:U:g :y : B B.7--(-0 B/ .  /  .  /  ./././././ 6}}001111111111111111 Expenses2nn221111111111111111 (]X ZItem 1|XBZA@:@B:: :% :7 BP:U:g :y : B B D   D    D    ? 5LLLLLL B  D D D ?5LLLLLL B   (]h ZItem 2|X!BZA@:@B":: :% :7 BP:U:g :y : B B D #  D  #  D  # $ % D #D #D #$%  (]x ZItem 3|X!BZA@:@B":: :% :7 BP:U:g :y : B B D #  D  #  D  # $  % D #D #D #$%  (x ZTotal Category 1xX3BZA@:@B4*:: :% :7 BP:U:g :y : B B5 7--(-0 B6  5  6  5  6  565 6 5 6 5 6 56  (] ZItem 4|X!BZA@:@B" :: :% :7 BP:U:g :y : B B D 7  D  7  D  7 8 ? 5LLLLLL B9 D 7D 7D 78?5LLLLLL B9  (] Z Item 5|X!BZ A@: @B": : :% :7 BP:U :g :y : B B D #  D  #  D  # $ % D #D #D #$%  (] Z!Item 6|X!BZ!A@:!@B":!:! :%! :7! BP:U!:g! :y! :! B B D #  D  #  D  # : % D #D #D #:%  (] Z"Item 7|X!BZ"A@:"@B":":" :%" :7" BP:U":g" :y" :" B B D ;  D  ;  D  ; <  =  D ;D ;D ;< =  D@l::{g:::e