Financial planning template: Create your own financial plan!

Create your own personal financial plan with this excel-based financial planning template. Ever since I made my first retirement calculator, I have had several requests to make an integrated financial plan creation tool. The only reason I took this long to make it is sheer boredom. I thought, since I had already made most of…

Continue reading →

Retirement Planning: letter to a prospective client

Nandish Desai and Manish Chauhan run Jagoadvisor – a portal for financial advisors. Recently, they posed the following retirement planning challenge, Scenario: ‘You meet a 55 year old with a corpus of Rs. 70 lakhs. The person seeks financial independence in retirement and expects an annual inflation of about 8-9%. He would like to invest the corpus in…

Continue reading →

Do not buy Gold ETFs because you need gold for your child’s marriage!

On occasions like Dhanteras and Akshaya Tritiya, AMCs and fund distributors advice you to start gold ETFs for financials goals like a child’s marriage. For some reason, many around us seem to think that one must start investing in gold-ETFs because gold is needed for our children’s (typically daughters!) marriage. As a result, many end…

Continue reading →

Mutual Fund Rolling Returns Calculator

Use this automated mutual fund rolling returns calculator to evaluate the consistency in performance of a mutual fund over any interval from April 3rd 2006 onward. You can compare results with benchmarks like Sensex, CNX Nifty, CNX Small-cap, and CNX Mid-Cap. This version is a major improvement over the previous Excel Rolling Returns Calculator.  The analysis…

Continue reading →

Calculator Updates: AMFI MF NAV history downloader and MF account statement generator

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 →