Sample Spreadsheets

Spreadsheet Description Action
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
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
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