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 |