Automated Return on Equity Analysis with the Dupont Formula

The 10th version of the freefincal automated stock analyzer includes an easy-to-understand graphical analysis of the factors that drive return on equity (ROE) using the five-step Dupont Analysis. Return on equity is defined as ROE = Net income/shareholders equity. It is the profit for each unit of shareholders equity or the earning power of the company….

Continue reading →

Correlation between Mutual Fund Returns & Capture Ratios

The correlation between mutual fund returns and the upside/downside capture ratios is discussed using Mid-cap mutual funds. It is no secret that I am a fan of the downside capture as a simple means of measuring downside protection, selecting and reviewing mutual funds. In this  post, the recently obtained downside Capture Ratio of all Mid-cap Equity…

Continue reading →

Stock Analysis Spreadsheet with Moneycontrol Financials

Dear reader, I write this to make two requests: (a) help beta test an Excel sheet that automatically downloads standalone or consolidated financials data (in new format or old) from MoneyControl, and (b) provide your feedback on how to improve the freefincal stock analysis spreadsheet. MoneyControl Financials Downloader The aim behind making this sheet is…

Continue reading →

Understanding Mutual Fund Investment Risk vs Reward

Although it has limited technical utility, the standard deviation is probably the simplest measure of understanding investment risk. Therefore, it has great practical value when it comes to ‘product positioning’ as the fund industry calls it. ‘Where does a given fund fall in the risk vs reward map?’. AMC often given a product positioning risk vs…

Continue reading →

How & when to choose Equity Savings Funds & Arbitrage Funds

Equity savings funds are the latest type of asset allocation mutual funds introduced first in late 2014 when the government made the duration for debt mutual fund capital gains to be classified as ‘long-term’ from 1-year to 3-years. Equity savings funds are basically arbitrage+equity+ debt  funds. They would hold a minimum of 65% equity (most…

Continue reading →

Review Your Financial Freedom Portfolio in Seven Easy Steps

All long-term financial goals require periodic review to ensure that they are on track and in line with expectations and assumptions made while planning for the goal. Here are seven easy steps to review the health of your financial freedom or retirement portfolio. First posted on Mar 25 2014, now republished with updates. Retirement is…

Continue reading →

Financial Freedom Calculator version 2: When can I retire?

Use this financial freedom calculator spreadsheet to answer questions like, “When can I retire?” and “When should I retire?” and hopefully understand the difference between them with minimal inputs. For a given age and life expectancy, along with other standard investment and inflation details, the years to retirement is calculated by determining when the monthly income…

Continue reading →

Are fixed income investors financially illiterate?

Any keen follower of personal finance space would have encountered their fair share of ‘why you should invest in equity?’ articles and ‘why equity alone is capable of beating inflation over the long-term’ arguments.  Things have come to such an end that fixed income investors are considered as not being financial literate. This kind of…

Continue reading →