Building LCC Blank Form Past Project

Document Sample
Building LCC Blank Form Past Project Powered By Docstoc
					LIFE CYCLE COST CALCULATOR - Past Projects
              Version 2007




The Province of Nova Scotia is pleased to provide the attached Life Cycle
Costing Analysis (LCCA) Tool. This was developed in partnership with
Service Nova Scotia and Municipal Relations and the Municipal Finance
Corporation, with the assistance of a large number of Public Works officials
over a two year period.

This Past Projects version is a modified version of the tool that can be used for
the evaluation of past projects. It is important to note that this version of the
tool should never be submitted to SNSMR for funding applications. Inflation
and interest data is provided back to 1987 in a look-up table. When using this
tool for past projects the NPV calculated is for the start year entered (i.e. if
year of construction was 1992 then the NPV is calculated in 1992 dollars not
present day dollars). In addition, the user has to enter in values for
maintenance, operating cost, etc, in the starting year dollars and not in the
actual dollars for the year, they were incurred. The inflation and interest
data cells are all unlocked, and can be manipulated by the user at any time

The third party using this product shall be solely responsible for and shall
save harmless and indemnify Nova Scotia, its Ministers, officers, employees
and agents from and against all claims, liabilities and demands of any kind.
                            Building Life Cycle Cost Calculator - Past Project
                                               Version 2007
                                    Last Updated: October 31, 2007
                                                    0
                                             INSTRUCTIONS

This spreadsheet-based life cycle costing (LCC) tool is designed to assist municipalities with planning future infrastructure projects. The various
worksheet components of this tool can be accessed using the worksheet tabs located at the bottom of this page or by clicking the buttons on the
bottom left of this current worksheet.


           LCC Tool Legend:                         Value to be entered by user.

                                                    Value calculated based on input data

