Calculating Capital Recovery Factor

[mcdonald60]

I am attempting to calculate CRF from the inputs of Interest Rate(B4) and Number of Annuities(B5). This should be doable in excel, but I am struggling. I tried simply having a cell with the formula

=(B4(1+B4)^B5)/((1+B4)^B5)-1

and I get a Value error.

Is there possibly a function for calculating CRF?

 

[joeu2004]

According to a Google search, that formula should be:

=B4*(1+B4)^B5 / ((1+B4)^B5 - 1)

 

[tobiasP]

CRF =1/PVAF

PVAF (Present Value Annuity Factor) on Excel is equal to -PV(rate,nper,1,,0)

So your CRF =1/(-PV(rate,nper,1,,0))