Need Excel sheet-calc compounded future value of quarterly flows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Looking for a spreadsheet that will allow me to calculate a series of
quarterly cash flows compounding at a fixed rate
 
golfnut said:
Looking for a spreadsheet that will allow me to calculate a
series of quarterly cash flows compounding at a fixed rate
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I import text file of cash flow to excel file then use formula 1
Calculating Future Value 6
how calculate a loan amount with quarterly compounded interest 1
Re: XIRR versus IRR 1
calculation of future value between two dates 2
Calculating Compounded Growth & the XIRR Function 4
annuity calculation for monthly payments but quarterly compoundin 5
Loan Schedule - Specific Requirements 1

Back
Top