Monte Carlo simulation for Excel for risk analysis - repost
- Status Closed
- Budget $250 - $750 USD
- Total Bids 14
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
The target is the Hedging Strategy Optimisation, i.e. determine the mix of derivative contracts to achieve an optimal risk / return outcome:
• Profit & Loss
• Margin calls
• Exposure calculations
• 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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online