{"id":232485,"date":"2023-01-19T12:31:00","date_gmt":"2023-01-19T09:31:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232485"},"modified":"2023-02-04T17:59:37","modified_gmt":"2023-02-04T14:59:37","slug":"a-calculadora-de-hipoteca-simples-implementada-em-c-c-javascript-e-mysql","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/pt-pt\/a-calculadora-de-hipoteca-simples-implementada-em-c-c-javascript-e-mysql\/","title":{"rendered":"A calculadora de hipoteca simples implementada em C\/C++, Javascript e MySQL"},"content":{"rendered":"<p>Embora existam muitas calculadoras de <a href=\"https:\/\/helloacm.com\/how-to-calculate-mortgage-monthly-payment-using-excel-with-formula\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">hipoteca<\/a> dispon\u00edveis, o princ\u00edpio de uma calculadora de hipoteca simples \u00e9 realmente simples, baseado na seguinte f\u00f3rmula matem\u00e1tica.<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" alt=\"A calculadora de hipoteca simples implementada em C\/C++, Javascript e MySQL\"><\/a><\/p>\n<p>onde, c \u00e9 o pagamento mensal, r s\u00e3o os juros mensais (que \u00e9 o d\u00e9cimo-d\u00e9cimo dos juros anuais). P \u00e9 o total de dinheiro emprestado. N \u00e9 o n\u00famero total de reembolsos (por exemplo, o n\u00famero de meses).<\/p>\n<h3>Calculadora de hipoteca simples implementada no MySQL<\/h3>\n<p>Por exemplo, peguei emprestado 170 mil do banco HSBC, a taxa de juros (anual) \u00e9 de 2,49% e preciso pagar o princ\u00edpio + juros em 25 anos. O valor do reembolso a cada m\u00eas (suponha que seja de taxa fixa) pode ser calculado atrav\u00e9s do seguinte comando no <a href=\"https:\/\/helloacm.com\/php-script-to-execute-mysql-statements-in-a-text-file\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">console MySQL<\/a> :<\/p>\n<pre><code>mysql&gt; select 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1);\n+------------------------------------------------------------------------+\n| 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1) |\n+------------------------------------------------------------------------+\n| \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 761.792586559163 |\n+------------------------------------------------------------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<h3>Calculadora de hipoteca simples implementada em C\/C++<\/h3>\n<p>Com a fun\u00e7\u00e3o pow de math.h, a fun\u00e7\u00e3o de pagamento \u00e9 definida da seguinte forma:<\/p>\n<pre><code>#include &lt;math.h&gt;\n\u00a0\n\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\ndouble payment(r, p, n) {\n\u00a0 \u00a0 var x = pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<h3>Calculadora de hipoteca simples online implementada em Javascript<\/h3>\n<p>Da mesma forma, a fun\u00e7\u00e3o definida em <a href=\"https:\/\/wordpress.mediadoma.com\/pt-pt\/como-preencher-automaticamente-o-formulario-de-comentarios-usando-javascript\/\" title=\"Javascript\">Javascript<\/a> \u00e9 definida como:<\/p>\n<pre><code>\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\nfunction payment(r, p, n) {\n\u00a0 \u00a0 var x = Math.pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<p>Preencha os valores de r, P e N e a seguinte <a href=\"https:\/\/helloacm.com\/the-simple-mortgage-calculator-implemented-in-cc-javascript-and-mysql\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">calculadora de hipoteca online (abrir em nova janela)<\/a> calcular\u00e1 o pagamento mensal e os juros (n\u00e3o dispon\u00edvel se voc\u00ea estiver visualizando na vers\u00e3o <a href=\"https:\/\/wordpress.mediadoma.com\/pt-pt\/como-habilitar-amp-com-wordpress-tecnicas-de-otimizacao-de-amp-com-wordpress\/\" title=\"Accelerated Mobile Page\">Accelerated Mobile Page<\/a> ):<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" alt=\"A calculadora de hipoteca simples implementada em C\/C++, Javascript e MySQL\"><\/a><\/p>\n<p>calculadora de hipoteca com f\u00f3rmula<\/p>\n<p>A vers\u00e3o alternativa <a href=\"https:\/\/justyy.com\/archives\/3454\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">desta calculadora de hipotecas pode ser encontrada aqui<\/a>.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">Fonte de grava\u00e7\u00e3o:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A calculadora de hipoteca simples implementada em C\/C++, Javascript e MySQL<\/p>\n","protected":false},"author":1,"featured_media":224427,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[898,722,920],"tags":[1170],"class_list":["post-232485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-codigo-2","category-desenvolvedor","category-outro","tag-affiai-pt-pt"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/posts\/232485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=232485"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/posts\/232485\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/media\/224427"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=232485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=232485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=232485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}