Overview

THIS TEMPLATE MAKES IT EASY TO PERFORM PORTFOLIO REBALANCING CALCULATIONS, IN ORDER TO DETERMINE QUANTITIES TO BE PURCHASED OR SOLD TO MEET SPECIFIED TARGETS. It also allows increasing/decreasing volumes and changing % weights to the lowest level of detail. Up to 32 foreign currencies supported. It comes with sample data.

 

Rebalancing is the process of realigning the weightings of an asset portfolio. Rebalancing involves periodically buying or selling assets to maintain an original or desired level of asset allocation or risk. For example, say an original target asset allocation was 50% stocks and 50% bonds. If the stocks performed well during the period, it could have increased the stock weighting of the portfolio to 70% and reduced the bond’s to 30%. The investor may then decide to sell some stocks and buy bonds to get the portfolio back to the original target allocation of 50/50. Rebalancing gives investors the opportunity to sell high and buy low, taking the gains from high-performing investments and reinvesting them in areas that have not yet experienced such notable growth or that are generating losses. Rebalancing is highly recommended at least once a year, but not too often, to keep your transaction costs down. 

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
TRADING SYSTEM
1,077
43
This model is designed to support medium term traders who hold onto positions for days, weeks or even months. It is not intended…
ASSETS CORRELATION MODEL
1,566
85
Achieve greater diversification in your asset allocation by using this tool to calculate the correlation coefficient between any two variables, including…
INFLATION CALCULATOR (NEW VERSION - 50 COUNTRIES)
2,017
100
This enhanced and updated version of the model includes two calculators: year-on-year inflation calculator flat rate inflation calculator The first…
RENT VS. BUY CALCULATOR
1,852
140
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
2,443
161
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
2,747
99
CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY, broken-down by trading gains (realized & unrealized), foreign exchange gains (realized…
See All