This is a triple update announcement. Download new versions of the (1) freefincal robo advisory template – this gives you a start-to-finish investment plan; (2) Automated Mutual Fund and Financial Goal Tracker – this allows you to dynamically track your mutual fund investments and associated goals; (3) Automated Stock Analyzer with MorningStar financials – value a stock in multiple ways.
I have few more announcements as well
1: My first book, You Can Be Rich Too With Goal-Based Investing is now 40% off at Amazon (Rs. 239) do get yourself one
2: Last week I gave a talk on Index investing. I will record the talk and publish it (hopefully) this weekend. So stay tuned.
3: From next week, we shall start discussing market timing or tactical asset allocation (TAA) model. So sign up for email updates if you have not.
Freefincal robo advisory template
This will help you build an investment plan for all your future needs from start to finish. That is from how much to invest where, where to invest and how to modify the investment allocation year on year. This release is a major bug update.
Fee-only RIA Swapnil Kendhe – Vivektaru pointed out that I was taking the EPF/NPS contributions for retirement planning incorrectly. This has been corrected in the current 4th release. Existing users will have to redo steps 2 and 3.
The robo template is available as a fully functional free exe file and as a paid Excel file (Windows & Mac) where all internal settings can be modified. All existing users of the paid version have been emailed the latest update (all future updates are also free).
To explore the features of the template you can consult: Key features of the freefincal robo advisory software template
Additional features and the download link is also available here: Download the Freefincal Robo Advisory Software Template
Paid Version: Get the paid version by paying Rs. 5160. I shall send you the file after payment confirmation.
Automated Mutual Fund and Financial Goal Tracker
This is the only file I use for my investments. I wanted to build a tracker that tells me “where I am today” wrt my financial goals. A quick way to conduct a financial audit. In this age of free online trackers, this Excel file still has its users and I believe some of its features are not available elsewhere.
The usp of this sheet is that it shifts the focus from individual fund returns to portfolio returns and growth. It is entirely open-source, so you can modify it as per your wishes. You can explore more here: Features of the freefincal mutual fund and financial goal tracker
In this edition, I have updated the sheet to handle mutual fund scheme mergers and a way to plot the growth of the entire portfolio with time. So the Portfolio Growth Visualizer is now part of the tracker. Thanks to Anish Mohan for his help in this regard. Existing users will need to make these changes to the sheet
So you can now plot graphs such as the ones shown in Ten Years of Mutual Fund Investing: My Journey and lessons learned
I have, for now, removed the Capital Gains sheet from the tracker. Those interested can use the Mutual Fund Capital Gains Calculator. The advantage with this sheet is, you can check the potential CG of any amount that you wish to redeem today.
Automated Stock Analyzer with MorningStar financials
The automated stock analysis sheet
- pulls financials from morningstar and analyzes them
- pulls adjusted stock price history from money control, and
- calculates intrinsic value six different ways!
It also pulls annual (standalone/consolidated) and quarterly financials from Value Research online.
Valuation models available:
1) Price Multiple Model
2) Sustainable Growth Rate
3) Book Value Growth Rate (Buffett’s approach to valuation)
4) Discounted Cash Flow(DCF)
5) Reverse DCF Valuation
6) Graham formula and Graham number
7) Piotroski Score for the last 9 financial years
8) Earnings Growth Estimate.
9) Automated Return on Equity Analysis with the Dupont Formula
10) Altman Z-score
11) Hewitt Heiserman Jr.’s Earnings Power Box
I have now added a way for users to add missing morningstar stock codes.
Subscribe and join the freefincal Youtube community!
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google PlusandPinterest
Do check out my books
Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy 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 SuryaThis 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)
Free Apps for your Android PhoneAll 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)