(function tab_emp( ){ if(fieldname3=="Annuité constante") { var me=fieldname2; var taux=fieldname6; var ans=fieldname7; var Ac=(me*(taux/(1-POW((1+taux),-ans)))).toFixed(2) ; var I=(me*taux).toFixed(2) ; var amort=(Ac -I).toFixed(2) ; var rest; var net=(me-amort).toFixed(2) ; var j; var impr= "<"+"br >

Tableau d'emprunt d'un prêt de "+ fieldname2+ " sur "+ fieldname7+ " ans, au taux de "+ fieldname6+ "<"+"/p><"+"/br >"; impr+=("<"+"table border='0' cellpadding='2px' style='background-color: #bbd0df;'>"); impr+=("<"+"th>An(s)"); impr+=(" <"+"th> Restant dû"); impr+=("<"+"th>Intérêts"); impr+=("<"+"th>Amortissement<"+"th>Annuité"); impr+=("<"+"th>Valeur nette"+""); impr+=("<"+"tr>"); impr+=(" <"+"td>1"); impr+=(" <"+"td>"+me+""); impr+=(" <"+"td>"+I+""); impr+=(" <"+"td>"+amort+""); impr+=(" <"+"td>"+Ac+""); impr+=(" <"+"td>"+net+""); for ( j=2; j<= ans; j++) { Ac=(me*(taux/(1-POW((1+taux),-ans)))).toFixed(2) ; I=(net*taux).toFixed(2) ; amort=(Ac -I).toFixed(2) ; rest=net; net=(net-amort).toFixed(2) ; impr+=(" <"+"td>"+j+""); impr+=(" <"+"td>"+rest+""); impr+=(" <"+"td>"+I+""); impr+=(" <"+"td>"+amort+""); impr+=(" <"+"td>"+Ac+""); if(j==ans) {net=0;} impr+=(" <"+"td>"+net+""); } impr+=(""); return $(".result").html($(impr)); } else { var me=fieldname2; var taux=fieldname6; var ans=fieldname7; var rest=me; var I=(rest*taux).toFixed(2) ; var amort=(me/ans).toFixed(2) ; var A=SUM(amort,I).toFixed(2); var net=(me-amort).toFixed(2) ; var j; var impr= "<"+"br >

Tableau d'emprunt d'un prêt de "+ fieldname2+ " sur "+ fieldname7+ " ans, au taux de "+ fieldname6+"<"+"/p><"+"/br >"; impr+=("<"+"table border='0' cellpadding='2px' style='background-color: #bbd0df;'>"); impr+=("<"+"th>An(s)"); impr+=(" <"+"th> Restant dû"); impr+=("<"+"th>Intérêts"); impr+=("<"+"th>Amortissement<"+"th>Annuité"); impr+=("<"+"th>Valeur nette"+""); impr+=("<"+"tr>"); impr+=(" <"+"td>1"); impr+=(" <"+"td>"+me+""); impr+=(" <"+"td>"+I+""); impr+=(" <"+"td>"+amort+""); impr+=(" <"+"td>"+A+""); impr+=(" <"+"td>"+net+""); for ( j=2; j<= ans; j++) { I=(net*taux).toFixed(2) ; rest=net; net=(net-amort).toFixed(2) ; impr+=(" <"+"td>"+j+""); impr+=(" <"+"td>"+rest+""); impr+=(" <"+"td>"+I+""); impr+=(" <"+"td>"+amort+""); A=SUM(amort,I).toFixed(2); impr+=(" <"+"td>"+A+""); if(j==ans) {net=0;} impr+=(" <"+"td>"+net+""); } impr+=(""); return $(".result").html($(impr)); } })();

Calculer un emprunt