Excel’s IRR and XIRR and simple but excellent tools to estimate the returns from a periodic investment in a volatile instruments (eg. Mutual fund SIP). Unfortunately, two issues affect its usage: Bug(s) of unknown origin that make it give the wrong result sometimes. Read more about this here: XIRR: A Bug? (Thanks to financial planner…
Continue reading →A retirement plan is a road map that helps you understand, plan and prepare for a financially independent life post-retirement. Well, that is what it is supposed to be! Unfortunately, each person’s retirement roadmap is unique. While past and peer experience can aid to a certain extent, it is entirely up to us to chart…
Continue reading →Use this tool to analyze the returns from monthly SIP investments in mutual funds for investment periods ranging from one to seven years. For comparison, SIP returns of an equity index (choose among Sensex, Nifty, CNX small cap and CNX mid cap) is also calculated. Features Choose the mutual fund you need to analyze, click…
Continue reading →In the last couple of days AMFI has changed it web address! From www.AMFI.com, it is now http://portal.amfiindia.com Therefore, I had to make this change in the mutual fund NAV history downloader. Also, while working on a mutual fund SIP returns analyzer, I noticed minor bugs in the mutual fund account statement generator and returns calculator….
Continue reading →This is an update to the Excel Mutual Fund NAV History Downloader posted a few days ago. I have now included the possibility of retrieving NAV history from the AMFI website in addition to Yahoo! Finance. Can retrieve NAV history of all mutual funds from AMFI up to April 3rd 2006 If you need NAV history from…
Continue reading →Unfortunately, Value Research Online changed their website format shortly after this tool was released. I often wonder if they did that because of this tool! So this tool does not work anymore. I only keep this post for sentimental reasons. If you wish you to analyse your mutual funds try these: Mutual Fund Rolling Returns…
Continue reading →Inflation – a gradual decrease in purchasing power with time – affects all human beings. The average inflation in India is more than twice the average inflation in the US. Will inflation in India ever increase? Many seem to believe that after a long time (say a couple of decades later) inflation will decrease, as…
Continue reading →Features Get full historical NAV from inception – not possible with the painful to use AMFI site. Fast download! Select frequency: daily/weekly/monthly Sort ascending or descending For dividend mutual funds obtain dividend history alone Suitable for Indian Mutual Funds only. Uses of Mutual Fund NAV history 1. Using calculators available at freefincal: Generate Mutual Fund…
Continue reading →No matter how often we mention/promote/advertise that equity investments if continued over a long enough period would generate handsome returns, many investors seem to require constant reassurance and encouragement to continue their equity investments. A person who wishes to remain anonymous made the following SIP rolling returns analysis with Sensex data to provide his friends…
Continue reading →Excel’s IRR and XIRR functions are often used to calculate the rate of investment returns. In this post, let us discuss the limitations of XIRR and IRR functions. Credit: This discussion is inspired by financial planner Mr. Hari who posted a video describing the limitations of IRR and XIRR on my XIRR calculator page. The video (a must…
Continue reading →Here is a list of calculators and resources related to fixed deposit (FD), recurring deposit (RD) and debt mutual funds. 1. Fixed Deposit and Recurring Deposit Calculators FD-Maturity value Comprehensive Fixed Deposit Calculator – I: Total and Advance Tax Liability Comprehensive Fixed Deposit Calculator – II: The Income Clubbing Headache Variable RD Calculator Comprehensive Recurring…
Continue reading →Use this excel tool to generate an account statement and calculate returns for your mutual fund SIP investments using NAV history. First, a few thoughts about calculating SIP returns. There are many ways to calculate returns from a SIP investment using Excel. Many prefer to use a function known as XIRR to estimate returns. Yes,…
Continue reading →Analyzing the performance of a mutual fund is not rocket science. Anybody can do it, just as anybody can select a mutual fund following a few simple rules. I would like to prove my point with a do it yourself mutual fund analysis using HDFC Top 200 fund – one of the most popular mutual funds in…
Continue reading →Here is a list of all the Excel-based free personal finance calculators available for download in the blog. This list will be available in a separate page in the navigation menu. If you see calculators you have not checked out before, do give them a try this weekend. If you find the calculators useful, please…
Continue reading →XLMFTrackerAG, an Excel based mutual fund portfolio tracker, is another excellent offering by Satish Mistry, financial planner at MoneyCare Financial Planning. Satish recently developed a comprehensive financial planning tool. XLMFTrackerAG is suitable for individual investors, financial planners and independent financial advisors to manage a mutual fund portfolio. Financial planners can easily process the portfolios of clients…
Continue reading →