ࡱ> Root EntryRoot Entry FܐoFkCompObjfWorkbookQ8MSDigSig(Author)$FP  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEGHIJKLMNOPRSTUVWXYZ[\]^_`abcdefghijklmSummaryInformation(zDocumentSummaryInformation8\ ՜.+,D՜.+, PXd lt| / New Capital Investment  WorksheetsD 8@ _PID_HLINKSABK.msbptz://Exercise - Investment Appraisal.xlt/msbpz://-r:276DB154/msbpz://-r:276DB153/msbpz://-r:276DB155/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0z X`  %New Fixed-Asset Investment EvaluatorelMicrosoft CorporationmeMicrosoft CorporationmeMicrosoft Excel@Er@\"r@'Gy+F <&" WMFCRn 2Rdd+F EMFR @    !" !" !  " !  e'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6e% Lddd!??% #6#% Ld###!??% Y6Y% LdYYY!??% 6% Ld!??%  6 % Ld   !??% d6d% Ldddd!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw F\lP@$0] F\l|pd+%w0%    TT AA LP11   ( &% 6% Ld!??   TT (7AA (LP2   %  6 % Ld   !??   TT :IAA :LP31   % :6:% Ld:::!??   TT KZAA KLP4U   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7O   % ~6~% Ld~~~!??   TT AA LP8y    % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PA0    % 6% Ld!??   TT:BAA:LPB2.    % $6$% Ld$$$!??   TTAALPChe    % Z6Z% LdZZZ!??   TTAALPD0    % 6% L&" WMFC Rd!??   TT4<AA4LPE    %  6 % Ld   !??% % " !% %   e'%    Ld#9 )!??'% (  Ld#d9#)!??'% (  Ld9#9 !??'% (  Ld#9d#9!??RL Tahoma Tahoma`hۍ0WXw ]\@$0h ]\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdana`hۍ0WXw ^\@$0h ^\0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw d\@$0h d\3 0% RL  Verdana Verdana`hۍ0WXw `\@$0h `\ 0%   RL  Verdana VerdanaDhۍ0WXw U\@$0h U\ D0% % % % " !% %   $\ l  T2^kAA2^L|Internal Rate of Return%  % % % % % % % % % % % % % % % % % % % " !% %   $e%   T$3dAA3$LNew Fixed-Asset Investment Evaluator         % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $e% % % % % % % %   T2dAA2tL4This template will calculate the present value, net present value, internal rate of return, and profitability index   T2dAA2;Lfor any capital investment over a period of up to 10 years. T2~ &WMFCRdAA2rL0Enter the cost and forecast revenues into the left-hand table. If your first cash flow occurs at the beginning of  T2dAA2nL(the period, enter it in year 0 (e.g. paying for an item upfront), otherwise start from year 1. Then enter the    T2dAA2pL,values for your two discount rates into the right-hand table. A worked example of this template is available in     T`2<AA2.Lthe template, Exercise - Investment Appraisal.  % % % " !% %   e% % " !% %   e' % (     ( &% % Ld!??% % Ld#!??% % LdY!??% % Ld!??% % Ld !??% % Ldd!??'%   ( &% #}6f}% Ld#}d}#}C!??% ( % " !%   ee 0  K@0 ee  % % % " !%   e'%    ( &% 6e% Ldde!??% 6% Ld!??% "   e  '' ' ,e-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-e- @ !d-##- @ !#-YY- @ !Y-- @ !-  - @ ! -dd- @ !d-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1] -- @ !  2 ( 2n -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6A -mm- @ !m  2 ~ 7 -~~- @ !~  2 8x -- @ !  2 9 -- @ !  2 #Am  -- @ !  2 :B]  -$$- @ !$  2 Cn  -ZZ- @ !Z  2 D  -- @ !  2 4E  -  - @ ! -"System-'-- ,e-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana-- --'- -  ,l \$ *2 ^2Internal Rate of Return-  - - - - - - - - - - - - - - - - - --'- -  ,e$-  =2 3$New Fixed-Asset Investment Evaluator         - - ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------'--  ,e$-------- 2 2tThis template will calculate the present value, net present value, internal rate of return, and profitability index   `2 2;for any capital investment over a period of up to 10 years.  2 2rEnter the cost and forecast revenues into the left-hand table. If your first cash flow occurs at the beginning of  2 2nthe period, enter it in year 0 (e.g. paying for an item upfront), otherwise start from year 1. Then enter the    2 2pvalues for your two discount rates into the right-hand table. A worked example of this template is available in     L2 2.the template, Exercise - Investment Appraisal.  ---'--  ,e--'--  ,e-   -- @ !-- @ !#-- @ !Y-- @ !-- @ ! -- @ !d-  -}#}f- @ !C}#- -'- ,e,e ,e ---'- ,e-   -e- @ !e-- @ !-'0E *H 60210 *H 0g +7Y0W03 +70%7)O•0 0 *H kV9K̙B?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1o0k0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1!]8!^R 0 +7 10JHNew Fixed Asset Investment Evaluator<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H [b`BhJIUܲKTe]^ ߧMY0{=3q @5۲*))CMapxۓ!щُO{LݴvӍj1hQda\8av<Z¨rNZf n,@4aM[Hi2EPw#㟟L泜 N75wTM??x}@\rCA%H'icEfUP,t 228g2+ yۄ$|0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201005834Z0 *H  1 dh!F<9*]w/]ʋ^-Tu'ݘ=5%DЕr 4}#0T EY'Yн,t @`\pMicrosoft Corporation Ba==hx,^8X@"1Arial1Arial1Arial1Arial1Tahoma1Verdana1 Tahoma1Tahoma1Tahoma1 Verdana1@ Tahoma1 Arial1Tahoma1@ Tahoma1Verdana1Verdana1Verdana1Verdana1& Verdana Ref1& Verdana Ref1& Verdana Ref1& Verdana Ref1&? Verdana Ref"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"IR"#,##0;\-"IR"#,##0!"IR"#,##0;[Red]\-"IR"#,##0""IR"#,##0.00;\-"IR"#,##0.00'""IR"#,##0.00;[Red]\-"IR"#,##0.00;6_-"IR"* #,##0_-;\-"IR"* #,##0_-;_-"IR"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-C>_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)#,##0;\(#,##0\) #,##0;#,##00.000000000000 0.0000000000                %@@   7     % @ %@"@  D   D  $  7 # ! ! ) ) % @   !7  7     @  `  `  h@@  ` @  `@ %a(@ %a`@  %a`@ %a` `  @ `   h   x 7  %  % 7  % % 7  % 7 7  %` `  $ %!h@ 7 %  7%(@ %   %("  %q "@  $@ 7%  7 %(@ %  % 7  %7  %!0 %!0 %!07  %! @  %! @   $  %ah@  %ah7 @ %h    %ah 7       7  `@ 7 %    ` %a @ q, A!7   H7 !  @ !  `  `7 X P H @ h7 `7 !  H  q, A!7 # ! ) ) ) )  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_Hyperlink NonPrint_TemTitle! NonPrint_Text "Normal 2#$ Product Title %Text &Title`New Capital Investment  ;# gZR  3  @@  Year Outgoing Cash Incoming Cash Net Cash Lower Discount RateHigher Discount Rate$Present Value at Lower Discount Rate(Net Present Value at Lower Discount Rate%Present Value at Higher Discount Rate)Net Present Value at Higher Discount RateInternal Rate of Return*Profitability Index at Lower Discount Rate Cost/RevenueCalculation TableDiscount Rates$New Fixed-Asset Investment EvaluatorGo to Article: See Also: Present ValueThe Profitability IndexExercise - Investment Appraisal.This template will calculate the present value, net present value, internal rate of return, and profitability index for any capital investment over a period of up to 10 years. Enter the cost and forecast revenues into the left-hand table. If your first cash flow occurs at the beginning of the period, enter it in year 0 (e.g. paying for an item upfront), otherwise start from year 1. Then enter the values for your two discount rates into the right-hand table. A worked example of this template is available in the template, Exercise - Investment Appraisal.Microsoft Business PlannerNote: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.f Colin Barrow 1998, Accounting: Financial Management for the Small Business, published by Kogan Page.M" Pb @ =*0  dMbP?_*+% &LDate: &D&~?'~?(~?)~?MHP LaserJet 5Si/5Si MX7@ pdXX7@XXEXCELCourier New (X\\proliant\pro_frontHP5SI" dXX `? `?U} I} }  }  2} $}  } I=  @ @      @ (@  X@                         @ '\]]]]]](' l]]]]]]('^______(' `______(' n nn____('aaaaaaa('bbbbbbb(' opppppd(' qpppppd( 'cdddddd( ' r pppppd( 'effffff( 'ghhhhhh( ' ^ ffffff('effffff(' nnnffff(' nniffff(' nnnffff('j______('j_____ m('*+,+'*+() ( - ./.0 - .() (TUUV1PQ'2 ( 3 4 4 5( R S'2 (~ J GGH LL( N O'2 (~ K? 687 M ='2 (~ K@ 687(>?'2 (~ K@ 687( @(A#D%"B '2 (~ K@ 687( B.CD%"B D '2 (~ K@ 687(DE'2 (~ K@ 68!7 DD; F(AD%"B '2 (~ K@ 68!7  DD; B .CD%"B D '2 D l00000000000HjmYY ! " # $ % & ' ( ) * + , - . / 0123456789:;< (~ K @ 68! 7! D D  ;WE'2 !(~ !K"@ !68!!7" D!D!!( !Z #!k$ %"B> !'2 "(~ "L$@ "9I!":! D"D""'YX'2 #(''''' #- !#[# DD #'2 $('''''(''2 %('''''1''2 &)&)222 ')'< '22 ()()(2)))2*)2222*2+)2222+2,)2222,2-)2222.)/)0)1)2)3)4)5)6)7)8)9):2;2<2>0__W"  ( - dB  s *D@ h]``aldB  s *D@\]`aldB  s *D@ h]`8aldB  s *D@\]`aldB  s *D@ h]`HaldB  s *D@\]`aldB @ s *D@$$]`XaldB  s *D@ h]`aldB   s *D@\] `ha>@  : 7FyK yK http:///^yK yK *msbpz://-r:276DB155/^yK yK *msbpz://-r:276DB153/^yK yK *msbpz://-r:276DB154/yK yK \msbptz://Exercise - Investment Appraisal.xlt/