(function(){ var tableauAmortissement = CALCULATEAMORTIZATION(fieldname27,(fieldname2*12),fieldname37, new Date(2020,1,1)), str = ''; strEmail = ''; if(tableauAmortissement.length) { str = '

'; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; var previousYearInterest = 0; var yearInterest = 0; var pinelValue = 0; var previouspinelValue = 0; var baseImposable = 0; var ir = 0; var ps = 0; var fluxAnnuel = 0; var reductionIr = fieldname50; var globalFluxAnnuel = 0; var arrayGlobalFluxYearAmount = []; var arrayGlobalFluxYearDate = []; for(var i = 0, h = tableauAmortissement.length; i < h; i++) { if((i+1)%12==0) { yearInterest = tableauAmortissement[i]['interest'] - previousYearInterest; if((i+1)==12) { pinelValue = fieldname5*(1+fieldname33); baseImposable = fieldname46-yearInterest-fieldname44-fieldname39-fieldname40-fieldname51; } else { pinelValue = previouspinelValue*(1+fieldname33); baseImposable = fieldname46-yearInterest-fieldname44-fieldname51; } if(baseImposable<0) { baseImposable=0; } if((i+1)>(9*12)) { reductionIr=0; } previouspinelValue = pinelValue; previousYearInterest = tableauAmortissement[i]['interest']; ir = baseImposable*fieldname23; ps = baseImposable*fieldname21; fluxAnnuel = fieldname46-fieldname45-fieldname51-ir-ps+reductionIr; globalFluxAnnuel = globalFluxAnnuel + fluxAnnuel; arrayGlobalFluxYearAmount.push(fluxAnnuel); arrayGlobalFluxYearDate.push(GETDATETIMESTRING( new Date(tableauAmortissement[i]['date']), 'yyyy-mm-dd')); strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; strEmail += ''; } } strEmail += '

Année	Valeur du bien immobilier	Loyers perçus	Annuités	Intérêts annuel	Assurance	Charges	Base imposable	Impôts sur le Revenu	Prélèvements sociaux	Réduction d\'impôt	Trésorerie annuelle
'+((i+1)/12)+'	'+PREC(pinelValue,2)+'	'+PREC(fieldname46,2)+'	'+PREC(fieldname45,2)+'	'+PREC(yearInterest,2)+'	'+PREC(fieldname44,2)+'	'+PREC(fieldname51,2)+'	'+PREC(baseImposable,2)+'	'+PREC(ir,2)+'	'+PREC(ps,2)+'	'+PREC(reductionIr,2)+'	'+PREC(fluxAnnuel,2)+'

'; str += '

Bilan de l\'opération

'; var epargne = PREC((globalFluxAnnuel/(fieldname2*12)*-1),2); str += '

Epargne mensuelle moyenne : '+epargne+'

'; str += '

Cumul de l\'épargne versée : '+PREC(globalFluxAnnuel,2)+'

'; str += '

Au terme de l\'opération

'; var Loyer = (fieldname46*12); str += '

Revenus : '+PREC(Loyer,2)+' €

'; str += '

Valeur du bien immbilier : '+PREC(pinelValue,2)+' €

'; str += '

Gain net de l\'opération : '+PREC((pinelValue+globalFluxAnnuel),2)+' €

'; arrayGlobalFluxYearAmount[0] = arrayGlobalFluxYearAmount[0] - fieldname35; arrayGlobalFluxYearAmount[arrayGlobalFluxYearAmount.length-1] += pinelValue; var tri = XIRR(arrayGlobalFluxYearAmount,arrayGlobalFluxYearDate,10); tri = tri * 100; str += '

TRI : '+ PREC(tri,2) +'%'; str += '

'; } localStorage.setItem('pinelEmail', strEmail); jQuery('.pinelresult-here').html( str ); })()

Simulateur Loi Pinel - Loi Denormandie