Simulations using Excel

Life is full of uncertainties and so are all the financial variables. In Finance one of the most famous tools for handling these uncertainties is Monte Carlo Simulation. This zip contains a set of applications of this famous technique across various financials domains
1.Simulations to project Cash Flows
2.Simulation of Stock Prices – ABM & GBM
3.Simulation to estimate Value at Risk & Expected Shortfall Calculations
4.Simulations to model Credit Risk Losses
5.Simulations to model Term Structure of Interest rates
6.Simulations to Price Derivatives
The zip also contains the following 2 sets of excel sheets
1.Random Number Generation techniques in MCS
2.Variance Reduction techniques.