Posted On: January 16, 2022

How to Analyze your portfolio objectively? Step 2: Identify the optimal asset allocation for your financial goal

I first refresh my memory on what I set to do with this investment. i.e. the goal of this investment.   I go by the dictum “a journey without a destination is an adventure” and want to avoid expensive adventures.

Let us say that this goal was to buy a car in 3 years from now. I wanted to invest ₹1L (₹100K) with view that it will become ₹1.4L (₹142K).  Let us also assume that I invested on 1 Jan 2019, today is 30 Dec 2019 (ease of calculations).

I now have 2 more years to go and I need to determine the following:

  1. The gain I made till now and compare to the gain I should have made till now for my goal
  2. The required rate of return to reach my goal
  3. My current asset allocation and identify the current weightage to an underlying entity
  4. The current market conditions and the return I should expect

Milestone 1: Compute the gain/loss till now

Table below shows the return I should make each year to reach my target

01-Jan-1930-Dec-1930-Dec-2030-Dec-21
       100,000        112,000       125,440       140,493

Milestone 2: Compute the required return to reach my goal

01-Jan-1930-Dec-1930-Dec-2030-Dec-21
Target values       100,000       112,000       125,440       140,493
actual       100,000       111,500  

I note that I made 11.5% compared to my target of 12% for the year 1. I am also note that I should make 13% in next year to compensate for the minor shortfall and keep the portfolio on track.

Milestone 3: Compute current asset allocation and determine my exposure to each issuer:

Now I compute the exposure to each underlying equity stock.  This step is a necessity to fully understand my collective exposure to the actual stock.

I now look at what the mutual funds I have invested are holding.  Lets us say for ease of simplicity the following table shows their holdings

FundInvested in% of NAVMy exposure on based on market value
Sundaram Corporate Bond FundReliance Industries25%       2,713
Sundaram Corporate Bond FundAdani Power25%       2,713
Sundaram Corporate Bond FundL&T infra25%       2,713
Sundaram Corporate Bond FundICICI Bank25%       2,713
    
Canara Robeco Equity Taxsaver FundReliance industries25%       5,500
Canara Robeco Equity Taxsaver FundMarico Industries25%       5,500
Canara Robeco Equity Taxsaver FundState Bank of India25%       5,500
Canara Robeco Equity Taxsaver FundTVS Motor Company25%       5,500

I now collate my entire holdings across my equity holdings, mutual fund’s underlying and FDs. 

IssuerExposure based on Market valueExposure %
State Bank of India  38,050.0034.1%
ICICI Bank  36,812.5033.0%
Infosys  12,000.0010.8%
Reliance Industries    8,212.507.4%
TVS Motor Company    5,500.004.9%
Marico Industries    5,500.004.9%
L&T infra    2,712.502.4%
Adani Power    2,712.502.4%

Looking at the exposure holistically I see that I have about 77% of my investments between 3 stocks i.e. State Bank of India, ICICI Bank and Infosys.   I use the term stocks here to represent the fact that I hold equity and /or debt instruments from these institutions.   Technically these would be called “issuer”.

This higher exposure might not necessarily be a bad thing, but I need to be mindful of where my money is invested by me and by the mutual funds, I have invested in.

Milestone 4:  Have a view on the market and individual stocks in my portfolio

Now I set out objectively to see if I will invest in these securities if I were to invest today or would I choose other asset classes or other assets.

This view is required to determine what is the best course from here.

I will deep dive into each stock, each issuer and read reports, market views on them.  My objective now is to have a view on the earning potential of each asset in my portfolio.

Once I have this view, I tabulate it as below to have a best- and worst-case scenarios

Asset classAssetInvested amountAsset allocation of InvestmentCurrent market valueCurrent asset allocationForecast return (highest)Forecast return (lowest)
Equity stocksInfosys₹ 10,00010%₹ 12,00011%10.0%8.0%
Equity stocksState Bank of India₹ 10,00010%₹ 10,5009%8.0%6.0%
Equity stocksICICI Bank₹ 10,00010%₹ 12,50011%12.0%10.0%
Mutual fundsSundaram Corporate Bond Fund₹ 10,00010%₹ 10,85010%7.0%5.5%
Mutual fundsCanara Robeco Equity Taxsaver Fund ₹ 20,00020%₹ 22,00020%11.0%9.0%
Fixed depositsICICI Bank₹ 20,00020%₹ 21,60019%8.0%8.0%
Fixed depositsState Bank of India₹ 20,00020%₹ 22,05020%8.0%8.0%

I now have all the information required to decide on the next steps.  In the next post we will discuss more on what my course of action would be.

Meanwhile, I welcome your comments. Stay safe and Happy Investing!

https://www.youtube.com/channel/UC9hJEd6udEI-eUHS9hJ1x8w

https://play.google.com/store/apps/details?id=com.xcaldata.goldennest

Similar Posts