{"id":3179,"date":"2023-07-18T20:07:43","date_gmt":"2023-07-18T20:07:43","guid":{"rendered":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/"},"modified":"2023-07-18T20:07:43","modified_gmt":"2023-07-18T20:07:43","slug":"bunga-majemuk-excel-setiap-bulan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/","title":{"rendered":"Cara menghitung bunga majemuk bulanan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk mencari nilai akhir suatu investasi setelah waktu tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>SEBUAH = P(1 + r\/n) <sup>tidak<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>J:<\/strong> Jumlah akhir<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>P:<\/strong> Inisial utama<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>r:<\/strong> tingkat bunga tahunan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n :<\/strong> Jumlah periode komposisi per tahun<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>t:<\/strong> Jumlah tahun<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika investasi dimajemukkan <strong>setiap bulan<\/strong> , maka kita dapat menggunakan 12 untuk <em>n<\/em> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>SEBUAH = P(1 + r\/12) <sup>12t<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan rumus ini di Excel untuk menghitung nilai akhir investasi majemuk setiap bulan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Rumus Bunga Majemuk Bulanan di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita menginvestasikan $5.000 dalam investasi yang bunganya bertambah 6% per tahun. Mari kita asumsikan investasi digabungkan setiap bulan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan rumus bunga majemuk di Excel untuk menghitung nilai akhir investasi ini setelah 10 tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27004\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelcomp1.jpg\" alt=\"Rumus Excel Bunga Majemuk Bulanan\" width=\"544\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Investasi ini akan bernilai <strong>$9,096,98<\/strong> setelah 10 tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung investasi akhir setiap tahun selama periode 10 tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kolom F menunjukkan rumus yang kita gunakan di setiap sel terkait di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27005 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelcomp2.jpg\" alt=\"\" width=\"668\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pada akhir tahun pertama, investasi bernilai <strong>$5,308.39<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pada akhir tahun kedua, investasi bernilai <strong>$5,635.80<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pada akhir tahun ketiga, investasi bernilai <strong>$5,983.40<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan pada akhir tahun kesepuluh, investasi tersebut bernilai <strong>$9,096.98<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memvisualisasikan pertumbuhan investasi dari waktu ke waktu, sorot sel dalam rentang <strong>E2:E11<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik opsi <strong>Bagan Kolom 2D<\/strong> dengan grup <strong>Grafik<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-27006 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelcomp3.jpg\" alt=\"\" width=\"598\" height=\"585\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan tahun dan tinggi batang mewakili nilai investasi pada setiap akhir tahun.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> Cara menemukan antilog nilai di Excel<br \/> <a href=\"https:\/\/statorials.org\/id\/menyelesaikan-sistem-persamaan-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menyelesaikan sistem persamaan di excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita dapat menggunakan rumus berikut untuk mencari nilai akhir suatu investasi setelah waktu tertentu: SEBUAH = P(1 + r\/n) tidak Emas: J: Jumlah akhir P: Inisial utama r: tingkat bunga tahunan n : Jumlah periode komposisi per tahun t: Jumlah tahun Jika investasi dimajemukkan setiap bulan , maka kita dapat menggunakan 12 untuk n : [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T20:07:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelcomp1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/\",\"url\":\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/\",\"name\":\"Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T20:07:43+00:00\",\"dateModified\":\"2023-07-18T20:07:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung bunga majemuk bulanan di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.","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:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/","og_site_name":"Statorials","article_published_time":"2023-07-18T20:07:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelcomp1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/","url":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/","name":"Cara Menghitung Bunga Majemuk Bulanan di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T20:07:43+00:00","dateModified":"2023-07-18T20:07:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus bunga majemuk bulanan di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bunga-majemuk-excel-setiap-bulan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung bunga majemuk bulanan di excel"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3179"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3179"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3179\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}