Asset Allocation & Retirement Planning Model 2021 (FULLY EDITABLE VERSION)
Originally published: 15/01/2021 08:38
Last version published: 08/06/2021 19:52
Publication number: ELQ-42884-4
View all versions & Certificate
certified

Asset Allocation & Retirement Planning Model 2021 (FULLY EDITABLE VERSION)

FULLY EDITABLE model with specific investment suggestions and realistic financial projections at retirement and beyond..

Description
This model helps finalise a sound investment strategy to meet the ultimate goal of a stress-free life in retirement, while suggesting specific investments you can directly execute through your home banking, saving money on fees. Up to 32 currencies supported.

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 will evolve during your lifespan, using built-in assumptions;

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 (calculated by default, if no specific input provided)
• estimated capital gains tax (average based on Country of investor);
• estimated life expectancy

Financial projections also available on net present value basis.

The allocation process:
1.determining investable assets
2.creation of emergency fund (kept in checking and savings accounts) equal to your annual expenses plus a proportional margin
3.determining expected cash requirements for next 5 years, to be invested in safer instruments with maturities matching your future disbursements
4.allocation of 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)

For private investors, fees paid to banks and mutual funds managers can significantly impact portfolio performance. To build a well diversified portfolio keeping costs down the model assumes majority of investments in Exchange Traded Funds (ETFs).
For full explanation of terminology used and model specifics, it is recommended to go through the Glossary sheet as a first step.

This Best Practice includes
1 EXCEL WORKBOOK

Domenico Cristarella offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

To finalise a sound investment strategy to meet the ultimate goal of a stress-free life in retirement, while suggesting specific investments you can directly execute through your home banking, saving money on fees.

Private investors and everybody concerned about disposing of sufficient resources to cover retirement needs.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Domenico Cristarella

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Asset Allocation & Retirement Planning Model 2021 (FULLY EDITABLE VERSION)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...