Overview

ASSET ALLOCATION MODEL WITH REALISTIC PROJECTIONS OF FINANCIAL SITUATION AT RETIREMENT AND CALCULATION OF RESOURCES NEEDED FROM THEN ON. Supporting up to 32 currencies. Fully editable version available, with investment suggestions.

This model helps finalize a sound investment strategy to meet the ultimate goal of a stress-free life in retirement, while suggesting specific investments you can even execute directly through your home banking, saving money on commissions.

This is primarily achieved by:
• establishing an adequate asset allocation methodology based on age and current net worth;
• projecting your current saving capacity, estimating how earnings, operating and capital expenditures might evolve in your lifespan.

For this purpose, the model uses a set of built-in assumptions:

  • average return of equity, bonds and real estate portfolios, based on last 10 years performance of relevant benchmark indexes;
  • expected inflation development, based on last 10 years history;
  • age at which earnings and expenses are expected to peak (based on broad statistical data);
  • estimated evolution of capital expenditures;
  • estimated capital gains tax;
  • estimated life expectancy.

The allocation process:
1.determination of investable assets
2.creation of an emergency fund (kept in checking and savings accounts) equal toannual expenses plus proportional margin
3.determination of expected cash requirements for next 5 years, to be invested in safer instruments with maturities matching future disbursements
4.allocation of the remaining funds to higher-risk instruments (Equities, Bonds, Real Estate)

Altogether, the model incorporates 3 key functionalities, each one generating a specific  asset allocation proposal:

  • PORTFOLIO STRUCTURING plus REBALANCING (main feature)
  • LUMP-SUM INVESTMENT (excess liquidity invested all in one go)
  • ACCUMULATION PLAN (younger people, lower net worth, periodically investing the same amount)

 

Full explanation of terminology used provided in the Glossary sheet.

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
RETIREMENT PLANNING MODEL **ADJUSTED FOR INFLATION**
1,589
61
ESTIMATES THE EVOLUTION OF YOUR INVESTABLE ASSETS UNTIL RETIREMENT AND THROUGHOUT YOUR LIFESPAN. CALCULATES YOUR LEGACY NET WORTH, INCLUDING FUTURE…
SIMPLE ASSET ALLOCATION MODEL
3,569
176
This simple model makes it easy to determine how to best structure your asset portfolio, allowing effective risk and volatility…
TRADING SYSTEM (ENHANCED 2022 VERSION)
5,440
242
Designed to support medium term investors who hold onto positions for days, weeks or even months. Best suited for investors…
ASSET PORTFOLIO REBALANCING TOOL (2022 RELEASE)
4,978
267
THIS TEMPLATE MAKES IT EASY TO PERFORM PORTFOLIO REBALANCING CALCULATIONS, IN ORDER TO DETERMINE QUANTITIES TO BE PURCHASED OR SOLD…
ASSETS CORRELATION MODEL
6,263
281
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)
5,940
263
This enhanced and updated version of the model includes two calculators: year-on-year inflation calculator flat rate inflation calculator The first…
See All