PV function calculation

[mse330]

Hi all,

Can someone help give me a formula that would imitate the PV function of excel. For example, if I use the below formula, then I would get an answer of $10,000

=PV(5%/12,60,188.72)

What I need is a formula that would give the same answer without using excel's built-in PV function

Thank you

 

[Eric W]

The formula they use is here:

https://support.office.com/en-us/article/pv-function-23879d31-0e02-4321-be01-da16e8168cbd

With a little algebra, you get:

Book1
	A	B	C	D	E	F
1	($10,000.41)	0.41667%	60	188.72	0	0
2
3	-10000.4061
Sheet1

Cell Formulas
Range	Formula
A1	=PV(B1,C1,D1,E1,F1)
A3	=-(D1*(1+B1*F1)*((B1+1)^C1-1)/B1+E1)/(B1+1)^C1
B1	=5%/12

 

[MickG]

Similar idea !!

=188.72/((1.004167^61)-(1.004167^60))*((1.004167^60)-1)

NB:- 1.004167 = 0.05/12+1

 

[mse330]

Excellent ! Thank you both, really appreciated ​

 

[Eric W]

Glad we could help!

 

[MickG]

You're welcome