Kalkulator Kredit<\/title>\r\n <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.18.5\/xlsx.full.min.js\"><\/script>\r\n <style>\r\n * {\r\n box-sizing: border-box;\r\n margin: 0;\r\n padding: 0;\r\n font-family: Arial, sans-serif;\r\n }\r\n\r\n body {\r\n background-color: #fff5eb;\r\n padding: 20px;\r\n }\r\n\r\n .container {\r\n max-width: 800px;\r\n margin: 0 auto;\r\n }\r\n\r\n .header {\r\n background-color: #ff8c00;\r\n color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n margin-bottom: 20px;\r\n text-align: center;\r\n }\r\n\r\n .input-form {\r\n background-color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\r\n margin-bottom: 20px;\r\n }\r\n\r\n .form-group {\r\n margin-bottom: 15px;\r\n }\r\n\r\n label {\r\n display: block;\r\n margin-bottom: 5px;\r\n color: #666;\r\n }\r\n\r\n input {\r\n width: 100%;\r\n padding: 8px;\r\n border: 1px solid #ddd;\r\n border-radius: 5px;\r\n font-size: 16px;\r\n }\r\n\r\n button {\r\n background-color: #ff8c00;\r\n color: white;\r\n padding: 10px 20px;\r\n border: none;\r\n border-radius: 5px;\r\n cursor: pointer;\r\n font-size: 16px;\r\n width: 100%;\r\n margin-bottom: 10px;\r\n }\r\n\r\n button:hover {\r\n background-color: #ff7300;\r\n }\r\n\r\n .results {\r\n background-color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\r\n margin-top: 20px;\r\n }\r\n\r\n table {\r\n width: 100%;\r\n border-collapse: collapse;\r\n margin-top: 20px;\r\n }\r\n\r\n th, td {\r\n padding: 10px;\r\n text-align: left;\r\n border-bottom: 1px solid #ddd;\r\n }\r\n\r\n th {\r\n background-color: #ff8c00;\r\n color: white;\r\n }\r\n\r\n .summary {\r\n margin-top: 20px;\r\n padding: 15px;\r\n background-color: #fff3e6;\r\n border-radius: 5px;\r\n }\r\n\r\n @media (max-width: 600px) {\r\n .container {\r\n padding: 10px;\r\n }\r\n \r\n th, td {\r\n font-size: 14px;\r\n padding: 8px;\r\n }\r\n }\r\n <\/style>\r\n<\/head>\r\n<body>\r\n <div class=\"container\">\r\n <div class=\"header\">\r\n <h1>Kalkulator Kredit<\/h1>\r\n <\/div>\r\n\r\n <div class=\"input-form\">\r\n <div class=\"form-group\">\r\n <label>Total Pinjaman (Rp)<\/label>\r\n <input type=\"number\" id=\"loanAmount\" placeholder=\"Masukkan jumlah pinjaman\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Uang Muka\/DP (Rp)<\/label>\r\n <input type=\"number\" id=\"downPayment\" placeholder=\"Masukkan jumlah DP\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Bunga per Tahun (%)<\/label>\r\n <input type=\"number\" id=\"interestRate\" placeholder=\"Masukkan bunga per tahun\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Tenor (Bulan)<\/label>\r\n <input type=\"number\" id=\"tenure\" placeholder=\"Masukkan jangka waktu\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Biaya Admin (Rp)<\/label>\r\n <input type=\"number\" id=\"adminFee\" placeholder=\"Masukkan biaya admin\">\r\n <\/div>\r\n <button onclick=\"calculateLoan()\">Hitung<\/button>\r\n <button onclick=\"exportToExcel()\">Export ke Excel<\/button>\r\n <\/div>\r\n\r\n <div class=\"results\" id=\"results\">\r\n <h2>Hasil Perhitungan<\/h2>\r\n <div class=\"summary\" id=\"summary\"><\/div>\r\n <div style=\"overflow-x: auto;\">\r\n <table id=\"paymentSchedule\">\r\n <thead>\r\n <tr>\r\n <th>Bulan<\/th>\r\n <th>Angsuran<\/th>\r\n <th>Pokok<\/th>\r\n <th>Bunga<\/th>\r\n <th>Sisa Pinjaman<\/th>\r\n <\/tr>\r\n <\/thead>\r\n <tbody><\/tbody>\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n\r\n <script>\r\n let paymentData = [];\r\n\r\n function calculateLoan() {\r\n const loanAmount = parseFloat(document.getElementById('loanAmount').value);\r\n const downPayment = parseFloat(document.getElementById('downPayment').value);\r\n const annualInterest = parseFloat(document.getElementById('interestRate').value);\r\n const tenure = parseInt(document.getElementById('tenure').value);\r\n const adminFee = parseFloat(document.getElementById('adminFee').value);\r\n\r\n const principalLoan = loanAmount - downPayment;\r\n const monthlyInterest = annualInterest \/ 12 \/ 100;\r\n const monthlyPayment = principalLoan * monthlyInterest * Math.pow(1 + monthlyInterest, tenure) \/ \r\n (Math.pow(1 + monthlyInterest, tenure) - 1);\r\n\r\n let remainingLoan = principalLoan;\r\n paymentData = [];\r\n\r\n for (let month = 1; month <= tenure; month++) {\r\n const interestPayment = remainingLoan * monthlyInterest;\r\n const principalPayment = monthlyPayment - interestPayment;\r\n remainingLoan -= principalPayment;\r\n\r\n paymentData.push({\r\n month: month,\r\n payment: monthlyPayment,\r\n principal: principalPayment,\r\n interest: interestPayment,\r\n remainingLoan: remainingLoan > 0 ? remainingLoan : 0\r\n });\r\n }\r\n\r\n const totalPayment = monthlyPayment * tenure;\r\n const totalInterest = totalPayment - principalLoan;\r\n const companyProfit = totalInterest + adminFee;\r\n\r\n displayResults(paymentData, {\r\n monthlyPayment,\r\n totalPayment,\r\n totalInterest,\r\n companyProfit,\r\n adminFee\r\n });\r\n }\r\n\r\n function displayResults(data, summary) {\r\n const tbody = document.querySelector('#paymentSchedule tbody');\r\n tbody.innerHTML = '';\r\n\r\n data.forEach(row => {\r\n const tr = document.createElement('tr');\r\n tr.innerHTML = `\r\n <td>${row.month}<\/td>\r\n <td>${formatCurrency(row.payment)}<\/td>\r\n <td>${formatCurrency(row.principal)}<\/td>\r\n <td>${formatCurrency(row.interest)}<\/td>\r\n <td>${formatCurrency(row.remainingLoan)}<\/td>\r\n `;\r\n tbody.appendChild(tr);\r\n });\r\n\r\n const summaryDiv = document.getElementById('summary');\r\n summaryDiv.innerHTML = `\r\n <h3>Ringkasan:<\/h3>\r\n <p>Angsuran per Bulan: ${formatCurrency(summary.monthlyPayment)}<\/p>\r\n <p>Total Pembayaran: ${formatCurrency(summary.totalPayment)}<\/p>\r\n <p>Total Bunga: ${formatCurrency(summary.totalInterest)}<\/p>\r\n <p>Biaya Admin: ${formatCurrency(summary.adminFee)}<\/p>\r\n <p>Keuntungan Perusahaan: ${formatCurrency(summary.companyProfit)}<\/p>\r\n `;\r\n }\r\n\r\n function formatCurrency(value) {\r\n return new Intl.NumberFormat('id-ID', {\r\n style: 'currency',\r\n currency: 'IDR'\r\n }).format(value);\r\n }\r\n\r\n function exportToExcel() {\r\n if (paymentData.length === 0) {\r\n alert('Harap hitung kredit terlebih dahulu!');\r\n return;\r\n }\r\n\r\n const ws = XLSX.utils.json_to_sheet(paymentData.map(row => ({\r\n 'Bulan': row.month,\r\n 'Angsuran': row.payment,\r\n 'Pokok': row.principal,\r\n 'Bunga': row.interest,\r\n 'Sisa Pinjaman': row.remainingLoan\r\n })));\r\n\r\n const wb = XLSX.utils.book_new();\r\n XLSX.utils.book_append_sheet(wb, ws, 'Jadwal Pembayaran');\r\n\r\n XLSX.writeFile(wb, 'jadwal_pembayaran_kredit.xlsx');\r\n }\r\n <\/script>\r\n<\/body>\r\n<\/html>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1cdd47d e-flex e-con-boxed e-con e-parent\" data-id=\"1cdd47d\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-42e3814 elementor-widget elementor-widget-text-editor\" data-id=\"42e3814\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>@Copyright | Design by – <a href=\"https:\/\/wa.me\/628990004999\">IT Lampung<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Kalkulator Kredit Kalkulator Kredit Total Pinjaman (Rp) Uang Muka\/DP (Rp) Bunga per Tahun (%) Tenor (Bulan) Biaya Admin (Rp) Hitung Export ke Excel Hasil Perhitungan Bulan Angsuran Pokok Bunga Sisa Pinjaman @Copyright | Design by – IT Lampung<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_canvas","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513"}],"collection":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":7,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513\/revisions\/523"}],"wp:attachment":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/media?parent=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

