[belajar-excel] Rumus Angsuran Pokok + Bunga dan Pemba [1 Attachment]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Rumus Angsuran Pokok + Bunga dan Pemba [1 Attachment]

Abid Kausar
Dear Suhu Excel,

Mohon pencerahaanya, saya mempunyai rumus Excel dimana rumus excel ini yang
buat orang sebelum saya :):):) , Saya kurang begitu paham bahasa manualnya
:) , rumus - rumus itu terdapat di kolom :
"Angsuran Pokok", "Angsuran Bunga", "Pembayaran Ke"...

yang saya mau tanyakan :
Apa itu "PPMT", "IPMT", dan "Ceiling", kalo diterapkan ke manual bahasanya
seperti apa?


terima kasih atas perhatian dan penjelasannya


regards
Muhabka

Rumus Excel Data Angsuran Pokok, Angsuran Bunga, Pembayaran Ke....xlsx (1M) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Rumus Angsuran Pokok + Bunga dan Pemba

hendrik karnadi
 Hai Muhabka,Coba mampir ke sini,https://leantoro.com/1479/cara-mudah-membuat-angsuran-pinjaman-di-excel-2019/

Salam,HK

    Pada Jumat, 24 Juli 2020 09.50.04 GMT+7, Abid Kausar [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Dear Suhu Excel,

Mohon pencerahaanya, saya mempunyai rumus Excel dimana rumus excel ini yang buat orang sebelum saya :):):) , Saya kurang begitu paham bahasa manualnya :) , rumus - rumus itu terdapat di kolom :
"Angsuran Pokok", "Angsuran Bunga", "Pembayaran Ke"...

yang saya mau tanyakan :
Apa itu "PPMT", "IPMT", dan "Ceiling", kalo diterapkan ke manual bahasanya seperti apa?


terima kasih atas perhatian dan penjelasannya

regardsMuhabka    
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Rumus Angsuran Pokok + Bunga dan Pemba

Sandy-2
In reply to this post by Abid Kausar
Mas,
Sepertinya datanya cukup confidential??
Sandy

    On Friday, July 24, 2020, 10:50:08 AM GMT+8, Abid Kausar [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    

Dear Suhu Excel,

Mohon pencerahaanya, saya mempunyai rumus Excel dimana rumus excel ini yang buat orang sebelum saya :):):) , Saya kurang begitu paham bahasa manualnya :) , rumus - rumus itu terdapat di kolom :
"Angsuran Pokok", "Angsuran Bunga", "Pembayaran Ke"...

yang saya mau tanyakan :
Apa itu "PPMT", "IPMT", dan "Ceiling", kalo diterapkan ke manual bahasanya seperti apa?


terima kasih atas perhatian dan penjelasannya

