Formula Excel PPMT
keuangan
The PPMT function in Excel calculates the principal payment for a specific period in an investment.
It is commonly used in financial analysis for loan amortization.
Formula dasar PPMT
=PPMT(rate, per, nper, pv, [fv], [type])
Hasil/Output penggunaan rumus PPMT
Hasilnya berupa angka yakni: Principal payment for the period
Penjelasan dari contoh rumus PPMT
- The PPMT function requires the interest rate per period (rate), the period for which you want to calculate the principal payment (per), the total number of payment periods (nper), the present value (pv), and optional future value (fv) and type parameters.
- It calculates the principal payment for a specific period in an investment.
Kesimpulan
PPMT is commonly used in finance for analyzing loan amortization schedules and understanding principal payments over time.