Real Property / Strategic Financial Analysis / Financial Analysis

Update Analysis Metrics

Before Running the Update Analysis Metric action

Project and equipment costs

Archibus doesn't assign costs directly to projects or equipment. For many metrics, the application assigns the project or equipment cost to the building or property, and sums the total project and equipment cost for that building or property. For this reason, if you are going to include capital project or capital equipment in the analysis, you will use the Forecast Capital Costs action. This would result in the project or equipment item having a finanal_params record. If the project or equipment item is in the analysis, Archibus includes all the metrics for that project or equipment item.

The metrics that apply to projects and equipment are these:

Even if the analyst does not include a project or equipment item in the analysis explicitly (by creating its own finanal_params record), any historic project costs are still rolled up with the building or property.

About the Update Analysis Metrics calculations

The Update Analysis Metrics action updates the values in the cost analysis, specifically the values in:

The action does so by looking at the analysis metrics defined in the Archibus Metric Definitions (afm_metric_definitions) table. For each analysis metric that calculates a new value, this action update the values in finanal_sum and finanal_sum_life.

For a description of the base analysis metrics, see Base Analysis Metrics.

For analysis metrics that calculate ratios (for example, Cost per Gross Area), the action uses the Numerator and Denominator metrics referenced in the Archibus Metric Definitions table to calculate the value.

Once all values are in the finanal_sum and finanal_sum_life summary tables, then the action calls a separate method to update the Capital and Expense matrix.

Analysts invoke the Update Analysis Metrics action from the Aggregate and Forecast Costs task for either buildings, properties, projects, or equipment.

The analysis values are stored in the Financial Analysis Summary Values (finanal_sum) and the Lifecycle Analysis Summary Values (finanal_sum_life) tables. These tables hold the values for the analysis fields (that is, the summary values) that can be displayed in:

Some analysis fields collect values by fiscal year, and others collect values for the entire financial lifecycle of the asset or project. Those analysis values collected by fiscal year are stored in the Financial Analysis Summary Table (finanal_sum), while those analysis values collected for the entire life-cycle are stored in the Life-cycle Financial Analysis Summary Table (finanal_sum_life).

Tips:
Planned Life required to calculate Annual Worth. 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.
Book Value: If the asset's parameters for depreciation (ex. 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.
Close the progress bar manually. To close the progress bar, click Close after the action has completed. Otherwise, the progress bar doesn't close.