Manual Calculation
Select product and enter only required details. Fields change automatically.
Calculation Result
Enter details and click Calculate Premium.
Bulk Calculation
Upload Excel/CSV with required headers. Result will appear below and can be downloaded.
Required headers: Product, Sub-Product, Case No, Insured Amount, EMI, Age, Carpet Area, Construction Rate, Tenure, IRR
Admin Rates / Formula Settings
These settings are saved in this browser. Use them for products where premium chart is not fully fixed in the app.
Fire GPA, Lombard Loan Suraksha GPA, Niva Bupa, Lombard EMI, Care Health and HDFC rates are loaded from your provided calculator files. HDFC Vehicle-10 and MSME-11 use exact Excel lookup: PLNNO + MAXLNTERM + DINTRATE + AGELIMIT to pick ZPMRATE.
Bulk Upload Format
Product,Sub-Product,Case No,Insured Amount,EMI,Age,Carpet Area,Construction Rate,Tenure,IRR Fire Insurance,GPA+BGR+RESI,729465,10130036,0,65,3000,800,10 Fire Insurance,GPA+BGR+COMM,732218,618326,0,65,1102,800,7 Fire Insurance,BGR+RESI,734065,1028427,0,65,1100,900,1 Fire Insurance,BGR+COMM,735566,409931,0,65,1188,900,5 Nivabupa Insurance,Nivabupa Insurance,737441,781857,10000,65,0,0,3 Lombard EMI Protection,Lombard EMI Protection,739337,500644,12000,65,0,0,2 Kotak Life Insurance,Kotak Life Insurance,740014,612711,0,60,0,0,5 Care Health Insurance,Care Health Insurance,740316,507370,0,65,0,0,4 ICICI Prudential Premium,ICICI Prudential Premium,742282,1950000,0,60,0,0,2 HDFC Life Insurance Vehicle-10,HDFC Life Insurance Vehicle-10,738227,1200000,0,60,0,0,10 HDFC Life Insurance MSME-11,HDFC Life Insurance MSME-11,739431,1000000,0,60,0,0,5,16