{"id":2696,"date":"2023-07-21T03:21:16","date_gmt":"2023-07-21T03:21:16","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/"},"modified":"2023-07-21T03:21:16","modified_gmt":"2023-07-21T03:21:16","slug":"excel-bunga-menulis-setiap-hari","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/","title":{"rendered":"Cara menghitung bunga majemuk harian 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 bertambah <strong>setiap hari<\/strong> , maka kita dapat menggunakan 365 untuk <em>n<\/em> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>A = P(1 + r\/365) <sup>365t<\/sup><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan rumus ini di Excel untuk menghitung nilai akhir investasi yang dimajemukkan setiap hari.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Rumus Bunga Majemuk Harian di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita menginvestasikan $5.000 dalam investasi yang bunganya bertambah 6% per tahun. Asumsikan investasi majemuk setiap hari.<\/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=\" wp-image-23745 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quotidiennementcompose1.jpg\" alt=\"\" width=\"499\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Investasi ini akan bernilai <strong>$9,110.14<\/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-23746 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quotidiencompose2.jpg\" alt=\"\" width=\"677\" height=\"386\" 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,309.16<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pada akhir tahun kedua, investasi bernilai <strong>$5,637.43<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pada akhir tahun ketiga, investasi bernilai <strong>$5,986.00<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan pada akhir tahun kesepuluh, investasi tersebut bernilai <strong>$9,110.14<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memvisualisasikan pertumbuhan investasi dari waktu ke waktu, cukup 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-23747 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quotidiencompose3.jpg\" alt=\"\" width=\"615\" height=\"633\" 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 bertambah setiap hari , maka kita dapat menggunakan 365 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 Harian di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.\" \/>\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\/excel-bunga-menulis-setiap-hari\/\" \/>\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 Harian di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T03:21:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quotidiennementcompose1.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\/excel-bunga-menulis-setiap-hari\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/\",\"name\":\"Cara Menghitung Bunga Majemuk Harian di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T03:21:16+00:00\",\"dateModified\":\"2023-07-21T03:21:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung bunga majemuk harian 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 Harian di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.","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\/excel-bunga-menulis-setiap-hari\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Bunga Majemuk Harian di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/","og_site_name":"Statorials","article_published_time":"2023-07-21T03:21:16+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/quotidiennementcompose1.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\/excel-bunga-menulis-setiap-hari\/","url":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/","name":"Cara Menghitung Bunga Majemuk Harian di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T03:21:16+00:00","dateModified":"2023-07-21T03:21:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung bunga majemuk harian di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-bunga-menulis-setiap-hari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung bunga majemuk harian 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\/2696"}],"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=2696"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2696\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}