Simple how-to articles and free tools for financing your goals, managing your money, mutual fund and stock investments

Update: Download Version 2 of the Freefincal Robo Advisory Software Template

This is an update to the Freefincal Robo Advisory Software Template released in Sep. 2017. The robo template is free to use and can be used to create a “start-to-finish” money management solution for all age groups. In this first update, I have now added two features:

1: Many people have insurance policies with an investment component to it – endowment, money back, ulip etc.  If they wish to hold onto it, then they can now enter it as a “sum they will receive close to the goal deadline”. This was possible for retirement in version 1. Now I have extended it other financial goals.

2: The retirement inputs can handle three post-retirement income streams (rent, pension etc.). Now I have added an option for this income to start & stop any time during retirement. For example, you can now add a rental income that will start only the 5th year in retirement. Down the line, if you sell that property, you can revisit the robo template, and add the sales proceed in the calculation and set the rental income to stop from a certain year in retirement.  This is a screenshot.

My aim is pretty simple: I would like to make the robo template as practical to use as possible. A user with an old and cluttered portfolio should still be able to use it. The above two updates have been based on feedback received from users of the first version.

If you are existing robo template user, download this update only if the above changes will affect your inputs. If it will, you can go to the download link below to get the template.

If you wish to download the template for the first time, then please head over to the main page to understand its basic features and then download the latest version from there:

Main Page: Download the Freefincal Robo Advisory Software Template

Features Page: Key features of the freefincal robo advisory software template

Also see: PlumbLine: a handpicked list of mutual funds

If you have purchased the full version of the robo template (free version is fully functional, but settings cannot be changed), then I shall send this update to you. If you do not hear from me in a couple of days, please send me a reminder.

Available Options: Comparison Table

Free version of the freefincal robo advisory software template

Two versions, basic and advanced are available as .exe files. To know more about them, download them and also see the user guide videos, go to the main page: Download the Freefincal Robo Advisory Software Template

Paid, Open source version of the freefincal robo advisory software template

The features mentioned in this post (and many others) are hidden in the free version of the template. Those interested in getting full access (to present and future versions) can do so for a nominal* one-time fee by writing to freefincal [at]

*  nominal when compared to other robo software pricing schemes. Please don’t tell me what price you would pay. This is not an auction.

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.

Robo template for Mac: I have received several requests for this.  The Mac version is ready with a cool Mission Impossible-like a self-destruct feature if run on windows 🙂 However, I cannot provide the .xlsb file as is since it can be easily cracked. Therefore interested Mac users will have to pay a token fee to access the locked Exce file or can buy the unlocked version too.

Robo template for Libre Office: The terms of use will be the same as that for Mac. I need some time to get this working. Will announce it soon.

Robo template for Google Sheets:  Work in progress.

Robo template for the cloud/app:   If you know of a competent programmer who can understand algorithms (meaning someone who can understand in the first reading)  as well as has a basic investing knowledge, please ask them to contact me.


For enquiries, use freefincal [at] or this form

[contact-form subject=”Robo Template”][contact-field label=”Name” type=”name” required=”1″][contact-field label=”Email” type=”email” required=”1″][contact-field label=”Message” type=”textarea” required=”1″][/contact-form]

GameChanger– Forget Startups, Join Corporate & Live The Rich Life You Want

My second book, Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantco-authored with Pranav Surya is now available at Amazon as paperback (₹ 199) and Kindle (free in unlimited or ₹ 99 – you could read with their free app on PC/tablet/mobile, no Kindle necessary).

It is a book that tells you how to travel anywhere on a budget (eg. to Europe at 50% lower costs) and specific investment advice for young earners.

The ultimate guide to travel by Pranav Surya 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 ₹199 (you will be emailed the pdf after payment)

You can Be Rich Too with Goal-Based Investing 

My first book with PV Subramanyam helps you ask the risk questions about money, seek simple solutions and find your own personalised answers with nine online calculator modules.

The book is available at:

Amazon Hardcover Rs. 271. 32% OFF

Infibeam Now just Rs. 270  32% OFF. If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

Flipkart Rs. 279. 30% off

Kindle at (Rs.271) Read with free app

Google PlayRs. 271 Read on your PC/Tablet/Mobile

Now in Hindi!

Order the Hindi version via this link


Subscribe and join the freefincal Youtube community!

 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media

Do check out my books

You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first 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 customg solutions for your lifestye!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 want My second 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 youngearner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover 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 ₹199 (instant download)

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.
Updated: October 2, 2017 — 10:24 am


  1. Looks like the Start Year for annual income Step 2 sheet (cell F32) cant be modified. Says it is in protected sheet and have to unprotect it. Was that intentional?

    1. no, a mistake. Will correct it.

Comments are closed.

freefincal © 2019 Frontier Theme