Note

Click here to download the full example code

simplelife present values of cashflowsΒΆ

Present values of liability cashflows of a simple whole life policy.

plot pvcashflows

Out:

c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)
c:\users\fumito\onedrive\pyproj\modelx\modelx\io\pandas.py:192: FutureWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
  result = pd.Series(data=data, name=cells.name, index=indexes)


import modelx as mx
proj = mx.read_model("model").Projection

vars = ['PV_PremIncome',
        'PV_BenefitSurr',
        'PV_BenefitDeath',
        'PV_ExpsMaint',
        'PV_ExpsCommTotal',
        'PV_ExpsAcq']

polid = 171

for cells in vars:
    list(proj[polid].cells[cells](t) for t in range(50))

cfs = proj[polid].frame[vars].sort_index().dropna()

[proj[polid].PV_NetCashflow[t] for t in range(50)]

ncf = proj[polid].PV_NetCashflow.frame.sort_index()

import seaborn as sns
sns.set_theme(style="darkgrid")

axes = ncf.plot.line(marker='o', color='r')
cfs.plot(kind='bar', stacked=True, ax=axes)

Total running time of the script: ( 0 minutes 0.946 seconds)

Gallery generated by Sphinx-Gallery

previous

fastlife present values of net cashflows

next

simplelife cashflow