Forum Discussion
Present Value using the PMT Function
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 P...
There are other functions that solve for different unknowns. It may be that
= PV( rate, nper, -pmnt)
is more relevant.
PeterBartholomew1 that's a good idea. Unfortunately, I don't know also the pmnt of the property. Since that's also linked to the property's price. I've thought of looking at the basic mortgage calculation formula. and extrapolate the price of the property from there. I have the property's cash flow and all other running costs. And I have the rent (which is the income). The variable is the property's price.