Cash Flows – Value from a Yield
Last updated 9 November 2026
Function reference › Bonds › Valuation from Cash Flows
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_Bonds_ValueFromyieldandCF
GIA_Bonds_ValueFromyieldandCF(Principal_cashFlow_Dates, Principal_cashFlow_Values, Yield, SDate, Comp, Days, Interp)| Argument | Use | Description |
|---|---|---|
Principal_cashFlow_Dates | Required | . |
Principal_cashFlow_Values | Required | . |
Yield | Required | The flat discounting interest rate. |
SDate | Required | The settlement date. |
Comp | Required | The compounding basis of the interest rate (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |