My personal financial audit 2017

Each December I take stock of how well my goal-based investment is moving along (or is it?) Since 2013, I have been publishing these audits. Here is this years edition with some analysis of my retirement and sons-education goals. The only reason I am sharing this is to advertise the benefits of goal based investing. Kindly do not think that I am bragging. I come from a humble background and continue to live a simple, frugal life. As explained below, I have been lucky.

Before we begin, this is the archive of personal finance audits published before:

In addition, I would like to the draw the attention of the reader to these two posts where I had plotted the growth of my equity retirement corpus.

I lost the tracker file due to a computer crash. So for this year’s audit, I have not only recreated the growth of my retirement portfolio but also created a generic tool for anyone to use. This will be beta-tested among members of Facebook group Asan Ideas for Wealth before publication here.  As regards the crash, I have now become wise and auto-synched my entire drive to Google drive (at extra cost).

So what happened this year?

In April 2017, I  cut short my equity retirement portfolio and reduced it to three mutual funds (see below).

I also merged my son’s marriage goal with his education goal as I had not invested in it for many months (why? not enough money, that is why)

Then I rebalanced my son’s portfolio and reset it to 60% equity. Since I have a PPF account in his name, it was a simple matter of investing shifting from equity to PPF.

Again in December, I had to rebalance his portfolio again. This time, since PPF was unavailable, I put it in ICICI Equity arbitrage fund (this is debt-like in terms of risk and equity-like in terms of tax). Btw this is part of PlumbLine Dec 2017: my handpicked list of mutual funds – skin in the game and all that nonsense.

Other than that, I am two months short of investing for retirement as per my schedule – maintained since 2010 in this Excel: How tracking investments instead of expenses changed my life!

Why? No money again 🙂 Too many unexpected expenses.

2017 personal finance audit: Retirement

As I explained in last years audit, returns do not matter! Unless we are able to quantify the health of a portfolio in terms of our wants, there is no point in doing goal-based investing.

New investors can consider reading this: Review Your Financial Freedom Portfolio in Seven Easy Steps

I will consider two key questions:

1) How long can I draw an inflation-protected income if I retire today (age 43)? ~ 30 years (this assumes a pension from 80% annuitization of my NPS corpus) at 8% inflation and ~ 35 years at 6%.

Am I financially independent? I would like to think so. Sure, the corpus is not strong enough to last me till say, age 90, but I am not complaining.

2) How long can I draw an inflation-protected income if I retire as intended (age 65)? Well, beyond age 100. (this assumes a pension from 40% of the projected NPS corpus at 8% return)

If I can help it, I have no intention of retiring so it is clear that I do not need to invest for retirement if life was to play out like an Excel sheet. However, it is crucial to try and keep investing as I will explain in the next couple of days.

You can use the robo advisory template for your own audit The above two questions can also be answered by users of the automated mutual fund & goal tracker or with this monthly financial tracker.

My retirement portfolio

Equity mutual funds: 56%

PPF (self + spouse): 9%

NPS: 35% (please note NPS is mandatory for me and it is 85% bonds and 15% equity. I treat is 100% debt)

The equity folio is in:

HDFC Balanced + PPFAS Long Term Value Fund + Quantum Long Term Equity (approx equal exposure)

I do not invest via SIPS, but do invest each manually without looking at market movements. If your portfolio is Rs. 100 and you invest Rs. 1 a month, it is a waste of time and energy to worry about when to invest that Rs. 1. My only focus is on the Rs. 100 and reducing risk from it as best as I can.

This is the new portfolio growth animation.

This is the graph.
Reitrement equity portfolio Dec 2017 - My personal financial audit 2017

The arrow represents the redemption and transfer of mf units.

The reason why I have done reasonably well should be clear from the above graph: sheer dumb luck plus fortune plus an  Information Diet( Less Information Can Make us More Informed)

Luck & fortune enabled me to invest as much as possible during the sideways market after the 2008 crash. The information diet helps me to invest without worrying about star ratings or market movements or what fund is hot at AIFW.

Luck & fortune kept huge crashes out of my/our way in the last 9ish years (this is of course in hindsight).

This is the equity portfolio after NPS investments were started. Amusingly, I started equity investing two years before NPS. My NPS contributions were earning 8% in an employer account until the NPS was ready to accept the money.

With NPS Reitrement equity portfolio Dec 2017 - My personal financial audit 2017
NPS (blue) is marked on the right axis (blue)

How about returns?

The current XIRR of my retirement equity portfolio is  ~ 17%. NPS ~ 10%. PPF ~ 8% (just a guess).

PPFAS LTVF~ 19%; HDFC Balanced ~ 18%; QLTE ~ 15%

Naturally, that is pretty decent. but these numbers have no meaning without the proper context: how much is the corpus actually worth. That is what I have considered with those two question above – how long can I generate an inflation-protected income with the corpus. Those who are new to this idea may consult generating an inflation-protected income with a lump sum.

