Formula Excel PDURATION
keuangan
The PDURATION function in Excel calculates the duration of an investment with periodic interest payments.
It is useful for determining the duration of bonds and other fixed-income securities.
Formula dasar PDURATION
=PDURATION(rate, pv, fv, [type])
Hasil/Output penggunaan rumus PDURATION
Hasilnya berupa angka yakni: Duration of the investment
Penjelasan dari contoh rumus PDURATION
- The PDURATION function requires the interest rate per period, present value, future value, and optional type parameter.
- It calculates the duration of the investment with periodic interest payments.
Kesimpulan
PDURATION is commonly used in finance for assessing the risk and sensitivity of fixed-income investments.