Formula Excel PRICEMAT
keuangan
The PRICEMAT function in Excel calculates the price per $100 face value of a security that matures on a specified date.
It is commonly used in financial analysis for pricing securities with maturity dates.
Formula dasar PRICEMAT
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Hasil/Output penggunaan rumus PRICEMAT
Hasilnya berupa angka yakni: Price per $100 face value
Penjelasan dari contoh rumus PRICEMAT
- The PRICEMAT function requires various arguments such as settlement date, maturity date, issue date, annual interest rate, annual yield, and optional basis parameter.
- It calculates the price per $100 face value of a security that matures on a specified date.
Kesimpulan
PRICEMAT is commonly used in financial analysis for pricing bonds and other securities with specified maturity dates.