Visual Basic Developer with knowledge of finance
Budget: $1,500 – $3,000 USD
Project asset and liability scenarios using Monte Carlo simulation including :
1) Generate stochastic asset and liability return scenarios (using correlation matrix for a portfolio of assets and liabilities)
2) Generate various discounting curves and funded status ratios (assets divided by liabilities)
3) Dynamically rebalance the asset portfolio and liability hedge if triggers are reached
4) At annual intervals (i) test for funding requirements, incorporating complex formula based funding rules and (ii) produce pro-forma GAAP disclosures
5) Produce outputs including charts
1) Generate stochastic asset and liability return scenarios (using correlation matrix for a portfolio of assets and liabilities)
2) Generate various discounting curves and funded status ratios (assets divided by liabilities)
3) Dynamically rebalance the asset portfolio and liability hedge if triggers are reached
4) At annual intervals (i) test for funding requirements, incorporating complex formula based funding rules and (ii) produce pro-forma GAAP disclosures
5) Produce outputs including charts