Sample Spreadsheets

SpreadsheetDescriptionAction
Asset PortfolioThis example demonstrates the creation of a 10-year asset portfolio using multivariate normal distribution to model the correlation between different asset classes.Download
Bivariate CorrelationThis example demonstrates the use of bivariate normal distribution, showcasing correlated values and their application in financial models.Download
Interest Rate Projections: Cox-Ingersoll-Ross ModelA 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 ModelingThis spreadsheet offers a foundational model for assessing investment returns and project planning, focusing on growth projections and risk analysis.Download
Multivariate RiskAn example of multivariate distribution analysis with a detailed breakdown in the associated article about statistical modeling.Download
Portfolio AnalysisA comparative model of two distinct portfolios over a set period, illustrating the effects of different investment strategies.Download
Retirement StrategyA 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 ModelThis spreadsheet evaluates conditional risk and opportunity asd scenarios, calculating the potential impacts based on predefined probabilities and outcomes.Download