Option Pricing using Monte Carlo Simulation – Pricing Exotic & Vanilla Options in Excel – Introduction

Option pricing using Monte Carlo Simulation In our post on Option Pricing using Monte Carlo Simulation, we walk through a simple modeling framework used for pricing vanilla as well as exotic options in Excel. After the framework is introduced we drop a few hints on how to price Asian, Barrier, Ladder & Chooser options using Monte [...]

Continue ReadingOption Pricing using Monte Carlo Simulation – Pricing Exotic & Vanilla Options in Excel – Introduction

Exotic derivatives & Options pricing – Pricing Chooser and Compound Options – Weekend Challenge

Exotic Derivatives & Option pricing weekend challenge This week exotic option pricing challenge focuses on chooser and compound option pricing using Monte Carlo Simulation in Excel. Hints to the solution will be posted separately within the next 12 hours. Let’s see if you can crack this first before I go ahead and post the solved solution. [...]

Continue ReadingExotic derivatives & Options pricing – Pricing Chooser and Compound Options – Weekend Challenge

Singapore Hortpark – Flowers, Creepy Crawlies & Woodpeckers

The last round of pictures from my morning walks in the Hortpark, Alexandra Arch, Forest Walk neighbourhood. Incase we met before sunrise, I was the indecently dressed guy armed with a camera and a stick. The yellow caterpillar, the wood pecker and the bumble bee in action remain my all time favorites. A [...]

Continue ReadingSingapore Hortpark – Flowers, Creepy Crawlies & Woodpeckers

Calculating Conditional Value at Risk (CVaR) or Expected Shortfall – VaR and beyond

Calculating Conditional Value at Risk (CVaR) or Expected Short fall using Historical returns. Imagine a board meeting where you have just presented your Value at Risk (VaR) analysis and a board member asks a simple question. “So what are we talking about here? What is the expectation? What is the most that we can drop if [...]

Continue ReadingCalculating Conditional Value at Risk (CVaR) or Expected Shortfall – VaR and beyond

The new A-380 only concourse A at Dubai airport

For the first time since the new T-3 lounge opened at Dubai airport, its empty at 6 am in the morning. Historically come 6 am and the lounge becomes a portrait of weary travelers in search of available space to crash, land, change, shower and chill. But the only problem with that portrait before 1st [...]

Continue ReadingThe new A-380 only concourse A at Dubai airport

Monte Carlo Simulation how to – Linking financial model to the simulation

Monte Carlo Simulation – Linking financial model to the simulation Since we have a model for simulating oil prices, we are now ready to link our oil price model to projected financial statements for the airline. To do this we need to figure out how to link simulated crude oil prices to jet fuel expense on the [...]

Continue ReadingMonte Carlo Simulation how to – Linking financial model to the simulation

Singapore – Close encounters of 2nd kind – Golden Web Spiders at Forest Top

This morning walk at the inclined interchange between Forest top, Henderson Waves & Faber top, I run smack into three beautifully sunlit spider webs. Even though I hate all families of creepy crawlies, the unintended display was so majestic and grand that it had to be captured and shared. In all three instances for somebody [...]

Continue ReadingSingapore – Close encounters of 2nd kind – Golden Web Spiders at Forest Top

Simulation Modeling – Monte Carlo how to reference

Simulation Modeling – Monte Carlo how to reference for financial simulations While we have shared a great deal about Simulation Modeling and Analysis on this blog, over the years, I felt it would help to finally have some organization. The need became more apparent when I ran sessions in Singapore, Abu Dhabi & Dubai for my [...]

Continue ReadingSimulation Modeling – Monte Carlo how to reference

Building Maturity & Liquidity profiles for Deposits and Advances book for ALCO (ALM), ICAAP & IAS 30 reporting

Maturity Profile Course package available for sale 9th February 2012 As part of our work as risk managers, one routine and recurring activity is preparing the slide deck for the Asset…

Continue ReadingBuilding Maturity & Liquidity profiles for Deposits and Advances book for ALCO (ALM), ICAAP & IAS 30 reporting