Capital Budgeting Investment Analysis Information On Old Asset Original Installed Cost Of Asset Net Working Capital Required For Asset Investment Tax Credit At 0.00% Economic Life Of Asset Years Depreciated Straight-Line Depreciation (Otherwise Enter Each Year Individually) Accumulated Depreciation Book Value Proceeds From Sale Of Old Asset Tax Effects Capital Gains Tax Rate Marginal Tax Rate Tax On Sale Of The Old Asset Recapture Of ITC Information On New Asset Cost Of New Asset Delivery And Installation Net Working Capital Required For Asset Investment Tax Credit % Depreciable Class Of Asset (Under MACRS) Class Enter 3-Year 2 5-Year 3 7-Year 4 10-Year 5 15-Year 6 20-Year 7 Economic Life Of New Asset For MACRS Enter Class Life + One Year For Straight-Line Enter Years Of Depreciation Salvage Value Of New Asset Depreciation Method (1) - Straight-Line (2) - MACRS Information On Real Property Original Cost Of Land Estimated Value At End Of Project Cost Of Building Class Of Property Enter 27.5 (Residential Rental Property) 1 39 (Nonresidential Real Property) 2 Month Building Is Placed In Service (1-12) Estimated Value At End Of Project Net Investment
$0 $0 $0 0 0 #DIV/0! $0 $0 $0 0.00% 0.00% $0 $0
$0 $0 $0 0.00% 0
0
$0 0
$0 $0 $0 0
0 $0 $0
Life Of The Project
0
Net Cash Flow Calculation 0 Growth Rate Cash Inflows Revenues With Project 0.00% Revenues Without Project 0.00% Incremental Revenue Cash Outflows Growth Rate Costs With Project 0.00% Cost Without Project 0.00% Incremental Cost Depreciation Depreciation On Building Depreciation With Project Depreciation Without Project Incremental Depreciation Incremental Earnings Before Taxes Taxes Recapture Of Asset Salvage Value Recapture Of Working Capital Recapture Of Land Salvage Value Recapture Of Building Salvage Value Additional Investment In Working Capital Net Cash Flow Summary Information Discount Rate Initial Guess For IRR Net Present Value IRR Profitability Index Payback (Years) Reinvestment Rate Gross Terminal Value Of Cash Flows Adjusted Net Present Value Adjusted Internal Rate Of Return Equivalent Annual Annuity Net Present Value (Infinite Chain) Certainty Equivalent Net Present Value Risk Free Rate Certainty Equivalent Factors Certainty Equivalent Cash Flows Certainty Net Present Value Cumulative Cash Flows 0.00% 0 $0 $0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0.00% 0.00% $0 #NUM! #DIV/0! 36 0.00% $0 $0
#DIV/0! #DIV/0! 1 2 3
0 $0 $0 $0
0 $0
0 $0
$0
$0
2
3
4
4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
4
5
6
7
8
9
10
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
$0
$0
$0
$0
$0
$0
$0
5
6
7
8
9
10
11
11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
11
12
13
14
15
16
17
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
$0
$0
$0
$0
$0
$0
$0
12
13
14
15
16
17
18
18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
18
19
20
21
22
23
24
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
$0
$0
$0
$0
$0
$0
$0
19
20
21
22
23
24
25
25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
26 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
28 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
25
26
27
28
29
30
31
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
0 $0
$0
$0
$0
$0
$0
$0
$0
26
27
28
29
30
31
32
32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
32
33
34
35
0 $0
0 $0
0 $0
0 $0
$0
$0
$0
$0
33
34
35
36