Or my free e-book: E-book: How to retire early in India

This is the reason I keep saying, stop harping on returns. They are useless.

Bitcoin investing: Many are curious if I have invested in Bitcoin. The answer is no. I have no need for it. I hope the above numbers make it clear as to why I have no need for it. I also do not have the health or the age to handle the volatility. I am at a stage where my only goal going forward is to reduce risk in my corpus. I am not interested in “investing a small amount in Bitcoin”. That is chicken feed and I have better things to do with my time. I am generally stupid (ask my wife), but even I am not that stupid to waste my hard-invested corpus on such a volatile asset.

If I was not an academic, 20+ or even 30-something today, I would have most likely invested in BTC too. There is nothing wrong with it. If you want to get ahead, you need to take risks in life. Just that my time for risk-taking is over, unless it is purely education.

My son’s education

This is my second long-term goal. I should say this was a long-term goal. Now that he is almost 8 and will be finishing school in about 10 years, it has now become a medium-term goal. After the two rebalancing transactions mentioned above, the current asset allocation is ~ 60% in equity mutual funds and 40% in PPF + arbitrage.

Again the only question that matters is – how much is the corpus worth?

1) If my son were to join college, would I able to afford a basic undergraduate education (even if I have to pay a big capitation fee) – yes.

2) If my son were to join college, would I be able to afford what he wants (thankfully he does not want much,so) – yes.

The corpus is also enough to handle his schooling (which is extremely inexpensive) and perhaps JEE preparation (I would like him to try and learn to prepare for a competition exam). Remember that joke about when should your kid start studying for JEE? The answer is true – before she/he is born (more on that in a later post).

From wanting to be a vegetable seller, I am disappointed to say that he now wants to study astronomy (sigh! I cannot handle another physicist in the family). So the goal post keeps shifting here. We need to keep that in mind while evaluating this goal.

My desire is to keep investing and maintain the 40% debt allocation for at least a few more years and hopefully that alone is enough to fund for his college. Then after keeping a part of it for his marriage, I can shift the equity portion as a medical expense corpus 🙂 This is the reason why I will not invest in my child’s name. I get to spend my money the way I want.

Notice how plans change as we go along. That is why the inputs of any calculator should be refreshed from time to time.

All this may make you feel as if I have a lot of money to invest. No. the is time, not money.  I have been investing for my son two months before he was born. That gave me an 18 year window to work(he will be 18 before he finishes school as he is Jan. born). Time is the ultimate currency and is even better than Bitcoin.

Son’education portfolio (XIRR ~ 16%)

Approximately equal allocation in HDFC Prudence (XIRR: 18%); ICICI Dynamic (XIRR: 15%); Mirae India Opportunities (~ 24% – don’t get excited it is a relatively recent investment)

What will I do if HDFC merges balanced with prudence (or vice versa)? I will continue to invest for retirement in “it” and stop investing for my son’s education and gradually shift or rebalance. Already both rebalancing transactions this year was from Prudence. So not a big deal.

So that is all for this year’s audit. You can use the robo advisory template to make up your financial and the automated financial tracker to automate the audit process.

The 2019 Lok Sabha elections

This December we have seen two events that will make the 2019 Lok Sabha elections a much closer contest than the 2014 one (the Gujarat elections and 2G verdict). This means one year from now, from the last quarter of 2018, the market will become edgy.  So if your goals are close, you better be careful. I will keep a close eye on my son’s education portfolio and rebalance as necessary and even consider reducing equity to 40% until there is clarity about the new government. As the goal investment duration becomes smaller and smaller, tactical withdrawals become important.


The idea of this post is to share my thought process on portfolio management.

Today your goals may seem far from completion. The first step is to gauge how far away it is. So that you can get there, one step at a time.

If you have any questions about managing your portfolio, post them as comments below. Please do not try to make sense of my numbers presented above. They are no relevance to you. Also please do not ask me why I have chosen X or Y or Z fund – I have already made my thought process clear in several posts before. Choose quiet but, consistent performers

Do check out my books

You can be rich 243x300 - My personal financial audit 2017You Can Be Rich Too with Goal-Based Investing, my first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now.  The kindle edition is only Rs. 199
Cover-pinkGamechanger, my second book is now only Rs 199 (Kindle Rs. 99).  Get it or gift it to a young earner 
Travel-Training-Kit-CoverThe ultimate guide to travel by Pranav Surya is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. You need to only cover my travel fare for the session.

Connect with us on social media

Do check out my books

You Can Be Rich Too with Goal-Based InvestingYou can be rich 243x300 - My personal financial audit 2017

My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now.  The Kindle edition is only Rs. 199.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Cover pink - My personal financial audit 2017 My second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

