تمت ترجمة هذه الصفحة آليًا. النسخة الإنجليزية الأصلية هي المعتمدة.

جداول بيانات نموذجية

جدول بيانات الوصف إجراء
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. تحميل
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. تحميل
Investment Return Modeling This spreadsheet offers a foundational model for assessing investment returns and project planning, focusing on growth projections and risk analysis. تحميل
Bivariate Correlation This example demonstrates the use of bivariate normal distribution, showcasing correlated values and their application in financial models. تحميل
Portfolio Analysis A comparative model of two distinct portfolios over a set period, illustrating the effects of different investment strategies. تحميل
Multivariate Risk An example of multivariate distribution analysis with a detailed breakdown in the associated article about statistical modeling. تحميل
Retirement Strategy A basic retirement portfolio model that evaluates potential portfolio risks with fixed annual withdrawals. تحميل
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. تحميل
Risk/Opportunity Model This spreadsheet evaluates conditional risk and opportunity asd scenarios, calculating the potential impacts based on predefined probabilities and outcomes. تحميل