FVSCHEDULE INTRATE

G_DURATION

G_DURATION —

Synopsis

G_DURATION(rate,pv,fv)

Description

G_DURATION calculates number of periods needed for an investment to attain a desired value. This function is similar to FV and PV with a difference that we do not need give the direction of cash flows e.g. -100 for a cash outflow and +100 for a cash inflow.

  • If rate <= 0, G_DURATION returns #DIV0 error.
  • If fv = 0 or pv = 0, G_DURATION returns #DIV0 error.
  • If fv / pv < 0, G_DURATION returns #VALUE error.

Examples

See also

PPMT, PV, FV, DURATION, MDURATION.

FVSCHEDULE INTRATE