Zoho Sheet PRICEDISC Function: Discounted Prices per 100

PRICEDISC(settlement; maturity; discount; redemption_value; [basis])

settlement is the purchase date and maturity the redemption date. discount is the annual discount rate; enter 8% or 0.08 for eight percent. redemption_value is redemption per 100 currency units of face value. The quoted price uses that same per-100 scale.

The optional basis defaults to 0. Zoho documents 0 as US NASD 30/360, 1 as actual days with an actual-length year, 2 as actual days/360, 3 as actual days/365 and 4 as European 30/360. Those are distinct conventions. This guide uses explicit 3 for reproducible actual-day examples; omitting the final argument would change the requested convention.

Construct dates with DATE(year;month;day) rather than ambiguous text. The Zoho DATE reference documents that construction. The examples use semicolons as shown in Zoho’s help; the actual editor’s locale and accepted separators should be checked before importing formulas.

The official PRICEDISC reference was retrieved October 15, 2026. It documents the rolling web service but does not establish the first release or last functioning version. Both historical endpoints remain unknown, and mobile/offline parity is not certified by the web entry.

Expected numbers below are independent simple-interest or discount-model calculations from fully specified inputs, not captured native Zoho output. The source lists syntax, argument meanings, day-count options and sample results, but its embedded example input cells are not visible in the retrieved text. Those hidden datasets are not reconstructed or claimed as executed tests. The ordinary positive, forward-date examples do not resolve every boundary or coercion behavior.

Enter these parameter labels in A1:E1: Settlement, Maturity, Discount, Redemption and Basis. Put =DATE(2026;4;1) in A2, =DATE(2026;7;1) in B2, 8% in C2, 100 in D2 and 3 in E2.

In F2 enter =PRICEDISC(A2;B2;C2;D2;E2). The independent price expectation is 98.0054794521 per 100 of face value. The two dates are 91 actual days apart.

A transparent discount-model check in G2 is =D2*(1-C2*(B2-A2)/365). The annual discount fraction 0.08 is first multiplied by 91/365, then applied to redemption 100. The amount discounted is independently 1.9945205479. Price plus that discount equals the redemption value.

The price is not 98.0054794521 percent interest. Label the output as a price per 100, and reserve percentage formatting for the rate input or an explicitly calculated return.

Keep the dates, redemption 100 and basis 3 fixed. Put rates 4%, 8% and 12% in H2:H4. In I2 use =PRICEDISC($A$2;$B$2;H2;$D$2;$E$2) and fill down.

The independent prices are 99.0027397260, 98.0054794521 and 97.0082191781. Each four-percentage-point increase reduces price by 0.9972602740 for this interval. The sensitivity is linear in the discount input, provided the other inputs are unchanged.

Absolute references preserve the common dates and redemption value while the rate row changes. Without the dollar signs, filling down would move the parameter references and could silently evaluate an unrelated model.

Suppose a fictional face amount of 25000 is placed in K2. The modeled purchase amount is =K2/100*F2, independently 24501.3698630137. The redemption at maturity is 25000 when the per-100 redemption input is 100.

The total difference is independently 498.6301369863. This multiplication is appropriate for a per-100 quote; multiplying price directly by 25000 would introduce a factor-of-100 error. Fees and other settlement cash flows are not included in this simple total.

Using the unrounded F2 price, =(D2-F2)/D2*365/(B2-A2) independently returns 0.08. This is a check on the supplied annual discount rate. A denominator of F2 would instead calculate an investment-based rate and would not recover exactly eight percent.

Keep the underlying unrounded price when carrying out that check. Rounding the quote to two decimals before reversing it introduces a real numeric difference, not merely a display change. If settlement documents specify a rounding convention, model that convention separately and label it.

Changing only basis from 3 to 2 produces the independent actual/360 quote 97.9777777778. With a fixed annual discount, a larger fraction 91/360 discounts more than 91/365 and therefore lowers price.

These calculations use actual-day conventions. They do not implement all special month-end adjustments of either 30/360 method. The same calendar dates can lead to a different counted interval under those conventions.

Zoho lists #NUM! for redemption less than or equal to zero, basis outside 0–4, and settlement after maturity. The retrieved dedicated list does not supply a negative-discount rule. Do not import another product’s error table or infer unrestricted support from that omission.

The worked rates and intervals keep the modeled discount fraction below one. More extreme combinations can yield zero or negative prices in the independent arithmetic; their native handling was not established. Equal dates, fractional basis values, text coercions and edge-year behavior also remain untested.

If a total is one hundred times too large, revisit the quote scale. If price moves the wrong way in a sensitivity table, check the rate’s sign and copied references. These examples are fictional calculation controls rather than investment or trading advice.