How to use the Financial Functions PRICE, PRICEDISC, PRICEMAT
In order to be able to calculate the price per $100 face value we pay for an investment, Excel provides us with 3 tools.
The functions PRICE, PRICEMAT, PRICEDISC.
In order to be able to calculate the price per $100 face value we pay for an investment, Excel provides us with 3 tools.
The functions PRICE, PRICEMAT, PRICEDISC.
It calculates the price per $100 face value of a security that pays interest at maturity.