Capital_Budgeting_Investment_Analysis by xiaoyounan

VIEWS: 6 PAGES: 11

									                                    Capital Budgeting Investment Analysis

Information On Old Asset
Original Installed Cost Of Asset                                                                $0
Net Working Capital Required For Asset                                                          $0
Investment Tax Credit At                                            0.00%                       $0
Economic Life Of Asset                                                                            0
Years Depreciated                                                                                 0
Straight-Line Depreciation (Otherwise Enter Each Year Individually)                 #DIV/0!
Accumulated Depreciation                                                                        $0
Book Value                                                                                      $0
Proceeds From Sale Of Old Asset                                                                 $0
Tax Effects
    Capital Gains Tax Rate                                                  0.00%
    Marginal Tax Rate                                                       0.00%
Tax On Sale Of The Old Asset                                                                    $0
Recapture Of ITC                                                                                $0

Information On New Asset
Cost Of New Asset                                                                                $0
Delivery And Installation                                                                        $0
Net Working Capital Required For Asset                                                           $0
Investment Tax Credit %                                                                       0.00%
Depreciable Class Of Asset (Under MACRS)                                                           0
    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                                                                        0
    For MACRS Enter Class Life + One Year
    For Straight-Line Enter Years Of Depreciation
Salvage Value Of New Asset                                                                      $0
Depreciation Method                                                                               0
    (1) - Straight-Line
    (2) - MACRS
Information On Real Property
Original Cost Of Land                                                                           $0
Estimated Value At End Of Project                                                               $0
Cost Of Building                                                                                $0
Class Of Property                                 Enter                                           0
    27.5 (Residential Rental Property)             1
    39 (Nonresidential Real Property)              2
Month Building Is Placed In Service (1-12)                                                        0
Estimated Value At End Of Project                                                               $0
Net Investment                                                                                  $0

Life Of The Project                                                                               0
Net Cash Flow Calculation                         0              1     2     3
Cash Inflows                          Growth Rate
    Revenues With Project                     0.00%              0     0     0
    Revenues Without Project                  0.00%              0     0     0
    Incremental Revenue                                          0     0     0
Cash Outflows                         Growth Rate
    Costs With Project                        0.00%              0     0     0
    Cost Without Project                      0.00%              0     0     0
    Incremental Cost                                             0     0     0
Depreciation
    Depreciation On Building                                     0     0     0
    Depreciation With Project                                    0     0     0
    Depreciation Without Project                                 0     0     0
    Incremental Depreciation                                     0     0     0
Incremental Earnings Before Taxes                                0     0     0
Taxes                                                            0     0     0
Recapture Of Asset Salvage Value                                 0     0     0
Recapture Of Working Capital                                     0     0     0
Recapture Of Land Salvage Value                                  0     0     0
Recapture Of Building Salvage Value                              0     0     0
Additional Investment In Working Capital                         0     0     0

Net Cash Flow                                  $0               $0    $0    $0

Summary Information
Discount Rate                                             0.00%
Initial Guess For IRR                                     0.00%
Net Present Value                                             $0
IRR                                                   #NUM!
Profitability Index                                   #DIV/0!
Payback (Years)                                                36

Reinvestment Rate                                          0.00%
Gross Terminal Value Of Cash Flows                            $0
Adjusted Net Present Value                                    $0
Adjusted Internal Rate Of Return

Equivalent Annual Annuity                             #DIV/0!
Net Present Value (Infinite Chain)                    #DIV/0!

Certainty Equivalent Net Present Value                           1     2     3

Risk Free Rate                               0.00%
Certainty Equivalent Factors                      0               0     0     0
Certainty Equivalent Cash Flows                 $0              $0    $0    $0

Certainty Net Present Value                                     $0

Cumulative Cash Flows                                           $0    $0    $0
                                                                  2     3     4
 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

 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     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     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    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

 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     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     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    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

 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     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     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    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

 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     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     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    33    34    35

 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
 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




32    33    34    35


  0     0     0     0
$0    $0    $0    $0




$0    $0    $0    $0
 33    34    35    36
MACRS Table
Recovery Year

          1
          2
          3
          4
          5
          6
          7
          8
          9
         10
         11
         12
         13
         14
         15
         16
         17
         18
         19
         20
         21
         22
         23
         24
         25
         26
         27
         28
         29
         30
         31
         32
         33
         34
         35
MACRS Table                                                             MACRS Straight Line (27.5)
Recovery Year                                                           Month of First
                     3        5        7        10       15        20   Year the Property
                33.33%   20.00%   14.29%   10.00%    5.00%    3.750%    Is Placed in Service
                44.45%   32.00%   24.49%   18.00%    9.50%    7.219%
                14.81%   19.20%   17.49%   14.40%    8.55%    6.677%
                 7.41%   11.52%   12.49%   11.52%    7.70%    6.177%
                         11.52%    8.93%    9.22%    6.93%    5.713%
                          5.76%    8.92%    7.37%    6.23%    5.285%
                                   8.93%    6.55%    5.90%    4.888%
                                   4.46%    6.55%    5.90%    4.522%
                                            6.56%    5.91%    4.462%
                                            6.55%    5.90%    4.461%
                                            3.28%    5.91%    4.462%
                                                     5.90%    4.461%
                                                     5.91%    4.462%
                                                     5.90%    4.461%
                                                     5.91%    4.462%
                                                     2.95%    4.461%
                                                              4.462%
                                                              4.461%
                                                              4.462%
                                                              4.461%
                                                              2.231%
MACRS Straight Line (27.5)                                                   MACRS Straight Line (39)
Month of First                                                               Month of First
Year the Property                         Recovery Years                     Year the Property          R
Is Placed in Service             1       2          28         29       30   Is Placed in Service
                      1      3.48%   3.64%      1.88%      0.00%    0.00%                          1
                      2      3.18%   3.64%      2.18%      0.00%    0.00%                          2
                      3      2.88%   3.64%      2.48%      0.00%    0.00%                          3
                      4      2.58%   3.64%      2.78%      0.00%    0.00%                          4
                      5      2.27%   3.64%      3.09%      0.00%    0.00%                          5
                      6      1.97%   3.64%      3.39%      0.00%    0.00%                          6
                      7      1.67%   3.64%      3.64%      0.05%    0.00%                          7
                      8      1.36%   3.64%      3.64%      0.36%    0.00%                          8
                      9      1.06%   3.64%      3.64%      0.66%    0.00%                          9
                     10      0.76%   3.64%      3.64%      0.96%    0.00%                         10
                     11      0.45%   3.64%      3.64%      1.27%    0.00%                         11
                     12      0.15%   3.64%      3.64%      1.57%    0.00%                         12
        Recovery Years
    1        2           40       41
2.46%    2.56%       0.11%    0.00%
2.24%    2.56%       0.32%    0.00%
2.03%    2.56%       0.53%    0.00%
1.82%    2.56%       0.75%    0.00%
1.60%    2.56%       0.96%    0.00%
1.39%    2.56%       1.18%    0.00%
1.18%    2.56%       1.39%    0.00%
0.96%    2.56%       1.60%    0.00%
0.75%    2.56%       1.82%    0.00%
0.53%    2.56%       2.03%    0.00%
0.32%    2.56%       2.24%    0.00%
0.11%    2.56%       2.46%    0.00%

								
To top