In Excel, version 2019, how do I find the present value of a tenant's lease rent? The rent amount changes each year (for that whole year, 12 payments). The lease is for 5 years. Example the first year 2023, 12 months, the rent every month, due at the beginning of the month, is $1,200. Then in 2024, the rent due at the beginning of the month is $1,260 for 12 months.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
PV of Lease Rents
- Thread starter ypodber
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,764
- Office Version
- 365
- Platform
- Windows
Duplicate to: PV of Lease Rents
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
Upvote
0
- Status
Similar threads
- Question
- Question
