Formula Excel PRICEDISC
keuangan
The PRICEDISC function in Excel calculates the price per $100 face value of a discounted security.
It is commonly used in financial analysis for pricing discounted bonds.
Formula dasar PRICEDISC
=PRICEDISC(settlement, maturity, discount, [redemption], [basis])
Hasil/Output penggunaan rumus PRICEDISC
Hasilnya berupa angka yakni: Price per $100 face value
Penjelasan dari contoh rumus PRICEDISC
- The PRICEDISC function requires various arguments such as settlement date, maturity date, discount rate, redemption value, and optional basis parameter.
- It calculates the price per $100 face value of a discounted security.
Kesimpulan
PRICEDISC is commonly used in financial analysis for pricing bonds that are sold at a discount.