The PRICE function in Excel calculates the price per $100 face value of a security that pays periodic interest.
It is commonly used in financial analysis for bond pricing.
Formula dasar PRICE
=PRICE(settlement, maturity, rate, yld, redemption, [frequency], [basis])Hasil/Output penggunaan rumus PRICE
Hasilnya berupa angka yakni: Price per $100 face value
Penjelasan dari contoh rumus PRICE
- The PRICE function requires various arguments such as settlement date, maturity date, annual interest rate, annual yield, redemption value, and optional frequency and basis parameters.
- It calculates the price per $100 face value of a security with periodic interest payments.
Kesimpulan
PRICE is commonly used in financial analysis for determining the fair market value of bonds and other fixed-income securities.
PRICE
The PRICE function in Excel calculates the price per $100 face value of a security that pays periodic interest.
ahliexcel.com - Keuangan