+ Reply to Thread
Results 1 to 2 of 2

Need Excel sheet-calc compounded future value of quarterly flows

  1. #1
    golfnut
    Guest

    Need Excel sheet-calc compounded future value of quarterly flows

    Looking for a spreadsheet that will allow me to calculate a series of
    quarterly cash flows compounding at a fixed rate

  2. #2

    RE: Need Excel sheet-calc compounded future value of quarterly flows

    "golfnut" wrote:
    > Looking for a spreadsheet that will allow me to calculate a
    > series of quarterly cash flows compounding at a fixed rate


    If the quarterly cash flows are equal and if the fixed rate is
    the nominal rate (not the APR), the answer is simple:

    =FV(rate/4,4*years,-cashFlow,,1)

    (Or replace "4*years" with the number of quarters.)

    If the quarterly cash flows are unequal or if the fixed rate
    is an APR, please be more specific.

+ 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