The freefincal robo advisory instrument is now accessible on Google Sheets. You should utilize it to plan from begin to end for retirement (early, regular, earlier than and after), non-recurring monetary objectives (youngster schooling) and recurring monetary objectives (holidays, home equipment and so on.).
The instrument would assist anybody from ages 18 to 80 plan their retirement with an in depth money move abstract, six different non-recurring monetary objectives, and 4 different recurring monetary objectives.
Greater than 1000 traders and monetary advisors are utilizing the instrument. The instrument was not too long ago featured within the Financial Instances: Meet Pattabiraman, the person who helps many plan a greater retirement by means of his calculators.
All inputs are absolutely customisable. It may be used for business use as effectively. Customers will get all future updates as effectively.
Presentation: The instrument is accessible
- as an Excel file with macros. It should work on Mac Excel and Home windows Excel.
- on Google Sheets with scripts (a alternative for Excel macros)
This can be a screenshot of the Google Sheets editions. The screenshots and video guides under for the Excel version additionally apply to the Google Sheets Version.
There are 9 Sheets with the next steps. An in depth video information is accessible.
Click on to play
Robo Advisory Software program: Learn me First
Step 1: Age of the consumer
A easy resolution is supplied for ages 18 to 25 with out additional enter. Older customers can be requested if they’re married or not and directed to the subsequent sheet.
Step 2 Retirement Inputs
You may enter particulars related to creating your retirement plan right here
Step 3 Retirement Planning
This sheet tells you the funding technique to be adopted earlier than retirement (and as much as retirement) with clear asset allocation break-up and funding portfolio administration strategies.
In case you are retired, you possibly can receive an opinion in regards to the well being of your retirement corpus.
You may play this simulation sport to grasp how the bucket technique works: The Retirement Bucket Technique Simulator
Step 4 A: Non-recurring Targets
You will get an entire funding technique for one-time objectives like your youngsters’s schooling, a enterprise and so on.
Step 4 B: Recurring Targets
You can too plan for recurring objectives like a vacation each different yr, or a brand new automobile or iPhone each few years.
Step 5: Advised Product Classes + “PlumbLine”
Funding strategies for monetary objectives are listed right here. As well as, PlumbLine gives a set of mutual funds to speculate.
Step 6A: Unbiased portfolio vs Unified portfolio
The money move for 2 totally different portfolio fashions is accessible. You may see the video for extra particulars.
This can be a screenshot of step 6A.
Step 6B: Money Movement
Easy methods to use the Robo Advisory Software to test if you’re able to retire
Get the Robo Advisory Software
All inputs are absolutely customisable. It may be used for business functions as effectively. As of Might 2022, 1000+ traders and monetary advisors are utilizing the instrument. Customers will get all future updates as effectively.
Google Sheets Version (with scripts): Get the robo instrument by paying Rs. 5160 (Google Sheets version; Immediate Obtain. No refunds allowed). One-time buy.
Excel Version (with macros): It should work on Mac Excel and Home windows Excel.
Get the robo instrument by paying Rs. 5160 (Excel version; Immediate Obtain. No refunds allowed). For help, write to freefincal [AT] Gmail [DOT] com. Please obtain the file and open it by way of Excel. One-time buy.
Exterior India? Then use this Paypal hyperlink to pay USD 80 (Kindly write to freefincal [AT] Gmail [DOT] com after you pay).
Beta Testing Workforce: The robo instrument was examined and enhanced by a staff of pals 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 deal with comply with him!!), Srinivasan SR, Sajo C Mathew, Prof. Shriram R, Srinivasan Sundararajan, Sumit Nisal, Vignesh Baskar, Balaji Swaminathan, Amarnath Reddy. I’m indebted to their time, effort, consideration and dedication. With out their assist, this launch wouldn’t be doable.
Do share this text with your pals utilizing the buttons under.