{"id":2310,"date":"2023-07-22T20:11:00","date_gmt":"2023-07-22T20:11:00","guid":{"rendered":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/"},"modified":"2023-07-22T20:11:00","modified_gmt":"2023-07-22T20:11:00","slug":"kepentingan-majemuk-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/","title":{"rendered":"Cara menghitung bunga majemuk di google sheets (3 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita dapat menggunakan rumus bunga majemuk berikut untuk mencari nilai akhir suatu investasi setelah jangka 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;\">Contoh berikut menunjukkan cara menggunakan rumus ini di Google Spreadsheet untuk menghitung nilai akhir investasi dalam berbagai skenario.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Rumus bunga majemuk dengan bunga majemuk tahunan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita menginvestasikan $5.000 dalam investasi yang bunganya bertambah 6% per tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus bunga majemuk di Google Spreadsheet untuk menghitung nilai akhir investasi ini setelah 10 tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21004 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees1.png\" alt=\"\" width=\"557\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Investasi ini akan bernilai <strong>$8,954.24<\/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;\">Perhatikan bahwa kolom F memperlihatkan rumus yang kita gunakan di setiap sel terkait di kolom E:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21006\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees2-1.png\" alt=\"Rumus Bunga Majemuk di Google Spreadsheet\" width=\"679\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Rumus bunga majemuk dengan bunga majemuk bulanan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita menginvestasikan $1.000 dalam investasi yang memiliki tingkat kapitalisasi 6% per tahun dan digabungkan setiap bulan (12 kali per tahun).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus bunga majemuk di Google Spreadsheet untuk menghitung nilai akhir investasi ini setelah 5 tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21008 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees3.png\" alt=\"\" width=\"552\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Investasi ini akan bernilai <strong>$1,348.85<\/strong> setelah 5 tahun.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Rumus Bunga Majemuk dengan Bunga Majemuk Harian<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita menginvestasikan $5.000 dalam investasi yang memiliki tingkat batas 8% per tahun dan digabungkan setiap hari (365 kali per tahun).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus bunga majemuk di Google Spreadsheet untuk menghitung nilai akhir investasi ini setelah 15 tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21009 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees4.png\" alt=\"\" width=\"549\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Investasi ini akan bernilai <strong>$16,598.39<\/strong> setelah 15 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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlahkan-di-beberapa-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menambahkan beberapa lembar di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menggabungkan-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara Menggabungkan Kolom di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-membandingkan-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana membandingkan dua kolom di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita dapat menggunakan rumus bunga majemuk berikut untuk mencari nilai akhir suatu investasi setelah jangka 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 Contoh berikut menunjukkan cara menggunakan rumus ini di Google Spreadsheet untuk [&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 di Google Sheets (3 Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.\" \/>\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\/kepentingan-majemuk-google-sheet\/\" \/>\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 di Google Sheets (3 Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:11:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees1.png\" \/>\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\/kepentingan-majemuk-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/\",\"name\":\"Cara Menghitung Bunga Majemuk di Google Sheets (3 Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:11:00+00:00\",\"dateModified\":\"2023-07-22T20:11:00+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung bunga majemuk di google sheets (3 contoh)\"}]},{\"@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 di Google Sheets (3 Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.","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\/kepentingan-majemuk-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Bunga Majemuk di Google Sheets (3 Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:11:00+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-composees1.png"}],"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\/kepentingan-majemuk-google-sheet\/","url":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/","name":"Cara Menghitung Bunga Majemuk di Google Sheets (3 Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:11:00+00:00","dateModified":"2023-07-22T20:11:00+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung bunga majemuk di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kepentingan-majemuk-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung bunga majemuk di google sheets (3 contoh)"}]},{"@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\/2310"}],"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=2310"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2310\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}