ࡱ> tw  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsvR Fdu@WorkbookSummaryInformation(DocumentSummaryInformation8 > `\p Compositor Ba==$18X@"1Tms Rmn1Geneva1Geneva1Geneva1Geneva1Tms Rmn1Tms Rmn"$"#,##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\);_(* "-"??_);_(@_) 0.0% 0.000% 0.0000000 0.000000 0.00000 0.0000 0.000#,##0.0_);[Red]\(#,##0.0\)##,##0.000_);[Red]\(#,##0.000\)% #,##0.0000_);[Red]\(#,##0.0000\)'"#,##0.00000_);[Red]\(#,##0.00000\)                ( &    &8f@  8f@      A &  1  " " &  ,` 1 (`   &8  ,  ( &8 &8  (` A  8  8    @  &  0    & L   & H ` CAPBUDG.XLT1 Accumulated_MACRS_Table=%D?/ Cumulative_Cash_Flows;01 -* MACRS_27.5_Table;AF( MACRS_39_Table;HL% MACRS_Table;%8>  ;8-p h`Recapture of Working CapitalRecapture of Land Salvage Value#Recapture of Building Salvage Value(Additional Investment in Working CapitalInitial Guess for IRR"Gross Terminal Value of Cash Flows Adjusted Internal Rate of Return%Capital Budgeting Investment AnalysisNet Cash Flow Calculation MACRS TableMACRS Straight Line (27.5)MACRS Straight Line (39) Cash Inflows Growth Rate Recovery YearMonth of FirstYear the PropertyRecovery YearsIs Placed in ServiceIncremental RevenueInvestment Tax Credit At Cash OutflowsYears DepreciatedCStraight-Line Depreciation (Otherwise Enter Each Year Individually)Incremental CostAccumulated Depreciation Depreciation Book Value Tax EffectsCapital Gains Tax RateIncremental DepreciationMarginal Tax Rate!Incremental Earnings Before TaxesTaxesInvestment Tax Credit % Net Cash FlowClassEnterSummary Information3-Year Discount Rate5-Year7-YearNet Present Value10-YearIRR15-YearProfitability Index20-YearPayback (Years)%For MACRS Enter Class Life + One YearReinvestment RateAdjusted Net Present ValueDepreciation Method(1) - Straight-Line (2) - MACRSEquivalent Annual Annuity"Net Present Value (Infinite Chain)&Certainty Equivalent Net Present ValueRisk Free Rate"27.5 (Residential Rental Property)Certainty Equivalent Factors!39 (Nonresidential Real Property)Certainty Equivalent Cash FlowsCertainty Net Present ValueNet InvestmentCumulative Cash FlowsInformation on Old Asset Original Installed Cost of Asset&Net Working Capital Required for AssetEconomic Life of AssetProceeds from Sale of Old AssetTax on Sale of the Old AssetRecapture of ITCInformation on New AssetCost of New AssetDelivery and Installation(Depreciable Class of Asset (Under MACRS)Economic Life of New Asset-For Straight-Line Enter Years of DepreciationSalvage Value of New AssetInformation on Real PropertyOriginal Cost of Land!Estimated Value at End of ProjectCost of BuildingClass of Property*Month Building Is Placed in Service (1-12)Life of the ProjectRevenues with ProjectRevenues without ProjectCosts with ProjectCost without ProjectDepreciation on BuildingDepreciation with ProjectDepreciation without Project Recapture of Asset Salvage ValueZ &8 !n !=8(mp"f 8Pt!Dw88p8 8!=(#گ;8o8h8ٶ!D !88#8 8 8H  ۔8$8 8!yepA۔ 8۔8;8 8!D4808 ACRS_TablebleleFlowsle!D|8!Dz88888 8x>!yeٶp""!D{a!Dz8H88H"j!Dw"p8 88H"8p8 8"pp Print_Area_AreatI08>!Ds(8t8(ٶp"8!DwO8p8Ppppp8p"!D|78ppٶp8p۔p8 گ33۔3  33ٶpA۔I0B`W8ٶpA۔? 3 3گ8x!x >  $Xj  dMbP?_*+%&?'?Mz,, ` } #(,, `,-^&'zNdA"d??U } } } }  } } } } -3 } . XX|LXXĝ XpXPXlMGXXVXP XH XV XH< X XTQXX??`?p??(G???p?`?`??????    ?@@@@@@ @"@$@&@(@*@,@.@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@@@A@A@- 8 @ G    8% @%A%%%%%%F G%H%%%%%L C  X -.  .  < -"2LD1 LD  B . . . . . . . . . . . . . . . . . . .   .! !." ".# #.$ $.% %.& &.' '.( (.) ).* *.+ +., ,.- -.  8(*9(@(@(@($@(.@(4@> @ B&C''''F G I&J'''+M D~ /  Y -.  .  < -"2LD1 LD  B . . . . . . . . . . . . . . . . . . .   .! !." ".# #.$ $.% %.& &.' '.( (.) ).* *.+ +., ,.- -.  ~ 8?9ioT?~ :4@;_LJ?<$@@)@> @(A($B(?(@(<@(=@(>@F G(H(I(?(@(D@(D@LM%S%%%%%W E~ /      -# LL                         ! !" "# #$ $% %& &' '( () )* *+ +, ,- -I ~ 8@9 r?~ :@@;+eX?<2@#@=>)B&9 {?~ A?B5;Nѡ?C&S?DUN@?EF~ H?I))?JI*II  L? 'JAA?KJJJ 'KQ?LKKK L&LLL$LL L&LLM ~ -!I DD    ~ 8@9D?:~jt?; c?<;On?=S?>)Z?~ A@BH?C&S?D46)qrCQ?~ A@BH}?C&S?Da+e?EF~ H@ILɔLɔ?JIJAA?KJK^^u?LKL LM ~ 0  [ -.  .  < -"2LD1 LL  B . . . . . . . . . . . . . . . . . . .   .! !." ".# #.$ $.% %.& &.' '.( (.) ).* *.+ +., ,.- -.I ~ 8@:H}?;ec]ܶ?<|Pk?=v?>)=$@?~ A@B{Pk?C&S?DPkw?EF~ H@I))?JIJAA?KJK~?LKLLM ! DD      -# LL                         ! !" "# #$ $% %& &' '( () )* *+ +, ,- -I ~ 8@:H}?;ͪն?<Y޲?=?>)W/'?~ A@Bz6>?C&S?D??EF~ H@Iii?JIJAA?KJK;;?LKL ILM ~ / ~ 8@ ;ec]ܶ? <S㥛İ? =h|?5? >)aۢ?~ A@ B<,? C&S? Dz6>W[? EF~ H@ Iqq? JI JAA? KJ K@? LK L L M = 2 'D DD B \ 1   -#LD1 sD* !L#D-BeD)@D* !L#D-BeD) "" B 1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1   1 !  !1 "  "1 #  #1 $  $1 %  %1 &  &1 '  '1 (  (1 )  )1 *  *1 +  +1 ,  ,1 -  -1 I ~ 8 @ ;ͪզ? <S㥛İ? =h|?5? >)@j'?~ A@ Bo_? C&S? D&S? EMb@?~ F~ H@ I? JI JAA? KJ K@qq? LK L L M G~ / ] 3   -#LD gD# <L#$BfDDDDDDDD" B 3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3 !  !3 "  "3 #  #3 $  $3 %  %3 &  &3 '  '3 (  (3 )  )3 *  *3 +  +3 ,  ,3 -  -3 I ~ 8"@ ;, < ^)˰? =cZB? >)~nئ?~ A @ B_Qڋ? C&S? D&S? EH}m?~ F~ H @ I;;? JI JAA? KJ Kii? LK L L M  ^ 3  V -#LDD 2LDD  $ " B 3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3   3 !  !3 "  "3 #  #3 $  $3 %  %3 &  &3 '  '3 (  (3 )  )3 *  *3 +  +3 ,  ,3 -  -3 I ~ 8$@ <S㥛İ? =h|?5? >),&6צ?~ A"@ Bgs? C&S? D&S? EF%u{?~ F~ H"@ I~? JI JAA? KJ K))? LK L L M ~ -     -#LLL                                                              !  ! "  " #  # $  $ %  % &  & '  ' (  ( )  ) *  * +  + ,  , -  - I ~ 8&@ < ^)ˠ? =cZB? >)~nئ?~ A$@ Bŏ1w-!? C&S? D&S? Ea2U0*?~ F~ H$@ I^^u? JI JAA? KJ KLɔLɔ? LK L L M ~ -      -#LLL                         ! !" "# #$ $% %& &' '( () )* *+ +, ,- -I ~ 8(@=h|?5?>),&6צ?~ A&@B;Onr?C&S?D&S?E F%u?~ F~ H&@IAAj?JIJAA?KJKoo?LKLLM H pD  [D D D D D-D DD DD D"B !    -# LD                         ! !" "# #$ $% %& &' '( () )* *+ +, ,- -I ~ 8*@=cZB?>)~nئ?~ A(@B~jtX?C&S?D&S?E2U0*?~ F~ H(@IQ?JIJAA?KJK))?LKL LM I~ / _   D D1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B   D D1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B  D D1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B  DD1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B  !D D1 D"DD qD"DDD DD% DDDD% 7)DODD% aPD"DD% D" B !"D!D1 D"DD qD"DDD DD% !DDDD% !7)DODD% !aPD"DD% !D" B "#D"D1 D"DD qD"DDD DD% "DDDD% "7)DODD% "aPD"DD% "D" B #$D#D1 D"DD qD"DDD DD% #DDDD% #7)DODD% #aPD"DD% #D" B $%D$D1 D"DD qD"DDD DD% $DDDD% $7)DODD% $aPD"DD% $D" B %&D%D1 D"DD qD"DDD DD% %DDDD% %7)DODD% %aPD"DD% %D" B &'D&D1 D"DD qD"DDD DD% &DDDD% &7)DODD% &aPD"DD% &D" B '(D'D1 D"DD qD"DDD DD% 'DDDD% '7)DODD% 'aPD"DD% 'D" B ()D(D1 D"DD qD"DDD DD% (DDDD% (7)DODD% (aPD"DD% (D" B )*D)D1 D"DD qD"DDD DD% )DDDD% )7)DODD% )aPD"DD% )D" B *+D*D1 D"DD qD"DDD DD% *DDDD% *7)DODD% *aPD"DD% *D" B +,D+D1 D"DD qD"DDD DD% +DDDD% +7)DODD% +aPD"DD% +D" B ,-D,D1 D"DD qD"DDD DD% ,DDDD% ,7)DODD% ,aPD"DD% ,D" B - D-D1 D"DD qD"DDD DD% -DDDD% -7)DODD% -aPD"DD% -D" B~ 8,@=h|?5?>),&6צ? 9  #D D1  $ B?  )D D1 DD  BG 1D D1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG1DD1 D%  BG 1DD1 D%  BG !1D D1 D%  BG!"1D!D1 D%  BG"#1D"D1 D% ! BG#$1D#D1 D% " BG$%1D$D1 D% # BG%&1D%D1 D% $ BG&'1D&D1 D% % BG'(1D'D1 D% & BG()1D(D1 D% ' BG)*1D)D1 D% ( BG*+1D*D1 D% ) BG+,1D+D1 D% * BG,-1D,D1 D% + BG- 1D-D1 D% , B~ 8.@=cZB?>)~nئ? J    @ -#6LD1 D(D(D'D  B                         ! !" "# #$ $% %& &' '( () )* *+ +, ,- -  ~ 80@=h|?5?>),&6צ? K~ /   D D1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" B  D D1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" B D D1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" BDD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" B DD1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" B !D D1 D.D)% -  $.D.D)% - *D.D)% -D.DgD.D) 0D.D)D D)% -B D D)D)% -""" B!"D!D1 D.D)% !-  $.D.D)% !- *D.D)% !-D.DgD.D) 0D.D)D D)% !-B D D)D)% !-""" B"#D"D1 D.D)% "-  $.D.D)% "- *D.D)% "-D.DgD.D) 0D.D)D D)% "-B D D)D)% "-""" B#$D#D1 D.D)% #-  $.D.D)% #- *D.D)% #-D.DgD.D) 0D.D)D D)% #-B D D)D)% #-""" B$%D$D1 D.D)% $-  $.D.D)% $- *D.D)% $-D.DgD.D) 0D.D)D D)% $-B D D)D)% $-""" B%&D%D1 D.D)% %-  $.D.D)% %- *D.D)% %-D.DgD.D) 0D.D)D D)% %-B D D)D)% %-""" B&'D&D1 D.D)% &-  $.D.D)% &- *D.D)% &-D.DgD.D) 0D.D)D D)% &-B D D)D)% &-""" B'(D'D1 D.D)% '-  $.D.D)% '- *D.D)% '-D.DgD.D) 0D.D)D D)% '-B D D)D)% '-""" B()D(D1 D.D)% (-  $.D.D)% (- *D.D)% (-D.DgD.D) 0D.D)D D)% (-B D D)D)% (-""" B)*D)D1 D.D)% )-  $.D.D)% )- *D.D)% )-D.DgD.D) 0D.D)D D)% )-B D D)D)% )-""" B*+D*D1 D.D)% *-  $.D.D)% *- *D.D)% *-D.DgD.D) 0D.D)D D)% *-B D D)D)% *-""" B+,D+D1 D.D)% +-  $.D.D)% +- *D.D)% +-D.DgD.D) 0D.D)D D)% +-B D D)D)% +-""" B,-D,D1 D.D)% ,-  $.D.D)% ,- *D.D)% ,-D.DgD.D) 0D.D)D D)% ,-B D D)D)% ,-""" B- D-D1 D.D)% --  $.D.D)% -- *D.D)% --D.DgD.D) 0D.D)D D)% --B D D)D)% --""" B~ 81@>)~nئ? L~ /  ...................................-~ 82@>),&6צ? E~ /~ 83@>)~nئ? "~ -! #  D/   / -#%LLL-L                                           ! ! " " # # $ $ % % & & ' ' ( ( ) ) * * + + , , - -   ~ 84@>),&6צ? M~ 0~ 85@>)~nؖ? $ % &~ 86@ '~ @ (~  -~ 87@ )~ @   D ~ 88@ *~ @ +. ! D D % -B ~ 89@ ,~ @ -# ,G$n\ % -B>~ 8:@ .~ @ /" "'0 D D ~ 8;@ 0~ @ 1( B@! D #Be~ 8<@ N~ 0~ 8=@DlJp$mn@&i%k )&&F<BZatihn 9|L!9"9ĝ#9@$9P%9lMG&9'9V(9P)9H*9V+9H<,9-9TQ.9/9 0.1.`2.p3.4.(G6.8.9.p 2 3~ -~ 8>@ !O !! ! ! !7!! " )e -d de -+~ !8?@ "P~ "/ "42" % D D! D D~ "8@@ #5~ #0# #~ #8@@ $6~ $8A@ %7 %89% .D& #D D DB8~ %8A@ &Q &9!& ~Ō, D% D  'R~ '/' (S~ (/( (*: ( ** ( *?*@*@*@*@*@*@* @*"@*$@*&@*(@**@*,@*.@*0@*1@*2@*3@*4@*5@*6@*7@*8@*9@*:@*;@*<@*=@*>@*?@*@@*@@*A@*A@- )T~ )/) *U *%~ ** *;~ * - +<~ +? +=+ 000000000000000000000000000000000000- ,>~ ,@ ,?, , , ,, -$ LL, , , , , , , ,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,,, ,, , , ,!, ,!,", ,",#, ,#,$, ,$,%, ,%,&, ,&,', ,',(, ,(,), ,),*, ,*,+, ,+,,, ,,,-, ,-. , -V~ -0 .S~ ./. .@.. !/D, D* %,, -B  /AK/0 5DDDD DDDD'D)/0# 0B=0 !0 'D( D  $  B0 !0 0 700 -"-LD LL B0 !00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!00 0!0 0 0 !0!0 0!!0"0 0"!0#0 0#!0$0 0$!0%0 0%!0&0 0&!0'0 0'!0(0 0(!0)0 0)!0*0 0*!0+0 0+!0,0 0,!0-0 0-! 0 1W~ 101 @@@@@@ @"@$@&@(@*@,@.@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@@@A@A@B@-23468$9$4D8nBgA&&P fg y|Lz{ĝ|@}P~lMGy%z{|}~x |Lĝ@PlMGVPH, >@888   Oh+'08@Th ' Compositor  Compositor Microsoft Excel@yH  ՜.+,D՜.+,  PXx  'OffCenter Concept Houseb  CAPBUDG.XLT  Worksheets 6> _PID_GUID'AN{C2ACE282-47AE-11D6-BC48-0050E4D08274} FMicrosoft Excel Worksheet8FIBExcel.Sheet.8CompObj X