+ Reply to Thread
Results 1 to 5 of 5

Future Value (FV)

  1. #1
    tikchye_oldLearner57
    Guest

    Future Value (FV)

    hello community

    can someone kindly explain to me why my FV is in negative form ?

    example:

    interest rate = 2.60%
    No of years = 6
    Annual investment = 20000 (fixed amount)

    when i used the FV(), my answer is in (128,075.73) - red ?

    thanks for the explanation
    --
    oldLearner57

  2. #2
    Bernard Liengme
    Guest

    Re: Future Value (FV)

    All Excel financial function use the same convention: money either flows in
    or out; out flow is considered negative. Thus if you use PMT to compute a
    loan payment and make the loan amount positive, PMT will be negative because
    the loan came in to you while the payments go out from you. The same formula
    with a negative pv value (a deposit in an annuity) will give positive
    payments (money paid by bank to you).
    To get a positive FV in your case make the investment negative (it flows
    from you) or simply use =-FV(parms)
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "tikchye_oldLearner57" <[email protected]> wrote
    in message news:[email protected]...
    > hello community
    >
    > can someone kindly explain to me why my FV is in negative form ?
    >
    > example:
    >
    > interest rate = 2.60%
    > No of years = 6
    > Annual investment = 20000 (fixed amount)
    >
    > when i used the FV(), my answer is in (128,075.73) - red ?
    >
    > thanks for the explanation
    > --
    > oldLearner57




  3. #3
    Michael
    Guest

    RE: Future Value (FV)

    Hi tikchye. If you make your $20,000 annual investment negative (it is an
    outflow and should be negative) your Future Value will then be positive. HTH
    --
    Sincerely, Michael Colvin


    "tikchye_oldLearner57" wrote:

    > hello community
    >
    > can someone kindly explain to me why my FV is in negative form ?
    >
    > example:
    >
    > interest rate = 2.60%
    > No of years = 6
    > Annual investment = 20000 (fixed amount)
    >
    > when i used the FV(), my answer is in (128,075.73) - red ?
    >
    > thanks for the explanation
    > --
    > oldLearner57


  4. #4
    Bondi
    Guest

    Re: Future Value (FV)


    tikchye_oldLearner57 wrote:
    > hello community
    >
    > can someone kindly explain to me why my FV is in negative form ?
    >
    > example:
    >
    > interest rate = 2.60%
    > No of years = 6
    > Annual investment = 20000 (fixed amount)
    >
    > when i used the FV(), my answer is in (128,075.73) - red ?
    >
    > thanks for the explanation
    > --
    > oldLearner57


    Hi,

    I belive that your payments to the investment should be negative.

    >From Help:

    For all the arguments, cash you pay out, such as deposits to savings,
    is represented by negative numbers; cash you receive, such as dividend
    checks, is represented by positive numbers.


    Regards,
    Bondi


  5. #5
    tikchye_oldLearner57
    Guest

    Re: Future Value (FV)

    thanks to Michael / Bernard Liengme / Bondi > now I understand

    best regards
    thanks community
    --
    oldLearner57


    "Bondi" wrote:

    >
    > tikchye_oldLearner57 wrote:
    > > hello community
    > >
    > > can someone kindly explain to me why my FV is in negative form ?
    > >
    > > example:
    > >
    > > interest rate = 2.60%
    > > No of years = 6
    > > Annual investment = 20000 (fixed amount)
    > >
    > > when i used the FV(), my answer is in (128,075.73) - red ?
    > >
    > > thanks for the explanation
    > > --
    > > oldLearner57

    >
    > Hi,
    >
    > I belive that your payments to the investment should be negative.
    >
    > >From Help:

    > For all the arguments, cash you pay out, such as deposits to savings,
    > is represented by negative numbers; cash you receive, such as dividend
    > checks, is represented by positive numbers.
    >
    >
    > Regards,
    > Bondi
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1