The freefincal robo advisory tool is now available on Google Sheets. You can use it to plan from start to finish for retirement (early, normal, before and after), one-time financial goals (kids education), and recurring financial goals (vacation, appliances, etc.).
The tool would help anyone aged 18 to 80 plan for retirement with a detailed cash flow summary, six other one-time financial goals and four other recurring financial goals.
More than 1000 investors and financial advisors use the tool. The tool was recently featured in the Economic Times: Meet Pattabiraman, the man who helps many plan a better retirement with his calculators.
All entries are fully customizable. It can also be used for commercial purposes. Users will also receive all future updates.
Presentation: The tool is available
- as an Excel file with macros. It will work on Mac Excel and Windows Excel.
- on Google Sheets with scripts (replacing Excel macros)
This is a screenshot of Google Sheets editions. The screenshots and video guides below for Excel editing also applies to Google Sheets editing.
There are nine sheets with the following steps. A detailed video guide is available.
Click to play
Robo Consulting Software: Read Me First
This is the End User License Agreement. The user must give his consent during the first use.
Step 1: User age
A simple solution is proposed for 18 to 25 year olds without any other contribution. Older users will be asked if they are married or not and will be directed to the next sheet.
Step 2 Retirement entries
Here you can enter the details relevant to the creation of your retirement plan
You can include up to three post-retirement income streams
Step 3 Retirement planning
This sheet tells you the investment strategy to adopt before retirement (and until retirement) with a clear breakdown of assets and suggestions for managing the investment portfolio.
If you are retired, you can get an opinion on the health of your retirement corpus.
and a detailed retirement basket 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 4 A: Non-recurring goals
You can get a complete investment strategy for one-time goals like your children’s education, a business, etc.
Step 4 B: Recurring Goals
You can also plan recurring goals like a vacation every two years, or a new car or iPhone every few years.
Step 5: Suggested Product Categories + “PlumbLine”
Investment suggestions for financial goals are listed here. Additionally, PlumbLine offers a set of mutual funds to invest in.
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
How to use the Robo advice tool to check if you’re ready to retire
Get the Robo Advisor Tool
All entries are fully customizable. It can also be used for commercial purposes. As of May 2022, over 1000 investors and financial advisors are using the tool. Users will also receive all future updates.
Google Sheets edition (with scripts): Get the robot tool by paying Rs. 5160 (Google Sheets edition; instant download. No refunds allowed). One-click purchase.
Excel edition (with macros): It will work on Mac Excel and Windows Excel.
Get the robot tool by paying Rs. 5160 (Excel edition; instant download. No refunds allowed). For help write to freefincal [AT] Gmail [DOT] com. Please download the file and open it using Excel. One-click purchase.
Outside India? Then use this Paypal link to pay 80USD (please write to freefincal [AT] Gmail [DOT] com after paying).
Beta Testing Team: The robot tool has been tested and improved 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 (Follow him on Twitter!!), Srinivasan SR, Sajo C Mathew, Prof. Shriram R, Srinivasan Sundararajan, Sumit Nisal, Vignesh Baskar, Balaji Swaminathan, Amarnath Reddy. I am indebted to them for their time, effort, consideration and dedication. Without their help, this outing would not be possible.
Share this article with your friends using the buttons below.