Last Updated on December 28, 2020
Get 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 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.
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
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
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. 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 Swaminathan.
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”)