Calculate Present Value/Property Price

[redblasko]

Hi there, I'm clearly out of my league on this one. I'm trying to calculate the total price of a property / present value (this is the variable) knowing everything else. I was thinking of using the PMT (rate, nper, pv) function but I'm stumped here. I don't know how to calculate the present value using this or any other formula when the variable is pv. I have other data related to the property IF that's necessary. What I'm trying to do is decide what's the right price knowing the rent, service charges and everything else about the property. Can you help?

 

[GraH]

Hi, I fail to see how the PMT function "The Excel PMT function is a financial function that returns the periodic payment for a loan." will help you calculating the total value of a property.

 

[redblasko]

Hi, I fail to see how the PMT function "The Excel PMT function is a financial function that returns the periodic payment for a loan." will help you calculating the total value of a property.

Me too, that's why I'm open to any other function you can suggest.

 

[AhoyNC]

What about the Present Value function PV?

The formula for present value is: