In this post you can find the Excel calculator used in the video of LIC Jeevan Utsav Plan. This calculator compares the premium of Jeevan Utsav Plan and its returns with that of a RD-FD Combo. Below is the complete details about this calculator.
Video on the Returns of Jeevan Utsav Plan
How the Calculator works?
Before you start, please read the text under “READ FIRST” tab. Note that in this calculator you will only have to enter the values in the cells marked in Blue.
Tax Slab – Under the Tax Slab you will be under if you add the FD Income (calculated in this sheet) to your other income. The calculation automatically takes care of the 4% Cess charged on the Total Income.
Enter Sum Assured – This is the Sum Assured which you are planning to taken under the LIC Jeevan Utsav Plan.
Enter Premium – This is the premium shared by LIC for the plan you are opting for.
Enter PPT – This is the Premium Payment Term for your Jeevan Utsav Policy. The values can only be between 5 and 16.
Enter the RD Rate – Enter the presumed Recurring Deposit Rate for your Investment amount (Premium in this case).
Maturity after PPT – The system will automatically calculate the Maturity amount based on Premium, PPT and the RD Rate.
Maturity Amount After Tax – This is the amount you will get after tax have been deducted (based on the Tax Slab you entered).
Enter the FD Rate – Enter the presumed Fixed Deposit Rate for your Investment amount (This will be the Maturity Amount after Tax calculated above).
Income Benefit Starts – The system will automatically calculate the value for this field based on PPT of your LIC Jeevan Utsav Policy.
Maturity Amount before Income Starts – This amount is calculated based on the FD Rate, duration of deposit (Income Benefit Start minus Premium Payment Term), and the RD Maturity Amount (after Tax)
Maturity Amount After Tax – Similar to before, this is the amount you will get after tax have been deducted on the earned interest(based on the Tax Slab you entered).
Enter Yearly Payout FD Rate – This is Fixed Deposit Rate you can presume which will exist at the time of year when your Income benefit is supposed to start.
Annual Income – This is the annual interest you will be on your new Fixed Deposit. The interest is being calculated on Quarterly compounding basis.
Annual Income (after Tax) – This is the Income that you will be receiving taking into account taxes on the interest earned.
Comparison
The right side of the calculator will show you a comparison between the annual Income generated by the LIC Jeevan Utsav Plan with the RD-FD Combo Plan. You can change various parameters and accordingly take an informed decision.
If you have any questions or feedback, leave a comment below.
Jeevan Utsav Calculator
Do also read about this NEW Post Office Scheme which offers guaranteed 7.71% Returns.
Tax on Jeevan Utsav Plan
The below dedicated video explains various cases under which you will have to pay tax on the Annual amount received under this LIC Plan 871
- Axis Bank Neo Credit Card: Too Good to Be True?
Axis Bank Neo Credit Card is a unique Life Time Free Credit card which gives up to 40% Discount on various offers. Let’s look at its various features and learn how you can apply for the same. Joining Fee – NIL Annual Fee – NIL Network – Rupay Card Type – Everyday Return – 0.33% to 5.0% APPLY … Read more - IDFC First Bank HPCL Power vs Power Plus – Credit Card ComparisonIDFC HPCL Power Joining Fee – ₹199 + GST Annual Fee – ₹199 + GST Network – Rupay Card Type – Fuel Return – 0.33% to 5.0% APPLY NOW IDFC HPCL Power+ Joining Fee – ₹499 + GST Annual Fee – ₹499 + GST Network – Rupay Card Type – Fuel Return – 0.5% to … Read more
- LIC Jeevan Dhara 2 – Returns Calculation
LIC Jeevan Dhara 2 is a non-linked, non-participating, individual, deferred annuity plan. What are the returns being generated under the LIC Dhara 2 plan – Let’s find out. A deferred annuity or pension plan is typically divided in 2 phases: Let’s understand this better with the help of a couple of examples. LIC Jeevan Dhara … Read more - LIC Jeevan Dhara 2 (New Pension Plan) – Should You Invest?LIC Jeevan Dhara 2 (Plan Number 872) is a new pension plan launched by LIC. What are its features and should you invest in the same? – Let’s find out. LIC Jeevan Dhara 2 is a non-linked, non-participating, individual, savings, deferred annuity plan. Currently the plan is being offered under Unique Identification Number (UIN) 512N364V01. … Read more
- LIC Jeevan Utsav Plan Calculator
In this post you can find the Excel calculator used in the video of LIC Jeevan Utsav Plan. This calculator compares the premium of Jeevan Utsav Plan and its returns with that of a RD-FD Combo. Below is the complete details about this calculator. Video on the Returns of Jeevan Utsav Plan How the Calculator … Read more