I paid Rs 18,572 every year on a moneyback insurance policy bought 20 years back. Every fifth year, I received Rs 40,000 back and Rs 4.5 lakh on maturity. What was my rate of return?
The internal rate of return (IRR) has to be calculated here. It is the interest rate accrued on an investment that has outflows and inflows at the same regular periods.
In the excel page type Rs 18,572 as a negative figure (-18572), as it is an outflow, in the first cell. Paste the same figure till the twentieth cell.
Then, as every fifth year has an inflow of Rs 40,000, type in Rs 21,428 (40,000-18,572) in every fifth cell. In the twentieth cell, type in –18572. In the twenty first cell, type in Rs 4,50,000, which is the maturity value of the policy.
Then click on the cell below it and type: = IRR(A1:A21) and hit enter.
5.28% will show in the cell. This is your internal rate of return.
Also used for: Calculating returns on insurance endowment policies.
Image: Uday Kotak, Chairman of Kotak Mahindra Old Mutual Life Insurance Limited, at a press conference in Mumbai. | Photograph: Rob Elliott/AFP/Getty Images
Also read:
Phaneesh Murthy on IT industry, economy & outsourcing
Advertisement
