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 free for personal and commercial use, but the user cannot modify the internal settings that decide the asset allocation based on risk-reward balance.
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.
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.
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
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.
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.
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
Robo Advisory Software: Presentation
You can download both the basic and advanced version as . exe files from this google drive link (no need to sign into Google) in zip format:
There is no need to worry about the .exe format. They are encrypted Excel files and will work in macro enabled Excel from 2007 version and above. Mac users or open office users contact me using the form or email given below.
I am working on an Excel-independent .exe file a possible Google spreadsheet version and an online version.
Before you download the .exe files to your computer, you can copy the above link and paste it at the Kaspersky VirusDesk and find out if the exe file is safe.
As a second check, you can then download the zip file, go to the folder, right click on the file and scan with your virus scanner. This is the result with Bitdefender in my computer.
MD5 Checksum of the basic version: f776c1a6b266d8c6ae51fb946489de06
M5 Checksum of the advanced version: 233bab56683aa9b3f818c69ce5998c16
You check the checksum of the downloaded file from your virus scanner or Kaspersky virusdesk to find out if the files are indeed the same if you are worried.
So please be rest assured you can open .exe files without fear of viruses or malware. Of course, when you execute or before executing the file, you need to let the windows user access control, Windows defender screen control, your anti-virus, anti-malware, internet securityware or your firewall permission to run the file.
Why .exe files instead of Excel? The free version of the freefincal robo advisory software is password protected. Excel password protection can easily be hacked so I had to look for an encrypted alternative.
Open-source version of the freefincal robo template
If you do not wish to work with .exe files or if you wish to work in mac or if you wish to modify the internal settings, or if you wish to support the freefincal robo advisory project (take it online from Excel) you can do so for a nominal fee by mentioning your requirements in this form or by writing to freefincal [at] gmail.com.
Robo Advisory Software: User Guides
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")
Use this form to ask Questions ONLY (For comments/opinions, use the form at the bottom)
And I will respond to them in the next few days. I welcome tough questions. Please do not ask for investment advice. Before asking, please search the site if the issue has already been discussed. Thank you. PLEASE DO NOT POST COMMENTS WITH THIS FORM it is for questions only.
GameChanger- Forget Startups, Join Corporate & Live The Rich Life You want
My second book, Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you want, co-authored with Pranav Surya is now available at Amazon as paperback (₹ 199) and Kindle (free in unlimited or ₹ 99 - you could read with their free app on PC/tablet/mobile, no Kindle necessary).
It is a book that tells you how to travel anywhere on a budget (eg. to Europe at 50% lower costs) and specific investment advice for young earners.
The 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)
You can Be Rich Too with Goal-Based Investing
My first book with PV Subramanyam helps you ask the risk questions about money, seek simple solutions and find your own personalised answers with nine online calculator modules.
The book is available at:
Amazon Hardcover Rs. 271. 32% OFF
Infibeam Now just Rs. 270 32% OFF. If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!
Flipkart Rs. 279. 30% off
Kindle at Amazon.in (Rs.271) Read with free app
Google PlayRs. 271 Read on your PC/Tablet/Mobile
Now in Hindi!
Order the Hindi version via this link