Monte Carlo simulation for Excel for risk analysis

Avg Bid (USD)
Project Budget (USD)
$1500 - $3000

Project Description:
We are a Power Retailer operating on a deregulated energy market, and we need to develop a tool for evaluation of risk exposure on the existing and / or forecasted portfolio using Monte Carlo simulation for Excel..

The tool has to allow us to:
- define risk scenarios, such as hedging contracts, books, demand curves, price indexes, selling contracts
- define the algorithm variables
- etc
The target is the Hedging Strategy Optimisation, i.e. determine the mix of derivative contracts to achieve an optimal risk / return outcome:
• Mark-to-market
• Profit & Loss
• Margin calls
• Exposure calculations
• VaR
• CVar
• PaR etc.

In other words, given different scenarios and variables, we’d like to perform a simulation to determine the possible outcomes, and how likely are they to occur.

Skills required:
Excel, Finance, Financial Markets, Matlab & Mathematica, Statistics
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 2100
in 120 days
$ 3000
in 20 days
$ 3000
in 45 days
Hire bchandra1955
$ 2475
in 60 days
Hire hmramezani
$ 2200
in 40 days
$ 2600
in 18 days
$ 1800
in 10 days
Hire kumarkmb
$ 2000
in 15 days
Hire Raghavanps
$ 2000
in 30 days
$ 2500
in 30 days