Sample Spreadsheets

Spreadsheet Description Action
Bivariate Correlation This example demonstrates the use of bivariate normal distribution, showcasing correlated values and their application in financial models. Download
Interest Rate Projections: Cox-Ingersoll-Ross Model A spreadsheet designed to model interest rate trends using the Cox-Ingersoll-Ross model, simulating changes over time across multiple discrete periods. The example is described in detail in this article. Download
Investment Return Modeling This spreadsheet offers a foundational model for assessing investment returns and project planning, focusing on growth projections and risk analysis. Download
Asset Portfolio This example demonstrates the creation of a 10-year asset portfolio using multivariate normal distribution to model the correlation between different asset classes. Download
Multivariate Risk An example of multivariate distribution analysis with a detailed breakdown in the associated article about statistical modeling. Download
Portfolio Analysis A comparative model of two distinct portfolios over a set period, illustrating the effects of different investment strategies. Download
Retirement Strategy A basic retirement portfolio model that evaluates potential portfolio risks with fixed annual withdrawals. Download
Risk Assessment: Value at Risk (VaR) This model allows for the estimation of value at risk (VaR), providing insights based on the profit or loss outcomes from simulation models. Download
Risk/Opportunity Model This spreadsheet evaluates conditional risk and opportunity asd scenarios, calculating the potential impacts based on predefined probabilities and outcomes. Download