36:["$","title",null,{"children":"Accumulative pension calculator | David B. | Observable"}] 3e:T709, { const sum = d3.sum(eachYearsPensionDetails,d=>d.total); const heightFunc = d3.scaleLinear().domain([0,5000000]).range([300,400]) if(!sum){ return } var data= [ {value:Math.round(d3.sum(eachYearsPensionDetails,d=>d.employer)), name:"Employeer ", fill:'#94688B', textFill:"#E5E2E0" }, {value:Math.round(d3.sum(eachYearsPensionDetails,d=>d.employee)), name:"You ", fill:'#007D83', textFill:"#E5E2E0", }, {value:Math.round(d3.sum(eachYearsPensionDetails,d=>d.gov)), name:"State ", fill:'#F18100', textFill:"#E5E2E0" }, {value:Math.round(totalPension-sum), name:" Percent ", fill:'#C2BBA7', textFill:"#E5E2E0" } ] var chartWidth = width<500?width:500; var height= heightFunc(totalPension); var pie=d3.pie().value(d=>d.value).sort(null); var arc = d3.arc().innerRadius(0).outerRadius(height/2); var arCc = d3.arc().innerRadius(0).outerRadius(height/2); var piedData = pie(data); yield svg` ` }3f:T5fd,calculationTable = ` ${eachYearsFVReal.map((d,i)=>{ const nom = Math.round(eachYearsFVNominal[i]) return `` } ).join('')}

Per year	salary	year nominal salary	Accumulated amount	Without inflation	Net pension	Without inflation	State donated
in ${i+1} year	${numberFormat(eachYearSalary[i])} GEL.	${numberFormat(eachYearsSalarySum[i])} GEL.	${numberFormat(nom)} GEL.	${numberFormat(Math.round(d))} GEL.	${numberFormat(Math.round(nom/timeAfterPension/12))} GEL.	${numberFormat(Math.round(d/timeAfterPension/12))} GEL.	${eachYearsGovPerc[i]} %

`40:[] 3a:{"id":"fa3abdb90981dd05","slug":"pension-calculator/2","title":"Accumulative pension calculator","thumbnail":"5ca0c7b422744516f33c671866b69e5c0075d3837c6cffd37437c2747f02cdc8","access_level":"public","create_time":"$D2018-11-21T18:36:25.661Z","update_time":"$D2020-04-12T08:42:35.826Z","view_time":null,"first_public_time":"$D2018-11-22T00:22:32.858Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"fcd7e4188e1df970","login":"bumbeishvili","name":"David B.","avatar_url":"https://avatars-next.observableusercontent.com/038bfbb4eaa1c1217d83efed9948fd774126f3fa01dcce32e347fd0fd7c960d7","tier":"starter_2024","bio":"Data viz engineer | twitter.com/dbumbeishvili","following":false},"version":697,"publish_version":697,"role":null,"authored":false,"authors":[{"type":"individual","id":"5e0ddde49c696e13","login":"bumbeishvili","name":"David B.","avatar_url":"https://avatars-next.observableusercontent.com/038bfbb4eaa1c1217d83efed9948fd774126f3fa01dcce32e347fd0fd7c960d7","tier":null,"bio":"Data viz engineer | twitter.com/dbumbeishvili","following":false}],"members":[{"type":"individual","id":"5e0ddde49c696e13","login":"bumbeishvili","name":"David B.","avatar_url":"https://avatars-next.observableusercontent.com/038bfbb4eaa1c1217d83efed9948fd774126f3fa01dcce32e347fd0fd7c960d7","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Accumulative pension calculator","cells":[{"id":0,"value":"md`# Accumulative pension calculator`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"html`\n

Our monthly salary - ${salary} GEL

Average yearly salary increase - ${salaryIncrease} GEL

Our Age - ${age} Years Old.

Pension retirement age - ( Saving ${timeBeforePension} years)\n

\n \n \n \n\n\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"html`${calculationTable}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":416,"value":"md`\n\n

\n\nMethodoloy is adjusted based on [ISET-PI's data](http://iset-pi.ge/index.php/ka/692-indexes-ge/pension-calculator) \n\n\n\nAdditional Details are adjusted from the [law of accumulated pension](https://www.matsne.gov.ge/ka/document/view/4280127?publication=0&fbclid=IwAR3ee9CNZ0tE3WvAQSCz9q0K7kZxnWy8GfUaqKTjctkDSpsDgNzUby0X07w)\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"timeAfterPension = {\n if(sex=='60 Years - Female'){\n return 21\n }else{\n return 13\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"timeBeforePension = {\n if(sex=='60 Years - Female'){\n return 60-age<0?0: 60-age\n }else{\n return 65-age \n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"commission = 0.5","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"yearlyPercent = 8","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"inflationTarget=3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"realPercent = yearlyPercent-inflationTarget ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"md`# calculations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"eachYearSalary =[...Array(timeBeforePension).keys()]\n.map(d=>{\n return salary+d*salaryIncrease\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"eachYearsNominalSalary = eachYearSalary\n.map(d=>d*1.25)\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"eachYearsSalarySum = eachYearsNominalSalary.map(d=>d*12)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"eachYearsGovPerc = eachYearsSalarySum.map(d=>{\n if(d<24000) return 2; \n if(d<60000) return 1; \n return 0;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"totalPension = eachYearsFVNominal[eachYearsFVNominal.length-1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"eachYearsPension = eachYearsNominalSalary\n.map((d,i)=>{\n // if(d*12>60000) return 0;\n return d*(0.04+eachYearsGovPerc[i]/100)\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":521,"value":"eachYearsPensionDetails = {\n return eachYearsPension.map(d=>{\n return {\n yearPension:Math.round(d*12),\n }\n })\n .map((d,i)=>{\n return {\n gov:d.yearPension * (eachYearsGovPerc[i]/( eachYearsGovPerc[i]+4)),\n employee:d.yearPension * 2/( eachYearsGovPerc[i]+4),\n employer:d.yearPension * 2/( eachYearsGovPerc[i]+4),\n total:d.yearPension\n }\n })\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"eachYearsFVNominal = {\n const result = [];\n let accumulation=0;\n \n eachYearsPension.map((d,i,arr)=>{\n const rate = yearlyPercent/100/12; // 5 percent yearly\n const nper = 12; // monthly\n const pmt = -d; // monthly deposit\n const pv = - (result[i-1]||0) * (100-commission)/100; // starting capital\n const type=1; // period of interest realisation\n accumulation= FV(rate,nper,pmt,pv,type);\n result.push(accumulation)\n })\n return result\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"eachYearsFVReal = {\n const result = [];\n let accumulation=0;\n \n eachYearsPension.map((d,i,arr)=>{\n const rate = (realPercent/100)/12; // 2 percent yearly\n const nper = 12; // monthly\n const pmt = -d; // monthly deposit\n const pv = - (result[i-1]||0); // starting capital\n const type=1; // period of interest realisation\n accumulation = FV(rate,nper,pmt,pv,type);\n result.push(accumulation)\n })\n return result\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"$3f","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"function FV(rate, nper, pmt, pv, type) {\n var pow = Math.pow(1 + rate, nper),\n fv;\n if (rate) {\n fv = (pmt*(1+rate*type)*(1-pow)/rate)-pv*pow;\n } else {\n fv = -1 * (pv + pmt * nper);\n }\n return fv;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"md`https://support.office.com/en-us/article/fv-function-4331eab5-c7e3-4dcb-a46e-1ef7bce51e6e`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"numberFormat = d3.format(',')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"import {select} from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"barRangeSlider","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"import {barRangeSlider} from \"@bumbeishvili/utils\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1"}} 35:null