Real Property / Strategic Financial Analysis
Base Analysis Metrics: Summary and Calculations
The following table summarizes the base analysis metrics that sum values for the current fiscal year. Many analysis metrics also have associated ratios – for example, Energy Cost per Gross Area – which allow analysts to normalize out the size of a facility or the number of occupants so that they can compare different facilities on an even-performance basis.
Analysis Metric | Metric Title | Prorations~ Applies To | Description | Business Relevance | Calculation | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total Cost Metrics |
|||||||||||||||||||||||||||||||||
(fin_tc_occ_an_fy ) |
TCO-Occupancy (fy) |
Buildings Properties |
Sums operating costs related to occupancy, including maintenance, custodial, security, energy and utilities, property taxes, rent, and direct services. compare occupied properties on an even basis with a focus on operating costs and improving operational efficiency. |
Compare performance of rented spaces on an even basis. Benchmark occupancy costs for each category against published standards for these costs to see what occupancy costs are outside of the norm for your industry and building type. This information allows you to focus cost reduction efforts to the most likely practical areas for reduction. |
For the given fiscal year and asset sum the values from the other comma-delimited columns specified in the AbRPLMStrategicFinancialAnalysis-UpdateTCO-OccupancyCosts application parameter. These columns default to:
|
||||||||||||||||||||||||||||
(fin_tc_occ_an_fy ) |
TCO-Ownership (fy) |
Buildings Properties |
Sums TCO-Occupancy costs along with income and depreciation on buildings, structures, capital improvements, and capital equipment. |
Account for the total cost of owning a property, building, or equipment asset over its lifespan. Evaluate leased / own decisions on an even basis. Compare owned properties on an even basis to see what cost might be better aligned to the mission. |
For the given fiscal year and asset, sum the values from the other columns specified in the AbRPLMStrategicFinancialAnalysis-UpdateTCO-OwnershipCosts application parameter. These columns default to the TCO-Occupancy (fy) columns plus:
Note: The fin_anlys_Depreciation_an_fy covers the depreciation of the Building or Structure (i.e. a property that is a structure) itself. The separate CapProj and PPE analysis metrics include the depreciation of capital projects and equipment in that building or on that property. |
||||||||||||||||||||||||||||
(fin_tc_wkpnt_an_fy) |
TCO-Workpoint (fy) |
Buildings Properties |
Sums TCO - Ownership costs along with costs for financing, cost of capital employed, infrastructure including telecom infrastructure, and indirect services. Compare Annual Worth for an annualized figure representing TCO over the entire lifecycle of the facility along with acquisition costs and disposal costs. |
Analyze all costs for providing the facility, including financing costs. Account for the true total cost to an organization for providing infrastructure, facility and real estate services to business units, inclusive of infrastructure, indirect services, financing, acquisition and disposal costs |
For the given fiscal year and asset, sum the values from the other columns specified in the AbRPLMStrategicFinancialAnalysis-UpdateTCO-WorkpointCosts application parameter. These columns default to the TCO-Ownership (fy) columns plus:
|
||||||||||||||||||||||||||||
Financing Metrics |
|||||||||||||||||||||||||||||||||
fin_anlys_RemainingMortgage_an | Remaining Mortgage |
Buildings Properties |
The total mortgage yet to be paid in future years for current loans. This figure included both the interest, which is included on the P&L, and the principal, which goes to the balance sheet. |
Gauge outstanding liability associated with assets in use and on the balance sheet. |
For the given asset, for the given fiscal year and all later years that have Scheduled Costs or Recurring Costs for that asset, the application uses the Cash Flow Projection to sum the values from the Cost Categories specified in the AbRPLMStrategicFinancialAnalysis application parameters. Sums up the appropriate parameter for each asset type:
|
||||||||||||||||||||||||||||
fin_anlys_Interest_an_fy | Interest (fy) |
Buildings Properties |
The total interest paid this fiscal year. | Gauge the P&L expense for the asset. |
For the given asset, for the given fiscal year, sum the values from the Cost Categories LIKE those specified in the AbRPLMStrategicFinancialAnalysis application parameters appropriate for each asset type. This parameter defaults to: CostCategory_InterestBuilding CostCategory_InterestProperty |
||||||||||||||||||||||||||||
fin_anlys_Principal_an_fy | Principal (fy) |
Buildings Properties |
The total principal paid this fiscal year. | Gauge the net gain to the balance sheet for the asset. |
Calculated as Interest, but uses these cost categories: CostCategory_PrincipalBuilding CostCategory_PrincipalProperty |
||||||||||||||||||||||||||||
fin_anlys_Income_an_fy | Income (fy) |
Buildings Properties |
The total income paid this fiscal year to this asset. |
Gauge the income benefits of owning this asset, including sublet rent paid, ground floor retail rent paid, telecom fees, and CAM costs paid on owned buildings. |
Calculated as Interest, but uses these cost categories: AbRPLMStrategicFinancialAnalysis-CostCategory_IncomeAll Note: Only buildings and properties might have income. Include all Scheduled Costs of this category. |
||||||||||||||||||||||||||||
fin_anlys_CostOfCapital_an_fy | Cost of Capital (fy) |
Buildings Properties . |
The cost of capital employed this year, valued using the Internal Cost of Capital. | Gauge the opportunity cost of the money employed in the downpayment and in the principal payments for this asset. |
Calculated as Interest, but uses these cost categories: CostCategory_CapitalBuilding CostCategory_CapitalProperty |
||||||||||||||||||||||||||||
fin_anlys_Appreciation_an_fy | Appreciation (fy) |
Buildings Properties |
The forecast appreciation of buildings or properties that have land. |
Gauge the time-based benefit of holding this asset. |
Calculated in the same way as Interest is calculated, but uses these cost categories: CostCategory_AppreciationAll Only Buildings with land and Properties that are land have appreciation. The application includes all Scheduled Costs of this category. |
||||||||||||||||||||||||||||
Note about depreciation calculations: Depreciation is charged equally for each year of the life of the asset, starting with the first day of the second fiscal year. | |||||||||||||||||||||||||||||||||
fin_anlys_Depreciation | Depreciation (fy) |
Buildings Properties |
The calculated depreciation based on the property type of the building, structure, capital project, or capital equipment item. |
Gauge the amount of equity that this particular building, structure, capital project or equipment item wrote down this year as consumed. |
Calculated in a similar way as Interest is calculated, but uses these cost categories: CostCategory_DeprBuilding CostCategory_DeprProperty Note: This is the depreciation on the asset itself – the building structure (property). |
||||||||||||||||||||||||||||
fin_anlys_DepreciationCapProj_an_fy | Depreciation - Capital Projects (fy) |
Buildings Properties |
The depreciation associated with all capital projects that are assigned to this building or this property. This value is 0 for the capital projects themselves. |
Gauge the amount of depreciation that occurred in capital projects that are tracked separately from the value of the building or property itself. This value is equal to the sum of all Depreciation (fy) values for all capital projects for this building. Analysts can sort depreciation by building and map this value geographically to review the costs expended for capital projects at this location. |
For the given asset, for the given fiscal year, the application sums the values from the Cost Categories LIKE those specified in the AbRPLMStrategicFinancialAnalysis application parameters: CostCategory_DeprCapProj Note: This metric applies only to buildings and properties. It sums the depreciation of the capital projects occurring in those buildings or on those properties. |
||||||||||||||||||||||||||||
fin_anlys_DepreciationPPE_an_fy | Depreciation - PPE (fy) |
Buildings Properties |
The depreciation associated with all capital equipment that is assigned to this building or this property. This value is 0 for the capital equipment items themselves. |
Gauge the amount of depreciation that occurred in capital equipment that is tracked separately from the value of the building or property itself. This value is equal to the sum of all Depreciation (fy) values for all capital equipment for this building. Analysts can sort depreciation by building and map this value geographically to review the costs expended for capital projects at this location. |
The PPE metric works similarly, just with the following Cost Category:
|
||||||||||||||||||||||||||||
fin_anlys_MarketValue_an | Market Value |
Buildings Properties |
The last estimated market value for this asset. | Gauge the total value of this asset if sold. |
For the given building, the application copies the value from bl.value_market. For any given property, the application copies the value from property.value_market. |
||||||||||||||||||||||||||||
fin_anlys_BookValue_an | Book Value |
Buildings Properties Projects Equipment |
The depreciated book value for this asset. |
Review the estimated accounting value of this asset on the books. |
For the given asset, the application calculates the depreciated value as follows:
Note: If the asset's parameters for depreciation (for example, missing cost_purchase, planned_life, etc.) do not exist in finanal_params table, the depreciation and thus the metric cannot be calculated, and the Update Analysis Metric action updates this metric with the value zero for that asset and that Fiscal Year. Note:
The metric fin_anlys_BookValue_an uses the depreciation service to estimate the depreciation to the end of the current fiscal year, and does not use existing depreciation costs resulted from forecasting capital costs, such as the metric fin_anlys_Depreciation_an_fy.
|
||||||||||||||||||||||||||||
fin_anlys_MarketMinusBookValue_an | Market Minus Book Value |
Buildings Properties |
The difference between the value of the asset on the market and the value of the asset on the balance sheet. | Summing this value over sections of the portfolio indicates the amount of capital that could be freed for other purposes if that section were sold or sold and then leased back. | For the current asset, the application subtracts the fin_anlys_BookValue_an from the fin_anlys_MarketValue_an | ||||||||||||||||||||||||||||
fin_anlys_RealEstateOpEx_an_fy | OpEx (fy) |
pga, pra, perseat Buildings Properties |
The operating expenses for this building or property. |
Review the cost of operating this facility. OpEx per Gross Area benchmarks the cost to normalized out building size. This measures how efficient your operations effort is overall. (For Buildings Only) OpEx per Rentable Area benchmarks the cost to normalized out size of leasable area. This measures how efficient your operations effort is with respect to areas that you lease or that can be leased out. (For Buildings Only) OpEx per Seat benchmarks the cost per available seat in this building. This measures how efficient your operation is per supported workspace area. (For Buildings Only) |
These columns default to the TCO-Occupancy (fy) columns. | ||||||||||||||||||||||||||||
Capital |
|||||||||||||||||||||||||||||||||
cap_AnnualWorth_an_fy | Annual Worth |
pga (per gross area) Buildings Properties |
Includes the total lifecycle cost of the asset normalized back to an annual value. These costs include occupancy, ownership, financing, infrastructure, acquisition and disposal costs. |
To compare owned assets on an even basis, including all occupancy costs plus financing costs, given their entire lifetime. This figure is often use to analyze construction and design costs and alternatives. Annual Worth Per Gross Area prorates the cost so that buildings of different sizes can be compared on an even basis. (For Buildings Only) |
For the given fiscal year and asset, the application gets the list of activity parameters specified in the AbRPLMStrategicFinancialAnalysis-UpdateAnnualWorth application parameter. The application:
Important: If the planned_life does not exist for the building or property, the Annual Worth (fy) cannot be calculated, and the Update Analysis Metric action updates this metric with the value zero for that building or property and that Fiscal Year. |
||||||||||||||||||||||||||||
cap_npv_1year_an cap_npv_3years_an cap_npv_lifetime_an |
NPV (1 Year) Buildings | Properties |
The net-present value of the asset, given all expenses and income over the first year, first three years, or the entire lifetime. Lifetime costs include acquisition, financing, disposition costs and salvage value. |
Gauge the total return on holding the asset (or the total expense of using the asset if the value is negative). The value is expressed in present value (e.g. present-day worth of dollars, euros, etc.) so that you can compare investments, expenses, and income incurred in different time frames on an even basis. Compare startup costs, initial costs, and lifetime benefits to gauge risks during different periods of ownership. NPV (1 Year) presents return for the first year. NPV (3 Year) presents return for the second year. NPV (Lifetime) presents return over the Planned Life of the asset. (NB, this may be different than the depreciation period of the asset.) |
Prerequisite: You have entered your organization's expected rate of return in the Application Parameter AbRPLMStrategicFinancialAnalysis-DiscountRate. For the given fiscal year and asset, the application:
Important: The calculation is from the "date purchased" rather than the current date. This is appropriate, as the metric is of primary use for comparing investments made today and going forward. Analysis of performance on past investments can use one of the annualized metrics to calculate performance for any period of years. The one consequence is that the "present value" is the value as of the Date Purchased (or planned to be purchased) not as of the current date. Important: This calculation is of a regular analysis metric that returns a single value. That value happens to concern performance over the lifecycle. That is to say, this metric is not calculated as "lifecycle analysis metric" since it results in a single value rather than one value per each year of the planned life of the building. The metrics below are similar. These are both of calculation order "1 - Base Analysis Value".
|
||||||||||||||||||||||||||||
cap_irr_3years_an cap_irr_lifetime_an |
IRR (1 Year) |
Buildings Properties |
The internal rate of return for the asset, given all expenses and income over the first year, first three years, or the entire lifetime. |
Gauge the return during different periods in the asset's lifetime. This value is useful for buildings or properties that generate income. For occupied properties that do not generate any income, the NPV calculation may be more useful. IRR (3 Year) presents return for the second year. IRR (Lifetime) presents return over the Planned Life of the asset You must have at least one positive and one negative cash flow year for the asset to calculate the rate of return. |
The application
|
||||||||||||||||||||||||||||
cap_CapitalProjects-Approved_an_fy | Capital Projects (fy) |
Buildings Properties |
The total value of all capital projects in this building or property for this fiscal year that are approved or have a 90% or better probability of being funded. (Buildings and Properties Only) |
Gauge how well the facility is doing compared to the target capital renewal rate for the building or structure. If the value is less than the target renewal rate, the facility is likely degrading in its ability to support the mission. (This value is 0 for the capital projects themselves to avoid double-counting projects. Also, if a project is assigned to both a building and a property, it is summed to the property. In this way, if you sum all Asset Scorecard records within a region or other filtered subset of the scorecard, you can sum all projects that are assigned to buildings or properties without any duplication). |
For buildings or properties, the application:
Notes: The analysis sums projects to the building or property to evaluate capital renewal ratios. To evaluate the cost of projects in the Financial Analysis Asset Scorecard or Asset Map, the application uses the fin_anlys_BookValue_an for the Project. |
||||||||||||||||||||||||||||
cap_CapitalProjects-Planned-3years_an cap_CapitalProjects-Planned-lifetime_an |
Planned Capital Projects Planned Capital Projects (lifetime) |
Buildings Properties |
The total value of all planned capital projects in this building or property for the next year or for the lifetime of the facility. (Buildings and Properties Only) |
Gauge how well the facility is doing compared to the target capital renewal rate for the building or structure in the coming years. If the value is less than the target renewal rate, the facility is likely degrading in its ability to support the mission. (This value is 0 for the capital projects themselves to avoid double-counting projects. Also, if a project is assigned to both a building and a property, it is summed to the property. In this way, if you sum all Asset Scorecard records within a region or other filtered subset of the scorecard, you can sum all projects that are assigned to buildings or properties without any duplication). |
cap_CapitalProjects-Planned-3years_an: For buildings and projects, the application: SELECT SUM(IF project.cost_est_baseline = 0.0 THEN project.cost_est_baseline ELSE project.cost_budget ) for all projects that are not Requested or (i.e. project.status NOT LIKE 'Requested%'), are assigned to the building or property (that is,. with project.bl_id=<current building>), and have a Requested Start Date (project.date_start) within three years of the first day of the current fiscal year. Note: This query first looks at the cost_est_baseline, which the project management activity updates from Action Item records (if the site has developed them for this project) with the Estimate Baseline Costs calculation. If the site does not use Action Items but instead just enters a Budgeted Cost (cost_budget) for the project, the calculation uses that value. cap_CapitalProjects-Planned-lifetime_an: This calculation works similarly to the calculation for Capital Projects Planned (3 Years), but includes all projects with a project.date_start greater than or equal to the first day of the current fiscal year. |
||||||||||||||||||||||||||||
ops_ExpensedProjects-Approved_an_fy | Expensed Projects - Approved (fy) |
Buildings Properties |
The total value of all expensed project tasks this fiscal year for this building or property. (Buildings and Properties Only) |
Gauge the cost of expensed maintenance. |
This calculation works similarly to the calculation for cap_CapitalProjects-Approved_an_fy; however, it uses Cost Category LIKE CostCategory_ExpensedProjectAll. | ||||||||||||||||||||||||||||
ops_FacilityConditionIndex_percent_an_fy | FCI (%) |
Buildings Properties Projects Equipment |
The cost of outstanding maintenance on an asset needed to bring it up to 100% capacity divided by the cost of that asset. |
Gauge the state of repair of an asset or facility with respect to its ability to support the mission. |
Note: You must use the Condition Assessment application and/or mobile app to accurately measure your outstanding capital liabilities in relation to the cost of the facility. For all activity_log_items that have activity_type = 'ASSESSMENT' and that are assigned to this asset that is, that have activity_log_items.pr_id, bl_id, project_id or eq_id assigned to this asset), the application calculates ${sql.getFormula("AbCapitalPlanningCA-FacilityConditionIndex")}/100 Note: The analysis may use the same assessment item for multiple assets (for example, properties, buildings, projects and/or equipment). This is because the same item can be part of evaluating multiple scopes. The analysis uses planned Action Items and not planned and historic items – that is, all Action Items (activity_log_hactivity_log) – because the measure is of defects or work yet to be done, and not work that has been done. For reference, the application preference AbCapitalPlanningCA-FacilityConditionIndex has a default value of "(1000 * ( activity_log.cost_estimated + activity_log.cost_est_cap) / ${sql.replaceZero('activity_log.cost_to_replace')})" |
||||||||||||||||||||||||||||
proj_Projects_Schedule_Variance_cng_an | Schedule Variance (%) | Projects |
The percentage month to month change in the number of days duration a project is estimated to take. (Projects Only) |
Use this as an alert to any projects that have a schedule risk. |
For the current building (afm_metric_trend_values.collect_by_value=<building>), the application queries the most recent record's afm_metric_trend_values.metric_value for spac_Vacancy_percent_monthly. It then queries the previous month's value, and calculates the percentage changes as ( this month - last month ) / (last month) * 100. You use the Projects application to track your project execution. |
||||||||||||||||||||||||||||
proj_Projects_Budget_Variance_cng_an | Budget Variance (%) | Projects | The percentage month to month change in the estimated cost of a project. (Projects Only) |
Use this as an alert to any projects that have a budget risk. |
The application queries the most recent value from Project Variance (proj_ProjectScheduleVariance_monthly) tracking metric for this project_id from the afm_metric_trend_values table. |
||||||||||||||||||||||||||||
Expense Metrics |
|||||||||||||||||||||||||||||||||
ops_Costs-Maintenance_an_fy | Costs - Maintenance (fy) |
pga (per gross area) Buildings Properties |
Cost of on demand and preventive maintenance. |
Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. |
These metrics are calculated similarly to the Interest (fy) metric, only they sum from different cost categories. These metrics apply only to Buildings and Properties. The following describes the cost categories used:
|
||||||||||||||||||||||||||||
ops_Costs-Custodial_an_fy | Costs - Custodial (fy) |
pra (per rentable area) Buildings Properties |
Janitorial and custodial costs. |
Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. | |||||||||||||||||||||||||||||
ops_Costs-Security_an_fy | Costs - Security (fy) |
pra (per rentable area) Buildings Properties |
Security expenses. | Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. | |||||||||||||||||||||||||||||
ops_Costs-Utility_an_fy | Costs - Utility (fy) |
pga Buildings Properties |
Electrical, gas, water and other utility expenses. |
Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. |
|||||||||||||||||||||||||||||
ops_Costs-PropertyTaxes_an_fy | Costs - Property Taxes |
pra (per rentable area) Buildings Properties |
Property taxes. | Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. | |||||||||||||||||||||||||||||
ops_Costs-Other_an_fy | Costs - Other (fy) |
pra (per rentable area) Buildings Properties |
Other operating costs, such as administration cost, that are not captured by other categories. |
Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. |
|||||||||||||||||||||||||||||
work-Costs-DirectServices_an_fy | Costs - Direct Services (fy) |
pra (per rentable area) Buildings Properties |
Cost for Service Desk services that are directly tied to providing the facility. |
Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. | |||||||||||||||||||||||||||||
work_Costs-IndirectServices_an_fy | Costs - Indirect Services (fy) |
pra (per rentable area) Buildings Properties |
Costs for Service Desk and other services – such as gym, cafeteria, day care, dry cleaning, etc. – that are staff services not directly tied to the facility per se. | Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. | |||||||||||||||||||||||||||||
Lease Metrics |
|||||||||||||||||||||||||||||||||
leas_Costs-RemainingCommitment_an | Remaining Lease Commitment |
Buildings Properties |
Remaining cost of all lease payments if the lease contract goes to term. |
Describes the total remaining contractual commitment. Represents an amount that may be required to be capitalized under future ISAB or FASB rules. |
For the given asset, for the given fiscal year and all years that have Scheduled Cost or Recurring Cost data in this category and asset, the application uses the Cash Flow Projection to sum the values from the Cost Categories LIKE those in the AbRPLMStrategicFinancialAnalysis-CostCategory_RentAll application parameter. This parameter defaults to: RENT% | ||||||||||||||||||||||||||||
leas_Costs-Rent_an_fy | Rent (fy) |
pra, (per rentable area) perseat (per seat) Buildings Properties |
Rental costs. | Use this metric and its prorated values to review budgets for this category of expense and compare buildings against each other and against industry benchmarks. |
This metric is calculated similarly to the Interest (fy) metric, only the application sums using different cost categories.
This metric applies only to buildings and properties. |
||||||||||||||||||||||||||||
Occupancy Metrics |
|||||||||||||||||||||||||||||||||
occ_OccupantsMax_an | Max. Occupants | Buildings | The maximum number of occupants a facility can have at one time. |
Used to gauge total capacity and prorate personnel-support expenses by the number of personnel that expense serves. |
The application copies this value from bl.count_max_occup | ||||||||||||||||||||||||||||
occ_Occupants_an | Occupants | Buildings | Number of occupants actually in the building. |
Used to review total capacity, ability to absorb growth, or ability to consolidate. |
The application copies the value from bl.count_em Can be estimated. or updated from Space Inventory, if that application is in use. |
||||||||||||||||||||||||||||
occ_Occupancy_percent_an | Occupancy (%) |
per occup, per seat Buildings |
Ratio of current occupancy to maximum occupancy. | Used to review efficiency of space allocation and ability to absorb change. Ratios under 95% can be improved. Ratios above 95% are too tight and tend to retard business' agility in reorganizing project teams around the organizational mission. |
occ_Occupants_an / occ_OccupantsMax_an |
||||||||||||||||||||||||||||
Space Metrics |
|||||||||||||||||||||||||||||||||
spac_Vacancy_percent_an | Vacancy (%) |
Buildings |
Measured vacancy of space from Occupancy application. | Used to review efficiency of space. |
You must use the Occupancy application, the mobile app to perform field surveys, and optionally the Service Desk application to process space and move requests in order to accurately gauge vacancy. This is calculated as the spac_VacantArea_an / spac_area_usable. |
||||||||||||||||||||||||||||
spac_Vacancy_Variance_cng_an | Vacancy Variance (%) |
Buildings |
Change in vacancy from the prior month according to the Occupancy application. |
Used to review if there were any changes in circumstances that require immediate action. |
You must use the Occupancy application, the mobile app to perform field surveys, and optionally the Service Desk application to process space and move requests in order to accurately gauge vacancy. For the current building (afm_metric_trend_values.collect_by_value=<building>), the application queries the most recent record's afm_metric_trend_values.metric_value for spac_Vacancy_percent_monthly. It also queries the previous month's value. Calculates the percentage changes as ( this month - last month ) / (last month) * 100. |
||||||||||||||||||||||||||||
spac_VacantArea_an | Vacant Area | Buildings |
Total vacant area available for repurposing. |
Use to respond to new calls for space or to propose changes to consolidate space and free unused leases and buildings. |
You must use the Space Inventory application, the mobile app, and optionally the Service Desk application to process space and move requests in order to accurately gauge vacant area. The application uses the following calculation: SELECT SUM( area ) FROM rm WHERE cap_em > 0 AND rm_cat IS NOT NULL AND rm_cat in (SELECT rm_cat from rmcat WHERE occupiable = 1) AND NOT EXISTS (SELECT * FROM em WHERE em.bl_id = rm.bl_id AND em.fl_id = rm.fl_id AND em.rm_id = rm.rm_id) AND bl_id=<this building> |
||||||||||||||||||||||||||||
Building Values and Measures |
|||||||||||||||||||||||||||||||||
spac_bl_AreaInternalGross_an | Int. Gross Area | Buildings |
Total interior gross area of the building. |
Used to gauge size of building and compare maintenance, utility and capital renewal budgets on an even basis between buildings of different size. |
The values below are copied from the associated field in the buildings table. In terms of calculation order, these are all of type "1 - Base Analysis Value".
Current Year Minus the year of the Date Built (bl.date_bl) for the current building |
||||||||||||||||||||||||||||
spac_bl_AreaRentable_an | Rentable Area | Buildings | Total rentable area of the building, including common areas. |
Used to gauge rentable area and compare costs on an even basis for rent, custodial, security and other categories of cost. |
|||||||||||||||||||||||||||||
spac_bl_AreaUsable_an | Usable Area | Buildings | Total usable area of the building within suites. |
Used to plan functional area to be allocated to staff and conferencing space. |
|||||||||||||||||||||||||||||
spac_criticality_an | Criticality | Buildings |
The importance of the asset to the mission. This is a combination of its significance to the line business and uniqueness of the facility. |
Used to gauge which assets or leases must be maintained to ensure continued pursuit of the mission. Assets which have secondary purposes or which can be replaced by similar buildings or leases in the same region have a lower criticality. | |||||||||||||||||||||||||||||
spac_BuildingAge_an | Building Age (Years) | Buildings | Age of the building. | Used to weigh capital decisions, particularly concerning buildings with a low FCI, as buildings nearing the end of their useful life may be more practicably rebuilt or resold than updated. | |||||||||||||||||||||||||||||
spac_Use_an | Use |
Buildings Properties |
The building use, for example, office, lab, manufacturing, warehouse. |
Use to group buildings and properties by like type to estimate costs against facilities delivering similar kinds of space and estimate mission criticality against redundant capacity you may have in the same region. |
|||||||||||||||||||||||||||||
spac_Status_an | Status |
Buildings Properties |
The status of the building, for example: Owned, Leased, Owned and Leased, Sold |
Use to evaluate metrics in terms of the purpose or status of an asset in the portfolio.
|