ࡱ> Root EntryRoot Entry F0iJFkCompObjfWorkbookQa5MSDigSig(Author)$FH  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEGHIJKLMNOPRSTUVWXYZ[\]^_`abcdefghijkSummaryInformation(xzDocumentSummaryInformation8x ՜.+,D՜.+, PXd lt| / Investment Evaluator  Worksheetsd 8@ _PID_HLINKSAmsbpz://-r:276DB155/msbpz://-r:276DB153/]=msbptz://Exercise - Capital Budgeting for a New Product.xlt/msbpz://-r:276DB158/  http:/// FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qOh+'0Hz X` !New Project Investment Evaluator ExMicrosoft Corporation EMicrosoft Corporation EMicrosoft Excel@#fΝ@Ÿz@/G0yo, # <&" WMFC T3TSdko, # EMFTSp @    !" !" !  " !  l'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6l% Ldkk!??% #6#% Ld###!??% 6% Ld!??% 6% Ld!??% '6'% Ld'''!??% k6k% Ldkkk!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw K\lP@$0  K\l|pd+%w0%    TT AA LP11   ( &% 6% Ld!??   TT (7AA (LP2   %  6 % Ld   !??   TT :IAA :LP3   % :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]eAA]LPB2.    % $6$% Ld$$$!??   TTAALPChe    % 6% Ld!??   TT AALPD0    % 6% L&" WMFC TTSd!??   TTEMAAELPE    % (6(% Ld(((!??% % " !% %   l'%    Ld#9 )!??'% (  Ld#k9#)!??'% (  Ld9#9 !??'% (  Ld#9k#9!??RL Tahoma Tahoma`hۍ0WXw \@$0 \ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana Verdana`hۍ0WXw \@$0 \0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana Refw}!w`WXw \@$0 \3 0% RL  Verdana Verdana`hۍ0WXw \@$0 \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% % % % " !% %   $\ll  Tt2^JkAA2^1LDiscounted Cash Flow in Working Capital Decisions  %  % % % % % % % " !% %   $l%   T 3OAA3 LNew Project Investment Evaluator         % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $l% % % % % % % % % % % % % % % % %   T2kAA2dLThis template will calculate net present value and internal rate of return for help with investment     T2kAA2_L decisions such as launching a new product, entering new markets, or buying or choosing between     T2AA2!Ldifferent types of new equipment.  T2kAA2eLEnter the payments and forecast revenues into the left-hand table. If your first cash flow occurs at   T2kAA2gL &vWMFCTTSthe beginning of the period, enter it in year 0 (e.g. cost of re-equipping a factory), otherwise start  T2kAA2cLfrom year 1. Then enter the values for your two discount rates into the right-hand table. A worked    TL2kAA2ULexample is available in the template, Exercise - Capital Budgeting for a New Product.    T2kAA2dLTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     T2pAA2 Ldclick Rows. % % % " !% %   l% % " !% %   l' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld!??% % Ld'!??% % Ldk!??'%   ( &% #}6m}% Ld#}k}#}J!??% ( % " !%   ll 0  K@0 ll  % % % " !%   l'%    ( &% 6l% Ldkl!??% 6% Ld!??% "   l  '' ' ,l-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-l- @ !k-##- @ !#-- @ !-- @ !-''- @ !'-kk- @ !k-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1w -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8w -- @ !  2  9 -- @ !  2 #A  -- @ !  2 ]B  -$$- @ !$  2 C  -- @ !  2 D  -- @ !  2 EE  -((- @ !(-"System-'-- ,l-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref-  Verdana-    Verdana-- --'- -  ,ll\$ Q2 ^21Discounted Cash Flow in Working Capital Decisions  -  - - - - - --'- -  ,l$-  72 3 New Project Investment Evaluator         - - ------------------------------------------------------------------------------------------'--  ,l$----------------- 2 2dThis template will calculate net present value and internal rate of return for help with investment     2 2_decisions such as launching a new product, entering new markets, or buying or choosing between m    92 2!different types of new equipment.  2 2eEnter the payments and forecast revenues into the left-hand table. If your first cash flow occurs at   2 2gthe beginning of the period, enter it in year 0 (e.g. cost of re-equipping a factory), otherwise start  2 2cfrom year 1. Then enter the values for your two discount rates into the right-hand table. A worked a   2 2Uexample is available in the template, Exercise - Capital Budgeting for a New Product.b    2 2dTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     2 2 click Rows.y ---'--  ,l--'--  ,l-   -- @ !-- @ !#-- @ !-- @ !-- @ !'-- @ !k-  -}#}m- @ !J}#- -'- ,l,l ,l ---'- ,l-   -l- @ !l-- @ !-'0= *H .0*10 *H 0g +7Y0W03 +70%7)O•0 0 *H vfC6,3G?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 #1g0c0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1j.\>0 +7 10B@New Project Investment Evaluator<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H k|}#utE]|կ.:}\?lNvO5=!>*yPMAS)yrUJ<)#"7xPӗ0u3h*ů?Et$}6fV.QDK/Oh[E7"]+:Qt\-N-a %|;c((zjn JTju}RĞ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 981201004823Z0 *H  1a/k2>mvv$0  *H 4UƙqhEjZyʕ2__-"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.000% 0.000#,##0_ ;[Red]\-#,##0\ 0_ ;[Red]\-0\ 0.00_ ;[Red]\-0.00\ 0.000_ ;[Red]\-0.000\ ##,##0.000_ ;[Red]\-#,##0.000\ #,##0;\(#,##0\) #,##0;#,##00.000000000000 0.0000000000                %@@   7      % @ %@"@     D  $  7 # ! ! ) ) % @   !7  7    %1(  @  `  `  h@@  ` @  `@ %q(@ %q`@  %q`@ %q`      7  7 `  %qh@  %qh7 @  @   @ x   x 7   %qh 7  %10@ % @ % 7@ % 7 @ %1 @   $  %(%  % %7 % 7  %1 @   $  %1  % %7 %7  %1h@ 7   7 % " @  %107 % 7 %7 %77 % 7 7  $@ 7 %  7 %  % 7   `@ 7 %1  %` %q @  %q(@  %(  %(  Q!7   H7 !  @ !  `  `7 X P H @ h7 `7 !  H %1(  " % "@  % "7 @      "@ %7  ,  Q!7 # ! ) ! !) !)  amount Body text  header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_Heading NonPrint_Hyperlink!NonPrint_TemTitle" NonPrint_Text #Normal 2$% Product Title &Text 'Title`Investment Evaluator  ;.  gbZ   3  @@  BNew Product Cash FlowCalculation TableYear:Discount RatesLower Discount RateReceiptsHigher Discount RateTotal Receipts(Net Present Value at Lower Discount RatePayments)Net Present Value at Higher Discount RateInternal Rate of Return Net Cash Flow New Project Investment EvaluatorGo to Article:1Discounted Cash Flow in Working Capital Decisions See Also:.Exercise - Capital Budgeting for a New Project Present ValueOtherThis template will calculate net present value and internal rate of return for help with investment decisions such as launching a new product, entering new markets, or buying or choosing between different types of new equipment. Enter the payments 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. cost of re-equipping a factory), otherwise start from year 1. Then enter the values for your two discount rates into the right-hand table. A worked example is available in the template, Exercise - Capital Budgeting for a New Product. To add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then click Rows.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,  @ 1b!+1  dMbP?_*+%MHP LaserJet 5Si/5Si MX7@ pdXX7@XXEXCELDCourier New (XO\\proliant\pro_frontHP5SI" dXX??U} I} }  } $} } I1  @ @       q@  g@                          )cddddddddd* ) zddddddddd* )efffffffff* ) gfffffffff* ) |||||fffff* )hhhhhhhhhh* )iiiiiiiiii* ) } ~~~~~~~kk* ) ~~~~~~~kk*  )jkkkkkkkkk*  )  ~~~~~~~kk*  )lmmmmmmmmm*  )nooooooooo*  ) e mmmmmmmmm* )lmmmmmmmmm* ) ||||mmmmmm* ) ppppmmmmmm* ) | |ppmmmmmm* )qfffffffff* )qffffffff  { * ),-....-),-*+ * /0111102  /  0*+ *3445556789): * ;*<<?<@<@<@=@*  v  >): *?@@AAAB*  C  D): * EFGHHHI  J  K): *LFGHHHI*PQ): *LFGHHHI*  w. RHID %..B D.  ): *LFGHHHI*XY): *LFGHHHI*  w . R D %..B D.  ): *LFGHHHI*\Y): *LFGHHHI^  _ # y$/ %..B>  ): D- l"6"66""66"6""6"666"6$N$n:L$j$j$ @ !  " # $ % & ' ( ) * +  ,  - . / 0  * ( MMNNNO^*)): !* !s!t.!!! -?!t.!!t.!!t.!!t.!!R.!!^7)): "*STUVVVW**)): #* #E #FGHHHx*7)) $*LFGHHHx**)) %*LFGHHHI*))): &*LFGHHHI)))): '*LFGHHHI)))): (*LZZZZZ[)))): )*]MMMMMO)))): **]MMMMMO)))): +* +r+MMMMMO)))): ,) ,s,t!,,, -?,t!,,t!,,t!,,t!,,u!,,)))) -)STUVVVW)))) .) .` .a ... LL.a,..a,..a,..a,..b,..)))) /)))))))))))) 0)))))))))))) &{@8$6"$$$$$$8""( D @  dB @ s *D@  ]`a>@  2 7FyK yK http:///^yK yK *msbpz://-r:276DB158/yK yK zmsbptz://Exercise - Capital Budgeting for a New Product.xlt/^yK yK *msbpz://-r:276DB153/^yK yK *msbpz://-r:276DB155/