Download the Freefincal Robo Advisory Software Template

/ M. Pattabiraman / 81 Comments

Published: September 7, 2017 at 9:57 am

Last Updated on

Photo of M Pattabiraman, founder, editor and primary author of freefincal.com By M. Pattabiraman   

Download the freefincal robo advisory software template to plan from start to finish for retirement (early, normal, before and after), non-recurring financial goals (child education) and recurring financial goals (Holiday, appliances etc.).

The template is presented in two versions – basic and advanced (the differences are explained below).  The template would help anyone from ages 18 to 80 to plan for their retirement, six other non-recurring financial goals and four other recurring financial goals with a detailed cash flow summary.

Adapted from a picture by Fabian Vervelde

Preview: Freefincal Robo Advisory Template

This is a preview published in the last post.

There are nine Sheets with the following steps. A two part detailed video guide is available below.

Robo Advisory Software: Read me First

This is the end user license agreement. The user will have to agree to this upon first use.Robo advisory software free download

Step 1: Age of the user

For ages 18 to 25, a simple solution is provided with no further inputs. For older users, they will be asked if they are married or not and directed to the next sheet.

Step 2 Retirement Inputs

You can enter details relevant to creating your retirement plan here

You can include up to three post-retirement income streams

Step 3 Retirement Planning

This sheet tells you the investment strategy to be adopted before retirement (and up to retirement) with clear asset allocation break up and investment portfolio management suggestions.

If you are retired, you can obtain an opinion about the health of your retirement corpus.

and a detailed retirement bucket investment strategy in case the corpus is good enough.

You can play this simulation game to understand how the bucket strategy works: The Retirement Bucket Strategy Simulator

In the advanced version, you can create your own retirement buckets.

Step Four A: Non-recurring Goals

You can get a complete investment strategy for one-time goals like your children’s education, a business etc.

Step Four B: Recurring Goals

You can also plan for recurring goals like a holiday every other year, or a new car or iPhone every few years.

Step 5: Suggested Product Categories + “PlumbLine”

Investment suggestions for financial goals are listed here. In addition, PlumbLine offers a set of mutual funds to invest.

 

 

Join our 1300+ Facebook Group on Portfolio Management! Losing sleep over the markt crash? Don't! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community

 

 

Step 6A: Independent portfolio vs Unified portfolio

The cash flow for two different portfolio models is available in the advanced version and only the independent portfolio in the basic version. You can see the video for more details.

This is a screenshot of step 6A.

Step 6B: Cash Flow

Independent portfolio

Unified portfolio

Robo Advisory Software: Presentation

All settings can be freely changed. Can be used commercially proper credits. Those who have purchased the paid version will get all future updates (including this one) as well. This is an Excel file that will work on Windows and Mac.

Get the robo template by paying Rs. 5160 (NO refunds allowed). I shall send you the file after payment confirmation. Version date: (Version 4 June 20th, 2018). Outside India? Then use this Paypal link to pay USD 80 (write to freefincal at Gmail after you pay)

 Robo Advisory Software: User Guides

Part 1

Part 2

Beta Testing Team

The robo template was tested and enhanced by a team of friends and readers for over a month:

Anirban Ghosh, Anish Mohan, Dashrath Memane, Guru Rudagi, Lokesh Shah, Mahesh Bangadkar, Muthu Krishnan V, Niranjan Kaushik, Prajal Sutaria, @Prashanth_Krish (twitter handle follow him!!), Srinivasan S R, Sajo C Mathew, Prof. Shriram R, Srinivasan Sundararajan, Sumit Nisal, Vignesh Baskar, Balaji Swaminthan.

I am indebted to their time, effort, consideration and dedication. Without their help, this release would not be possible.

Your Feedback & Feature Enhancements

I eagerly await your feedback about the template. Please report any bugs so that I can immediately release an update. Also, mention any additional features that you have in mind.

Thanks to Amarnath Reddy for pointing out that Step 2, B24 refers to annual income and minor incorrect cell references. Both are corrected.

Alea iacta est (“The die is cast”)

Do share if you found this useful
Join our 1300+ Facebook Group on Portfolio Management! Do not lose sleep over your bleeding portfolio: Learn how to reduce fear, doubt and uncertainty while investing for financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community
Hate ads but would like to support the site? Subscribe to our ad-free newsletter and get beautifully formatted full articles delivered to your inbox!

About the Author

Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice.
He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association. For speaking engagements write to pattu [at] freefincal [dot] com

