Overview

Achieve greater diversification in your asset allocation by using this tool to calculate the correlation coefficient between any two variables, including stock market indexes, individual securities, commodities, currencies, interest rates.

The model calculates static or rolling correlations (12, 24, 36, 48, 60 months) for the given time period, based either on end-of-month values or monthly returns, going back to Dec. 1995. Including chart to visualize changes over time. 29 indicators included. You can replace any of them with the most appropriate ones for your analysis, by uploading historical values in the “Master” sheet.

Correlation statistically measures the degree of relationship between two variables in terms of a correlation coefficient that lies anywhere between +1.0 and -1.0. When it comes to diversified portfolios, correlation represents the degree of relationship between price (returns) movements of different assets included in the portfolio. A correlation of +1.0 means prices (returns) move in tandem (perfect positive correlation); a correlation of -1.0 means that prices (returns) move in completely opposite directions (perfect negative correlation). A correlation of 0 means the movement of one asset has no effect on the movement of the other asset. Well diversified portfolios should include uncorrelated or inversely correlated assets.

 

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
ASSET ALLOCATION & RETIREMENT PLANNING MODEL 2021 (FULLY EDITABLE)
232
0
ASSET ALLOCATION MODEL WITH REALISTIC PROJECTIONS OF FINANCIAL SITUATION AT RETIREMENT AND CALCULATION OF RESOURCES NEEDED FROM THEN ON. Fully…
INFLATION CALCULATOR (46 COUNTRIES)
1,253
69
This model actually includes two calculators: year-on-year inflation calculator flat rate inflation calculator   The first one calculates the equivalent…
RENT VS. BUY CALCULATOR
1,283
92
The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of…
PREPAID EXPENSE & UNEARNED INCOME CALCULATOR
1,622
116
THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…
NET TOTAL RETURN ON BOND INVESTMENT CALCULATOR
1,958
75
CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY, broken-down by trading gains (realized & unrealized), foreign exchange gains (realized…
ANALYTICAL RETURN ON INVESTMENT (ROI) CALCULATOR
1,962
159
This tool calculates return of an investment denominated in any currency, split between Realized and Unrealized and further dissected into…
See All