regardsMuhabka  #yiv0170956361 #yiv0170956361 -- #yiv0170956361ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0170956361 #yiv0170956361ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0170956361 #yiv0170956361ygrp-mkp #yiv0170956361hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0170956361 #yiv0170956361ygrp-mkp #yiv0170956361ads {margin-bottom:10px;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad {padding:0 0;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad p {margin:0;}#yiv0170956361 #yiv0170956361ygrp-mkp .yiv0170956361ad a {color:#0000ff;text-decoration:none;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ygrp-lc {font-family:Arial;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ygrp-lc #yiv0170956361hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ygrp-lc .yiv0170956361ad {margin-bottom:10px;padding:0 0;}#yiv0170956361 #yiv0170956361actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0170956361 #yiv0170956361activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0170956361 #yiv0170956361activity span {font-weight:700;}#yiv0170956361 #yiv0170956361activity span:first-child {text-transform:uppercase;}#yiv0170956361 #yiv0170956361activity span a {color:#5085b6;text-decoration:none;}#yiv0170956361 #yiv0170956361activity span span {color:#ff7900;}#yiv0170956361 #yiv0170956361activity span .yiv0170956361underline {text-decoration:underline;}#yiv0170956361 .yiv0170956361attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0170956361 .yiv0170956361attach div a {text-decoration:none;}#yiv0170956361 .yiv0170956361attach img {border:none;padding-right:5px;}#yiv0170956361 .yiv0170956361attach label {display:block;margin-bottom:5px;}#yiv0170956361 .yiv0170956361attach label a {text-decoration:none;}#yiv0170956361 blockquote {margin:0 0 0 4px;}#yiv0170956361 .yiv0170956361bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0170956361 .yiv0170956361bold a {text-decoration:none;}#yiv0170956361 dd.yiv0170956361last p a {font-family:Verdana;font-weight:700;}#yiv0170956361 dd.yiv0170956361last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0170956361 dd.yiv0170956361last p span.yiv0170956361yshortcuts {margin-right:0;}#yiv0170956361 div.yiv0170956361attach-table div div a {text-decoration:none;}#yiv0170956361 div.yiv0170956361attach-table {width:400px;}#yiv0170956361 div.yiv0170956361file-title a, #yiv0170956361 div.yiv0170956361file-title a:active, #yiv0170956361 div.yiv0170956361file-title a:hover, #yiv0170956361 div.yiv0170956361file-title a:visited {text-decoration:none;}#yiv0170956361 div.yiv0170956361photo-title a, #yiv0170956361 div.yiv0170956361photo-title a:active, #yiv0170956361 div.yiv0170956361photo-title a:hover, #yiv0170956361 div.yiv0170956361photo-title a:visited {text-decoration:none;}#yiv0170956361 div#yiv0170956361ygrp-mlmsg #yiv0170956361ygrp-msg p a span.yiv0170956361yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0170956361 .yiv0170956361green {color:#628c2a;}#yiv0170956361 .yiv0170956361MsoNormal {margin:0 0 0 0;}#yiv0170956361 o {font-size:0;}#yiv0170956361 #yiv0170956361photos div {float:left;width:72px;}#yiv0170956361 #yiv0170956361photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0170956361 #yiv0170956361photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0170956361 #yiv0170956361reco-category {font-size:77%;}#yiv0170956361 #yiv0170956361reco-desc {font-size:77%;}#yiv0170956361 .yiv0170956361replbq {margin:4px;}#yiv0170956361 #yiv0170956361ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0170956361 #yiv0170956361ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0170956361 #yiv0170956361ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0170956361 #yiv0170956361ygrp-mlmsg select, #yiv0170956361 input, #yiv0170956361 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0170956361 #yiv0170956361ygrp-mlmsg pre, #yiv0170956361 code {font:115% monospace;}#yiv0170956361 #yiv0170956361ygrp-mlmsg * {line-height:1.22em;}#yiv0170956361 #yiv0170956361ygrp-mlmsg #yiv0170956361logo {padding-bottom:10px;}#yiv0170956361 #yiv0170956361ygrp-msg p a {font-family:Verdana;}#yiv0170956361 #yiv0170956361ygrp-msg p#yiv0170956361attach-count span {color:#1E66AE;font-weight:700;}#yiv0170956361 #yiv0170956361ygrp-reco #yiv0170956361reco-head {color:#ff7900;font-weight:700;}#yiv0170956361 #yiv0170956361ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ov li a {font-size:130%;text-decoration:none;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0170956361 #yiv0170956361ygrp-sponsor #yiv0170956361ov ul {margin:0;padding:0 0 0 8px;}#yiv0170956361 #yiv0170956361ygrp-text {font-family:Georgia;}#yiv0170956361 #yiv0170956361ygrp-text p {margin:0 0 1em 0;}#yiv0170956361 #yiv0170956361ygrp-text tt {font-size:120%;}#yiv0170956361 #yiv0170956361ygrp-vital ul li:last-child {border-right:none !important;}#yiv0170956361