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
Free version (proprietary and closed-source): This can be used for personal and commercial use, but the user cannot modify the internal settings that decide the asset allocation based on risk-reward balance. Available only in Exe format that will work on Windows Excel 2007 and upwards.
If you are an investor, the free version is fully featured and should suffice. The only downside is that you cannot change assumptions, check the math and need to wait for bug updates. If you an advisor, the free version is pretty realistic and your clients would run away if you assume only 10% return from equity. You could consider buying the open-source version so that you can change equity returns as 18% and inflation as 3%.
Mac users will have to either use the free version on a Windows machine or get the full version.
Paid version (proprietary and open-source) 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.
Paid Version: Get the paid version by paying Rs. 5160. I shall send you the file after payment confirmation.
Please note: Freefincal is a non-profit operation. You can support the websites and its future plans (eg. setting up the robo template online or as an app) by spreading word about the website; disabling ad-blockers while you are here or buying one of the versions below.
A robo template, by definition and design, should not be freely modified. Else it will reduce to a calculator. Hence the need to prevent access.
You can download it as a .exe file from this google drive link (no need to sign into Google)
Download the Freefincal Robo Advisory Template (Version 4 June 20th, 2018)
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.
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 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.
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.
If your anti-virus claims it is a virus, then you can either trust me and treat it as a false positive or choose not to use the exe 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.
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”)