About freefincal & its content policy

Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. We operate in a non-profit manner. All revenue is used only for expenses and for the future growth of the site. Follow us on Google News
Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication.Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)

Connect with us on social media

Our Publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingThis book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.
  

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

Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new

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

Free Apps for your Android Phone

Comment Policy

Your thoughts are the driving force behind our work. We welcome criticism and differing opinions.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.

81 Comments

  3. Excellent work Pattu. I can see the humongous effort behind this and I appreciate the fact that this is non profit.

    I assume one way of paying back is by directing friends to your blog. This Robo Advisory Software Template will only make it easy sell for me. This is one of your best templates and very easily understandable.

    I have been asked many times by my friends and family about where should they input their investments like gold and real estate. I understand gold and real estate may not be great investment options but they already hold a considerable amount towards goals like wedding and retirement. Kindly share your thoughts or redirect if you have already addressed this.

    Thank you.

    Reply

    1. Thank you so much. They can enter a notional value for gold and real estate in the current assets. Maybe gold along with fixed income and real estate along with equity (or fixed income!) as per their return perception.

      Reply

  4. A bug in the Robo advisory – in Step 2 sheet.B24 column, ‘Annual pay’ is to be mentioned. The same value is taken as ‘Monthly pay’ in Step 6B.K8 column.

    Reply

  5. Dear Prof. Pattu,
    Thank you for this tremendous piece of work. I can only imagine the amount of hard work you had put into this. Hats off to your dedication and motivation.

    Just my observation, i was under the impression that due to Plumbline , there would be an evaluation of risk profile as part of robo advisory. Is it beyond the scope of robo advisory template? IMO, The combination of Risk Profile+Robo Advisory+Plumbline would have been a complete package. Just my 2 cents.

    Once Again, Thank you for helping and guiding a novice like me.

    Reply

    1. Thank you very much and also a fantastic question. Yes a risk profiler is missing. For two reasons: 1) I am not impressed by them as imo they can mislead the planner. 2) I am trying to make one and see if I can solve existing issues but it is a big challenge 🙂

      Reply

  6. Hi Pattu, It is an excellent product and very comprehensive and detailed. I have a few suggestions/points to make:
    1. Since this template is designed for people from 18 to 80, I feel that the focus is more on the accumulation phase of retirement corpus. For people approaching retirement or retired, income generation strategies from the corpus will be very helpful. Why can’t the retirement bucket strategy be incorporated into the template. This will be especially useful for DIY investors.
    2. Fixing the retirement phase till the age of the younger spouse is 90 makes it rigid (Worksheet Step 3 cell B3). This should be open to modification by users.
    3. In the worksheet “Step 2 Retirement Inputs” Cell B19, monthly EPF contribution is taken which is debt portion. I suggest, monthly equity contribution (SIPs) should also be taken input.
    4. Also notional value of any Real Estate asset that is owned can be taken as an input as I have seen retired people selling/buying property either to be near their adult married kids or in a retirement home

    Reply

    1. Thank you Madam.The retirement bucket strategy is implemented for all ages but not shown unless you are ready to retire.
      Age is fixed at 90 by design. Cannot be too flexible with a robo template.
      Equity sips need be an input. Since equity investment is shown, you can compare that with what you already invest.
      NOtional value of RE for now can be added as lump sum benefit after tax upon retirement in Step 2.

      Reply

  7. Dear Prof. Pattu,

    Great work in building the tool.
    I tried the basic version of the tool ,although it looked daunting at first glance, I was able to navigate through it and fill the required numbers and and was able to come up with the final numbers in less then one hour time.

    Happy to say that my current planned investments matches the number suggested by the tool :).

    One small feedback , it will be good to have a column in the sheet “Step 6B Cash Flow” which to show the Total Monthly investment required (sum of column M and O). It will give a one final number on how much to invest.

    Thanks
    Debashish

    Reply

  9. Win 10 EMET is blocking this exe file from opening with a message that it is trying to make simexecflow which I understand is expected but WIN treats this is danger due to exe form. I don’t know about everyone but whoever uses genuine latest OS and genuine Microsoft Office versions could have problem as Win blocks this exe due to EMET! Can’t the excel file be locked not to make changes to it and release excel format? Exe will cause one or the other problems for latest WIN users.

    Reply

    1. Can’t the excel file be locked not to make changes to it and release excel format? If only it was as simple as that! There are only three choices : 1) allow the file to run (many have); 2) purchase either the locked excel file or the open source file or 3) ignore the whole thing.

      Reply

      1. Dear Pattu,

        Greetings!
        We appreciate your work and great contributions.
        I have just paid for Robo Advisory Software template (Order# MOJO9424105N27502297)

        Reply

  10. EMET doesn’t allow any such individual exceptions for unverified publishers. EMET already whitelists excel, wordpad etc. It blocks exes which try to execute on a computer and if that comes from an unverified publisher. Only option is to uninstall EMET and give up security of a computer but that may be concern due to security obviously and be worry of Ransomware etc. I was curious to see the ideas and suggestions behind the Robo. But though I don’t like I’m chosing the 3rd option.

    Reply

  11. after filling data in “Step 4A Other goals’ Goal 1 and clicking the Investment Requirred button the tool throws following error.

    Run-time error ‘1004’.
    The password you supplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalisation.

    I tried by downloading multiple time but same error.

    Reply

  12. Hi. I have been an ardent follower of your site since last 1 year. I am really excited for this software, however I would like to know can it suggest mutual funds, and track my portfolio growth based on live data like most financial sites do? Also it would be great if it can show the exposure overlap etc.

    Reply

    1. What issue are you facing? Exe blocked by anti-virus? Are you referring to password protecting Excel files like ITR utility? That can be cracked in under 3 seconds.

      Reply

  15. I have checked the download link with Kaspersky virus desk as mentioned and it says the link is clean. However, my antivirus software ( Quick heal ) always detects the trojan viruses in both the files in the compressed format and immediately it quarantines it. Any help?

    Reply

    1. Meaning, you will have to tell your anti-virus software to treat this as valid file. If you dont want to do this, you can buy the Excel sheet.

      Reply

  20. Adding even a small annual income amount of Rs.20,000/- with yearly increase of 5% in the post-retirement income cells (Step 2, cells B32 to B41) makes a dramatic difference in the figures generated in step 3. Considering the annual income of Rs.20,000/-, I can retire now without any further corpus required but when I consider the annual income as zero I will need an additional corpus of Rs.1.6 crores for inflation protection income after first 15 years in retirement. Why is this so? Are the current annual income figures in cells B32, B36 & B40 in step 2 calculated as annual figures or monthly figures?

    Reply

    1. It is annual income everywhere. And yes, it makes a huge difference – 20K annual income with 5% yoy increase is a big sum, but donr expect it to be equal the difference in corpus needed.

      Reply

  21. What a stroke of luck! I may be receiving a large chunk of money soon (no, no one is dying and no, I didn’t win a lottery!) and wondering how best to invest it when I read this article and another article on fee-only planners.
    Thank you for both!
    Excited to try this software and see the results.

    P.S. Is it possible for you to have a ‘Donate’ option on your website and as soon as you get enough money there (and I’m sure you will) please remove these ads on your website. There are so many download buttons of varying sizes, it is confusing. I’ve given up on quite a few articles beacuse of this.

    Reply

    1. Good to know. Tried the “donate” thing. Does not work. Since my traffic has increased the ads are necessary to pay for server costs.

      Reply

  24. Hi Pattu,

    I wanted to express my sincere thanks for this outstanding template. I can very well imagine the amount of effort and dedication that this work must have taken. You have made financial planning accessible and empowered many DIY investors. Hats off!

    I have been maintaining a very basic Financial Statement template of my own since FY08. I have been tinkering with it over the years to add some simple features. Right now, it contains a balance sheet (assets vs liabilities), financial journey chart, budget tracking, simple calculators and financial ratios (solvency ratio, debt-to-asset, etc). I can send you the template if you like.

    One input – it would be good to track the current value of goals against the plan. Essentially, a financial goal tracker. This could even be a separate simple Excel. It is immensely satisfying to see the line graph of assets and liabilities over time and confirm that we are on track for the goals. I am speaking from personal experience 🙂

    This template came at the right time for my annual review and filled a major gap of “correct” financial goal planning.

    I have loved all your MF calculators. But, this is your master piece. Once again, thank you!

    Regards,
    Anand

    PS:
    The only way I contribute back is buy your books and point my friends to the website and articles. This is a very very small return for the service. For yours is service in its true sense.

    Reply

    1. Thank you so much. You made my week! I have other sheets to track assets. It will be unwieldy to include that here.

      Reply

  25. Is there a way to save the file with the input I have entered?
    Right now when I try to save it says “This file cannot be saved in any other format” (even though I am not trying to change the format)

    This would be very helpful for updating the plan in case of income change etc

    Reply

  26. Cell B24 in step 2 pertains to Annual take home pay and the same figures reflects in step 6B. However, cell K6, K7 states monthly salary, Request you to resolve the discrepancy.

    Regards ..Angshuman

    Reply

  27. Hi Pattu,

    I tried the Robo Advisory software. It is brilliant and I love it. I will refer my friends and family to use it.

    I would like to bring to your notice one issue which stumped me for sometime. I entered the data sequentially sheet by sheet. When I went to the last sheet to view cash flow, it was in red and indicated insufficient funds.
    I traced back debugging the issue and then found that in the Sheet#4A, I had missed clicking the link on that sheet for ‘Click to find the investment amount required’.
    Only after clicking this, the amounts everywhere got updated and looked reasonable. Apparently the earlier default values of Goal were too high.

    Is this intentional – to wake up people into planning their retirement 😉 ??

    Reply

  28. Been following your blog regularly and the recent paisa visa podcast was great. Im a mac user and bummed that I cant use the robo excel. Guessing the only option is to buy the full version? or is there an update on this? Would be super helpful.

    Reply

  29. Hi Pattu Sir,

    I have the template version of year 2017. Will that be good enough to continue using it or should I go for latest paid version :)?

    I am not sure but the version which I have shows I need not to do any additional savings for my retirement corpus fund after I entered all the required inputs on tab 1 and 2. its very strange for me. I am confused if i did something wrong or my investments are really so good :)… For other goals surely it showing me the required investment to achieve the goal.

    Reply

  30. Hii I am kishorekani, Managing Director of SKST Chit Funds P Ltd. I am planning to create a investor presentation for my investors. So will your excel sheet help for chit Funds companies ??
    I would like to talk to you. Plz call me PH: +91-7899554400

    Reply

  31. Dear Pattu,
    I paid for Robo software. However, I have wrongly mentioned my email ID during the purchase process. Pls consider email ID (that I’m sharing thru below text box) for sharing the Software and further communication. Thank you.

    Reply

  32. Dear pattu sir ,i am trying to download free version of Robo Advisory software. but i am not able to download it ,every time it is going to other page ,Request you to please send the link to downloads it .thanks

    Reply

      1. Hello Sir,
        Please put the notice at the TOP. I already have this with me. However, same is on my office laptop (cannot transfer anything from here). Now I needed to download the same on personal laptop. I too struggled almost more than 1 hr to find the download link. Only to realize later that download is discontinued.

        Reply

  34. I don’t use Excel 🙁 Is there any chance of porting this to Kingsoft Spreadsheet which is an open source alternative to Excel?

    Reply

  35. Hello Pattu Sir,
    Is there no free version available for this robo template?
    Can you provide the basic version for free download?
    Will be really helpful.

    Regards
    Deep

    Reply

  37. Dear Sir,
    Your work is invaluable and gives immense knowledge to the beginner. Very practical approach.
    I did create some portfolio for investments with the help of VR . However, for the last 2 years, I developed an apprehension as the corpus keeps increasing, I doubt my investing choices and portfolio. Will you be able to review my portfolio?

    Reply

  38. Hi Pattu

    Can you please tell me where i can get the Robo advisory excel .

    Also can you help me with selecting the right Mutual funds .I am already investing 15 k monthly

    Reply

  40. Hello sir,
    I am not able to find the download link in this page. can you guide me how I can find the link and download the template.

    Reply

  42. Pattu Sir,

    Compared to the other tools like screener, this is more expensive… Surely this is feature rich and your work is hugely appreciated?

    Do you plan to reduce the price of this template so that many can use.. I understand some people abused it. But, with a price of 1k, only readers who are serious will buy it and the higher volume may increase the revenue for you also..

    Reply

  43. Pattu Sir,

    Please consider to reduce the cost of tool, it will for sure help many to use and get benefit with knowledge base you have created.it will change way many are seeing the life and plan long term planning. if possible please consider for selling it for Rs 1000 . I will be first one to get copy from you with reduced cost.

    Reply

  44. Is there a link in this page for downloading the free version ? I’m not able to find it among other ads which displays ‘Click here to download’. Please share the download link.

    Reply

  46. Great effort and certainly needs to be paid for. No free lunch. Kindly clarify if this will work on Microsoft Excel for Mac.

    Reply
  49. Pingback: Handpicked List of Mutual Funds April 2020 (PlumbLine)

Leave a Reply

Your email address will not be published. Required fields are marked *