The results from the financial analysis of the model are
returned to the attributes in the same module that contains the time
grid.
If time grid values are edited in the time grid editor, the
results retrieved from the financial analysis in the attributes is
reset to zero. The values must be saved using the Investment analysis
interface to retrieve results from the financial analysis of the model.
The
values for NPV, NPV Mean, NPV Standard Deviation, ROI, IRR and Payback
Period are not calculated for the read-only attributes in a view.
If
the connected attributes in a view cannot be edited, those attributes
are not updated when they are saved by using Investment analysis.
Important: To return the results, the alias of the time grid
is used as a prefix for the alias of each result attributes. For example,
if the alias of the time grid attribute was defined as TG,
the alias of the result attributes must be TG__<Alias Suffix> respectively.
Table 1. Attributes to retrieve financial analysis result| Result |
Attribute Type |
Alias |
Example |
| NPV Distribution |
Matrix |
time grid alias__NPV |
TG__NPV |
| NPV Mean |
Float |
time grid alias__NPVMean |
TG__NPVMean |
| NPV Standard Deviation |
Float |
time grid alias__NPVStddev |
TG__NPVStddev |
| ROI |
Integer |
time grid alias__ROI |
TG__ROI |
| IRR |
Float |
time grid alias__IRR |
TG__IRR |
| Payback Period |
Integer |
time grid alias__paybackPeriod |
TG__paybackPeriod |
| ROI To Date |
Matrix |
time grid alias__ROIToDate |
TG__ROIToDate |
| ROI To Go |
Matrix |
time grid alias__ROIToGo |
TG__ROIToGo |
| Payback Period Distribution |
Matrix |
time grid alias__paybackPeriodDist |
TG__paybackPeriodDist |
Note: The options Display as Line Chart and Flip Matrix
Axes are good choices when configuring the matrix attribute.
After
you configure the attributes to retrieve the financial results, you
can build your financial model.