Future Value Formula

  • Thread starter Thread starter DENNIS VAN DER MAATEN
  • Start date Start date
D

DENNIS VAN DER MAATEN

I dont have excel anymore. However, I works. Does anyone
know the formual in works for FV of money? For excel it
is:FV(rate,nper,pmt.pv,type) but this does not work in
works spreadsheet. PLEASE HELP
DENNIS
 
Dennis,

fv=d*(((1+i/p)^(n*p)-1)/(i/p)

Where:
i=interest rate (expressed as %)
n=number of years
p=cash flows per year
d=cash flow ($ amount per period)

Don
 
If PMT is 0, the formula simplifies to:

FV = PV * (1+i)^n

--
Regards,
Fred
Please reply to newsgroup, not e-mail


Bernard Liengme said:
Hi Dennis
From the www.microsoft.com site I found a file listing all financial
functions. And this tells me that the functions all use this formula (which
might not show in the newsgrroup)


Rearrange this to get FV = -PV(1+rate)^nper - pmt[1+RATE(TYPE)][
((1+RATE)^NPER -1 )/rate]
This could be write as a formula in a Works spreadsheet cell.
Bernard

DENNIS VAN DER MAATEN said:
I dont have excel anymore. However, I works. Does anyone
know the formual in works for FV of money? For excel it
is:FV(rate,nper,pmt.pv,type) but this does not work in
works spreadsheet. PLEASE HELP
DENNIS
Click to expand...
Click to expand...
 
Hi Dennis,

The full formula is:
fv=-if(rate=0,pmt*nper+pv,(pv*((1+rate)^nper)+pmt*(1+rate*type)*((1+rate)^np
er-1)/rate))
where:
· fv is the future value
· pv is the present value
· rate is the interest rate per period
· nper is the total number of payment periods
· pmt is the fixed instalment paid in each period
· type is the number 0 or 1 and indicates when instalments are paid. 0
indicates payments are made at the end of the period, 1 indicates payments
are made at the start of the period
This works exactly the same as in Excel.

Cheers
 
Back
Top