22 thoughts on “My personal financial audit 2017

  1. You are really very frank in your posts.
    You do have courage to think & act out of box.I will definitely try to imitate you in this aspects of personality.
    No query on your funds,but I feel any & all with reasonable thinking will agree with your fund selection.
    Sure,I have always found it wise to have common goal of Child Marriage & Education rather than to separate goals,as I find Marriage as a secondary goal ,primary goal is education.
    As it is well said,to learn how to find a fish is more valuable than being offered a fish,at least ,I am learning the same from your knowledge.But most want to have a fish rather than knowledge as to how to find a fish.
    Keep it up , Sir
    Well written,well executed,well intended post.
    Wish you Happy New Year 2018
    Dr.Rajnikant Gajjar

  2. Sir,

    Regarding your recent crash/file corruption and mention of syncing to Google drive, do note that syncing and backup are two different things.

    All syncing will do will be to copy over the corrupted file really fast over the online copy. While previous versions may be available, it’s usually worth it to invest in a proper backup solution, that can backup your drive contents periodically to either a secondary or an online location. You can google for multiple comparisons of such services.

    1. Many thanks. I did not think about that. G drive is the primary storage for freefincal backups, but I wanted a real-time backup. I understand a corruption will get copied too. I have been plagued with hard drive crashes thrice in as many years. Will use a backup solution instead of synch. Thank you.

  3. Being an IIT prof, teach your kid to become a billionaire, the best return ever any XIRR can not calculate. :p Just wondering sir why you don’t invest directly in stocks? I am 27 now & learning personal finance.

    1. IIT profs dont think about money! I am an exception. Why not stocks? Not my cup of tea. More time to fool around and learn with mfs.

  4. dear Prof pattu,
    thanks for sharing your audit and insights into it . much benefited .
    actually i went through the audits since 2013 .
    just few queries :
    in case of person , not having NPS , where one is supposed to invest for debt portion for long term goal ?
    it seems you prefer arbitrage fund over UST debt fund even for long term goal ?
    secondly , what is the rationale behind investing in low volatility funds for longest term goal like retirement as compared to more volatile funds for intermediate goal like child education ?

    1. Thank you. You can use debt mutual funds or arbitrage funds or PPF. I have and still use PPF as long term debt. Just that I have added arbitrage when I rebalanced. The tax free returns from arbitrage are attractive and simpler to book-keep.

  5. Three HD crashes in 3 years is not normal. May be you need to check the other components of your system and electrical system too. Or may be getting SSD is an option.

  6. Please see for a comparison and recommendations. If comfortable with Amazon AWS etc, you can use a 1 time purchase of a product like cloudberry backup ($30), and have it backup data to s3 and other data storage services. Fairly cheap (1 cent/gb type), and you only pay more when you have to do a restore. Might be worth if technically savvy, else use one of the recommended ones like Backblaze for $50/yr for unlimited backups etc.

  7. Brilliant as always. The thought to look at Dec 2018 was an eye-opener considering 2019 general elections. One may get tempted to book profits even if retirement is far away (it’s very dynamic in IT industry anyways)

  8. Thank you Pattu sir for your valid inputs in personal finance. I am at least 25 years away from retirement.My question is should one invest in NPS ? Even when one is invested in mutual funds?

  9. PPFAS Long Term Value Fund – 44% cash + debt
    Quantum Long Term Equity – 19% debt
    HDFC Balanced – 31% debt + cash

    Your equity part of the portfolio has 31 % debt + cash. PPFAS and Quantum LT by their very nature will hold on to large wads of cash. And HDFC Balanced by mandate has to.

    Assuming equity is 50 % portfolio, then your retirement portfolio has only 35 % real equity. Considering your retirement is another 20 years away, why is it so debt heavy?

    You are already timing the market with “tactical” withdrawls, then why do you have to choose such conservative funds?

    1. I neither knew I was making tactical withdrawals nor about the current portfolio of my funds. Too much information for me.

  10. I took the information about current fund portfolio from valueresearchonline. I have been watching the Quantum fund for about three years time (I am also invested in it). They generally sit on cash. Grapevine has it that PPFAS also loves cash (i.e. ultra value conscious). And the Balanced anyway has to.

    I think you mention above you will be making some withdraws before the 2019 general elections. I also remember reading one of your articles where you recommend “tactical withdrawal” as a means to keep asset allocation right. So I assume you do it yourself too. Pardon me if that was too audacious an assumption.

    For the shorter term goal “son’s education”, you have a “growth” fund (Mirae Asset India Opportunities) and HDFC Prudence – debt portion has good number of ultra long term bonds and more equity allocation that it’s sibling HDFC Balanced, while for retirement you have all ultra safe funds ?

    1. No worries. I do not track monthly portfolios and as of now I have not done anything tactical, so far. I have also not bothered to look at the style of the investment or the bond portfolio of balanced funds. Now you know why I said sheer dumb luck 🙂

Your feedback is valuable. Do let us know what you think about the article and help us improve