This simple model makes it easy to determine how to best structure your asset portfolio, allowing effective risk and volatility management through a balanced and diversified approach, providing basic guidelines for a safe and effective investment strategy.
Asset allocation is an investment portfolio technique that aims to balance risk by dividing assets among major categories such as cash, stocks, bonds, real estate.
Each asset class has different levels of return and risk, each behaving differently over time. The idea behind diversification is that a variety of investments will yield a higher return. It also suggests that investors will face lower risk by investing in different vehicles, rather than “putting all the eggs in one basket”.
The process of determining which mix of assets to hold in your portfolio is the result of many different variables, including age, savings capability, time horizon, and risk tolerance.
The sequence of the allocation process included in the model:
1. determining the amount of investable assets;
2. creating an emergency fund (kept in bank accounts and highly liquid instruments) equal to your annual expenses plus an extra margin, to cover excess volatility in equity investments, in proportion to the amount invested;
3. determining expected cash requirements for the next 5 years, to be kept in term deposits (or Government Bonds) with maturities matching your future disbursements;
4. allocating remaining funds to higher-risk instruments (Equities, Bonds, Real Estate, Commodities, Private Equity, Hedge Funds), based on the methodology table included in the worksheet, which can be modified to suit more or less aggressive strategies.
Similar Products
Other customers were also interested in...
Amortization Schedules Template (Loans, Mortgages,...
User friendly template including Amortization Schedules for Loans, Mortgages, Operating and Finance ... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Lending Company Financial Model – 5 Year Forecas...
This Financial model template presents a business scenario of a corporation engaged in granting loan... Read more
Asset Management Company – Closed End Fund M...
Financial Model presenting a scenario of a Closed-End Fund managed by an Asset Management Company. C... Read more
Crowdlending (P2P) Platform – 5 Year Financi...
Financial Model providing an advanced 5-year financial plan for a startup Crowdlending (Peer-to-Peer... Read more
Multi-Member Investment Fund Portfolio and Distrib...
A fund management tool to track many positions over time as well as distributions to up to 20 member... Read more
Investment Holding Company 3 Statement Financial P...
3 statement 5 or 8 year rolling financial projection Excel model for an investment holding company h... Read more
Investment Fund Preferred Return Tracker: Up to 30...
Track preferred returns for investors in a fund with this template. Premium joint venture tracking t... Read more
Leveraged Buyout (LBO) Financial Projection Model
User-friendly financial model to project and analyse the financial outcomes (IRR, projected financia... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
You must log in to submit a review.