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 →Use this Excel based rolling returns calculator to evaluate the consistency in performance of your mutual funds and stocks by comparing them with their benchmark indices. Returns for a financial instrument that fluctuate can be calculated in two ways: Point-to-point returns: The effective annual compounded growth rate (CAGR) is calculated between any two dates. You…
Continue reading →This is a guest post by Aditya Veera. Aditya has studied and worked in finance, but this is the first article on investment he has written. Hopefully it is not the last. He holds an MSc from the London School of Economics and has an evangelical fervour for low-fee, passive investments! You can find his…
Continue reading →PPFAS Long Term Value Fund is advertised with a tagline: Only for “truly” long term investors! The funds scheme document states, “Investors should note that this scheme is suitable for investors who have an investment horizon of minimum 5 years”. Unfortunately,this can give investors the wrong notion that ‘long term’ implies duration of 5 years…
Continue reading →Here are updated versions of three fixed deposit calculators. FD calculator for investment tenure in months and years (tax to paid each FY and advance tax liability) minor bug fixed FD calculator for investment tenure in days (tax to paid each FY and advance tax liability) macro button added to stop and start calculations for…
Continue reading →