Forum Discussion
Present Value using the PMT Function
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.
Perhaps the starting point should not be 'what function do I need?'.
If, instead, you start by building the expenditure and cash flows period by period then that might help formulate the problem. The finance functions link the results to the assumptions more immediately but watching the effect develop over time might give more insight to help you understand the implications of the assumptions and develop your requirements.