I am renting my apartment out, and for that I need to calculate the Net Present Value of the rental payment, after deducting the management fees (
f) and adjusted for rental increased.
- The annual rental increase is
- The annual management fees increase is
- I collect rent for
yyears, say, 10 years
- The annual inflation is
i, say, 3% (
What is the formula that I can use in Google Spreadsheet, to calculate Net Present Value of the rental payment, after deducting the management fees and adjusted for rental increased?