\n\t\t\t\t

\n\t\t\t\t\t

\n\t\t\t\t

\n\t\t\t\r\n\r\n\r\n \r\n \r\n Kalkulator Kredit<\/title>\r\n <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.18.5\/xlsx.full.min.js\"><\/script>\r\n <style>\r\n * {\r\n box-sizing: border-box;\r\n margin: 0;\r\n padding: 0;\r\n font-family: Arial, sans-serif;\r\n }\r\n\r\n body {\r\n background-color: #fff5eb;\r\n padding: 20px;\r\n }\r\n\r\n .container {\r\n max-width: 800px;\r\n margin: 0 auto;\r\n }\r\n\r\n .header {\r\n background-color: #ff8c00;\r\n color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n margin-bottom: 20px;\r\n text-align: center;\r\n }\r\n\r\n .input-form {\r\n background-color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\r\n margin-bottom: 20px;\r\n }\r\n\r\n .form-group {\r\n margin-bottom: 15px;\r\n }\r\n\r\n label {\r\n display: block;\r\n margin-bottom: 5px;\r\n color: #666;\r\n }\r\n\r\n input {\r\n width: 100%;\r\n padding: 8px;\r\n border: 1px solid #ddd;\r\n border-radius: 5px;\r\n font-size: 16px;\r\n }\r\n\r\n button {\r\n background-color: #ff8c00;\r\n color: white;\r\n padding: 10px 20px;\r\n border: none;\r\n border-radius: 5px;\r\n cursor: pointer;\r\n font-size: 16px;\r\n width: 100%;\r\n margin-bottom: 10px;\r\n }\r\n\r\n button:hover {\r\n background-color: #ff7300;\r\n }\r\n\r\n .results {\r\n background-color: white;\r\n padding: 20px;\r\n border-radius: 10px;\r\n box-shadow: 0 2px 5px rgba(0,0,0,0.1);\r\n margin-top: 20px;\r\n }\r\n\r\n table {\r\n width: 100%;\r\n border-collapse: collapse;\r\n margin-top: 20px;\r\n }\r\n\r\n th, td {\r\n padding: 10px;\r\n text-align: left;\r\n border-bottom: 1px solid #ddd;\r\n }\r\n\r\n th {\r\n background-color: #ff8c00;\r\n color: white;\r\n }\r\n\r\n .summary {\r\n margin-top: 20px;\r\n padding: 15px;\r\n background-color: #fff3e6;\r\n border-radius: 5px;\r\n }\r\n\r\n @media (max-width: 600px) {\r\n .container {\r\n padding: 10px;\r\n }\r\n \r\n th, td {\r\n font-size: 14px;\r\n padding: 8px;\r\n }\r\n }\r\n <\/style>\r\n<\/head>\r\n<body>\r\n <div class=\"container\">\r\n <div class=\"header\">\r\n <h1>Kalkulator Kredit<\/h1>\r\n <\/div>\r\n\r\n <div class=\"input-form\">\r\n <div class=\"form-group\">\r\n <label>Total Pinjaman (Rp)<\/label>\r\n <input type=\"number\" id=\"loanAmount\" placeholder=\"Masukkan jumlah pinjaman\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Uang Muka\/DP (Rp)<\/label>\r\n <input type=\"number\" id=\"downPayment\" placeholder=\"Masukkan jumlah DP\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Bunga per Tahun (%)<\/label>\r\n <input type=\"number\" id=\"interestRate\" placeholder=\"Masukkan bunga per tahun\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Tenor (Bulan)<\/label>\r\n <input type=\"number\" id=\"tenure\" placeholder=\"Masukkan jangka waktu\">\r\n <\/div>\r\n <div class=\"form-group\">\r\n <label>Biaya Admin (Rp)<\/label>\r\n <input type=\"number\" id=\"adminFee\" placeholder=\"Masukkan biaya admin\">\r\n <\/div>\r\n <button onclick=\"calculateLoan()\">Hitung<\/button>\r\n <button onclick=\"exportToExcel()\">Export ke Excel<\/button>\r\n <\/div>\r\n\r\n <div class=\"results\" id=\"results\">\r\n <h2>Hasil Perhitungan<\/h2>\r\n <div class=\"summary\" id=\"summary\"><\/div>\r\n <div style=\"overflow-x: auto;\">\r\n <table id=\"paymentSchedule\">\r\n <thead>\r\n <tr>\r\n <th>Bulan<\/th>\r\n <th>Angsuran<\/th>\r\n <th>Pokok<\/th>\r\n <th>Bunga<\/th>\r\n <th>Sisa Pinjaman<\/th>\r\n <\/tr>\r\n <\/thead>\r\n <tbody><\/tbody>\r\n <\/table>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n\r\n <script>\r\n let paymentData = [];\r\n\r\n function calculateLoan() {\r\n const loanAmount = parseFloat(document.getElementById('loanAmount').value);\r\n const downPayment = parseFloat(document.getElementById('downPayment').value);\r\n const annualInterest = parseFloat(document.getElementById('interestRate').value);\r\n const tenure = parseInt(document.getElementById('tenure').value);\r\n const adminFee = parseFloat(document.getElementById('adminFee').value);\r\n\r\n const principalLoan = loanAmount - downPayment;\r\n const monthlyInterest = annualInterest \/ 12 \/ 100;\r\n const monthlyPayment = principalLoan * monthlyInterest * Math.pow(1 + monthlyInterest, tenure) \/ \r\n (Math.pow(1 + monthlyInterest, tenure) - 1);\r\n\r\n let remainingLoan = principalLoan;\r\n paymentData = [];\r\n\r\n for (let month = 1; month <= tenure; month++) {\r\n const interestPayment = remainingLoan * monthlyInterest;\r\n const principalPayment = monthlyPayment - interestPayment;\r\n remainingLoan -= principalPayment;\r\n\r\n paymentData.push({\r\n month: month,\r\n payment: monthlyPayment,\r\n principal: principalPayment,\r\n interest: interestPayment,\r\n remainingLoan: remainingLoan > 0 ? remainingLoan : 0\r\n });\r\n }\r\n\r\n const totalPayment = monthlyPayment * tenure;\r\n const totalInterest = totalPayment - principalLoan;\r\n const companyProfit = totalInterest + adminFee;\r\n\r\n displayResults(paymentData, {\r\n monthlyPayment,\r\n totalPayment,\r\n totalInterest,\r\n companyProfit,\r\n adminFee\r\n });\r\n }\r\n\r\n function displayResults(data, summary) {\r\n const tbody = document.querySelector('#paymentSchedule tbody');\r\n tbody.innerHTML = '';\r\n\r\n data.forEach(row => {\r\n const tr = document.createElement('tr');\r\n tr.innerHTML = `\r\n <td>${row.month}<\/td>\r\n <td>${formatCurrency(row.payment)}<\/td>\r\n <td>${formatCurrency(row.principal)}<\/td>\r\n <td>${formatCurrency(row.interest)}<\/td>\r\n <td>${formatCurrency(row.remainingLoan)}<\/td>\r\n `;\r\n tbody.appendChild(tr);\r\n });\r\n\r\n const summaryDiv = document.getElementById('summary');\r\n summaryDiv.innerHTML = `\r\n <h3>Ringkasan:<\/h3>\r\n <p>Angsuran per Bulan: ${formatCurrency(summary.monthlyPayment)}<\/p>\r\n <p>Total Pembayaran: ${formatCurrency(summary.totalPayment)}<\/p>\r\n <p>Total Bunga: ${formatCurrency(summary.totalInterest)}<\/p>\r\n <p>Biaya Admin: ${formatCurrency(summary.adminFee)}<\/p>\r\n <p>Keuntungan Perusahaan: ${formatCurrency(summary.companyProfit)}<\/p>\r\n `;\r\n }\r\n\r\n function formatCurrency(value) {\r\n return new Intl.NumberFormat('id-ID', {\r\n style: 'currency',\r\n currency: 'IDR'\r\n }).format(value);\r\n }\r\n\r\n function exportToExcel() {\r\n if (paymentData.length === 0) {\r\n alert('Harap hitung kredit terlebih dahulu!');\r\n return;\r\n }\r\n\r\n const ws = XLSX.utils.json_to_sheet(paymentData.map(row => ({\r\n 'Bulan': row.month,\r\n 'Angsuran': row.payment,\r\n 'Pokok': row.principal,\r\n 'Bunga': row.interest,\r\n 'Sisa Pinjaman': row.remainingLoan\r\n })));\r\n\r\n const wb = XLSX.utils.book_new();\r\n XLSX.utils.book_append_sheet(wb, ws, 'Jadwal Pembayaran');\r\n\r\n XLSX.writeFile(wb, 'jadwal_pembayaran_kredit.xlsx');\r\n }\r\n <\/script>\r\n<\/body>\r\n<\/html>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1cdd47d e-flex e-con-boxed e-con e-parent\" data-id=\"1cdd47d\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-42e3814 elementor-widget elementor-widget-text-editor\" data-id=\"42e3814\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>@Copyright | Design by – <a href=\"https:\/\/wa.me\/628990004999\">IT Lampung<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Kalkulator Kredit Kalkulator Kredit Total Pinjaman (Rp) Uang Muka\/DP (Rp) Bunga per Tahun (%) Tenor (Bulan) Biaya Admin (Rp) Hitung Export ke Excel Hasil Perhitungan Bulan Angsuran Pokok Bunga Sisa Pinjaman @Copyright | Design by – IT Lampung<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_canvas","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513"}],"collection":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":7,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/pages\/513\/revisions\/523"}],"wp:attachment":[{"href":"https:\/\/bg.pendampingusaha.com\/animasi\/wp-json\/wp\/v2\/media?parent=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}