Financial Toolbox    
fvdisc

Future value of discounted security

Syntax

Arguments

Settle
Settlement date. Enter as serial date number or date string. Settle must be earlier than or equal to Maturity.
Maturity
Maturity date. Enter as serial date number or date string.
Price
Price (present value) of the security.
Discount
Bank discount rate of the security. Enter as decimal fraction.
Basis
(Optional) Day-count basis: 0 = actual/actual (default), 1 = 30/360, 2 = actual/360, 3 = actual/365.

Description

FutureVal = fvdisc(Settle, Maturity, Price, Discount, Basis) finds the amount received at maturity for a fully vested security.

Examples

Using this data

returns

See Also

acrudisc, discrate, prdisc, ylddisc

References

Mayle, Standard Securities Calculation Methods, Volumes I-II, 3rd edition.


  frontcon fvfix