{"id":232482,"date":"2023-01-19T12:52:00","date_gmt":"2023-01-19T09:52:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232482"},"modified":"2023-02-04T17:54:33","modified_gmt":"2023-02-04T14:54:33","slug":"simple-mortgage-calculator-toteutettu-c-c-javascript-ja-mysql","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fi\/simple-mortgage-calculator-toteutettu-c-c-javascript-ja-mysql\/","title":{"rendered":"Simple Mortgage Calculator toteutettu C\/C++, Javascript ja MySQL"},"content":{"rendered":"

Vaikka saatavilla on monia asuntolainalaskimia<\/a>, yksinkertaisen asuntolainalaskimen periaate on todella yksinkertainen, joka perustuu seuraavaan matemaattiseen kaavaan.<\/p>\n

\"Simple<\/a><\/p>\n

jossa c on kuukausittainen takaisinmaksu, r on kuukausikorot (joka on yksi kahdestoistaosa vuosikoroista). P on lainatun rahan kokonaism\u00e4\u00e4r\u00e4. N on takaisinmaksujen kokonaism\u00e4\u00e4r\u00e4 (esim. kuukausien lukum\u00e4\u00e4r\u00e4).<\/p>\n

Yksinkertainen asuntolainalaskin toteutettu MySQL:ss\u00e4<\/h3>\n

Esimerkiksi lainasin HSBC Bankista 170K, korko (vuosittain) on 2,49%, ja minun on maksettava periaate+korot takaisin 25 vuodessa. Kuukausittainen takaisinmaksun m\u00e4\u00e4r\u00e4 (oletetaan, ett\u00e4 se on kiinte\u00e4korkoinen) voidaan laskea seuraavalla komennolla MySQL-konsolissa<\/a> :<\/p>\n

mysql> 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
Yksinkertainen asuntolainalaskin toteutettu C\/C++:ssa<\/h3>\n
Math.h:n pow-funktiolla maksufunktio m\u00e4\u00e4ritell\u00e4\u00e4n seuraavasti:<\/p>\n
#include <math.h>\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
Online yksinkertainen asuntolainaskin toteutettu Javascriptiss\u00e4<\/h3>\n
Vastaavasti Javascriptiss\u00e4<\/a> m\u00e4\u00e4ritetty funktio m\u00e4\u00e4ritell\u00e4\u00e4n seuraavasti:<\/p>\n
\/\/ 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
T\u00e4yt\u00e4 r-, P- ja N-arvot ja seuraava online-asuntolainalaskin (avautuu uuteen ikkunaan)<\/a> laskee kuukausittaisen lyhennyksen ja korot (ei k\u00e4ytett\u00e4viss\u00e4, jos katselet Accelerated Mobile Page<\/a> -versiota):<\/p>\n
\"Simple<\/a><\/p>\n
asuntolaina laskin kaavalla<\/p>\n
T\u00e4m\u00e4n asuntolainalaskurin vaihtoehtoinen versio l\u00f6ytyy t\u00e4\u00e4lt\u00e4<\/a>.<\/p>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Simple Mortgage Calculator toteutettu C\/C++, Javascript ja 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":[719,895,917],"tags":[1166],"class_list":["post-232482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kehittaejae","category-koodi","category-muut","tag-affiai-fi"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/232482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/comments?post=232482"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/232482\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media\/224427"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media?parent=232482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/categories?post=232482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/tags?post=232482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}