Sample Spreadsheets
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.
DownloadBivariate Correlation
This example demonstrates the use of bivariate normal distribution, showcasing correlated values and their application in financial models.
DownloadInterest 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.
DownloadInvestment Return Modeling
This spreadsheet offers a foundational model for assessing investment returns and project planning, focusing on growth projections and risk analysis.
DownloadMultivariate Risk
An example of multivariate distribution analysis with a detailed breakdown in the associated article about statistical modeling.
DownloadPortfolio Analysis
A comparative model of two distinct portfolios over a set period, illustrating the effects of different investment strategies.
DownloadRetirement Strategy
A basic retirement portfolio model that evaluates potential portfolio risks with fixed annual withdrawals.
DownloadRisk 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.
DownloadRisk/Opportunity Model
This spreadsheet evaluates conditional risk and opportunity asd scenarios, calculating the potential impacts based on predefined probabilities and outcomes.
Download
| 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 |