Provides 12 random number generators that allow you to generate histograms from probability distributions given the parameters you have specified. You also have the option to output random numbers from the distribution on the spreadsheet.
13 different topics in finance and statistics from a simple model such as computing standard deviation and mean to more advanced models such as Monte Carlo simulation, multivariate standard normal distribution, multiple regression, and option pricing
The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.
The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing tools include Black-Scholes, Binomial, and Game Theory.
The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.
Contains topics in applying different numerical searching methods to solve mathematical equations and implied volatility from option pricing models. Also includes vanilla option pricing models on futures, currencies, stock indexes.
