{"id":1701,"date":"2023-11-10T18:31:38","date_gmt":"2023-11-10T18:31:38","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/"},"modified":"2023-12-06T06:17:39","modified_gmt":"2023-12-06T06:17:39","slug":"bunga-majemuk","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/","title":{"rendered":"Bagaimana cara menghitung bunga majemuk di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3462410091\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Bunga majemuk adalah salah satu perhitungan keuangan terpenting yang sering kita gunakan, dan mempelajari cara menghitungnya di Excel adalah suatu keharusan.<\/p><p> Namun sebelum Anda melakukannya, Anda perlu memahami apa sebenarnya bunga majemuk itu.<\/p><blockquote class=\"wp-block-quote\"><p> Bunga majemuk adalah bunga yang dihitung atas modal awal dan juga bunga yang meningkat dari periode simpanan atau pinjaman sebelumnya.<\/p><p> <cite><em><a href=\"http:\/\/www.investopedia.com\/terms\/c\/compoundinterest.asp\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Investopedia<\/a><\/em><\/cite><\/p><\/blockquote><p> Di Excel, metode penghitungan bunga majemuk sederhana.<\/p><p> Sekarang masalahnya adalah. Cukup gunakan metode perhitungan dan tentukan periode waktu yang ingin Anda hitung. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif\" sizes=\"\" srcset=\"\" alt=\"model sederhana untuk menghitung bunga majemuk di excel\"><\/figure><\/div><p> Jadi hari ini di artikel ini saya ingin menunjukkan kepada Anda cara menghitung bunga majemuk di Excel menggunakan periode waktu yang berbeda. Jadi, mari kita mulai.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Rumus Bunga Majemuk Tahunan<\/h2><p> Untuk menghitung bunga majemuk tahunan, cukup tambahkan bunga satu tahun ke jumlah pokok tahun berikutnya untuk menghitung bunga tahun berikutnya.<\/p><p> Dan rumus di Excel untuk bunga majemuk tahunan adalah.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=Principal Amount*((1+Annual Interest Rate\/1)^(Total Years of Investment*1)))<\/code><\/pre><p> Mari saya tunjukkan sebuah contoh. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-linteret-compose-dans-excel-chaque-annee.png\" sizes=\"\" srcset=\"\" alt=\"menghitung bunga majemuk di excel setiap tahun\"><\/figure><\/div><p> Dalam contoh di atas, dengan pokok $10.000 dan bunga 10% selama 5 tahun, Anda akan mendapatkan $16.105.<\/p><p> Pada tahun pertama, Anda akan mendapatkan $10.000 * 10%, yaitu $1.000, dan pada tahun kedua, ($10.000 + $1.000) * 10% = $1.100, dan seterusnya.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Rumus Bunga Majemuk Triwulanan<\/h2><p> Menghitung bunga majemuk triwulanan mirip dengan menghitung bunga majemuk tahunan.<\/p><p> Tapi, di sini Anda harus menghitung bunganya empat kali dalam setahun. Jumlah bunga setiap triwulan akan ditambahkan ke jumlah pokok triwulan berikutnya. Untuk menghitung bunga majemuk triwulanan, Anda dapat menggunakan rumus di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=Principal Amount*((1+Annual Interest Rate\/4)^(Total Years of Investment*4)))<\/code><\/pre><p> Ini sebuah contoh. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-les-interets-composes-dans-excel-trimestriel.png\" sizes=\"\" srcset=\"\" alt=\"menghitung bunga majemuk di excel setiap triwulan\"><\/figure><\/div><p> Dalam contoh di atas, dengan pokok $10.000 dan bunga 10% selama 5 tahun, kita akan mendapatkan $16.386.<\/p><p> Pada kuartal pertama, kita memperoleh 10.000*(10%\/4) atau 250$, dan pada kuartal kedua, (10.000$+250$)*(10%\/4) = 256$, dan metode perhitungan yang sama untuk 20 Kuartal (5 tahun).<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Rumus Bunga Majemuk Bulanan<\/h2><p> Saat menghitung bunga majemuk bulanan, Anda harus menggunakan dasar yang Anda gunakan pada periode lain.<\/p><p> Anda harus menghitung bunga setiap akhir bulan. Dan pada metode ini, tingkat bunga akan dibagi 12 untuk tingkat bunga bulanan. Untuk menghitung bunga majemuk bulanan di Excel, Anda bisa menggunakan rumus di bawah ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=Principal Amount*((1+Annual Interest Rate\/12)^(Total Years of Investment*12)))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-mensuellement-les-interets-composes-dans-excel.png\" sizes=\"\" srcset=\"\" alt=\"menghitung bunga majemuk di excel setiap bulan\"><\/figure><\/div><p> Dalam contoh di atas, dengan pokok $10.000 dan bunga 10% selama 5 tahun, kita akan mendapatkan $16.453.<\/p><p> Pada bulan pertama, kita mendapatkan 10,000 * (10%\/12), yaitu $83,33 &amp; bulan kedua, ($10,000 + $83,33) * (10%\/12) = $84,02 dan jumlah yang sama berlaku untuk 60 bulan (5 tahun).<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Rumus Bunga Majemuk Harian<\/h2><p> Saat menghitung bunga majemuk harian, kita perlu menggunakan cara yang sama dengan rumus perhitungan di bawah ini. Kita perlu membagi tingkat bunga dengan 365 untuk mendapatkan tingkat bunga harian.<\/p><p> Jadi, Anda bisa menggunakan rumus di bawah ini untuk menghitung bunga majemuk harian. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=Principal Amount*((1+Annual Interest Rate\/365)^(Total Years of Investment*365)))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/calculer-linteret-compose-sur-excel-day.png\" sizes=\"\" srcset=\"\" alt=\"menghitung bunga majemuk pada hari excel\"><\/figure><\/div><p> Dalam contoh di atas, dengan pokok $10.000 dan bunga 10% selama 5 tahun, kita akan mendapatkan $16.486.<\/p><p> Pada hari pertama, kita mendapatkan 10.000*(10%\/365) = 4$, dan pada hari kedua, (10.000$+4$)*(10%\/365) = 4$, dan hal yang sama berlaku untuk semua hari selama 5 tahun.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Contoh berkas<\/h2><p> Dengan menggunakan metode di atas, saya membuat [Templat] Kalkulator Bunga Akumulasi untuk menghitung semua perhitungan bunga di atas dalam satu spreadsheet. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Dapatkan file Excelnya <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/excel-interet-compose.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/bunga-sederhana\/\">Hitung Bunga Sederhana di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/margin-keuntungan\/\">Laba kotor (margin dan rasio)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tong\/\">Hitung PPN<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1701","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\",\"name\":\"\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif\",\"datePublished\":\"2023-11-10T18:31:38+00:00\",\"dateModified\":\"2023-12-06T06:17:39+00:00\",\"description\":\"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghitung bunga majemuk di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel","description":"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel","og_description":"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim","og_url":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/","url":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/","name":"\u25b7 Bagaimana cara menghitung bunga majemuk? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif","datePublished":"2023-11-10T18:31:38+00:00","dateModified":"2023-12-06T06:17:39+00:00","description":"Pada artikel ini, Anda akan mempelajari cara menghitung bunga majemuk di Excel. Anda dapat menggunakan harian, bulanan, trim","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/bunga-majemuk\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-modele-simple-pour-calculer-les-interets-composes-dans-excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/bunga-majemuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghitung bunga majemuk di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1701"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1701\/revisions"}],"predecessor-version":[{"id":2625,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1701\/revisions\/2625"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}