Please provide the general information requested below.

            PROJECT NAME:                                                                          *Upon completion of LCCA, please provide a
                                                                                                   brief explanation outlining the source of input
                  LOCATION:                                                                        data for the operations and maintenance costs
                                                                                                   provided (i.e.; historical costs, industry
     CONSTRUCTION YEAR: 0

            COMPLETED BY:

             ORGANIZATION:

      TELEPHONE NUMBER:

               FAX NUMBER:

           CONTACT EMAIL:



          LCC Results Summary
          LCC Results Summary                       This worksheet provides a one page summary of the input data and LCC results.


              LCC Input Data
              LCC Input Data                        Enter data as required. This is the only worksheet which requires data entry.


                  LCC Help
                  LCC Help                          This worksheet serves as a guidance document for the input data requirements.

       LCC Results Calculator
       LCC Results Calculator                       This worksheet performs the LCC operations and shows the annual output of this calculator.

  PVF and Inflation Factor data
  PVF and Inflation Factor data                     This worksheet computes a Present Value Factor (PVF) and Inflation factor based on historical


     Net Present Value Profile
     Net Present Value Profile                      Use this Figure to help interpret the results of the LCC Calculator.


  Annual Present Value Cash Flow
  Annual Present Value Cash Flow                    Use this Figure to help interpret the results of the LCC Calculator.
             Profile
              Profile

           Population Profile
           Population Profile                       Use this Figure to project future population levels
           Building Life Cycle Cost Calculator - Past Project
                                   0
                       LCC RESULTS SUMMARY
 GENERAL DATA

 Project Name:                                      0
 Location:                                          0
 Construction Year:                                 0
 Completed by:                                      0
 Organization:                                      0
 Telephone Number:                                  0
 Fax Number:                                        0
 Contact email:                                     0

 Year of Construction:                              0
 Life Cycle Period in years:                        0
 Applicable present value factor (%):               0.00%
 General price inflation factor (%):                0.00%



INVESTMENT DATA

 Installed Capital Cost (Present Day $)             $0
 Service life of investment in years                0
 Annual Energy costs                                $0
 Annual Operations costs (excluding Energy costs)   $0
 Annual Maintenance Costs                           $0
 Total Non-Annual Replacement or Repair Costs       $0



LCC RESULTS SUMMARY

 Net Present Value                                  $0
 Cost/Benefit Metrics
           NPV/person                               #DIV/0!
           NPV/m2                                   #DIV/0!
           Capital Cost/person                      #DIV/0!
                              Building Life Cycle Cost Calculator - Past Project                                                                        Present Day

                                                      0                                                                                                 Future

                                              LCC INPUT DATA                                                                                                          1


PROJECT INFORMATION

Construction Year:

Life Cycle Period in years:                                                                    Yearly Population Growth or Decline in Percentage
Applicable present value factor (%):                                             0.00%                            Year 1 to 5: 1.0%    Year 15 to 20:

General price inflation factor (%):                                              0.00%                         Year 5 to 10:          Year 20 and on:
                      2
Building Footprint (m ):                                                                                      Year 10 to 15:
                                                                                          Present Day
Population Served by New Infrastructure:                                                                           Comment:



CAPITAL COSTS

                                                                                                        Total Cost ($)

Engineering Design Services:

Construction Costs:
                                      Land Acquisition
                                      Site Works
                                      Building Envelope

                                      Electrical

                                                          Electrical Service/Generation
                                                          Electrical Distribution
                                                          Electrical Lighting
                                                          Electrical Equipment

                                      Mechanical
                                                          HVAC

                                                          Plumbing
                                                          Fire Protection Systems
                                                          Control System

                                                          Other
                                                          Other
                                      Other

                                      Other
                                      Other

                                      Contingency                                                            $0
Total Capital Costs:                                                                                         $0
                               Building Life Cycle Cost Calculator - Past Project      Present Day

                                                       0                               Future

                                               LCC INPUT DATA                                        1



       ANNUAL OPERATING COSTS

       Item                                          Total Cost ($)
       Electricity
       Heating Fuel

       Water and Sewer
       Garbage Disposal
       Custodial Services
       Grounds
       Insurance

       Overhead

       Other
       Other
       Total Operating Costs                               $0



       ANNUAL MAINTENANCE AND REPAIR COSTS
Item                                             Total Cost per Item ($)
                                                                             Comment
Interior Maintenance and Repairs
Roof System
Elevators
Plumbing
Fire Protection Systems

HVAC Maintenance and Repairs

Electrical Maintenance and Repairs
Equipment
Other
Other

Other
Other

Total Annual Maintenance Costs                             $0
                                                    Building Life Cycle Cost Calculator - Past Project                                              Present Day

                                                                            0                                                                       Future

                                                                    LCC INPUT DATA                                                                                1



                          NON-ANNUAL REPLACEMENT OR UPGRADE COSTS

                                                                                  Comment              Total Replacement Cost
                          Items in year X                                                                                       Year Incurred (X)
                                                                                                       ($)
                  1    Site Utilities

                  2    Exterior Doors

                  3    Other

                  4    Other

                  5    Other

                  6    Other

                  7    Other

                  8    Other

                  9    Other

                 10    Other

                 11    Other

                 12    Other

                 13    Other

                 14    Other

                 15    Other

                 16    Other

                 17    Other

                 18    Other

                 19    Other

                 20    Other

                 21    Other

                 22    Other

                 23    Other

                 24    Other

                 25    Other

                                                        Total Non-Annual Replacement or Repair Costs              $0




                          COST/ BENEFIT METRICS

                          Item                          Quantity                Output
                          Population                               0            NPV/person
                                               2                                         2
                          Building Footprint (m )                  0            NPV/m

                          Total Households Served                               NPV/household
                          Population                               0            Capital Cost/person
                          Other                                                 NPV/other
                          Other                                                 NPV/other




                                                    4
Other
Site Improvements                                   9
Site Utilities                                      8
Foundation/ Substructure                            1
Superstructure                                      1
Exterior Wall System                                1
Exterior Windows                                    1
Exterior Doors                                      1
Roof Systems                                        1
Interior Partitions                                 1
Interior Doors                                      1
Interior Floor Finishes                             1
Interior Wall Finishes                              1
Interior Ceiling Finishes                           1
Conveyance System                                   1
Plumbing Piping                                     1
Plumbing Fixtures                                   1
Fire Protection Services                            1
HVAC Equipment                                      1
HVAC Distribution                                   1
HVAC Controls                                       1
Electrical Lighting                                 1
Electrical Service/ Generation                      1
Electrical Distribution                             1
Equipment                                           1
                                                    1
                                                    1
                                                    1
                           Building Life Cycle Cost Calculator - Past Project
                                                   0
                                               LCC HELP
                        Item                                                     Help Comment

                                                Enter the year the past project began construction. The year must be 1987 or
Year of Construction                            after to utilize the lookup table available in program. See the instruction manual
                                                to overwrite the interest and inflation rates for earlier projects.

                                                Based on the Debenture Interest Rate from the Nova Scotia Municipal Finance
Applicable Present Value Factor (PVF) (%)       Corporation for the year corresponding to the initital date of your past project.
                                                This number is excerpted from the Interest & Inflation Rate Data sheet attached.

                                                Based on the Debenture Interest Rate from the Nova Scotia Municipal Finance
Applicable Present Value Factor (PVF) (%)       Corporation for the year corresponding to the initital date of your past project.
                                                This number is excerpted from the Interest & Inflation Rate Data sheet attached.

                                                Based on the Consumer price Index (CPI) for the year corresponding to the
General Price Inflation Factor (%)              initital date of your past project. This number is excerpted from the Interest &
                                                Inflation Rate Data sheet attached.


Capital Cost Total Costs                        This column includes the total lump sum construction costs for each item listed.


Site Works                                      Includes the earthworks, paving, landscaping, water and sewer services, etc.


                                                Includes all costs associated with the foundation/ sub-structure and
Building Envelope
                                                superstructure such as construction materials, framework, windows, doors, etc.

                                                Includes all costs associated with the upkeep of the exterior property such as
Grounds
                                                landscaping, repaving, clean-up, etc.

                                                The drop down menus contain a list of typical items to be replaced within the life
                                                of the building. Some are quite general due to the nature of this tool. The
Items in Year X                                 comment box to the right of each cell can be used to provide more detail, if
                                                required. If there is an item specific to the new infrastructure that is not in the
                                                drop down box, please select the "other" option and use the comment box to
                                                provide the item description.
                                                Enter the present day value of replacement cost, price will automatically be
Total Replacement Cost ($)
                                                inflated in output.


Year Incurred                                   Multiple non-annual replacements are possible within same year.


                                                Any additional cost/benefit measurement metrics added by the user will not be
Other
                                                displayed on the LCC Summary page.

                                                Calculator assumes initial capital expenditure occurs at beginning of year 1 and
Initial Capital Expenditure
                                                cost/payments accrue at end of year.

                                                Includes site investigation, construction management and design services
Engineering Design Services
                                                associated with the new infrastructure.

                                                Please insert the percentage typically used for contingency into the box provided
Contingency
                                                and the contingency will be calculated and added to the total capital costs.

                                                Please insert the present day population or future population that is to be served
Population Served                               by the new infrastructure. If future population, provide information on percentage
                                                of growth in comment box.

                                                Is the expected life span of infrastructure prior to replacement. Typical Building
Life Cycle Period                               Lifespan is 30-50 years.
                                                                                                       Building Life Cycle Cost Calculator - Past Project
                                                                                                                               0
                                                                                                                 LCC RESULTS CALCULATOR
                                                     Project Initiation year                       0
                                                 Present Value Factor (%)                      0.00%
                                                General Price Inflation (%)                    0.00%
                                                     Study Period (years)                          0

                          Initial Capital
                                                                                                                                                                                                                                                          Present Value                                 Cumulative Cash Flow
                           Expenditure                                         Annual Fuel or Energy        Annual Maintenance       Replacement Costs
Year        Population                           Annual Operating Costs                                                                                            Replacement Costs            Cash Flow                     Present Value Factor         (Cash Flow             Net Present Value       (without present
                                                                                       Costs                       Costs             (Present Day Value)
                                                                                                                                                                                                                                                            per year)                                       value factor)

        0           0 $                     -                                                                                                                                              $                     -                           1.0000   $                   -   $                   -    $                  -
 0      1           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 1      2           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 2      3           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 3      4           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 4      5           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 5      6           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 6      7           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 7      8           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 8      9           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
 9     10           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
10     11           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
11     12           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
12     13           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
13     14           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
14     15           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
15     16           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
16     17           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
17     18           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
18     19           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
19     20           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
20     21           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
21     22           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
22     23           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
23     24           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
24     25           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
25     26           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
26     27           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
27     28           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
28     29           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
29     30           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
30     31           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
31     32           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
32     33           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
33     34           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
34     35           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
35     36           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
36     37           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
37     38           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
38     39           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
39     40           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
40     41           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
41     42           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
42     43           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
43     44           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
44     45           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
45     46           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
46     47           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
47     48           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
48     49           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -
49     50           0                            $                     -       $                 -      $                   -    $                         -   $                       -   $                         -                       1.0000   $                   -   -                        -

                                                                                                                                                                                                   NPV                    $                     -                                            Cost/Benefit Metrics
                                                                                                                                                                                               5 yr life span            -                                                    NPV/person                        #DIV/0!
                                                                                                                                                                                               10 yr life span           -                                                    NPV/m2                            #DIV/0!
                                                                                                                                                                                               15 yr life span           -                                                    NPV/household                     #DIV/0!
                                                                                                                                                                                               20 yr life span           -                                                    Capital Cost/person               #DIV/0!
                                                                                                                                                                                               25 yr life span           -                                                    NPV/other                         #DIV/0!
                                                                                                                                                                                               30 yr life span           -                                                    NPV/other                         #DIV/0!
                                                                                                                                                                                               35 yr life span           -
                                                                                                                                                                                               40 yr life span           -
                                                                                                                                                                                               45 yr life span           -
                                                                                                                                                                                               50 yr life span           -
                                 General Note:
Building Life Cycle Cost Calculator - Past Project
                        0
         INTEREST & INFLATION DATA

     Average Inflation Rate        Most Recent Debenture Interest Rate
                  Average                        Debenture Interest
      Year       CPI/Inflation        Year              Rate
                     Rate                        (Municipal Finance
                                                    Corporation)
      1987            4.40              1987             8.70
      1988            3.90              1988            10.80
      1989            5.10              1989            11.20
      1990            4.80              1990            12.10
      1991            5.60              1991             9.90
      1992            1.40              1992             8.40
      1993            1.90              1993             7.60
      1994            0.10              1994             9.20
      1995            2.20              1995             8.10
      1996            1.50              1996             7.43
      1997            1.70              1997             6.30
      1998            1.00              1998             5.40
      1999            1.80              1999             5.90
      2000            2.70              2000             6.50
      2001            2.50              2001             5.54
      2002            2.20              2002             5.26
      2003            2.80              2003             4.68
      2004            1.80              2004             4.51
      2005            2.20              2005             4.46
      2006            2.00              2006             4.60
      2007                              2007             4.64
      2008                              2008
      2009                              2009
      2010                              2010
      2011                              2011
      2012                              2012
      2013                              2013
      2014                              2014
      2015                              2015
      2016                              2016
      2017                              2017
      2018                              2018
      2019                              2019
      2020                              2020
                                                  Building Life Cycle Cost Calculator- Past Project
                                                         Figure 1: Net Present Value Profile

                    $1                                                                                     1


                    $1                                                                                     1


                    $1                                                                                     1


                    $1                                                                                     1
Net Present Value




                    $1                                                                                     1




                                                                                                               Population
                    $1                                                                                     1


                    $0                                                                                     0


                    $0                                                                                     0


                    $0                                                                                     0


                    $0                                                                                     0


                    $-                                                                                     0
                         0   2   4   6   8   10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48
                                                                                                                        Net Present Value
                                                                   Month
                                                                                                                        Population
                               Building Life Cycle Cost Calculator - Past Project
                               Figure 2: Annual Present Value Cash Flow Profile


                          $1
                               *Note: Initial Capital Expenditure in Year 1 is not displayed on chart.

                          $1


                          $1


                          $1
Present Value Cash Flow




                          $1


                          $1


                          $0


                          $0


                          $0


                          $0


                          $-


                                                             Year
                 Buidling Life Cycle Cost Calculator - Past Project
                                Figure 3: Population


             1



             1



             1



             1



             1
Population




             1



             0



             0



             0



             0



             0


                                    Year

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:7/27/2012
language:
pages:15