PHPOffice / PhpSpreadsheet

     *

     * @return float

     */

    public static function PRICEDISC($settlement, $maturity, $discount, $redemption, $basis = 0)

    {

        $settlement = Functions::flattenSingleValue($settlement);

        $maturity = Functions::flattenSingleValue($maturity);

        $discount = (float) Functions::flattenSingleValue($discount);

        $redemption = (float) Functions::flattenSingleValue($redemption);

        $basis = (int) Functions::flattenSingleValue($basis);

        //    Validate

        if ((is_numeric($discount)) && (is_numeric($redemption)) && (is_numeric($basis))) {

            if (($discount <= 0) || ($redemption <= 0)) {

                return Functions::NAN();

            }

            $daysBetweenSettlementAndMaturity = DateTime::YEARFRAC($settlement, $maturity, $basis);

            if (!is_numeric($daysBetweenSettlementAndMaturity)) {

                //    return date error

                return $daysBetweenSettlementAndMaturity;

            }

            return $redemption * (1 - $discount * $daysBetweenSettlementAndMaturity);

        }

        return Functions::VALUE();

    }

    /**

     * PRICEMAT.

     *

     * @return float

     */

    public static function RECEIVED($settlement, $maturity, $investment, $discount, $basis = 0)

    {

        $settlement = Functions::flattenSingleValue($settlement);

        $maturity = Functions::flattenSingleValue($maturity);

        $investment = (float) Functions::flattenSingleValue($investment);

        $discount = (float) Functions::flattenSingleValue($discount);

        $basis = (int) Functions::flattenSingleValue($basis);

        //    Validate

        if ((is_numeric($investment)) && (is_numeric($discount)) && (is_numeric($basis))) {

            if (($investment <= 0) || ($discount <= 0)) {

                return Functions::NAN();

            }

            $daysBetweenSettlementAndMaturity = DateTime::YEARFRAC($settlement, $maturity, $basis);

            if (!is_numeric($daysBetweenSettlementAndMaturity)) {

                //    return date error

                return $daysBetweenSettlementAndMaturity;

            }

            return $investment / (1 - ($discount * $daysBetweenSettlementAndMaturity));

        }

        return Functions::VALUE();

    }

    /**

     * SLN.