Download the Freefincal Robo Advisory Software Template

Published: September 7, 2017 at 9:57 am

Last Updated on

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 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.

Adapted from a picture by Fabian Vervelde

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.Robo advisory software free download

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

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.

 

 

Join our 1500+ Facebook Group on Portfolio Management! Losing sleep over the market crash? Don't! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free! Did you miss out on the lockdown discount? You can still avail it! Follow instructions in the above link!

 

 

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

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 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”)

Do share if you found this useful
Share your thoughts on this topic at the  Reddit freefincal_user_forum

Reach your financial goals like a pro! Join our 1600+ Facebook Group on Portfolio Management! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free!
Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
About the Author Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice. He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association. For speaking engagements write to pattu [at] freefincal [dot] com
About freefincal & its content policy Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. We operate in a non-profit manner. All revenue is used only for expenses and for the future growth of the site. Follow us on Google News Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication. Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This 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 Rs 199 (instant download)
Free android apps