The XIRR function which is available in MS-Excel is a simple function which can be used to calculate returns on investments when irregular payments are made or received. You can use XIRR function to determine the annualized returns on your investments like Mutual Funds, Stocks, insurance policies (Endowment / money-back / ULIPs), Chit funds, business […]
Financial Planning
Valuable Financial Planning lessons from ISRO’s Mars Orbiter Mission
India created history in space research. Amazing achievement by our ISRO (Indian Space Research Organization) scientists. I believe that each achievement in any field provides us an opportunity to learn. Yesterday’s achievement by our ISRO team also teaches us some important things which we can relate to personal finances. Identification of Goal & Time frame: […]
RBI’s data on Financial Savings of the Households
Recently the RBI (Reserve Bank of India)released ‘Handbook of Statistics on the Indian Economy-2014.’ This handbook is available to the public and is updated every year. Based on this handbook, I have tried to collate some important / interesting points related to Personal Finances. Like – Financial Savings of Households, total investments in bank deposits, […]
What not to Buy (or) not to Invest in….
The stock markets are at life-time highs. The economy is showing signs of recovery. I am receiving lot of queries from retail investors on what to buy in financial markets now.. Is this the right time to buy mutual funds? Is it good to enter the stock markets now? Is this the right time to […]
Five important formulas to calculate returns on investments
Familiarize yourself on five important formulas that are used to calculate returns. 1) Holding Period Return (HPR) 2) Post Tax Returns 3) Inflation Adjusted Returns 4) Compounded Annual Growth Rate (CAGR) 5) Effective Annual Rate Let us understand each of these formulas in detail. 1) Holding Period Return (HPR) Holding period return is the total […]
Employees’ Pension Scheme – Amendments and new benefits
The Central government has notified the much-awaited minimum monthly pension of Rs 1,000 per month to the Employees’ Pension Scheme holders. This scheme is managed by EPFO (Employees’ Provident Fund Organization). Employees Provident Fund & Employees’ Pension Scheme: Every month 12% of your “salary” is contributed towards EPF account. Your employer also contributes 12% of […]