Lic Data Sheet: Fill & Download for Free

Going Anonymous for obvious reasons. I use excel sheet for tracking my expenses.My gross salary is 185K with taxes of about 35K.My EPF + VPF is about 26K per month.LIC is of 8.4K per month.Four Mutual funds of 5K each. [20K]Daughter’s FD: 5K per month (I have to start for my son now)Phone+TV: Rs 1KMaids: About 6–8 K (Cleaner, Cook, baby massage)Grocery: Rs 15-20KPetrol: 4KMisc shopping: 1–5K per month.Total: 108.5K spent. Rest of 40K is saved in cash.We have no EMI as my home loan of my 2.5BHK in Pune was for 10 years, which we finished off in 6 years, thanks to some stay abroad. I bought car in cash hence no auto loan.Extra monthly earnings:Quora Partner Program: 3–5KFD monthly returns: Rs 18.5KTotal: 62.5K saved in cashI have recently enrolled in a Masters Program (Masters in Data Science), which would cost 4L in 18 months, which I am paying in EMIs. I picked EMIs because the money in bank will rather pay me cash in terms of interest. This investment should double my salary after 2 years.Final savings: 36K, not considering the PF/MF/LIC/FDsThis does not include school fees of my daughter, which is about 1.25L per year.I don’t want to buy another house in next 2–3 years because the real estate in India is stalled for now and it would make more sense to build up a corpus and have a minimum loan. Also, the newer the house is, the better the facilities are.

It is a near impossibility to predict the movement of the crude prices with certainty in the long term and even the best of commodities experts will have difficulty in predicting the short term movement.This is the last 18 year chart of crude and I am sure many experts and companies would have been caught off-guard with the sudden spikes and drops at times.Even in the short term, over the last 3 years, the crude oil price movement has halved and doubled, which makes it really difficult to assess the long term options. From $65/bbl to $30/bbl to rising at $80/bbl. These are strong movements and the fortunes of IOCL, HPCL, BPCL etc vary very much based on where the price stands and also on their masters - the govt.With the govt on the hunt for money from all sources, investing in any public sector company will not make sense at all, as the govt keeps using them, either for their own purposes or for squeezing dividend out of them.In 2016–17, the govt had instructed every public sector company to pay a minimum dividend of 30% of its net profit or 5% of net worth, whichever is higher. Hence the 3 OMC’s paid Rs 8,119 cr. in dividend and after that, the govt. asked the 3 companies to double the dividend[1][1][1][1] in 2017–18 and pay close to Rs. 16,000 cr.Oil and gas PSUs[2][2][2][2] such as Indian Oil, ONGC, BPCL, HPCL and GAIL (India) have paid Rs 328 billion as interim dividend during the first 11 months of 2017-18, 22 per cent higher than their full-year dividend in 2016-17. Indian Oil topped the dividend list with a total interim dividend payout of Rs 184 billion, more than twice its full-year dividend in 2016-17.When the crude oil is high and the dividend is squeezed, it leaves no room for investor interest. Also, such commodity based companies should be invested when the raw material is at its low, which was 3 years ago.The answer for BPCL: Gopal Kavalireddi's answer to What's Gopal Kavalireddi's long term view on accumulating BPCL at CMP?Conclusion: I have written my opinion on investing in govt owned companies while addressing the query on NBCC and it remains the same. Over the last 4 years, the govt. has used all the public sector institutions to gather money, for spending on welfare schemes and others, which has resulted in depleted balance sheets for most of these companies.A simple look at the situation post recapitalization of PSB’s will tell you that all that money given to those banks is gone already and hence, the govt is making LIC and others buy these companies to keep them afloat.I reiterate my stand that, it doesn’t make any sense to buy into govt. owned companies at this time. With regards to the 3 OMC’s, unless crude comes down to less than $60/bbl, it doesn’t make any sense. Even then, we have to consider that it is an election year, and if the crude goes up, the govt. will not let the OMC’s increase the petrol & diesel prices for fear of losing the vote bank, while demanding dividend from these companies.Hence, I believe that it is a lose-lose situation for the oil marketing companies.Financial data and source credits: Mining Intelligence and Technology , Economic Times and Business Standard Articles.Footnotes[1] Govt tells IOC, HPCL, BPCL to double dividend payout[1] Govt tells IOC, HPCL, BPCL to double dividend payout[1] Govt tells IOC, HPCL, BPCL to double dividend payout[1] Govt tells IOC, HPCL, BPCL to double dividend payout[2] Govt may have to settle for lower dividend income from PSUs in FY19[2] Govt may have to settle for lower dividend income from PSUs in FY19[2] Govt may have to settle for lower dividend income from PSUs in FY19[2] Govt may have to settle for lower dividend income from PSUs in FY19

It is quite simple to do calculation of Returns for an investment product. However, LIC Endowment and Money back Insurance mixed Investment policies are not pure investment products, but with supporting data such as Bonus announcement available in their website, it can be done quite accurately.The easiest way to calculate returns for any investment is to know about the date and amounts invested and the current value of the investment.So to take the case of one of our clients who came to us for financial advice, they provided a New Jeevan Anand Policy which hadSum assured of Rs 3.0 L (Cell C1)Yearly premium of Rs 16,800.From LIC Website you get the simple reversionary bonus declared yearly for this plan as 48 per 1000 of Sum Assured.You can enter these data in an excel sheet and use the XIRR formula to calculate the returns of this particular plan (= 5.41% - shown in yellow)The figure Rs 6.02 L will be the final payout .It is calculated as Sum Assured (A) + Sum of Reversionary bonuses (B) + Final Additional bonus (FAB) (C)A - Sum Assured = Rs 3.0 LReversionary Bonus per year = 48 / 1000 * 300000 = 14,400, so for 20 years, the total will be 20 x 14,400 = 2.88 L (B)Final Additional Bonus (FAB) = Rs 70 / 1000 * 300000 = 21,000 (C)So A+B+C = 6,09,000 (Final payout)You can put these data points in an excel sheet and use excel function (shown in top bar) for Cell B24 to get the Time weighted rate of return (or) Compounded Annual Growth Rate (CAGR), the metric used to calculate rate of return universally.Calculating the returns of LIC policy is not rocket science, just simple secondary school maths, so you can ask the right questions to the person who comes to advise you on insurance products and take informed decision based on your goals, return expectations, risk preference and tax status.Remember however, most of these long term policies are quite inflexible, which means if you stop paying premiums midway, either the surrender value will be much lower than the sum of premiums paid or even zero depending on when you decide to discontinue / surrender, which may happen due to many reasons linked to the individual himself.